UM_DVNDR_INT_VW(SQL View) |
Index Back |
|---|---|
User Preferences. |
| SELECT OPRID , OPRDEFNDESC , EMAILID , OPERPSWD , SYMBOLICID , LANGUAGE_CD , MULTILANG , ACCTLOCK FROM PSOPRDEFN WHERE OPRID = %OperatorId |
| # | 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 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 4 | OPERPSWD | Character(32) | VARCHAR2(32) NOT NULL | An user's password |
| 5 | SYMBOLICID | Character(8) | VARCHAR2(8) NOT NULL |
The foreign key linking the PSOPRDEFN table to PSACCESSPRFL
Prompt Table: PSACCESSPRFL |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | MULTILANG | Number(1,0) | SMALLINT NOT NULL | Used to determine if user is Multi-Lingual |
| 8 | ACCTLOCK | Number(1,0) | SMALLINT NOT NULL |
To lock out PeopleSoft User Account
Default Value: 0 |