RSEC_PRFFGVW (SQL View)	Index Back
Security Profile Function view View that shows the functional option groups associated to application security rule.

RSEC_PRFFGVW

(SQL View)

Security Profile Function view

View that shows the functional option groups associated to application security rule.

SELECT PF.RSEC_PROFILE_ID , FG.RSEC_FUNC_GRP_ID , FG.DESCR FROM %Table(RSEC_PROFILEFNC) PF , %Table(RSEC_FUNC_GROUP) FG WHERE PF.RSEC_FUNC_GRP_ID = FG.RSEC_FUNC_GRP_ID

Related Language Record: RSEC_PRFG_LNGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RSEC_FUNC_GRP_ID Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.
2	RSEC_FUNC_GRP_ID	Character(30)	VARCHAR2(30) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description