33190 FHPD Entity Published / External 8083 Food Habits Database (FHDBS) Data Set Completed Predator Data Loaded by batch 8930, 07-01-2016 13:03 Data Table Yes FHDBS Predator Data 1 CRUISE6 VARCHAR2 6 No No Active Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. VARCHAR2 2 CRUISE VARCHAR2 4 No No Active Cruise code - first to digits reflect year and second 2 are numbers sequentially assigned to indicate the order in which the cruises were coded. VARCHAR2 3 STRATUM VARCHAR2 5 No No Active A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 3 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See svdbs.svmstrata. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras 02 = BIOME 03 = Trawl, inshore north of Hatteras 04 = Shrimp 05 = Scotian shelf 06 = Shellfish 07 = Trawl, inshore south of Hatteras 08 = Trawl, Offhore south of Hatteras 09 = MA DMF 99 = Offshore deepwater (outside the stratified area) A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350 Present strata: 01351, 01352 VARCHAR2 4 TOW VARCHAR2 3 No No Active Sequential number representing order in which station was selected within a stratum. VARCHAR2 5 STATION VARCHAR2 4 No No Active Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. VARCHAR2 6 SVSPP VARCHAR2 3 No No Active A three digit alphanumeric filed used to code each species caught in a trawl or dredge. Refer to the svdbs.svspecies_list table for all 3 digit species codes. VARCHAR2 7 PDSEX VARCHAR2 1 No No Active Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional. VARCHAR2 8 PDID NUMBER 22 No No 6 0 Active Predator ID number beginning in 1991. NUMBER 9 CATSEX VARCHAR2 1 No No Active Numeric sex code: 0=unsexed, 1=male, 2=female. VARCHAR2 10 TOWDATE DATE 7 No No Active Date of tow. DATE 11 TOWTIME VARCHAR2 4 No No Active Time at beginning of tow in EST, 24 hour time notation. VARCHAR2 12 BEGLAT NUMBER 22 No No 12 8 Active Beginning latitude of tow. NUMBER 13 BEGLON NUMBER 22 No No 12 8 Active Beginning longitude of tow. NUMBER 14 SETDEPTH NUMBER 22 No No 5 0 Active A four digit number recording the depth, to the nearest meter, at the start of a trawl, dredge, or other survey gear deployment. NUMBER 15 BOTTEMP NUMBER 22 No No 4 1 Active Bottom temperature. NUMBER 16 SVSEAS VARCHAR2 6 No No Active Survey season for routine groundfish cruises. VARCHAR2 17 CRUTYP VARCHAR2 3 No No Active Food habits study type: BE=Biological Effects, GC=Gear Comoparison, GF=Ground Fish, GM=Gulf of Maine,BLM=Bureau of Land Management,MS=Mackerel,JF=Juvenile Fish. VARCHAR2 18 FHTYPE VARCHAR2 1 No No Active Code to indicate how samples were collected and measured:2=individual, percent fullness, 6=individual, weight (1973-1980), 8=individual, volume (1981 - present). VARCHAR2 19 LOGNUM VARCHAR2 6 No No Active Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID. VARCHAR2 20 FHSEX VARCHAR2 1 No No Active Predator sex code: M=male, F=female, X=unknown, I=unknown, U=unknown. VARCHAR2 21 FHPDLEN NUMBER 22 No No 4 0 Active Predator length to the nearest CM. NUMBER 22 PDLEN NUMBER 22 No No 6 2 Active Predator length in CM, rounded up. NUMBER 23 SVPDLEN NUMBER 22 No No 6 2 Active Predator length from Survey data measured in centimeters. NUMBER 24 PDWGT NUMBER 22 No No 7 0 Active Total body weight of predator in grams. NUMBER 25 PDMINL NUMBER 22 No No 6 2 Active Predator minimum length in CM NUMBER 26 PDMAXL NUMBER 22 No No 6 2 Active Predator maximum length in CM. NUMBER 27 PDAVEL NUMBER 22 No No 6 2 Active Predator average length in CM (grouped data). NUMBER 28 PDSVOL NUMBER 22 No No 6 1 Active Total stomach volume for an individual predator in cubic centimeters. NUMBER 29 PDSWGT NUMBER 22 No No 8 3 Active Total stomach weight for an individual predator in grams. NUMBER 30 FHMAT VARCHAR2 1 No No Active Predator maturity code:I=immature,D=developing,R=ripe, U=ripe and running,S=spent,T=resting VARCHAR2 31 PDMAT VARCHAR2 1 No No Active Predator maturity code: I=immature,D=developing,R=ripe,U=ripe and runing,S=spent,T=resting,E=eyed,X=unknown VARCHAR2 32 PDAGE NUMBER 22 No No 3 0 Active Predator age in years. NUMBER 33 PDSAMP NUMBER 22 No No 3 0 Active Number of predators sampled. NUMBER 34 PDEMPT NUMBER 22 No No 3 0 Active Number of empty predator stomachs in sample. NUMBER 35 PYMINL NUMBER 22 No No 4 0 Active Minimum length of all fish prey measured in a single predator. NUMBER 36 PYMAXL NUMBER 22 No No 4 0 Active Maximum length of all the fish prey measured in a single predator. NUMBER 37 PYAVEL NUMBER 22 No No 4 0 Active Average length for all fish prey measusred in a single predator in millimeters. NUMBER 38 FHDAT VARCHAR2 1 No No Active Code for food habits data: E=examined at sea, P=preserved. VARCHAR2 40 MATDAT VARCHAR2 1 No No Active Null data field VARCHAR2 41 REMARK VARCHAR2 1 No No Active Indicates remark entered on log. VARCHAR2 42 WRITER VARCHAR2 30 No No Active Person recording data on log sheet. VARCHAR2 43 CUTTER VARCHAR2 30 No No Active A thirty character field indicating the individual who was measuring and cutting fish at a FSCS workstation. VARCHAR2 45 A_UPDATE DATE 7 No No Active Last date record was edited. DATE 46 A_USERID VARCHAR2 3 No No Active Initials of person editing record. VARCHAR2 47 T_FHMOD VARCHAR2 1 No No Active Data auditing flag VARCHAR2 48 T_PDCOM VARCHAR2 60 No No Active Predator comments field VARCHAR2 49 T_SVMOD VARCHAR2 1 No No Active Data auditing flag VARCHAR2 50 SUNRIS VARCHAR2 4 No No Active Null data field VARCHAR2 51 SUNSET VARCHAR2 4 No No Active Null data field VARCHAR2 52 DIEL VARCHAR2 1 No No Active Null data field VARCHAR2 53 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS). DATE 54 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 55 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 56 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 gov.noaa.nmfs.inport:33190 Patricia Jones 2016-07-01T13:03:09 SysAdmin InPortAdmin 2022-08-09T17:11:08 2017-02-27 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 2017-02-27 1 Year 2018-02-27