GP_GL_CHART_VW (SQL View)	Index Back
View of GL CHART based on OPR View of GP GL CHART that limits the user to see GL CHARTs for the country of their user profile (unless their profile is for "ALL Countries")

GP_GL_CHART_VW

(SQL View)

View of GL CHART based on OPR

View of GP GL CHART that limits the user to see GL CHARTs for the country of their user profile (unless their profile is for "ALL Countries")

SELECT GL.PAY_ENTITY ,GL.BUSINESS_UNIT ,OP.OPRID ,PE.COUNTRY FROM PS_GP_GL_CHARTFLD GL , PS_GP_PYENT PE , PS_GP_OPR_RULE_PRF OP WHERE (GL.PAY_ENTITY=PE.PAY_ENTITY AND PE.COUNTRY=OP.COUNTRY) OR (GL.PAY_ENTITY=PE.PAY_ENTITY AND OP.USED_BY='A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT_OPR_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT_OPR_VW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country