22160 PREDPREY 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 PredPrey Data Table Loaded by FGDC Metadata Uploader, batch 5084, 09-02-2014 16:45 REEM North Pacific Groundfish Diet Data PredPrey Data Table CRUISE NUMBER No No Active A 4-digit numeric field that does not accept null values, acceptable values are any cruise code. 11982 - 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 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. 347810 - 11135974 NOTE CHAR No No Active A 100 place character field that allows comments about the related predator or prey. PREDJOIN NUMBER No No Active A 12-digit numeric field that uniquely identifies a given stomach sample. 991 - 99999991 PRED_DIG NUMBER No No Active A 1-digit numeric field that does not allow null values representing the state of digestion of a given prey item. Values are 1, indicating an empty stomach, 2 indicating traces of prey, 3 indicating 75% digested, 4 indicating 50% digested, 5 indicating 25% digested and 6 indicating fresh prey. 1 - 7 PRED_FULL NUMBER No No Active A 1-digit numeric field that allows null values representing predator stomach fullness at the time of analysis. Values are null, 1 indicating an empty stomach, 2 indicating trace of prey, 3 indicating 25% fullness, 4 indicating 50% fullness, 5 indicating 75% fullness, 6 indicating 100% fullness and 7 indicating a distended stomach. 0 - 7 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. 0 - 295 PRED_LH NUMBER 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. 0 - 8 PRED_MAT NUMBER No No Active A 1-digit numeric field that allows null values representing the maturity state (spawning condition) of the predator. Acceptable values are null, 1 indicating spawning, and 0 indicating non-spawning. 0 - 9 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. 5704020101 - 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 - 9997 PRED_STOMWT NUMBER No No Active An 8.3-digit numeric field that does not allow null values representing the total content weight (g) of a given stomach. A value of 0 indicates an empty stomach. 0 - 11773 PRED_WT NUMBER No No Active A 7.1 numeric field that allows null values representing the weight (g) of the predator calculated from established length-weight regressions. May be null of no established length-weight regression is available. 0 - 146979.1 PREYJOIN NUMBER No No Active A 12-digit numeric field that uniquely identifies a given prey record. 10207196 - 10844366 PREY_CNT NUMBER No No Active A 4-digit numeric field that allows null values representing the total count of a given prey. 0 - 9999 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. 0 - 9999999999 PREY_PARTS CHAR No No Active A 1-digit character field that allows null values representing the parts code, if any, of the prey item. In addition to a null value, indicating no parts code used, parts codes are listed in Table 7. PREY_TWT NUMBER No No Active An 8.3-digit numeric field that does not allow null values representing the total weight (g) of a given prey. 0 - 8005.64 QUARTER NUMBER No No Active A one-digit numeric field that allows null values representing the quarter from which the sample was collected. 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 - 1189 START_HOUR NUMBER No No Active A 4-digit numeric field that allows null values representing the 24-hour time at which the trawl from which the predator was collected began. 0 - 9999 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. Acceptable values are 2, representing REEM personnel shipboard scans, 3, representing laboratory scans, 4, representing non-REEM personnel shipboard scans and all shipboard scans performed prior to 2004, 6, representing quantitative laboratory analysis (pred-prey form or all prey weighed), and 9, representing plant collected (observer) 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 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 - 4081 gov.noaa.nmfs.inport:22160 Angie Greig 2014-09-02T16:45:33 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