Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBTRP

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33576 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Vessel-Trip Logs

Description

Observer Vessel-Trip Logs

Entity Type
Data View

Data Attribute / Type	Description
GEARCAT VARCHAR2	Gear category code, see support table OBGEAR. Collected for ASM where applicable.
LINK1 VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
PROGRAM VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
QTR NUMBER	Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.
TRIPEXT VARCHAR2	Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable.
VTRSERNO VARCHAR2	Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.
FLEET_TYPE VARCHAR2	Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.
SECTOR_ID VARCHAR2	Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.
VENDOR_ID VARCHAR2	01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.
HULLNUM1 VARCHAR2	Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.
XTRIPDUR NUMBER	The number of days the Captain expected to be away from port on fishing trip.
YEARSAIL VARCHAR2	Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.
MONTHSAIL VARCHAR2	Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.
DAYSAIL VARCHAR2	The day the vessel left the dock to go fishing. Collected for ASM where applicable.
TIMESAIL VARCHAR2	Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.
DATESAIL DATE	The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
TRIPTYPE VARCHAR2	Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.
HULLNUM2 VARCHAR2	Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown
CREW NUMBER	The number of individuals working on the vessel, including the Captain. Null = unknown.
YEARLAND VARCHAR2	(Same as YEAR) Collected for ASM where applicable.
MONTHLAND VARCHAR2	Month vessel landed for unloading catch. Collected for ASM where applicable.
DAYLAND VARCHAR2	Day the vessel landed to off load catch. Collected for ASM where applicable.
TIMELAND VARCHAR2	Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.
DATELAND DATE	Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
DA NUMBER	Computed field indicating number of day's absent on the trip; dateland - datesail + 1.
TMPHPORT VARCHAR2	4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch.
PORT VARCHAR2	The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable.
PORTSAIL VARCHAR2	The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.
STATE VARCHAR2	2-character state code (from PORT). Collected for ASM where applicable.
STEAMTIM NUMBER	Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable.
ICETONS NUMBER	Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.
FUELGAL NUMBER	Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.
DAMAGCOST NUMBER	Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
SUPPLYCOST NUMBER	Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable.
FOODCOST NUMBER	Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
ICEPRICE NUMBER	Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.
FUELPRICE NUMBER	Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.
WATERCOST NUMBER	Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
OILCOST NUMBER	Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
BAITCOST NUMBER	Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
TIMELOSTCD1 VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost.
TIMELOST1 NUMBER	Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.
TIMELOSTCD2 VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST2 NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.
TIMELOSTCD3 VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to
TIMELOST3 NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.
TIMELOSTCD4 VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST4 NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.
TIMELOSTCD5 VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST5 NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.
DOL DATE	Date of loading the data to the master tables
TRPCOMMENTS VARCHAR2	Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
PERMIT1 NUMBER	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
PERMIT2 NUMBER	Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).
DEALNUM VARCHAR2	Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
DEALISS_AGENCY VARCHAR2	Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).
VMSCODE VARCHAR2	VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).

Data Attribute / Type

Description

GEARCAT
VARCHAR2

Gear category code, see support table OBGEAR. Collected for ASM where applicable.

LINK1
VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

PROGRAM
VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

YEAR
VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

MONTH
VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

TRIPID
VARCHAR2

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.

QTR
NUMBER

Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.

TRIPEXT
VARCHAR2

Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable.

VTRSERNO
VARCHAR2

Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.

FLEET_TYPE
VARCHAR2

Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.

SECTOR_ID
VARCHAR2

Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.

VENDOR_ID
VARCHAR2

01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.

HULLNUM1
VARCHAR2

Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.

XTRIPDUR
NUMBER

The number of days the Captain expected to be away from port on fishing trip.

YEARSAIL
VARCHAR2

Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.

MONTHSAIL
VARCHAR2

Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.

DAYSAIL
VARCHAR2

The day the vessel left the dock to go fishing. Collected for ASM where applicable.

TIMESAIL
VARCHAR2

Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.

DATESAIL
DATE

The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

TRIPTYPE
VARCHAR2

Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.

HULLNUM2
VARCHAR2

Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown

CREW
NUMBER

The number of individuals working on the vessel, including the Captain. Null = unknown.

YEARLAND
VARCHAR2

(Same as YEAR) Collected for ASM where applicable.

MONTHLAND
VARCHAR2

Month vessel landed for unloading catch. Collected for ASM where applicable.

DAYLAND
VARCHAR2

Day the vessel landed to off load catch. Collected for ASM where applicable.

TIMELAND
VARCHAR2

Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.

DATELAND
DATE

Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

DA
NUMBER

Computed field indicating number of day's absent on the trip; dateland - datesail + 1.

TMPHPORT
VARCHAR2

4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch.

PORT
VARCHAR2

The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable.

