Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_011_S (ver 18.2.0)

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

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
SchoolYear18.2.0Varchar2(4)School year of the record that had a change.
E_ID18.2.0Number(11,0)ID of record that changed (logical key)
E_A18.2.0Number(11,0)In session track A (logical key)
E_B18.2.0Number(11,0)In session track B (logical key)
E_C18.2.0Number(11,0)In session track C (logical key)
E_D18.2.0Number(11,0)In session track D (logical key)
E_E18.2.0Number(11,0)In session track E (logical key)
E_F18.2.0Number(11,0)In session track F (logical key)
E_DistrictCalendarID18.2.0Number(11,0)ID of the related calendar (logical key)
E_DateValue18.2.0DateDate of the changed record (logical key)
E_Note18.2.0Varchar2(50)Note (logical key)
E_MembershipValue18.2.0Varchar2(25,10)Membership Value (logical key)
E_Type18.2.0Number(11,0)Type (logical key).
E_DistrictCycleDayId18.2.0Number(11,0)Id of the related Cycle Day (logical key).
E_DistrictBellScheduleId18.2.0Number(11,0)Id of the related Bell Schedule (logical key).
O_DateValue18.2.0DateOld date value.
O_Type18.2.0Number(11,0)Old type.
O_DistrictBellScheduleId18.2.0Number(11,0)Old related bell schedule.
O_InSession18.2.0Number(1,0)Old in-session flag.
N_DateValue18.2.0DateNew date value.
N_Type18.2.0Number(11,0)New type.
N_DistrictBellScheduleId18.2.0Number(11,0)New related bell schedule.
N_InSession18.2.0Number(1,0)New in-session flag.
JavaScript errors detected

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

If this problem persists, please contact our support.