33577 OBTRS Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Scallop Trip Summary Data from standard observer trips Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Scallop Trip Summary Data from standard observer trips 1 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 2 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 3 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 4 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 5 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 6 CATSOAK VARCHAR2 1 No No Active Scallop meats soaked in fluid other than water. 0=no; 1=yes VARCHAR2 7 CATMIX VARCHAR2 1 No No Active Indicator of whether scallop meats were mixed size. 0 = no, 1 = yes, 9 = unknown. VARCHAR2 8 NBAGS NUMBER 22 No No 4 0 Active Total number of bags of shucked scallops for trip. NUMBER 9 BAGAVGLB NUMBER 22 No No 3 0 Active Average weight of bag of shucked scallops for trip, in whole pounds. Not collected prior to May, 1994 (set to null = unknown) NUMBER 10 TRSCOMMENTS VARCHAR2 250 No No Active Additional information regarding scallop trip. Prior to 2001 only true or false VARCHAR2 11 QTR NUMBER 22 No No 38 Active Quarter of year landed: 1 = Jan, Feb, Mar; 2 = Apr,May,Jun 3=Jul, Aug, Sep, 4= Oct, Nov, Dec. Collected for ASM where applicable. NUMBER 12 TRIPEXT VARCHAR2 1 No No Active Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. VARCHAR2 13 VTRSERNO VARCHAR2 15 No No Active Serial number from the Vessel Trip Report; Unknown or none = '00000000'; entered after January 2006. Collected for ASM where applicable. Contains EVTR Tripid when collected else VTR Serial Number. VARCHAR2 14 FLEET_TYPE VARCHAR2 3 No No Active Identifies limited access/general category scallop trips, carrier vessels, and processor vessels. See support table OBFLEET_TYPE. VARCHAR2 15 SECTOR_ID VARCHAR2 3 No No Active Sector id code for groundfish only trips for trips beginning May, 2010. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. See OBSECTOR_ID table. VARCHAR2 16 VENDOR_ID VARCHAR2 2 No No Active 01: AIS NMFS-Funded Trip; 02: AIS Industry-Funded Trip; 04 EWTS,LLC industry_funded trip; 00 unknown. Collected for ASM where applicable. VARCHAR2 17 HULLNUM1 VARCHAR2 10 No No Active Number on the hull of the vessel on which observer is deployed. See OBVESSEL table. Collected for ASM where applicable. VARCHAR2 18 XTRIPDUR NUMBER 22 No No 2 0 Active The number of days the Captain expected to be away from port on fishing trip. NUMBER 19 YEARSAIL VARCHAR2 4 No No Active Four digit year in which the vessel left dock to go fishing. Collected for ASM where applicable. VARCHAR2 20 MONTHSAIL VARCHAR2 2 No No Active Two digit month in which vessel left dock to go fishing. Collected for ASM where applicable. VARCHAR2 21 DAYSAIL VARCHAR2 2 No No Active The day the vessel left the dock to go fishing. Collected for ASM where applicable. VARCHAR2 22 TIMESAIL VARCHAR2 4 No No Active Local time, using 24 hour clock (0000-2359), the vessel left the dock to go fishing. Collected for ASM where applicable. VARCHAR2 23 DATESAIL DATE 7 No No Active The month, day and year the vessel left the dock to go fishing. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. DATE 24 TRIPTYPE VARCHAR2 1 No No Active Indicator of whether one or more than one type of gear was used. 1=single gear, 2=multiple gear. VARCHAR2 25 HULLNUM2 VARCHAR2 10 No No Active Used for pair trawl and joint venture trips only. The number on the hull of the paired or joint venture vessel. Not recorded prior to 5/1994; set to unknown VARCHAR2 26 CREW NUMBER 22 No No 2 0 Active The number of individuals working on the vessel, including the Captain. Null = unknown. NUMBER 27 YEARLAND VARCHAR2 4 No No Active (Same as YEAR) Collected for ASM where applicable. VARCHAR2 28 MONTHLAND VARCHAR2 2 No No Active Month vessel landed for unloading catch. Collected for ASM where applicable. VARCHAR2 29 DAYLAND VARCHAR2 2 No No Active Day the vessel landed to off load catch. Collected for ASM where applicable. VARCHAR2 30 TIMELAND VARCHAR2 4 No No Active Time vessel docked to unload catch at the end of the trip. Collected for ASM where applicable. VARCHAR2 31 DATELAND DATE 7 No No Active Date vessel landed to offload catch. NOTE: if time is unknown it defaults to midnight in this field. Collected for ASM where applicable. DATE 32 TMPHPORT VARCHAR2 6 No No Active 4 - digit port code (see PORT table) identifying "home port" on log.;where boat is mostly kept which may be neither where registered nor where sold catch. VARCHAR2 33 PORT VARCHAR2 6 No No Active The 6-char code of the port, including state, in which vessel offloads its catch. See PORT table. Collected for ASM where applicable. VARCHAR2 34 PORTSAIL VARCHAR2 6 No No Active The 6-char code of the port, including state, from which the vessel sailed. See PORT table. Collected for ASM where applicable. VARCHAR2 35 STEAMTIM NUMBER 22 No No 4 1 Active Time, to nearest tenth of the hour, from when the vessel left the dock to go fishing, and arrived at the location where the gear was first deployed/hauled. Collected for ASM where applicable. NUMBER 36 ICETONS NUMBER 22 No No 5 2 Active Estimated ice used, to the nearest hundredth of a ton. Collected for ASM where applicable. NUMBER 37 FUELGAL NUMBER 22 No No 5 0 Active Estimated amount of of fuel consumed during trip, in whole gallons. Null = unknown. Collected for ASM where applicable. NUMBER 38 DAMAGCOST NUMBER 22 No No 6 0 Active Captains estimate, to the nearest dollar, of the cost of gear and/or equipment lost or damaged during trip. Unknown = nul. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 39 SUPPLYCOST NUMBER 22 No No 6 0 Active Price, in dollars and cents for commonly used supplies purchased for trip. Null = unknown. Not recorded prior to 2001; set to unknown. Collected for ASM where applicable. NUMBER 40 FOODCOST NUMBER 22 No No 4 0 Active Cost to the crew and Captain, to the nearest dollar, for food purchased for trip. Null = unknown. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 41 ICEPRICE NUMBER 22 No No 5 2 Active Price paid per ton for ice purchased for trip, in dollars and cents. Unknown = null. Collected for ASM where applicable. NUMBER 42 FUELPRICE NUMBER 22 No No 4 2 Active Price per gallon paid for fuel purchased for trip, in dollars and cents. Null = unknown. Collected for ASM where applicable. NUMBER 43 WATERCOST NUMBER 22 No No 4 0 Active Cost of fresh water purchased for trip, to nearest dollar. Unknown = null. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 44 OILCOST NUMBER 22 No No 4 0 Active Cost of lubricating oil purchased for trip, to nearest dollar. Null = unknown. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 45 BAITCOST NUMBER 22 No No 5 0 Active Cost of bait purchased for trip, to nearest dollar. Not recorded prior to 5/1994; set to unknown. Collected for ASM where applicable. NUMBER 46 TIMELOSTCD1 VARCHAR2 2 No No Active Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code.Not collected prior to 5/1994; set to 00 (unknown) if an amount of hours lost is recorded, to 98 (none) if 0 hours is recorded for hours lost. VARCHAR2 47 TIMELOST1 NUMBER 22 No No 4 1 Active Fishing time , to nearest tenth of hour, vessel lost for reason identified in timelostcd1 during trip using primary gear. NUMBER 48 TIMELOSTCD2 VARCHAR2 2 No No Active Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. VARCHAR2 49 TIMELOST2 NUMBER 22 No No 4 1 Active Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd2 during trip using primary gear. NUMBER 50 TIMELOSTCD3 VARCHAR2 2 No No Active Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. Not recorded prior to VARCHAR2 51 TIMELOST3 NUMBER 22 No No 4 1 Active Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd3 during trip using primary gear. NUMBER 52 TIMELOSTCD4 VARCHAR2 2 No No Active Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. VARCHAR2 53 TIMELOST4 NUMBER 22 No No 4 1 Active Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd4 during trip using primary gear. NUMBER 54 TIMELOSTCD5 VARCHAR2 2 No No Active Reason for any amount of fishing time the vessel lost while using primary gear type. Two digit code. VARCHAR2 55 TIMELOST5 NUMBER 22 No No 4 1 Active Fishing time , to nearest tenth of hour, vessel lost due to reason identified by timelostcd5 during trip using primary gear. NUMBER 56 TRPCOMMENTS VARCHAR2 250 No No Active Any additional information regarding trip or expenditures.Prior to 2001 only true or false. Collected for ASM where applicable. VARCHAR2 57 PERMIT1 NUMBER 22 No No 38 Active Vessel Permit Number. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. NUMBER 58 PERMIT2 NUMBER 22 No No 38 Active Vessel Permit Number required for joint venture trips and pair trawl. Collected beginning with obdbs Version 10 (01/01/2011). NUMBER 59 DEALNUM VARCHAR2 25 No No Active Dealer number. See OBDEALER_MV table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 60 DEALISS_AGENCY VARCHAR2 25 No No Active Dealer issuing agency, codes 9,10,11 used by NEFOP only. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 61 VMSCODE VARCHAR2 2 No No Active VMS Fishing Area Code required for Special Access Program (SAP) trips. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 gov.noaa.nmfs.inport:33577 Patricia Jones 2016-07-27T19:10:31 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