PSM_AuthenticationAttempt (ver1.5)
This table contains information used to track any authentication attempt for PowerTeacher Admin.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AccountID | 1.5 | Number(19,0) | Internal number for the associated PSM_Account record. |
AttemptTimestamp | 1.5 | Timestamp | The time the authentication attempt was made. |
ID | 1.5 | Number(19,0) | Unique sequential number generated by the application. Required. |
IPAddress | 1.5 | Varchar2(256) | The IP Address of the machine from which the authentication attempt originates. |
IsSuccessfulLogin | 1.5 | Number(1,0) | 1 indicates a successful authentication attempt. Required. |
Password | 1.5 | Varchar2(30) | The password that was entered during the authentication attempt. |
Platform | 1.5 | Varchar2(30) | The general operating system information of the machine that made the authentication attempt. |
UserAgent | 1.5 | Varchar2(256) | Data taken from the user-agent header. Contains information about the browser, operating system, etc. of the machine that made the authentication attempt. |
UserName | 1.5 | Varchar2(30) | The username that was entered during the authentication attempt. |