tblCatchData
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34059 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | tblCatchData |
|---|---|
| Short Name: | tblCatchData |
| Abstract: |
Counts of fish by species captured during surveys |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Counts of fish by species captured during surveys |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
TripID | Long Integer | Relational field to parent table (tblTripData) | |
|
100
|
CatchID | AutoNumber | Relationally unique field | |
|
100
|
SpeciesCode | Text | Maine Salmon unique three letter code per species | |
|
100
|
TotalCount | Long Integer | Total number of individuals caught per event | |
|
100
|
CountDOA | Long Integer | Total number of individuals DOA per event | |
|
100
|
Lifestage | Text | Developmental lifestage of individual species i.e. Smolt, Adult, juvenile, etc. | |
|
100
|
BatchCount | Long Integer | Total number of individual species used for batch weight | |
|
100
|
BatchWeight | Double | Total weight (g) of individuals from the batch count per species | |
|
100
|
CountMethod | Text | Method of enumeration i.e. 'count' for hand count, 'prorate' for an extrapolated sample count, or 'visual' for visually estimated. | |
|
100
|
StationCode | Text | Concatinated ID of station number, sample date, and sitecode for unique ID of trip info from tblTripData | |
|
100
|
CatchCode | Text | Concatinated ID of station number, sample date, and sitecode for unique ID of catch info |
Attribute Details
TripID
CC ID: 342458
| Data Storage Type: | Long Integer |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Relational field to parent table (tblTripData) |
| General Data Type: | Number |
CatchID
CC ID: 342459
| Data Storage Type: | AutoNumber |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Relationally unique field |
| General Data Type: | Number |
SpeciesCode
CC ID: 342460
| Data Storage Type: | Text |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maine Salmon unique three letter code per species |
| General Data Type: | Text |
TotalCount
CC ID: 342461
| Data Storage Type: | Long Integer |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of individuals caught per event |
| General Data Type: | Number |
CountDOA
CC ID: 342462
| Data Storage Type: | Long Integer |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of individuals DOA per event |
| General Data Type: | Number |
Lifestage
CC ID: 342463
| Data Storage Type: | Text |
|---|---|
| Max Length: | 255 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Developmental lifestage of individual species i.e. Smolt, Adult, juvenile, etc. |
| General Data Type: | Text |
BatchCount
CC ID: 342464
| Data Storage Type: | Long Integer |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of individual species used for batch weight |
| General Data Type: | Number |
BatchWeight
CC ID: 342465
| Data Storage Type: | Double |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total weight (g) of individuals from the batch count per species |
| General Data Type: | Number |
CountMethod
CC ID: 342466
| Data Storage Type: | Text |
|---|---|
| Max Length: | 255 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Method of enumeration i.e. 'count' for hand count, 'prorate' for an extrapolated sample count, or 'visual' for visually estimated. |
| General Data Type: | Text |
StationCode
CC ID: 342467
| Data Storage Type: | Text |
|---|---|
| Max Length: | 255 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatinated ID of station number, sample date, and sitecode for unique ID of trip info from tblTripData |
| General Data Type: | Text |
CatchCode
CC ID: 342468
| Data Storage Type: | Text |
|---|---|
| Max Length: | 255 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatinated ID of station number, sample date, and sitecode for unique ID of catch info |
| General Data Type: | Text |
Catalog Details
| Catalog Item ID: | 34059 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:34059 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-08-03 14:01+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-08-08 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-08-08 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-08-08 |