SAFILE: STUDENT AID FILE

ElementElement NameTableSQL Name
SAY00AWD YR YYSAFRTSAWD_YR
SA0XAOAR REVWR ID PARSAFRTSOAR_REVWR_ID_PAR
SA0XBOAR REVW DT PARSAFRTSOAR_REVW_DT_PAR
SA0XCREVW IND PARSAFRTSREVW_IND_PAR
SA0XDOAR REVWR ID STUSAFRTSOAR_REVWR_ID_STU
SA0XEOAR REVW DT STUSAFRTSOAR_REVW_DT_STU
SA0XFREVW IND STUSAFRTSREVW_IND_STU
SA0XGVERF RQRDSAFRTSVERF_RQRD
SA0XHCNTRIB OVRDSAFRTSCNTRIB_OVRD
SA0XISTU STAT VERF RQSTSAFRTSSTU_STAT_VERF_RQST
SA0XJINAS PELL CALCSAFRTSINAS_PELL_CALC
SA0XKINAS CALC FLAGSAFRTSINAS_CALC_FLAG
SA0XMFR DW PARSAFRTSDW_PAR
SA0XOFR DH PARSAFRTSDH_PAR
SA0XQFR TAX FORM PARSAFRTSTAX_FORM_PAR
SA0XRFR EXEMPT PARSAFRTSEXEMPT_PAR
SA0XSFR MARITAL PARSAFRTSMARITAL_STAT_PAR
SA0XTDIVR SEPR PAR INFOSAFRTSDIVR_SEPR_PAR_INFO
SA0XUFR NUM HSHLD PARSAFRTSNUM_HSHLD_PAR
SA0XVFR NUM IN COLL PARSAFRTSNUM_IN_COLL_PAR
SA0XWPAR IN COLLSAFRTSPAR_IN_COLL
SA0XXFR ST RESID PARSAFRTSST_RESID_PAR
SA0XYFR AGE OLDER PARSAFRTSAGE_OLDER_PAR
SA0XZRPTD PAR CNTRIBSAFRTSRPTD_PAR_CNTRIB
SA0X0REC TYPSAFRTSREC_TYP
SA0X2MTHD CHOICE PCSAFRTSMTHD_CHOICE_PC
SA0X4MTHD CHOICE SCSAFRTSMTHD_CHOICE_SC
SA0X6CALC TYPSAFRTSCALC_TYP
SA0X7CALC CHOICESAFRTSCALC_CHOICE
SA0X8PROC RCVD FORM DTSAFRTSPROC_RCVD_FORM_DT
SA0X9FR OAR INTRFC DTSAFRTSOAR_INTRFC_DT
SA0YAOTX INCOME PARSAFRTSOTX_INCOME_PAR
SA0YBADJ INCOME PARSAFRTSADJ_INCOME_PAR
SA0YCFR MEDC EXPEN PARSAFRTSMEDC_EXPEN_PAR
SA0YDFR NUM TUIT PARSAFRTSNUM_TUIT_PAR
SA0YEFR TUIT FEES PARSAFRTSTUIT_FEES_PAR
SA0YFITMZ DEDUCT PARSAFRTSITMZ_DEDUCT_PAR
SA0YHFR FED TAX PD PARSAFRTSFED_TAX_PD_PAR
SA0YIFR SOC SEC BEN PARSAFRTSSOC_SEC_BENE_PAR
SA0YJFR AFDC PARSAFRTSAFDC_PAR
SA0YKFR CHILD SUPP PARSAFRTSCHILD_SUPP_PAR
SA0YLOTH BENE PARSAFRTSOTH_BENE_PAR
SA0YMFR EST INC FTHRSAFRTSEST_INCOME_FTHR
SA0YNFR EST INC MTHESAFRTSEST_INCOME_MTHR
SA0YOFR EST OTX PARSAFRTSEST_OTX_INCOME_PAR
SA0YPFR EST OTH NTAX PARSAFRTSEST_OTH_NTAX_PAR
SA0YQIRA PARSAFRTSIRA_PAR
SA0YRFR ST TAX PD PARSAFRTSST_TAX_PD_PAR
SA0YSWORK EXCLU PARSAFRTSWORK_EXCLU_PAR
SA0YTEST AJD GROSS PARSAFRTSEST_AJD_GROSS_PAR
SA0YVEST INT INCOME PARSAFRTSEST_INT_INCOME_PAR
SA0YWEST DIVD INC PARSAFRTSEST_DIVD_INC_PAR
SA0YXEST BUS INCOME PARSAFRTSEST_BUS_INCOME_PAR
SA0YYEST IRA PARSAFRTSEST_IRA_PAR
SA0YZEST SOC SEC PARSAFRTSEST_SOC_SEC_PAR
SA0Y0PROJ PAR CNTRIBSAFRTSPROJ_PAR_CNTRIB
SA0Y1INAS USE EST PARSAFRTSINAS_USE_EST_PAR
SA0Y2FED INCOME PARSAFRTSFED_INCOME_PAR
SA0Y3FR ADJ GROSS PARSAFRTSADJ_GROSS_PAR
SA0Y4FR WAGES PARSAFRTSWAGES_PAR
SA0Y5FR INCOME FATHSAFRTSINCOME_FTHR
SA0Y6FR INCOME MOTHSAFRTSINCOME_MTHR
SA0Y7INT INCOME PARSAFRTSINT_INCOME_PAR
SA0Y8FR DIVD INCOME PARSAFRTSDIVD_INCOME_PAR
SA0Y9NET BUS INCOME PARSAFRTSNET_BUS_INCOME_PAR
SA0ZAINVSTMT DEBT PARSAFRTSINVSTMT_DEBT_PAR
SA0ZBFR BUS ASSET PARSAFRTSBUS_ASSET_PAR
SA0ZDFR BUS DEBT PARSAFRTSBUS_DEBT_PAR
SA0ZFBUS FARM SUPL PARSAFRTSBUS_FARM_SUPL_PAR
SA0ZGFR FARM INCL PARSAFRTSFARM_INCL_PAR
SA0ZJFR DW STUSAFRTSDW_STU
SA0ZLFR DH STUSAFRTSDH_STU
SA0ZNFR TAX FORM STUSAFRTSTAX_FORM_STU
SA0ZOFR EXEMPT STUSAFRTSEXEMPT_STU
SA0ZPFR MARITAL STUSAFRTSMARITAL_STAT_STU
SA0ZQMARR DT STUSAFRTSMARR_DT_STU
SA0ZSFR NUM HSHLD STUSAFRTSNUM_HSHLD_STU
SA0ZTFR YR SCHOOLSAFRTSYR_SCHL
SA0ZVDEGREE BY JULYSAFRTSDEGREE_BY_JULY
SA0ZWYR DEGREE EXPCTSAFRTSYR_DEGREE_EXPCT
SA0ZXFR NUM IN COLL STUSAFRTSNUM_IN_COLL_STU
SA0ZYFR ST RESID STUSAFRTSST_RESID_STU
SA0ZZFR CITZN STATSAFRTSCITZN_STAT
SA0Z0EST AFDC PARSAFRTSEST_AFDC_PAR
SA0Z2FR CASH PARSAFRTSCASH_PAR
SA0Z3FR HOME VAL PARSAFRTSHOME_VAL_PAR
SA0Z4FR HOME DEBT PARSAFRTSHOME_DEBT_PAR
SA0Z5HOME PRCH YR PARSAFRTSHOME_PRCH_YR_PAR
SA0Z6HOME PRCH PRC PARSAFRTSHOME_PRCH_PRC_PAR
SA0Z7OTH RE VAL PARSAFRTSOTH_RE_VAL_PAR
SA0Z8OTH RE DEBT PARSAFRTSOTH_RE_DEBT_PAR
SA0Z9INVSTMT VAL PARSAFRTSINVSTMT_VAL_PAR
SA000AWD YRSAFRTSAWD_YR_CCYY
SA001STU IDSAFRTSSTU_ID
SA10AFMLY MEMB ATTND 1SAFRTSFMLY_MEMB_ATTND_1
SA10BFMLY MEMB ATTND 2SAFRTSFMLY_MEMB_ATTND_2
SA10CFMLY MEMB ATTND 3SAFRTSFMLY_MEMB_ATTND_3
SA10DFMLY MEMB ATTND 4SAFRTSFMLY_MEMB_ATTND_4
SA10EFMLY MEMB ATTND 5SAFRTSFMLY_MEMB_ATTND_5
SA10FFMLY MEMB ATTND 6SAFRTSFMLY_MEMB_ATTND_6
SA10GFMLY MEMB ATTND 7SAFRTSFMLY_MEMB_ATTND_7
SA10HAPP START DTSAFRTSAPP_START_DT
SA10IAPP END DTSAFRTSAPP_END_DT
SA10JSELF HELP AIDSAFRTSSELF_HELP_AID
SA10KEXPCT HOUS BDGTSAFRTSEXPCT_HOUS_BDGT
SA10LFR ENRL STSTSAFRTSENRL_STAT
SA10MGRAD DTSAFRTSGRAD_DT
SA10NNAF MAJORSAFRTSNAF_MAJOR
SA10ODEGREE OBJSAFRTSDEGREE_OBJ
SA10PLN DEF GRNT REF FRSAFRTSLN_DEF_GRNT_REF_FR
SA10RNUM POST SCNDSAFRTSNUM_POST_SCND
SA10SPREV INSTITUTION 1SAFRTSPREV_INSTITUTION_1
SA10TPREV INSTITUTION 2SAFRTSPREV_INSTITUTION_2
SA10UPREV INSTITUTION 3SAFRTSPREV_INSTITUTION_3
SA10VLEGAL RESID DTSAFRTSLEGAL_RESID_DT
SA10XDOB TESTSAFRTSDOB_TEST
SA10YFR VETSAFRTSVET
SA10ZFR ORPHAN WARDSAFRTSORPHAN_WARD
SA101FR RLTNSHP 1SAFRTSRLTNSHP_1
SA102FR RLTNSHP 2SAFRTSRLTNSHP_2
SA103FR RLTNSHP 3SAFRTSRLTNSHP_3
SA104FR RLTNSHP 4SAFRTSRLTNSHP_4
SA105FR RLTNSHP 5SAFRTSRLTNSHP_5
SA106FR RLTNSHP 6SAFRTSRLTNSHP_6
SA107FR RLTNSHP 7SAFRTSRLTNSHP_7
SA108EIGHT MEMBSAFRTSEIGHT_MEMB
SA11AFR EXEMPT 88SAFRTSEXEMPT_88
SA11BFR EXEMPT 89SAFRTSEXEMPT_89
SA11CFR EXEMPT 90SAFRTSEXEMPT_90
SA11DFR EXEMPT 91SAFRTSEXEMPT_91
SA11EFR EXEMPT 92SAFRTSEXEMPT_92
SA11KFR INCOME 85SAFRTSINCOME_85
SA11MFR INCOME 86SAFRTSINCOME_86
SA11OFR INCOME 87SAFRTSINCOME_87
SA11QFR INCOME 88SAFRTSINCOME_88
SA11SFR INCOME 89SAFRTSINCOME_89
SA11TFR INCOME 90SAFRTSINCOME_90
SA11UFR INCOME 91SAFRTSINCOME_91
SA11WNUM DEPEN STUSAFRTSNUM_DEPEN_STU
SA11YSPOUSE ATTNDSAFRTSSPOUSE_ATTND
SA110FR LEGAL DEPENSAFRTSLEGAL_DEPEN
SA111FR RCVD AID 88SAFRTSRCVD_FED_AID_88
SA112EXEMPT 85SAFRTSEXEMPT_85
SA118EXEMPT 86SAFRTSEXEMPT_86
SA119EXEMPT 87SAFRTSEXEMPT_87
SA12AFR OTH NTAX STUSAFRTSOTH_NTAX_INC_STU
SA12BFR SOC SEC BEN STUSAFRTSSOC_SEC_BENE_STU
SA12CFR AFDC STUSAFRTSAFDC_STU
SA12DFR CHILD SUPP STUSAFRTSCHILD_SUPP_STU
SA12EFR FED TAX PD STUSAFRTSFED_TAX_PD_STU
SA12FITMZ DEDUCT STUSAFRTSITMZ_DEDUCT_STU
SA12IFR MED EXPEN STUSAFRTSMEDC_EXPEN_STU
SA12JFR NUM TUIT STUSAFRTSNUM_TUIT_STU
SA12KFR TUIT FEES STUSAFRTSTUIT_FEES_STU
SA12LEST SUMR INCOMESAFRTSEST_SUMR_INCOME
SA12MEST ACAD YR INCOMESAFRTSEST_ACAD_YR_INCOME
SA12NSPOUSE SUMR INCOMESAFRTSSPOUSE_SUMR_INCOME
SA12OSPOUSE ACAD YR INCSAFRTSSPOUSE_ACAD_YR_INC
SA12POTX SUMR INCOMESAFRTSOTX_SUMR_INCOME
SA12QOTX ACAD YR INCOMESAFRTSOTX_ACAD_YR_INCOME
SA12RNTAX SUMR INCOMESAFRTSNTAX_SUMR_INCOME
SA12SNTAX ACAD YR INCSAFRTSNTAX_ACAD_YR_INC
SA12TFR VA CONTRIB AMTSAFRTSVA_CNTRIB_AMT
SA12VFR VA CONTRIB MOSAFRTSVA_CNTRIB_MO
SA12XFR VET BENE AMTSAFRTSVET_BENE_AMT
SA12YFR VET BENE MOSAFRTSVET_BENE_MO
SA12ZSUMR EXPEN STU SPSSAFRTSSUMR_EXPEN_STU_SPS
SA120SPOUSE A STUSAFRTSSPOUSE_A_STU
SA122STU CONT EMPLRSAFRTSSTU_CONT_EMPLR
SA123SPOUSE CONT EMPLRSAFRTSSPOUSE_CONT_EMPLR
SA124SEL SERV REGISSAFRTSSEL_SERV_REGIS
SA125INAS USE EST STUSAFRTSINAS_USE_EST_STU
SA126FED INCOME STUSAFRTSFED_INCOME_STU
SA127FR ADJ GROSS STUSAFRTSADJ_GROSS_STU
SA128FR INCOME STUSAFRTSINCOME_STU
SA129FR INCOME SPOUSESAFRTSINCOME_SPOUSE
SA13ADEPEN STU SAVSAFRTSDEPEN_STU_SAV
SA13CDEPEN STU NTAXSAFRTSDEPEN_STU_NTAX
SA13DDEPEN STU TAX PDSAFRTSDEPEN_STU_TAX_PD
SA13EFR OTH INC STUSAFRTSOTH_INCOME_STU
SA13FOTH MO STUSAFRTSOTH_MO_STU
SA13HFR CASH STUSAFRTSCASH_STU
SA13IHOME VALU STUSAFRTSHOME_VALU_STU
SA13JFR HOME DEBT STUSAFRTSHOME_DEBT_STU
SA13KINVSTMT VAL STUSAFRTSINVSTMT_VAL_STU
SA13LINVSTMT DEBT STUSAFRTSINVSTMT_DEBT_STU
SA13MFR BUS ASSET STUSAFRTSBUS_ASSET_STU
SA13OFR BUS DEBT STUSAFRTSBUS_DEBT_STU
SA13QBUS FARM SUPL STUSAFRTSBUS_FARM_SUPL_STU
SA13RFR FARM INCL STUSAFRTSFARM_INCL_STU
SA13TGSL RQSTSAFRTSGSL_RQST
SA13UGSL UNPD FISC FRSAFRTSGSL_UNPD_FISC
SA13VGSL UNPD LAST FRSAFRTSGSL_UNPD_LAST
SA13WGSL INT RATE FRSAFRTSGSL_INT_RATE
SA13XGSL LST BEG DT FRSAFRTSGSL_LAST_BEGIN_DT
SA13YGSL LST END DT FRSAFRTSGSL_LAST_END_DT
SA13ZGSL LST CLASS FRSAFRTSGSL_LAST_CLASS
SA130SUMR EXPEN SPOUSESAFRTSSUMR_EXPEN_SPOUSE
SA131FR EST INC STUSAFRTSEST_INCOME_STU
SA132FR EST INC SPSSAFRTSEST_INCOME_SPOUSE
SA133FR EST OTX STUSAFRTSEST_OTX_INCOME_STU
SA134EST OTH NTAX STUSAFRTSEST_OTH_NTAX_STU
SA135FR ST TAX PD STUSAFRTSST_TAX_PD_STU
SA137WORK EXCLU STUSAFRTSWORK_EXCLU_STU
SA138DEPEN STU BENESAFRTSDEPEN_STU_BENE
SA14AMSG 9SAFRTSMSG_9
SA14BOAR MSG 10SAFRTSMSG_10
SA14CMSG 11SAFRTSMSG_11
SA14DMSG 12SAFRTSMSG_12
SA14EMSG 13SAFRTSMSG_13
SA14FMSG 14SAFRTSMSG_14
SA14GMSG 15SAFRTSMSG_15
SA14HMSG 16SAFRTSMSG_16
SA14IMSG 17SAFRTSMSG_17
SA14JMSG 18SAFRTSMSG_18
SA14KMSG 19SAFRTSMSG_19
SA14LMSG 20SAFRTSMSG_20
SA14MMSG 21SAFRTSMSG_21
SA14NMSG 22SAFRTSMSG_22
SA14OMSG 23SAFRTSMSG_23
SA14PMSG 24SAFRTSMSG_24
SA14QMSG 25SAFRTSMSG_25
SA14RMSG 26SAFRTSMSG_26
SA14SMSG 27SAFRTSMSG_27
SA14TMSG 28SAFRTSMSG_28
SA14UMSG 29SAFRTSMSG_29
SA14VMSG 30SAFRTSMSG_30
SA14XDEPEN OVRDSAFRTSDEPEN_OVRD
SA14YDEPEN OVRD RSNSAFRTSDEPEN_OVRD_RSN
SA14ZBDGT DUR OVRD INASSAFRTSBDGT_DUR_OVRD_INAS
SA140GSL RQST AMT FRSAFRTSGSL_RQST_AMT
SA142OAR MSG 1SAFRTSMSG_1
SA143OAR MSG 2SAFRTSMSG_2
SA144FR MSG 3SAFRTSMSG_3
SA145MSG 4SAFRTSMSG_4
SA146MSG 5SAFRTSMSG_5
SA147MSG 6SAFRTSMSG_6
SA148MSG 7SAFRTSMSG_7
SA149MSG 8SAFRTSMSG_8
SA15AFICA OVRD STUSAFRTSFICA_OVRD_STU
SA15BHOME EQTY OVRD PARSAFRTSHOME_EQTY_OVRD_PAR
SA15CINVSTMT OVRD PARSAFRTSINVSTMT_OVRD_PAR
SA15DSUMR SAV OVRDSAFRTSSUMR_SAV_OVRD
SA15EFED TAX OVRD PARSAFRTSFED_TAX_OVRD_PAR
SA15FFED TAX OVRD STUSAFRTSFED_TAX_OVRD_STU
SA15GCPS OFFCLSAFRTSCPS_OFFCL
SA151PL OVRD PAR CNTRIBSAFRTSPL_OVRD_PAR_CNTRIB
SA152PL OVRD STU CNTRIBSAFRTSPL_OVRD_STU_CNTRIB
SA154SMA INDX OVRDSAFRTSSMA_INDX_OVRD
SA155EMPLM OVRD PARSAFRTSEMPLM_OVRD_PAR
SA156EMPLM OVRD STUSAFRTSEMPLM_OVRD_STU
SA157ST TAX PD OVRD PARSAFRTSST_TAX_PD_OVRD_PAR
SA158ST TAX PD OVRD STUSAFRTSST_TAX_PD_OVRD_STU
SA159FICA OVRD PARSAFRTSFICA_OVRD_PAR

©1999 All Rights Reserved