Table: ATL_SCANNED_AGE_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9752 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SEQ_NUMBER
NUMBER |
|
CHANGED_BY
VARCHAR2 |
|
DATE_CHANGED
DATE |
|
CRUISE
NUMBER |
|
SPECIMEN_NUMBER
VARCHAR2 |
|
PERMIT
NUMBER |
|
SPECIES_CODE
NUMBER |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: ATL_SCANNED_AGE_H |
---|---|
Short Name: | ATL_SCANNED_AGE_H |
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. |
Purpose: |
Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. |
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 | ||
---|---|---|---|---|
67
|
SEQ_NUMBER | NUMBER | ||
67
|
CHANGED_BY | VARCHAR2 | ||
67
|
DATE_CHANGED | DATE | ||
67
|
CRUISE | NUMBER | ||
67
|
SPECIMEN_NUMBER | VARCHAR2 | ||
67
|
PERMIT | NUMBER | ||
67
|
SPECIES_CODE | NUMBER |
Attribute Details
SEQ_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
General Data Type: | NUMBER |
CHANGED_BY
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | VARCHAR2 |
DATE_CHANGED
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | DATE |
CRUISE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
General Data Type: | NUMBER |
SPECIMEN_NUMBER
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
General Data Type: | NUMBER |
SPECIES_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 22 |
Scale: | 0 |
Status: | Active |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 9752 |
---|---|
GUID: | gov.noaa.nmfs.inport:9752 |
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 |