22161 PREYLEN Entity Published / External 20485 AFSC/REFM: North Pacific Groundfish Diet Data 1981-present, Aydin, K. Data Set In Work REEM North Pacific Groundfish Diet Data PreyLen Data Table Loaded by FGDC Metadata Uploader, batch 5084, 09-02-2014 16:45 REEM North Pacific Groundfish Diet Data PreyLen Data Table CRUISE NUMBER No No Active A 4-digit numeric field that does not accept null values, acceptable values are any cruise code. 11983 - 992009 YEAR NUMBER No No Active This is a 4-digit numeric field that does not accept null values, acceptable values are any four-digit year 1981 - 2015 HAUL NUMBER No No Active A 3-digit numeric field that does not allow null values representing the haul number from which the associated stomach data were collected. 1 - 3058 HAULJOIN NUMBER No No Active A 12-digit numeric field that does not allow null values. Each hauljoin uniquely identifies a given vessel, cruise, haul combination. A foreign key to the haul table. 651234 - 11135973 PREDJOIN NUMBER No No Active A 12-digit numeric field that uniquely identifies a given stomach sample. 999996 - 11138912 PRED_LEN NUMBER No No Active A 4.1-digit numeric field that does not allow null values representing the fork length (cm) of the predator. 4.3 - 288 PRED_LH NUMBER No No Active A 1-digit numeric field that allows null values representing the life history stage of the predator from which the stomachs were collected. Table 5 contains the acceptable values for this field. 0 - 8 PRED_NODC NUMBER No No Active A 10-digit numeric field that does not allow null values representing the NODC code for the predator from which the given data were collected. Consult REEM NODC code dictionary for definitions as some codes have been customized 8710010101 - 8857041901 PRED_SEX NUMBER No No Active A 1-digit numeric field that allows null values representing the sex of the predator. Acceptable values are null, 1 indicating male, 2 indicating female or 3 indicating unsexed or juvenile. 1 - 3 PRED_SPECN NUMBER No No Active A 4-digit numeric field that does not allow null values. This is the predator specimen number assigned to the stomach when it was collected in the field. Prior to in-lab form data entry, this was a 2-digit number assigned in the lab at the time of analysis 0 - 9880 PREYLENJOIN NUMBER No No Active A 12-digit numeric field that uniquely identifies a prey length record. 10873939 - 10991339 PREY_LH CHAR No No Active A 1-digit character field that allows null values representing the life history stage of the prey item. Table 6 contains the acceptable values for this field. PREY_NODC NUMBER No No Active A 10-digit numeric field that does not allow null values representing the NODC code for the prey item. Consult REEM NODC code dictionary for definitions as some codes have been customized 5.001e+09 - 9999999999 PREY_SEX NUMBER No No Active A 1-digit numeric field that allows null values representing the sex of the prey. Acceptable values are null, 1 indicating male, 2 indicating female or 3 indicating unsexed or juvenile. A prey sex code of 5 may be used to indicate a fish length that was estimated with a method other than the Pollock otolith measurements as noted below. Values of 6-8 are used indicating the condition of walleye pollock otoliths used for estimating the length of the prey fish they were removed from. 6 indcating fair, 7 indicating good, and 8 indicating excellent. See the lab manual for a description of the protocol for using walleye pollock otoliths for estimating prey length. 0 - 8 PREY_SZ1 NUMBER No No Active An 8.3-digit numeric field that does not allow null values representing the standard length (mm) of fish prey, carapace width (mm) of Majid crabs, or carapace length of Lithodid crabs. This is the primary prey size measurement 0 - 710 PREY_SZ2 NUMBER No No Active An 8.3-digit numeric field that allows null values representing the fork length (mm) of fish prey or carapace length (mm) of Majid crabs. This is a secondary prey size measurement. 0 - 570 PREY_SZ3 NUMBER No No Active An 8.3-digit numeric field that allows null values representing miscellaneous auxiliary prey size measurements. 0 - 440 QUARTER NUMBER No No Active This is a one-digit numeric field with acceptable values of null, 1, 2, 3, 4. Quarter 1 represents January through March, quarter 2 represents April through June, quarter 3 represents July through September and quarter 4 represents October through December. 1 - 4 SEQ_NUM NUMBER No No Active A 4-digit numeric field that allows null values. This represents the sequence number from the old pred-prey form used in the lab for quantitative analysis. Sequence number uniquely identified a record from a given stomach. These are currently not maintained. 0 - 1242 STA_ID_LET CHAR No No Active A 2-digit character field that allows null values or a station ID letter based on the RACE station grid. Bering Sea Data only. This field indicates the station ID letter from which the samples were collected. Not maintained, use Station_ID from the Haul table STA_ID_NUM NUMBER No No Active A 2-digit character field that allows null values or a station ID number based on the RACE station grid. Bering Sea Data only. This field indicates the station ID number from which the samples were collected. Not maintained, use Station_ID from the Haul table. 0 - 33 TYPE NUMBER No No Active A 1-digit numeric field that does not accept null values indicating the stomach analysis type performed to generate the associated data. 2 - 9 VESSEL NUMBER No No Active A 4-digit numeric field that does not accept null values, acceptable values are any vessel code. 1 - 7777 EMPTY_1 NUMBER No No Active An 8.3-digit numeric field that allows null values. Unused. 0 - 49.5 gov.noaa.nmfs.inport:22161 Angie Greig 2014-09-02T16:45:34 SysAdmin InPortAdmin 2022-08-09T17:11:05 2016-04-19 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-04-19 1 Year 2017-04-19