10663 DEBRIEFED_TRIP Entity Published / External 10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT) Data Set Completed The debriefed trip table was created as a successor to the debriefed haul materialized view. As vessel trip information was rolled into the haul objects of the Domestic data set, the values recorded here represent the notion of a trip as defined in the ATL data (2008 onwards) This definition may be defined as "cast off - tie up". Any movement of a vessel is defined as a trip regardless of fishing activity. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed trip table was created as a successor to the debriefed haul materialized view. As vessel trip information was rolled into the haul objects of the Domestic data set, the values recorded here represent the notion of a trip as defined in the ATL data (2008 onwards) This definition may be defined as "cast off - tie up". Any movement of a vessel is defined as a trip regardless of fishing activity. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. 1 T_TABLE CHAR 3 No No Active Identifier of Source Table CHAR 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 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 4 TRIP_NUMBER NUMBER 22 Yes No 4 0 Active Number which is entered by the observer which must be unique within a cruise - vessel combination. NUMBER 5 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a trip as defined in ATL_fma_trip. NUMBER 6 TRIP_JOIN NUMBER 22 Yes No 38 Active Unique identifier of a trip record created by concatenating cruise, permit, and trip_seq. NUMBER 7 VESSEL_CODE VARCHAR2 8 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel VARCHAR2 8 VESSEL_NAME VARCHAR2 50 No No Active Name of Vessel from ATL_lov_vessel VARCHAR2 9 ADFG_NUMBER VARCHAR2 6 No No Active ADFG permit number VARCHAR2 10 CG_NUMBER NUMBER 22 No No 7 0 Active USCG registration number NUMBER 11 EMBARKED_PORT NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 12 DISEMBARKED_PORT NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 13 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 14 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 15 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 16 TRIP_START DATE 7 No No Active Date of embarkation. DATE 17 TRIP_END 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 YEAR NUMBER 22 No No 38 Active Current Year extracted from trip start date. NUMBER 19 TRIP_START_LAT_DEG NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees NUMBER 20 TRIP_START_LAT_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 21 TRIP_START_LAT_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 22 TRIP_START_LONG_DEG NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 23 TRIP_START_LONG_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 24 TRIP_START_LONG_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 25 TRIP_START_LONG_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 26 TRIP_END_LAT_DEG NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees, if not a defined port. NUMBER 27 TRIP_END_LAT_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes, if not a defined port. NUMBER 28 TRIP_END_LAT_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds, if not a defined port. NUMBER 29 TRIP_END_LONG_DEG NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees if not a defined port. NUMBER 30 TRIP_END_LONG_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes if not a defined port. NUMBER 31 TRIP_END_LONG_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds if not a defined port. NUMBER 32 TRIP_END_LONG_EW VARCHAR2 1 No No Active East (Western Hemisphere) West (Eastern Hemisphere) Longitude of disembarkation. VARCHAR2 33 NON_FISHING_DATE DATE 7 No No Active Date where no fishing activity occured, This value is denormalized down from the cruise vessel/cruise plant level. DATE 34 NO_FISH_LAT_DEG NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred' NUMBER 35 NO_FISH_LAT_MIN NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred' NUMBER 36 NO_FISH_LAT_SEC NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 37 NO_FISH_LONG_DEG NUMBER 22 No No 3 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 38 NO_FISH_LONG_MIN NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 39 NO_FISH_LONG_SEC NUMBER 22 No No 2 0 Active Vessel position at noon of the day where no fishing occurred. NUMBER 40 NO_FISH_LONG_EW VARCHAR2 1 No No Active Vessel position at noon of the day where no fishing occurred. VARCHAR2 41 FISHING_HOURS_LOST NUMBER 22 No No 3 0 Active Fishing time lost is a child value of a fma_trip, and may result in duplicate trip records. NUMBER 42 TIME_LOST_REASON VARCHAR2 50 No No Active The reason identified for lost fishing time. This value is prescribed and not editable. VARCHAR2 gov.noaa.nmfs.inport:10663 Doug Turnbull 2010-11-09T10:55:45 SysAdmin InPortAdmin 2022-08-09T17:11:03 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