33362 OPHAU Entity Published / External 24507 Observer Preliminary Database (OBPRELIM) Data Set Completed Preliminary Observer Haul Data Loaded by batch 8952, 07-06-2016 15:07 Data View Yes OBPRELIM Preliminary Observer Haul Data 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 YEAR VARCHAR2 4 Yes No Active Year landed. Characters 4-7 of LINK1. VARCHAR2 4 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 5 HAULNUM VARCHAR2 4 Yes No Active Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take. VARCHAR2 6 NEGEAR VARCHAR2 3 Yes No Active Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR. VARCHAR2 7 OBSRFLAG VARCHAR2 1 Yes No Active Indicator of whether haul was observed for discards. 0=No, 1=Yes. VARCHAR2 8 CATEXIST VARCHAR2 1 No No Active Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes. VARCHAR2 9 LATHBEG VARCHAR2 6 No No Active Latitude location where haul began. VARCHAR2 10 LONHBEG VARCHAR2 6 No No Active Longitude location where haul began. VARCHAR2 11 GIS_LATHBEG VARCHAR2 6 No No Active GIS converted LATHBEG. VARCHAR2 12 GIS_LONHBEG VARCHAR2 6 No No Active GIS converted LONHBEG. This number is negative. VARCHAR2 13 LATHEND VARCHAR2 6 No No Active Latitude location where haul ended or position information where take occurred for incidental take. VARCHAR2 14 LONHEND VARCHAR2 6 No No Active Longitude location where haul ended or position information where take occurred for incidental take. VARCHAR2 15 GIS_LATHEND VARCHAR2 6 No No Active GIS converted LATHEND. VARCHAR2 16 GIS_LONHEND VARCHAR2 6 No No Active GIS converted LONHEND. This number is negative. VARCHAR2 17 AREA VARCHAR2 3 No No Active Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul. VARCHAR2 18 HAUCOMMENTS VARCHAR2 200 No No Active Additional information regarding the haul. VARCHAR2 gov.noaa.nmfs.inport:33362 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