RSEC_PRFG_LNGVW (SQL View)	Index Back
Functional option groups Related language of the functional option group descriptions that are associated to a security profile.

RSEC_PRFG_LNGVW

(SQL View)

Functional option groups

Related language of the functional option group descriptions that are associated to a security profile.

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

Related Language Record for RSEC_PRFFGVW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description