Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_050_S (ver 17.9.1)

eThis table is a standalone Audit table for the Extract 50.

Column NameVersionData TypeDescription
DML_Type17.9.1Varchar2(5)Data Transaction Type
DMLDate17.9.1DateData Transaction Date
ChangedCoreColumnNames17.9.1Varchar2(4000)List of column names changed
UserID17.9.1Varchar2(11)User ID who made the change
DataVersion17.9.1Varchar2(50)Generated identifier of the data change event
TableName17.9.1Varchar2(30)Name of the table that had a change
E_RecordDCID17.9.1Number(11,0)DCID of record that changed (logical key)
E_DCID17.9.1Number(11,0)DCID (logical key)
E_ID17.9.1Number(11,0)ID (logical key)
E_StudentID17.9.1Number(11,0)Student ID (logical key)
E_SchoolID17.9.1Number(11,0)School ID (logical key)
E_Track19.3.0Varchar2(20)Track (logical key)
E_SSN17.9.1Varchar2(12)SSN (logical key)
E_ExitDate17.9.1DateExit Date (logical key)
E_State_StudentNumber17.9.1Varchar2(12)State Student Number (logical key)
E_StudentPIN17.9.1Varchar2(12)Student Pin (logical key)
E_Enrollment_SchoolID17.9.1Number(11,0)Enrollment School ID (logical key)
O_ExitDate17.9.1DateOld Exit Date
O_ExitCode19.3.0Varchar2(80)Old Exit Code
N_ExitDate17.9.1DateNew Exit Date
N_ExitCode19.3.0Varchar2(80)New Exit Code
JavaScript errors detected

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

If this problem persists, please contact our support.