RC_ASGN_HIST_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_HIST_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.NAME_AC FROM PS_RB_WORKER A , PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y'

# 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 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

#	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	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)