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