Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

A 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.

Description

A 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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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 within each observer instance of Atlas
CRUISE_VESSEL_SEQ
NUMBER
Sequence generated unique identifier for a cruise vessel.
TRIP_NUMBER
NUMBER
Number which is entered by the observer which must be unique within a cruise - vessel combination.
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.
ATLAS_VERSION_NUMBER
NUMBER
Current Version of Atlas Program. This is stored in both Trip and Offload and inherited by the rest of the system.
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: ATL_FMA_TRIP
Short Name: ATL_FMA_TRIP
Status: Completed
Abstract:

A 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.

Notes:

Loaded by batch 4574, 05-03-2013 17:18

Entity Information

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

A 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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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 TRIP_SEQ NUMBER Sequence generated unique identifier of a trip within each observer instance of Atlas
100
CRUISE_VESSEL_SEQ NUMBER Sequence generated unique identifier for a cruise vessel.
100
TRIP_NUMBER NUMBER Number which is entered by the observer which must be unique within a cruise - vessel combination.
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
ATLAS_VERSION_NUMBER NUMBER Current Version of Atlas Program. This is stored in both Trip and Offload and inherited by the rest of the system.
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
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

Attribute Details

CRUISE

CC ID: 111875
Seq. Order: 1
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
Foreign Key Relations:

NPRB_1017.ATL_CRUISE_VESSEL

TRIP_SEQ

CC ID: 111891
Seq. Order: 2
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 within each observer instance of Atlas

General Data Type: NUMBER

CRUISE_VESSEL_SEQ

CC ID: 111877
Seq. Order: 3
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
Foreign Key Relations:

NPRB_1017.ATL_CRUISE_VESSEL

TRIP_NUMBER

CC ID: 111901
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

EMBARKED_PORT_CODE

CC ID: 111879
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

User defined unique identifier of a port currently limited to 1 - 12

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_PORT_CODE

DISEMBARKED_PORT_CODE

CC ID: 111880
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
Foreign Key Relations:

NPRB_1017.ATL_LOV_PORT_CODE

BAIT_USED_SEQ

CC ID: 111878
Seq. Order: 7
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
Foreign Key Relations:

NPRB_1017.ATL_LOV_BAIT_USED

START_DATE

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

Date of embarkation.

General Data Type: DATE

START_LATITUDE_DEGREE

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

Latitude of embarkation in degrees.

General Data Type: NUMBER

START_LATITUDE_MIN

CC ID: 111881
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 minutes.

General Data Type: NUMBER

START_LATITUDE_SEC

CC ID: 111882
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 seconds.

General Data Type: NUMBER

START_LONGITUDE_DEGREE

CC ID: 111883
Seq. Order: 12
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

CC ID: 111884
Seq. Order: 13
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

CC ID: 111885
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 seconds.

General Data Type: NUMBER

START_EW

CC ID: 111886
Seq. Order: 15
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

CC ID: 111887
Seq. Order: 16
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

CC ID: 111888
Seq. Order: 17
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

CC ID: 111889
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 minutes

General Data Type: NUMBER

END_LATITUDE_SEC

CC ID: 111890
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 seconds

General Data Type: NUMBER

END_LONGITUDE_DEGREE

CC ID: 111892
Seq. Order: 20
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

CC ID: 111893
Seq. Order: 21
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

CC ID: 111894
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 seconds

General Data Type: NUMBER

END_EW

CC ID: 111895
Seq. Order: 23
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

CC ID: 111896
Seq. Order: 24
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: 111897
Seq. Order: 25
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: 111898
Seq. Order: 26
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

ATLAS_VERSION_NUMBER

CC ID: 111899
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Current Version of Atlas Program. This is stored in both Trip and Offload and inherited by the rest of the system.

General Data Type: NUMBER

COMMENTS

CC ID: 111900
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

CC ID: 111876
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
Foreign Key Relations:

NPRB_1017.ATL_CRUISE_VESSEL

Catalog Details

Catalog Item ID: 18984
GUID: gov.noaa.nmfs.inport:18984
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+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