Transcript Understanding Your Data for FA

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