9618 ATLW_FMA_TRIP Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed AA FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC An FMA trip is defined as any time a vessel leaves a port-floating processor and upon completion it returns to a port-processor and completes an offload or the observer transfers off the vessel. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when an offload or observer transfer took place. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header 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 3 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip NUMBER 4 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 5 TRIP_NUMBER NUMBER 22 Yes No 4 0 Active Number which is entered by the observer identifying a unique within a cruise - vessel combination. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 6 EMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 7 DISEMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 8 BAIT_USED_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bait used record NUMBER 9 START_DATE DATE 7 Yes No Active Date of embarkation. DATE 10 START_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees. NUMBER 11 START_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 12 START_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 13 START_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 14 START_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 15 START_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 16 START_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 17 END_DATE DATE 7 No No Active Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. DATE 18 END_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees. NUMBER 19 END_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes NUMBER 20 END_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds NUMBER 21 END_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees. NUMBER 22 END_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes NUMBER 23 END_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds NUMBER 24 END_EW VARCHAR2 1 No No Active East West longitude identifier for Disembarkation. VARCHAR2 25 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 26 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 27 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 1 Yes No Active Identifies whether there were fish present in the hold at the start of a fishing trip. VARCHAR2 28 COMMENTS VARCHAR2 2000 No No Active Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. VARCHAR2 29 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:9618 Doug Turnbull 2009-06-30T16:11:08 SysAdmin InPortAdmin 2022-08-09T17:11:03 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