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

Summary

Abstract

6 - Child Table to Smolt Data for ATS specific Mark and Sample Data.

Description

6 - Child Table to Smolt Data for ATS specific Mark and Sample Data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SMOID
AutoNumber
Internal ID # used by Visual CE to synch with Access
JoinId
Text
Unique ID for each smolt, used as the link between related salmon data tables
ObsApp
Text
Indicates whether the Mark was observed or applied
Type
Text
The type of mark or sample. Lookup from MaineSalmon CodeMarks.
TagColor
Text
Color of tags observed or applied, if not applicable value = "NoData"
Number
Text
Tag # ifobserved or applied; OR the sample # for scale envelope or genetics vial; if not applicable value = "None", if missing value = "NoData"
LocationCode
Text
Location on the fish where observation or application occurred. Lookup from MaineSalmon CodeAnatomy.

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: SampleMarks
Short Name: SampleMarks
Status: Planned
Abstract:

6 - Child Table to Smolt Data for ATS specific Mark and Sample Data.

Entity Information

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

6 - Child Table to Smolt Data for ATS specific Mark and Sample Data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SMOID AutoNumber Internal ID # used by Visual CE to synch with Access
100
JoinId Text Unique ID for each smolt, used as the link between related salmon data tables
100
ObsApp Text Indicates whether the Mark was observed or applied
100
Type Text The type of mark or sample. Lookup from MaineSalmon CodeMarks.
100
TagColor Text Color of tags observed or applied, if not applicable value = "NoData"
100
Number Text Tag # ifobserved or applied; OR the sample # for scale envelope or genetics vial; if not applicable value = "None", if missing value = "NoData"
100
LocationCode Text Location on the fish where observation or application occurred. Lookup from MaineSalmon CodeAnatomy.

Attribute Details

SMOID

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

JoinId

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

Unique ID for each smolt, used as the link between related salmon data tables

General Data Type: Text

ObsApp

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

Indicates whether the Mark was observed or applied

General Data Type: Text

Type

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

The type of mark or sample. Lookup from MaineSalmon CodeMarks.

General Data Type: Text

TagColor

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

Color of tags observed or applied, if not applicable value = "NoData"

General Data Type: Text

Number

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

Tag # ifobserved or applied; OR the sample # for scale envelope or genetics vial; if not applicable value = "None", if missing value = "NoData"

General Data Type: Text

LocationCode

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

Location on the fish where observation or application occurred. Lookup from MaineSalmon CodeAnatomy.

General Data Type: Text

Catalog Details

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