GPAU_GL_PREP_VW (SQL View)	Index Back
Prompt view for Online inquiry This prompt view is used by the General Ledger Online inquiry page to view GL transactions per calendar run id and pay entity.

GPAU_GL_PREP_VW

(SQL View)

Prompt view for Online inquiry

This prompt view is used by the General Ledger Online inquiry page to view GL transactions per calendar run id and pay entity.

SELECT CAL_RUN_ID , PAY_ENTITY , GROUPING_CODE , EMPLID FROM PS_GP_GL_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

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

3 GROUPING_CODE Character(15) VARCHAR2(15) NOT NULL Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	GROUPING_CODE	Character(15)	VARCHAR2(15) NOT NULL	Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID