33289 OBCDH Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Clam Dredge Haul Logs Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Clam Dredge Haul Logs 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 LINK1 VARCHAR2 15 No No Active 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. VARCHAR2 3 LINK4 VARCHAR2 17 No No Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. VARCHAR2 4 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 7 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 8 TOWSPEED NUMBER 22 No No 3 1 Active Average towing speed over bottom, to nearest 10th of knot. NUMBER 9 WIREOUT NUMBER 22 No No 3 0 Active Amount of wire paid out for haul, in whole fathoms. NUMBER 10 CLAPOBS VARCHAR2 1 No No Active Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. VARCHAR2 11 NBUSHKEP NUMBER 22 No No 5 2 Active Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. NUMBER 12 NBUSHDIS NUMBER 22 No No 5 2 Active Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. NUMBER 13 CDHCOMMENTS VARCHAR2 250 No No Active Clam/quahog dredge haul comments. VARCHAR2 gov.noaa.nmfs.inport:33289 Patricia Jones 2016-07-06T08:23:38 SysAdmin InPortAdmin 2022-08-09T17:11:11 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