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

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Trip Economic Data from standard observer trips

Description

Observer Trip Economic Data from standard observer trips

Entity Type
Data View

Data Attribute / Type	Description
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.
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.
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.
YRBLT VARCHAR2	Four digit year vessel was built.
VESSLEN NUMBER	Total length of the vessel, in whole feet.
GRTONS NUMBER	Total gross registered tonnage of vessel, in whole tons.
HOLDCAP NUMBER	Amount of fish that can be stored in vessel's hold, in whole pounds.
FUELTYPE VARCHAR2	Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2.
INSHULL NUMBER	Total annual cost of vessel owner's hull insurance coverage, to the nearest dollar. Not recorded prior to 5/1994; set to unknown.
INSPI NUMBER	Total annual cost of the vessel owner's insurance coverage for protection and indemnity, to the nearest dollar. Not collected prior to 5/1994; set to unknown.
INSCOMBINED NUMBER	Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar.
ENG2EXIST VARCHAR2	Secondary engine used on vessel for propulsion. 0=no; 1=yes, unknown = 9. Not recorded prior to 5/1994; set to unknown.
ENG1YR VARCHAR2	Year the main engine was built. Unknown = 0000.
ENG2YR VARCHAR2	Year the secondary engine was built. Unknown = 0000.
ENG1HSPR NUMBER	Horsepower of the main engine. Unknown = null.
ENG2HSPR NUMBER	Horsepower of the secondary engine. Unknown = null.
CORP VARCHAR2	Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994
OWNTYPE VARCHAR2	Type of vessel ownership. 0=unknown, 1=sole owner, 2 = partnership, 3 = fish firm owns, not captain, 4 = non-fish firm owns, not captain, 5 = sole ownership; not captain, 9 = other.
VESSCONS VARCHAR2	Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other.
ENGMAINT NUMBER	Repair and maintenance cost to the engine for the last twelve months. Unknown = null. Not collected prior to 2001; set to unknown.
FSHGRMAINT NUMBER	Dollars spent of maintenance and repair of fishing gear in last 12 months. Null if unknown Not collected prior to 2001; set to unknown.
DCKGRMAINT NUMBER	Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown.
PROCMAINT NUMBER	Dollars spent on processing equipment maintenance or repair in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
ELECTMAINT NUMBER	Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown.
OTHERMAINT NUMBER	Dollars spent on repairs and or maintenance to gear not accounted for on other categories. Null = unknown. Not collected prior to 2001; set to unknown.
ENGREPL NUMBER	Dollars spent on engine replacement or addition in the last 12 months. Unknown = null.
FSHGRREPL NUMBER	Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown.
DCKGRREPL NUMBER	Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown.
PROCREPL NUMBER	Dollars spent on processing equipment additions of replacement in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
ELECTREPL NUMBER	Cost of wheelhouse and gear mounted electronic equipment replaced or added on vessel in last 12 months, to the nearest dollar. Unknown = null.
OTHERREPL NUMBER	Cost of other vessel parts repairs and/or maintenance made on vessel in the last 12 month period, to the nearest dollar. Unknown = null.
TRECOMMENTS VARCHAR2	Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false.
TRPCOMMENTS VARCHAR2	Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
PERMIT1 VARCHAR2	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
PERMIT2 VARCHAR2	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

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.

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.

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.

YRBLT
VARCHAR2

Four digit year vessel was built.

VESSLEN
NUMBER

Total length of the vessel, in whole feet.

GRTONS
NUMBER

Total gross registered tonnage of vessel, in whole tons.

HOLDCAP
NUMBER

Amount of fish that can be stored in vessel's hold, in whole pounds.

FUELTYPE
VARCHAR2

Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2.

INSHULL
NUMBER

Total annual cost of vessel owner's hull insurance coverage, to the nearest dollar. Not recorded prior to 5/1994; set to unknown.

INSPI
NUMBER

Total annual cost of the vessel owner's insurance coverage for protection and indemnity, to the nearest dollar. Not collected prior to 5/1994; set to unknown.

INSCOMBINED
NUMBER

Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar.

ENG2EXIST
VARCHAR2

Secondary engine used on vessel for propulsion. 0=no; 1=yes, unknown = 9. Not recorded prior to 5/1994; set to unknown.

ENG1YR
VARCHAR2

Year the main engine was built. Unknown = 0000.

ENG2YR
VARCHAR2

Year the secondary engine was built. Unknown = 0000.

ENG1HSPR
NUMBER

Horsepower of the main engine. Unknown = null.

ENG2HSPR
NUMBER

Horsepower of the secondary engine. Unknown = null.

CORP
VARCHAR2

Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994

OWNTYPE
VARCHAR2

Type of vessel ownership. 0=unknown, 1=sole owner, 2 = partnership, 3 = fish firm owns, not captain, 4 = non-fish firm owns, not captain, 5 = sole ownership; not captain, 9 = other.

VESSCONS
VARCHAR2

Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other.

ENGMAINT
NUMBER

Repair and maintenance cost to the engine for the last twelve months. Unknown = null. Not collected prior to 2001; set to unknown.

FSHGRMAINT
NUMBER

Dollars spent of maintenance and repair of fishing gear in last 12 months. Null if unknown Not collected prior to 2001; set to unknown.

DCKGRMAINT
NUMBER

Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown.

PROCMAINT
NUMBER

Dollars spent on processing equipment maintenance or repair in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.

ELECTMAINT
NUMBER

Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown.

OTHERMAINT
NUMBER

Dollars spent on repairs and or maintenance to gear not accounted for on other categories. Null = unknown. Not collected prior to 2001; set to unknown.

ENGREPL
NUMBER

Dollars spent on engine replacement or addition in the last 12 months. Unknown = null.

FSHGRREPL
NUMBER

Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown.

DCKGRREPL
NUMBER

Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown.

PROCREPL
NUMBER

Dollars spent on processing equipment additions of replacement in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.

ELECTREPL
NUMBER

Cost of wheelhouse and gear mounted electronic equipment replaced or added on vessel in last 12 months, to the nearest dollar. Unknown = null.

OTHERREPL
NUMBER

Cost of other vessel parts repairs and/or maintenance made on vessel in the last 12 month period, to the nearest dollar. Unknown = null.

TRECOMMENTS
VARCHAR2

Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false.

TRPCOMMENTS
VARCHAR2

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

PERMIT1
VARCHAR2

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

PERMIT2
VARCHAR2

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: OBTRE
Short Name:	OBTRE
Status:	Completed
Abstract:	Observer Trip Economic Data from standard observer trips
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Trip Economic Data from standard observer trips

Attribute Summary

	Name	Type	Description
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	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	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	YRBLT	VARCHAR2	Four digit year vessel was built.
100	VESSLEN	NUMBER	Total length of the vessel, in whole feet.
100	GRTONS	NUMBER	Total gross registered tonnage of vessel, in whole tons.
100	HOLDCAP	NUMBER	Amount of fish that can be stored in vessel's hold, in whole pounds.
100	FUELTYPE	VARCHAR2	Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2.
100	INSHULL	NUMBER	Total annual cost of vessel owner's hull insurance coverage, to the nearest dollar. Not recorded prior to 5/1994; set to unknown.
100	INSPI	NUMBER	Total annual cost of the vessel owner's insurance coverage for protection and indemnity, to the nearest dollar. Not collected prior to 5/1994; set to unknown.
100	INSCOMBINED	NUMBER	Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar.
100	ENG2EXIST	VARCHAR2	Secondary engine used on vessel for propulsion. 0=no; 1=yes, unknown = 9. Not recorded prior to 5/1994; set to unknown.
100	ENG1YR	VARCHAR2	Year the main engine was built. Unknown = 0000.
100	ENG2YR	VARCHAR2	Year the secondary engine was built. Unknown = 0000.
100	ENG1HSPR	NUMBER	Horsepower of the main engine. Unknown = null.
100	ENG2HSPR	NUMBER	Horsepower of the secondary engine. Unknown = null.
100	CORP	VARCHAR2	Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994
100	OWNTYPE	VARCHAR2	Type of vessel ownership. 0=unknown, 1=sole owner, 2 = partnership, 3 = fish firm owns, not captain, 4 = non-fish firm owns, not captain, 5 = sole ownership; not captain, 9 = other.
100	VESSCONS	VARCHAR2	Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other.
100	ENGMAINT	NUMBER	Repair and maintenance cost to the engine for the last twelve months. Unknown = null. Not collected prior to 2001; set to unknown.
100	FSHGRMAINT	NUMBER	Dollars spent of maintenance and repair of fishing gear in last 12 months. Null if unknown Not collected prior to 2001; set to unknown.
100	DCKGRMAINT	NUMBER	Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown.
100	PROCMAINT	NUMBER	Dollars spent on processing equipment maintenance or repair in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
100	ELECTMAINT	NUMBER	Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown.
100	OTHERMAINT	NUMBER	Dollars spent on repairs and or maintenance to gear not accounted for on other categories. Null = unknown. Not collected prior to 2001; set to unknown.
100	ENGREPL	NUMBER	Dollars spent on engine replacement or addition in the last 12 months. Unknown = null.
100	FSHGRREPL	NUMBER	Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown.
100	DCKGRREPL	NUMBER	Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown.
100	PROCREPL	NUMBER	Dollars spent on processing equipment additions of replacement in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
100	ELECTREPL	NUMBER	Cost of wheelhouse and gear mounted electronic equipment replaced or added on vessel in last 12 months, to the nearest dollar. Unknown = null.
100	OTHERREPL	NUMBER	Cost of other vessel parts repairs and/or maintenance made on vessel in the last 12 month period, to the nearest dollar. Unknown = null.
100	TRECOMMENTS	VARCHAR2	Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false.
100	TRPCOMMENTS	VARCHAR2	Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
100	PERMIT1	VARCHAR2	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100	PERMIT2	VARCHAR2	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

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

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

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

YRBLT

VARCHAR2

Four digit year vessel was built.

100

VESSLEN

NUMBER

Total length of the vessel, in whole feet.

100

GRTONS

NUMBER

Total gross registered tonnage of vessel, in whole tons.

100

HOLDCAP

NUMBER

Amount of fish that can be stored in vessel's hold, in whole pounds.

100

FUELTYPE

VARCHAR2

Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2.

100

INSHULL

NUMBER

Total annual cost of vessel owner's hull insurance coverage, to the nearest dollar. Not recorded prior to 5/1994; set to unknown.

100

INSPI

NUMBER

Total annual cost of the vessel owner's insurance coverage for protection and indemnity, to the nearest dollar. Not collected prior to 5/1994; set to unknown.

100

INSCOMBINED

NUMBER

Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar.

100

ENG2EXIST

VARCHAR2

Secondary engine used on vessel for propulsion. 0=no; 1=yes, unknown = 9. Not recorded prior to 5/1994; set to unknown.

100

ENG1YR

VARCHAR2

Year the main engine was built. Unknown = 0000.

100

ENG2YR

VARCHAR2

Year the secondary engine was built. Unknown = 0000.

100

ENG1HSPR

NUMBER

Horsepower of the main engine. Unknown = null.

100

ENG2HSPR

NUMBER

Horsepower of the secondary engine. Unknown = null.

100

CORP

VARCHAR2

Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994

100

OWNTYPE

VARCHAR2

Type of vessel ownership. 0=unknown, 1=sole owner, 2 = partnership, 3 = fish firm owns, not captain, 4 = non-fish firm owns, not captain, 5 = sole ownership; not captain, 9 = other.

100

VESSCONS

VARCHAR2

Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other.

100

ENGMAINT

NUMBER

Repair and maintenance cost to the engine for the last twelve months. Unknown = null. Not collected prior to 2001; set to unknown.

100

FSHGRMAINT

NUMBER

Dollars spent of maintenance and repair of fishing gear in last 12 months. Null if unknown Not collected prior to 2001; set to unknown.

100

DCKGRMAINT

NUMBER

Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown.

100

PROCMAINT

NUMBER

Dollars spent on processing equipment maintenance or repair in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.

100

ELECTMAINT

NUMBER

Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown.

100

OTHERMAINT

NUMBER

Dollars spent on repairs and or maintenance to gear not accounted for on other categories. Null = unknown. Not collected prior to 2001; set to unknown.

100

ENGREPL

NUMBER

Dollars spent on engine replacement or addition in the last 12 months. Unknown = null.

100

FSHGRREPL

NUMBER

Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown.

100

DCKGRREPL

NUMBER

Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown.

100

PROCREPL

NUMBER

Dollars spent on processing equipment additions of replacement in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.

100

ELECTREPL

NUMBER

Cost of wheelhouse and gear mounted electronic equipment replaced or added on vessel in last 12 months, to the nearest dollar. Unknown = null.

100

OTHERREPL

NUMBER

Cost of other vessel parts repairs and/or maintenance made on vessel in the last 12 month period, to the nearest dollar. Unknown = null.

100

TRECOMMENTS

VARCHAR2

Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false.

100

TRPCOMMENTS

VARCHAR2

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

100

PERMIT1

VARCHAR2

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

100

PERMIT2

VARCHAR2

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

PROGRAM

CC ID: 335031

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

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

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

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

LINK1

CC ID: 335071

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	Yes
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

VTRSERNO

CC ID: 335072

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

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

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

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
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: 335032

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

YRBLT

CC ID: 335033

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Four digit year vessel was built.
General Data Type:	VARCHAR2

VESSLEN

CC ID: 335034

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Total length of the vessel, in whole feet.
General Data Type:	NUMBER

GRTONS

CC ID: 335035

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total gross registered tonnage of vessel, in whole tons.
General Data Type:	NUMBER

HOLDCAP

CC ID: 335036

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	7
Scale:	0
Status:	Active
Description:	Amount of fish that can be stored in vessel's hold, in whole pounds.
General Data Type:	NUMBER

FUELTYPE

CC ID: 335037

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2.
General Data Type:	VARCHAR2

INSHULL

CC ID: 335038

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Total annual cost of vessel owner's hull insurance coverage, to the nearest dollar. Not recorded prior to 5/1994; set to unknown.
General Data Type:	NUMBER

INSPI

CC ID: 335039

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Total annual cost of the vessel owner's insurance coverage for protection and indemnity, to the nearest dollar. Not collected prior to 5/1994; set to unknown.
General Data Type:	NUMBER

INSCOMBINED

CC ID: 335040

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar.
General Data Type:	NUMBER

ENG2EXIST

CC ID: 335041

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Secondary engine used on vessel for propulsion. 0=no; 1=yes, unknown = 9. Not recorded prior to 5/1994; set to unknown.
General Data Type:	VARCHAR2

ENG1YR

CC ID: 335043

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year the main engine was built. Unknown = 0000.
General Data Type:	VARCHAR2

ENG2YR

CC ID: 335044

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year the secondary engine was built. Unknown = 0000.
General Data Type:	VARCHAR2

ENG1HSPR

CC ID: 335045

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Horsepower of the main engine. Unknown = null.
General Data Type:	NUMBER

ENG2HSPR

CC ID: 335046

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Horsepower of the secondary engine. Unknown = null.
General Data Type:	NUMBER

CORP

CC ID: 335047

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994
General Data Type:	VARCHAR2

OWNTYPE

CC ID: 335048

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of vessel ownership. 0=unknown, 1=sole owner, 2 = partnership, 3 = fish firm owns, not captain, 4 = non-fish firm owns, not captain, 5 = sole ownership; not captain, 9 = other.
General Data Type:	VARCHAR2

VESSCONS

CC ID: 335049

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other.
General Data Type:	VARCHAR2

ENGMAINT

CC ID: 335050

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Repair and maintenance cost to the engine for the last twelve months. Unknown = null. Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

FSHGRMAINT

CC ID: 335051

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent of maintenance and repair of fishing gear in last 12 months. Null if unknown Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

DCKGRMAINT

CC ID: 335052

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

PROCMAINT

CC ID: 335054

Seq. Order:	30
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent on processing equipment maintenance or repair in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
General Data Type:	NUMBER

ELECTMAINT

CC ID: 335055

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown.
General Data Type:	NUMBER

OTHERMAINT

CC ID: 335056

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent on repairs and or maintenance to gear not accounted for on other categories. Null = unknown. Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

ENGREPL

CC ID: 335057

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent on engine replacement or addition in the last 12 months. Unknown = null.
General Data Type:	NUMBER

FSHGRREPL

CC ID: 335058

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown.
General Data Type:	NUMBER

DCKGRREPL

CC ID: 335059

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown.
General Data Type:	NUMBER

PROCREPL

CC ID: 335060

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Dollars spent on processing equipment additions of replacement in the last 12 months. Unknown = null. Unrecorded prior to 2001; set to unknown.
General Data Type:	NUMBER

ELECTREPL

CC ID: 335061

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Cost of wheelhouse and gear mounted electronic equipment replaced or added on vessel in last 12 months, to the nearest dollar. Unknown = null.
General Data Type:	NUMBER

OTHERREPL

CC ID: 335062

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Cost of other vessel parts repairs and/or maintenance made on vessel in the last 12 month period, to the nearest dollar. Unknown = null.
General Data Type:	NUMBER

TRECOMMENTS

CC ID: 335063

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false.
General Data Type:	VARCHAR2

TRPCOMMENTS

CC ID: 335065

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

Seq. Order:	41
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type:	VARCHAR2

PERMIT2

CC ID: 335067

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

DEALNUM

CC ID: 335068

Seq. Order:	43
Data Storage Type:	VARCHAR2
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: 335069

Seq. Order:	44
Data Storage Type:	VARCHAR2
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: 335070

Seq. Order:	45
Data Storage Type:	VARCHAR2
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:	33575
GUID:	gov.noaa.nmfs.inport:33575
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

PROGRAM

YEAR

MONTH

TRIPID

LINK1

VTRSERNO

FLEET_TYPE

SECTOR_ID

VENDOR_ID

HULLNUM1

YRBLT

VESSLEN

GRTONS

HOLDCAP

FUELTYPE

INSHULL

INSPI

INSCOMBINED

ENG2EXIST

ENG1YR

ENG2YR

ENG1HSPR

ENG2HSPR

CORP

OWNTYPE

VESSCONS

ENGMAINT

FSHGRMAINT

DCKGRMAINT

PROCMAINT

ELECTMAINT

OTHERMAINT

ENGREPL

FSHGRREPL

DCKGRREPL

PROCREPL

ELECTREPL

OTHERREPL

TRECOMMENTS

TRPCOMMENTS

PERMIT1

PERMIT2

DEALNUM

DEALISS_AGENCY

VMSCODE

Catalog Details