Document toolboxDocument toolbox

14.1 sp593_audit_op_reason_mapping

This table is part of the solutions that provides the ability for users to record reason codes and notes for fixed jobs.


 

Table Definition

Field
Type
Default
Nullable
operation_nonumber(3) (error)
reason_codenumber (error)
display_sequencenumber (error)

Keys

foreign key (operation_no) references SP591_audit_reason_ops (operation_no) 
foreign key (reason_code) references SP590_audit_reason_codes(reason_code)

Column Descriptions

FieldDescription
operation_noOperation number.
reason_codeReason code.
display_sequenceDisplay sequence.