AV_MBR_EXPNS_VW (SQL View)	Index Back
Membership Budget Expense View This view will sum the total budget expenses for a given Membership Initiative.

AV_MBR_EXPNS_VW

(SQL View)

Membership Budget Expense View

This view will sum the total budget expenses for a given Membership Initiative.

SELECT INSTITUTION , INTV_CD , SUM(BUDGET_EXPNS_AMT) FROM PS_AV_INTV_BGT_DTL GROUP BY INSTITUTION , INTV_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

3 MBR_EXPENSES Number(16,2) DECIMAL(15,2) NOT NULL Derived field for Membership Progress Panel. The sum of all the expenses that have been entered for this membership campaign initiative.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
3	MBR_EXPENSES	Number(16,2)	DECIMAL(15,2) NOT NULL	Derived field for Membership Progress Panel. The sum of all the expenses that have been entered for this membership campaign initiative.