Table: ATL_ERROR_LOG_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9663 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: ATL_ERROR_LOG_H |
|---|---|
| Short Name: | ATL_ERROR_LOG_H |
| Status: | Completed |
| Abstract: |
This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution. |
| Purpose: |
This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution. 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 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NORPAC |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
SEQ_NUMBER | NUMBER | Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. |
|
100
|
CHANGED_BY | VARCHAR2 | Oracle user who made a change to the transaction table record. | |
|
100
|
DATE_CHANGED | DATE | Timestamp of change to transaction record. | |
|
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
|
100
|
ERROR_LOG_ID | NUMBER | Sequence generated unique identifier for an error log entry | |
|
67
|
ERROR_NUMBER | NUMBER | ||
|
67
|
YEAR | NUMBER | ||
|
67
|
TABLE_NAME | VARCHAR2 | ||
|
67
|
PK1_COLUMN_NAME | VARCHAR2 | ||
|
67
|
PK1_VALUE | VARCHAR2 | ||
|
67
|
PK2_COLUMN_NAME | VARCHAR2 | ||
|
67
|
PK2_VALUE | VARCHAR2 | ||
|
67
|
LOADING_LEVEL | VARCHAR2 | ||
|
67
|
RESOLVED_CODE | VARCHAR2 | ||
|
67
|
RESOLVED_BY | VARCHAR2 | ||
|
67
|
RESOLVED_DATE | DATE | ||
|
67
|
ADMIN_OVERRIDE_FLAG | VARCHAR2 | ||
|
67
|
COMMENTS | VARCHAR2 | ||
|
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau | |
|
100
|
ACTIVE_FLAG | VARCHAR2 | When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added. |
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 |
| Description: |
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. |
| General Data Type: | NUMBER |
CHANGED_BY
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Oracle user who made a change to the transaction table record. |
| General Data Type: | VARCHAR2 |
DATE_CHANGED
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Timestamp of change to transaction record. |
| 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 |
| Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
| General Data Type: | NUMBER |
ERROR_LOG_ID
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 22 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Sequence generated unique identifier for an error log entry |
| General Data Type: | NUMBER |
ERROR_NUMBER
| 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 |
YEAR
| 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 |
TABLE_NAME
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
PK1_COLUMN_NAME
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
PK1_VALUE
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
PK2_COLUMN_NAME
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
PK2_VALUE
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
LOADING_LEVEL
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
RESOLVED_CODE
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
RESOLVED_BY
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
RESOLVED_DATE
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | DATE |
ADMIN_OVERRIDE_FLAG
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
COMMENTS
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| General Data Type: | VARCHAR2 |
PERMIT
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
| General Data Type: | VARCHAR2 |
ACTIVE_FLAG
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 9663 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:9663 |
| 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 |