ISIRs contain student FAFSA data from the Department of Education. ISIRs are used for a wide variety of financial aid processes including determining dependency status, federal taxable income, and updating aggregates. There article highlights some of the ways we currently identify
Method 1: SAI Status
This field can be viewed manually on a student’s View Financial Aid Status screen. Most importantly, it helps us identify which students are ready for need-based aid packaging. An Official status means a valid ISIR has been received and the student’s SAI is ready to use for awarding. If an ISIR has not been received, the student’s SAI status will typically show as Unofficial.
Query Field Name: EFC_STATUS
Example Query Table: ISIR_CONTROL
| Status |
Translation |
| O |
Official |
| R |
Rejected |
| U |
Unofficial |
| Z |
Provisional |
Method 2: ISIR_STUDENT Table
Another way to check is by building a query against the ISIR_STUDENT table. In the query, you can prompt for an aid year to narrow results. If we have received an ISIR for a student in that aid year, their record will appear on the ISIR_STUDENT table. Below is example SQL that identifies all students with a received ISIR by aid year.
Example SQL:
SELECT A.EMPLID, A.AID_YEAR, TO_CHAR(A.EFFDT,'YYYY-MM-DD')
FROM PS_ISIR_STUDENT A
WHERE ( A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ISIR_STUDENT A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ISIR_STUDENT A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.AID_YEAR = A_ES.AID_YEAR
AND A.EFFDT = A_ES.EFFDT)
AND A.AID_YEAR = :1)