Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: GMRI_COD_RELEASE_FISH_TAG
Short Name: GMRI_COD_RELEASE_FISH_TAG
Status: Completed
Abstract:

Tecords the properties of each tag.

Notes:

Loaded by batch 9211, 08-23-2016 14:45

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CO_OP_RESEARCH
Description:

Tecords the properties of each tag.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
RELEASE_FISH_TAG_ID NUMBER Unique ID
100
RELEASE_FISH_ID NUMBER Identifies the fish capture associated with tag – from COD_RELEASE_FISH data table
100
TAG_NUMBER VARCHAR2 Number physically stamped on tag. In addition, field may contain: “US0000” for undersized, non-tagged fish OR, “PC0000” for poor condition non-tagged fish See FAQ for more information
100
SKIN_TAGGED NUMBER 0= Indicates not a skin tag 1= Indicates a skin tag
100
TAG_NUMBER_UNCERTAIN NUMBER 0= Indicates tag number is accurate 1= Indicates tag number is uncertain

Attribute Details

RELEASE_FISH_TAG_ID

CC ID: 345575
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Unique ID

General Data Type: NUMBER

RELEASE_FISH_ID

CC ID: 345576
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Identifies the fish capture associated with tag – from COD_RELEASE_FISH data table

General Data Type: NUMBER

TAG_NUMBER

CC ID: 345577
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
Description:

Number physically stamped on tag. In addition, field may contain: “US0000” for undersized, non-tagged fish OR, “PC0000” for poor condition non-tagged fish See FAQ for more information

General Data Type: VARCHAR2

SKIN_TAGGED

CC ID: 345578
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

0= Indicates not a skin tag 1= Indicates a skin tag

General Data Type: NUMBER

TAG_NUMBER_UNCERTAIN

CC ID: 345579
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

0= Indicates tag number is accurate 1= Indicates tag number is uncertain

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34409
GUID: gov.noaa.nmfs.inport:34409
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 14:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-24
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-24