PC_CAL_SUMM_VW

(SQL View)
 Index Back

PC View of SummaryCalendars

View of Summary Calendars used to build the Projects Cube.

SELECT SETID , DETAIL_CALENDAR , CALENDAR_ID , DESCR FROM PS_CAL_DEFN_TBL WHERE CALENDAR_TYPE = 'S'

  • Related Language Record: PC_CALSUMVW_LNG

    • # 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 PC_CAL_TYPE_MT Character(2) VARCHAR2(2) NOT NULL Monthly Calendar
    3 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_SUMM_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description