GP_PYENT_OPR_VL (SQL View)	Index Back
RelVw of PYENT based on OprPrf Related language View of GP PYENT that limits user to the see PAY ENTITY s for the country of their user profile (unless their profile is for "ALL Countries"

GP_PYENT_OPR_VL

(SQL View)

RelVw of PYENT based on OprPrf

Related language View of GP PYENT that limits user to the see PAY ENTITY s for the country of their user profile (unless their profile is for "ALL Countries"

SELECT P.PAY_ENTITY , OP.OPRID , PL.LANGUAGE_CD , PL.DESCR FROM PS_GP_PYENT P , PS_GP_PYENT_LANG PL , PS_GP_OPR_RULE_PRF OP WHERE P.PAY_ENTITY=PL.PAY_ENTITY AND (P.COUNTRY = OP.COUNTRY OR OP.USED_BY = 'A')

Related Language Record for GP_PYENT_OPR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

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

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	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description