Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_FMA_TRIP_H

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

Item Identification

Title:	Table: ATL_FMA_TRIP_H
Short Name:	ATL_FMA_TRIP_H
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.
Purpose:	Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.
Notes:	Loaded by batch 2390, 06-30-2009 16:11

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
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

	Name	Type	Description
100	SEQ_NUMBER	NUMBER	Oracle user who made a change to the transaction table record.
100	CHANGED_BY	VARCHAR2	Oracle user who made a change to the transaction table record.
100	DATE_CHANGED	DATE	Timestamp of change to transaction record.
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 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	Identifies 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	PERMIT	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau.
100	CAPTAIN_NAME	VARCHAR2	Name of the vessel captain for an observed trip. This data element will be recorded on the trip form or electronically beginning in 2013, and captured during debriefing in 2012.

Name

Type

Description

100

SEQ_NUMBER

NUMBER

Oracle user who made a change to the transaction table record.

100

CHANGED_BY

VARCHAR2

Oracle user who made a change to the transaction table record.

100

DATE_CHANGED

DATE

Timestamp of change to transaction record.

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

Identifies 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

PERMIT

VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau.

100

CAPTAIN_NAME

VARCHAR2

Name of the vessel captain for an observed trip. This data element will be recorded on the trip form or electronically beginning in 2013, and captured during debriefing in 2012.

Attribute Details

SEQ_NUMBER

CC ID: 38310

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	Oracle user who made a change to the transaction table record.
General Data Type:	NUMBER

CHANGED_BY

CC ID: 38291

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle user who made a change to the transaction table record.
General Data Type:	VARCHAR2

DATE_CHANGED

CC ID: 38296

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Timestamp of change to transaction record.
General Data Type:	DATE

CRUISE

CC ID: 38294

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
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

CC ID: 38320

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
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: 38295

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier for a cruise vessel.
General Data Type:	NUMBER

TRIP_NUMBER

CC ID: 38319

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
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: 38299

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	User defined unique identifier of a port currently limited to 1 - 12.
General Data Type:	NUMBER

DISEMBARKED_PORT_CODE

CC ID: 38298

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	User defined unique identifier of a port currently limited to 1 - 12.
General Data Type:	NUMBER

BAIT_USED_SEQ

CC ID: 38290

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier of a bait used record.
General Data Type:	NUMBER

START_DATE

CC ID: 38311

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

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of embarkation in degrees.
General Data Type:	NUMBER

START_LATITUDE_MIN

CC ID: 38314

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of embarkation in minutes.
General Data Type:	NUMBER

START_LATITUDE_SEC

CC ID: 38315

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of embarkation in seconds.
General Data Type:	NUMBER

START_LONGITUDE_DEGREE

CC ID: 38316

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of embarkation in degrees.
General Data Type:	NUMBER

START_LONGITUDE_MIN

CC ID: 38317

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of embarkation in minutes.
General Data Type:	NUMBER

START_LONGITUDE_SEC

CC ID: 38318

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of embarkation in seconds.
General Data Type:	NUMBER

START_EW

CC ID: 38312

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

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

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of disembarkation in degrees.
General Data Type:	NUMBER

END_LATITUDE_MIN

CC ID: 38303

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of disembarkation in minutes.
General Data Type:	NUMBER

END_LATITUDE_SEC

CC ID: 38304

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Latitude of disembarkation in seconds.
General Data Type:	NUMBER

END_LONGITUDE_DEGREE

CC ID: 38305

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of disembarkation in degrees.
General Data Type:	NUMBER

END_LONGITUDE_MIN

CC ID: 38306

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of disembarkation in minutes.
General Data Type:	NUMBER

END_LONGITUDE_SEC

CC ID: 38307

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Longitude of disembarkation in seconds.
General Data Type:	NUMBER

END_EW

CC ID: 38301

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

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Number of personnel on the vessel.
General Data Type:	NUMBER

DID_FISHING_OCCUR_FLAG

CC ID: 38297

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies whether fishing took place or not.
General Data Type:	VARCHAR2

FISH_IN_HOLD_AT_START_FLAG

CC ID: 38308

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
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: 38289

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

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

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
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

CAPTAIN_NAME

CC ID: 786094

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the vessel captain for an observed trip. This data element will be recorded on the trip form or electronically beginning in 2013, and captured during debriefing in 2012.

Catalog Details

Catalog Item ID:	9673
GUID:	gov.noaa.nmfs.inport:9673
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