The Login ID List table contains the following data for the user’s Login ID:
- Login ID
- Resp Org
- Telco
- Phone
- Name of the user entered on the SUD page
| RHDB_SMSLOGONS | ||
| Field | Characters | Description |
| LogonId | varchar2(8) | The identification code associated with a given user. |
| Owner | varchar2(5) | The Resp Org code associated with the Login ID. |
| Telco | varchar2(4) | Telephone company associated with the Login ID. |
| Phone | varchar2(12) | The Phone number of the user. |
| UserName | varchar2(30) | The name of the user entered on the SUD page. |
| ExtractDate | Date | The date when the record was sent to the RHDB database. |
Index for RHDB_SMSLOGONS Table
The index and fields used for the RHDB_SMSLOGONS table are the same as for the RHDB_SECURITYUSERDATA table:
| RHDB_SMSLOGONS | |
| Index Name | Fields Used |
| rhdb_ SecurityUserData _idx1 |
|
| rhdb_ SecurityUserData _idx2 |
|
| rhdb_ SecurityUserData _idx3 |
|
| rhdb_ SecurityUserData _idx4 |
|
| rhdb_ SecurityUserData _idx5 |
|
| rhdb_ SecurityUserData _idx6 |
|
| rhdb_ SecurityUserData _idx7 |
|
| rhdb_ SecurityUserData _idx8 |
|
All users can view data in the RHDB_SMSLOGONS table in the Reports History Database (RHDB).