GP_GL_GRP_SRCH (SQL View)	Index Back
Search view for GL Grouping View of GP GL GROUP that limits the user to see GL GROUPs for the country of their user profile (unless their profile is for "ALL Countries")

GP_GL_GRP_SRCH

(SQL View)

Search view for GL Grouping

View of GP GL GROUP that limits the user to see GL GROUPs 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_GROUP GL , PS_GP_PYENT PE , PS_GP_OPR_RULE_PRF OP WHERE GL.PAY_ENTITY=PE.PAY_ENTITY AND (PE.COUNTRY=OP.COUNTRY OR 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