PCAS_AccountAccessHist (ver7.0.0)
Used to track the history of login attempts made to the system.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
HTTPForwardedFor | 7.0.0 | Varchar2(30) | The HTTP-Forwarded-For header information of the login request. Defaults to 0.0.0.0. Required. |
IsApprovedToDelete | 7.0.0 | Number(1) | Indicates if admin is allowed to select records to be deleted. Valid values: 0 = Not approved to delete, 1 = Approved for deletion. Defaults to 0. |
IsInvalidUsername | 7.0.0 | Number(1) | Indicates the username entered during an attempted login was either valid or invalid. Valid values: 0 = Valid user name, 1 = Invalid user name. Defaults to 0. Required. |
IsLoginSuccessful | 7.0.0 | Number(1) | Indicates the attempted login was either successful or unsuccessful. Valid values: 0 = Not a successful login, 1 = Login was successful. Defaults to 1. Required. |
LoginAttemptDate | 7.0.0 | Timestamp(6) | The date and time of the login attempt. Defaults to system date. Required. |
LoginDelay | 7.0.0 | Number(10) | The value in seconds of the login delay in place at the time of the login attempt. Defaults to 0. Required. |
LoginIPSource | 7.0.0 | Varchar2(30) | The TCP IP source of the login request. Defaults to 0.0.0.0. Required. |
PCAS_AccountAccessHistID | 7.0.0 | Number(19) | Unique identifier for this table. Required. |
PCAS_AccountID | 7.0.0 | Number(19) | Foreign key to the PCAS_Account table. Required. |
PCAS_ServiceID | 7.0.0 | Number(19) | Foreign key to the PCAS_Service table. Required. |
UserNameAttempted | 7.0.0 | Varchar2(64) | Both valid and invalid usernames used for login attempts are recorded. Required. |
WhenCreated | 7.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 7.0.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |