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
Table 120 RHDB_SMSLOGONS
|
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).