Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_047_S (ver 17.9.1)

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

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_DCID17.9.1Number(11,0)DCID (logical key)
E_ID17.9.1Number(11,0)DCID of record that changed (logical key)
E_SchoolID17.9.1Number(11,0)School ID (logical key)
E_StudentID17.9.1Number(11,0)Student ID (logical key)
E_State_StudentNumber17.9.1Varchar2(32)Enrollment School ID (logical key)
E_StudentPIN17.9.1Varchar2(9)Student Pin (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)
O_StudentStandardDay17.9.1Number(11,0)Old Student Standard
N_StudentStandardDay17.9.1Number(11,0)New Student Standard
JavaScript errors detected

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

If this problem persists, please contact our support.