Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBPRH

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

Item Identification

Title:	View: OBPRH
Short Name:	OBPRH
Status:	Completed
Abstract:	Observer Pair Trawl Hauls
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Pair Trawl Hauls

Data Attributes

Attribute Summary

	Name	Type	Description
100	LINK3	VARCHAR2	Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100	LINK4	VARCHAR2	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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	HAULNUM	VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100	GEARNUM	VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100	TOWSPEED	NUMBER	Average towing speed over bottom, to nearest 10th of knot.
100	WIREOUT	NUMBER	Amount of wire paid out for haul, in whole fathoms.
100	HRDEPMIN	NUMBER	Shallowest depth from surface the headrope fished, in whole fathoms.
100	HRDEPMAX	NUMBER	Deepest depth from surface the headrope fished, in whole fathoms.
100	DISTMIN	NUMBER	Shortest distance between two boats while fishing, in whole feet.
100	DISTMAX	NUMBER	Longest distance between two boats while fishing, in whole feet.
100	PUMPBEGINYEAR	VARCHAR2	Year in local time that fish pumping is attached to codend and initially turned on
100	PUMPBEGINMONTH	VARCHAR2	Month in local time that fish pumping is attached to codend and initially turned on
100	PUMPBEGINDAY	VARCHAR2	Day in local time that fish pumping is attached to codend and initially turned on
100	PUMPBEGINTIME	VARCHAR2	Time in local time that fish pumping is attached to codend and initially turned on
100	PUMPENDYEAR	VARCHAR2	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
100	PUMPENDMONTH	VARCHAR2	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
100	PUMPENDDAY	VARCHAR2	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
100	PUMPENDTIME	VARCHAR2	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
100	NTURNS	NUMBER	Number of turns > 90 degrees in haul; begun 3/2007
100	NETOVERT	NUMBER	Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
100	NETOHORIZ	NUMBER	Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
100	DOORSPREAD	NUMBER	Average distance between the doors while fishing; whole feet; begun 3/2007
100	PRHCOMMENTS	VARCHAR2	Additional information re: PaiR trawl Haul.
100	DOE	DATE	Date of Entry of the associated record.
100	UOE	VARCHAR2	Oracle user ID of the person who entered the data.
100	DOC	DATE	Date associated record was updated.
100	UOC	VARCHAR2	Oracle ID of user who made the (most recent ) change on the record.

Name

Type

Description

100

LINK3

VARCHAR2

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.

100

LINK4

VARCHAR2

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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

HAULNUM

VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

100

GEARNUM

VARCHAR2

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

100

TOWSPEED

NUMBER

Average towing speed over bottom, to nearest 10th of knot.

100

WIREOUT

NUMBER

Amount of wire paid out for haul, in whole fathoms.

100

HRDEPMIN

NUMBER

Shallowest depth from surface the headrope fished, in whole fathoms.

100

HRDEPMAX

NUMBER

Deepest depth from surface the headrope fished, in whole fathoms.

100

DISTMIN

NUMBER

Shortest distance between two boats while fishing, in whole feet.

100

DISTMAX

NUMBER

Longest distance between two boats while fishing, in whole feet.

100

PUMPBEGINYEAR

VARCHAR2

Year in local time that fish pumping is attached to codend and initially turned on

100

PUMPBEGINMONTH

VARCHAR2

Month in local time that fish pumping is attached to codend and initially turned on

100

PUMPBEGINDAY

VARCHAR2

Day in local time that fish pumping is attached to codend and initially turned on

100

PUMPBEGINTIME

VARCHAR2

Time in local time that fish pumping is attached to codend and initially turned on

100

PUMPENDYEAR

VARCHAR2

Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.

100

PUMPENDMONTH

VARCHAR2

Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.

100

PUMPENDDAY

VARCHAR2

Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.

100

PUMPENDTIME

VARCHAR2

Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.

100

NTURNS

NUMBER

Number of turns > 90 degrees in haul; begun 3/2007

100

NETOVERT

NUMBER

Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007

100

NETOHORIZ

NUMBER

Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007

100

DOORSPREAD

NUMBER

Average distance between the doors while fishing; whole feet; begun 3/2007

100

PRHCOMMENTS

VARCHAR2

Additional information re: PaiR trawl Haul.

100

DOE

DATE

Date of Entry of the associated record.

100

UOE

VARCHAR2

Oracle user ID of the person who entered the data.

100

DOC

DATE

Date associated record was updated.

100

UOC

VARCHAR2

Oracle ID of user who made the (most recent ) change on the record.

Attribute Details

LINK3

CC ID: 330184

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	19
Required:	No
Primary Key:	No
Status:	Active
Description:	Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK4

CC ID: 330195

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	17
Required:	No
Primary Key:	No
Status:	Active
Description:	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 330206

Seq. Order:	3
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: 330210

Seq. Order:	4
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: 330211

Seq. Order:	5
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: 330212

Seq. Order:	6
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: 330213

Seq. Order:	7
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

HAULNUM

CC ID: 330214

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
General Data Type:	VARCHAR2

GEARNUM

CC ID: 330215

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TOWSPEED

CC ID: 330185

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Average towing speed over bottom, to nearest 10th of knot.
General Data Type:	NUMBER

WIREOUT

CC ID: 330186

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of wire paid out for haul, in whole fathoms.
General Data Type:	NUMBER

HRDEPMIN

CC ID: 330187

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Shallowest depth from surface the headrope fished, in whole fathoms.
General Data Type:	NUMBER

HRDEPMAX

CC ID: 330188

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Deepest depth from surface the headrope fished, in whole fathoms.
General Data Type:	NUMBER

DISTMIN

CC ID: 330189

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Shortest distance between two boats while fishing, in whole feet.
General Data Type:	NUMBER

DISTMAX

CC ID: 330190

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Longest distance between two boats while fishing, in whole feet.
General Data Type:	NUMBER

PUMPBEGINYEAR

CC ID: 330191

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year in local time that fish pumping is attached to codend and initially turned on
General Data Type:	VARCHAR2

PUMPBEGINMONTH

CC ID: 330192

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month in local time that fish pumping is attached to codend and initially turned on
General Data Type:	VARCHAR2

PUMPBEGINDAY

CC ID: 330193

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day in local time that fish pumping is attached to codend and initially turned on
General Data Type:	VARCHAR2

PUMPBEGINTIME

CC ID: 330194

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time in local time that fish pumping is attached to codend and initially turned on
General Data Type:	VARCHAR2

PUMPENDYEAR

CC ID: 330196

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
General Data Type:	VARCHAR2

PUMPENDMONTH

CC ID: 330197

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
General Data Type:	VARCHAR2

PUMPENDDAY

CC ID: 330198

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
General Data Type:	VARCHAR2

PUMPENDTIME

CC ID: 330199

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box.
General Data Type:	VARCHAR2

NTURNS

CC ID: 330200

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of turns > 90 degrees in haul; begun 3/2007
General Data Type:	NUMBER

NETOVERT

CC ID: 330201

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

NETOHORIZ

CC ID: 330202

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

DOORSPREAD

CC ID: 330203

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Average distance between the doors while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

PRHCOMMENTS

CC ID: 330204

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information re: PaiR trawl Haul.
General Data Type:	VARCHAR2

DOE

CC ID: 330205

Seq. Order:	29
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of Entry of the associated record.
General Data Type:	DATE

UOE

CC ID: 330207

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle user ID of the person who entered the data.
General Data Type:	VARCHAR2

DOC

CC ID: 330208

Seq. Order:	31
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date associated record was updated.
General Data Type:	DATE

UOC

CC ID: 330209

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle ID of user who made the (most recent ) change on the record.
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	33307
GUID:	gov.noaa.nmfs.inport:33307
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 08:23+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