HI_GL_RUN_1_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_1_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 , B.DESCR FROM PS_HI_GL_RUN_3_VW A , PS_COMPANY_TBL B WHERE B.COMPANY = A.COMPANY AND B.EFFDT= ( SELECT MAX(B1.EFFDT) FROM PS_COMPANY_TBL B1 WHERE B1.COMPANY = B.COMPANY AND B1.EFFDT <= A.PAY_END_DT AND B1.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 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description