PERSON_IDUSERIDPrompt Table: RD_PER_USER_VW
RB_WF_GRP_NAMEPrompt Table: RB_WF_WL_GRP
Y/N Table Edit
RD_PER_GRPWL_VW(SQL View) |
Index Back |
|---|---|
Person Group WorklistsView to see which group worklists a particular person belongs to. |
| SELECT A.PERSON_ID , B.USERID , C.RB_WF_GRP_NAME , C.GROUP_OWNER_FLG FROM PS_RD_PERSON A , PS_RD_PER_USER_VW B , PS_RB_WF_GRP_PLIST C WHERE A.PERSON_ID = B.PERSON_ID AND B.USERID = C.USERID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: RD_PER_USER_VW |
| 3 | RB_WF_GRP_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table: RB_WF_WL_GRP |
| 4 | GROUP_OWNER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Group Owner
Y/N Table Edit |