Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: VAS_SITE_VISIT
Short Name: VAS_SITE_VISIT
Status: Completed
Abstract:

This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.

Notes:

Loaded by batch 5652, 03-17-2015 18:40

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SITE_VISIT_SEQ NUMBER Primary key sequence.
100
SCHEDULED_SITE_VISIT_DATE DATE The scheduled date for site visit. It is temporary schedule.
100
ACTUAL_SITE_VISIT_DATE DATE Date of actual site visit took place by NMFS
100
USER_SEQ NUMBER CAM_USER sequence number of the inspector acctually performed the vessel inspection.
100
PORT_CODE NUMBER Location where a inspection performed. Primary key from atl_lov_port_code table.
100
SITE_VISIT_COMMENTS VARCHAR2 Additional comment on determination.
100
USER_SEQ_ASSIGNED NUMBER CAM_USER sequence number of the inspector assigned to a vessel for inspection.
100
RMD_CHANGED_BY VARCHAR2 The user who changed the record lastly.
100
RMD_TS_CHANGED TIMESTAMP(6) The date and time on which the record was changed lastly.
100
RMD_ACTION VARCHAR2 last action performed on the record. I for Insert, U for Update, R for Revert and D for Delete. Delete only recorded on history record.
100
RMD_CHANGE_COMMENT VARCHAR2 Comment for data change.
100
VESSEL_ASSESSMENT_SEQ NUMBER Vessel being inspected. Primary key sequence from vas_vessel_assessment.
100
PORT_CODE_SCHEDULED NUMBER Location where a assessment scheduled performed. Primary key from atl_lov_port_code table.
100
SITE_VISIT_STATUS_SEQ NUMBER Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS.

Attribute Details

SITE_VISIT_SEQ

CC ID: 193898
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key sequence.

General Data Type: NUMBER

SCHEDULED_SITE_VISIT_DATE

CC ID: 193901
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The scheduled date for site visit. It is temporary schedule.

General Data Type: DATE

ACTUAL_SITE_VISIT_DATE

CC ID: 193902
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of actual site visit took place by NMFS

General Data Type: DATE

USER_SEQ

CC ID: 193892
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

CAM_USER sequence number of the inspector acctually performed the vessel inspection.

General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

PORT_CODE

CC ID: 193895
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Location where a inspection performed. Primary key from atl_lov_port_code table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_PORT_CODE

SITE_VISIT_COMMENTS

CC ID: 193903
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Additional comment on determination.

General Data Type: VARCHAR2

USER_SEQ_ASSIGNED

CC ID: 193893
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

CAM_USER sequence number of the inspector assigned to a vessel for inspection.

General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

RMD_CHANGED_BY

CC ID: 193904
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The user who changed the record lastly.

General Data Type: VARCHAR2

RMD_TS_CHANGED

CC ID: 193905
Seq. Order: 9
Data Storage Type: TIMESTAMP(6)
Max Length: 11
Required: No
Primary Key: No
Scale: 6
Status: Active
Description:

The date and time on which the record was changed lastly.

General Data Type: TIMESTAMP(6)

RMD_ACTION

CC ID: 193899
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

last action performed on the record. I for Insert, U for Update, R for Revert and D for Delete. Delete only recorded on history record.

General Data Type: VARCHAR2

RMD_CHANGE_COMMENT

CC ID: 193900
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment for data change.

General Data Type: VARCHAR2

VESSEL_ASSESSMENT_SEQ

CC ID: 193897
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Vessel being inspected. Primary key sequence from vas_vessel_assessment.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_VESSEL_ASSESSMENT

PORT_CODE_SCHEDULED

CC ID: 193894
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Location where a assessment scheduled performed. Primary key from atl_lov_port_code table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_PORT_CODE

SITE_VISIT_STATUS_SEQ

CC ID: 193896
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_LOV_SITE_VISIT_STAT

Catalog Details

Catalog Item ID: 24082
GUID: gov.noaa.nmfs.inport:24082
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-03-17 18:40+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18