INSTITUTIONAID_YEARDefault Value: INSTALLATION.EXCHNG_TO_CURRENCY
SFA_DISBTOT_VW(SQL View) |
Index Back |
|---|---|
Student Disb Award Total ViewSelects the total DISBURSED_AMOUNT from STDNT_DISB_AWD for an Institution and Aid Year. |
| SELECT C.INSTITUTION , C.AID_YEAR , SUM(C.DISBURSED_AMOUNT) , D.CURRENCY_CD FROM PS_STDNT_DISB_AWD C , PS_STDNT_AWRD_DISB D WHERE D.EMPLID = C.EMPLID AND D.INSTITUTION = C.INSTITUTION AND D.AID_YEAR = C.AID_YEAR AND D.ITEM_TYPE = C.ITEM_TYPE AND D.ACAD_CAREER = C.ACAD_CAREER AND D.DISBURSEMENT_ID = C.DISBURSEMENT_ID GROUP BY D.CURRENCY_CD, C.INSTITUTION, C.AID_YEAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 3 | SFA_DISBURSED_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Disbursed Amount |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |