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

Summary

Abstract

7 - Child Table to Smolt Data for ATS specific Injury Data.

Description

7 - Child Table to Smolt Data for ATS specific Injury Data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
INOID
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
InjuryCode
Text
MaineSalmon code for the type of injury observed
LocationCode
Text
MaineSalmon code for the area of the fish wherethe injury was observed
InjurySeverity
Text
Code for severity of injury and probabilioty of mortality
InjurySource
Text
Code for location where injury occurred (Internal or External to trap, and Handling)
Comments
Memo
Comments that describe injury in greater detail and the conditions which may have caused injury

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

7 - Child Table to Smolt Data for ATS specific Injury Data.

Entity Information

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

7 - Child Table to Smolt Data for ATS specific Injury Data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
INOID 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
InjuryCode Text MaineSalmon code for the type of injury observed
100
LocationCode Text MaineSalmon code for the area of the fish wherethe injury was observed
100
InjurySeverity Text Code for severity of injury and probabilioty of mortality
100
InjurySource Text Code for location where injury occurred (Internal or External to trap, and Handling)
100
Comments Memo Comments that describe injury in greater detail and the conditions which may have caused injury

Attribute Details

INOID

CC ID: 343406
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: 343407
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

InjuryCode

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

MaineSalmon code for the type of injury observed

General Data Type: Text

LocationCode

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

MaineSalmon code for the area of the fish wherethe injury was observed

General Data Type: Text

InjurySeverity

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

Code for severity of injury and probabilioty of mortality

General Data Type: Text

InjurySource

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

Code for location where injury occurred (Internal or External to trap, and Handling)

General Data Type: Text

Comments

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

Comments that describe injury in greater detail and the conditions which may have caused injury

General Data Type: Memo

Catalog Details

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