The Security User Data table contains data for each user’s Login ID.
This table is available via the SMSADM universe in Reporting. The data is viewable only by the Help Desk and Administrators via Reporting (see Table 122 RHDB_SECURITYUSERDATA).
Table 122 RHDB_SECURITYUSERDATA
RHDB_SECURITYUSERDATA |
||
Field |
Characters |
Description |
LogonId |
varchar2(8) |
The identification code associated with a given user. |
Resporg |
varchar2(5) |
The Resp Org code associated with the Login ID. If “*****” is displayed, then security user data does not exist for the listed Login ID. |
Telco |
varchar2(4) |
Telephone company associated with the Login ID. |
UserClass |
varchar2(1) |
The User Class associated with the Login ID. |
RaoCode |
varchar2(3) |
The RAO code 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. |
DefaultPrinter |
varchar2(8) |
The Default Printer associated with the Login ID. |
SecondPrinter |
varchar2(8) |
The Second Printer associated with the Login ID. |
LastLogonDate |
Date |
The date and time of the last logon associated with this Login ID. |
ExtractDate |
Date |
The date when the record was sent to the RHDB database. |
|
Varchar2 (60) |
Data field that identifies the email address to send SMS/800 TFN Registry generated messages specific to the Login ID. |
Index for RHDB_SECURITYUSERDATA Table
The index and fields used for the RHDB_SECURITYUSERDATA table are:
RHDB_SECURITYUSERDATA |
|
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 |
|