Understanding Your Data for FA. Jodi M. Dyson, CIS Systems Analyst Forsyth Technical Community College. Just give me the #!*&% data!!. Files Keyed on Colleague ID. Non Year Specific. File Suite – Year Specific. STUDENTS FIN.AID CS.ACYR SA.ACYR YS.ACYR. FFSP-File suites created annually.
Jodi M. Dyson, CIS Systems Analyst
Forsyth Technical Community College
Non Year Specific
File Suite – Year Specific
Budget and ISIR Information (FASI)
Annual Award Information (AIDE)
Term level award amount, status, & registered credits (AIDE)
Contains Misc. FA Fields and the FILE COMPLETE DATE
Summary loan data, such as specific loan amount and disbursement dates
ISIR.DEMO – student demographic data from the FAFSA
ISIR.FAFSA – the exact responses the student put on the FAFSA application
ISIR.RESULTS – Match flags, comment codes, etc.
ISIR.CALC.RESULTS – Reject codes and information that supports EFC
PERSON-demographic information from CORE
STUDENTS-general student data
MAILING-communication management information (doc tracking letter, etc.)
STUDENT.TERMS-term-level data for a student; one record per student for each term that they register
INSTITUTIONS.ATTEND-one record for each ‘other’ institution that a student attended (high school, other colleges, etc.)
STUDENT.PROGRAMS-information regarding each of the student’s programs; one record for each program in which the student has enrolled
AR.ACCTS-general information about a student’s account; one record per student, per AR type
RDEL can be accessed directly or through drill down from RFEI.
Enter the file name to view or use LookUp option like…verif…
Associated – Multi-valued field associated with other multi-valued fields in the file.
Data – Single-valued field.
List – Multi-valued field that is not part of an association.
Text – Free-form text.
Q Pointer – Multi-valued pointer (contains multiple keys to another file).
X Pointer – Single-valued pointer (contains a key to another file).
Associated co-files: A list of all files that share the same key.
I’m off to find the data!!