Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Debriefed Observer Data Interface > AFSC/FMA/North Pacific Observer Debriefed Data... >

Table: DEBRIEFED_TRIP

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:10663  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: DEBRIEFED_TRIP
Short Name: DEBRIEFED_TRIP
Status: Completed
Abstract:

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.
Notes:

Loaded by batch 2535, 11-09-2010 10:55

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: OBSINT
Description:

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 T_TABLE CHAR Identifier of Source Table
100
 Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 Primary Key PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 TRIP_NUMBER NUMBER Number which is entered by the observer which must be unique within a cruise - vessel combination.
100
 Primary Key TRIP_SEQ NUMBER Sequence generated unique identifier for a trip as defined in ATL_fma_trip.
100
 TRIP_JOIN NUMBER Unique identifier of a trip record created by concatenating cruise, permit, and trip_seq.
100
 VESSEL_CODE VARCHAR2 Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
100
 VESSEL_NAME VARCHAR2 Name of Vessel from ATL_lov_vessel
100
 ADFG_NUMBER VARCHAR2 ADFG permit number
100
 CG_NUMBER NUMBER USCG registration number
100
 EMBARKED_PORT NUMBER User defined unique identifier of a port currently limited to 1 - 12
100
 DISEMBARKED_PORT NUMBER User defined unique identifier of a port currently limited to 1 - 12
100
 CREW_SIZE NUMBER Number of personnel on the vessel.
100
 DID_FISHING_OCCUR_FLAG VARCHAR2 Idetifies whether fishing took place or not.
100
 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 Identifies whether there were fish present in the hold at the start of a fishing trip.
100
 TRIP_START DATE Date of embarkation.
100
 TRIP_END DATE Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip.
100
 YEAR NUMBER Current Year extracted from trip start date.
100
 TRIP_START_LAT_DEG NUMBER Latitude of embarkation in degrees
100
 TRIP_START_LAT_MIN NUMBER Latitude of embarkation in minutes.
100
 TRIP_START_LAT_SEC NUMBER Latitude of embarkation in seconds.
100
 TRIP_START_LONG_DEG NUMBER Longitude of embarkation in degrees.
100
 TRIP_START_LONG_MIN NUMBER Longitude of embarkation in minutes.
100
 TRIP_START_LONG_SEC NUMBER Longitude of embarkation in seconds.
100
 TRIP_START_LONG_EW VARCHAR2 East West longitude identifier for Embarkation.
100
 TRIP_END_LAT_DEG NUMBER Latitude of disembarkation in degrees, if not a defined port.
100
 TRIP_END_LAT_MIN NUMBER Latitude of disembarkation in minutes, if not a defined port.
100
 TRIP_END_LAT_SEC NUMBER Latitude of disembarkation in seconds, if not a defined port.
100
 TRIP_END_LONG_DEG NUMBER Longitude of disembarkation in degrees if not a defined port.
100
 TRIP_END_LONG_MIN NUMBER Longitude of disembarkation in minutes if not a defined port.
100
 TRIP_END_LONG_SEC NUMBER Longitude of disembarkation in seconds if not a defined port.
100
 TRIP_END_LONG_EW VARCHAR2 East (Western Hemisphere) West (Eastern Hemisphere) Longitude of disembarkation.
100
 NON_FISHING_DATE DATE Date where no fishing activity occured, This value is denormalized down from the cruise vessel/cruise plant level.
100
 NO_FISH_LAT_DEG NUMBER Vessel position at noon of the day where no fishing occurred'
100
 NO_FISH_LAT_MIN NUMBER Vessel position at noon of the day where no fishing occurred'
100
 NO_FISH_LAT_SEC NUMBER Vessel position at noon of the day where no fishing occurred.
100
 NO_FISH_LONG_DEG NUMBER Vessel position at noon of the day where no fishing occurred.
100
 NO_FISH_LONG_MIN NUMBER Vessel position at noon of the day where no fishing occurred.
100
 NO_FISH_LONG_SEC NUMBER Vessel position at noon of the day where no fishing occurred.
100
 NO_FISH_LONG_EW VARCHAR2 Vessel position at noon of the day where no fishing occurred.
100
 FISHING_HOURS_LOST NUMBER Fishing time lost is a child value of a fma_trip, and may result in duplicate trip records.
100
 TIME_LOST_REASON VARCHAR2 The reason identified for lost fishing time. This value is prescribed and not editable.

Attribute Details

T_TABLE

CC ID: 42739
Seq. Order: 1
Data Storage Type: CHAR
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Identifier of Source Table
General Data Type: CHAR

CRUISE

CC ID: 42740
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER

PERMIT

CC ID: 42741
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: VARCHAR2

TRIP_NUMBER

CC ID: 42742
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number which is entered by the observer which must be unique within a cruise - vessel combination.
General Data Type: NUMBER

TRIP_SEQ

