KK_SUM_BPCAL_VW

(SQL View)
 Index Back

Summary budget period calendar

This view is used on the CC budgets overview inquiry to prompt for summary budget period calendar ids.

SELECT DISTINCT A.SETID , A.CALENDAR_ID , A.DESCR , A.CALENDAR_TYPE FROM PS_CAL_DEFN_TBL A , PS_CAL_BP_TBL B WHERE A.SETID = B.SETID AND A.DETAIL_CALENDAR = B.CALENDAR_ID AND A.CALENDAR_TYPE IN('I') AND A.DETAIL_CALENDAR > ' '

  • Related Language Record: KK_SUMBPLNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CALENDAR_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Calendar
    B=Budget Calendar
    D=Detail Calendar
    I=Summary Budget Period Calendar
    P=Budget Period Calendar
    S=Summary Calendar
    T=Promo Mgmt Sales Calendar