PORTSAIL
VARCHAR2

The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.

STATE
VARCHAR2

2-character state code (from PORT). Collected for ASM where applicable.

STEAMTIM
NUMBER

Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable.

ICETONS
NUMBER

Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.

FUELGAL
NUMBER

Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.

DAMAGCOST
NUMBER

Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

SUPPLYCOST
NUMBER

Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable.

FOODCOST
NUMBER

Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

ICEPRICE
NUMBER

Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.

FUELPRICE
NUMBER

Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.

WATERCOST
NUMBER

Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

OILCOST
NUMBER

Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

BAITCOST
NUMBER

Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

TIMELOSTCD1
VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost.

TIMELOST1
NUMBER

Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.

TIMELOSTCD2
VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

TIMELOST2
NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.

TIMELOSTCD3
VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to

TIMELOST3
NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.

TIMELOSTCD4
VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

TIMELOST4
NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.

TIMELOSTCD5
VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

TIMELOST5
NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.

DOL
DATE

Date of loading the data to the master tables

TRPCOMMENTS
VARCHAR2

Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.

PERMIT1
NUMBER

Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

PERMIT2
NUMBER

Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).

DEALNUM
VARCHAR2

Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

DEALISS_AGENCY
VARCHAR2

Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).

VMSCODE
VARCHAR2

VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OBTRP
Short Name:	OBTRP
Status:	Completed
Abstract:	Observer Vessel-Trip Logs
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Vessel-Trip Logs

Attribute Summary

	Name	Type	Description
100	GEARCAT	VARCHAR2	Gear category code, see support table OBGEAR. Collected for ASM where applicable.
100	LINK1	VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100	PROGRAM	VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100	YEAR	VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100	MONTH	VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100	TRIPID	VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100	QTR	NUMBER	Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.
100	TRIPEXT	VARCHAR2	Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable.
100	VTRSERNO	VARCHAR2	Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.
100	FLEET_TYPE	VARCHAR2	Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.
100	SECTOR_ID	VARCHAR2	Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.
100	VENDOR_ID	VARCHAR2	01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.
100	HULLNUM1	VARCHAR2	Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.
100	XTRIPDUR	NUMBER	The number of days the Captain expected to be away from port on fishing trip.
100	YEARSAIL	VARCHAR2	Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.
100	MONTHSAIL	VARCHAR2	Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.
100	DAYSAIL	VARCHAR2	The day the vessel left the dock to go fishing. Collected for ASM where applicable.
100	TIMESAIL	VARCHAR2	Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.
100	DATESAIL	DATE	The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100	TRIPTYPE	VARCHAR2	Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.
100	HULLNUM2	VARCHAR2	Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown
100	CREW	NUMBER	The number of individuals working on the vessel, including the Captain. Null = unknown.
100	YEARLAND	VARCHAR2	(Same as YEAR) Collected for ASM where applicable.
100	MONTHLAND	VARCHAR2	Month vessel landed for unloading catch. Collected for ASM where applicable.
100	DAYLAND	VARCHAR2	Day the vessel landed to off load catch. Collected for ASM where applicable.
100	TIMELAND	VARCHAR2	Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.
100	DATELAND	DATE	Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
100	DA	NUMBER	Computed field indicating number of day's absent on the trip; dateland - datesail + 1.
100	TMPHPORT	VARCHAR2	4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch.
100	PORT	VARCHAR2	The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable.
100	PORTSAIL	VARCHAR2	The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.
100	STATE	VARCHAR2	2-character state code (from PORT). Collected for ASM where applicable.
100	STEAMTIM	NUMBER	Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable.
100	ICETONS	NUMBER	Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.
100	FUELGAL	NUMBER	Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.
100	DAMAGCOST	NUMBER	Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	SUPPLYCOST	NUMBER	Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable.
100	FOODCOST	NUMBER	Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	ICEPRICE	NUMBER	Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.
100	FUELPRICE	NUMBER	Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.
100	WATERCOST	NUMBER	Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	OILCOST	NUMBER	Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	BAITCOST	NUMBER	Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	TIMELOSTCD1	VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost.
100	TIMELOST1	NUMBER	Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.
100	TIMELOSTCD2	VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
100	TIMELOST2	NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.
100	TIMELOSTCD3	VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to
100	TIMELOST3	NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.
100	TIMELOSTCD4	VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
100	TIMELOST4	NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.
100	TIMELOSTCD5	VARCHAR2	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
100	TIMELOST5	NUMBER	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.
100	DOL	DATE	Date of loading the data to the master tables
100	TRPCOMMENTS	VARCHAR2	Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
100	PERMIT1	NUMBER	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100	PERMIT2	NUMBER	Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).
100	DEALNUM	VARCHAR2	Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100	DEALISS_AGENCY	VARCHAR2	Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).
100	VMSCODE	VARCHAR2	VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).

Name

Type

Description

100

GEARCAT

VARCHAR2

Gear category code, see support table OBGEAR. Collected for ASM where applicable.

100

LINK1

VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

100

PROGRAM

VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

100

YEAR

VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

100

MONTH

VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

100

TRIPID

VARCHAR2

100

QTR

NUMBER

Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.

100

TRIPEXT

VARCHAR2

100

VTRSERNO

VARCHAR2

Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.

100

FLEET_TYPE

VARCHAR2

Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.

100

SECTOR_ID

VARCHAR2

Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.

100

VENDOR_ID

VARCHAR2

01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.

100

HULLNUM1

VARCHAR2

Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.

100

XTRIPDUR

NUMBER

The number of days the Captain expected to be away from port on fishing trip.

100

YEARSAIL

VARCHAR2

Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.

100

MONTHSAIL

VARCHAR2

Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.

100

DAYSAIL

VARCHAR2

The day the vessel left the dock to go fishing. Collected for ASM where applicable.

100

TIMESAIL

VARCHAR2

Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.

100

DATESAIL

DATE

The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

100

TRIPTYPE

VARCHAR2

Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.

100

HULLNUM2

VARCHAR2

Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown

100

CREW

NUMBER

The number of individuals working on the vessel, including the Captain. Null = unknown.

100

YEARLAND

VARCHAR2

(Same as YEAR) Collected for ASM where applicable.

100

MONTHLAND

VARCHAR2

Month vessel landed for unloading catch. Collected for ASM where applicable.

100

DAYLAND

VARCHAR2

Day the vessel landed to off load catch. Collected for ASM where applicable.

100

TIMELAND

VARCHAR2

Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.

100

DATELAND

DATE

Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.

100

NUMBER

Computed field indicating number of day's absent on the trip; dateland - datesail + 1.

100

TMPHPORT

VARCHAR2

4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch.

100

PORT

VARCHAR2

The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable.

100

PORTSAIL

VARCHAR2

The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.

100

STATE

VARCHAR2

2-character state code (from PORT). Collected for ASM where applicable.

100

STEAMTIM

NUMBER

Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable.

100

ICETONS

NUMBER

Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.

100

FUELGAL

NUMBER

Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.

100

DAMAGCOST

NUMBER

100

SUPPLYCOST

NUMBER

Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable.

100

FOODCOST

NUMBER

Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

ICEPRICE

NUMBER

Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.

100

FUELPRICE

NUMBER

Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.

100

WATERCOST

NUMBER

Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

OILCOST

NUMBER

Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

BAITCOST

NUMBER

Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

TIMELOSTCD1

VARCHAR2

100

TIMELOST1

NUMBER

Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.

100

TIMELOSTCD2

VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

100

TIMELOST2

NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.

100

TIMELOSTCD3

VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to

100

TIMELOST3

NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.

100

TIMELOSTCD4

VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

100

TIMELOST4

NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.

100

TIMELOSTCD5

VARCHAR2

Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.

100

TIMELOST5

NUMBER

Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.

100

DOL

DATE

Date of loading the data to the master tables

100

TRPCOMMENTS

VARCHAR2

Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.

100

PERMIT1

NUMBER

Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

100

PERMIT2

NUMBER

Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).

100

DEALNUM

VARCHAR2

Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

100

DEALISS_AGENCY

VARCHAR2

Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).

100

VMSCODE

VARCHAR2

VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).

Attribute Details

GEARCAT

CC ID: 335076

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Gear category code, see support table OBGEAR. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 335087

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PROGRAM

CC ID: 335098

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAR

CC ID: 335109

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTH

CC ID: 335120

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TRIPID

CC ID: 335131

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type:	VARCHAR2

QTR

CC ID: 335133

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable.
General Data Type:	NUMBER

TRIPEXT

CC ID: 335134

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable.
General Data Type:	VARCHAR2

VTRSERNO

CC ID: 335135

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.
General Data Type:	VARCHAR2

FLEET_TYPE

CC ID: 335077

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.
General Data Type:	VARCHAR2

SECTOR_ID

CC ID: 335078

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.
General Data Type:	VARCHAR2

VENDOR_ID

CC ID: 335079

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.
General Data Type:	VARCHAR2

HULLNUM1

CC ID: 335080

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

XTRIPDUR

CC ID: 335081

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	The number of days the Captain expected to be away from port on fishing trip.
General Data Type:	NUMBER

YEARSAIL

CC ID: 335082

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTHSAIL

CC ID: 335083

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DAYSAIL

CC ID: 335084

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The day the vessel left the dock to go fishing. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TIMESAIL

CC ID: 335085

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DATESAIL

CC ID: 335086

Seq. Order:	19
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
General Data Type:	DATE

TRIPTYPE

