9660
Table: ATL_ERROR
ATL_ERROR
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
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.
Loaded by batch 2390, 06-30-2009 16:11
Data Table
Yes
NORPAC
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.
1
ERROR_NUMBER
NUMBER
22
Yes
Yes
5
0
Active
Unique user defined error number between -20000 and -21000
NUMBER
2
ERROR_FORM_TYPE
VARCHAR2
50
Yes
No
Active
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.
VARCHAR2
3
ERROR_NAME
VARCHAR2
50
Yes
No
Active
Unique name of error
VARCHAR2
4
ERROR_TEXT
VARCHAR2
150
Yes
No
Active
Text to be returned with error
VARCHAR2
5
ERROR_DISCUSSION
VARCHAR2
1000
No
No
Active
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
VARCHAR2
6
ERROR_LEVEL
NUMBER
22
Yes
No
2
0
Active
Level of severity
NUMBER
7
OLD_ERROR_NUMBER
NUMBER
22
No
No
4
0
Active
NUMBER
gov.noaa.nmfs.inport:9660
Doug Turnbull
2009-06-30T16:11:21
SysAdmin InPortAdmin
2022-08-09T17:11:02
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
https://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26