7509 FMA_TRIP Entity Published / External 7283 AFSC/FMA/ATLAS Remote Client Data Set Completed An 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. Loaded by batch 2204, 03-28-2008 14:09 Data Table Yes TURNBULLD An 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. 1 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip NUMBER 2 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER TURNBULLD.CRUISE_VESSEL 3 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 4 EMBARKED_PORT_CODE NUMBER 22 Yes No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER TURNBULLD.LOV_PORT_CODE 5 DISEMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER TURNBULLD.LOV_PORT_CODE 6 BAIT_USED_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bait used record NUMBER TURNBULLD.LOV_BAIT_USED 7 START_DATE DATE 7 Yes No Active Date of embarkation. DATE 8 START_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees. NUMBER 9 START_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 10 START_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 11 START_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 12 START_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 13 START_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 14 START_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 15 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 16 END_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees. NUMBER 17 END_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes NUMBER 18 END_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds NUMBER 19 END_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees. NUMBER 20 END_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes NUMBER 21 END_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds NUMBER 22 END_EW VARCHAR2 1 No No Active East West longitude identifier for Disembarkation. VARCHAR2 23 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 24 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 25 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 26 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 gov.noaa.nmfs.inport:7509 Doug Turnbull 2008-03-28T14:09:54 SysAdmin InPortAdmin 2022-08-09T17:11:01 2016-05-04 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-04 1 Year 2017-05-04