Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Atlas Remote Client > AFSC/FMA/ATLAS Remote Client >

Table: FMA_TRIP

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

An 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

Entity Type
Data Table

Data Attribute / Type	Description
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.

Data Attribute / Type

Description

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	Table: FMA_TRIP
Short Name:	FMA_TRIP
Status:	Completed
Abstract:	An 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 2204, 03-28-2008 14:09

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	TURNBULLD
Description:	An 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.

Attribute Summary

	Name	Type	Description
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.

Name

Type

Description

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

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.

Attribute Details

TRIP_SEQ

CC ID: 29581

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 trip
General Data Type:	NUMBER

CRUISE_VESSEL_SEQ

CC ID: 29559

Seq. Order:	2
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:	TURNBULLD.CRUISE_VESSEL

TRIP_NUMBER

CC ID: 29580

Seq. Order:	3
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

CC ID: 29562

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
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:	TURNBULLD.LOV_PORT_CODE

DISEMBARKED_PORT_CODE

CC ID: 29561

Seq. Order:	5
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:	TURNBULLD.LOV_PORT_CODE

BAIT_USED_SEQ

CC ID: 29556

Seq. Order:	6
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:	TURNBULLD.LOV_BAIT_USED

START_DATE

CC ID: 29572

Seq. Order:	7
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

CC ID: 29574

Seq. Order:	8
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

CC ID: 29575

Seq. Order:	9
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: 29576

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 seconds.
General Data Type:	NUMBER

START_LONGITUDE_DEGREE

CC ID: 29577

Seq. Order:	11
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: 29578

Seq. Order:	12
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: 29579

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 seconds.
General Data Type:	NUMBER

START_EW

CC ID: 29573

Seq. Order:	14
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: 29563

Seq. Order:	15
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: 29565

Seq. Order:	16
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: 29566

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 minutes
General Data Type:	NUMBER

END_LATITUDE_SEC

CC ID: 29567

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 seconds
General Data Type:	NUMBER

END_LONGITUDE_DEGREE

CC ID: 29568

Seq. Order:	19
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: 29569

Seq. Order:	20
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: 29570

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 seconds
General Data Type:	NUMBER

END_EW

CC ID: 29564

Seq. Order:	22
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: 29558

Seq. Order:	23
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: 29560

Seq. Order:	24
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: 29571

Seq. Order:	25
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

CC ID: 29557

Seq. Order:	26
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

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

Table: FMA_TRIP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_SEQ

CRUISE_VESSEL_SEQ

TRIP_NUMBER

EMBARKED_PORT_CODE

DISEMBARKED_PORT_CODE

BAIT_USED_SEQ

START_DATE

START_LATITUDE_DEGREE

START_LATITUDE_MIN

START_LATITUDE_SEC

START_LONGITUDE_DEGREE

START_LONGITUDE_MIN

START_LONGITUDE_SEC

START_EW

END_DATE

END_LATITUDE_DEGREE

END_LATITUDE_MIN

END_LATITUDE_SEC

END_LONGITUDE_DEGREE

END_LONGITUDE_MIN

END_LONGITUDE_SEC

END_EW

CREW_SIZE

DID_FISHING_OCCUR_FLAG

FISH_IN_HOLD_AT_START_FLAG

COMMENTS

Catalog Details