Search Help Show/Hide Menu
Metadata Rubric
98%
5.86 / 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

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9660  |  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.

Description

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ERROR_NUMBER
NUMBER 		Unique user defined error number between -20000 and -21000
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_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
Short Name: ATL_ERROR
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.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

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

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ERROR_NUMBER NUMBER Unique user defined error number between -20000 and -21000
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_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

ERROR_NUMBER

CC ID: 38141
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 5
Scale: 0
Status: Active
Description:

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

ERROR_FORM_TYPE

CC ID: 38138
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
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: 38140
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Unique name of error
General Data Type: VARCHAR2

ERROR_TEXT

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

Text to be returned with error
General Data Type: VARCHAR2

ERROR_DISCUSSION

CC ID: 38137
Seq. Order: 5
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: 38139
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Level of severity
General Data Type: NUMBER

OLD_ERROR_NUMBER

CC ID: 38143
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 9660
GUID: gov.noaa.nmfs.inport:9660
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