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 Telemetry Monitoring >

tblSmoltDetails (2005,2006,2008,2009,2010,2011,2012,2013,2015)

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

Summary

Abstract

2 Data table of Smolt biological info, release and capture history

Description

2 Data table of Smolt biological info, release and capture history (Format used for 2005,2006,2008,2009,2010 data)

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SmoltDetailsID
AutoNumber 		Unique value assigned for primary key (referential integrity)
FishNum
Long Integer 		Number assigned to individual fish
CaptureDate
Date/Time 		Date/time of origianl capture for individual (for offsite captures such as upriver RST)
CaptureSiteCode
Text 		MaineSalmon location of capture for individual (for offsite captures such as upriver RST)
CaptureGearCode
Text 		Gear used for capture of individual (for offsite captures such as upriver RST or downstream bypass)
LifeStageCode
Text 		MaineSalmon lifestage Code for the species captured
SpeciesCode
Text 		MaineSalmon Species Code for the species 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 individual in millimeters
TotalLength
Integer 		Total legth of individual in millimeters
Weight
Double 		Weight of individual in grams
OriginCode
Text 		Origin of individiual (wild, parr stocked or hatchery smolt)
ParrCode
Text 		Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture (e.g. P8 or p20)
PingerIDCode
Long Integer 		The IDCode (code reported by detection gear) for the pinger
Surgeon
Text 		Initials of surgeon implanting pinger
SurgeryTime
Date/Time 		Time of pinger implantation surgery (in UTC!!!!)
SurgeryDate
Date/Time 		Date of pinger implantation surgery
RelSiteCode
Text 		MaineSalmon sitecode for release location
RelDateTime
Date/Time 		Date and Time of release (Time in UTC!!!!)
TankTemp
Double 		Water temperature of transport tank (e.g. xactic) in C
RiverTemp
Double 		Water temperature of river at release location (e.g. xactic) in C
Comments
Memo 		Comments regarding individual or release (e.g. marks, surgery notes, pinger notes)
Fate
Text 		Assigned Fate of Smolt Transmitter Tagged (2005, 2006, 2008 data formats only)

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: tblSmoltDetails (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Short Name: tblSmoltDetails (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Status: Completed
Abstract:

2 Data table of Smolt biological info, release and capture history

Entity Information

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

2 Data table of Smolt biological info, release and capture history (Format used for 2005,2006,2008,2009,2010 data)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SmoltDetailsID AutoNumber Unique value assigned for primary key (referential integrity)
100
 FishNum Long Integer Number assigned to individual fish
100
 CaptureDate Date/Time Date/time of origianl capture for individual (for offsite captures such as upriver RST)
100
 CaptureSiteCode Text MaineSalmon location of capture for individual (for offsite captures such as upriver RST)
100
 CaptureGearCode Text Gear used for capture of individual (for offsite captures such as upriver RST or downstream bypass)
100
 LifeStageCode Text MaineSalmon lifestage Code for the species captured
100
 SpeciesCode Text MaineSalmon Species Code for the species 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 individual in millimeters
100
 TotalLength Integer Total legth of individual in millimeters
100
 Weight Double Weight of individual in grams
100
 OriginCode Text Origin of individiual (wild, parr stocked or hatchery smolt)
100
 ParrCode Text Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture (e.g. P8 or p20)
100
 PingerIDCode Long Integer The IDCode (code reported by detection gear) for the pinger
100
 Surgeon Text Initials of surgeon implanting pinger
100
 SurgeryTime Date/Time Time of pinger implantation surgery (in UTC!!!!)
100
 SurgeryDate Date/Time Date of pinger implantation surgery
100
 RelSiteCode Text MaineSalmon sitecode for release location
100
 RelDateTime Date/Time Date and Time of release (Time in UTC!!!!)
100
 TankTemp Double Water temperature of transport tank (e.g. xactic) in C
100
 RiverTemp Double Water temperature of river at release location (e.g. xactic) in C
100
 Comments Memo Comments regarding individual or release (e.g. marks, surgery notes, pinger notes)
100
 Fate Text Assigned Fate of Smolt Transmitter Tagged (2005, 2006, 2008 data formats only)

Attribute Details

SmoltDetailsID

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

Unique value assigned for primary key (referential integrity)
General Data Type: Number

FishNum

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

Number assigned to individual fish
General Data Type: Number

CaptureDate

CC ID: 343835
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date/time of origianl capture for individual (for offsite captures such as upriver RST)
General Data Type: Date/Time

CaptureSiteCode

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

MaineSalmon location of capture for individual (for offsite captures such as upriver RST)
General Data Type: Text

CaptureGearCode

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

Gear used for capture of individual (for offsite captures such as upriver RST or downstream bypass)
General Data Type: Text

LifeStageCode

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

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

SpeciesCode

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

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

DorsalScore

CC ID: 343840
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: 343841
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: 343842
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Fork length of individual in millimeters
General Data Type: Number

TotalLength

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

Total legth of individual in millimeters
General Data Type: Number

Weight

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

Weight of individual in grams
General Data Type: Number

OriginCode

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

Origin of individiual (wild, parr stocked or hatchery smolt)
General Data Type: Text

ParrCode

CC ID: 343846
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 (e.g. P8 or p20)
General Data Type: Text

PingerIDCode

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

The IDCode (code reported by detection gear) for the pinger
General Data Type: Number

Surgeon

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

Initials of surgeon implanting pinger
General Data Type: Text

SurgeryTime

CC ID: 343849
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time of pinger implantation surgery (in UTC!!!!)
General Data Type: Date/Time

SurgeryDate

CC ID: 343850
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date of pinger implantation surgery
General Data Type: Date/Time

RelSiteCode

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

MaineSalmon sitecode for release location
General Data Type: Text

RelDateTime

CC ID: 343852
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date and Time of release (Time in UTC!!!!)
General Data Type: Date/Time

TankTemp

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

Water temperature of transport tank (e.g. xactic) in C
General Data Type: Number

RiverTemp

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

Water temperature of river at release location (e.g. xactic) in C
General Data Type: Number

Comments

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

Comments regarding individual or release (e.g. marks, surgery notes, pinger notes)
General Data Type: Memo

Fate

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

Assigned Fate of Smolt Transmitter Tagged (2005, 2006, 2008 data formats only)
General Data Type: Text

Catalog Details

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