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

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Pots and Traps Hauls

Description

Observer Pots and Traps Hauls

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.
NPOTSET NUMBER	Total number of pots used in set.
NPOTHAUL NUMBER	Total number of pots hauled back from set.
NPOTLOST NUMBER	Amount of bait used for haul, in whole lbs.
BAIT1LBS NUMBER	Amount of primary bait used for haul, in whole pounds.
BAIT1KND VARCHAR2	Code for primary bait kind. see OBBAIT table.
BAIT1TYP VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
BAIT1CND VARCHAR2	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
BAIT2LBS NUMBER	Amount of secondary bait used for haul, in whole pounds.
BAIT2KND VARCHAR2	Code for bait kind. See OBBAIT table.
BAIT2TYP VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
BAIT2CND VARCHAR2	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
SETMETHOD VARCHAR2	Method of manner in which gear was set for haul. See OBSETMETHOD table.
PTHCOMMENTS VARCHAR2	Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0)
UOE VARCHAR2	Oracle user ID of the person who entered the data.
UOC VARCHAR2	Oracle ID of user who made the (most recent ) change on the record.

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.

NPOTSET
NUMBER

Total number of pots used in set.

NPOTHAUL
NUMBER

Total number of pots hauled back from set.

NPOTLOST
NUMBER

Amount of bait used for haul, in whole lbs.

BAIT1LBS
NUMBER

Amount of primary bait used for haul, in whole pounds.

BAIT1KND
VARCHAR2

Code for primary bait kind. see OBBAIT table.

BAIT1TYP
VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.

BAIT1CND
VARCHAR2

Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

BAIT2LBS
NUMBER

Amount of secondary bait used for haul, in whole pounds.

BAIT2KND
VARCHAR2

Code for bait kind. See OBBAIT table.

BAIT2TYP
VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

BAIT2CND
VARCHAR2

Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

SETMETHOD
VARCHAR2

Method of manner in which gear was set for haul. See OBSETMETHOD table.

PTHCOMMENTS
VARCHAR2

Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0)

UOE
VARCHAR2

Oracle user ID of the person who entered the data.

UOC
VARCHAR2

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

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: OBPTH
Short Name:	OBPTH
Status:	Completed
Abstract:	Observer Pots and Traps Hauls
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Pots and Traps Hauls

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	NPOTSET	NUMBER	Total number of pots used in set.
100	NPOTHAUL	NUMBER	Total number of pots hauled back from set.
100	NPOTLOST	NUMBER	Amount of bait used for haul, in whole lbs.
100	BAIT1LBS	NUMBER	Amount of primary bait used for haul, in whole pounds.
100	BAIT1KND	VARCHAR2	Code for primary bait kind. see OBBAIT table.
100	BAIT1TYP	VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
100	BAIT1CND	VARCHAR2	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100	BAIT2LBS	NUMBER	Amount of secondary bait used for haul, in whole pounds.
100	BAIT2KND	VARCHAR2	Code for bait kind. See OBBAIT table.
100	BAIT2TYP	VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
100	BAIT2CND	VARCHAR2	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100	SETMETHOD	VARCHAR2	Method of manner in which gear was set for haul. See OBSETMETHOD table.
100	PTHCOMMENTS	VARCHAR2	Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0)
100	UOE	VARCHAR2	Oracle user ID of the person who entered the data.
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

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

NPOTSET

NUMBER

Total number of pots used in set.

100

NPOTHAUL

NUMBER

Total number of pots hauled back from set.

100

NPOTLOST

NUMBER

Amount of bait used for haul, in whole lbs.

100

BAIT1LBS

NUMBER

Amount of primary bait used for haul, in whole pounds.

100

BAIT1KND

VARCHAR2

Code for primary bait kind. see OBBAIT table.

100

BAIT1TYP

VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.

100

BAIT1CND

VARCHAR2

Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

100

BAIT2LBS

NUMBER

Amount of secondary bait used for haul, in whole pounds.

100

BAIT2KND

VARCHAR2

Code for bait kind. See OBBAIT table.

100

BAIT2TYP

VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

100

BAIT2CND

VARCHAR2

Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

100

SETMETHOD

VARCHAR2

Method of manner in which gear was set for haul. See OBSETMETHOD table.

100

PTHCOMMENTS

VARCHAR2

Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0)

100

UOE

VARCHAR2

Oracle user ID of the person who entered the data.

100

UOC

VARCHAR2

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

Attribute Details

LINK3

CC ID: 330343

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

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

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

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

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

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

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

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

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

NPOTSET

CC ID: 330344

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total number of pots used in set.
General Data Type:	NUMBER

NPOTHAUL

CC ID: 330345

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total number of pots hauled back from set.
General Data Type:	NUMBER

NPOTLOST

CC ID: 330346

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Amount of bait used for haul, in whole lbs.
General Data Type:	NUMBER

BAIT1LBS

CC ID: 330347

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of primary bait used for haul, in whole pounds.
General Data Type:	NUMBER

BAIT1KND

CC ID: 330348

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait kind. see OBBAIT table.
General Data Type:	VARCHAR2

BAIT1TYP

CC ID: 330349

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
General Data Type:	VARCHAR2

BAIT1CND

CC ID: 330350

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
General Data Type:	VARCHAR2

BAIT2LBS

CC ID: 330351

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of secondary bait used for haul, in whole pounds.
General Data Type:	NUMBER

BAIT2KND

CC ID: 330352

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for bait kind. See OBBAIT table.
General Data Type:	VARCHAR2

BAIT2TYP

CC ID: 330353

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
General Data Type:	VARCHAR2

BAIT2CND

CC ID: 330355

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
General Data Type:	VARCHAR2

SETMETHOD

CC ID: 330356

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Method of manner in which gear was set for haul. See OBSETMETHOD table.
General Data Type:	VARCHAR2

PTHCOMMENTS

CC ID: 330357

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0)
General Data Type:	VARCHAR2

UOE

CC ID: 330358

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

UOC

CC ID: 330359

Seq. Order:	24
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 Item ID:	33311
GUID:	gov.noaa.nmfs.inport:33311
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

View: OBPTH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK3

LINK4

LINK1

PROGRAM

YEAR

MONTH

TRIPID

HAULNUM

GEARNUM

NPOTSET

NPOTHAUL

NPOTLOST

BAIT1LBS

BAIT1KND

BAIT1TYP

BAIT1CND

BAIT2LBS

BAIT2KND

BAIT2TYP

BAIT2CND

SETMETHOD

PTHCOMMENTS

UOE

UOC

Catalog Details