RD_PTNR_SPRF_VW (SQL View)	Index Back
Partner Security Profile View This is view of Partner Security Profile showing all the memberships and profiles associated with a partner.

RD_PTNR_SPRF_VW

(SQL View)

Partner Security Profile View

This is view of Partner Security Profile showing all the memberships and profiles associated with a partner.

SELECT DISTINCT A.BO_ID , A.RSEC_MEMBER_ID , B.RSEC_PROFILE_ID FROM PS_RSEC_ML_PARTNER A , PS_RSEC_PROFILEMDM B WHERE A.RSEC_MEMBER_ID = B.RSEC_MEMBER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
Prompt Table: RSEC_BO_PART_VW

2 RSEC_MEMBER_ID Character(30) VARCHAR2(30) NOT NULL Security Membership ID for application security membership definition.

3 RSEC_PROFILE_ID Character(30) VARCHAR2(30) NOT NULL A unique identifier of security profile for application security.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: RSEC_BO_PART_VW
2	RSEC_MEMBER_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Membership ID for application security membership definition.
3	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.