PCAS_AccountSession (ver6.2.0)
Represents session information for an authorized user for one or more services (service tickets).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
IPAddress | 6.2.0 | Varchar2(32) | The IP address of the client machine where the user logged in from. |
LoginServiceID | 6.2.0 | Number(19) | The initial service that was used to login for that account session. The internal ID for the PCAS_Service record to which the record is associated. Indexed. |
LoginTime | 6.2.0 | Timestamp(6) | The time the user logged in. |
LogoutServiceID | 6.2.0 | Number(19) | The service from which the user logged out. The internal ID for the PCAS_Service record to which the record is associated. Indexed. |
LogoutTime | 6.2.0 | Timestamp(6) | The time the user logged out. |
PCAS_AccountID | 6.2.0 | Number(19) | A unique identifier for an account used by the Pearson Central Authentication Server. The internal ID for the PCAS_Account record to which the record is associated. Indexed. Required. |
PCAS_AccountSessionID | 6.2.0 | Number(19) | A unique identifier of the account's session. Indexed. Required. |
SessionStatus | 6.2.0 | Varchar2(24) | The current status of the session. Valid values: Active, Inactive. If the value is inactive, the session is considered logged out. |
UserTicket | 6.2.0 | Varchar2(128) | This is a master ticket granted to the user account session on initial login. A master ticket is a user level ticket, which is used to grant service level tickets when a user attempts to access additional services. Required. |
WhenCreated | 6.2.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 6.2.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhoModified | 6.2.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |