RSEC_PRFV_LNGVW (SQL View)	Index Back
View lists associated profile Related language of the view list descriptions that are associated to a security profile.

RSEC_PRFV_LNGVW

(SQL View)

View lists associated profile

Related language of the view list descriptions that are associated to a security profile.

SELECT PV.RSEC_PROFILE_ID , VL.RSEC_VIEW_ID , VLNG.LANGUAGE_CD , VLNG.DESCR FROM %Table(RSEC_PROFILEVDM) PV , %Table(RSEC_VIEW_DEFN) VL , %Table(RSEC_VIEW_LNG) VLNG WHERE PV.RSEC_VIEW_ID = VL.RSEC_VIEW_ID AND VL.RSEC_VIEW_ID = VLNG.RSEC_VIEW_ID

Related Language Record for RSEC_PRFVLISTVW

# 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_VIEW_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier of a view list used in application security.

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_VIEW_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier of a view list used in application security.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description