GP_CG_CO_LVW

(SQL View)
 Index Back

Lang rec for GP CG CO VW

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.LANGUAGE_CD , CO.DESCR FROM PS_GP_PYE_PRC_STAT PPS , PS_JOB JOB , PS_COMPNY_TBL_LANG 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_COMPNY_TBL_LANG CC WHERE CO.COMPANY = CC.COMPANY AND CO.LANGUAGE_CD=CC.LANGUAGE_CD AND CC.EFFDT <= %CurrentDateIn)

  • Related Language Record for GP_CG_CO_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description