Metadata Rubric

100%

6 / 6

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

View: OBPSH

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

Item Identification

Title:	View: OBPSH
Short Name:	OBPSH
Status:	Completed
Abstract:	Observer Purse Seine 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 Purse Seine 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	SETSPEED	NUMBER	Speed of vessel setting net during set, nearest 10th of knot.
100	PLANEUSD	VARCHAR2	Indicator of whether a spotter plane was used.
100	TIMEUP	VARCHAR2	Using 24 hour clock(0000-2359), time the spotter plane took off.
100	TIMEDOWN	VARCHAR2	Using 24 hour clock(0000-2359), time the spotter plane landed.
100	SETPLANE	VARCHAR2	Indicator of whether a spotter palne was used to set on school of fish.
100	SETDEBRIS	VARCHAR2	Indicator of whether set was made on debris.
100	SETSUCCESS	VARCHAR2	Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown
100	FISHLOST	VARCHAR2	Indicator for whether fish were lost during set.
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	PSHCOMMENTS	VARCHAR2	Additional information re: Purse Seine 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

SETSPEED

NUMBER

Speed of vessel setting net during set, nearest 10th of knot.

100

PLANEUSD

VARCHAR2

Indicator of whether a spotter plane was used.

100

TIMEUP

VARCHAR2

Using 24 hour clock(0000-2359), time the spotter plane took off.

100

TIMEDOWN

VARCHAR2

Using 24 hour clock(0000-2359), time the spotter plane landed.

100

SETPLANE

VARCHAR2

Indicator of whether a spotter palne was used to set on school of fish.

100

SETDEBRIS

VARCHAR2

Indicator of whether set was made on debris.

100

SETSUCCESS

VARCHAR2

Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown

100

FISHLOST

VARCHAR2

Indicator for whether fish were lost during set.

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

PSHCOMMENTS

VARCHAR2

Additional information re: Purse Seine 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: 330251

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

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

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

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

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

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

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

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

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

SETSPEED

CC ID: 330252

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	2
Status:	Active
Description:	Speed of vessel setting net during set, nearest 10th of knot.
General Data Type:	NUMBER

PLANEUSD

CC ID: 330253

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether a spotter plane was used.
General Data Type:	VARCHAR2

TIMEUP

CC ID: 330254

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Using 24 hour clock(0000-2359), time the spotter plane took off.
General Data Type:	VARCHAR2

TIMEDOWN

CC ID: 330255

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Using 24 hour clock(0000-2359), time the spotter plane landed.
General Data Type:	VARCHAR2

SETPLANE

CC ID: 330256

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether a spotter palne was used to set on school of fish.
General Data Type:	VARCHAR2

SETDEBRIS

CC ID: 330257

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether set was made on debris.
General Data Type:	VARCHAR2

SETSUCCESS

CC ID: 330258

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Captain felt set was successful: 0 = no, 1 = yes, 9 = unknown
General Data Type:	VARCHAR2

FISHLOST

CC ID: 330259

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator for whether fish were lost during set.
General Data Type:	VARCHAR2

PUMPBEGINYEAR

CC ID: 330260

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

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

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

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

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

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

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

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

PSHCOMMENTS

CC ID: 330269

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information re: Purse Seine Haul.
General Data Type:	VARCHAR2

DOE

CC ID: 330270

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

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

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

Seq. Order:	30
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:	33309
GUID:	gov.noaa.nmfs.inport:33309
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