Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: NewStomachContent
Short Name: NewStomachContent
Status: In Work
Abstract:

This table contains the diet information, data is entered at the station level.

Notes:

Loaded by FGDC Metadata Uploader, batch 7301, 10-13-2015 19:37

Entity Information

Description:

This table contains the diet information, data is entered at the station level.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Project Unknown Project the data is associated with
100
Year Unknown Year the samples were collected from field
100
Species VARCHAR2 species of fish examined, limited to pink, chum, sockeye, coho, chinook
100
TSN_species Unknown unique species number - see SpeciesTSN_lookup Table
100
LHS Unknown life history stage of predator
100
Station# Unknown station #, redundant from fish table
100
SIN Unknown unique # assigned to a fish or a composite of fish stomachs
100
PreySpecies Unknown species of prey, limited to PreyName table
100
Size/Stage Unknown size range of prey &/or stage of prey
100
Count Unknown count of indv. taxa
100
Weight Unknown weight of taxa group
100
Digestion Unknown digestion code, limited
100
Notes Unknown -no description-
100
ProcessingDate Unknown date sample was processed
100
Processor Unknown -no description-
100
UI_SECM_HAUL Unknown Unique id for SECM samples to link to SECM database Haul table
100
UI_GOA_STATIONNAME Unknown Unique id for GOAIERP & GOA samples to link to GOA database Station table
100
UI_YUKON_SAMPLEID Unknown Unique id for Yukon samples to link to Yukon database Samples table
100
UI_EMA_ALTSTATIONNAME Unknown Unique id for EMA samples to link to EMA database CATCH table
100
UI_MISC_PROJECT_STATION Unknown Unique id for miscellaneous samples usually station or event number/name

Attribute Details

Project

CC ID: 232324
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Project the data is associated with

Allowed Values: No domain defined.

Year

CC ID: 232325
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Year the samples were collected from field

Allowed Values: No domain defined.

Species

CC ID: 232326
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

species of fish examined, limited to pink, chum, sockeye, coho, chinook

Allowed Values: ATF, Chinook salmon, Chum salmon, Coho salmon, Pacific cod, Pink salmon, Pollock, Rockfish, Sockeye salmon

TSN_species

CC ID: 232327
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

unique species number - see SpeciesTSN_lookup Table

Allowed Values: No domain defined.

LHS

CC ID: 232328
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

life history stage of predator

Allowed Values: No domain defined.

Station#

CC ID: 232329
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

station #, redundant from fish table

Allowed Values: No domain defined.

SIN

CC ID: 232330
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

unique # assigned to a fish or a composite of fish stomachs

Allowed Values: No domain defined.

PreySpecies

CC ID: 232331
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

species of prey, limited to PreyName table

Allowed Values: see PreyName table for list of prey species

Size/Stage

CC ID: 232332
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

size range of prey &/or stage of prey

Allowed Values: No domain defined.

Count

CC ID: 232333
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

count of indv. taxa

Allowed Values: No domain defined.

Weight

CC ID: 232334
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

weight of taxa group

Allowed Values: No domain defined.

Digestion

CC ID: 232335
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

digestion code, limited

Allowed Values: No domain defined.

Notes

CC ID: 232336
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

-no description-

Allowed Values: No domain defined.

ProcessingDate

CC ID: 232337
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

date sample was processed

Allowed Values: No domain defined.

Processor

CC ID: 232338
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

-no description-

Allowed Values: No domain defined.

UI_SECM_HAUL

CC ID: 232339
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique id for SECM samples to link to SECM database Haul table

Allowed Values: No domain defined.

UI_GOA_STATIONNAME

CC ID: 232340
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique id for GOAIERP & GOA samples to link to GOA database Station table

Allowed Values: No domain defined.

UI_YUKON_SAMPLEID

CC ID: 232341
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique id for Yukon samples to link to Yukon database Samples table

Allowed Values: No domain defined.

UI_EMA_ALTSTATIONNAME

CC ID: 232342
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique id for EMA samples to link to EMA database CATCH table

Allowed Values: No domain defined.

UI_MISC_PROJECT_STATION

CC ID: 232343
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique id for miscellaneous samples usually station or event number/name

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 27941
GUID: gov.noaa.nmfs.inport:27941
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-10-13 19:37+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-05-24
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-24