GPCH_CC_MAP_LNG

(SQL View)
 Index Back

RL-Mapping CostCenter/Dept

Mapping CostCenter / Department

SELECT M.HPYP_CC_ID , E.LANGUAGE_CD , M.PIN_CHART2_VAL , M.EFFDT , M.PAY_ENTITY , CC.DESCR40 , E.DESCR , M.BUSINESS_UNIT , M.HPYP_CNTRL_AREA ,D.SETID FROM PS_GP_CC_MAP M , PS_HPYP_CC_TBL CC , PS_DEPT_TBL D , PS_DEPT_TBL_LANG E , PS_GP_CC_SET S WHERE D.SETID = E.SETID AND M.PAY_ENTITY = S.PAY_ENTITY AND M.BUSINESS_UNIT = S.BUSINESS_UNIT AND S.SEQNUM = 1 AND M.EFFDT = S.EFFDT AND M.HPYP_CNTRL_AREA = CC.HPYP_CNTRL_AREA AND M.HPYP_CC_ID = CC.HPYP_CC_ID AND CC.EFF_STATUS = 'A' AND CC.BUSINESS_UNIT_GL = S.BUSINESS_UNIT AND CC.EFFDT = ( SELECT MAX(CC1.EFFDT) FROM PS_HPYP_CC_TBL CC1 WHERE CC.HPYP_CNTRL_AREA = CC1.HPYP_CNTRL_AREA AND CC.HPYP_CC_ID = CC1.HPYP_CC_ID AND CC.BUSINESS_UNIT_GL = CC1.BUSINESS_UNIT_GL AND CC.EFF_STATUS = CC1.EFF_STATUS AND CC1.EFFDT <= M.EFFDT ) AND M.PIN_CHART2_VAL = D.DEPTID AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D.SETID = D1.SETID AND D.DEPTID = D1.DEPTID AND D.EFF_STATUS = 'A' AND D1.EFFDT <= M.EFFDT )

  • Related Language Record for GPCH_CC_MAP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HPYP_CC_ID Character(12) VARCHAR2(12) NOT NULL Cost Center ID.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    6 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    9 HPYP_CNTRL_AREA Character(5) VARCHAR2(5) NOT NULL Controlling Area
    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID