CAL_BP_VW (SQL View)	Index Back
Calendar Budget Period View To reduce the number of budget periods displayed on the prompt this view reduces the list to those budget periods within the Fiscal Year

CAL_BP_VW

(SQL View)

Calendar Budget Period View

To reduce the number of budget periods displayed on the prompt this view reduces the list to those budget periods within the Fiscal Year

SELECT DISTINCT A.SETID , A.CALENDAR_ID , A.FISCAL_YEAR , B.BUDGET_PERIOD , B.PERIOD_NAME , B.BEGIN_DT , B.END_DT FROM PS_CAL_DETP_TBL A , PS_CAL_BP_TBL B WHERE B.SETID = A.SETID AND B.BEGIN_DT <= ( SELECT MAX(C.END_DT) FROM PS_CAL_DETP_TBL C WHERE C.SETID = A.SETID AND C.CALENDAR_ID = A.CALENDAR_ID AND C.FISCAL_YEAR = A.FISCAL_YEAR) AND B.END_DT >= ( SELECT MIN(D.BEGIN_DT) FROM PS_CAL_DETP_TBL D WHERE D.SETID = A.SETID AND D.CALENDAR_ID = A.CALENDAR_ID AND D.FISCAL_YEAR = A.FISCAL_YEAR)

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

4 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

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

6 BEGIN_DT Date(10) DATE NOT NULL Begin Date

7 END_DT Date(10) DATE end date

#	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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period
5	PERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Period Name
6	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
7	END_DT	Date(10)	DATE	end date