33305 OBPDQ Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Discard Log Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Discard Log 1 LINK3 VARCHAR2 19 No No Active Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. VARCHAR2 2 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 3 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 4 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 5 TRIPID VARCHAR2 6 No No Active 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. VARCHAR2 6 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 7 DISCARDEXIST VARCHAR2 1 No No Active Indicator if there were discards for this haul 1 = yes, 0 = no. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 8 SEECODCONT VARCHAR2 1 No No Active 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). VARCHAR2 9 PDQREASONSTR VARCHAR2 20 No No Active 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). VARCHAR2 10 CATCHESTBY VARCHAR2 1 No No Active Person who estimated the weight of the discarded catch 1 = observer, 2 = captain, 8 = combination Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 11 OTHVESSUSD VARCHAR2 1 No No Active Indicator if any of the catch was pumped to another vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 12 OTHVESSOBSVD VARCHAR2 1 No No Active Indicator if there was an observer onboard the other vessel 1 = yes, 0 = no Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 13 OTHVESSTRIPID VARCHAR2 6 No No Active Tripid if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 14 OTHVESSHAUL VARCHAR2 4 No No Active Haul number if there was an observer onboard the other vessel. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 15 PDQEVENTSTR VARCHAR2 20 No No Active 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). VARCHAR2 16 PUMPING_PROBLEMS VARCHAR2 250 No No Active Reason catch was unable to be pumped. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 17 COMPOSITION VARCHAR2 250 No No Active Catch composition of the discarded haul and how those determinations were made. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 18 CHALLENGES VARCHAR2 250 No No Active Challenges that occurred while observing the haul. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 19 PDQCOMMENTS VARCHAR2 250 No No Active Comments on Discard Log. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 20 DOE DATE 7 No No Active Date of Entry of the associated record. DATE 21 UOE VARCHAR2 8 No No Active Oracle user ID of the person who entered the data. VARCHAR2 22 DOC DATE 7 No No Active Date associated record was updated. DATE 23 UOC VARCHAR2 8 No No Active Oracle ID of user who made the (most recent ) change on the record. VARCHAR2 gov.noaa.nmfs.inport:33305 Patricia Jones 2016-07-06T08:23:41 SysAdmin InPortAdmin 2022-08-09T17:11:12 2016-07-28 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-07-28 1 Year 2017-07-28