33311 OBPTH Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Pots and Traps Hauls Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Pots and Traps Hauls 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 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 3 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 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 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 10 NPOTSET NUMBER 22 No No 4 0 Active Total number of pots used in set. NUMBER 11 NPOTHAUL NUMBER 22 No No 4 0 Active Total number of pots hauled back from set. NUMBER 12 NPOTLOST NUMBER 22 No No 4 0 Active Amount of bait used for haul, in whole lbs. NUMBER 13 BAIT1LBS NUMBER 22 No No 3 0 Active Amount of primary bait used for haul, in whole pounds. NUMBER 14 BAIT1KND VARCHAR2 2 No No Active Code for primary bait kind. see OBBAIT table. VARCHAR2 15 BAIT1TYP VARCHAR2 1 No No Active Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other. VARCHAR2 16 BAIT1CND VARCHAR2 1 No No Active Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other. VARCHAR2 17 BAIT2LBS NUMBER 22 No No 3 0 Active Amount of secondary bait used for haul, in whole pounds. NUMBER 18 BAIT2KND VARCHAR2 2 No No Active Code for bait kind. See OBBAIT table. VARCHAR2 19 BAIT2TYP VARCHAR2 1 No No Active Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other VARCHAR2 20 BAIT2CND VARCHAR2 1 No No Active Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other. VARCHAR2 21 SETMETHOD VARCHAR2 2 No No Active Method of manner in which gear was set for haul. See OBSETMETHOD table. VARCHAR2 22 PTHCOMMENTS VARCHAR2 250 No No Active Pots and Traps Haul Comments. Prior to 2001 only true (1), false (0) VARCHAR2 23 UOE VARCHAR2 8 No No Active Oracle user ID of the person who entered the data. VARCHAR2 24 UOC VARCHAR2 8 No No Active Oracle ID of user who made the (most recent ) change on the record. VARCHAR2 gov.noaa.nmfs.inport:33311 Patricia Jones 2016-07-06T08:23:43 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