GP_CG_CO_VW

(SQL View)
 Index Back

Companies in Calendar Group

Used for prompt-edits. Lists COs that are represented in a Cal Grp based on GP PYE PRC STAT

SELECT DISTINCT PPS.CAL_RUN_ID , CO.COMPANY , CO.DESCR FROM PS_GP_PYE_PRC_STAT PPS , PS_JOB JOB , PS_COMPANY_TBL CO WHERE PPS.EMPLID=JOB.EMPLID AND PPS.EMPL_RCD=JOB.EMPL_RCD AND JOB.EFFDT = ( SELECT MAX(JJ.EFFDT) FROM PS_JOB JJ WHERE JJ.EMPLID=PPS.EMPLID AND JJ.EMPL_RCD=PPS.EMPL_RCD AND JJ.EFFDT <= PPS.PRD_END_DT) AND JOB.COMPANY=CO.COMPANY AND CO.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_COMPANY_TBL CC WHERE CO.COMPANY = CC.COMPANY AND CC.EFFDT <= %CurrentDateIn)

  • Related Language Record: GP_CG_CO_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description