Search Help Show/Hide Menu
Metadata Rubric
82%
4.9 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_ERROR_H

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7369  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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.
CHANGED_BY
VARCHAR2 		Oracle user who made a change to the transaction table record.
DATE_CHANGED
DATE 		Timestamp of change to transaction record.
ERROR_FORM_TYPE
VARCHAR2 		Error script run for every specific form type. This column groups errors according to the respective subsystem tested. For example: Trip errors relate to the Atlas Trip and related table data.
ERROR_NAME
VARCHAR2 		Unique name of error
ERROR_NUMBER
NUMBER 		Unique user defined error number between -20000 and -21000
ERROR_TEXT
VARCHAR2 		Text to be returned with error
ERROR_DISCUSSION
VARCHAR2 		Optional discussion of history, and remedies relating to this error. Including usage by table and program. It is anticipated that complilation of this metadata will generate an error handbook which will be available to inseason staff
ERROR_LEVEL
NUMBER 		Level of severity
OLD_ERROR_NUMBER
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_ERROR_H
Short Name: ATL_ERROR_H
Status: Completed
Abstract:

This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log.

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.
Purpose:

This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log.

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 2164, 03-27-2008 10:42

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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
 ERROR_FORM_TYPE VARCHAR2 Error script run for every specific form type. This column groups errors according to the respective subsystem tested. For example: Trip errors relate to the Atlas Trip and related table data.
100
 ERROR_NAME VARCHAR2 Unique name of error
100
 ERROR_NUMBER NUMBER Unique user defined error number between -20000 and -21000
100
 ERROR_TEXT VARCHAR2 Text to be returned with error
100
 ERROR_DISCUSSION VARCHAR2 Optional discussion of history, and remedies relating to this error. Including usage by table and program. It is anticipated that complilation of this metadata will generate an error handbook which will be available to inseason staff
100
 ERROR_LEVEL NUMBER Level of severity
67
 OLD_ERROR_NUMBER NUMBER

Attribute Details

SEQ_NUMBER

CC ID: 28531
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

CC ID: 28522
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

CC ID: 28523
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

ERROR_FORM_TYPE

CC ID: 28525
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Error script run for every specific form type. This column groups errors according to the respective subsystem tested. For example: Trip errors relate to the Atlas Trip and related table data.
General Data Type: VARCHAR2

ERROR_NAME

CC ID: 28527
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Unique name of error
General Data Type: VARCHAR2

ERROR_NUMBER

CC ID: 28528
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Unique user defined error number between -20000 and -21000
General Data Type: NUMBER

ERROR_TEXT

CC ID: 28529
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Text to be returned with error
General Data Type: VARCHAR2

ERROR_DISCUSSION

CC ID: 28524
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Optional discussion of history, and remedies relating to this error. Including usage by table and program. It is anticipated that complilation of this metadata will generate an error handbook which will be available to inseason staff
General Data Type: VARCHAR2

ERROR_LEVEL

CC ID: 28526
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Level of severity
General Data Type: NUMBER

OLD_ERROR_NUMBER

CC ID: 28530
Seq. Order: 10
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: 7369
GUID: gov.noaa.nmfs.inport:7369
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 10:42+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