250 likes | 385 Views
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.
E N D
Understanding Your Data for FA Jodi M. Dyson, CIS Systems Analyst Forsyth Technical Community College
Files Keyed on Colleague ID Non Year Specific File Suite – Year Specific STUDENTS FIN.AID CS.ACYR SA.ACYR YS.ACYR
FIN.AID Common items • 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 Calc summary
SA.ACYR Annual Award Information (AIDE) • SA.AWARD • SA.AMOUNT • SA.ACTION • SA.DATE • SA.XMIT.AMT • SA.PELL.ENTITLEMENT • SA.AWARDED • SA.ACCEPTED Summary Award
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 Term Award
YS.ACYR Contains Misc. FA Fields and the FILE COMPLETE DATE • YS.FILE.COMPLETE.DT • YS.DECISION • YS.MISC 1-5 Yearly ‘stuff’
File Structure: DIRECT LOANS Exported data DLE.DISB.SEQ DLE.DISB.SEQ DLI.DISB.SEQ DLI.DISB.SEQ Imported data
SL.ACYR Summary loan data, such as specific loan amount and disbursement dates • SL.STUDENT.ID • SL.ORIG.READY.TO.SEND • SL.ANT.DISB.TERM • SL.ANT.DISB.DATE • SL.ANT.DISB.AMT • SL.SCHOOL.CODE • SL.REPORTING/ATTENDING.CAMPUS Student loan
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 Isir.fafsa • IFAF.STUDENT.ID • IFAF.IMPORT.YEAR • IFAF.TRANS.NBR • IFAF.READY.TO.SEND • IFAF…(all the FAFSA answers) • IRES.TRANS.NBR • IRES.RECEIPT.DT • IRES.COMMENT.CODES • IRES.SAR.C.FLAG • IRES.CPS.PELL.ELIG Isir.calc.results Isir.results • ICRES.REJECT CODES • ICRES.AZE.IND • ICRES.PRI.EFC • ISIR.CALC.RESULTS.CHGDATE • ICRES.PRI.TI
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
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 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).
RFSP Associated co-files: A list of all files that share the same key.
Thanks for coming!! I’m off to find the data!!