Understanding Your Data for FA Jodi M. Dyson, CIS Systems Analyst Forsyth Technical Community College Files Keyed on Colleague ID STUDENTS FIN.AID CS.ACYR SA.ACYR YS.ACYR FFSP-File suites created annually FILE STRUCTURE FIN.AID CS.ACYR YS.ACYR SA.ACYR TA.ACYR FIN.AID FA.SAP.RESULTS.ID FA.CS.YEARS FA.SA.YEARS FA.ENTR.INT.DT FA.LENDERS.ID FA.START.DATE FA.ADMIT.STATUS Created as soon as the student has FA data and maintained over the life of the student at the institution Pointers to both year specific tables and other non-year specific tables CS.ACYR Budget and ISIR Information (FASI) CS.FC CS.FED.ISIR.ID (pointer) CS.FED.ISIR.OR.CORRECTION (pointer) CS.FED.DEPENDENCY CS.ISIR.HOUSING CODES CS.HAS.ISIR CS.NEED CS.VERIF.STATUS CS.VERIF.DATE CS.STD.TOTAL.EXPENSES CS.COMP.ID CS.PKG.ATP.CODE Annual vs. Term Annual Per Year Per Term •SA.ACYR •TC.ACYR •TA.ACYR SA.ACYR Annual Award Information (AIDE) SA.AWARD SA.AMOUNT SA.ACTION SA.DATE SA.XMIT.AMT SA.PELL.ENTITLEMENT SA.AWARDED SA.ACCEPTED Annual 2 Awards 2 Terms Pell Fall Pell Pell Spring SA.ACYR SEOG Fall SEOG SEOG Spring TA.ACYR Term level award amount, status, & registered credits (AIDE) TA.TERM.ID TA.AW.ID TA.STUDENT.ID TA.TERM.ACTION TERM.TERM.ACTION.DATE TA.TERM.AMOUNT TA.TERM.XMIT.AMT TA.TERM.XMIT.DT TA.REG.CREDITS TA.QUERY.REG.CREDITS YS.ACYR Contains Misc. FA Fields and the FILE COMPLETE DATE YS.FILE.COMPLETE.DT YS.DECISION YS.MISC 1-5 File Structure: DIRECT LOANS DLE.DISB.SEQ DLE.AWARD DLE.DISB DLI.AWARD DLI.DISB DLE.DISB.SEQ SL.AWARD DLI.DISB.SEQ DLI.DISB.SEQ SL.ACYR Summary loan data, such as specific loan amount and disbursement dates SL.STUDENT.ID SL.ANT.DISB.AMT SL.ORIG.READY.TO.SEND SL.SCHOOL.CODE SL.ANT.DISB.TERM SL.REPORTING/ATTENDING.CAMPUS SL.ANT.DISB.DATE ISIR FILES 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 COMMON ISIR FIELDS IFAF.STUDENT.ID IFAF.IMPORT.YEAR IFAF.TRANS.NBR IFAF.READY.TO.SEND IFAF…(all the FAFSA answers) ICRES.REJECT CODES ICRES.AZE.IND ICRES.PRI.EFC ISIR.CALC.RESULTS.CHGDATE ICRES.PRI.TI IRES.TRANS.NBR IRES.RECEIPT.DT IRES.COMMENT.CODES IRES.SAR.C.FLAG IRES.CPS.PELL.ELIG NON FA FILES 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 NON FA FILES 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 COMMON FIELDS (NON FA) STU.ACTIVE.PROGRAMS STU.CURRENT.ACAD.LEVELS STU.CLASS STU.CURRENT.HOME.LOCATION STU.CURRENT.TYPE APPL.START.TERM APPL.ADMIT.STATUS GENDER AGE ETHNIC FIELD HELP (really is a BIG help) RDEL RDEL can be accessed directly or through drill down from RFEI. Enter the file name to view or use LookUp option like…verif… RFEI Field Types: Associated – Multi-valued field associated with other multivalued 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). RFSP Associated co-files: A list of all files that share the same key. clients.datatel.com I’m off to find the data!!