EMPLIDINSTITUTIONAID_YEARITEM_TYPEDefault Value: INSTALLATION.EXCHNG_TO_CURRENCY
SFA_DISBAWD_VW(SQL View) |
Index Back |
|---|---|
Student Disb Award ViewSelects rows from STDNT_DISB_AWD for an Institution and Aid Year. |
| SELECT C.EMPLID , C.INSTITUTION , C.AID_YEAR , C.ITEM_TYPE , 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 5 | SFA_DISBURSED_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Disbursed Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |