Metadata Rubric

100%

6 / 6

View Report

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer Preliminary Database (OBPRELIM) >

View: OPPDQ

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

Title:	View: OPPDQ
Short Name:	OPPDQ
Status:	Completed
Abstract:	Preliminary Observer Discard Log
Notes:	Loaded by batch 8952, 07-06-2016 15:07

Entity Information

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

Data Attributes

Attribute Summary

	Name	Type	Description
100	LINK1	VARCHAR2	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
100	LINK3	VARCHAR2	19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
100	TRIPID	VARCHAR2	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
100	HAULNUM	VARCHAR2	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
100	DISCARDEXIST	VARCHAR2	Indicator if there were discards for this haul. 0=No, 1=Yes.
100	SEECODEND	VARCHAR2	Indicator if observer was able to see the contents of the codend. 0 = No; 1 = Yes, contents seen on deck; 2 = Yes, contents seen in water.
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 (comment).
100	CATCHESTBY	VARCHAR2	Person who estimated the weight of the discarded catch. 0 = Unknown; 1 = Observer; 2 = Captain; 8 = Combination.
100	OTHVESSUSD	VARCHAR2	Indicator if any of the catch was pumped to another vessel. 0=No, 1=Yes.
100	OTHVESSOBSVD	VARCHAR2	Indicator if there was an observer onboard the other vessel. 0=No, 1=Yes.
100	OTHVESSTRIPID	VARCHAR2	TRIPID if there was an observer onboard the other vessel.
100	OTHVESSHAUL	VARCHAR2	Haul number if there was an observer onboard the other vessel.
100	PDQEVENTSTR	VARCHAR2	Discard event, comma separated list of multiple values. 0 = Unknown; 1=Operational discards; 2=Tow was partially released; 3=Tow was fully released; 4=Discarded after being brought onboard; 9=Other (comment).
100	PUMPING_PROBLEMS	VARCHAR2	Reason catch was unable to be pumped.
100	COMPOSITION	VARCHAR2	Catch composition of the discarded haul and how those determinations were made.
100	CHALLENGES	VARCHAR2	Challenges that occurred while observing the haul.

Name

Type

Description

100

LINK1

VARCHAR2

15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)

100

LINK3

VARCHAR2

19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)

100

TRIPID

VARCHAR2

6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.

100

HAULNUM

VARCHAR2

Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.

100

DISCARDEXIST

VARCHAR2

Indicator if there were discards for this haul. 0=No, 1=Yes.

100

SEECODEND

VARCHAR2

Indicator if observer was able to see the contents of the codend. 0 = No; 1 = Yes, contents seen on deck; 2 = Yes, contents seen in water.

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 (comment).

100

CATCHESTBY

VARCHAR2

Person who estimated the weight of the discarded catch. 0 = Unknown; 1 = Observer; 2 = Captain; 8 = Combination.

100

OTHVESSUSD

VARCHAR2

Indicator if any of the catch was pumped to another vessel. 0=No, 1=Yes.

100

OTHVESSOBSVD

VARCHAR2

Indicator if there was an observer onboard the other vessel. 0=No, 1=Yes.

100

OTHVESSTRIPID

VARCHAR2

TRIPID if there was an observer onboard the other vessel.

100

OTHVESSHAUL

VARCHAR2

Haul number if there was an observer onboard the other vessel.

100

PDQEVENTSTR

VARCHAR2

Discard event, comma separated list of multiple values. 0 = Unknown; 1=Operational discards; 2=Tow was partially released; 3=Tow was fully released; 4=Discarded after being brought onboard; 9=Other (comment).

100

PUMPING_PROBLEMS

VARCHAR2

Reason catch was unable to be pumped.

100

COMPOSITION

VARCHAR2

Catch composition of the discarded haul and how those determinations were made.

100

CHALLENGES

VARCHAR2

Challenges that occurred while observing the haul.

Attribute Details

LINK1

CC ID: 331409

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
General Data Type:	VARCHAR2

LINK3

CC ID: 331417

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	19
Required:	No
Primary Key:	No
Status:	Active
Description:	19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
General Data Type:	VARCHAR2

TRIPID

CC ID: 331418

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year.
General Data Type:	VARCHAR2

HAULNUM

CC ID: 331419

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
General Data Type:	VARCHAR2

DISCARDEXIST

CC ID: 331420

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator if there were discards for this haul. 0=No, 1=Yes.
General Data Type:	VARCHAR2

SEECODEND

CC ID: 331421

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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 = Yes, contents seen in water.
General Data Type:	VARCHAR2

PDQREASONSTR

CC ID: 331422

Seq. Order:	7
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 (comment).
General Data Type:	VARCHAR2

CATCHESTBY

CC ID: 331423

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Person who estimated the weight of the discarded catch. 0 = Unknown; 1 = Observer; 2 = Captain; 8 = Combination.
General Data Type:	VARCHAR2

OTHVESSUSD

CC ID: 331424

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator if any of the catch was pumped to another vessel. 0=No, 1=Yes.
General Data Type:	VARCHAR2

OTHVESSOBSVD

CC ID: 331410

Seq. Order:	10
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. 0=No, 1=Yes.
General Data Type:	VARCHAR2

OTHVESSTRIPID

CC ID: 331411

Seq. Order:	11
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.
General Data Type:	VARCHAR2

OTHVESSHAUL

CC ID: 331412

Seq. Order:	12
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.
General Data Type:	VARCHAR2

PDQEVENTSTR

CC ID: 331413

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Discard event, comma separated list of multiple values. 0 = Unknown; 1=Operational discards; 2=Tow was partially released; 3=Tow was fully released; 4=Discarded after being brought onboard; 9=Other (comment).
General Data Type:	VARCHAR2

PUMPING_PROBLEMS

CC ID: 331414

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Reason catch was unable to be pumped.
General Data Type:	VARCHAR2

COMPOSITION

CC ID: 331415

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Catch composition of the discarded haul and how those determinations were made.
General Data Type:	VARCHAR2

CHALLENGES

CC ID: 331416

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Challenges that occurred while observing the haul.
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	33364
GUID:	gov.noaa.nmfs.inport:33364
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 15:07+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-06
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-06
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-06

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK1

LINK3

TRIPID

HAULNUM

DISCARDEXIST

SEECODEND

PDQREASONSTR

CATCHESTBY

OTHVESSUSD

OTHVESSOBSVD

OTHVESSTRIPID

OTHVESSHAUL

PDQEVENTSTR

PUMPING_PROBLEMS

COMPOSITION

CHALLENGES

Catalog Details