PSUSERATTR

(SQL Table)
Index Back

User Security Attributes

Including Hint Questions, Hint Response, And symbolic id warning

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 HINT_QUESTION Character(50) VARCHAR2(50) NOT NULL Password Hint Question

Prompt Table: PSPSWDHINT_VW
Set Control Field: HINT_QUESTION

3 HINT_RESPONSE Character(30) VARCHAR2(30) NOT NULL Password Hint repsponse
4 NO_SYMBID_WARN Character(1) VARCHAR2(1) NOT NULL Do not show this message again

Y/N Table Edit

Default Value: N

5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 MPDEFAULMP Character(30) VARCHAR2(30) NOT NULL Default Mobile Page

Prompt Table: PSMPDEFN