View: OBPDQ
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33305 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Discard Log
DescriptionObserver 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |