SmoltData
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34163 | Updated: August 9, 2022 | Published / External
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
|
|
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 |