33191 FHPY Entity Published / External 8083 Food Habits Database (FHDBS) Data Set Completed Prey Data Loaded by batch 8930, 07-01-2016 13:03 Data Table Yes FHDBS Prey 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 Yes 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 STATION VARCHAR2 4 Yes No Active Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number. VARCHAR2 4 SVSPP VARCHAR2 3 Yes 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 5 PDSEX VARCHAR2 1 No No Active Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional. VARCHAR2 6 PDID NUMBER 22 Yes No 6 0 Active Predator ID number beginning in 1991. NUMBER 7 TOWDATE DATE 7 No No Active Date of tow. DATE 8 TOWTIME VARCHAR2 4 No No Active Time at beginning of tow in EST, 24 hour time notation. VARCHAR2 9 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 10 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 11 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 12 LOGNUM VARCHAR2 6 No No Active Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID. VARCHAR2 13 PYDIG VARCHAR2 1 No No Active Relative state of digestion: F=fresh, P=partially digested,W=well digested, blank = unknown. VARCHAR2 14 PYNAM VARCHAR2 45 No No Active Prey scientific name. VARCHAR2 16 PYSPP VARCHAR2 15 No No Active Prey species name. VARCHAR2 17 PYABBR VARCHAR2 6 No No Active Prey abbreviation. VARCHAR2 18 PYWGTA NUMBER 22 No No 8 3 Active Prey species weight for grouped predator sampling. NUMBER 19 PYWGTI NUMBER 22 No No 8 3 Active Prey weight for individual predator. NUMBER 20 PYPERI NUMBER 22 No No 4 0 Active Prey species measured as percent of the total predator stomach fullness. NUMBER 21 PYVOLA NUMBER 22 No No 6 1 Active Volume of prey for grouped predators. NUMBER 22 PYVOLI NUMBER 22 No No 6 1 Active Volume of prey for individual predator. NUMBER 23 PYNUM NUMBER 22 No No 10 0 Active Number of prey per prey species. NUMBER 24 PYMEAS NUMBER 22 No No 4 0 Active Number of prey lengths measured, summed up by program. NUMBER 26 A_UPDATE DATE 7 No No Active Last date record was edited. DATE 27 A_USERID VARCHAR2 3 No No Active Initials of person editing record. VARCHAR2 28 T_FHMOD VARCHAR2 1 No No Active Data auditing flag VARCHAR2 29 T_PYCOM VARCHAR2 60 No No Active Prey comments field VARCHAR2 30 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS). DATE 31 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 32 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 33 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 gov.noaa.nmfs.inport:33191 Patricia Jones 2016-07-01T13:03:10 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