33192 FHPYL Entity Published / External 8083 Food Habits Database (FHDBS) Data Set Completed Prey Length data Loaded by batch 8930, 07-01-2016 13:03 Data Table Yes FHDBS Prey Length 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 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 4 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 5 PDSEX VARCHAR2 1 No No Active Predator sex code: 0=unknown, 1=male, 2=female, 4=transitional. VARCHAR2 6 PDID NUMBER 22 No No 6 0 Active Predator ID number beginning in 1991. NUMBER 7 LOGNUM VARCHAR2 6 No No Active Prior to 1991, unique number assigned to each predator. In 1991 the LOGNUM was replaced with PDID. VARCHAR2 8 PYSPP VARCHAR2 15 No No Active Prey species name. VARCHAR2 9 PYLEN NUMBER 22 No No 4 0 Active Prey length in millimeters NUMBER 10 PYLEST VARCHAR2 1 No No Active Prey length was estimated if value = E, actual length = N. VARCHAR2 11 PYNAM VARCHAR2 45 No No Active Prey scientific name. VARCHAR2 12 PREYLEN_COMMENT VARCHAR2 60 No No Active Comments on individual prey lengths. VARCHAR2 13 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS). DATE 14 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). DATE 15 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 16 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 gov.noaa.nmfs.inport:33192 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