24082
Table: VAS_SITE_VISIT
VAS_SITE_VISIT
Entity
Published / External
24074
AFSC/FMA/Vessel Assessment Logging
Data Set
Completed
This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.
Loaded by batch 5652, 03-17-2015 18:40
Data Table
Yes
NORPAC
This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.
1
SITE_VISIT_SEQ
NUMBER
22
Yes
Yes
Active
Primary key sequence.
NUMBER
2
SCHEDULED_SITE_VISIT_DATE
DATE
7
No
No
Active
The scheduled date for site visit. It is temporary schedule.
DATE
3
ACTUAL_SITE_VISIT_DATE
DATE
7
No
No
Active
Date of actual site visit took place by NMFS
DATE
4
USER_SEQ
NUMBER
22
No
No
38
Active
CAM_USER sequence number of the inspector acctually performed the vessel inspection.
NUMBER
CUST_AUTH.CAM_USERS
5
PORT_CODE
NUMBER
22
No
No
Active
Location where a inspection performed. Primary key from atl_lov_port_code table.
NUMBER
NORPAC.ATL_LOV_PORT_CODE
6
SITE_VISIT_COMMENTS
VARCHAR2
4000
No
No
Active
Additional comment on determination.
VARCHAR2
7
USER_SEQ_ASSIGNED
NUMBER
22
No
No
Active
CAM_USER sequence number of the inspector assigned to a vessel for inspection.
NUMBER
CUST_AUTH.CAM_USERS
8
RMD_CHANGED_BY
VARCHAR2
100
No
No
Active
The user who changed the record lastly.
VARCHAR2
9
RMD_TS_CHANGED
TIMESTAMP(6)
11
No
No
6
Active
The date and time on which the record was changed lastly.
TIMESTAMP(6)
10
RMD_ACTION
VARCHAR2
2
No
No
Active
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.
VARCHAR2
11
RMD_CHANGE_COMMENT
VARCHAR2
4000
No
No
Active
Comment for data change.
VARCHAR2
12
VESSEL_ASSESSMENT_SEQ
NUMBER
22
Yes
No
38
Active
Vessel being inspected. Primary key sequence from vas_vessel_assessment.
NUMBER
NORPAC.VAS_VESSEL_ASSESSMENT
13
PORT_CODE_SCHEDULED
NUMBER
22
No
No
Active
Location where a assessment scheduled performed. Primary key from atl_lov_port_code table.
NUMBER
NORPAC.ATL_LOV_PORT_CODE
14
SITE_VISIT_STATUS_SEQ
NUMBER
22
No
No
38
Active
Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS.
NUMBER
NORPAC.VAS_LOV_SITE_VISIT_STAT
gov.noaa.nmfs.inport:24082
Julie Blair
2015-03-17T18:40:16
SysAdmin InPortAdmin
2022-08-09T17:11:11
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18