Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Auke Bay Laboratories > AFSC/ABL: Fish, Energy, Diet, and Zooplankton (... >

Fish

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:27939  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains the bioenergetic data for all fish anylized.

Description

This table contains the bioenergetic data for all fish anylized.

Entity Information

Data Attribute / Type Description
Unique_ID
Unknown 		Used to link Fish table to ADFG-GOA table
UI_SECM_HAUL
Unknown 		Unique id for SECM samples to link to SECM database Haul table
UI_GOA_STATIONNAME
Unknown 		Unique id for GOAIERP & GOA samples to link to GOA database Station table
UI_YUKON_SAMPLEID
Unknown 		Unique id for Yukon samples to link to Yukon database Samples table
UI_EMA_ALTSTATIONNAME
Unknown 		Unique id for EMA samples to link to EMA database CATCH table
Year
Unknown 		year sample was collected
Project
VARCHAR2 		name of project collecting samples, see project table
Species
VARCHAR2 		species of fish
TSN_species
Unknown 		unique identifier for species code - see Species_TSN_lookup table
Station#/Haul#
Unknown 		Station where fish was captured
FIN
Unknown 		Fish Identification Number = YYYYPPFFFF: Y is year, P is project (see project table), F is four digit fish #
FEDZ_Fish#
Unknown 		Unique number assigned to each fish, not unique between species - Used prior to 2014 sampling.
Field_Fish#
Unknown 		number assigned to the fish in the field, must be linked to station and species to be unique - Used prior to 2014 sampling
SIN
Unknown 		Sample Identification Number, unique identifier to the NUT lab projects
Length
Unknown 		frozen fork length (mm) of fish
Weight
Unknown 		frozen weight (g) of fish
StomachFull
Unknown 		weight (g) of stomach with contents
StomachEmpty
Unknown 		weight (g) of stomach without contents
Content_wt_method
Unknown 		1 = subtraction, 2 = prey weight (empty weight will be 0)
Full
Unknown 		stomach fullness (percent)
TrayWt
Unknown 		weight of tray
DryWtWithTray
Unknown 		weight of dried fish & tray
%DW
Unknown 		percent dry weight of energy fish
cal/gDW
Unknown 		calories per gram dry weight of energy fish (this is the data output from the calorimeter)
cal/gWW
Unknown 		calories per gram wet weight of energy fish
ProcDate
Unknown 		date stomach was processed
Processor
Unknown 		name of processor
Length/weight
VARCHAR2 		Yes if length and/or weight was taken on fish
Otoltih
VARCHAR2 		Yes if otolith was removed
Genetics
VARCHAR2 		Yes if genetic clip was taken
DietFish
VARCHAR2 		If fish was processed for diet
EnergyFish
VARCHAR2 		If fish was processed for energy
CWT
VARCHAR2 		If fish had a cwt or was missing it's adipose fin, cwt information is in the cwt table
Comments
Unknown 		comments about fish or processing

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

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

This table contains the bioenergetic data for all fish anylized.
Notes:

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

Entity Information

Description:

This table contains the bioenergetic data for all fish anylized.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Unique_ID Unknown Used to link Fish table to ADFG-GOA table
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
 Year Unknown year sample was collected
100
 Project VARCHAR2 name of project collecting samples, see project table
100
 Species VARCHAR2 species of fish
100
 TSN_species Unknown unique identifier for species code - see Species_TSN_lookup table
100
 Station#/Haul# Unknown Station where fish was captured
100
 FIN Unknown Fish Identification Number = YYYYPPFFFF: Y is year, P is project (see project table), F is four digit fish #
100
 FEDZ_Fish# Unknown Unique number assigned to each fish, not unique between species - Used prior to 2014 sampling.
100
 Field_Fish# Unknown number assigned to the fish in the field, must be linked to station and species to be unique - Used prior to 2014 sampling
100
 SIN Unknown Sample Identification Number, unique identifier to the NUT lab projects
100
 Length Unknown frozen fork length (mm) of fish
100
 Weight Unknown frozen weight (g) of fish
100
 StomachFull Unknown weight (g) of stomach with contents
100
 StomachEmpty Unknown weight (g) of stomach without contents
100
 Content_wt_method Unknown 1 = subtraction, 2 = prey weight (empty weight will be 0)
100
 Full Unknown stomach fullness (percent)
100
 TrayWt Unknown weight of tray
100
 DryWtWithTray Unknown weight of dried fish & tray
100
 %DW Unknown percent dry weight of energy fish
100
 cal/gDW Unknown calories per gram dry weight of energy fish (this is the data output from the calorimeter)
100
 cal/gWW Unknown calories per gram wet weight of energy fish
100
 ProcDate Unknown date stomach was processed
100
 Processor Unknown name of processor
100
 Length/weight VARCHAR2 Yes if length and/or weight was taken on fish
100
 Otoltih VARCHAR2 Yes if otolith was removed
100
 Genetics VARCHAR2 Yes if genetic clip was taken
100
 DietFish VARCHAR2 If fish was processed for diet
100
 EnergyFish VARCHAR2 If fish was processed for energy
100
 CWT VARCHAR2 If fish had a cwt or was missing it's adipose fin, cwt information is in the cwt table
100
 Comments Unknown comments about fish or processing

Attribute Details

Unique_ID

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

Used to link Fish table to ADFG-GOA table
Allowed Values: No domain defined.

UI_SECM_HAUL

CC ID: 232289
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: 232290
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: 232291
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: 232292
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.

Year

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

year sample was collected
Allowed Values: No domain defined.

Project

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

name of project collecting samples, see project table
Allowed Values: ACES, ArcticEIS, BSIERP-BASIS12, EMA, EVOS-HCM, Freezer longevity, GOA, GOA/ADFG, GOAIERP, NBS, SEBS, SECM, Yukon-LPW, Yukon-Offshore, Yukon-River

Species

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

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

TSN_species

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

unique identifier for species code - see Species_TSN_lookup table
Allowed Values: No domain defined.

Station#/Haul#

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

Station where fish was captured
Allowed Values: No domain defined.

FIN

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

Fish Identification Number = YYYYPPFFFF: Y is year, P is project (see project table), F is four digit fish #
Allowed Values: No domain defined.

FEDZ_Fish#

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

Unique number assigned to each fish, not unique between species - Used prior to 2014 sampling.
Allowed Values: No domain defined.

Field_Fish#

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

number assigned to the fish in the field, must be linked to station and species to be unique - Used prior to 2014 sampling
Allowed Values: No domain defined.

SIN

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

Sample Identification Number, unique identifier to the NUT lab projects
Allowed Values: No domain defined.

Length

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

frozen fork length (mm) of fish
Allowed Values: No domain defined.

Weight

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

frozen weight (g) of fish
Allowed Values: No domain defined.

StomachFull

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

weight (g) of stomach with contents
Allowed Values: No domain defined.

StomachEmpty

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

weight (g) of stomach without contents
Allowed Values: No domain defined.

Content_wt_method

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

1 = subtraction, 2 = prey weight (empty weight will be 0)
Allowed Values: No domain defined.

Full

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

stomach fullness (percent)
Allowed Values: No domain defined.

TrayWt

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

weight of tray
Allowed Values: No domain defined.

DryWtWithTray

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

weight of dried fish & tray
Allowed Values: No domain defined.

%DW

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

percent dry weight of energy fish
Allowed Values: No domain defined.

cal/gDW

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

calories per gram dry weight of energy fish (this is the data output from the calorimeter)
Allowed Values: No domain defined.

cal/gWW

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

calories per gram wet weight of energy fish
Allowed Values: No domain defined.

ProcDate

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

date stomach was processed
Allowed Values: No domain defined.

Processor

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

name of processor
Allowed Values: No domain defined.

Length/weight

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

Yes if length and/or weight was taken on fish
Allowed Values: False, True

Otoltih

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

Yes if otolith was removed
Allowed Values: False, True

Genetics

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

Yes if genetic clip was taken
Allowed Values: False, True

DietFish

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

If fish was processed for diet
Allowed Values: False, True

EnergyFish

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

If fish was processed for energy
Allowed Values: False, True

CWT

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

If fish had a cwt or was missing it's adipose fin, cwt information is in the cwt table
Allowed Values: False, True

Comments

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

comments about fish or processing
Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 27939
GUID: gov.noaa.nmfs.inport:27939
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