PC_BUD_BP_VW (SQL View)	Index Back
Budget Period Calendar This dynamic view populates the BUDGET_PERIOD field with the proper range of budget periods based on the budget start date and number of periods.

PC_BUD_BP_VW

(SQL View)

Budget Period Calendar

This dynamic view populates the BUDGET_PERIOD field with the proper range of budget periods based on the budget start date and number of periods.

SELECT A.BUDGET_PERIOD , A.CALENDAR_ID , A.BEGIN_DT , A.END_DT , A.PERIOD_NAME FROM PS_CAL_BP_TBL A , PS_CAL_DEFN_TBL B WHERE A.SETID = B.SETID AND A.CALENDAR_ID = B.CALENDAR_ID AND B.CALENDAR_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

3 BEGIN_DT Date(10) DATE NOT NULL Begin Date

4 END_DT Date(10) DATE NOT NULL End Date

5 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
4	END_DT	Date(10)	DATE NOT NULL	End Date
5	PERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Period Name