tblSmoltDetails (2005,2006,2008,2009,2010,2011,2012,2013,2015)
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 34182
| Published / External
Created: 2016-08-09
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 27492
ID: 34182
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
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 |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
2 Data table of Smolt biological info, release and capture history |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
2 Data table of Smolt biological info, release and capture history (Format used for 2005,2006,2008,2009,2010 data) |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | SmoltDetailsID | AutoNumber | Unique value assigned for primary key (referential integrity) |
100 | No | No | FishNum | Long Integer | Number assigned to individual fish |
100 | No | No | CaptureDate | Date/Time | Date/time of origianl capture for individual (for offsite captures such as upriver RST) |
100 | No | No | CaptureSiteCode | Text | MaineSalmon location of capture for individual (for offsite captures such as upriver RST) |
100 | No | No | CaptureGearCode | Text | Gear used for capture of individual (for offsite captures such as upriver RST or downstream bypass) |
100 | No | No | LifeStageCode | Text | MaineSalmon lifestage Code for the species captured |
100 | No | No | SpeciesCode | Text | MaineSalmon Species Code for the species captured |
100 | No | No | DorsalScore | Long Integer | Erosion intensity score for the dorsal fin of each smolt |
100 | No | No | SmoltScore | Long Integer | Score of degree of "smoltiness" for each smolt captured |
100 | No | No | ForkLength | Double | Fork length of individual in millimeters |
100 | No | No | TotalLength | Integer | Total legth of individual in millimeters |
100 | No | No | Weight | Double | Weight of individual in grams |
100 | No | No | OriginCode | Text | Origin of individiual (wild, parr stocked or hatchery smolt) |
100 | No | No | ParrCode | Text | Age Code (related to MaineSalmon table CodeFreshwaterAge) of salmon at time of capture (e.g. P8 or p20) |
100 | Yes | No | PingerIDCode | Long Integer | The IDCode (code reported by detection gear) for the pinger |
100 | No | No | Surgeon | Text | Initials of surgeon implanting pinger |
100 | No | No | SurgeryTime | Date/Time | Time of pinger implantation surgery (in UTC!!!!) |
100 | No | No | SurgeryDate | Date/Time | Date of pinger implantation surgery |
100 | No | No | RelSiteCode | Text | MaineSalmon sitecode for release location |
100 | No | No | RelDateTime | Date/Time | Date and Time of release (Time in UTC!!!!) |
100 | No | No | TankTemp | Double | Water temperature of transport tank (e.g. xactic) in C |
100 | No | No | RiverTemp | Double | Water temperature of river at release location (e.g. xactic) in C |
100 | No | No | Comments | Memo | Comments regarding individual or release (e.g. marks, surgery notes, pinger notes) |
100 | No | No | Fate | Text | Assigned Fate of Smolt Transmitter Tagged (2005, 2006, 2008 data formats only) |
Attribute Details
Attribute Name | SmoltDetailsID |
---|---|
Seq. Order | |
Data Storage Type | AutoNumber |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique value assigned for primary key (referential integrity) |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FishNum |
---|---|
Seq. Order | |
Data Storage Type | Long Integer |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number assigned to individual fish |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CaptureDate |
---|---|
Seq. Order | |
Data Storage Type | Date/Time |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date/time of origianl capture for individual (for offsite captures such as upriver RST) |
General Data Type | Date/Time |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CaptureSiteCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
MaineSalmon location of capture for individual (for offsite captures such as upriver RST) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CaptureGearCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear used for capture of individual (for offsite captures such as upriver RST or downstream bypass) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LifeStageCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
MaineSalmon lifestage Code for the species captured |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SpeciesCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
MaineSalmon Species Code for the species captured |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DorsalScore |
---|---|
Seq. Order | |
Data Storage Type | Long Integer |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Erosion intensity score for the dorsal fin of each smolt |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SmoltScore |
---|---|
Seq. Order | |
Data Storage Type | Long Integer |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Score of degree of "smoltiness" for each smolt captured |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ForkLength |
---|---|
Seq. Order | |
Data Storage Type | Double |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fork length of individual in millimeters |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TotalLength |
---|---|
Seq. Order | |
Data Storage Type | Integer |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total legth of individual in millimeters |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Weight |
---|---|
Seq. Order | |
Data Storage Type | Double |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight of individual in grams |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OriginCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Origin of individiual (wild, parr stocked or hatchery smolt) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ParrCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PingerIDCode |
---|---|
Seq. Order | |
Data Storage Type | Long Integer |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The IDCode (code reported by detection gear) for the pinger |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Surgeon |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Initials of surgeon implanting pinger |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SurgeryTime |
---|---|
Seq. Order | |
Data Storage Type | Date/Time |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time of pinger implantation surgery (in UTC!!!!) |
General Data Type | Date/Time |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SurgeryDate |
---|---|
Seq. Order | |
Data Storage Type | Date/Time |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of pinger implantation surgery |
General Data Type | Date/Time |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RelSiteCode |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
MaineSalmon sitecode for release location |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RelDateTime |
---|---|
Seq. Order | |
Data Storage Type | Date/Time |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and Time of release (Time in UTC!!!!) |
General Data Type | Date/Time |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TankTemp |
---|---|
Seq. Order | |
Data Storage Type | Double |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Water temperature of transport tank (e.g. xactic) in C |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RiverTemp |
---|---|
Seq. Order | |
Data Storage Type | Double |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Water temperature of river at release location (e.g. xactic) in C |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Comments |
---|---|
Seq. Order | |
Data Storage Type | Memo |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments regarding individual or release (e.g. marks, surgery notes, pinger notes) |
General Data Type | Memo |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Fate |
---|---|
Seq. Order | |
Data Storage Type | Text |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Assigned Fate of Smolt Transmitter Tagged (2005, 2006, 2008 data formats only) |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-11-21 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-11-21 |
Tags |
---|