Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer Preliminary Database (OBPRELIM) >

View: OPTRP

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

Item Identification

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 Information

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

Data Attributes

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 Details

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