Table: ATLW_FMA_TRIP
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9618 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionAn 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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RECORD_SET_STATUS_SEQ
NUMBER |
Sequence generated unique identifier of a record set header |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
TRIP_SEQ
NUMBER |
Sequence generated unique identifier of a trip |
CRUISE_VESSEL_SEQ
NUMBER |
Sequence generated unique identifier for a cruise vessel. |
TRIP_NUMBER
NUMBER |
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). |
EMBARKED_PORT_CODE
NUMBER |
User defined unique identifier of a port currently limited to 1 - 12 |
DISEMBARKED_PORT_CODE
NUMBER |
User defined unique identifier of a port currently limited to 1 - 12 |
BAIT_USED_SEQ
NUMBER |
Sequence generated unique identifier of a bait used record |
START_DATE
DATE |
Date of embarkation. |
START_LATITUDE_DEGREE
NUMBER |
Latitude of embarkation in degrees. |
START_LATITUDE_MIN
NUMBER |
Latitude of embarkation in minutes. |
START_LATITUDE_SEC
NUMBER |
Latitude of embarkation in seconds. |
START_LONGITUDE_DEGREE
NUMBER |
Longitude of embarkation in degrees. |
START_LONGITUDE_MIN
NUMBER |
Longitude of embarkation in minutes. |
START_LONGITUDE_SEC
NUMBER |
Longitude of embarkation in seconds. |
START_EW
VARCHAR2 |
East West longitude identifier for Embarkation. |
END_DATE
DATE |
Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. |
END_LATITUDE_DEGREE
NUMBER |
Latitude of disembarkation in degrees. |
END_LATITUDE_MIN
NUMBER |
Latitude of disembarkation in minutes |
END_LATITUDE_SEC
NUMBER |
Latitude of disembarkation in seconds |
END_LONGITUDE_DEGREE
NUMBER |
Longitude of disembarkation in degrees. |
END_LONGITUDE_MIN
NUMBER |
Longitude of disembarkation in minutes |
END_LONGITUDE_SEC
NUMBER |
Longitude of disembarkation in seconds |
END_EW
VARCHAR2 |
East West longitude identifier for Disembarkation. |
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. |
COMMENTS
VARCHAR2 |
Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
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: ATLW_FMA_TRIP |
---|---|
Short Name: | ATLW_FMA_TRIP |
Status: | Completed |
Abstract: |
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. |
Purpose: |
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. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
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. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECORD_SET_STATUS_SEQ | NUMBER | Sequence generated unique identifier of a record set header | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
TRIP_SEQ | NUMBER | Sequence generated unique identifier of a trip | |
100
|
CRUISE_VESSEL_SEQ | NUMBER | Sequence generated unique identifier for a cruise vessel. | |
100
|
TRIP_NUMBER | NUMBER | 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). | |
100
|
EMBARKED_PORT_CODE | NUMBER | User defined unique identifier of a port currently limited to 1 - 12 | |
100
|
DISEMBARKED_PORT_CODE | NUMBER | User defined unique identifier of a port currently limited to 1 - 12 | |
100
|
BAIT_USED_SEQ | NUMBER | Sequence generated unique identifier of a bait used record | |
100
|
START_DATE | DATE | Date of embarkation. | |
100
|
START_LATITUDE_DEGREE | NUMBER | Latitude of embarkation in degrees. | |
100
|
START_LATITUDE_MIN | NUMBER | Latitude of embarkation in minutes. | |
100
|
START_LATITUDE_SEC | NUMBER | Latitude of embarkation in seconds. | |
100
|
START_LONGITUDE_DEGREE | NUMBER | Longitude of embarkation in degrees. | |
100
|
START_LONGITUDE_MIN | NUMBER | Longitude of embarkation in minutes. | |
100
|
START_LONGITUDE_SEC | NUMBER | Longitude of embarkation in seconds. | |
100
|
START_EW | VARCHAR2 | East West longitude identifier for Embarkation. | |
100
|
END_DATE | DATE | Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. | |
100
|
END_LATITUDE_DEGREE | NUMBER | Latitude of disembarkation in degrees. | |
100
|
END_LATITUDE_MIN | NUMBER | Latitude of disembarkation in minutes | |
100
|
END_LATITUDE_SEC | NUMBER | Latitude of disembarkation in seconds | |
100
|
END_LONGITUDE_DEGREE | NUMBER | Longitude of disembarkation in degrees. | |
100
|
END_LONGITUDE_MIN | NUMBER | Longitude of disembarkation in minutes | |
100
|
END_LONGITUDE_SEC | NUMBER | Longitude of disembarkation in seconds | |
100
|
END_EW | VARCHAR2 | East West longitude identifier for Disembarkation. | |
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
|
COMMENTS | VARCHAR2 | Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
Attribute Details
RECORD_SET_STATUS_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a record set header |
General Data Type: | NUMBER |
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 |
TRIP_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a trip |
General Data Type: | NUMBER |
CRUISE_VESSEL_SEQ
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a cruise vessel. |
General Data Type: | NUMBER |
TRIP_NUMBER
Seq. Order: | 5 |
---|---|
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 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). |
General Data Type: | NUMBER |
EMBARKED_PORT_CODE
Seq. Order: | 6 |
---|---|
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_CODE
Seq. Order: | 7 |
---|---|
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 |
BAIT_USED_SEQ
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a bait used record |
General Data Type: | NUMBER |
START_DATE
Seq. Order: | 9 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date of embarkation. |
General Data Type: | DATE |
START_LATITUDE_DEGREE
Seq. Order: | 10 |
---|---|
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 |
START_LATITUDE_MIN
Seq. Order: | 11 |
---|---|
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 |
START_LATITUDE_SEC
Seq. Order: | 12 |
---|---|
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 |
START_LONGITUDE_DEGREE
Seq. Order: | 13 |
---|---|
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 |
START_LONGITUDE_MIN
Seq. Order: | 14 |
---|---|
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 |
START_LONGITUDE_SEC
Seq. Order: | 15 |
---|---|
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 |
START_EW
Seq. Order: | 16 |
---|---|
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 |
END_DATE
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 |
END_LATITUDE_DEGREE
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude of disembarkation in degrees. |
General Data Type: | NUMBER |
END_LATITUDE_MIN
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude of disembarkation in minutes |
General Data Type: | NUMBER |
END_LATITUDE_SEC
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Latitude of disembarkation in seconds |
General Data Type: | NUMBER |
END_LONGITUDE_DEGREE
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude of disembarkation in degrees. |
General Data Type: | NUMBER |
END_LONGITUDE_MIN
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude of disembarkation in minutes |
General Data Type: | NUMBER |
END_LONGITUDE_SEC
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Longitude of disembarkation in seconds |
General Data Type: | NUMBER |
END_EW
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
East West longitude identifier for Disembarkation. |
General Data Type: | VARCHAR2 |
CREW_SIZE
Seq. Order: | 25 |
---|---|
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: | 26 |
---|---|
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: | 27 |
---|---|
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 |
COMMENTS
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 29 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 9618 |
---|---|
GUID: | gov.noaa.nmfs.inport:9618 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |