Metadata Rubric

100%

6 / 6

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

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

	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

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