understanding your data for fa n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Understanding Your Data for FA PowerPoint Presentation
Download Presentation
Understanding Your Data for FA

Loading in 2 Seconds...

play fullscreen
1 / 25

Understanding Your Data for FA - PowerPoint PPT Presentation


  • 83 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Understanding Your Data for FA' - nixie


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation 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
Files Keyed on Colleague ID

Non Year Specific

File Suite – Year Specific

STUDENTS

FIN.AID

CS.ACYR

SA.ACYR

YS.ACYR

fin aid
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
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
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
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
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
File Structure: DIRECT LOANS

Exported data

DLE.DISB.SEQ

DLE.DISB.SEQ

DLI.DISB.SEQ

DLI.DISB.SEQ

Imported data

sl acyr
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 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
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
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 files1
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
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
slide21
RDEL

RDEL can be accessed directly or through drill down from RFEI.

Enter the file name to view or use LookUp option like…verif…

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

slide23
RFSP

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

slide25

Thanks for coming!!

I’m off to find the data!!