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

Summary

Abstract

At Sea Monitor trip and vessel data

Description

At Sea Monitor trip and vessel data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
GEARCAT
VARCHAR2
Gear category code, see support table OBGEAR. Collected for ASM where applicable.
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.
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.
DA
NUMBER
Computed field indicating number of day's absent on the trip; dateland - datesail + 1.
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.
STATE
VARCHAR2
2-character state code (from PORT). 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.
DOL
DATE
Date of loading the data to the master tables
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).
ASMTEST_STATUS
VARCHAR2
Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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: ASMTRP
Short Name: ASMTRP
Status: Completed
Abstract:

At Sea Monitor trip and vessel data

Notes:

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

Entity Information

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

At Sea Monitor trip and vessel data

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).
100
ASMTEST_STATUS VARCHAR2 Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

GEARCAT

CC ID: 334166
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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: 334177
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

PROGRAM

CC ID: 334188
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: 334199
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: 334210
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: 334221
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: 334224
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: 334225
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
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: 334226
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: 334167
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: 334168
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: 334169
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

HULLNUM1

CC ID: 334170
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
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: 334171
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: 334172
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
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: 334173
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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: 334174
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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: 334175
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: 334176
Seq. Order: 19
Data Storage Type: DATE
Max Length: 8
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: 334178
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: 334179
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: 334180
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: 334181
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

(Same as YEAR) Collected for ASM where applicable.

General Data Type: VARCHAR2

MONTHLAND

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

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

General Data Type: VARCHAR2

DAYLAND

CC ID: 334183
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
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: 334184
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: 334185
Seq. Order: 27
Data Storage Type: DATE
Max Length: 8
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: 334186
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: 334187
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: 334189
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
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: 334190
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
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: 334191
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: 334192
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: 334193
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: 334194
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: 334195
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: 334196
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: 334197
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: 334198
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: 334200
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: 334201
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: 334202
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: 334203
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: 334204
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: 334205
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: 334206
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: 334207
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: 334208
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: 334209
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: 334211
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: 334212
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: 334213
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: 334214
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: 334215
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: 334216
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: 334217
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: 334218
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: 334219
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: 334220
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: 334222
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

ASMTEST_STATUS

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

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33557
GUID: gov.noaa.nmfs.inport:33557
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