NewStomachContent
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27941 | Updated: August 9, 2022 | Published / External
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
|
|
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 |