HI_GL_RUN_VW

(SQL View)
 Index Back

Payroll Run IDs with GL Data

This view retrieves all run ids 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.RUN_ID , B.DESCR , B.DESCRSHORT FROM PS_PAY_RUN_TBL B , PS_GL_GEN_HISTORY A WHERE A.PROGRAM_ID = 'PAYGL01' AND A.RUN_DT = ( SELECT MAX(A1.RUN_DT) FROM PS_GL_GEN_HISTORY A1 WHERE A1.PROGRAM_ID = 'PAYGL01' AND A1.RUN_ID = A.RUN_ID ) AND A.GL_RUN_NUM = ( SELECT MAX(A2.GL_RUN_NUM) FROM PS_GL_GEN_HISTORY A2 WHERE A2.PROGRAM_ID = 'PAYGL01' AND A2.RUN_ID = A.RUN_ID AND A2.RUN_DT = A.RUN_DT ) AND A.GL_GEN_STATUS = 'N' AND B.RUN_ID = A.RUN_ID

  • Related Language Record: PAY_RUN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description