GP_ED_CTRY_VW (SQL View)	Index Back
Countries in GP ED SETUP CAT Returns list of countries that have at least one existing entry in the GP_ED_SETUP_CAT table while applying country access based on users OPR RULE PRF.

GP_ED_CTRY_VW

(SQL View)

Countries in GP ED SETUP CAT

Returns list of countries that have at least one existing entry in the GP_ED_SETUP_CAT table while applying country access based on users OPR RULE PRF.

SELECT PRF.OPRID , CT.COUNTRY , CT.DESCR FROM PS_GP_PSLP_CTRY_VW CT , PS_GP_OPR_RULE_PRF PRF WHERE (PRF.COUNTRY='ALL' OR PRF.COUNTRY=CT.COUNTRY OR CT.COUNTRY = 'ALL') AND EXISTS ( SELECT 1 FROM PS_GP_ED_SETUP_CAT ED WHERE ED.COUNTRY = CT.COUNTRY)

Related Language Record: GP_ED_CTRY_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description