View: OBTRE
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33575
| Published / External
Created: 2016-07-27
|
Last Modified: 2022-08-09
Parent: Observer and At Sea Monitor Database (OBDBS)
Data Set (DS) | ID: 24111
Data Set (DS) | ID: 24111
ID: 33575
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | View: OBTRE |
|---|---|
| Short Name | OBTRE |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Observer Trip Economic Data from standard observer trips |
| * Purpose | |
| Notes |
Loaded by batch 9053, 07-27-2016 19:10 |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data View |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | OBDBS |
| » Description |
Observer Trip Economic Data from standard observer trips |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
| 100 | No | No | YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
| 100 | No | No | MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
| 100 | No | No | 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 | Yes | No | 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 | No | No | 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 | No | No | FLEET_TYPE | VARCHAR2 | Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. |
| 100 | No | No | 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 | Yes | No | 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 | No | No | HULLNUM1 | VARCHAR2 | Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable. |
| 100 | No | No | YRBLT | VARCHAR2 | Four digit year vessel was built. |
| 100 | No | No | VESSLEN | NUMBER | Total length of the vessel, in whole feet. |
| 100 | No | No | GRTONS | NUMBER | Total gross registered tonnage of vessel, in whole tons. |
| 100 | No | No | HOLDCAP | NUMBER | Amount of fish that can be stored in vessel's hold, in whole pounds. |
| 100 | No | No | FUELTYPE | VARCHAR2 | Type of fuel used to power vessel's engine. 0=unknown,1=gasoline, 2=diesel, 3=number 2. |
| 100 | No | No | 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 | No | No | 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 | No | No | INSCOMBINED | NUMBER | Combined total cost of vessel owner's hull, protection and indemnity coverage,to the nearest dollar. |
| 100 | No | No | 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 | No | No | ENG1YR | VARCHAR2 | Year the main engine was built. Unknown = 0000. |
| 100 | No | No | ENG2YR | VARCHAR2 | Year the secondary engine was built. Unknown = 0000. |
| 100 | No | No | ENG1HSPR | NUMBER | Horsepower of the main engine. Unknown = null. |
| 100 | No | No | ENG2HSPR | NUMBER | Horsepower of the secondary engine. Unknown = null. |
| 100 | No | No | CORP | VARCHAR2 | Indicator of whether the vessel is owned by corporation. 0=no; 1=yes. Not collected prior to 5/1994 |
| 100 | No | No | 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 | No | No | VESSCONS | VARCHAR2 | Type of material used for hull construction. 0 = unknown, 1 = wood, 2 = steel, 3 = composition, 7 = aluminium, 8 = fiberglass, 9 = other. |
| 100 | No | No | 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 | No | No | 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 | No | No | DCKGRMAINT | NUMBER | Costs of Deck gear maintenace for the previous 12 months. Not collected prior to 2001; set to unknown. |
| 100 | No | No | 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 | No | No | ELECTMAINT | NUMBER | Costs to maintain or repair electrical gear in last 12 months. Unknown = null. Not collected prior to 2001. Set to unknown. |
| 100 | No | No | 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 | No | No | ENGREPL | NUMBER | Dollars spent on engine replacement or addition in the last 12 months. Unknown = null. |
| 100 | No | No | FSHGRREPL | NUMBER | Dollars spent on replacment or additions to fishing gear in last 12 months. Null = unknown. |
| 100 | No | No | DCKGRREPL | NUMBER | Costs of Deck gear replacement for the previous 12 months; not collected prior to 5/1994; set to unknown. |
| 100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | TRECOMMENTS | VARCHAR2 | Additional information regarding fields on Six-month question / trip economic log. Prior to 2001 only true or false. |
| 100 | No | No | TRPCOMMENTS | VARCHAR2 | Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable. |
| 100 | No | No | PERMIT1 | VARCHAR2 | Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
| 100 | No | No | PERMIT2 | VARCHAR2 | Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). |
| 100 | No | No | DEALNUM | VARCHAR2 | Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
| 100 | No | No | DEALISS_AGENCY | VARCHAR2 | Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011). |
| 100 | No | No | VMSCODE | VARCHAR2 | VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011). |
Attribute Details
| Attribute Name | PROGRAM |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YEAR |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MONTH |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRIPID |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LINK1 |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VTRSERNO |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLEET_TYPE |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SECTOR_ID |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VENDOR_ID |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HULLNUM1 |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | VARCHAR2 |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YRBLT |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Four digit year vessel was built. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VESSLEN |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Total length of the vessel, in whole feet. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GRTONS |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HOLDCAP |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FUELTYPE |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | INSHULL |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | INSPI |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | INSCOMBINED |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENG2EXIST |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENG1YR |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year the main engine was built. Unknown = 0000. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENG2YR |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year the secondary engine was built. Unknown = 0000. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENG1HSPR |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Horsepower of the main engine. Unknown = null. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENG2HSPR |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Horsepower of the secondary engine. Unknown = null. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CORP |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OWNTYPE |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VESSCONS |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENGMAINT |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FSHGRMAINT |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DCKGRMAINT |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PROCMAINT |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ELECTMAINT |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OTHERMAINT |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENGREPL |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FSHGRREPL |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DCKGRREPL |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PROCREPL |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ELECTREPL |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OTHERREPL |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRECOMMENTS |
|---|---|
| Seq. Order | 39 |
| Data Storage Type | VARCHAR2 |
| Max Length | 250 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRPCOMMENTS |
|---|---|
| Seq. Order | 40 |
| Data Storage Type | VARCHAR2 |
| Max Length | 250 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERMIT1 |
|---|---|
| Seq. Order | 41 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERMIT2 |
|---|---|
| Seq. Order | 42 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEALNUM |
|---|---|
| Seq. Order | 43 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEALISS_AGENCY |
|---|---|
| Seq. Order | 44 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VMSCODE |
|---|---|
| Seq. Order | 45 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 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 Workflow State | Published / External |
| Metadata Last Review Date | 2016-07-28 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2017-07-28 |
| Tags |
|---|