Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

AGE

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35887  |  Updated: August 9, 2022  |  Published / External 
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