CC ID: 42743
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a trip as defined in ATL_fma_trip.
General Data Type: NUMBER

TRIP_JOIN

CC ID: 42744
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique identifier of a trip record created by concatenating cruise, permit, and trip_seq.
General Data Type: NUMBER

VESSEL_CODE

CC ID: 42745
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 42746
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of Vessel from ATL_lov_vessel
General Data Type: VARCHAR2

ADFG_NUMBER

CC ID: 42747
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

ADFG permit number
General Data Type: VARCHAR2

CG_NUMBER

CC ID: 42748
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 0
Status: Active
Description:

USCG registration number
General Data Type: NUMBER

EMBARKED_PORT

CC ID: 42749
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

User defined unique identifier of a port currently limited to 1 - 12
General Data Type: NUMBER

DISEMBARKED_PORT

CC ID: 42750
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

User defined unique identifier of a port currently limited to 1 - 12
General Data Type: NUMBER

CREW_SIZE

CC ID: 42751
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number of personnel on the vessel.
General Data Type: NUMBER

DID_FISHING_OCCUR_FLAG

CC ID: 42752
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Idetifies whether fishing took place or not.
General Data Type: VARCHAR2

FISH_IN_HOLD_AT_START_FLAG

CC ID: 42753
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Identifies whether there were fish present in the hold at the start of a fishing trip.
General Data Type: VARCHAR2

TRIP_START

CC ID: 42754
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of embarkation.
General Data Type: DATE

TRIP_END

CC ID: 42755
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip.
General Data Type: DATE

YEAR

CC ID: 42756
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Current Year extracted from trip start date.
General Data Type: NUMBER

TRIP_START_LAT_DEG

CC ID: 42757
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of embarkation in degrees
General Data Type: NUMBER

TRIP_START_LAT_MIN

CC ID: 42758
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of embarkation in minutes.
General Data Type: NUMBER

TRIP_START_LAT_SEC

CC ID: 42759
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of embarkation in seconds.
General Data Type: NUMBER

TRIP_START_LONG_DEG

CC ID: 42760
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Longitude of embarkation in degrees.
General Data Type: NUMBER

TRIP_START_LONG_MIN

CC ID: 42761
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude of embarkation in minutes.
General Data Type: NUMBER

TRIP_START_LONG_SEC

CC ID: 42762
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude of embarkation in seconds.
General Data Type: NUMBER

TRIP_START_LONG_EW

CC ID: 42763
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

East West longitude identifier for Embarkation.
General Data Type: VARCHAR2

TRIP_END_LAT_DEG

CC ID: 42764
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of disembarkation in degrees, if not a defined port.
General Data Type: NUMBER

TRIP_END_LAT_MIN

CC ID: 42765
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of disembarkation in minutes, if not a defined port.
General Data Type: NUMBER

TRIP_END_LAT_SEC

CC ID: 42766
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude of disembarkation in seconds, if not a defined port.
General Data Type: NUMBER

TRIP_END_LONG_DEG

CC ID: 42767
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Longitude of disembarkation in degrees if not a defined port.
General Data Type: NUMBER

TRIP_END_LONG_MIN

CC ID: 42768
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude of disembarkation in minutes if not a defined port.
General Data Type: NUMBER

TRIP_END_LONG_SEC

CC ID: 42769
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude of disembarkation in seconds if not a defined port.
General Data Type: NUMBER

TRIP_END_LONG_EW

CC ID: 42770
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

East (Western Hemisphere) West (Eastern Hemisphere) Longitude of disembarkation.
General Data Type: VARCHAR2

NON_FISHING_DATE

CC ID: 42771
Seq. Order: 33
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date where no fishing activity occured, This value is denormalized down from the cruise vessel/cruise plant level.
General Data Type: DATE

NO_FISH_LAT_DEG

CC ID: 42772
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred'
General Data Type: NUMBER

NO_FISH_LAT_MIN

CC ID: 42773
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred'
General Data Type: NUMBER

NO_FISH_LAT_SEC

CC ID: 42774
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred.
General Data Type: NUMBER

NO_FISH_LONG_DEG

CC ID: 42775
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred.
General Data Type: NUMBER

NO_FISH_LONG_MIN

CC ID: 42776
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred.
General Data Type: NUMBER

NO_FISH_LONG_SEC

CC ID: 42777
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred.
General Data Type: NUMBER

NO_FISH_LONG_EW

CC ID: 42778
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Vessel position at noon of the day where no fishing occurred.
General Data Type: VARCHAR2

FISHING_HOURS_LOST

CC ID: 42779
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Fishing time lost is a child value of a fma_trip, and may result in duplicate trip records.
General Data Type: NUMBER

TIME_LOST_REASON

CC ID: 42780
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The reason identified for lost fishing time. This value is prescribed and not editable.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 10663
GUID: gov.noaa.nmfs.inport:10663
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2010-11-09 10:55+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18