Table: ATL_ERROR
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9660 | Updated: August 9, 2022 | Published / External
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
|
|
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: | 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 |