Skip to main content
Skip table of contents

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_Expires20.4.2Timestamp(6)Indicates when the verification token expires.
Verification_Token20.4.2Varchar2(32)Randomized token used for the public parent email verification process.
Verification_Retry_Count20.4.2Number(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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.