RB_TSK_DELED_VW (SQL View)	Index Back
Task Delegated View Task Delegated as Direct Report View. Used for Data Distribution rules in My Tasks.

RB_TSK_DELED_VW

(SQL View)

Task Delegated View

Task Delegated as Direct Report View. Used for Data Distribution rules in My Tasks.

SELECT CASE WHEN A.TASK_LIST = 'MT' THEN A.PERSON_ID ELSE A.TASK_LIST END , B.PERSON_ID , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_RB_WORKER B WHERE A.TSK_DELEGATE_TYPE = 'DT' AND A.PERSON_ID = B.SUPERVISOR_ID AND B.EMPL_STATUS = 'A' AND A.START_DT <= %CurrentDateIn AND A.END_DT >= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH

3 READONLY Character(1) VARCHAR2(1) NOT NULL Read Only

4 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	PERSON_ID_ASSIGNEE	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
3	READONLY	Character(1)	VARCHAR2(1) NOT NULL	Read Only
4	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"