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

Summary

Abstract

Fish age data for sampled specimens that did not come from trawl surveys. Trawl survey samples have age data in FLDRPILOT.EBSFD_FSCS_UNION

Description

Fish age data for sampled specimens that did not come from trawl surveys. Trawl survey samples have age data in FLDRPILOT.EBSFD_FSCS_UNION

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISH_ID_CODE
VARCHAR2
Unique code for each sampled fish.
ANNULI
NUMBER
Under development
MARGIN_TYPE
CHAR
Under development
CONFIDENCE
NUMBER
Qualitative score of confidence by ager in the age. 1 is highest.
AGE
NUMBER
Age of specimen in years.
CREATED_DATE
DATE
Date of age data entry
TYPE
VARCHAR2
Age structure type
COMMENTS
VARCHAR2
Comment field for the age sample
OMIT
VARCHAR2
Age sampled excluded because of the quality of the age structure
AGE_TYPE
NUMBER
Under development
AGE_NUMBER
NUMBER
Sequential number for ages, if multiple ageing techniques attempted. 1 is final age.

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: AGE
Short Name: AGE
Status: Completed
Abstract:

Fish age data for sampled specimens that did not come from trawl surveys. Trawl survey samples have age data in FLDRPILOT.EBSFD_FSCS_UNION

Entity Information

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

Fish age data for sampled specimens that did not come from trawl surveys. Trawl survey samples have age data in FLDRPILOT.EBSFD_FSCS_UNION

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISH_ID_CODE VARCHAR2 Unique code for each sampled fish.
100
ANNULI NUMBER Under development
100
MARGIN_TYPE CHAR Under development
100
CONFIDENCE NUMBER Qualitative score of confidence by ager in the age. 1 is highest.
100
AGE NUMBER Age of specimen in years.
100
CREATED_DATE DATE Date of age data entry
100
TYPE VARCHAR2 Age structure type
100
COMMENTS VARCHAR2 Comment field for the age sample
100
OMIT VARCHAR2 Age sampled excluded because of the quality of the age structure
100
AGE_TYPE NUMBER Under development
100
Primary Key AGE_NUMBER NUMBER Sequential number for ages, if multiple ageing techniques attempted. 1 is final age.

Attribute Details

FISH_ID_CODE

CC ID: 362122
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique code for each sampled fish.

General Data Type: VARCHAR2
Foreign Key Relations:

FISH_ORGANISM.FISH_ID_CODE

ANNULI

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

Under development

General Data Type: NUMBER

MARGIN_TYPE

CC ID: 362124
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Under development

General Data Type: CHAR

CONFIDENCE

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

Qualitative score of confidence by ager in the age. 1 is highest.

General Data Type: NUMBER

AGE

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

Age of specimen in years.

General Data Type: NUMBER

CREATED_DATE

CC ID: 362127
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of age data entry

General Data Type: DATE

TYPE

CC ID: 362128
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Age structure type

General Data Type: VARCHAR2

COMMENTS

CC ID: 362129
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Comment field for the age sample

General Data Type: VARCHAR2

OMIT

CC ID: 362130
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Age sampled excluded because of the quality of the age structure

General Data Type: VARCHAR2

AGE_TYPE

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

Under development

General Data Type: NUMBER

AGE_NUMBER

CC ID: 362132
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Sequential number for ages, if multiple ageing techniques attempted. 1 is final age.

General Data Type: NUMBER

Catalog Details

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