9657 ATL_CRUISE_VESSEL Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed The intersection of an observer cruise and a vessel Loaded by batch 2390, 06-30-2009 16:11 Theme AFSC Theme ATL Theme ATLAS Theme BYCATCH Theme FMA Theme NORPAC Theme OBSERVER Spatial AI Spatial ALEUTIAN ISLANDS Spatial BERING SEA Spatial BS Spatial BSAI Spatial GOA Spatial GULF OF ALASKA Data Table Yes NORPAC The intersection of an observer cruise and a vessel 1 CRUISE_VESSEL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_OBSERVER_CRUISE 3 VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Unique Code identifying a vessel - inherited from the NORPAC data set. Generated by logistics staff. NUMBER NORPAC.ATL_LOV_VESSEL 4 STATUS NUMBER 22 Yes No 2 0 Active This attribute is the logical foreign key from the CV_Status table owned by Norpac. It represents the current processing phase that a record is in. NUMBER NORPAC.CV_STATUS 5 STATUS_DATE DATE 7 Yes No Active Timestamp of when processing status was assigned DATE 6 STATUS_USER VARCHAR2 30 No No Active User who was logged on when the cruise vessel (cruise plant) status was assigned VARCHAR2 7 COMMENTS VARCHAR2 2000 No No Active Optional Comments Field for a cruise_vessel data set. This field is provided for use by the debriefing staff. They are not available to observers in the field for this release. VARCHAR2 8 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 gov.noaa.nmfs.inport:9657 Doug Turnbull 2009-06-30T16:11:20 SysAdmin InPortAdmin 2022-08-09T17:11:02 2018-09-26 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 2018-09-26 1 Year 2019-09-26