Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_044_S (ver 18.2.0)

This table is a standalone Audit table for the Extract 44.

Column NameVersionData TypeDescription
DML_Type18.2.0Varchar2(5)Data Transaction Type
DMLDate18.2.0DateData Transaction Date
ChangedCoreColumnNames18.2.0Varchar2(4000)List of column names changed
UserID18.2.0Varchar2(11)User ID who made the change
DataVersion18.2.0Varchar2(50)Generated identifier of the data change event.
StateEventQueueDCID18.2.0Number(11,0)DCID of record saved in the StateEventQueue
TableName18.2.0Varchar2(30)Name of the table that had a change
E_ID18.2.0Number(11,0)ID of record that changed (logical key)
E_RecordDCID18.2.0Number(11,0)DCID of record that changed (logical key)
E_SchoolID18.2.0Number(11,0)School ID of Student Classification record (logical key)
E_ClassificationType18.2.0Varchar2(80)Student Classification Type (logical key)
E_BeginDate18.2.0DateStudent Classification Begin Date. (logical key)
O_ClassificationType18.2.0Varchar2(80)Old Student Classification Type.
O_BeginDate18.2.0DateOld Student Classification Begin Date.
O_EndDate18.2.0DateOld Student Classification End Date.
N_ClassificationType18.2.0Varchar2(80)New Student Classification Type.
N_BeginDate18.2.0DateNew Student Classification Begin Date.
N_EndDate18.2.0DateNew Student Classification End Date.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.