Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer Trip Economic Data from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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).

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 Details

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