33300 OBLND Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Animal Length Detail Data from standard observer trips Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Animal Length Detail Data from standard observer trips 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 LINK5 VARCHAR2 28 No No Active field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. 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 HAULNUM VARCHAR2 4 No No Active Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. VARCHAR2 9 NESPP4 VARCHAR2 4 No No Active Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. VARCHAR2 10 FISHDISP VARCHAR2 3 No No Active Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable. VARCHAR2 11 CATDISP VARCHAR2 1 No No Active Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable. VARCHAR2 12 SEX VARCHAR2 1 No No Active One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female. VARCHAR2 13 DREDGEPOS VARCHAR2 1 No No Active Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown; VARCHAR2 14 LENANML NUMBER 22 No No 4 0 Active Finfish and squid measured in whole centimeters. Shellfish measured in whole millimeters. Collected for ASM where applicable. NUMBER 15 NUMLEN NUMBER 22 No No 4 0 Active Total number of animals measured at each centimeter or millimeter. Collected for ASM where applicable. NUMBER gov.noaa.nmfs.inport:33300 Patricia Jones 2016-07-06T08:23:40 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