OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Managing an Object Structure | OneData Audit Columns and Triggers | OneData Audit Columns
 
OneData Audit Columns
For tables, OneData automatically adds the audit columns when the object is imported into OneData, if they do not already exist. Whereas, in a view, you must add the audit columns to the view definition before bringing the view into OneData.
The audit columns for any table or view in the Work area or Release area are as follows:
Column Name
Data Type
Nullable?
Default Value
Definition
CREAT_DT
Date
Yes
Sysdate
Date/time of record creation.
LST_UPD_DT
Date
Yes
Sysdate
Date/time of last update.
CREAT_USR_ID
Varchar2(50)
Yes
User
OneData user who created the record.
LST_UPD_USR_ID
Varchar2(50)
Yes
User
OneData user who last updated the record.
LST_DEL_DT
Date
Yes
Date/time record was logically deleted.
S2P_TRN_DT
Date
Yes
Date/time of record transfer to release area.
FLD_DELETE
Number(1)
Yes
0
Logical delete indicator.