INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
AID_YEARSFA_SLC_HEI_CDPrompt Table: SFA_SLC_HEI_VW
Prompt Table: SFA_SLC_ACYR_VW
G=Tuition Fee Grant
T=Tuition Fee Loan
SFA_SLC_SGRP_VW(SQL View) |
Index Back |
|---|---|
SLC TFRA Item Group ViewUsed to return one row for each TFRA Item Group entered in the SFA_SLC_SETUP table. Allows results from TFRA tables to be joined to Student Awards table using ITEM_TYPE_GROUP. |
| SELECT INSTITUTION , AID_YEAR , SFA_SLC_HEI_CD , SFA_SLC_ACAD_YR , 'T' , SFA_SLC_TLOAN_GRP FROM PS_SFA_SLC_SETUP UNION ALL SELECT INSTITUTION , AID_YEAR , SFA_SLC_HEI_CD , SFA_SLC_ACAD_YR , 'G' , SFA_SLC_TGRANT_GRP FROM PS_SFA_SLC_SETUP |
| # | 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 |
| 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 | SFA_SLC_PAYMNT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
G=Tuition Fee Grant T=Tuition Fee Loan |
| 6 | ITEM_TYPE_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Item Type Group |