7369
Table: ATL_ERROR_H
ATL_ERROR_H
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.
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.
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.
Loaded by batch 2164, 03-27-2008 10:42
Data Table
Yes
NORPAC
1
SEQ_NUMBER
NUMBER
22
Yes
Yes
10
0
Active
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.
NUMBER
2
CHANGED_BY
VARCHAR2
30
No
No
Active
Oracle user who made a change to the transaction table record.
VARCHAR2
3
DATE_CHANGED
DATE
7
No
No
Active
Timestamp of change to transaction record.
DATE
4
ERROR_FORM_TYPE
VARCHAR2
50
No
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
5
ERROR_NAME
VARCHAR2
50
No
No
Active
Unique name of error
VARCHAR2
6
ERROR_NUMBER
NUMBER
22
No
No
22
0
Active
Unique user defined error number between -20000 and -21000
NUMBER
7
ERROR_TEXT
VARCHAR2
150
No
No
Active
Text to be returned with error
VARCHAR2
8
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
9
ERROR_LEVEL
NUMBER
22
No
No
22
0
Active
Level of severity
NUMBER
10
OLD_ERROR_NUMBER
NUMBER
22
No
No
22
0
Active
NUMBER
gov.noaa.nmfs.inport:7369
Doug Turnbull
2008-03-27T10:42:10
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26