RC_ER_ASGN_N_VW (SQL View)	Index Back
View for searching assign to View created for Config Search, used as "deep query" for searching cases of a specific assign to person on search case page.

RC_ER_ASGN_N_VW

(SQL View)

View for searching assign to

View created for Config Search, used as "deep query" for searching cases of a specific assign to person on search case page.

SELECT n.BO_NAME_DISPLAY , n.BO_NAME_DISP_UPPER , p.EMPLID , n.FIRST_NAME , n.LAST_NAME FROM PS_RD_PERSON p , PS_BO_NAME n , PS_BO_ROLE r WHERE p.BO_ID = n.BO_ID AND p.BO_ID = r.BO_ID AND r.ROLE_TYPE_ID IN (4,88) AND r.ROLE_START_DT <= %CurrentDateIn AND r.ROLE_END_DT >= %CurrentDateIn AND n.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_NAME_DISPLAY_3 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_NAME_DISPLAY_3	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name