24082 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 https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-18 1 Year 2017-05-18