Table: ATL_SCANNED_AGE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9751 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: ATL_SCANNED_AGE |
---|---|
Short Name: | ATL_SCANNED_AGE |
Status: | Completed |
Abstract: |
This entity exists as a confirmation that an otolith recorded as taken and entered in the ATL Fish Inv Specimen Table matches. If there is a mismatch the event is captured by a trigger and an error is written. The data is not preserved for independent reference. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | AFSC |
None | AGE |
None | ATL |
None | ATLAS |
None | BYCATCH |
None | FMA |
None | GROUNDFISH |
None | MATURITY |
None | NORPAC |
None | OBSERVER |
None | SAMPLING |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | AI |
None | ALEUTIAN ISLANDS |
None | BERING SEA |
None | BS |
None | BSAI |
None | GOA |
None | GULF OF ALASKA |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
SPECIMEN_NUMBER | VARCHAR2 | Unique identifier in combination with a cruise for an otolith specimen. This is the same value as the specimen number entered in the ATL Fish Inv Specimen Table |
100
|
![]() |
CRUISE | NUMBER | Cruise is a new column for this table, and required to guarantee uniqueness between trips. |
100
|
![]() |
PERMIT | NUMBER | This is the Federal Fishery Permit for the vessel or processing plant from which the specimen was extracted. |
100
|
SPECIES_CODE | NUMBER | Species from which otolith was taken. Must match corresponding specimen species for this cruise and specimen number. |
Attribute Details
SPECIMEN_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unique identifier in combination with a cruise for an otolith specimen. This is the same value as the specimen number entered in the ATL Fish Inv Specimen Table |
General Data Type: | VARCHAR2 |
CRUISE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Cruise is a new column for this table, and required to guarantee uniqueness between trips. |
General Data Type: | NUMBER |
PERMIT
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
This is the Federal Fishery Permit for the vessel or processing plant from which the specimen was extracted. |
General Data Type: | NUMBER |
SPECIES_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Species from which otolith was taken. Must match corresponding specimen species for this cruise and specimen number. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 9751 |
---|---|
GUID: | gov.noaa.nmfs.inport:9751 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |