PCAS_Audit (ver11.1.0)
Used for troubleshooting purposes once the auditing is enabled to track application access.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Accessed_TS | 11.1.0 | Timestamp(6) | Timestamp of the url request in IP_Address timezone. |
| ExecutionID | 23.2.0 | Varchar2(64) | A unique identifier for changes made as part of a transaction |
| HTTP_Verb | 11.1.0 | Varchar2(10) | The HTTP verb (GET, POST, etc). |
| IP_Address | 11.1.0 | Varchar2(30) | The IP address the user is logging in from. |
Key_Params | 11.1.0 | Varchar2(4000) | Delimited list of form names and values submitted/requested for: AC, FRN, RN, LRN, DCID, ID, CurStudId, CurSchoolId, CurTchrId. |
Other_Params | 11.1.0 | Varchar2(4000) | Delimited list of form names submitted/requested. |
| PCAS_AuditID | 11.1.0 | Number(19,0) | Unique identifier for this table. Not Indexed. Required. |
| Requested_URL | 11.1.0 | Varchar2(4000) | The user requested URL. |
| Thread_Handle | 11.1.0 | Varchar2(100) | Thread handle name. |
| UntrustedForwardedFor | 11.1.0 | Varchar2(4000) | Contains delimited list of IPs from X-Forwarded-For request header, not automatically trusted by PowerSchool. |
| User_UID | 11.1.0 | Varchar2(40) | User Unique ID. Concatenated string of User Type, the letter A, User ID. UserID by User Type:
|