GPCN_BG_CM_LANG

(SQL View)
 Index Back

Language table for Budget CM

Language table for Budget Compariosn Report

SELECT a.gpcn_bdgt_item , a.gpcn_bdgt_prd , a.setid , a.tree_name , a.tree_effdt , c.gpcn_bdgt_unit , l.language_cd , l.descr FROM ps_gpcn_bdgt_distr a , ps_gpcn_bdgt_dteff b , ps_gpcn_bdgt_dt_bu c , PS_GPCN_B_DTBU_LNG l WHERE a.gpcn_bdgt_stats = 'D' AND a.gpcn_bdgt_item = b.gpcn_bdgt_item AND a.gpcn_bdgt_prd = b.gpcn_bdgt_prd AND a.setid = b.setid AND a.tree_name = b.tree_name AND a.tree_effdt = b.tree_effdt AND a.gpcn_bdgt_item = c.gpcn_bdgt_item AND a.gpcn_bdgt_prd = c.gpcn_bdgt_prd AND a.setid = c.setid AND a.tree_name = c.tree_name AND a.tree_effdt = c.tree_effdt AND b.effdt = c.effdt AND b.effdt = ( SELECT MAX(effdt) FROM ps_gpcn_bdgt_dteff d WHERE a.gpcn_bdgt_item = d.gpcn_bdgt_item AND a.gpcn_bdgt_prd = d.gpcn_bdgt_prd AND a.setid = d.setid AND a.tree_name = d.tree_name AND a.tree_effdt = d.tree_effdt) AND c.gpcn_bdgt_unit <> 'ALL_DEPTS' AND a.gpcn_bdgt_item = l.gpcn_bdgt_item AND a.gpcn_bdgt_prd = l.gpcn_bdgt_prd AND a.setid = l.setid AND a.tree_name = l.tree_name AND a.tree_effdt = l.tree_effdt

  • Related Language Record for GPCN_BDGT_CC_VW GPCN_BDGT_CM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCN_BDGT_ITEM Character(10) VARCHAR2(10) NOT NULL Budget Item

    Prompt Table: GPCN_BDGT_ITEM

    2 GPCN_BDGT_PRD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: GPCN_BDGT_PRD

    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: GPCN_SEC_T_VW

    5 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

    Prompt Table: GPCN_SEC_TE_VW

    6 GPCN_BDGT_UNIT Character(20) VARCHAR2(20) NOT NULL Bdget Unit
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description