AGE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35887 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Fish age data for sampled specimens that did not come from trawl surveys. Trawl survey samples have age data in FLDRPILOT.EBSFD_FSCS_UNION
DescriptionFish 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
|
AGE_NUMBER | NUMBER | Sequential number for ages, if multiple ageing techniques attempted. 1 is final age. |
Attribute Details
FISH_ID_CODE
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
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
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
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
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
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
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
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
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
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
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 |