AV_ASK_DECL_VW (SQL View)	Index Back
Declined Asks Amount/Count Vw This is a view of the Constituient Action table that returns the amount and count of Declined Asks for a given Campaign Initiative.

AV_ASK_DECL_VW

(SQL View)

Declined Asks Amount/Count Vw

This is a view of the Constituient Action table that returns the amount and count of Declined Asks for a given Campaign Initiative.

SELECT A.INSTITUTION, B.INTV_CD, SUM(A.ASK_AMT), COUNT(*) FROM PS_AV_CNST_ACTN A, PS_AV_ACTN_INTV B WHERE A.INSTITUTION = B.INSTITUTION AND A.EMPLID = B.EMPLID AND A.EXT_ORG_ID = B.EXT_ORG_ID AND A.CNST_ACTN_NO = B.CNST_ACTN_NO AND A.ACTN_TYPE_CD = 'ASK' AND A.ACTN_RSLT_CD = 'DECL' GROUP BY A.INSTITUTION, B.INTV_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION

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

3 ASK_DECL_AMT Number(16,2) DECIMAL(15,2) NOT NULL Declined Asks

4 ASK_DECL_CNT Number(9,0) DECIMAL(9) NOT NULL Nbr Declined Asks

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_OPR_DEF_TBL.INSTITUTION
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
3	ASK_DECL_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Declined Asks
4	ASK_DECL_CNT	Number(9,0)	DECIMAL(9) NOT NULL	Nbr Declined Asks