PC_PM_TOPD_VW

(SQL View)
Index Back

Budget Period Calendar ID to


SELECT A.SETID , A.CALENDAR_ID , A.BUDGET_PERIOD , A.END_DT FROM PS_CAL_BP_TBL A , PS_INSTALLATION_PC B WHERE A.CALENDAR_ID = B.PC_SUM_CAL_ID

  • Parent record: CAL_DEFN_TBL
  • # 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

    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    3 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
    4 END_DT Date(10) DATE NOT NULL End Date