RC_ASGN_SRCH_VW (SQL View)	Index Back
Assignment History This record contains all of the provider group and agent assignments that have been made to each case. This view is used for configurable search for finding cases by provider group or assigned to.

RC_ASGN_SRCH_VW

(SQL View)

Assignment History

This record contains all of the provider group and agent assignments that have been made to each case. This view is used for configurable search for finding cases by provider group or assigned to.

SELECT B.BO_NAME_DISPLAY , B.BO_NAME_DISP_UPPER , B.BO_ID , 4 , A.SYNCID FROM PS_RC_CASE A , PS_BO_NAME B , PS_RD_PERSON C , PS_RC_ASSIGN_HIST D WHERE D.ASSIGNED_TO = C.PERSON_ID AND C.BO_ID = B.BO_ID AND A.CASE_ID = D.CASE_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_NAME_DISPLAY_6 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

2 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper

3 BO_ID_3 Number(31,0) DECIMAL(31) NOT NULL Business object ID 3rd version

4 ROLE_TYPE_ID_3 Number(12,0) DECIMAL(12) NOT NULL Role Type ID

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_NAME_DISPLAY_6	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
2	BO_NAME_DISP_UPPER	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object in Upper
3	BO_ID_3	Number(31,0)	DECIMAL(31) NOT NULL	Business object ID 3rd version
4	ROLE_TYPE_ID_3	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
5	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.