SAFILE: STUDENT AID FILE

ElementElement NameTableSQL Name
SAY00AWD YR YYSAPGTSAWD_YR
SA000AWD YRSAPGTSAWD_YR_CCYY
SA001STU IDSAPGTSSTU_ID
SA2CATAX FORM PARSAPGTSTAX_FORM_PAR
SA2CBEXEMPT PARSAPGTSEXEMPT_PAR
SA2CCMARITAL STAT PARSAPGTSMARITAL_STAT_PAR
SA2CDNUM HSHLD PARSAPGTSNUM_HSHLD_PAR
SA2CENUM IN COLL PARSAPGTSNUM_IN_COLL_PAR
SA2CFST RESID PARSAPGTSST_RESID_PAR
SA2CGAGE OLDER PARSAPGTSAGE_OLDER_PAR
SA2CHADJ GROSS PARSAPGTSADJ_GROSS_PAR
SA2CIINCOME FTHRSAPGTSINCOME_FTHR
SA2CJINCOME MTHRSAPGTSINCOME_MTHR
SA2CKMED/DEN EXP PARSAPGTSMEDC_EXPEN_PAR
SA2CLNUM TUIT PARSAPGTSNUM_TUIT_PAR
SA2CMTUIT FEES PARSAPGTSTUIT_FEES_PAR
SA2CNFED TAX PD PARSAPGTSFED_TAX_PD_PAR
SA2COSOC SEC BENE PARSAPGTSSOC_SEC_BENE_PAR
SA2CPAFDC PARSAPGTSAFDC_PAR
SA2CQCHILD SUPP PARSAPGTSCHILD_SUPP_PAR
SA2CROTH NTAX PARSAPGTSOTH_NTAX_PAR
SA2CSEST INCOME FTHRSAPGTSEST_INCOME_FTHR
SA2CTEST INCOME MTHRSAPGTSEST_INCOME_MTHR
SA2CUEST OTX INCOME PARSAPGTSEST_OTX_INCOME_PAR
SA2CVEST OTH NTAX PARSAPGTSEST_OTH_NTAX_PAR
SA2CWEST FED TAX PD PARSAPGTSEST_FED_TAX_PD_PAR
SA2CXCASH PARSAPGTSCASH_PAR
SA2CYHOME VAL PARSAPGTSHOME_VAL_PAR
SA2CZHOME DEBT PARSAPGTSHOME_DEBT_PAR
SA2C1PELL ID 1SAPGTSPELL_ID_1
SA2C2PELL ID 2SAPGTSPELL_ID_2
SA2C3PELL ID 3SAPGTSPELL_ID_3
SA2C4PRIM PGISAPGTSPRIM_PGI
SA2C5SCND PGISAPGTSSCND_PGI
SA2C6PL DW PSAPGTSDW_PAR
SA2C8PL DH PSAPGTSDH_PAR
SA2DAPL DW STUSAPGTSDH_STU
SA2DCTAX FORM STUSAPGTSTAX_FORM_STU
SA2DDEXEMPT STUSAPGTSEXEMPT_STU
SA2DEMARITAL STAT STUSAPGTSMARITAL_STAT_STU
SA2DFNUM HSHLD STUSAPGTSNUM_HSHLD_STU
SA2DGYR SCHL PLSAPGTSYR_SCHL
SA2DHDEGREE BY JULSAPGTSDEGREE_BY_JULY
SA2DINUM IN COLL STUSAPGTSNUM_IN_COLL_STU
SA2DJST RESID STUSAPGTSST_RESID_STU
SA2DKCITZN STATSAPGTSCITZN_STAT
SA2DLPL DOB TESTSAPGTSDOB_TEST
SA2DMPL VETSAPGTSVET
SA2DNORPHAN WARDSAPGTSORPHAN_WARD
SA2DOLEGAL DEPENSAPGTSLEGAL_DEPEN
SA2DPRCVD FED AIDSAPGTSRCVD_FED_AID
SA2DREXEMPT 88SAPGTSEXEMPT_88
SA2DTEXEMPT 89SAPGTSEXEMPT_89
SA2DVEXEMPT 90SAPGTSEXEMPT_90
SA2DXEXEMPT 91SAPGTSEXEMPT_91
SA2DZEXEMPT 92SAPGTSEXEMPT_92
SA2D0INVSMT VAL PARSAPGTSINVSMT_VAL_PAR
SA2D1INVSMT DEBT PARSAPGTSINVSMT_DEBT_PAR
SA2D2BUS ASSET PARSAPGTSBUS_ASSET_PAR
SA2D4BUS DEBT PARSAPGTSBUS_DEBT_PAR
SA2D6FARM INCL PARSAPGTSFARM_INCL_PAR
SA2D8PL DW SSAPGTSDW_STU
SA2EAINCOME 91SAPGTSINCOME_91
SA2EFSEL SEV REGISSAPGTSSEL_SEV_REGIS
SA2EGADJ GROSS STUSAPGTSADJ_GROSS_STU
SA2EHINCOME STUSAPGTSINCOME_STU
SA2EIINCOME SPOUSESAPGTSINCOME_SPOUSE
SA2EJOTH NTAX INC STUSAPGTSOTH_NTAX_INC_STU
SA2EKSOC SEC BENE STUSAPGTSSOC_SEC_BENE_STU
SA2ELAFDC STUSAPGTSAFDC_STU
SA2EMCHILD SUPP STUSAPGTSCHILD_SUPP_STU
SA2ENFED TAX PD STUSAPGTSFED_TAX_PD_STU
SA2EOMEDC EXPEN STUSAPGTSMEDC_EXPEN_STU
SA2EQNUM TUIT STUSAPGTSNUM_TUIT_STU
SA2ERTUIT FEES STUSAPGTSTUIT_FEES_STU
SA2ESVA CNTRIB AMTSAPGTSVA_CNTRIB_AMT
SA2ETVA CNTRIB MOSAPGTSVA_CNTRIB_MO
SA2EVVET BENE AMTSAPGTSVET_BENE_AMT
SA2EWVET BENE MOSAPGTSVET_BENE_MO
SA2EXEST INCOME STUSAPGTSEST_INCOME_STU
SA2EYEST INCOME SPOUSESAPGTSEST_INCOME_SPOUSE
SA2EZEST OTX INCOME STUSAPGTSEST_OTX_INCOME_STU
SA2E4INCOME 85SAPGTSINCOME_85
SA2E5INCOME 86SAPGTSINCOME_86
SA2E6INCOME 87SAPGTSINCOME_87
SA2E7INCOME 88SAPGTSINCOME_88
SA2E8INCOME 89SAPGTSINCOME_89
SA2E9INCOME 90SAPGTSINCOME_90
SA2FBBUS DEBT STUSAPGTSBUS_DEBT_STU
SA2FDFARM INCL STUSAPGTSFARM_INCL_STU
SA2FFAWD PGI INDSAPGTSAWD_PGI_IND
SA2FGPRIM FMLY CNTRIBSAPGTSPRIM_FMLY_CNTRIB
SA2FISCND FMLY CNTRIBSAPGTSSCND_FMLY_CNTRIB
SA2FKDEPEN STATSAPGTSDEPEN_STAT
SA2FLORIG APP AGNCYSAPGTSORIG_APP_AGNCY
SA2FMSEL SERV STATSAPGTSSEL_SERV_STAT
SA2FNINS STATSAPGTSINS_STAT
SA2FOTITLE IV DEFAULTSAPGTSTITLE_IV_DEFAULT
SA2FPLN DEF GRNT REF PLSAPGTSLN_DEF_GRNT_REF_PL
SA2FRDRUG ABUSE PLSAPGTSDRUG_ABUSE_PL
SA2FSUNPD STFRD TOT PLSAPGTSUNPD_STFRD_TOT_PL
SA2FTUNPD LAST STFRD PLSAPGTSUNPD_LAST_STFRD_PL
SA2FUINTEREST RATE PLSAPGTSINTEREST_RATE_PL
SA2FVTITLE IV DEF MTCHSAPGTSTITLE_IV_DEF_MTCH
SA2FWLST STFRD BEGDT PLSAPGTSLST_STFRD_BEGDT_PL
SA2FXLST STFRD ENDDT PLSAPGTSLST_STFRD_ENDDT_PL
SA2FYLST STFRD CLASS PLSAPGTSLST_STFRD_CLASS_PL
SA2F0EST OTHER NTAX STUSAPGTSEST_OTH_NTAX_STU
SA2F1EST FED TAX PD STUSAPGTSEST_FED_TAX_PD_STU
SA2F2CASH STUSAPGTSCASH_STU
SA2F3HOME VAL STUSAPGTSHOME_VAL_STU
SA2F5HOME DEBT STUSAPGTSHOME_DEBT_STU
SA2F7INVSMT VAL STUSAPGTSINVSMT_VAL_STU
SA2F8INVSMT DEBT STUSAPGTSINVSMT_DEBT_STU
SA2F9BUS ASSET STUSAPGTSBUS_ASSET_STU
SA2GASAR REVWSAPGTSSAR_REVW
SA2GBCHG STAT DTSAPGTSCHG_STAT_DT
SA2GEPELL VERF RESPSAPGTSPELL_VERF_RESP
SA2GFPELL VERF TRANSAPGTSPELL_VERF_TRAN
SA2GGPELL TUIT FEESSAPGTSPELL_TUIT_FEES
SA2GHPELL ROOM BOARDSAPGTSPELL_ROOM_BOARD
SA2GIPELL BOOKS MISCSAPGTSPELL_BOOKS_MISC
SA2GJPELL TOT BDGTSAPGTSPELL_TOT_BDGT
SA2GKENRL STAT TERM 1SAPGTSENRL_STAT_TERM_1
SA2GLENRL STAT TERM 2SAPGTSENRL_STAT_TERM_2
SA2GMENRL STAT TERM 3SAPGTSENRL_STAT_TERM_3
SA2GNENRL STAT TERM 4SAPGTSENRL_STAT_TERM_4
SA2GOENRL STAT TERM 5SAPGTSENRL_STAT_TERM_5
SA2GPENRL STAT TERM 6SAPGTSENRL_STAT_TERM_6
SA2GQPL ENRL DTSAPGTSENRL_DT
SA2GRSCHD AWD PLSAPGTSSCHD_AWD
SA2GSEXPCT DISBSAPGTSEXPCT_DISB
SA2GUPELL RPT STATSAPGTSPELL_RPT_STAT
SA2GVPELL RPT STAT DTSAPGTSPELL_RPT_STAT_DT
SA2GWPELL ACCPT TRANSAPGTSPELL_ACCPT_TRAN
SA2GXPELL ACCPT INDXSAPGTSPELL_ACCPT_INDX
SA2GYPELL ACCPT BDGTSAPGTSPELL_ACCPT_BDGT
SA2GZPELL ACCPT STATSAPGTSPELL_ACCPT_STAT
SA2G0SAR RCVDSAPGTSSAR_RCVD
SA2G1SAR SPCL CONDSAPGTSSAR_SPCL_COND
SA2G2PELL VERFSAPGTSPELL_VERF
SA2G3VERF WRKSHTSAPGTSVERF_WRKSHT
SA2G4PELL INDX DIFFSAPGTSPELL_INDX_DIFF
SA2G5OAR DTSAPGTSOAR_DT
SA2G6CHG STATSAPGTSCHG_STAT
SA2G7EDE STATSAPGTSEDE_STAT
SA2G8EDE STAT DTSAPGTSEDE_STAT_DT
SA2G9EDE REJ RSNSAPGTSEDE_REJ_RSN
SA2HAOVER REASON PLSAPGTSOVER_REASON_PL
SA2HBVERF CONFIRM PLSAPGTSVERF_CONFIRM_PL
SA2HCOVERPAY CONFIRM PLSAPGTSOVERPAY_CONFIRM_PL
SA2H0PELL ACCPT DISBSAPGTSPELL_ACCPT_DISB
SA2H1PELL REMAIN DISBSAPGTSPELL_REMAIN_DISB
SA2H2ACCPT VERF RESPSAPGTSACCPT_VERF_RESP
SA2H3REVW DTSAPGTSREVW_DT
SA2H4UNTXD TOT PARSAPGTSUNTXD_TOT_PAR
SA2H5UNTXD TOT STUSAPGTSUNTXD_TOT_STU
SA2H6OAR INTRFC DTSAPGTSOAR_INTRFC_DT
SA2H7PELL INFO SOURCESAPGTSPELL_INFO_SOURCE
SA2H8LIMIT STATUS PLSAPGTSLIMIT_STATUS_PL
SA2H9LIMIT OVER PLSAPGTSLIMIT_OVER_PL

©1999 All Rights Reserved