Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Scallop Trip Summary Data from standard observer trips

Description

Observer Scallop Trip Summary Data from standard observer trips

Entity Information

Entity Type
Data View

Data Attribute / Type Description
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.
PROGRAM
VARCHAR2
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
CATSOAK
VARCHAR2
Scallop meats soaked in fluid other than water. 0=no; 1=yes
CATMIX
VARCHAR2
Indicator of whether scallop meats were mixed size. 0 = no, 1 = yes, 9 = unknown.
NBAGS
NUMBER
Total number of bags of shucked scallops for trip.
BAGAVGLB
NUMBER
Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown)
TRSCOMMENTS
VARCHAR2
Additional information regarding scallop trip. Prior to 2001 only true or false
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.
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.
VTRSERNO
VARCHAR2
Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number.
FLEET_TYPE
VARCHAR2
Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE.
SECTOR_ID
VARCHAR2
Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table.
VENDOR_ID
VARCHAR2
01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable.
HULLNUM1
VARCHAR2
Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable.
XTRIPDUR
NUMBER
The number of days the Captain expected to be away from port on fishing trip.
YEARSAIL
VARCHAR2
Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable.
MONTHSAIL
VARCHAR2
Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable.
DAYSAIL
VARCHAR2
The day the vessel left the dock to go fishing. Collected for ASM where applicable.
TIMESAIL
VARCHAR2
Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable.
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.
TRIPTYPE
VARCHAR2
Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear.
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
CREW
NUMBER
The number of individuals working on the vessel, including the Captain. Null = unknown.
YEARLAND
VARCHAR2
(Same as YEAR) Collected for ASM where applicable.
MONTHLAND
VARCHAR2
Month vessel landed for unloading catch. Collected for ASM where applicable.
DAYLAND
VARCHAR2
Day the vessel landed to off load catch. Collected for ASM where applicable.
TIMELAND
VARCHAR2
Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable.
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.
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.
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.
PORTSAIL
VARCHAR2
The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable.
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.
ICETONS
NUMBER
Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable.
FUELGAL
NUMBER
Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable.
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.
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.
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.
ICEPRICE
NUMBER
Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable.
FUELPRICE
NUMBER
Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable.
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.
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.
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.
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.
TIMELOST1
NUMBER
Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear.
TIMELOSTCD2
VARCHAR2
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST2
NUMBER
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear.
TIMELOSTCD3
VARCHAR2
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to
TIMELOST3
NUMBER
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear.
TIMELOSTCD4
VARCHAR2
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST4
NUMBER
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear.
TIMELOSTCD5
VARCHAR2
Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.
TIMELOST5
NUMBER
Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear.
TRPCOMMENTS
VARCHAR2
Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable.
PERMIT1
NUMBER
Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
PERMIT2
NUMBER
Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011).
DEALNUM
VARCHAR2
Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
DEALISS_AGENCY
VARCHAR2
Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011).
VMSCODE
VARCHAR2
VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011).

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: View: OBTRS
Short Name: OBTRS
Status: Completed
Abstract:

Observer Scallop Trip Summary Data from standard observer trips

Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

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

Observer Scallop Trip Summary Data from standard observer trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
CATSOAK VARCHAR2 Scallop meats soaked in fluid other than water. 0=no; 1=yes
100
CATMIX VARCHAR2 Indicator of whether scallop meats were mixed size. 0 = no, 1 = yes, 9 = unknown.
100
NBAGS NUMBER Total number of bags of shucked scallops for trip.
100
BAGAVGLB NUMBER Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown)
100
TRSCOMMENTS VARCHAR2 Additional information regarding scallop trip. Prior to 2001 only true or false
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
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
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
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

LINK1

CC ID: 335136
Seq. Order: 1
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: 335147
Seq. Order: 2
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: 335158
Seq. Order: 3
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: 335169
Seq. Order: 4
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: 335180
Seq. Order: 5
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

CATSOAK

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

Scallop meats soaked in fluid other than water. 0=no; 1=yes

General Data Type: VARCHAR2

CATMIX

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

Indicator of whether scallop meats were mixed size. 0 = no, 1 = yes, 9 = unknown.

General Data Type: VARCHAR2

NBAGS

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

Total number of bags of shucked scallops for trip.

General Data Type: NUMBER

BAGAVGLB

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

Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown)

General Data Type: NUMBER

TRSCOMMENTS

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

Additional information regarding scallop trip. Prior to 2001 only true or false

General Data Type: VARCHAR2

QTR

CC ID: 335138
Seq. Order: 11
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: 335139
Seq. Order: 12
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: 335140
Seq. Order: 13
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: 335141
Seq. Order: 14
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: 335142
Seq. Order: 15
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: 335143
Seq. Order: 16
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: 335144
Seq. Order: 17
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: 335145
Seq. Order: 18
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: 335146
Seq. Order: 19
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: 335148
Seq. Order: 20
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: 335149
Seq. Order: 21
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: 335150
Seq. Order: 22
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: 335151
Seq. Order: 23
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: 335152
Seq. Order: 24
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: 335153
Seq. Order: 25
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: 335154
Seq. Order: 26
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: 335155
Seq. Order: 27
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: 335156
Seq. Order: 28
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: 335157
Seq. Order: 29
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: 335159
Seq. Order: 30
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: 335160
Seq. Order: 31
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

TMPHPORT

CC ID: 335161
Seq. Order: 32
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: 335162
Seq. Order: 33
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: 335163
Seq. Order: 34
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

STEAMTIM

CC ID: 335164
Seq. Order: 35
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: 335165
Seq. Order: 36
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: 335166
Seq. Order: 37
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: 335167
Seq. Order: 38
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: 335168
Seq. Order: 39
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: 335170
Seq. Order: 40
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: 335171
Seq. Order: 41
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: 335172
Seq. Order: 42
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: 335173
Seq. Order: 43
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: 335174
Seq. Order: 44
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: 335175
Seq. Order: 45
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: 335176
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.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: 335177
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 for reason identified in timelostcd1 during trip using primary gear.

General Data Type: NUMBER

TIMELOSTCD2

CC ID: 335178
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.

General Data Type: VARCHAR2

TIMELOST2

CC ID: 335179
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 timelostcd2 during trip using primary gear.

General Data Type: NUMBER

TIMELOSTCD3

CC ID: 335181
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. Not recorded prior to

General Data Type: VARCHAR2

TIMELOST3

CC ID: 335182
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 timelostcd3 during trip using primary gear.

General Data Type: NUMBER

TIMELOSTCD4

CC ID: 335183
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

TIMELOST4

CC ID: 335184
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 timelostcd4 during trip using primary gear.

General Data Type: NUMBER

TIMELOSTCD5

CC ID: 335185
Seq. Order: 54
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: 335186
Seq. Order: 55
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

TRPCOMMENTS

CC ID: 335187
Seq. Order: 56
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: 335188
Seq. Order: 57
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: 335189
Seq. Order: 58
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: 335190
Seq. Order: 59
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: 335192
Seq. Order: 60
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: 335193
Seq. Order: 61
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: 33577
GUID: gov.noaa.nmfs.inport:33577
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