Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > 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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Pair Trawl Hauls

Description

Observer Pair Trawl Hauls

Entity Information

Entity Type
Data View

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

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: 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

Rubric Score Primary Key? 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