AUD_S_TN_DISTRICTBUSSTAFF_S (ver 15.12.0)
This table is a standalone Audit table for TN District Bus Staff Information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.12.0 | Number(11,0) | Unique Record ID. |
OLD_REGULARDRIVER | 15.12.0 | Number(11,0) | Audit value - Old number of regular drivers. |
| NEW_REGULARDRIVER | 15.12.0 | Number(11,0) | Audit value - New number of regular drivers. |
OLD_SUBSTITUTEDRIVER | 15.12.0 | Number(11,0) | Audit value - Old number of substitute drivers. |
NEW_SUBSTITUTEDRIVER | 15.12.0 | Number(11,0) | Audit value - New number of substitute drivers. |
OLD_EMPLOYEDDRIVERCDL | 15.12.0 | Number(11,0) | Audit value - Old number of employed bus drivers with CDL. |
NEW_EMPLOYEDDRIVERCDL | 15.12.0 | Number(11,0) | Audit value - New number of employed bus drivers with CDL. |
OLD_CONTRACTEDDRIVERCDL | 15.12.0 | Number(11,0) | Audit value - Old number of contracted drivers with CDL. |
NEW_CONTRACTEDDRIVERCDL | 15.12.0 | Number(11,0) | Audit value - New number of contracted drivers with CDL. |
OLD_BUSASSISTANTS | 15.12.0 | Number(11,0) | Audit value - Old number of bus assistants. |
NEW_BUSASSISTANTS | 15.12.0 | Number(11,0) | Audit value - New number of bus assistants. |
OLD_BUSGARAGEMAINT | 15.12.0 | Varchar2(20) | Audit value - Does district own and operate a bus garage and perform bus maintenance old value. |
| NEW_BUSGARAGEMAINT | 15.12.0 | Varchar2(20) | Audit value - Does district own and operate a bus garage and perform bus maintenance new value. |
OLD_MAINTENANCENONSCHBUS | 15.12.0 | Varchar2(4) | Audit value - Does the bus garage mechanics perform maintenance on non-school bus vehicles old value. |
| NEW_MAINTENANCENONSCHBUS | 15.12.0 | Varchar2(4) | Audit value - Does the bus garage mechanics perform maintenance on non-school bus vehicles new value. |
| OLD_FULLTIMEMECHANICS | 15.12.0 | Number(11,0) | Audit value - Number of full time mechanics employed by the district old value. |
NEW_FULLTIMEMECHANICS | 15.12.0 | Number(11,0) | Audit value - Number of full time mechanics employed by the district new value. |
DistrictID | 15.12.0 | Number(11,0) | District ID value. |
SCHOOLYEAR | 15.12.0 | Number(11,0) | Two digit school year id. |
DML_TYPE | 15.12.0 | Varchar2(1) | The transaction type that occurred to the audited table. 'I' for insert, 'U' for update, and 'D' for delete. |
TRANSACTION_DATE | 15.12.0 | Date | Audit change date. |
AUDIT_SEQ | 15.12.0 | Number(11,0) | Audit sequence number. |
WHOMODIFIEDID | 15.12.0 | Number(11,0) | Who modified ID. |
WHOMODIFIEDTYPE | 15.12.0 | Varchar2(1) | Who modified field type. |
IP_ADDRESS | 15.12.0 | Varchar2(39) | IP address of who modified ID. |