ROLENAMEEMAIL_ADDRPrompt Table: %EDITTABLE
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
IT_ROLEXLATOPR(SQL View) |
Index Back |
|---|---|
Role User ViewRole User View with language code. |
| SELECT B.ROLENAME , A.emailid , A.emplid , C.NAME , A.worklist_user_sw , A.email_user_sw , C.LANG_CD FROM PS_ROLEXLATOPR A , PSROLEUSER B , PS_PERSONAL_DATA C WHERE A.ROLEUSER = B.ROLEUSER AND A.EMPLID = C.EMPLID AND A.EMAIL_USER_SW = 'Y' AND A.EMAILID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | EMAIL_ADDR |
Character(70) | VARCHAR2(70) NOT NULL |
Email Address
Prompt Table: %EDITTABLE |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | WORKLIST_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets a worklist generated |
| 6 | EMAIL_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets workflow email generated |
| 7 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German INE=International English ITA=Italian JPN=Japanese POR=Portuguese |