Skip to main content
Skip table of contents

S_TN_AUD_EXTRACT_045_S (ver 18.2.0)

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

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_DCID18.2.0Number(11,0)DCID of record that changed (logical key)
E_StudentID18.2.0Number(11,0)ID of the student related to the record that changed (logical key)
E_SchoolID18.2.0Number(11,0)School ID of transportation record (logical key)
E_FromTo18.2.0Varchar2(80)Indicates if the bus travels to or from school (logical key)
E_AMBusNumber18.2.0Varchar2(80)Bus number for AM bus (logical key)
E_AMStartDate18.2.0DateStart date for the AM bus. (logical key)
E_AMEndDate18.2.0DateEnd date for the AM bus. (logical key)
E_PMBusNumber18.2.0Varchar2(80)Bus number for PM bus (logical key)
E_PMStartDate18.2.0DateStart date for the PM bus. (logical key)
E_PMEndDate18.2.0DateEnd date for the PM bus. (logical key)
O_FromTo18.2.0Varchar2(80)Old indicates if the bus travels to or from school.
O_BusNumber18.2.0Varchar2(80)Old Bus number.
O_Distance18.2.0Number(25,10)Old Route Distance.
O_DistanceValue18.2.0Number(25,10)Old Distance Traveled in Miles.
O_LinkingCode18.2.0Varchar2(3)Old Linking Indicator.
O_StartDate18.2.0DateOld Bus Start Date.
O_EndDate18.2.0DateOld Bus End Date.
N_FromTo18.2.0Varchar2(80)New indicates if the bus travels to or from school.
N_BusNumber18.2.0Varchar2(80)New Bus number.
N_Distance18.2.0Number(25,10)New Route Distance.
N_DistanceValue18.2.0Number(25,10)New Distance Traveled in Miles.
N_LinkingCode18.2.0Varchar2(3)New Linking Indicator.
N_StartDate18.2.0DateNew Bus Start Date.
N_EndDate18.2.0DateNew Bus End Date.
JavaScript errors detected

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

If this problem persists, please contact our support.