RC_TSK_WORKER_V (SQL View)	Index Back
View to get Workers View to Fetch Wroker PERSON_ID and Name

RC_TSK_WORKER_V

(SQL View)

View to get Workers

View to Fetch Wroker PERSON_ID and Name

SELECT A.PERSON_ID , %Substring(A.BO_NAME_DISPLAY, 1, 50) FROM PS_RB_PRSN_P_NM_VW A , PS_RB_WORKER B WHERE A.PERSON_ID = B.PERSON_ID AND B.EMPL_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TSK_DELEGATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Id of the Person or Group to whom the task is delegated.
2	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object