Logins, 16 (ver3.6.1)
This table records user information about session.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AuthType | 23.9.0 | Varchar2(20) | Determines what kind of authentication is used for logging on.
|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Hits | 3.6.1 | Number(10,0) | Number of hits the user accumulated while logged on. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IPAddr | 3.6.1 | Number(10,0) | The IP address of the login request. |
LoginDate | 3.6.1 | Date | The date the user logged in. Indexed. |
LoginTicks | 3.6.1 | Number(10,0) | The number of ticks in CPU time the user has been logged in for. |
LoginTime | 3.6.1 | Number(10,0) | The time the user logged in. |
LogoutDate | 3.6.1 | Date | The date the user logged out, should almost always be the same as log in if the machine re-starts it self every night. |
LogoutStatus | 3.6.1 | Number(10,0) |
|
LogoutTime | 3.6.1 | Number(10,0) | The time the user logged out. |
MinutesOnline | 3.6.1 | Float | Number of minutes logged in. |
Name | 3.6.1 | Varchar(100) | The name entered by the user logged in. |
PSID | 3.6.1 | Varchar(80) | The internal user number associated with this user login. |
PW | 3.6.1 | Varchar(20) | The password entered by the user. |
PageViews | 3.6.1 | Number(10,0) | The number of pages the user looked at. |
Platform | 3.6.1 | Number(10,0) | The type of system the user has, such as Windows or Macintosh. |
SchoolID | 3.6.1 | Number(10,0) | No longer used by the application. The School_Number of the associated Schools record. |
Server_Instance_ID | 7.8.0 | Number(10) | Identifies the server node from which the user was logged into PowerSchool. |
Status | 23.9.0 | Varchar2(200) | States the reason for failed logins. Records "SUCCESS" for successful logins. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Subject | 23.9.0 | Varchar2(100) | Represents the global identifier for logged in User.
|
UntrustedForwardedFor | 9.2.4.4/10.1.0 | Varchar2(4000) | Contains delimited list of IPs from X-Forwarded-For request header, not automatically trusted by PowerSchool. |
Unused1 | ver... | Number(10,0) | Currently unused field. |
UserAgent | 3.6.1 | CLOB | The browser the user has. |
UserID | 3.6.1 | Number(10,0) | The internal teacher ID associated with this record. Indexed. |
UserType | 3.6.1 | Number(10,0) | Determines what kind of user is logging on. Indexed.
|