SystemHistory (ver12.0.1)
Table maintains a historical record of all system startups and the versions of certain components.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| App_TZOffset | 23.1.0 | NUMBER(6) | Required. The offset of the node's timezone from UTC. Default 0. |
| DB_TZOffset | 23.1.0 | NUMBER(6) | Required. The offset of the DB's timezone from UTC. Default 0. |
Host_Name | 12.0.1 | Varchar2(80) | The node's host name. |
ID | 12.0.1 | Number(19) | Unique identifier. Indexed |
IP_Address | 12.0.1 | Varchar2(40) | The node's IP address. |
| IsTaskMaster | 23.1.0 | Number(1) | Required. The node's Task Maser status:
Default 0. |
PS_Version | 12.0.1 | Varchar2(40) | The PowerSchool version the node is/was running. |
Server_InstanceID | 12.0.1 | Number(10) | The server instance ID from the Server_Instance table. |
SR_Version | 12.0.1 | Varchar2(40) | The state reporting version the node is/was running. |
WhenCeated | 12.0.1 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 12.0.1 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 12.0.1 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 12.0.1 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |