SFA_SLC_TFRAVW6(SQL View) |
Index Back |
|---|---|
Sum of SFA_SLC_TFRAVW5Sums the amount fields in SFA_SLC_TFRAVW5 and calculates a difference field. |
| SELECT INSTITUTION , AID_YEAR , SFA_SLC_HEI_CD , SFA_SLC_ACAD_YR , ITEM_TYPE_GROUP , SUM(SFA_SLC_FEE_AMT) , SUM(ACCEPT_AMOUNT) , SUM(SFA_SLC_FEE_AMT) - SUM(ACCEPT_AMOUNT) , SFA_SLC_PAYMNT_TYP , CURRENCY_CD FROM PS_SFA_SLC_TFRAVW5 GROUP BY INSTITUTION , AID_YEAR , SFA_SLC_HEI_CD , SFA_SLC_ACAD_YR , SFA_SLC_PAYMNT_TYP , ITEM_TYPE_GROUP , CURRENCY_CD |
| # | 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_DIFFERENCE_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Difference Amount |
| 9 | SFA_SLC_PAYMNT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
G=Tuition Fee Grant T=Tuition Fee Loan |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |