INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
AID_YEARDefault Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL
SFA_RPTD_SCHL_IDPrompt Table: SFA_LN_SCHL_VW
SFA_LN_ATTSRCH(SQL View) |
Index Back |
|---|---|
Loan Institution VwRecord used to define School/Institution wide Loan processing options, by Aid Year. |
| SELECT DISTINCT A.INSTITUTION , A.AID_YEAR , A.SFA_RPTD_SCHL_ID FROM PS_SFA_COD_LN_ATTD A |
| # | 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_RPTD_SCHL_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Common School ID for use with the Department of Education financial aid.
Prompt Table: SFA_LN_SCHL_VW |