DM-FinancialAid
Financial Aid Data Mart (DM-FinancialAid)
About the Financial Aid Data Mart
The DM-FinancialAid data mart serves as a reporting center for the Financia Aid department
DM-FinancialAid Tables
secure.IsirNslds
Description: NSLDS summary data from the ISIR.
Grain: One row per NSLDS summary record.
Primary key: ISIR_NSLDS_ID
|
Column |
Description |
|---|---|
|
ISIR_NSLDS_ID |
NSLDS summary record ID |
|
COLLEAGUE_RPID |
Colleague person ID |
|
INSD_TRANS_NO |
NSLDS transaction number |
|
INSD_TYPE |
NSLDS record type |
|
INSD_PROCESSED_DATE |
NSLDS processed date |
|
INSD_SUB_USE_LMT_APPLIES |
Subsidized usage limit applies flag |
|
INSD_SUB_ELIG_PCT_USED |
Subsidized eligibility percent used |
|
INSD_PELL_LIFE_PCT_USED |
Lifetime Pell percent used |
|
INSD_UG_AG_SUB_TOTAL |
Undergraduate aggregate subsidized total |
|
INSD_UG_AG_UNSUB_TOTAL |
Undergraduate aggregate unsubsidized total |
|
INSD_UG_AG_COMB_TOTAL |
Undergraduate aggregate combined total |
|
INSD_GR_AG_SUB_TOTAL |
Graduate aggregate subsidized total |
|
INSD_GR_AG_UNSUB_TOTAL |
Graduate aggregate unsubsidized total |
|
INSD_GR_AG_COMB_TOTAL |
Graduate aggregate combined total |
|
INSD_AG_SUB_TOTAL |
Aggregate subsidized total |
|
INSD_AG_UNSUB_TOTAL |
Aggregate unsubsidized total |
|
INSD_AG_COMB_TOTAL |
Aggregate combined total |
|
INSD_DEFAULTED_FLAG |
Defaulted loan flag |
|
INSD_OVERPAY_CHG_FLAG |
Overpayment change flag |
|
INSD_LOAN_LIM_EXCEPT_FLAG |
Loan limit exception flag |
|
INSD_DISB_DATE_FLAG |
Disbursement date flag |
|
INSD_AG_PR_PLUS_LOAN_TOTAL |
Parent PLUS aggregate loan total |
|
INSD_LIFE_MAX_LOAN_TOTAL |
Lifetime maximum loan total |
|
INSD_GRAD_COMB_LIMIT_IND |
Graduate combined limit indicator |
|
INSD_PROF_COMB_LIMIT_IND |
Professional combined limit indicator |
|
INSD_PAR_PLUS_LIMIT_IND |
Parent PLUS limit indicator |
|
INSD_MAX_LIFE_LIMIT_IND |
Maximum lifetime limit indicator |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
secure.IsirNsldsDetail
Description: NSLDS loan, grant, and Pell detail lines from the ISIR.
Grain: One row per NSLDS detail line.
Primary key: DetailKey, DetailType
|
Column |
Description |
|---|---|
|
DetailKey |
Unique detail line identifier |
|
DetailType |
Detail category: LOAN, GRANT, or PELL |
|
ISIR_NSLDS_ID |
NSLDS summary record ID |
|
COLLEAGUE_RPID |
Colleague person ID |
|
SequenceNo |
NSLDS sequence number |
|
SchoolCode |
School code |
|
ProgramCode |
Loan program code |
|
AwardYear |
Award year |
|
GradeLevel |
Grade level |
|
CurrentStatusCode |
Current loan status code |
|
CurrentStatusDate |
Current loan status date |
|
NetAmount |
Net loan amount |
|
TotalDisburseAmount |
Total disbursement amount |
|
LastDisburseAmount |
Last disbursement amount |
|
LastDisburseDate |
Last disbursement date |
|
OutstandingPrincipalBalance |
Outstanding principal balance |
|
PercentUsed |
Percent used (grant/Pell) |
|
AwardAmount |
Award amount (grant/Pell) |
|
PaidAmount |
Paid amount (grant/Pell) |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
secure.PersonFilters
Description: Person match keys for restricted FA filter reports.
Grain: One row per Colleague person.
Primary key: COLLEAGUE_RPID
|
Column |
Description |
|---|---|
|
COLLEAGUE_RPID |
Colleague person ID |
|
FirstName |
First name |
|
LastName |
Last name |
|
BirthDate |
Date of birth |
|
SSN |
Social Security Number |
secure.StudentTypes
Description: Student type assignment history.
Grain: One row per person and sequence position.
Primary key: COLLEAGUE_RPID, Ordering
|
Column |
Description |
|---|---|
|
COLLEAGUE_RPID |
Colleague person ID |
|
Ordering |
Sequence position |
|
StudentTypeDate |
Student type effective date |
|
StudentType |
Student type code |
dbo.StudentFinancialAid
Description: Term-level financial aid awards and package context.
Grain: One row per TA ACYR record (TA_ID and FA_YEAR).
Primary key: RecordKey
|
Column |
Description |
|---|---|
|
RecordKey |
Unique record key (TA_ID and FA_YEAR) |
|
COLLEAGUE_RPID |
Colleague person ID |
|
FA_YEAR |
Financial aid award year |
|
AWARD_ID |
Award code |
|
TERM_ID |
Term code |
|
TA_TERM_ACTION |
Term action code |
|
TA_TERM_AMOUNT |
Term award amount |
|
TA_TERM_XMIT_AMT |
Transmitted amount |
|
TA_TERM_UNXMIT_AMT |
Untransmitted amount |
|
TA_TERM_LOAN_FEES |
Term loan fees |
|
TA_TERM_MANUAL_CHG |
Term manual change flag |
|
TA_ELIG_FLAG |
Eligibility flag |
|
TA_XMIT_FLAG |
Transmittal flag |
|
TA_TERM_PRIORITY |
Term award priority |
|
TA_INIT_DISB_DT |
Initial disbursement date |
|
TA_TERM_XMIT_DT |
Transmittal date |
|
FA_GFATHERD_LOAN_PROG |
Grandfathered loan program code |
|
CS_FED_ISIR_ID |
Federal ISIR ID |
|
CS_NEED |
Calculated need |
|
CS_INST_TOTAL_EXPENSES |
Institutional total expenses |
|
CS_PKG_ATP_CODE |
Packaging ATP code |
|
CS_PKG_UNMET_CB_NEED |
Unmet campus-based need |
|
CS_PKG_UNMET_INST_NEED |
Unmet institutional need |
|
CS_STD_TOTAL_EXPENSES |
Student total expenses |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
dbo.StudentLoan
Description: Student loan header from SL ACYR.
Grain: One row per SL ACYR record (SL_ID and FA_YEAR).
Primary key: SL_ID, FA_YEAR
|
Column |
Description |
|---|---|
|
SL_ID |
Student loan ACYR ID |
|
COLLEAGUE_RPID |
Colleague person ID |
|
FA_YEAR |
Financial aid award year |
|
AWARD_ID |
Award code |
|
SL_LOAN_ID |
Colleague loan ID |
|
SL_LOAN_AMOUNT |
Loan amount |
|
SL_LOAN_FEES |
Loan fees |
|
SL_INTEREST_RATE |
Interest rate |
|
SL_LENDER_ID |
Lender ID |
|
SL_DL_LOAN_ID |
Direct Loan ID |
|
SL_ENRL_STATUS |
Enrollment status |
|
SL_IN_DEFAULT |
Default indicator |
|
SL_TOTAL_ANT_DISB_AMT |
Total anticipated disbursement amount |
|
SL_TOTAL_ACT_DISB_AMT |
Total actual disbursement amount |
|
SL_ACAD_YEAR_START_DATE |
Academic year start date |
|
SL_ACAD_YEAR_END_DATE |
Academic year end date |
|
SL_ORIG_SENT_DT |
Original certification sent date |
|
SL_CHG_SENT_DT |
Change sent date |
|
SL_PGM_COMP_DT |
Program completion date |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
dbo.StudentLoanDisbursement
Description: Student loan disbursement detail.
Grain: One row per loan disbursement line (SL_ID, FA_YEAR, and position).
Primary key: RecordKey
|
Column |
Description |
|---|---|
|
RecordKey |
Unique record key (SL_ID, FA_YEAR, and position) |
|
SL_ID |
Student loan ACYR ID |
|
DisbursementPos |
Disbursement position |
|
COLLEAGUE_RPID |
Colleague person ID |
|
FA_YEAR |
Financial aid award year |
|
SL_ANT_DISB_DATE |
Anticipated disbursement date |
|
SL_ANT_DISB_AMT |
Anticipated disbursement amount |
|
SL_ANT_DISB_TERM |
Anticipated disbursement term |
|
SL_ACT_DISB_DT |
Actual disbursement date |
|
SL_ACT_DISB_AMT |
Actual disbursement amount |
|
SL_INIT_DISB_DT |
Initial disbursement date |
|
SL_DISB_CNCL_DT |
Disbursement cancel date |
|
SL_ACT_ENRL_INTENSITY |
Actual enrollment intensity |
|
SL_ACT_DISB_CREDITS |
Actual disbursement credits |
|
SL_ROSTER_AMT_OVERRIDE |
Roster amount override |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
dbo.FinAidSupplemental
Description: Supplemental financial aid records (SAP, interview, transmittal, roster, and related).
Grain: One row per supplemental record.
Primary key: RecordType, RecordKey
|
Column |
Description |
|---|---|
|
RecordType |
Record category (SAP_RESULT, SAP_APPEAL, FA_INTERVIEW, FA_TRANSMITTAL, WITHDRAW_STATUS, FA_AUTH, LOAN_ROSTER) |
|
RecordKey |
Unique record identifier |
|
COLLEAGUE_RPID |
Colleague person ID |
|
FA_YEAR |
Financial aid award year |
|
TERM_ID |
Term code |
|
AWARD_ID |
Award or loan code |
|
StatusCode |
Status code |
|
StatusDescription |
Status description |
|
Amount |
Primary amount |
|
Amount2 |
Secondary amount |
|
Date1 |
Primary date |
|
Date2 |
Secondary date |
|
Date3 |
Tertiary date |
|
Text1 |
Primary text value |
|
Text2 |
Secondary text value |
|
Comment |
Comment or remarks |
|
ChangeDate |
Source record last change date |
|
LoadDate |
Date loaded into DM-FinancialAid |
secure.Fafsa
Description: ISIR/FAFSA application data from Colleague.
Grain: One row per ISIR FAFSA transaction.
Primary key: IFAF_ID
|
Column |
Description |
|---|---|
|
IFAF_ID |
FAFSA transaction ID |
|
COLLEAGUE_RPID |
Colleague person ID |
|
CORRECTED_FAFSA |
Corrected FAFSA transaction ID |
|
IFAF_ADD_DATE |
Ifaf add date |
|
IFAF_ADDITIONAL_LOAN_FLAG |
Ifaf additional loan flag |
|
IFAF_ADDITIONAL_UNSUB_FLAG |
Ifaf additional unsub flag |
|
IFAF_AG_COMBINED_CALC_AMOUNT |
Ifaf ag combined calc amount |
|
IFAF_AGGREGATE_CHANGE_FLAG |
Ifaf aggregate change flag |
|
IFAF_APPL_SOURCE |
Ifaf appl source |
|
IFAF_ASSM_P_ASSET_THD_EXC |
Ifaf assm p asset thd exc |
|
IFAF_ASSM_S_ASSET_THD_EXC |
Ifaf assm s asset thd exc |
|
IFAF_AZE |
Ifaf aze |
|
IFAF_BIRTHDATE |
Ifaf birthdate |
|
IFAF_COMMENT_CODES |
Ifaf comment codes |
|
IFAF_CORRECTION_SENT_DATE |
Ifaf correction sent date |
|
IFAF_CORRECTION_STATUS |
Ifaf correction status |
|
IFAF_CPS_PELL_ELIG |
Ifaf cps pell elig |
|
IFAF_CURR_SSN |
Ifaf curr ssn |
|
IFAF_DEGREE_BY_JULY_FLAG |
Ifaf degree by july flag |
|
IFAF_DEGREE_OR_CERTIFICATE |
Ifaf degree or certificate |
|
IFAF_DEPENDENCY |
Ifaf dependency |
|
IFAF_DRIVER_LICENSE_NUMBER |
Ifaf driver license number |
|
IFAF_DRIVER_LICENSE_STATE |
Ifaf driver license state |
|
IFAF_FAA_ADJUSTMENT_FLAG |
Ifaf faa adjustment flag |
|
IFAF_FALLEN_HERO_IND |
Ifaf fallen hero ind |
|
IFAF_FATHER_DOB |
Ifaf father dob |
|
IFAF_FPS_CORR_REASON |
Ifaf fps corr reason |
|
IFAF_GRADUATE_PROGRAM_FLAG |
Ifaf graduate program flag |
|
IFAF_HS_CITY |
Ifaf hs city |
|
IFAF_HS_CODE |
Ifaf hs code |
|
IFAF_HS_GRAD_TYPE |
Ifaf hs grad type |
|
IFAF_HS_NAME |
Ifaf hs name |
|
IFAF_HS_STATE |
Ifaf hs state |
|
IFAF_IDEM_ADDR |
Ifaf idem addr |
|
IFAF_IDEM_CITY |
Ifaf idem city |
|
IFAF_IDEM_OTHER_P_ADDR |
Ifaf idem other p addr |
|
IFAF_IDEM_OTHER_P_BIRTHDATE |
Ifaf idem other p birthdate |
|
IFAF_IDEM_OTHER_P_CITY |
Ifaf idem other p city |
|
IFAF_IDEM_OTHER_P_COUNTRY |
Ifaf idem other p country |
|
IFAF_IDEM_OTHER_P_ITIN |
Ifaf idem other p itin |
|
IFAF_IDEM_OTHER_P_NAME_FIRST |
Ifaf idem other p name first |
|
IFAF_IDEM_OTHER_P_NAME_LAST |
Ifaf idem other p name last |
|
IFAF_IDEM_OTHER_P_NAME_MI |
Ifaf idem other p name mi |
|
IFAF_IDEM_OTHER_P_SSN |
Ifaf idem other p ssn |
|
IFAF_IDEM_OTHER_P_STATE |
Ifaf idem other p state |
|
IFAF_IDEM_OTHER_P_ZIP |
Ifaf idem other p zip |
|
IFAF_IDEM_P_ADDR |
Ifaf idem p addr |
|
IFAF_IDEM_P_CITY |
Ifaf idem p city |
|
IFAF_IDEM_P_COUNTRY |
Ifaf idem p country |
|
IFAF_IDEM_P_ITIN |
Ifaf idem p itin |
|
IFAF_IDEM_P_NAME_FIRST |
Ifaf idem p name first |
|
IFAF_IDEM_P_NAME_LAST |
Ifaf idem p name last |
|
IFAF_IDEM_P_NAME_MI |
Ifaf idem p name mi |
|
IFAF_IDEM_P_SSN |
Ifaf idem p ssn |
|
IFAF_IDEM_P_STATE |
Ifaf idem p state |
|
IFAF_IDEM_P_ZIP |
Ifaf idem p zip |
|
IFAF_IDEM_PHONE |
Ifaf idem phone |
|
IFAF_IDEM_S_COUNTRY |
Ifaf idem s country |
|
IFAF_IDEM_S_EMAIL_ADDR |
Ifaf idem s email addr |
|
IFAF_IDEM_S_ITIN |
Ifaf idem s itin |
|
IFAF_IDEM_STATE |
Ifaf idem state |
|
IFAF_IDEM_ZIP |
Ifaf idem zip |
|
IFAF_INCARC_APPL_FLAG |
Ifaf incarc appl flag |
|
IFAF_IRES_DRUG_ABUSE_HOLD_IND |
Ifaf ires drug abuse hold ind |
|
IFAF_IRES_FTI_OTH_P_AGI |
Ifaf ires fti oth p agi |
|
IFAF_IRES_FTI_OTH_P_EDU_CREDIT |
Ifaf ires fti oth p edu credit |
|
IFAF_IRES_FTI_OTH_P_INCOME |
Ifaf ires fti oth p income |
|
IFAF_IRES_FTI_OTH_P_INTEREST_INC |
Ifaf ires fti oth p interest inc |
|
IFAF_IRES_FTI_OTH_P_IRA_PAYMTS |
Ifaf ires fti oth p ira paymts |
|
IFAF_IRES_FTI_OTH_P_IRS_RESP_CODE |
Ifaf ires fti oth p irs resp code |
|
IFAF_IRES_FTI_OTH_P_NBR_DEPEND |
Ifaf ires fti oth p nbr depend |
|
IFAF_IRES_FTI_OTH_P_NBR_EXEMPT |
Ifaf ires fti oth p nbr exempt |
|
IFAF_IRES_FTI_OTH_P_RET_TAX_YEAR |
Ifaf ires fti oth p ret tax year |
|
IFAF_IRES_FTI_OTH_P_SCHED_A_IND |
Ifaf ires fti oth p sched a ind |
|
IFAF_IRES_FTI_OTH_P_SCHED_B_IND |
Ifaf ires fti oth p sched b ind |
|
IFAF_IRES_FTI_OTH_P_SCHED_C_NET |
Ifaf ires fti oth p sched c net |
|
IFAF_IRES_FTI_OTH_P_SCHED_D_IND |
Ifaf ires fti oth p sched d ind |
|
IFAF_IRES_FTI_OTH_P_SCHED_E_IND |
Ifaf ires fti oth p sched e ind |
|
IFAF_IRES_FTI_OTH_P_SCHED_F_IND |
Ifaf ires fti oth p sched f ind |
|
IFAF_IRES_FTI_OTH_P_SCHED_H_IND |
Ifaf ires fti oth p sched h ind |
|
IFAF_IRES_FTI_OTH_P_TAX_MAR_ST |
Ifaf ires fti oth p tax mar st |
|
IFAF_IRES_FTI_OTH_P_UNTAXED_IRA |
Ifaf ires fti oth p untaxed ira |
|
IFAF_IRES_FTI_OTH_P_UNTAXED_PEN |
Ifaf ires fti oth p untaxed pen |
|
IFAF_IRES_FTI_OTH_P_US_TAX_PD |
Ifaf ires fti oth p us tax pd |
|
IFAF_IRES_FTI_P_AGI |
Ifaf ires fti p agi |
|
IFAF_IRES_FTI_P_EDU_CREDIT |
Ifaf ires fti p edu credit |
|
IFAF_IRES_FTI_P_INCOME |
Ifaf ires fti p income |
|
IFAF_IRES_FTI_P_INTEREST_INC |
Ifaf ires fti p interest inc |
|
IFAF_IRES_FTI_P_IRA_PAYMTS |
Ifaf ires fti p ira paymts |
|
IFAF_IRES_FTI_P_IRS_RESP_CODE |
Ifaf ires fti p irs resp code |
|
IFAF_IRES_FTI_P_NBR_DEPEND |
Ifaf ires fti p nbr depend |
|
IFAF_IRES_FTI_P_NBR_EXEMPT |
Ifaf ires fti p nbr exempt |
|
IFAF_IRES_FTI_P_RET_TAX_YEAR |
Ifaf ires fti p ret tax year |
|
IFAF_IRES_FTI_P_SCHED_A_IND |
Ifaf ires fti p sched a ind |
|
IFAF_IRES_FTI_P_SCHED_B_IND |
Ifaf ires fti p sched b ind |
|
IFAF_IRES_FTI_P_SCHED_C_NET |
Ifaf ires fti p sched c net |
|
IFAF_IRES_FTI_P_SCHED_D_IND |
Ifaf ires fti p sched d ind |
|
IFAF_IRES_FTI_P_SCHED_E_IND |
Ifaf ires fti p sched e ind |
|
IFAF_IRES_FTI_P_SCHED_F_IND |
Ifaf ires fti p sched f ind |
|
IFAF_IRES_FTI_P_SCHED_H_IND |
Ifaf ires fti p sched h ind |
|
IFAF_IRES_FTI_P_TAX_MAR_ST |
Ifaf ires fti p tax mar st |
|
IFAF_IRES_FTI_P_UNTAXED_IRA |
Ifaf ires fti p untaxed ira |
|
IFAF_IRES_FTI_P_UNTAXED_PEN |
Ifaf ires fti p untaxed pen |
|
IFAF_IRES_FTI_P_US_TAX_PD |
Ifaf ires fti p us tax pd |
|
IFAF_IRES_FTI_S_AGI |
Ifaf ires fti s agi |
|
IFAF_IRES_FTI_S_EDU_CREDIT |
Ifaf ires fti s edu credit |
|
IFAF_IRES_FTI_S_INCOME |
Ifaf ires fti s income |
|
IFAF_IRES_FTI_S_INTEREST_INC |
Ifaf ires fti s interest inc |
|
IFAF_IRES_FTI_S_IRA_PAYMTS |
Ifaf ires fti s ira paymts |
|
IFAF_IRES_FTI_S_IRS_RESP_CODE |
Ifaf ires fti s irs resp code |
|
IFAF_IRES_FTI_S_NBR_DEPEND |
Ifaf ires fti s nbr depend |
|
IFAF_IRES_FTI_S_NBR_EXEMPT |
Ifaf ires fti s nbr exempt |
|
IFAF_IRES_FTI_S_RET_TAX_YEAR |
Ifaf ires fti s ret tax year |
|
IFAF_IRES_FTI_S_SCHED_A_IND |
Ifaf ires fti s sched a ind |
|
IFAF_IRES_FTI_S_SCHED_B_IND |
Ifaf ires fti s sched b ind |
|
IFAF_IRES_FTI_S_SCHED_C_NET |
Ifaf ires fti s sched c net |
|
IFAF_IRES_FTI_S_SCHED_D_IND |
Ifaf ires fti s sched d ind |
|
IFAF_IRES_FTI_S_SCHED_E_IND |
Ifaf ires fti s sched e ind |
|
IFAF_IRES_FTI_S_SCHED_F_IND |
Ifaf ires fti s sched f ind |
|
IFAF_IRES_FTI_S_SCHED_H_IND |
Ifaf ires fti s sched h ind |
|
IFAF_IRES_FTI_S_TAX_MAR_ST |
Ifaf ires fti s tax mar st |
|
IFAF_IRES_FTI_S_UNTAXED_IRA |
Ifaf ires fti s untaxed ira |
|
IFAF_IRES_FTI_S_UNTAXED_PEN |
Ifaf ires fti s untaxed pen |
|
IFAF_IRES_FTI_S_US_TAX_PD |
Ifaf ires fti s us tax pd |
|
IFAF_IRES_FTI_SP_AGI |
Ifaf ires fti sp agi |
|
IFAF_IRES_FTI_SP_EDU_CREDIT |
Ifaf ires fti sp edu credit |
|
IFAF_IRES_FTI_SP_INCOME |
Ifaf ires fti sp income |
|
IFAF_IRES_FTI_SP_INTEREST_INC |
Ifaf ires fti sp interest inc |
|
IFAF_IRES_FTI_SP_IRA_PAYMTS |
Ifaf ires fti sp ira paymts |
|
IFAF_IRES_FTI_SP_IRS_RESP_CODE |
Ifaf ires fti sp irs resp code |
|
IFAF_IRES_FTI_SP_NBR_DEPEND |
Ifaf ires fti sp nbr depend |
|
IFAF_IRES_FTI_SP_NBR_EXEMPT |
Ifaf ires fti sp nbr exempt |
|
IFAF_IRES_FTI_SP_RET_TAX_YEAR |
Ifaf ires fti sp ret tax year |
|
IFAF_IRES_FTI_SP_SCHED_A_IND |
Ifaf ires fti sp sched a ind |
|
IFAF_IRES_FTI_SP_SCHED_B_IND |
Ifaf ires fti sp sched b ind |
|
IFAF_IRES_FTI_SP_SCHED_C_NET |
Ifaf ires fti sp sched c net |
|
IFAF_IRES_FTI_SP_SCHED_D_IND |
Ifaf ires fti sp sched d ind |
|
IFAF_IRES_FTI_SP_SCHED_E_IND |
Ifaf ires fti sp sched e ind |
|
IFAF_IRES_FTI_SP_SCHED_F_IND |
Ifaf ires fti sp sched f ind |
|
IFAF_IRES_FTI_SP_SCHED_H_IND |
Ifaf ires fti sp sched h ind |
|
IFAF_IRES_FTI_SP_TAX_MAR_ST |
Ifaf ires fti sp tax mar st |
|
IFAF_IRES_FTI_SP_UNTAXED_IRA |
Ifaf ires fti sp untaxed ira |
|
IFAF_IRES_FTI_SP_UNTAXED_PEN |
Ifaf ires fti sp untaxed pen |
|
IFAF_IRES_FTI_SP_US_TAX_PD |
Ifaf ires fti sp us tax pd |
|
IFAF_IRES_IASG_IND |
Ifaf ires iasg ind |
|
IFAF_IRES_OTH_P_AFFIRM_STATUS |
Ifaf ires oth p affirm status |
|
IFAF_IRES_OTH_P_CONSENT_DATE |
Ifaf ires oth p consent date |
|
IFAF_IRES_OTH_P_SSN_MATCH |
Ifaf ires oth p ssn match |
|
IFAF_IRES_OTH_P_TRNU_MATCH_STATUS |
Ifaf ires oth p trnu match status |
|
IFAF_IRES_P_AFFIRM_STATUS |
Ifaf ires p affirm status |
|
IFAF_IRES_P_CONSENT_DATE |
Ifaf ires p consent date |
|
IFAF_IRES_P_SSN_MATCH |
Ifaf ires p ssn match |
|
IFAF_IRES_P_TRNU_MATCH_STATUS |
Ifaf ires p trnu match status |
|
IFAF_IRES_S_AFFIRM_STATUS |
Ifaf ires s affirm status |
|
IFAF_IRES_S_CONSENT_DATE |
Ifaf ires s consent date |
|
IFAF_IRES_S_TRNU_MATCH_STATUS |
Ifaf ires s trnu match status |
|
IFAF_IRES_SAR_C_FLAG |
Ifaf ires sar c flag |
|
IFAF_IRES_SP_AFFIRM_STATUS |
Ifaf ires sp affirm status |
|
IFAF_IRES_SP_CONSENT_DATE |
Ifaf ires sp consent date |
|
IFAF_IRES_SP_SSN_MATCH |
Ifaf ires sp ssn match |
|
IFAF_IRES_SP_TRNU_MATCH_STATUS |
Ifaf ires sp trnu match status |
|
IFAF_IRES_SPECIAL_HANDLE_IND |
Ifaf ires special handle ind |
|
IFAF_IRES_TRANS_LANGUAGE |
Ifaf ires trans language |
|
IFAF_IRES_TRANS_SOURCE |
Ifaf ires trans source |
|
IFAF_IRES_TRANS_STATUS |
Ifaf ires trans status |
|
IFAF_IRES_TRANS_TYPE |
Ifaf ires trans type |
|
IFAF_ISES_RENEWAL_DATA_USED |
Ifaf ises renewal data used |
|
IFAF_ISIR_TYPE |
Ifaf isir type |
|
IFAF_MAX_PELL_IND |
Ifaf max pell ind |
|
IFAF_MIN_PELL_IND |
Ifaf min pell ind |
|
IFAF_MOTHER_DOB |
Ifaf mother dob |
|
IFAF_NAME_FIRST |
Ifaf name first |
|
IFAF_NAME_LAST |
Ifaf name last |
|
IFAF_OTH_P_BIRTHDATE |
Ifaf oth p birthdate |
|
IFAF_P_AGI_DATA_FLD_FLAG |
Ifaf p agi data fld flag |
|
IFAF_P_BIRTHDATE |
Ifaf p birthdate |
|
IFAF_P_FIT_DATA_FLD_FLAG |
Ifaf p fit data fld flag |
|
IFAF_P_IRS_DISPLAY_FLAG |
Ifaf p irs display flag |
|
IFAF_P_IRS_ED_CRED_FLAG |
Ifaf p irs ed cred flag |
|
IFAF_P_IRS_EXEMPT_FLAG |
Ifaf p irs exempt flag |
|
IFAF_P_IRS_INT_INC_FLAG |
Ifaf p irs int inc flag |
|
IFAF_P_IRS_IRA_DISB_FLAG |
Ifaf p irs ira disb flag |
|
IFAF_P_IRS_IRA_PAY_FLAG |
Ifaf p irs ira pay flag |
|
IFAF_P_IRS_REQUEST_FLAG |
Ifaf p irs request flag |
|
IFAF_P_IRS_TAX_FILE_FLAG |
Ifaf p irs tax file flag |
|
IFAF_P_IRS_TAX_TYPE_FLAG |
Ifaf p irs tax type flag |
|
IFAF_P_MARITAL_MONTH |
Ifaf p marital month |
|
IFAF_P_MARITAL_YEAR |
Ifaf p marital year |
|
IFAF_P_UNTX_PEN_FLAG |
Ifaf p untx pen flag |
|
IFAF_PARENT_ADJ_GROSS_INCOME |
Ifaf parent adj gross income |
|
IFAF_POST_SCRN_RSN_CODE |
Ifaf post scrn rsn code |
|
IFAF_PREVIOUS_ACTIVE_TRANS |
Ifaf previous active trans |
|
IFAF_PRI_ALT1 |
Ifaf pri alt1 |
|
IFAF_PRI_ALT10 |
Ifaf pri alt10 |
|
IFAF_PRI_ALT11 |
Ifaf pri alt11 |
|
IFAF_PRI_ALT12 |
Ifaf pri alt12 |
|
IFAF_PRI_ALT2 |
Ifaf pri alt2 |
|
IFAF_PRI_ALT3 |
Ifaf pri alt3 |
|
IFAF_PRI_ALT4 |
Ifaf pri alt4 |
|
IFAF_PRI_ALT5 |
Ifaf pri alt5 |
|
IFAF_PRI_ALT6 |
Ifaf pri alt6 |
|
IFAF_PRI_ALT7 |
Ifaf pri alt7 |
|
IFAF_PRI_ALT8 |
Ifaf pri alt8 |
|
IFAF_PRI_ATI |
Ifaf pri ati |
|
IFAF_PRI_CAI |
Ifaf pri cai |
|
IFAF_PRI_EA |
Ifaf pri ea |
|
IFAF_PRI_EFC |
Ifaf pri efc |
|
IFAF_PRI_FTI |
Ifaf pri fti |
|
IFAF_PRI_IPA |
Ifaf pri ipa |
|
IFAF_PRI_PC |
Ifaf pri pc |
|
IFAF_PRI_PCA |
Ifaf pri pca |
|
IFAF_PRI_SAAI |
Ifaf pri saai |
|
IFAF_PRI_SATI |
Ifaf pri sati |
|
IFAF_PRI_SC |
Ifaf pri sc |
|
IFAF_PRI_SCA |
Ifaf pri sca |
|
IFAF_PRI_STAI |
Ifaf pri stai |
|
IFAF_PRI_STI |
Ifaf pri sti |
|
IFAF_PRI_STX |
Ifaf pri stx |
|
IFAF_PRI_TI |
Ifaf pri ti |
|
IFAF_PROVISIONAL_SAI |
Ifaf provisional sai |
|
IFAF_RECEIPT_DATE |
Ifaf receipt date |
|
IFAF_S_AGI_DATA_FLD_FLAG |
Ifaf s agi data fld flag |
|
IFAF_S_FIT_DATA_FLD_FLAG |
Ifaf s fit data fld flag |
|
IFAF_S_IRS_DISPLAY_FLAG |
Ifaf s irs display flag |
|
IFAF_S_IRS_ED_CRED_FLAG |
Ifaf s irs ed cred flag |
|
IFAF_S_IRS_EXEMPT_FLAG |
Ifaf s irs exempt flag |
|
IFAF_S_IRS_INT_INC_FLAG |
Ifaf s irs int inc flag |
|
IFAF_S_IRS_IRA_DISB_FLAG |
Ifaf s irs ira disb flag |
|
IFAF_S_IRS_IRA_PAY_FLAG |
Ifaf s irs ira pay flag |
|
IFAF_S_IRS_REQUEST_FLAG |
Ifaf s irs request flag |
|
IFAF_S_IRS_TAX_TYPE_FLAG |
Ifaf s irs tax type flag |
|
IFAF_S_IRS_UNTX_PEN_FLAG |
Ifaf s irs untx pen flag |
|
IFAF_S_MARITAL_MONTH |
Ifaf s marital month |
|
IFAF_S_MARITAL_YEAR |
Ifaf s marital year |
|
IFAF_S_TAX_FILE_FLAG |
Ifaf s tax file flag |
|
IFAF_SAI_COMP_TYPE |
Ifaf sai comp type |
|
IFAF_SIMPLE_NEED_IND |
Ifaf simple need ind |
|
IFAF_SSN_MATCH |
Ifaf ssn match |
|
IFAF_STU_APA |
Ifaf stu apa |
|
IFAF_STU_NW |
Ifaf stu nw |
|
IFAF_TRANSACTION_NUMBER |
Ifaf transaction number |
|
IFAF_TRANSACTION_PROC_DATE |
Ifaf transaction proc date |
|
IFAF_VERIF_CHG_FLAG |
Ifaf verif chg flag |
|
IFAF_VERIF_TRACKING |
Ifaf verif tracking |
|
IFAF_VETERAN_BENEFIT_TYPE |
Ifaf veteran benefit type |
|
IFAF_VETERAN_BENEFIT_TYPE_DESC |
Ifaf veteran benefit type desc |
|
IFAF_YEAR |
Ifaf year |
|
IFAF_YEAR_IN_COLLEGE |
Ifaf year in college |
|
IFAF_BORN_B4_DT |
Ifaf born b4 dt |
|
IFAF_CITIZENSHIP |
Ifaf citizenship |
|
IFAF_CPS_OVER_ASSM1 |
Ifaf cps over assm1 |
|
IFAF_CPS_OVER_ASSM2 |
Ifaf cps over assm2 |
|
IFAF_CPS_OVER_ASSM3 |
Ifaf cps over assm3 |
|
IFAF_CPS_OVER_ASSM4 |
Ifaf cps over assm4 |
|
IFAF_CPS_OVER_ASSM5 |
Ifaf cps over assm5 |
|
IFAF_CPS_OVER_ASSM6 |
Ifaf cps over assm6 |
|
IFAF_DEPEND_CHILDREN |
Ifaf depend children |
|
IFAF_EITHER_PAR_ATTEND_COLL |
Ifaf either par attend coll |
|
IFAF_EMANCIPATED_MINOR |
Ifaf emancipated minor |
|
IFAF_FATHER_GRADE_LVL |
Ifaf father grade lvl |
|
IFAF_HOMELESS_AT_RISK |
Ifaf homeless at risk |
|
IFAF_HOMELESS_BY_HUD |
Ifaf homeless by hud |
|
IFAF_HOMELESS_BY_SCHOOL |
Ifaf homeless by school |
|
IFAF_HOMELESS_FAA |
Ifaf homeless faa |
|
IFAF_HOMELESS_TRIO |
Ifaf homeless trio |
|
IFAF_HOUSING_1 |
Ifaf housing 1 |
|
IFAF_HOUSING_10 |
Ifaf housing 10 |
|
IFAF_HOUSING_2 |
Ifaf housing 2 |
|
IFAF_HOUSING_3 |
Ifaf housing 3 |
|
IFAF_HOUSING_4 |
Ifaf housing 4 |
|
IFAF_HOUSING_5 |
Ifaf housing 5 |
|
IFAF_HOUSING_6 |
Ifaf housing 6 |
|
IFAF_HOUSING_7 |
Ifaf housing 7 |
|
IFAF_HOUSING_8 |
Ifaf housing 8 |
|
IFAF_HOUSING_9 |
Ifaf housing 9 |
|
IFAF_LEGAL_GUARDIANSHIP |
Ifaf legal guardianship |
|
IFAF_MALE_FEMALE |
Ifaf male female |
|
IFAF_MARRIED |
Ifaf married |
|
IFAF_MOTHER_GRADE_LVL |
Ifaf mother grade lvl |
|
IFAF_ORPHAN_WARD |
Ifaf orphan ward |
|
IFAF_OTH_P_AGI |
Ifaf oth p agi |
|
IFAF_OTH_P_FILE_SCHED_ABDEFH |
Ifaf oth p file sched abdefh |
|
IFAF_OTH_P_FILED_1040_OR_NR |
Ifaf oth p filed 1040 or nr |
|
IFAF_OTH_P_FILED_NON_US_TAX |
Ifaf oth p filed non us tax |
|
IFAF_OTH_P_INC |
Ifaf oth p inc |
|
IFAF_OTH_P_IRA_ROLLOVER |
Ifaf oth p ira rollover |
|
IFAF_OTH_P_PENSION_ROLLOVER |
Ifaf oth p pension rollover |
|
IFAF_OTH_P_SCHED_C_AMT |
Ifaf oth p sched c amt |
|
IFAF_OTH_P_UNTAXED_IRA |
Ifaf oth p untaxed ira |
|
IFAF_OTH_P_UNTAXED_PENSIONS |
Ifaf oth p untaxed pensions |
|
IFAF_OTH_P_US_TAX_PD |
Ifaf oth p us tax pd |
|
IFAF_OTHER_DEPEND |
Ifaf other depend |
|
IFAF_P_BUS_NET_WORTH |
Ifaf p bus net worth |
|
IFAF_P_CASH |
Ifaf p cash |
|
IFAF_P_CHILD_SUP_RECV |
Ifaf p child sup recv |
|
IFAF_P_CHILD_SUPPORT_PD |
Ifaf p child support pd |
|
IFAF_P_CO_OP_EARNINGS |
Ifaf p co op earnings |
|
IFAF_P_COMBAT_PAY |
Ifaf p combat pay |
|
IFAF_P_DISLOCATED_WORK |
Ifaf p dislocated work |
|
IFAF_P_EDU_CREDIT |
Ifaf p edu credit |
|
IFAF_P_FATHER_INC |
Ifaf p father inc |
|
IFAF_P_FILE_SCHED_ABDEFH |
Ifaf p file sched abdefh |
|
IFAF_P_FILED_1040_OR_NR |
Ifaf p filed 1040 or nr |
|
IFAF_P_FILED_JOIN_WITH_SP |
Ifaf p filed join with sp |
|
IFAF_P_FILED_NON_US_TAX |
Ifaf p filed non us tax |
|
IFAF_P_FOOD_STAMPS |
Ifaf p food stamps |
|
IFAF_P_GRANT_SCHOL_AID |
Ifaf p grant schol aid |
|
IFAF_P_INC |
Ifaf p inc |
|
IFAF_P_INTEREST_INCOME |
Ifaf p interest income |
|
IFAF_P_INV_NET_WORTH |
Ifaf p inv net worth |
|
IFAF_P_IRA_DISTRIB |
Ifaf p ira distrib |
|
IFAF_P_IRA_PAYMTS |
Ifaf p ira paymts |
|
IFAF_P_IRA_ROLLOVER |
Ifaf p ira rollover |
|
IFAF_P_LEGAL_RES |
Ifaf p legal res |
|
IFAF_P_LUNCH_BEN |
Ifaf p lunch ben |
|
IFAF_P_MARITAL_ST |
Ifaf p marital st |
|
IFAF_P_MILITARY_CLERGY_ALLOW |
Ifaf p military clergy allow |
|
IFAF_P_MOTHER_INC |
Ifaf p mother inc |
|
IFAF_P_NBR_FAMILY |
Ifaf p nbr family |
|
IFAF_P_NEED_BASED_EMP |
Ifaf p need based emp |
|
IFAF_P_NO_COLL |
Ifaf p no coll |
|
IFAF_P_OTHER_UNTAXED_INC |
Ifaf p other untaxed inc |
|
IFAF_P_PENSION_PAYMTS |
Ifaf p pension paymts |
|
IFAF_P_PENSION_ROLLOVER |
Ifaf p pension rollover |
|
IFAF_P_SCHED_C_AMT |
Ifaf p sched c amt |
|
IFAF_P_SSI_BEN |
Ifaf p ssi ben |
|
IFAF_P_TANF |
Ifaf p tanf |
|
IFAF_P_TAX_FORM_TYPE |
Ifaf p tax form type |
|
IFAF_P_TAX_MARITAL_ST |
Ifaf p tax marital st |
|
IFAF_P_TAX_MARITAL_STATUS |
Ifaf p tax marital status |
|
IFAF_P_TAX_RETURN_FILED |
Ifaf p tax return filed |
|
IFAF_P_UNTAXED_IRA |
Ifaf p untaxed ira |
|
IFAF_P_UNTX_IRA_PEN |
Ifaf p untx ira pen |
|
IFAF_P_US_TAX_PD |
Ifaf p us tax pd |
|
IFAF_P_VET_NON_ED_BEN |
Ifaf p vet non ed ben |
|
IFAF_P_WIC |
Ifaf p wic |
|
IFAF_PAR_KILLED_LINE_DUTY |
Ifaf par killed line duty |
|
IFAF_REC_VET_BEN |
Ifaf rec vet ben |
|
IFAF_S_AGI |
Ifaf s agi |
|
IFAF_S_BUS_NET_WORTH |
Ifaf s bus net worth |
|
IFAF_S_CASH |
Ifaf s cash |
|
IFAF_S_CHILD_OTH_DEPEND |
Ifaf s child oth depend |
|
IFAF_S_CHILD_SUP_RECV |
Ifaf s child sup recv |
|
IFAF_S_CHILD_SUPPORT_PD |
Ifaf s child support pd |
|
IFAF_S_CO_OP_EARNINGS |
Ifaf s co op earnings |
|
IFAF_S_COMBAT_PAY |
Ifaf s combat pay |
|
IFAF_S_DISLOCATED_WORK |
Ifaf s dislocated work |
|
IFAF_S_EDU_CREDIT |
Ifaf s edu credit |
|
IFAF_S_EXMPT_FOREIGN_INC |
Ifaf s exmpt foreign inc |
|
IFAF_S_FILE_SCHED_ABDEFH |
Ifaf s file sched abdefh |
|
IFAF_S_FILED_1040_OR_NR |
Ifaf s filed 1040 or nr |
|
IFAF_S_FILED_JOIN_WITH_SP |
Ifaf s filed join with sp |
|
IFAF_S_FILED_NON_US_TAX |
Ifaf s filed non us tax |
|
IFAF_S_FOOD_STAMPS |
Ifaf s food stamps |
|
IFAF_S_GRANT_SCHOL_AID |
Ifaf s grant schol aid |
|
IFAF_S_HOMELESS_GENERAL |
Ifaf s homeless general |
|
IFAF_S_HOMELESS_RISK_OR_SELF |
Ifaf s homeless risk or self |
|
IFAF_S_HS_EQUIV_DIP_NAME |
Ifaf s hs equiv dip name |
|
IFAF_S_HS_EQUIV_DIP_STATE |
Ifaf s hs equiv dip state |
|
IFAF_S_IN_FOSTER_CARE |
Ifaf s in foster care |
|
IFAF_S_INTEREST_INCOME |
Ifaf s interest income |
|
IFAF_S_INV_NET_WORTH |
Ifaf s inv net worth |
|
IFAF_S_IRA_PAYMTS |
Ifaf s ira paymts |
|
IFAF_S_IRA_ROLLOVER |
Ifaf s ira rollover |
|
IFAF_S_LEGAL_RES |
Ifaf s legal res |
|
IFAF_S_LUNCH_BEN |
Ifaf s lunch ben |
|
IFAF_S_MARITAL_ST |
Ifaf s marital st |
|
IFAF_S_MILITARY_CLERGY_ALLOW |
Ifaf s military clergy allow |
|
IFAF_S_NEED_BASED_EMP |
Ifaf s need based emp |
|
IFAF_S_NO_COLL |
Ifaf s no coll |
|
IFAF_S_NO_FAMILY |
Ifaf s no family |
|
IFAF_S_OTH_CIRCUM_NOTA |
Ifaf s oth circum nota |
|
IFAF_S_OTHER_NON_REP_MONEY |
Ifaf s other non rep money |
|
IFAF_S_OTHER_UNTAXED_INC |
Ifaf s other untaxed inc |
|
IFAF_S_PARENTS_DECEASED |
Ifaf s parents deceased |
|
IFAF_S_PENSION_PAYMTS |
Ifaf s pension paymts |
|
IFAF_S_PENSION_ROLLOVER |
Ifaf s pension rollover |
|
IFAF_S_PERSONAL_CIRCUM_NOTA |
Ifaf s personal circum nota |
|
IFAF_S_PURSUE_TEACH_CERT |
Ifaf s pursue teach cert |
|
IFAF_S_SCHED_C_AMT |
Ifaf s sched c amt |
|
IFAF_S_SSI_BEN |
Ifaf s ssi ben |
|
IFAF_S_STUDENT_INC |
Ifaf s student inc |
|
IFAF_S_TANF |
Ifaf s tanf |
|
IFAF_S_TAX_FORM_TYPE |
Ifaf s tax form type |
|
IFAF_S_TAX_MARITAL_STATUS |
Ifaf s tax marital status |
|
IFAF_S_TAX_RETURN_FILED |
Ifaf s tax return filed |
|
IFAF_S_UNSUB_ONLY |
Ifaf s unsub only |
|
IFAF_S_UNTAXED_IRA |
Ifaf s untaxed ira |
|
IFAF_S_UNTX_IRA_PEN |
Ifaf s untx ira pen |
|
IFAF_S_UNUSUAL_CIRCUM |
Ifaf s unusual circum |
|
IFAF_S_US_TAX_PD |
Ifaf s us tax pd |
|
IFAF_S_VET_NON_ED_BEN |
Ifaf s vet non ed ben |
|
IFAF_S_WARD_OF_COURT |
Ifaf s ward of court |
|
IFAF_S_WIC |
Ifaf s wic |
|
IFAF_SP_AGI |
Ifaf sp agi |
|
IFAF_SP_EXMPT_FOREIGN_INC |
Ifaf sp exmpt foreign inc |
|
IFAF_SP_FILE_SCHED_ABDEFH |
Ifaf sp file sched abdefh |
|
IFAF_SP_FILED_1040_OR_NR |
Ifaf sp filed 1040 or nr |
|
IFAF_SP_FILED_NON_US_TAX |
Ifaf sp filed non us tax |
|
IFAF_SP_IRA_ROLLOVER |
Ifaf sp ira rollover |
|
IFAF_SP_PENSION_ROLLOVER |
Ifaf sp pension rollover |
|
IFAF_SP_SCHED_C_AMT |
Ifaf sp sched c amt |
|
IFAF_SP_TAX_MARITAL_ST |
Ifaf sp tax marital st |
|
IFAF_SP_UNTAXED_IRA |
Ifaf sp untaxed ira |
|
IFAF_SP_UNTAXED_PENSIONS |
Ifaf sp untaxed pensions |
|
IFAF_SP_US_TAX_PD |
Ifaf sp us tax pd |
|
IFAF_SPOUSE_INC |
Ifaf spouse inc |
|
IFAF_TITLEIV_1 |
Ifaf titleiv 1 |
|
IFAF_TITLEIV_10 |
Ifaf titleiv 10 |
|
IFAF_TITLEIV_2 |
Ifaf titleiv 2 |
|
IFAF_TITLEIV_3 |
Ifaf titleiv 3 |
|
IFAF_TITLEIV_4 |
Ifaf titleiv 4 |
|
IFAF_TITLEIV_5 |
Ifaf titleiv 5 |
|
IFAF_TITLEIV_6 |
Ifaf titleiv 6 |
|
IFAF_TITLEIV_7 |
Ifaf titleiv 7 |
|
IFAF_TITLEIV_8 |
Ifaf titleiv 8 |
|
IFAF_TITLEIV_9 |
Ifaf titleiv 9 |
|
PREVIOUS_FAFSA |
Previous FAFSA transaction ID |
|
IRES_EFC_CHG_FLAG |
Ires efc chg flag |
|
IRES_NSLDS_MATCH |
Ires nslds match |
|
IRES_REPROC_REASON_CODE |
Ires reproc reason code |
|
CS_ACTIVE_FLAG |
Active transaction flag |