View: OBTRP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33576 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: OBTRP |
---|---|
Short Name: | OBTRP |
Status: | Completed |
Abstract: |
Observer Vessel-Trip Logs |
Notes: |
Loaded by batch 9053, 07-27-2016 19:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Vessel-Trip Logs |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
GEARCAT | VARCHAR2 | Gear category code, see support table OBGEAR. Collected for ASM where applicable. | |
100
|
LINK1 | VARCHAR2 | 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. | |
100
|
PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. | |
100
|
YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. | |
100
|
MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. | |
100
|
TRIPID | VARCHAR2 | May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. | |
100
|
QTR | NUMBER | Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable. | |
100
|
TRIPEXT | VARCHAR2 | Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. | |
100
|
VTRSERNO | VARCHAR2 | Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number. | |
100
|
FLEET_TYPE | VARCHAR2 | Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. | |
100
|
SECTOR_ID | VARCHAR2 | Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table. | |
100
|
VENDOR_ID | VARCHAR2 | 01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable. | |
100
|
HULLNUM1 | VARCHAR2 | Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable. | |
100
|
XTRIPDUR | NUMBER | The number of days the Captain expected to be away from port on fishing trip. | |
100
|
YEARSAIL | VARCHAR2 | Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable. | |
100
|
MONTHSAIL | VARCHAR2 | Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable. | |
100
|
DAYSAIL | VARCHAR2 | The day the vessel left the dock to go fishing. Collected for ASM where applicable. | |
100
|
TIMESAIL | VARCHAR2 | Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable. | |
100
|
DATESAIL | DATE | The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. | |
100
|
TRIPTYPE | VARCHAR2 | Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear. | |
100
|
HULLNUM2 | VARCHAR2 | Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown | |
100
|
CREW | NUMBER | The number of individuals working on the vessel, including the Captain. Null = unknown. | |
100
|
YEARLAND | VARCHAR2 | (Same as YEAR) Collected for ASM where applicable. | |
100
|
MONTHLAND | VARCHAR2 | Month vessel landed for unloading catch. Collected for ASM where applicable. | |
100
|
DAYLAND | VARCHAR2 | Day the vessel landed to off load catch. Collected for ASM where applicable. | |
100
|
TIMELAND | VARCHAR2 | Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable. | |
100
|
DATELAND | DATE | Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. | |
100
|
DA | NUMBER | Computed field indicating number of day's absent on the trip; dateland - datesail + 1. | |
100
|
TMPHPORT | VARCHAR2 | 4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch. | |
100
|
PORT | VARCHAR2 | The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable. | |
100
|
PORTSAIL | VARCHAR2 | The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable. | |
100
|
STATE | VARCHAR2 | 2-character state code (from PORT). Collected for ASM where applicable. | |
100
|
STEAMTIM | NUMBER | Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable. | |
100
|
ICETONS | NUMBER | Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable. | |
100
|
FUELGAL | NUMBER | Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable. | |
100
|
DAMAGCOST | NUMBER | Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. | |
100
|
SUPPLYCOST | NUMBER | Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable. | |
100
|
FOODCOST | NUMBER | Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. | |
100
|
ICEPRICE | NUMBER | Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable. | |
100
|
FUELPRICE | NUMBER | Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable. | |
100
|
WATERCOST | NUMBER | Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. | |
100
|
OILCOST | NUMBER | Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. | |
100
|
BAITCOST | NUMBER | Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. | |
100
|
TIMELOSTCD1 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost. | |
100
|
TIMELOST1 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear. | |
100
|
TIMELOSTCD2 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. | |
100
|
TIMELOST2 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear. | |
100
|
TIMELOSTCD3 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to | |
100
|
TIMELOST3 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear. | |
100
|
TIMELOSTCD4 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. | |
100
|
TIMELOST4 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear. | |
100
|
TIMELOSTCD5 | VARCHAR2 | Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. | |
100
|
TIMELOST5 | NUMBER | Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear. | |
100
|
DOL | DATE | Date of loading the data to the master tables | |
100
|
TRPCOMMENTS | VARCHAR2 | Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable. | |
100
|
PERMIT1 | NUMBER | Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. | |
100
|
PERMIT2 | NUMBER | Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). | |
100
|
DEALNUM | VARCHAR2 | Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. | |
100
|
DEALISS_AGENCY | VARCHAR2 | Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011). | |
100
|
VMSCODE | VARCHAR2 | VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011). |
Attribute Details
GEARCAT
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Gear category code, see support table OBGEAR. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
LINK1
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
PROGRAM
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TRIPID
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
QTR
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable. |
General Data Type: | NUMBER |
TRIPEXT
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
VTRSERNO
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number. |
General Data Type: | VARCHAR2 |
FLEET_TYPE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. |
General Data Type: | VARCHAR2 |
SECTOR_ID
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table. |
General Data Type: | VARCHAR2 |
VENDOR_ID
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
HULLNUM1
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
XTRIPDUR
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
The number of days the Captain expected to be away from port on fishing trip. |
General Data Type: | NUMBER |
YEARSAIL
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
MONTHSAIL
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
DAYSAIL
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The day the vessel left the dock to go fishing. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TIMESAIL
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
DATESAIL
Seq. Order: | 19 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
General Data Type: | DATE |
TRIPTYPE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear. |
General Data Type: | VARCHAR2 |
HULLNUM2
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown |
General Data Type: | VARCHAR2 |
CREW
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
The number of individuals working on the vessel, including the Captain. Null = unknown. |
General Data Type: | NUMBER |
YEARLAND
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
(Same as YEAR) Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
MONTHLAND
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month vessel landed for unloading catch. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
DAYLAND
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day the vessel landed to off load catch. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TIMELAND
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
DATELAND
Seq. Order: | 27 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. |
General Data Type: | DATE |
DA
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Computed field indicating number of day's absent on the trip; dateland - datesail + 1. |
General Data Type: | NUMBER |
TMPHPORT
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch. |
General Data Type: | VARCHAR2 |
PORT
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
PORTSAIL
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
STATE
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-character state code (from PORT). Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
STEAMTIM
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable. |
General Data Type: | NUMBER |
ICETONS
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable. |
General Data Type: | NUMBER |
FUELGAL
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
DAMAGCOST
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
SUPPLYCOST
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
FOODCOST
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
ICEPRICE
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable. |
General Data Type: | NUMBER |
FUELPRICE
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 2 |
Status: | Active |
Description: |
Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
WATERCOST
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
OILCOST
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
BAITCOST
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. |
General Data Type: | NUMBER |
TIMELOSTCD1
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost. |
General Data Type: | VARCHAR2 |
TIMELOST1
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear. |
General Data Type: | NUMBER |
TIMELOSTCD2
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type: | VARCHAR2 |
TIMELOST2
Seq. Order: | 47 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear. |
General Data Type: | NUMBER |
TIMELOSTCD3
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to |
General Data Type: | VARCHAR2 |
TIMELOST3
Seq. Order: | 49 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear. |
General Data Type: | NUMBER |
TIMELOSTCD4
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type: | VARCHAR2 |
TIMELOST4
Seq. Order: | 51 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear. |
General Data Type: | NUMBER |
TIMELOSTCD5
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. |
General Data Type: | VARCHAR2 |
TIMELOST5
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear. |
General Data Type: | NUMBER |
DOL
Seq. Order: | 54 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of loading the data to the master tables |
General Data Type: | DATE |
TRPCOMMENTS
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
PERMIT1
Seq. Order: | 56 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
General Data Type: | NUMBER |
PERMIT2
Seq. Order: | 57 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). |
General Data Type: | NUMBER |
DEALNUM
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
DEALISS_AGENCY
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011). |
General Data Type: | VARCHAR2 |
VMSCODE
Seq. Order: | 60 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011). |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33576 |
---|---|
GUID: | gov.noaa.nmfs.inport:33576 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-27 19:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-28 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-28 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-28 |