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

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

Item Identification

Title:	View: OBPDQ
Short Name:	OBPDQ
Status:	Completed
Abstract:	Observer Discard Log
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Discard Log

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	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	GEARNUM	VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100	DISCARDEXIST	VARCHAR2	Indicator if there were discards for this haul 1 = yes, 0 = no. Collected beginning with obdbs Version 10 (01/01/2011).
100	SEECODCONT	VARCHAR2	Indicator if observer was able to see the contents of the codend 0 = no, 1 = yes, contents seen on deck, 2 = contents seen in water Collected beginning with obdbs Version 10 (01/01/2011).
100	PDQREASONSTR	VARCHAR2	Reason catch was discarded on haul, comma separated list of multiple values. 0 = unknown, 1 = market, 2 = regulations, 4 = quality, 5 = not brought onboard, 9 = other. Collected beginning with obdbs Version 10 (01/01/2011).
100	CATCHESTBY	VARCHAR2	Person who estimated the weight of the discarded catch 1 = observer, 2 = captain, 8 = combination Collected beginning with obdbs Version 10 (01/01/2011).
100	OTHVESSUSD	VARCHAR2	Indicator if any of the catch was pumped to another vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).
100	OTHVESSOBSVD	VARCHAR2	Indicator if there was an observer onboard the other vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).
100	OTHVESSTRIPID	VARCHAR2	Tripid if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
100	OTHVESSHAUL	VARCHAR2	Haul number if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
100	PDQEVENTSTR	VARCHAR2	Discard event, comma separated list of multiple values 1 = discards left in net, 2 = tow was partially discarded, 3 = tow was fully discarded, 4 = discarded after pumping onboard, 9 = other Collected beginning with obdbs Version 10 (01/01/2011).
100	PUMPING_PROBLEMS	VARCHAR2	Reason catch was unable to be pumped. Collected beginning with obdbs Version 10 (01/01/2011).
100	COMPOSITION	VARCHAR2	Catch composition of the discarded haul and how those determinations were made. Collected beginning with obdbs Version 10 (01/01/2011).
100	CHALLENGES	VARCHAR2	Challenges that occurred while observing the haul. Collected beginning with obdbs Version 10 (01/01/2011).
100	PDQCOMMENTS	VARCHAR2	Comments on Discard Log. Collected beginning with obdbs Version 10 (01/01/2011).
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

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

GEARNUM

VARCHAR2

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

100

DISCARDEXIST

VARCHAR2

Indicator if there were discards for this haul 1 = yes, 0 = no. Collected beginning with obdbs Version 10 (01/01/2011).

100

SEECODCONT

VARCHAR2

Indicator if observer was able to see the contents of the codend 0 = no, 1 = yes, contents seen on deck, 2 = contents seen in water Collected beginning with obdbs Version 10 (01/01/2011).

100

PDQREASONSTR

VARCHAR2

Reason catch was discarded on haul, comma separated list of multiple values. 0 = unknown, 1 = market, 2 = regulations, 4 = quality, 5 = not brought onboard, 9 = other. Collected beginning with obdbs Version 10 (01/01/2011).

100

CATCHESTBY

VARCHAR2

Person who estimated the weight of the discarded catch 1 = observer, 2 = captain, 8 = combination Collected beginning with obdbs Version 10 (01/01/2011).

100

OTHVESSUSD

VARCHAR2

Indicator if any of the catch was pumped to another vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).

100

OTHVESSOBSVD

VARCHAR2

Indicator if there was an observer onboard the other vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).

100

OTHVESSTRIPID

VARCHAR2

Tripid if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).

100

OTHVESSHAUL

VARCHAR2

Haul number if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).

100

PDQEVENTSTR

VARCHAR2

Discard event, comma separated list of multiple values 1 = discards left in net, 2 = tow was partially discarded, 3 = tow was fully discarded, 4 = discarded after pumping onboard, 9 = other Collected beginning with obdbs Version 10 (01/01/2011).

100

PUMPING_PROBLEMS

VARCHAR2

Reason catch was unable to be pumped. Collected beginning with obdbs Version 10 (01/01/2011).

100

COMPOSITION

VARCHAR2

Catch composition of the discarded haul and how those determinations were made. Collected beginning with obdbs Version 10 (01/01/2011).

100

CHALLENGES

VARCHAR2

Challenges that occurred while observing the haul. Collected beginning with obdbs Version 10 (01/01/2011).

100

PDQCOMMENTS

VARCHAR2

Comments on Discard Log. Collected beginning with obdbs Version 10 (01/01/2011).

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

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

PROGRAM

CC ID: 330101

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

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

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

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

GEARNUM

CC ID: 330109

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

DISCARDEXIST

CC ID: 330110

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if there were discards for this haul 1 = yes, 0 = no. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

SEECODCONT

CC ID: 330111

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if observer was able to see the contents of the codend 0 = no, 1 = yes, contents seen on deck, 2 = contents seen in water Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

PDQREASONSTR

CC ID: 330112

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason catch was discarded on haul, comma separated list of multiple values. 0 = unknown, 1 = market, 2 = regulations, 4 = quality, 5 = not brought onboard, 9 = other. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

CATCHESTBY

CC ID: 330091

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Person who estimated the weight of the discarded catch 1 = observer, 2 = captain, 8 = combination Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

OTHVESSUSD

CC ID: 330092

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if any of the catch was pumped to another vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

OTHVESSOBSVD

CC ID: 330093

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if there was an observer onboard the other vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

OTHVESSTRIPID

CC ID: 330094

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Tripid if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

OTHVESSHAUL

CC ID: 330095

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Haul number if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

PDQEVENTSTR

CC ID: 330096

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Discard event, comma separated list of multiple values 1 = discards left in net, 2 = tow was partially discarded, 3 = tow was fully discarded, 4 = discarded after pumping onboard, 9 = other Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

PUMPING_PROBLEMS

CC ID: 330097

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason catch was unable to be pumped. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

COMPOSITION

CC ID: 330098

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Catch composition of the discarded haul and how those determinations were made. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

CHALLENGES

CC ID: 330099

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Challenges that occurred while observing the haul. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

PDQCOMMENTS

CC ID: 330100

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on Discard Log. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

DOE

CC ID: 330102

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

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

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

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