Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Northeast Salmon Team (NEST) > Penobscot Estuary (Maine) Monitoring >

tblBioData

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

Summary

Abstract

Morphological data on individual fish from surveys

Description

Morphological data on individual fish from surveys

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BioID
AutoNumber 		Unique ID number for fish speciman, autogenerated number
CatchID
Long Integer 		Unique ID number for catch relational link to tblCatch
FishID
Text 		Unique speciman ID concatinating StationCode+SpeciesCode+BioID
FishNumber
Long Integer 		No Description available
TotalLength
Double 		Measured Standard total length in mm for fish, taken from tip of snout to extent of longest caudal fin lobe
ForkLength
Double 		Measured fork total length in mm for fish, taken from tip of snout to intersect of upper and lower caudal fin lobe
Weight
Double 		Measured wetted mass of fish in grams
Sex
Text 		Sex of individual as confirmed by morphology, dissection or external evidence of gametes
Maturity
Text 		Sexual maturity of individual as confirmed by dissection
Disposition
Text 		Individual dispostion (already included in batch disposition tblCatchData)
SampleTaken
Yes/No 		Was tissue sample taken? i.e. scale sample, genetic sample, physiology, gut, etc.
SampleNumber
Text 		Easy ID of sample taken, used interim until valid FishID is created and sample labeled
MarkObserved
Text 		Hatchery applied mark observed i.e. fin clip or external tag such as VIE, carlin, etc.
MarkApplied
Text 		Any mark applied in field for later identification i.e. upper caudal punch or clip (UCP/UC)
SmoScore
Text 		Smolt score observed for individual, applies only to Atlantic salmon juvenile caught in spring.
FinScore
Text 		Fin score observed for individual, quantifying the degree of fin erosion. Used to identify hatchery reared individuals, applies only to Atlantic salmon.
Comments
Memo 		Notes of individual fish
CatchCode
Text 		No Description available
AgeOrigin
Text 		No Description available

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: tblBioData
Short Name: tblBioData
Abstract:

Morphological data on individual fish from surveys

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Morphological data on individual fish from surveys

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BioID AutoNumber Unique ID number for fish speciman, autogenerated number
100
 CatchID Long Integer Unique ID number for catch relational link to tblCatch
100
 FishID Text Unique speciman ID concatinating StationCode+SpeciesCode+BioID
100
 FishNumber Long Integer No Description available
100
 TotalLength Double Measured Standard total length in mm for fish, taken from tip of snout to extent of longest caudal fin lobe
100
 ForkLength Double Measured fork total length in mm for fish, taken from tip of snout to intersect of upper and lower caudal fin lobe
100
 Weight Double Measured wetted mass of fish in grams
100
 Sex Text Sex of individual as confirmed by morphology, dissection or external evidence of gametes
100
 Maturity Text Sexual maturity of individual as confirmed by dissection
100
 Disposition Text Individual dispostion (already included in batch disposition tblCatchData)
100
 SampleTaken Yes/No Was tissue sample taken? i.e. scale sample, genetic sample, physiology, gut, etc.
100
 SampleNumber Text Easy ID of sample taken, used interim until valid FishID is created and sample labeled
100
 MarkObserved Text Hatchery applied mark observed i.e. fin clip or external tag such as VIE, carlin, etc.
100
 MarkApplied Text Any mark applied in field for later identification i.e. upper caudal punch or clip (UCP/UC)
100
 SmoScore Text Smolt score observed for individual, applies only to Atlantic salmon juvenile caught in spring.
100
 FinScore Text Fin score observed for individual, quantifying the degree of fin erosion. Used to identify hatchery reared individuals, applies only to Atlantic salmon.
100
 Comments Memo Notes of individual fish
100
 CatchCode Text No Description available
100
 AgeOrigin Text No Description available

Attribute Details

BioID

CC ID: 342439
Data Storage Type: AutoNumber
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID number for fish speciman, autogenerated number
General Data Type: Number

CatchID

CC ID: 342440
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID number for catch relational link to tblCatch
General Data Type: Number

FishID

CC ID: 342441
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique speciman ID concatinating StationCode+SpeciesCode+BioID
General Data Type: Text

FishNumber

CC ID: 342442
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

No Description available
General Data Type: Number

TotalLength

CC ID: 342443
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured Standard total length in mm for fish, taken from tip of snout to extent of longest caudal fin lobe
General Data Type: Number

ForkLength

CC ID: 342444
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured fork total length in mm for fish, taken from tip of snout to intersect of upper and lower caudal fin lobe
General Data Type: Number

Weight

CC ID: 342445
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured wetted mass of fish in grams
General Data Type: Number

Sex

CC ID: 342446
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Sex of individual as confirmed by morphology, dissection or external evidence of gametes
General Data Type: Text

Maturity

CC ID: 342447
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Sexual maturity of individual as confirmed by dissection
General Data Type: Text

Disposition

CC ID: 342448
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Individual dispostion (already included in batch disposition tblCatchData)
General Data Type: Text

SampleTaken

CC ID: 342449
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Was tissue sample taken? i.e. scale sample, genetic sample, physiology, gut, etc.
General Data Type: Yes/No

SampleNumber

CC ID: 342450
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Easy ID of sample taken, used interim until valid FishID is created and sample labeled
General Data Type: Text

MarkObserved

CC ID: 342451
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Hatchery applied mark observed i.e. fin clip or external tag such as VIE, carlin, etc.
General Data Type: Text

MarkApplied

CC ID: 342452
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Any mark applied in field for later identification i.e. upper caudal punch or clip (UCP/UC)
General Data Type: Text

SmoScore

CC ID: 342453
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Smolt score observed for individual, applies only to Atlantic salmon juvenile caught in spring.
General Data Type: Text

FinScore

CC ID: 342454
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Fin score observed for individual, quantifying the degree of fin erosion. Used to identify hatchery reared individuals, applies only to Atlantic salmon.
General Data Type: Text

Comments

CC ID: 342455
Data Storage Type: Memo
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Notes of individual fish
General Data Type: Memo

CatchCode

CC ID: 342456
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

No Description available
General Data Type: Text

AgeOrigin

CC ID: 342457
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

No Description available
General Data Type: Text

Catalog Details

Catalog Item ID: 34058
GUID: gov.noaa.nmfs.inport:34058
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-03 14:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-08
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-08