Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Discard Log

Description

Observer Discard Log

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.
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.
GEARNUM
VARCHAR2
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
DISCARDEXIST
VARCHAR2
Indicator if there were discards for this haul 1 = yes, 0 = no. Collected beginning with obdbs Version 10 (01/01/2011).
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).
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).
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).
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).
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).
OTHVESSTRIPID
VARCHAR2
Tripid if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
OTHVESSHAUL
VARCHAR2
Haul number if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011).
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).
PUMPING_PROBLEMS
VARCHAR2
Reason catch was unable to be pumped. Collected beginning with obdbs Version 10 (01/01/2011).
COMPOSITION
VARCHAR2
Catch composition of the discarded haul and how those determinations were made. Collected beginning with obdbs Version 10 (01/01/2011).
CHALLENGES
VARCHAR2
Challenges that occurred while observing the haul. Collected beginning with obdbs Version 10 (01/01/2011).
PDQCOMMENTS
VARCHAR2
Comments on Discard Log. Collected beginning with obdbs Version 10 (01/01/2011).
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: 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

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