Slide Menu
Search Help Show/Hide Menu

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

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

CC ID: 335076
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

LINK1

CC ID: 335087
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

PROGRAM

CC ID: 335098
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

YEAR

CC ID: 335109
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

MONTH

CC ID: 335120
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TRIPID

CC ID: 335131
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

QTR

CC ID: 335133
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

TRIPEXT

CC ID: 335134
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

VTRSERNO

CC ID: 335135
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

FLEET_TYPE

CC ID: 335077
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

SECTOR_ID

CC ID: 335078
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

VENDOR_ID

CC ID: 335079
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

HULLNUM1

CC ID: 335080
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

XTRIPDUR

CC ID: 335081
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

YEARSAIL

CC ID: 335082
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

MONTHSAIL

CC ID: 335083
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

DAYSAIL

CC ID: 335084
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMESAIL

CC ID: 335085
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

DATESAIL

CC ID: 335086
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: DATE

TRIPTYPE

CC ID: 335088
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

HULLNUM2

CC ID: 335089
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

CREW

CC ID: 335090
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

YEARLAND

CC ID: 335091
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

(Same as YEAR) Collected for ASM where applicable.

General Data Type: VARCHAR2

MONTHLAND

CC ID: 335092
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

DAYLAND

CC ID: 335093
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELAND

CC ID: 335094
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

DATELAND

CC ID: 335095
Seq. Order: 27
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: DATE

DA

CC ID: 335096
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

TMPHPORT

CC ID: 335097
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

PORT

CC ID: 335099
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

PORTSAIL

CC ID: 335100
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

STATE

CC ID: 335101
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

STEAMTIM

CC ID: 335102
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

ICETONS

CC ID: 335103
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

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

General Data Type: NUMBER

FUELGAL

CC ID: 335104
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

DAMAGCOST

CC ID: 335105
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

SUPPLYCOST

CC ID: 335106
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

FOODCOST

CC ID: 335107
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

ICEPRICE

CC ID: 335108
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

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

General Data Type: NUMBER

FUELPRICE

CC ID: 335110
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

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

General Data Type: NUMBER

WATERCOST

CC ID: 335111
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

OILCOST

CC ID: 335112
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

BAITCOST

CC ID: 335113
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

TIMELOSTCD1

CC ID: 335114
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELOST1

CC ID: 335115
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

TIMELOSTCD2

CC ID: 335116
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELOST2

CC ID: 335117
Seq. Order: 47
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

TIMELOSTCD3

CC ID: 335118
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELOST3

CC ID: 335119
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

TIMELOSTCD4

CC ID: 335121
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELOST4

CC ID: 335122
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

TIMELOSTCD5

CC ID: 335123
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TIMELOST5

CC ID: 335124
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

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

General Data Type: NUMBER

DOL

CC ID: 335125
Seq. Order: 54
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of loading the data to the master tables

General Data Type: DATE

TRPCOMMENTS

CC ID: 335126
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

PERMIT1

CC ID: 335127
Seq. Order: 56
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

PERMIT2

CC ID: 335128
Seq. Order: 57
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

DEALNUM

CC ID: 335129
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

DEALISS_AGENCY

CC ID: 335130
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

VMSCODE

CC ID: 335132
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

Catalog 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