SFA_SLC_TFRAVW5(SQL View) |
Index Back |
|---|---|
SLC TFRA, Award Total ViewUnions the results from SFA_SLC_TFRAVW4 and SFA_SLC_AWDGTVW |
| SELECT S.INSTITUTION , S.AID_YEAR , S.SFA_SLC_HEI_CD , S.SFA_SLC_ACAD_YR , S.ITEM_TYPE_GROUP , T.SFA_SLC_FEE_AMT , 0 , T.SFA_SLC_PAYMNT_TYP , T.CURRENCY_CD FROM PS_SFA_SLC_TFRAVW4 T , PS_SFA_SLC_SGRP_VW S WHERE S.SFA_SLC_HEI_CD = T.SFA_SLC_HEI_CD AND S.SFA_SLC_ACAD_YR = T.SFA_SLC_ACAD_YR AND T.SFA_SLC_PAYMNT_TYP = S.SFA_SLC_PAYMNT_TYP UNION ALL SELECT A.INSTITUTION , A.AID_YEAR , A.SFA_SLC_HEI_CD , A.SFA_SLC_ACAD_YR , A.ITEM_TYPE_GROUP , 0 , A.ACCEPT_AMOUNT , S1.SFA_SLC_PAYMNT_TYP , A.CURRENCY_CD FROM PS_SFA_SLC_AWDGTVW A , PS_SFA_SLC_SGRP_VW S1 WHERE A.INSTITUTION = S1.INSTITUTION AND A.AID_YEAR = S1.AID_YEAR AND A.SFA_SLC_HEI_CD = S1.SFA_SLC_HEI_CD AND A.ITEM_TYPE_GROUP = S1.ITEM_TYPE_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 3 | SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table: SFA_SLC_HEI_VW |
| 4 | SFA_SLC_ACAD_YR |
Character(4) | VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table: SFA_SLC_ACYR_VW |
| 5 | ITEM_TYPE_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Item Type Group |
| 6 | SFA_SLC_FEE_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Fee Amount |
| 7 | ACCEPT_AMOUNT | Number(12,2) | DECIMAL(11,2) NOT NULL | Accept Amount |
| 8 | SFA_SLC_PAYMNT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
G=Tuition Fee Grant T=Tuition Fee Loan |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |