Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > OBPRELIM Observer Preliminary Data System >

View: OPTRP

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33365 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Preliminary Observer Vessel-Trip Logs

Description

Preliminary Observer Vessel-Trip Logs

Entity Type
Data View

Data Attribute / Type	Description
LINK1 VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
PROGRAM VARCHAR2	Code identifying program under which data was collected. First 3 digits of LINK1. See OBPROGRAM.
YEAR VARCHAR2	Year landed. Characters 4-7 of LINK1.
MONTH VARCHAR2	Month landed. Characters 8-9 of LINK1.
TRIPID VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
TRIPEXT VARCHAR2	Level of sampling of discards in the gillnet fishery, or whether or not the trip was aborted. See OBDBS.OBTRIPEXT.
FLEET_TYPE VARCHAR2	Identify limited access/general category scallop trips, carrier and processor vessels. See OBDBS.OBFLEET_TYPE
HULLNUM1 VARCHAR2	Hull number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
PERMIT1 NUMBER	Permit number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
DATESAIL DATE	The month, day, year and time (24HH:mm) the vessel left the dock to go fishing.
PORTSAIL VARCHAR2	6-character port code, including state, from which the vessel sailed. See OBDBS.PORT.
VENDOR_ID VARCHAR2	2-character vendor code to distinguish vendor the observer works for. See OBDBS.OBSVENDOR.
NEGEAR VARCHAR2	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
NEGEAR2 VARCHAR2	Northeast gear code. Secondary gear used on trip. See OBGEAR.
TARGSPEC1 VARCHAR2	NESPP4 for the primary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
TARGSPEC2 VARCHAR2	NESPP4 for the secondary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
DATELAND DATE	The month, day, year and time (24HH:mm) the vessel returned to the dock from fishing.
PORT VARCHAR2	6-character port code, including state, from which the vessel offloads its catch. See OBDBS.PORT.
VTRSERNO NUMBER	Either the Serial number from the Vessel Trip Report or the eVTR number.
DEALNUM VARCHAR2	Dealer number. See OBDBS.OBDEALER_MV.
PRIMSPLAND VARCHAR2	Primary species landed on the trip. See OBDBS.OBSPEC.
TRIPHAULS NUMBER	Total number of hauls that occurred on the trip.
AREA VARCHAR2	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
LONGFIN_FLAG VARCHAR2	Indicates whether the trip caught more than 2500 lbs of Longfin squid; 1 = Yes, 0 = No.
TRPCOMMENTS VARCHAR2	Any additional information regarding the trip.

Data Attribute / Type

Description

LINK1
VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

PROGRAM
VARCHAR2

Code identifying program under which data was collected. First 3 digits of LINK1. See OBPROGRAM.

YEAR
VARCHAR2

Year landed. Characters 4-7 of LINK1.

MONTH
VARCHAR2

Month landed. Characters 8-9 of LINK1.

TRIPID
VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

TRIPEXT
VARCHAR2

Level of sampling of discards in the gillnet fishery, or whether or not the trip was aborted. See OBDBS.OBTRIPEXT.

FLEET_TYPE
VARCHAR2

Identify limited access/general category scallop trips, carrier and processor vessels. See OBDBS.OBFLEET_TYPE

HULLNUM1
VARCHAR2

Hull number of vessel on which observer is deployed. See OBDBS.OBVESSEL.

PERMIT1
NUMBER

Permit number of vessel on which observer is deployed. See OBDBS.OBVESSEL.

DATESAIL
DATE

The month, day, year and time (24HH:mm) the vessel left the dock to go fishing.

PORTSAIL
VARCHAR2

6-character port code, including state, from which the vessel sailed. See OBDBS.PORT.

VENDOR_ID
VARCHAR2

2-character vendor code to distinguish vendor the observer works for. See OBDBS.OBSVENDOR.

NEGEAR
VARCHAR2

Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.

NEGEAR2
VARCHAR2

Northeast gear code. Secondary gear used on trip. See OBGEAR.

TARGSPEC1
VARCHAR2

NESPP4 for the primary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.

TARGSPEC2
VARCHAR2

NESPP4 for the secondary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.

DATELAND
DATE

The month, day, year and time (24HH:mm) the vessel returned to the dock from fishing.

PORT
VARCHAR2

6-character port code, including state, from which the vessel offloads its catch. See OBDBS.PORT.

VTRSERNO
NUMBER

Either the Serial number from the Vessel Trip Report or the eVTR number.

DEALNUM
VARCHAR2

Dealer number. See OBDBS.OBDEALER_MV.

PRIMSPLAND
VARCHAR2

Primary species landed on the trip. See OBDBS.OBSPEC.

TRIPHAULS
NUMBER

Total number of hauls that occurred on the trip.

AREA
VARCHAR2

Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.

LONGFIN_FLAG
VARCHAR2

Indicates whether the trip caught more than 2500 lbs of Longfin squid; 1 = Yes, 0 = No.

TRPCOMMENTS
VARCHAR2

Any additional information regarding the trip.

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OPTRP
Short Name:	OPTRP
Status:	Completed
Abstract:	Preliminary Observer Vessel-Trip Logs
Notes:	Loaded by batch 8952, 07-06-2016 15:07

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBPRELIM
Description:	Preliminary Observer Vessel-Trip Logs

Attribute Summary

	Name	Type	Description
100	LINK1	VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
100	PROGRAM	VARCHAR2	Code identifying program under which data was collected. First 3 digits of LINK1. See OBPROGRAM.
100	YEAR	VARCHAR2	Year landed. Characters 4-7 of LINK1.
100	MONTH	VARCHAR2	Month landed. Characters 8-9 of LINK1.
100	TRIPID	VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
100	TRIPEXT	VARCHAR2	Level of sampling of discards in the gillnet fishery, or whether or not the trip was aborted. See OBDBS.OBTRIPEXT.
100	FLEET_TYPE	VARCHAR2	Identify limited access/general category scallop trips, carrier and processor vessels. See OBDBS.OBFLEET_TYPE
100	HULLNUM1	VARCHAR2	Hull number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
100	PERMIT1	NUMBER	Permit number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
100	DATESAIL	DATE	The month, day, year and time (24HH:mm) the vessel left the dock to go fishing.
100	PORTSAIL	VARCHAR2	6-character port code, including state, from which the vessel sailed. See OBDBS.PORT.
100	VENDOR_ID	VARCHAR2	2-character vendor code to distinguish vendor the observer works for. See OBDBS.OBSVENDOR.
100	NEGEAR	VARCHAR2	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
100	NEGEAR2	VARCHAR2	Northeast gear code. Secondary gear used on trip. See OBGEAR.
100	TARGSPEC1	VARCHAR2	NESPP4 for the primary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
100	TARGSPEC2	VARCHAR2	NESPP4 for the secondary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
100	DATELAND	DATE	The month, day, year and time (24HH:mm) the vessel returned to the dock from fishing.
100	PORT	VARCHAR2	6-character port code, including state, from which the vessel offloads its catch. See OBDBS.PORT.
100	VTRSERNO	NUMBER	Either the Serial number from the Vessel Trip Report or the eVTR number.
100	DEALNUM	VARCHAR2	Dealer number. See OBDBS.OBDEALER_MV.
100	PRIMSPLAND	VARCHAR2	Primary species landed on the trip. See OBDBS.OBSPEC.
100	TRIPHAULS	NUMBER	Total number of hauls that occurred on the trip.
100	AREA	VARCHAR2	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
100	LONGFIN_FLAG	VARCHAR2	Indicates whether the trip caught more than 2500 lbs of Longfin squid; 1 = Yes, 0 = No.
100	TRPCOMMENTS	VARCHAR2	Any additional information regarding the trip.

Name

Type

Description

100

LINK1

VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

100

PROGRAM

VARCHAR2

Code identifying program under which data was collected. First 3 digits of LINK1. See OBPROGRAM.

100

YEAR

VARCHAR2

Year landed. Characters 4-7 of LINK1.

100

MONTH

VARCHAR2

Month landed. Characters 8-9 of LINK1.

100

TRIPID

VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

100

TRIPEXT

VARCHAR2

Level of sampling of discards in the gillnet fishery, or whether or not the trip was aborted. See OBDBS.OBTRIPEXT.

100

FLEET_TYPE

VARCHAR2

Identify limited access/general category scallop trips, carrier and processor vessels. See OBDBS.OBFLEET_TYPE

100

HULLNUM1

VARCHAR2

Hull number of vessel on which observer is deployed. See OBDBS.OBVESSEL.

100

PERMIT1

NUMBER

Permit number of vessel on which observer is deployed. See OBDBS.OBVESSEL.

100

DATESAIL

DATE

The month, day, year and time (24HH:mm) the vessel left the dock to go fishing.

100

PORTSAIL

VARCHAR2

6-character port code, including state, from which the vessel sailed. See OBDBS.PORT.

100

VENDOR_ID

VARCHAR2

2-character vendor code to distinguish vendor the observer works for. See OBDBS.OBSVENDOR.

100

NEGEAR

VARCHAR2

Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.

100

NEGEAR2

VARCHAR2

Northeast gear code. Secondary gear used on trip. See OBGEAR.

100

TARGSPEC1

VARCHAR2

NESPP4 for the primary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.

100

TARGSPEC2

VARCHAR2

NESPP4 for the secondary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.

100

DATELAND

DATE

The month, day, year and time (24HH:mm) the vessel returned to the dock from fishing.

100

PORT

VARCHAR2

6-character port code, including state, from which the vessel offloads its catch. See OBDBS.PORT.

100

VTRSERNO

NUMBER

Either the Serial number from the Vessel Trip Report or the eVTR number.

100

DEALNUM

VARCHAR2

Dealer number. See OBDBS.OBDEALER_MV.

100

PRIMSPLAND

VARCHAR2

Primary species landed on the trip. See OBDBS.OBSPEC.

100

TRIPHAULS

NUMBER

Total number of hauls that occurred on the trip.

100

AREA

VARCHAR2

Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.

100

LONGFIN_FLAG

VARCHAR2

Indicates whether the trip caught more than 2500 lbs of Longfin squid; 1 = Yes, 0 = No.

100

TRPCOMMENTS

VARCHAR2

Any additional information regarding the trip.

Attribute Details

LINK1

CC ID: 331425

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
General Data Type:	VARCHAR2

PROGRAM

CC ID: 331436

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code identifying program under which data was collected. First 3 digits of LINK1. See OBPROGRAM.
General Data Type:	VARCHAR2

YEAR

CC ID: 331443

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Year landed. Characters 4-7 of LINK1.
General Data Type:	VARCHAR2

MONTH

CC ID: 331444

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Month landed. Characters 8-9 of LINK1.
General Data Type:	VARCHAR2

TRIPID

CC ID: 331445

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
General Data Type:	VARCHAR2

TRIPEXT

CC ID: 331446

Seq. Order:	6
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 the trip was aborted. See OBDBS.OBTRIPEXT.
General Data Type:	VARCHAR2

FLEET_TYPE

CC ID: 331447

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Identify limited access/general category scallop trips, carrier and processor vessels. See OBDBS.OBFLEET_TYPE
General Data Type:	VARCHAR2

HULLNUM1

CC ID: 331448

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Hull number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
General Data Type:	VARCHAR2

PERMIT1

CC ID: 331449

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Permit number of vessel on which observer is deployed. See OBDBS.OBVESSEL.
General Data Type:	NUMBER

DATESAIL

CC ID: 331426

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The month, day, year and time (24HH:mm) the vessel left the dock to go fishing.
General Data Type:	DATE

PORTSAIL

CC ID: 331427

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character port code, including state, from which the vessel sailed. See OBDBS.PORT.
General Data Type:	VARCHAR2

VENDOR_ID

CC ID: 331428

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	2-character vendor code to distinguish vendor the observer works for. See OBDBS.OBSVENDOR.
General Data Type:	VARCHAR2

NEGEAR

CC ID: 331429

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR.
General Data Type:	VARCHAR2

NEGEAR2

CC ID: 331430

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast gear code. Secondary gear used on trip. See OBGEAR.
General Data Type:	VARCHAR2

TARGSPEC1

CC ID: 331431

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	NESPP4 for the primary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
General Data Type:	VARCHAR2

TARGSPEC2

CC ID: 331432

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 for the secondary species named by the captain as targeted for the trip. See OBDBS.OBSPEC.
General Data Type:	VARCHAR2

DATELAND

CC ID: 331433

Seq. Order:	17
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The month, day, year and time (24HH:mm) the vessel returned to the dock from fishing.
General Data Type:	DATE

PORT

CC ID: 331434

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character port code, including state, from which the vessel offloads its catch. See OBDBS.PORT.
General Data Type:	VARCHAR2

VTRSERNO

CC ID: 331435

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	16
Scale:	0
Status:	Active
Description:	Either the Serial number from the Vessel Trip Report or the eVTR number.
General Data Type:	NUMBER

DEALNUM

CC ID: 331437

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Dealer number. See OBDBS.OBDEALER_MV.
General Data Type:	VARCHAR2

PRIMSPLAND

CC ID: 331438

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Primary species landed on the trip. See OBDBS.OBSPEC.
General Data Type:	VARCHAR2

TRIPHAULS

CC ID: 331439

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Total number of hauls that occurred on the trip.
General Data Type:	NUMBER

AREA

CC ID: 331440

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul.
General Data Type:	VARCHAR2

LONGFIN_FLAG

CC ID: 331441

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether the trip caught more than 2500 lbs of Longfin squid; 1 = Yes, 0 = No.
General Data Type:	VARCHAR2

TRPCOMMENTS

CC ID: 331442

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Any additional information regarding the trip.
General Data Type:	VARCHAR2

Catalog Item ID:	33365
GUID:	gov.noaa.nmfs.inport:33365
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 15:07+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-27
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-27
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-27

View: OPTRP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK1

PROGRAM

YEAR

MONTH

TRIPID

TRIPEXT

FLEET_TYPE

HULLNUM1

PERMIT1

DATESAIL

PORTSAIL

VENDOR_ID

NEGEAR

NEGEAR2

TARGSPEC1

TARGSPEC2

DATELAND

PORT

VTRSERNO

DEALNUM

PRIMSPLAND

TRIPHAULS

AREA

LONGFIN_FLAG

TRPCOMMENTS

Catalog Details