RC_ER_MEM_VW (SQL View)	Index Back
ER Memeber View View holds the list of users having ER roles as defined in the role map page

RC_ER_MEM_VW

(SQL View)

ER Memeber View

View holds the list of users having ER roles as defined in the role map page

SELECT p.PERSON_ID , n.LAST_NAME , n.FIRST_NAME , n.BO_NAME_DISPLAY , n.NAME_AC FROM PS_RD_PERSON p , PS_BO_NAME n , PS_BO_ROLE r , PSOPRALIAS o , PSROLEUSER u 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 o.PERSON_ID = p.PERSON_ID AND u.ROLEUSER = o.OPRID AND u.ROLENAME IN ( SELECT ROLENAME FROM PS_RC_ER_ROLE_MAP WHERE DISP_TMPL_FAM_CD = 'CRM_ERHD') AND n.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

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

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

4 BO_NAME_DISPLAY_5 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
2	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
4	BO_NAME_DISPLAY_5	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)