1 / 25

Understanding Your Data for FA

This guide provides an in-depth understanding of financial aid data structures at Forsyth Technical Community College, detailing both year-specific and non-year-specific file suites. It outlines key data points including student identifiers, financial aid results, award information, disbursement details, and demographic data captured from FAFSA. The document assists systems analysts, educators, and administrative staff in navigating the complexities of financial aid data management and provides pointers to essential tables and data fields.

nixie
Télécharger la présentation

Understanding Your Data for FA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Understanding Your Data for FA Jodi M. Dyson, CIS Systems Analyst Forsyth Technical Community College

  2. Just give me the #!*&% data!!

  3. Files Keyed on Colleague ID Non Year Specific File Suite – Year Specific STUDENTS FIN.AID CS.ACYR SA.ACYR YS.ACYR

  4. FFSP-File suites created annually

  5. FILE STRUCTURE

  6. 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

  7. 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

  8. Annual vs. Term

  9. 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

  10. 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

  11. YS.ACYR Contains Misc. FA Fields and the FILE COMPLETE DATE • YS.FILE.COMPLETE.DT • YS.DECISION • YS.MISC 1-5 Yearly ‘stuff’

  12. File Structure: DIRECT LOANS Exported data DLE.DISB.SEQ DLE.DISB.SEQ DLI.DISB.SEQ DLI.DISB.SEQ Imported data

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. FIELD HELP (really is a BIG help)

  20. RDEL RDEL can be accessed directly or through drill down from RFEI. Enter the file name to view or use LookUp option like…verif…

  21. 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).

  22. RFSP Associated co-files: A list of all files that share the same key.

  23. clients.datatel.com

  24. Thanks for coming!! I’m off to find the data!!

More Related