RC_ACCES_MEM_VW (SQL View)	Index Back
Case Access Member Name View This view brings the name and alternate character for the person

RC_ACCES_MEM_VW

(SQL View)

Case Access Member Name View

This view brings the name and alternate character for the person

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 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 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)