RB_TSK_DTI_VW (SQL View)	Index Back
Delegate View View for retrieving Tasks delegated to Individual from the Task Delegate record.

RB_TSK_DTI_VW

(SQL View)

Delegate View

View for retrieving Tasks delegated to Individual from the Task Delegate record.

SELECT D.PERSON_ID , B.BO_ID , A.TSK_DELEGATE_ID , B.BO_NAME_DISPLAY , A.READONLY , A.TASK_TYPE FROM PS_RB_TSK_DELEGATE A , PS_BO_NAME B , PS_RB_WORKER D WHERE A.PERSON_ID = D.SUPERVISOR_ID AND D.BO_ID = B.BO_ID AND D.EMPL_STATUS = 'A' AND A.TSK_DELEGATE_TYPE = 'I' AND A.TASK_LIST = 'DT' 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 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

3 TSK_DELEGATE_ID Character(30) VARCHAR2(30) NOT NULL Id of the Person or Group to whom the task is delegated.

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

6 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	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	TSK_DELEGATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Id of the Person or Group to whom the task is delegated.
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	READONLY	Character(1)	VARCHAR2(1) NOT NULL	Read Only
6	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"