PCAS_Account (ver6.2.0)
Stores user information for the Pearson Central Authentication Server.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Credential | 6.2.0 | Varchar2(64) | A credential is used by Pearson Central Authentication Server to authenticate a user. For example, a credential could be a password or a digital certificate. |
CredentialChangedDate | 7.0.0 | Timestamp(6) | Date and time of the last credential change. Required. Default to system date. |
EncryptionMode | 6.2.0 | Number(1) | Defines if the credential is encrypted or not. Valid values: 1 = Encrypted, 0 = Not encrypted. |
IsEnabled | 6.2.0 | Number(1) | Defines if an account is enabled or disabled. Valid values: 1 = Enabled, 0 = Disabled. |
IsLockedOut | 7.0.0 | Number(1) | 1 indicates user account locked. Required. Defaults to 0. |
LockedOutReason | 7.0.0 | Varchar2(256) | Text description explaining the reason for lockout. |
PCAS_AccountID | 6.2.0 | Number(19) | A unique identifier for an account used by the Pearson Central Authentication Server. Indexed. Required. |
PCAS_AccountToken | 6.2.0 | Varchar2(32) | It is a unique identifier, which identifies a Pearson Central Authentication Server account that can be used by other services to associate a user to a domain entity. Such as the guardian account in Parent Portal is a domain entity that is associated with a Pearson Central Authentication Server account through the account token. Required. |
PCAS_CredentialTypeID | 6.2.0 | Number(19) | The internal ID for the PCAS_CredentialType record to which the record is associated. Required. |
PCAS_ServiceID | 6.2.0 | Number(19) | Internal number for the associatedPCAS_Service record, which represents a service. For example, Parent Portal is a service, and this ID would relate to the ID of the Parent Portal service in this case. |
Username | 6.2.0 | Varchar2(64) | It is a login name used by the Pearson Central Authentication Server to authenticate a user. Required. |
| Verification_Expires | 20.4.2 | Timestamp(6) | Indicates when the verification token expires. |
| Verification_Token | 20.4.2 | Varchar2(32) | Randomized token used for the public parent email verification process. |
| Verification_Retry_Count | 20.4.2 | Number(4) | The number of failed attempts to verify the account email. |
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. |