33364 OPPDQ Entity Published / External 24507 Observer Preliminary Database (OBPRELIM) Data Set Completed Preliminary Observer Discard Log Loaded by batch 8952, 07-06-2016 15:07 Data View Yes OBPRELIM Preliminary Observer Discard Log 1 LINK1 VARCHAR2 15 No No Active 15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) VARCHAR2 2 LINK3 VARCHAR2 19 No No Active 19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4) VARCHAR2 3 TRIPID VARCHAR2 6 Yes No Active 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. VARCHAR2 4 HAULNUM VARCHAR2 4 Yes No Active Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take. VARCHAR2 5 DISCARDEXIST VARCHAR2 1 Yes No Active Indicator if there were discards for this haul. 0=No, 1=Yes. VARCHAR2 6 SEECODEND VARCHAR2 1 Yes No Active 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. VARCHAR2 7 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 (comment). VARCHAR2 8 CATCHESTBY VARCHAR2 1 No No Active Person who estimated the weight of the discarded catch. 0 = Unknown; 1 = Observer; 2 = Captain; 8 = Combination. VARCHAR2 9 OTHVESSUSD VARCHAR2 1 Yes No Active Indicator if any of the catch was pumped to another vessel. 0=No, 1=Yes. VARCHAR2 10 OTHVESSOBSVD VARCHAR2 1 No No Active Indicator if there was an observer onboard the other vessel. 0=No, 1=Yes. VARCHAR2 11 OTHVESSTRIPID VARCHAR2 6 No No Active TRIPID if there was an observer onboard the other vessel. VARCHAR2 12 OTHVESSHAUL VARCHAR2 4 No No Active Haul number if there was an observer onboard the other vessel. VARCHAR2 13 PDQEVENTSTR VARCHAR2 20 No No Active 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). VARCHAR2 14 PUMPING_PROBLEMS VARCHAR2 500 No No Active Reason catch was unable to be pumped. VARCHAR2 15 COMPOSITION VARCHAR2 500 No No Active Catch composition of the discarded haul and how those determinations were made. VARCHAR2 16 CHALLENGES VARCHAR2 500 No No Active Challenges that occurred while observing the haul. VARCHAR2 gov.noaa.nmfs.inport:33364 Patricia Jones 2016-07-06T15:07:05 SysAdmin InPortAdmin 2022-08-09T17:11:10 2016-07-06 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-06 1 Year 2017-07-06