RC_TSK_ROLE_EML (SQL View)	Index Back
View to get PERSON_ID This view will be used to fetch the person id based on Role defined on Task/Task Status

RC_TSK_ROLE_EML

(SQL View)

View to get PERSON_ID

This view will be used to fetch the person id based on Role defined on Task/Task Status

SELECT A.BUS_PROC_INSTANCE , A.ACTIVITY_INSTANCE , A.RC_TASK_ID , C.PERSON_ID FROM PSROLEUSER B , PSOPRALIAS C , PS_RC_TASK_STATUS A WHERE B.ROLEUSER = C.OPRID AND C.OPRALIASTYPE = 'PER' AND A.RC_ASSIGNMENT_OPT = 'G' AND B.ROLENAME = A.RC_ASSIGNED_TO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

2 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance

3 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
2	ACTIVITY_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Activity Instance
3	RC_TASK_ID	Character(15)	VARCHAR2(15) NOT NULL	Task ID used for Business Process tracking.
4	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID