Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

5 - Child Data Table related to tbl TrapData of Other Species Bycatch.

Description

5 - Child Data Table related to tbl TrapData of Other Species Bycatch.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OSOID
AutoNumber
Internal ID # used by Visual CE to synch with Access
TendID
Text
Unique ID for each tending event, used as a relational link to the TrapData table
SpeciesCode
Text
MaineSalmon Species Code for the species captured
Lifestage
Text
Lifestage of individual or group counted
Count
Integer
# of individuals being recorded (usually for fry or other species)
ForkLength
Double
Individual Fork Length (in mm) of species if applicable
TotalLength
Double
Individual Total Length (in mm) of species if applicable
Weight
Double
Individual weight (in grams) of species counted
Disposition
Text
Disposition of catch; same options as for ATS
OS Comments
Memo
Comments related to individual or group of fish recorded

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Otherspecies
Short Name: Otherspecies
Status: Planned
Abstract:

5 - Child Data Table related to tbl TrapData of Other Species Bycatch.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

5 - Child Data Table related to tbl TrapData of Other Species Bycatch.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OSOID 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
SpeciesCode Text MaineSalmon Species Code for the species captured
100
Lifestage Text Lifestage of individual or group counted
100
Count Integer # of individuals being recorded (usually for fry or other species)
100
ForkLength Double Individual Fork Length (in mm) of species if applicable
100
TotalLength Double Individual Total Length (in mm) of species if applicable
100
Weight Double Individual weight (in grams) of species counted
100
Disposition Text Disposition of catch; same options as for ATS
100
OS Comments Memo Comments related to individual or group of fish recorded

Attribute Details

OSOID

CC ID: 343475
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: 343476
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

SpeciesCode

CC ID: 343477
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

Lifestage

CC ID: 343478
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Lifestage of individual or group counted

General Data Type: Text

Count

CC ID: 343479
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

ForkLength

CC ID: 343480
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Individual Fork Length (in mm) of species if applicable

General Data Type: Number

TotalLength

CC ID: 343481
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Individual Total Length (in mm) of species if applicable

General Data Type: Number

Weight

CC ID: 343482
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Individual weight (in grams) of species counted

General Data Type: Number

Disposition

CC ID: 343483
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Disposition of catch; same options as for ATS

General Data Type: Text

OS Comments

CC ID: 343484
Data Storage Type: Memo
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Comments related to individual or group of fish recorded

General Data Type: Memo

Catalog Details

Catalog Item ID: 34161
GUID: gov.noaa.nmfs.inport:34161
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