TASK_IDPERSON_ID_ASSIGNEEPrompt Table: RB_WORKER_SRCH
OPRIDLANGUAGE_CDRB_TSK_WL_LVW(SQL View) |
Index Back |
|---|---|
Task Assignees ViewRelated language record for Task Work List of Assignees View. Used for My Work list. |
| SELECT TA.TASK_ID , P.PERSON_ID ,U.OPRID ,TLANG.LANGUAGE_CD , T.DESCR60 FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RD_PERSON P , PSOPRALIAS U ,PS_RB_TSK_LANG TLANG WHERE T.TASK_ID = TA.TASK_ID AND TA.PERSON_ID_ASSIGNEE = P.PERSON_ID AND P.PERSON_ID = %Substring(U.OPRALIASVALUE,1,15) AND U.OPRALIASTYPE = 'PER' AND TA.TASK_ASGN_STATUS <> 'DCLN' AND TLANG.TASK_ID = T.TASK_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_ID |
Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
| 2 | PERSON_ID_ASSIGNEE |
Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |