DBLog, 20 (ver3.6.1)
Tracks the user who has modified data using USM.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Code | 3.6.1 | Varchar(79) | Type of action being taken on the database, such as Delete Teacher, Delete Section, etc. |
Date_Value | 3.6.1 | Date | The Date this record was created. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IPAddress | 3.6.1 | Number(10,0) | The IP the user was at when this record was created. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Server_InstanceID | 4.2.0 | Number(10,0) | Identifier for the PowerSchool Server Instance. Indexed. |
TData | 3.6.1 | CLOB | The actual data stored for this record, such as Name=miller, ID=23223. |
Time | 3.6.1 | Number(10,0) | The Time this record was created. |
Type | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
UserID | 3.6.1 | Number(10,0) | The userID associated with the record. |