LG_TableName (ver9.1.0)
LG_[TableName] tables are log tables. These tables are created dynamically when a data change subscription is processed. The log records stored in these tables belong to the [TableName]. These tables will have one or more [LogicalKeyFieldName] columns and one or more set of N_[FieldName] and O_[FieldName] columns. These columns have the same type and size as their equivalent in the source [TableName]. LG_[TableName] tables are automatically deleted during PowerSchool startup when no longer needed. The [LogicalKeyFieldName], O_[FieldName], and N_[FieldName] columns are automatically removed from the table during PowerSchool startup when no longer needed.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
LOG_SEQ | 9.1.0 | Number(19) | Unique identifier for this table. Required. |
| Changed_Columns | 9.1.0 | Varchar2(4000) | A comma delimited list of columns that were changed. |
| DML_Type | 9.1.0 | Varchar2(1) | The type of record transaction. The possible values are I, D, and U. I=Insert, D=Delete, U=Update. |
| HLE_Log_ID | 9.1.0 | Number(10) | HLE refers to a High Level Event. When this log is related to a High Level Event this field will be populated. |
| IP_Address | 9.1.0 | Varchar2(39) | The IP address of the client that initiated the transaction. |
| [LogicalKeyFieldName] | ver.. | Based on source field type | A logical key field. There may be 1 or more of these fields. |
| N_[FieldName] | ver.. | Based on source field type | The new value of the field. There may be 1 or more of these fields. |
| O_[FieldName] | ver.. | Based on source field type | The old value of the field. There may be 1 or more of these fields. |
Transaction_Date | 9.1.0 | Timestamp | The timestamp fo the transaction. |
WhoModifiedID | 9.1.0 | Number(10) | The ID of the client that initiated the transaction. |
WhoModifiedType | 9.1.0 | Varchar2(1) | The type of the client that initiated the transaction. |