KSEC_BP_VW

(SQL View)
Index Back

CC Security - Budget Period VW


SELECT A.SETID ,A.CALENDAR_ID ,B.BUDGET_PERIOD FROM PS_CAL_DEFN_TBL A ,PS_CAL_BP_TBL B WHERE A.SETID = B.SETID AND A.CALENDAR_ID = B.CALENDAR_ID

# 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 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period