HI_GL_RUN_2_VW (SQL View)	Index Back
Payroll Run IDs with GL Data This view retrieves all companies/paygroup/pay_end_date combinations for which the PAYGL01 process has been run. They are entered in the GL_GEN_HISTORY table with a GL_GEN_STATUS of N.

HI_GL_RUN_2_VW

(SQL View)

Payroll Run IDs with GL Data

This view retrieves all companies/paygroup/pay_end_date combinations for which the PAYGL01 process has been run. They are entered in the GL_GEN_HISTORY table with a GL_GEN_STATUS of N.

SELECT DISTINCT A.COMPANY , A.PAYGROUP , C.DESCR FROM PS_HI_GL_RUN_3_VW A , PS_PAYGROUP_TBL C WHERE C.PAYGROUP = A.PAYGROUP AND C.EFFDT= ( SELECT MAX(C1.EFFDT) FROM PS_PAYGROUP_TBL C1 WHERE C1.PAYGROUP = C.PAYGROUP AND C1.EFFDT <= A.PAY_END_DT AND C1.EFF_STATUS <> 'I' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description