PC_BUD_ITEM_LNG

(SQL View)
Index Back

Budget Item Language

Related language view for miscellaneous budget item views.

SELECT A.SETID , A.BUDGET_CATEGORY , L.LANGUAGE_CD , L.DESCR FROM %Table(GM_BUD_CATEGORY) A , %Table(GM_BUD_CAT_LNG) L WHERE A.SETID = L.SETID AND A.BUDGET_CATEGORY = L.BUDGET_CATEGORY AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(GM_BUD_CATEGORY) B WHERE %Join(COMMON_KEYS, GM_BUD_CATEGORY A, GM_BUD_CATEGORY B, EFFDT) AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND L.EFFDT = ( SELECT MAX(C.EFFDT) FROM %Table(GM_BUD_CATEGORY) C WHERE %Join(COMMON_KEYS, GM_BUD_CATEGORY L, GM_BUD_CATEGORY C, EFFDT) AND L.EFFDT <= %CurrentDateIn)

  • Related Language Record for BUDGET_ITEM_ASS BUDGET_ITEM_LAB BUDGET_ITEM_MAT BUDGET_ITEM_NOL BUDGET_ITEM_OTH REV_BUD_ITEM_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description