PREDPREY

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.

This is a 4-digit numeric field that does not accept null values, acceptable values are any four-digit year.

A 4-digit numeric field that does not accept null values, acceptable values are any vessel code

A 4-digit numeric field that does not accept null values, acceptable values are any cruise code.

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.

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.

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.

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.

A 3-digit numeric field that does not allow null values representing the haul number from which the associated stomach data were collected.

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.

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.

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.

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.

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.

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.

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.

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

A 4-digit numeric field that allows null values representing the total count of a given prey.

An 8.3-digit numeric field that does not allow null values representing the total weight (g) of a given prey.

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.

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.

A 4.1-digit numeric field that does not allow null values representing the fork length (cm) of the predator.

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.

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.

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.

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.

A 12-digit numeric field that uniquely identifies a given stomach sample.

A 100 place character field that allows comments about the related predator or prey.

A 12-digit numeric field that uniquely identifies a given prey record.