Slide Menu
Search Help Show/Hide Menu

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