RC_WL_TKASGNLVW (SQL View)	Index Back
Task Assignment View This view returns the person name, role description or provider group name assigned to a business project task worklist item.

RC_WL_TKASGNLVW

(SQL View)

Task Assignment View

This view returns the person name, role description or provider group name assigned to a business project task worklist item.

SELECT A.SYNCID , CASE WHEN A.RC_ASSIGNMENT_OPT = 'P' THEN B.LANGUAGE_CD WHEN A.RC_ASSIGNMENT_OPT = 'G' THEN C.LANGUAGE_CD WHEN A.RC_ASSIGNMENT_OPT = 'C' THEN ' ' END , CASE WHEN A.RC_ASSIGNMENT_OPT = 'P' THEN B.NAME1 WHEN A.RC_ASSIGNMENT_OPT = 'G' THEN C.DESCR WHEN A.RC_ASSIGNMENT_OPT = 'C' THEN D.BO_NAME_DISPLAY END FROM PS_RC_TASK A , PS_RF_PROVGRP_LNG B , PSROLEDEFNLANG C , PS_RB_PRSN_P_NM_VW D , PS_RC_WF_BUSPRC_VW E WHERE E.RC_TASK_ID = A.RC_TASK_ID AND A.SETID = B.SETID (+) AND %Substring(A.RC_ASSIGNED_TO,1,10) = B.PROVIDER_GRP_ID (+) AND A.RC_ASSIGNED_TO = C.ROLENAME (+) AND %Substring(A.RC_ASSIGNED_TO,1,15) = D.PERSON_ID (+)

Related Language Record for RC_WL_TKASGN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	BO_NAME_DISPLAY_1	Character(80)	VARCHAR2(80) NOT NULL	This field represents the Display Name for a business object