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) > Atlantic Salmon Smolt Monitoring >

SmoltData

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

Summary

Abstract

2 - Master Data Table for ATS data

Description

2 - Master Data Table for ATS data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SID
AutoNumber 		Internal ID # used by Visual CE to synch with Access
TendID
Text 		Unique ID for each tending event, used as a relational link to the TrapData table
JoinID
Text 		Unique ID for each smolt, used as the link between related salmon data tables
SpeciesCode
Text 		MaineSalmon Species Code for the species captured
Fish#
Integer 		Sequence # for each smolt captured in a given day
LifeStageCode
Text 		MaineSalmon LifeStageCode for each salmon captured
DorsalScore
Long Integer 		Erosion intensity score for the dorsal fin of each smolt
SmoltScore
Long Integer 		Score of degree of "smoltiness" for each smolt captured
ForkLength
Double 		Fork length of captured salmon in millimeters
TotalLength
Integer 		Total legth of captured salmon in millimeters
Weight
Double 		Weight of species in grams
Count
Integer 		# of individuals being recorded (usually for fry or other species)
RECAP
Text 		Same site, inseason recapture (RECAP) or initial capture (NEWFISH)
Disposition
Text 		Disposition of fish after work-up is complete
Origin
Text 		Origin of Birth of salmon captured.
OriginMethod
Text 		Method used in determing the Origin of salmon (e.g. Scale Reading, Mark Observed, Visual Observation or Prorate)
AgeCode
Text 		Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture.
AgeMethod
Text 		Method used in determining the Age of a salmon (e.g. Scale Reading, Mark Observed)
AOMethod
Text 		Method used in determining Age and Origin of salmon (i.e. Scale Reading, Visual Observation, Mark Observed, or Prorate)
Comments
Memo 		Additional comments about the species captured

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: SmoltData
Short Name: SmoltData
Status: Planned
Abstract:

2 - Master Data Table for ATS data

Entity Information

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

2 - Master Data Table for ATS data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SID AutoNumber Internal ID # used by Visual CE to synch with Access
100
 TendID Text Unique ID for each tending event, used as a relational link to the TrapData table
100
 JoinID Text Unique ID for each smolt, used as the link between related salmon data tables
100
 SpeciesCode Text MaineSalmon Species Code for the species captured
100
 Fish# Integer Sequence # for each smolt captured in a given day
100
 LifeStageCode Text MaineSalmon LifeStageCode for each salmon captured
100
 DorsalScore Long Integer Erosion intensity score for the dorsal fin of each smolt
100
 SmoltScore Long Integer Score of degree of "smoltiness" for each smolt captured
100
 ForkLength Double Fork length of captured salmon in millimeters
100
 TotalLength Integer Total legth of captured salmon in millimeters
100
 Weight Double Weight of species in grams
100
 Count Integer # of individuals being recorded (usually for fry or other species)
100
 RECAP Text Same site, inseason recapture (RECAP) or initial capture (NEWFISH)
100
 Disposition Text Disposition of fish after work-up is complete
100
 Origin Text Origin of Birth of salmon captured.
100
 OriginMethod Text Method used in determing the Origin of salmon (e.g. Scale Reading, Mark Observed, Visual Observation or Prorate)
100
 AgeCode Text Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture.
100
 AgeMethod Text Method used in determining the Age of a salmon (e.g. Scale Reading, Mark Observed)
100
 AOMethod Text Method used in determining Age and Origin of salmon (i.e. Scale Reading, Visual Observation, Mark Observed, or Prorate)
100
 Comments Memo Additional comments about the species captured

Attribute Details

SID

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

Internal ID # used by Visual CE to synch with Access
General Data Type: Number

TendID

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

Unique ID for each tending event, used as a relational link to the TrapData table
General Data Type: Text

JoinID

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

Unique ID for each smolt, used as the link between related salmon data tables
General Data Type: Text

SpeciesCode

CC ID: 343495
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

MaineSalmon Species Code for the species captured
General Data Type: Text

Fish#

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

Sequence # for each smolt captured in a given day
General Data Type: Number

LifeStageCode

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

MaineSalmon LifeStageCode for each salmon captured
General Data Type: Text

DorsalScore

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

Erosion intensity score for the dorsal fin of each smolt
General Data Type: Number

SmoltScore

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

Score of degree of "smoltiness" for each smolt captured
General Data Type: Number

ForkLength

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

Fork length of captured salmon in millimeters
General Data Type: Number

TotalLength

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

Total legth of captured salmon in millimeters
General Data Type: Number

Weight

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

Weight of species in grams
General Data Type: Number

Count

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

# of individuals being recorded (usually for fry or other species)
General Data Type: Number

RECAP

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

Same site, inseason recapture (RECAP) or initial capture (NEWFISH)
General Data Type: Text

Disposition

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

Disposition of fish after work-up is complete
General Data Type: Text

Origin

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

Origin of Birth of salmon captured.
General Data Type: Text

OriginMethod

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

Method used in determing the Origin of salmon (e.g. Scale Reading, Mark Observed, Visual Observation or Prorate)
General Data Type: Text

AgeCode

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

Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture.
General Data Type: Text

AgeMethod

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

Method used in determining the Age of a salmon (e.g. Scale Reading, Mark Observed)
General Data Type: Text

AOMethod

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

Method used in determining Age and Origin of salmon (i.e. Scale Reading, Visual Observation, Mark Observed, or Prorate)
General Data Type: Text

Comments

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

Additional comments about the species captured
General Data Type: Memo

Catalog Details

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