INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
INTV_CDAV_CMPGN_ASK_VW(SQL View) |
Index Back |
|---|---|
Open Asks Amount/Count ViewThis is a view of the Constituient Action table that returns the amount and count of Open 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_STAT_CD <> 'CMP' AND A.ACTN_STAT_CD <> 'CAN' 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_OPEN_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Outstanding Asks |
| 4 | ASK_OPEN_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Nbr Open Asks |