Table: DEBRIEFED_TRIP
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:10663 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThe 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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
T_TABLE
CHAR |
Identifier of Source Table |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
TRIP_NUMBER
NUMBER |
Number which is entered by the observer which must be unique within a cruise - vessel combination. |
TRIP_SEQ
NUMBER |
Sequence generated unique identifier for a trip as defined in ATL_fma_trip. |
TRIP_JOIN
NUMBER |
Unique identifier of a trip record created by concatenating cruise, permit, and trip_seq. |
VESSEL_CODE
VARCHAR2 |
Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel |
VESSEL_NAME
VARCHAR2 |
Name of Vessel from ATL_lov_vessel |
ADFG_NUMBER
VARCHAR2 |
ADFG permit number |
CG_NUMBER
NUMBER |
USCG registration number |
EMBARKED_PORT
NUMBER |
User defined unique identifier of a port currently limited to 1 - 12 |
DISEMBARKED_PORT
NUMBER |
User defined unique identifier of a port currently limited to 1 - 12 |
CREW_SIZE
NUMBER |
Number of personnel on the vessel. |
DID_FISHING_OCCUR_FLAG
VARCHAR2 |
Idetifies whether fishing took place or not. |
FISH_IN_HOLD_AT_START_FLAG
VARCHAR2 |
Identifies whether there were fish present in the hold at the start of a fishing trip. |
TRIP_START
DATE |
Date of embarkation. |
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. |
YEAR
NUMBER |
Current Year extracted from trip start date. |
TRIP_START_LAT_DEG
NUMBER |
Latitude of embarkation in degrees |
TRIP_START_LAT_MIN
NUMBER |
Latitude of embarkation in minutes. |
TRIP_START_LAT_SEC
NUMBER |
Latitude of embarkation in seconds. |
TRIP_START_LONG_DEG
NUMBER |
Longitude of embarkation in degrees. |
TRIP_START_LONG_MIN
NUMBER |
Longitude of embarkation in minutes. |
TRIP_START_LONG_SEC
NUMBER |
Longitude of embarkation in seconds. |
TRIP_START_LONG_EW
VARCHAR2 |
East West longitude identifier for Embarkation. |
TRIP_END_LAT_DEG
NUMBER |
Latitude of disembarkation in degrees, if not a defined port. |
TRIP_END_LAT_MIN
NUMBER |
Latitude of disembarkation in minutes, if not a defined port. |
TRIP_END_LAT_SEC
NUMBER |
Latitude of disembarkation in seconds, if not a defined port. |
TRIP_END_LONG_DEG
NUMBER |
Longitude of disembarkation in degrees if not a defined port. |
TRIP_END_LONG_MIN
NUMBER |
Longitude of disembarkation in minutes if not a defined port. |
TRIP_END_LONG_SEC
NUMBER |
Longitude of disembarkation in seconds if not a defined port. |
TRIP_END_LONG_EW
VARCHAR2 |
East (Western Hemisphere) West (Eastern Hemisphere) Longitude of disembarkation. |
NON_FISHING_DATE
DATE |
Date where no fishing activity occured, This value is denormalized down from the cruise vessel/cruise plant level. |
NO_FISH_LAT_DEG
NUMBER |
Vessel position at noon of the day where no fishing occurred' |
NO_FISH_LAT_MIN
NUMBER |
Vessel position at noon of the day where no fishing occurred' |
NO_FISH_LAT_SEC
NUMBER |
Vessel position at noon of the day where no fishing occurred. |
NO_FISH_LONG_DEG
NUMBER |
Vessel position at noon of the day where no fishing occurred. |
NO_FISH_LONG_MIN
NUMBER |
Vessel position at noon of the day where no fishing occurred. |
NO_FISH_LONG_SEC
NUMBER |
Vessel position at noon of the day where no fishing occurred. |
NO_FISH_LONG_EW
VARCHAR2 |
Vessel position at noon of the day where no fishing occurred. |
FISHING_HOURS_LOST
NUMBER |
Fishing time lost is a child value of a fma_trip, and may result in duplicate trip records. |
TIME_LOST_REASON
VARCHAR2 |
The reason identified for lost fishing time. This value is prescribed and not editable. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
T_TABLE | CHAR | Identifier of Source Table | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
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
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |