PERSON_IDRB_WF_GRP_NAMERB_PER_GRPWLIST(SQL View) |
Index Back |
|---|---|
Group WorklistGroup Worklist |
| SELECT DISTINCT A.PERSON_ID ,C.RB_WF_GRP_NAME FROM PS_RD_PERSON_NAME A ,PSOPRALIAS_VW B ,PS_RB_WF_GRP_PLIST C WHERE A.PRIMARY_IND='Y' AND B.OPRALIASVALUE=A.PERSON_ID AND B.OPRALIASTYPE='PER' AND B.OPRID=C.USERID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | RB_WF_GRP_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Group Worklist Nameg |