RSEC_PRFMEMVW (SQL View)	Index Back
Security Profile Member View View that shows the membership list associated to application security profile.

RSEC_PRFMEMVW

(SQL View)

Security Profile Member View

View that shows the membership list associated to application security profile.

SELECT MEM.RSEC_MEMBER_ID , PM.RSEC_PROFILE_ID , MEM.DESCR FROM %Table(RSEC_PROFILEMDM) PM , %Table(RSEC_MEMBERDEFN) MEM WHERE PM.RSEC_MEMBER_ID = MEM.RSEC_MEMBER_ID

Related Language Record: RSEC_PRFM_LNGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_MEMBER_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Membership ID for application security membership definition.
2	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description