CC ID: 335088

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.
General Data Type:	VARCHAR2

HULLNUM2

CC ID: 335089

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown
General Data Type:	VARCHAR2

CREW

CC ID: 335090

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	The number of individuals working on the vessel, including the Captain. Null = unknown.
General Data Type:	NUMBER

YEARLAND

CC ID: 335091

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	(Same as YEAR) Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTHLAND

CC ID: 335092

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month vessel landed for unloading catch. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DAYLAND

CC ID: 335093

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day the vessel landed to off load catch. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TIMELAND

CC ID: 335094

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DATELAND

CC ID: 335095

Seq. Order:	27
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable.
General Data Type:	DATE

DA

CC ID: 335096

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Computed field indicating number of day's absent on the trip; dateland - datesail + 1.
General Data Type:	NUMBER

TMPHPORT

CC ID: 335097

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch.
General Data Type:	VARCHAR2

PORT

CC ID: 335099

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PORTSAIL

CC ID: 335100

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

STATE

CC ID: 335101

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	2-character state code (from PORT). Collected for ASM where applicable.
General Data Type:	VARCHAR2

STEAMTIM

CC ID: 335102

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable.
General Data Type:	NUMBER

ICETONS

CC ID: 335103

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.
General Data Type:	NUMBER

FUELGAL

CC ID: 335104

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

DAMAGCOST

CC ID: 335105

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

SUPPLYCOST

CC ID: 335106

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

FOODCOST

CC ID: 335107

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

ICEPRICE

CC ID: 335108

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.
General Data Type:	NUMBER

FUELPRICE

CC ID: 335110

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

WATERCOST

CC ID: 335111

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

OILCOST

CC ID: 335112

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

BAITCOST

CC ID: 335113

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

TIMELOSTCD1

CC ID: 335114

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost.
General Data Type:	VARCHAR2

TIMELOST1

CC ID: 335115

Seq. Order:	45
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.
General Data Type:	NUMBER

TIMELOSTCD2

CC ID: 335116

Seq. Order:	46
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
General Data Type:	VARCHAR2

TIMELOST2

CC ID: 335117

Seq. Order:	47
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.
General Data Type:	NUMBER

TIMELOSTCD3

CC ID: 335118

Seq. Order:	48
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to
General Data Type:	VARCHAR2

TIMELOST3

CC ID: 335119

Seq. Order:	49
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.
General Data Type:	NUMBER

TIMELOSTCD4

CC ID: 335121

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
General Data Type:	VARCHAR2

TIMELOST4

CC ID: 335122

Seq. Order:	51
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.
General Data Type:	NUMBER

TIMELOSTCD5

CC ID: 335123

Seq. Order:	52
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
General Data Type:	VARCHAR2

TIMELOST5

CC ID: 335124

Seq. Order:	53
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.
General Data Type:	NUMBER

DOL

CC ID: 335125

Seq. Order:	54
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of loading the data to the master tables
General Data Type:	DATE

TRPCOMMENTS

CC ID: 335126

Seq. Order:	55
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PERMIT1

CC ID: 335127

Seq. Order:	56
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type:	NUMBER

PERMIT2

CC ID: 335128

Seq. Order:	57
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	NUMBER

DEALNUM

CC ID: 335129

Seq. Order:	58
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type:	VARCHAR2

DEALISS_AGENCY

CC ID: 335130

Seq. Order:	59
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

VMSCODE

CC ID: 335132

Seq. Order:	60
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

Catalog Item ID:	33576
GUID:	gov.noaa.nmfs.inport:33576
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

GEARCAT

LINK1

PROGRAM

YEAR

MONTH

TRIPID

QTR

TRIPEXT

VTRSERNO

FLEET_TYPE

SECTOR_ID

VENDOR_ID

HULLNUM1

XTRIPDUR

YEARSAIL

MONTHSAIL

DAYSAIL

TIMESAIL

DATESAIL

TRIPTYPE

HULLNUM2

CREW

YEARLAND

MONTHLAND

DAYLAND

TIMELAND

DATELAND

DA

TMPHPORT

PORT

PORTSAIL

STATE

STEAMTIM

ICETONS

FUELGAL

DAMAGCOST

SUPPLYCOST

FOODCOST

ICEPRICE

FUELPRICE

WATERCOST

OILCOST

BAITCOST

TIMELOSTCD1

TIMELOST1

TIMELOSTCD2

TIMELOST2

TIMELOSTCD3

TIMELOST3

TIMELOSTCD4

TIMELOST4

TIMELOSTCD5

TIMELOST5

DOL

TRPCOMMENTS

PERMIT1

PERMIT2

DEALNUM

DEALISS_AGENCY

VMSCODE

Catalog Details