CREATEUSER_AET(SQL Table) |
Index Back |
|---|---|
State record for CREATEUSERID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 4 | OPR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Operators EmplID |
| 5 | MC_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 6 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | OPRALIASTYPE | Character(3) | VARCHAR2(3) NOT NULL | User ID Type |
| 9 | BASE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The base User ID used for creating new user IDs |
| 10 | SYMBOLICID | Character(8) | VARCHAR2(8) NOT NULL | The foreign key linking the PSOPRDEFN table to PSACCESSPRFL |
| 11 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 12 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 13 | PRCSPRFLCLS | Character(30) | VARCHAR2(30) NOT NULL | A class that determines a user's process profile |
| 14 | DEFAULTNAVHP | Character(30) | VARCHAR2(30) NOT NULL | Default Navigator Home Page |
| 15 | LANGUAGECD | Character(56) | VARCHAR2(56) NOT NULL | Language Code Attribute |
| 16 | MULTILANG | Number(1,0) | SMALLINT NOT NULL | Used to determine if user is Multi-Lingual |
| 17 | PASSWORD_ALGORITHM | Character(4) | VARCHAR2(4) NOT NULL |
For Passwords
NAME=First Name, Last Name, ID RAND=Random Creation |
| 18 | USER_ID_ALGORITHM | Character(4) | VARCHAR2(4) NOT NULL |
For User IDs
EMAL=Email EMPL=ID |
| 19 | ALGO_EMAIL_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business CAMP=Campus DORM=Dorm HOME=Home OTHR=Other PREF=Preferred |
| 20 | E_ADDR_TYP2 | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other PREF=Preferred |
| 21 | SEND_COMM | Character(1) | VARCHAR2(1) NOT NULL | Assign 3C |
| 22 | POPU_USRPRF_TMP | Character(1) | VARCHAR2(1) NOT NULL | Create result table |
| 23 | EVENT_3CS_ID | Character(10) | VARCHAR2(10) NOT NULL | 3Cs event ID |
| 24 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 25 | READY_TO_DEL | Character(1) | VARCHAR2(1) NOT NULL |
Ready to delete
Default Value: Y |
| 26 | PASS_CI | Character(1) | VARCHAR2(1) NOT NULL |
Default Value: N |
| 27 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Flag
Default Value: N |
| 28 | USRPRO_PSWD | Character(32) | VARCHAR2(32) NOT NULL | unencripted password field for Oper Load process |
| 29 | ID_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Emplid exist
Default Value: N |
| 30 | EMAILTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BB=Blackberry BUS=Business HOME=Home OTH=Other WORK=Work |