Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_043_S (ver 17.9.1)

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

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(50)Name of the table that had a change
E_DCID17.9.1Number(11,0)DCID (logical key)
E_RecordDCID17.9.1Number(11,0)DCID of record that changed (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_Enrollment_SchoolID17.9.1Number(11,0)Enrollment School ID (logical key)
E_Track19.3.0Varchar2(20)Track (logical key)
E_SSN17.9.1Varchar2(12)SSN (logical key)
E_EntryDate17.9.1DateEntry Date (logical key)
E_StudentPIN17.9.1Varchar2(9)Student Pin (logical key)
E_State_StudentNumber17.9.1Varchar2(32)State Student Number (logical key)
O_EntryDate17.9.1DateOld Entry Date
O_Enrollment_SchoolID17.9.1Number(11,0)Old Enrollment School ID
O_Grade_Level17.9.1Number(11,0)Old Grade Level
N_EntryDate17.9.1DateNew Entry Date
N_Enrollment_SchoolID17.9.1Number(11,0)New Enrollment School ID
N_Grade_Level17.9.1Number(11,0)New Grade Level
JavaScript errors detected

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

If this problem persists, please contact our support.