PSUSERATTR(SQL Table) |
Index Back |
---|---|
User Security AttributesIncluding 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
|
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 |