33555 ASMLNH Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed At Sea Monitor Animal Length Header Data Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS At Sea Monitor Animal Length Header Data 1 LINK3 VARCHAR2 19 Yes 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 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 4 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 5 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 6 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 7 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 8 LINK5 VARCHAR2 29 No No Active field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. Collected for ASM where applicable. VARCHAR2 9 NESPP4 VARCHAR2 4 Yes 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 Yes 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 2 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 SAMPWEIGHT NUMBER 22 No No 6 1 Active Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable. NUMBER 15 AGESTRCT VARCHAR2 2 No No Active Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments). VARCHAR2 16 NAGESTRCT NUMBER 22 No No 3 0 Active Total number of animals from which age samples were collected. NUMBER 17 VOLMEATS NUMBER 22 No No 5 0 Active Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown. NUMBER 18 LNHCOMMENTS VARCHAR2 250 No No Active Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. VARCHAR2 19 ASMTEST_STATUS VARCHAR2 6 No No Active Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested VARCHAR2 gov.noaa.nmfs.inport:33555 Patricia Jones 2016-07-27T19:10:30 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