Table: ATL_ERROR
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18977 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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 4574, 05-03-2013 17:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NPRB_1017 |
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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: | 18977 |
---|---|
GUID: | gov.noaa.nmfs.inport:18977 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-05-03 17:18+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |