Versions Compared

Old Version 29

changes.mady.by.user Heather Smith

Saved on

compared with

New Version 30

changes.mady.by.user Heather Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Overview

...

 Multiple FAYs can be represented on the Access Database Extract File at the same time, but the table below shows only columns applicable to the 24-25 form.

Note: For clients who make application corrections via import file, this table can be used to identify column names that correspond to 24-25 questions. Uncorrectable fields can be identified by a N/A in the ‘Field on Form’ column or by a ‘Client custom field’ entry in the Notes column, for questions not applicable to the client’s form.

Expand
titleClick here to expand for the 2024-2025 Access Database Extract File (CSV) layout and field mapping

The table below represents the file Access Database Extract File layout and field mapping for the 2024-2025 Access master form. 

Column Name on File

Field on Form

Field Type on Form

Valid Values

Column Name on File

Field on Form

Field Type on Form

Valid Values

Notes

username

N/A




userExternalId

N/A




userCreatedDate

N/A




userLastIpAddress

N/A




applicationId

N/A




institution

N/A




institutionExternalId

N/A




campus

N/A




campusExternalId

N/A




site

N/A




siteExternalId

N/A




program

N/A




programExternalId

N/A




electronicSignatureRequiredTypeCode

N/A


NOTREQUIRED

ONLYPARENTSIGNATUREREQUIRED

ONLYSTUDENTSIGNATUREREQUIRED

BOTHSTUDENTANDPARENTSIGNATURESREQUIRED


type

N/A


Financial Aid Application


name

N/A



Name from Document Setup

status

N/A




createdDate

N/A




eSigned

N/A




eSignedDate

N/A




⚖️ sai

N/A




dependencyStatusCode

N/A


I= Independent

D= Dependent

Z= Provisional Independent

X= Rejected Dependent


dependencyStatus

N/A


Independent
Dependent
Provisional Independent
Rejected Independent


correctionProcessDate

N/A




⚖️ originalSocialSecurityNumber

Social Security Number

Textbox

9-digit numeric value. Values may also be blank or nine zeroes (000000000)


studentsFirstName

First Name

Textbox



middleName

Middle Name

Textbox



studentsLastName

Last Name

Textbox



academicYear

N/A



Example: 2025

academicYearRange

N/A



Example: 2024-2025

areYouOnActiveDutyInUSArmedForces

The student is currently serving on active duty in the U.S. armed forces for purposes other than training.

Checkbox

1= Selected
Blank

Personal Circumstances option

asofTodayAnEmancipatedMinor

The student is or was a legally emancipated minor, as determined by a court in their state of residence.

Checkbox

1= Selected
Blank

Personal Circumstances option

asofTodayInLegalGuardianship

The student is or was in a legal guardianship with someone other than their parent or stepparent, as determined by a court in their state of residence.

Checkbox

1= Selected
Blank

Personal Circumstances option

certificationIntroduction


Text Only


Client custom field. Text only. Column is blank in file for all clients.

certificationOptionA


Radio Button

1
2
Blank

Client custom field. 

certificationOptionB


Radio Button

1
2
Blank

Client custom field. 

certificationOptionC


Radio Button

1
2
Blank

Client custom field. 

certificationPermanentResidency


Radio Button

1
2
Blank

Client custom field. 

certifyPermandentResidencyApplication


Text Only


Client custom field. Text only. Column is blank in file for all clients.

doYouWantSelectiveServiceToRegisterYou

I certify that I am in compliance with federal Selective Service registration requirements.

Checkbox

Blank
1= checked

Only shown for some states, to males between age 18 and 25

eitherParentAttendCollege

Did either of the student’s parents attend or complete college?

Dropdown

1 = Neither parent attended college
2 = One or both parents attended college, but neither parent completed college
3 = One or both parents completed college
4 = Don’t know
Blank


encourageCreateProfile


Text Only


Client custom field. Text only. Column is blank in file for all clients.

federalSchoolCode1

Federal School Code 1

Dropdown


Options are:
Select
List of FSC for each configured Site

federalSchoolCode10

Federal School Code 10

Dropdown

Blank
Numeric Federal School Code

Options are:
Select
List of FSC for each configured Site

federalSchoolCode11

Federal School Code 11

Dropdown



federalSchoolCode12

Federal School Code 12

Dropdown



federalSchoolCode13

Federal School Code 13

Dropdown



federalSchoolCode14

Federal School Code 14

Dropdown



federalSchoolCode15

Federal School Code 15

Dropdown



federalSchoolCode16

Federal School Code 16

Dropdown



federalSchoolCode17

Federal School Code 17

Dropdown



federalSchoolCode18

Federal School Code 18

Dropdown



federalSchoolCode19

Federal School Code 19

Dropdown



federalSchoolCode2

Federal School Code 2

Dropdown



federalSchoolCode20

Federal School Code 20

Dropdown



federalSchoolCode3

Federal School Code 3

Dropdown



federalSchoolCode4

Federal School Code 4

Dropdown



federalSchoolCode5

Federal School Code 5

Dropdown



federalSchoolCode6

Federal School Code 6

Dropdown



federalSchoolCode7

Federal School Code 7

Dropdown



federalSchoolCode8

Federal School Code 8

Dropdown



federalSchoolCode9

Federal School Code 9

Dropdown



firstBachelorsDegreeBy

When the student begins the XXXX school year, will they already have their first bachelor's degree?

Dropdown

1= Yes
2= No


gradeLevelInCollege

When the student begins the XXXX school year, what will their college grade level be?

Dropdown

1 = First Year (Freshman)
2 = Second Year (Sophomore)
3 = Other Undergraduate (Junior or Senior)
4 = College Graduate, Professional or Beyond (MBA, M.D., Ph.D., etc.)
Blank


gradeLevelInCollegeFundingMessage

N/A- informational text only



Text is shown/hidden based on client. Column will be blank in file for all clients.

haveChildrenYouSupport

The student has children or other people (excluding their spouse) who live with the student and will receive more than half of their support from the student now and between July 1, XXXX and June 30, XXXX.

Checkbox

1= Selected
Blank

Personal Circumstances option

highSchoolCity

High school city

Textbox



highSchoolEquivalentDiplomaName

Which state-recognized high school equivalent did or will the student receive?

Dropdown

1= GED
2= HiSET
3= TASC
4= Other
Blank


highSchoolEquivalentDiplomaState

Issuing state

Dropdown

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

highSchoolName

High school name

Textbox



highSchoolState

High school state

Dropdown

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

houseBill1079


Radio Button

1
2
Blank

Client custom field. 

HSDiplomaOrEquivalent

High school completion status when the student begins the XXXX school year.

Dropdown

1= High School diploma
2= State-recognized high school equivalent
3= Homeschooled
4= None of the previous


inFosterCare

At any time since the student turned age 13, they were in foster care.

Checkbox

1= Selected
Blank

Personal Circumstances option

inStateRates


Text Only


Client custom question. Text only. Column will be blank in file for all clients.

isTheStudentHispanic

Is the student of Hispanic, Latino, or Spanish origin?


1= No, not of Hispanic, Latino, or Spanish origin
2= Yes, Mexican, Mexican American, or Chicano
3= Yes, Puerto Rican
4= Yes, Cuban
5= Yes, another Hispanic, Latino, or Spanish origin
6= Prefer not to answer


otherCircumstancesNoneOfTheAbove

None of these

Checkbox

1= Selected
Blank

Other Circumstances option

parentCity

City

Textbox



parentDateOfBirth

Parent's date of birth

MMDDYYYY Dropdown Date



parentDeductiblePaymentsToIRAKeoghOther

IRA deductions and payments to self-employed SEP, SIMPLE, and qualified plans

Textbox


Amount value

parentEarnedIncomeTaxCreditReceivedDuringTaxYear

Did the parent receive the earned income tax credit (EITC)?

Dropdown

1= Yes
2= No
3= Don't know
Blank


parentEmailAddress

Parent's email address

Textbox



parentFederalBenefitsNoneOfTheAbove

None of these

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentFiled1040or1040NR

Did or will the parent file a XXXX IRS Form 1040 or 1040-NR?

Radio Button

1= Yes
2= No
Blank


parentFiledJointReturnWithCurrentSpouse

Did or will the parent file a XXXX joint tax return with their current spouse?

Radio Button

1= Yes
2= No
Blank


parentFiledNonUSTaxReturn

Indicate which of the following situations applies to the parent for XXXX.

Radio Button

1 = The parent filed or will file a tax return with Puerto Rico or another U.S. territory
2 = The parent filed or will file a foreign tax return
3 = Either the parent earned income in a foreign country but did not and will not file a foreign tax return, or they were an employee of an international organization but not required to report their income on any tax return.
4 = The parent, even though they earned income in the U.S., did not and will not file a U.S. tax return  because their income was below the tax filing threshold.
5 = The parent did not and will not file a U.S. tax return for reasons other than low income.
6 = The parent did not and will not file any tax return because they did not earn any income.
Blank


parentFiledScheduleABDEForH

Did the parent file a schedule A, B, D, E, F, or H with their XXXX IRS Form 1040?

Dropdown

1= Yes
2= No
3= Don't know
Blank


parentFirstName

Parent's first name

Textbox



parentForeignEarnedIncomeExclusion

Foreign earned income exclusion

Textbox


Amount value

parentFreeorReducedPriceSchoolLunchBenefits

Free or reduced-price school lunch

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentIncomeEarnedFromWork

Income earned from work

Textbox


Amount value

parentIRARollover

IRA rollover into another IRA or qualified plan

Textbox


Amount value

parentITIN

N/A



Column will be blank on file. Field was consolidated with SSN field on form, to maintain current account validation processes. 

parentKilledintheLineofDuty

Was the student's parent or guardian killed in the line of duty while (1) serving on active duty as a member of the armed forces on or after September 11, 2001, or (2) performing official duties as a public safety officer?

Radio Button

1= Yes
2= No
Blank


parentLastName

Parent's last name

Textbox



parentMiddleName

Parent's middle name

Textbox



parentPensionRollover

Pension rollover into another IRA or qualified plan

Textbox


Amount value

parentPhoneNumber

Parent's mobile phone number

Textbox



parentReceivedEITC

Earned income tax credit (EITC)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentReceivedFederalHousingAssistance

Federal housing assistance

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentReceivedMedicaid

Medicaid

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentReceivedRefundableCreditFor36BHealthPlan

Refundable credit for coverage under a qualified health plan (QHP)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentReceivedSNAP

Supplemental Nutrition Assistance Program (SNAP)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentsAdjustedGrossIncomeFromIRSForm

Adjusted gross income

Textbox


Amount value

parentsBusinessAndOrInvestmentFarmNetWorth

Current net worth of businesses and investment farms

Textbox


Amount value

parentsCashSavingsAndChecking

Current total of cash, savings, and checking accounts

Textbox


Amount value

parentScheduleCAmount

Net profit or loss from IRS Form 1040 Schedule C

Textbox


Amount value

parentsChildSupportReceived

Annual Child Support Received

Textbox


Amount value

parentsDeceased

At any time since the student turned 13, they were an orphan (no living biological or adoptive parent.)

Checkbox

1= Selected
Blank

Personal Circumstances option

parentsEducationalCredits

Education credits (American Opportunity and Lifetime Learning credits)

Textbox


Amount value

parentsGrantOrScholarshipAid

Amount of college grants or scholarships reported as income to the IRS

Textbox


Amount value

parentSignatureDate

N/A




parentSignatureName

N/A




parentsInvestmentNetWorth

Current net worth of investments, including real estate

Textbox


Amount value

parentsLegalResidenceDate

Month and year parent became a full-time resident of the state/country indicated.

MMDDYYYY Dropdown Date



parentsMaritalStatus

Parent Current Marital Status

Dropdown

1 = Single
2 = Unmarried and both legal parents living together
3 = Married
4 = Remarried
5 = Separated
6 = Divorced
7 = Widowed
Blank

Note: Update needed to align option values with ISIR option values. 

parentsNumberinCollegeParentsExcluded

How many people in the parent's family will be in college between July 1, XXXX and June 30, XXXX?

Dropdown

1 through 9


parentsNumberofFamilyMembers

How many people are in the parent's family?

Dropdown

1 through 20


⚖️ parentSocialSecurityNumber

Parent's Social Security number (SSN), Individual Taxpayer Identification Number (ITIN), or Deferred Action for Childhood Arrivals (DACA) number

Textbox

9-digit numeric value. Values may also be blank or nine zeroes (000000000)


parentSpouseOrPartnerAdjustedGrossIncome

Adjusted gross income

Textbox


Amount value

parentSpouseOrPartnerCity

City

Textbox



parentSpouseOrPartnerDateOfBirth

Parent spouse or partner's date of birth

Date



parentSpouseOrPartnerDeductiblePaymentsToIRAKeoghOther

IRA deductions and payments to self-employed SEP, SIMPLE, and qualified plans

Textbox


Amount value

parentSpouseOrPartnerEducationCredits

Education credits (American Opportunity and Lifetime Learning credits)

Textbox


Amount value

parentSpouseOrPartnerEmailAddress

Parent spouse or partner's email address

Textbox



parentSpouseOrPartnerFiled1040or1040NR

Did or will the parent spouse or partner file a XXXX IRS Form 1040 or 1040-NR?

Radio Button



parentSpouseOrPartnerFiledNonUSTaxReturn

Indicate which of the following situations applies to the parent spouse or partner for XXXX.

Dropdown

1 = The parent spouse or partner filed or will file a tax return with Puerto Rico or another U.S. territory
2 = The parent spouse of partner filed or will file a foreign tax return
3 = Either the parent spouse or partner earned income in a foreign country but did not and will not file a foreign tax return, or they were an employee of an international organization but not required to report their income on any tax return.
4 = The parent spouse or partner, even though they earned income in the U.S., did not and will not file a U.S. tax return  because their income was below the tax filing threshold.
5 = The parent spouse or partner did not and will not file a U.S. tax return for reasons other than low income.
6 = The parent spouse or partner did not and will not file any tax return because they did not earn any income.
Blank


parentSpouseOrPartnerFiledScheduleABDEForH

Did the parent spouse or partner file a schedule A, B, D, E, F, or H with their $App.Fay(-3) IRS Form 1040?

Dropdown

1= Yes
2= No
3= Don't know
Blank


parentSpouseOrPartnerFirstName

Parent spouse or partner's first name

Textbox



parentSpouseOrPartnerForeignEarnedIncomeExclusion

Foreign earned income exclusion

Textbox


Amount value

parentSpouseOrPartnerIncomeEarnedFromWork

Income earned from work

Textbox


Amount value

parentSpouseOrPartnerIncomeTaxPaid

Income tax paid

Textbox


Amount value

parentSpouseOrPartnerIRARollover

IRA rollover into another IRA or qualified plan

Textbox


Amount value

parentSpouseOrPartnerITIN

N/A



Column will be blank on file. Field was consolidated with SSN field on form, to maintain current account validation processes. 

parentSpouseOrPartnerLastName

Parent spouse or partner's last name

Textbox



parentSpouseOrPartnerMiddleName

Parent spouse or partner's middle name

Textbox



parentSpouseOrPartnerPensionRollover





parentSpouseOrPartnerPhoneNumber

Parent spouse or partner's mobile phone number

Textbox



parentSpouseOrPartnerScheduleCAmount

Net profit or loss from IRS Form 1040 Schedule C

Textbox


Amount value

⚖️ parentSpouseOrPartnerSocialSecurityNumber

Parent spouse or partner’s Social Security number (SSN), Individual Taxpayer Identification Number (ITIN), or Deferred Action for Childhood Arrivals (DACA) number

Textbox

9-digit numeric value. Values may also be blank or nine zeroes (000000000)

parentSpouseOrPartnerState

State

Dropdown

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

parentSpouseOrPartnerStreetAddress

Parent spouse or partner's permanent mailing address

Textbox



parentSpouseOrPartnerSuffix

Suffix

Textbox



parentSpouseOrPartnerTaxExemptInterestIncome

Tax exempt interest income

Textbox


Amount value

parentSpouseOrPartnerTaxReturnFilingStatus

Indicate the parent spouse or partner's income tax filing status for XXXX.

Dropdown

1 = Single
2 = Married–Filing jointly
3 = Married–Filing separately
4 = Head of Household
5 = Qualifying Surviving Spouse
Blank


parentSpouseOrPartnerUntaxedPortionsOfIRADistributions

Untaxed portions of IRA distributions

Textbox


Amount value

parentSpouseOrPartnerUntaxedPortionsOfPensions

Untaxed portions of pensions

Textbox


Amount value

parentSpouseOrPartnerZipCode

Zip Code

Textbox



parentsStateofLegalResidence

Parent's State of Residence

Dropdown

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

parentState

State

Textbox

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

parentsTaxReturnFilingStatus

Indicate the parent's income tax filing status for XXXX.

Dropdown

1 = Single
2 = Married–Filing jointly
3 = Married–Filing separately
4 = Head of Household
5 = Qualifying Surviving Spouse
Blank


parentStreetAddress

Parent's permanent mailing address

Textbox



parentSuffix

Suffix

Textbox



parentsUntaxedPensions

Untaxed portions of pensions

Textbox


Amount value

parentSupplementalSecurityIncomeBenefits

Supplemental Security Income (SSI)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentsUSIncomeTaxPaid

Income tax paid

Textbox


Amount value

parentTANFBenefits

Temporary Assistance for Needy Families (TANF)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentTaxExemptInterestIncome

Tax exempt interest income

Textbox


Amount value

parentUntaxedPortionsOfIRADistributions

Untaxed portions of IRA distributions

Textbox


Amount value

parentWICBenefits

Special Supplemental Nutrition Program for Women, Infants, and Children (WIC)

Checkbox

1= Selected
Blank

Parent Federal Benefits Received option

parentZipCode

Zip Code

Textbox



permanentMailingAddress

Permanent mailing address

Textbox



personalCircumstancesNoneOfTheAbove

None of these

Checkbox

1= Selected
Blank

Personal Circumstances option

pursuingTeacherCertification

Will the student be pursuing an initial teaching certification at the elementary or secondary level?

Dropdown

1= Yes
2= No
Blank

Not shown on form if firstBachelorsDegreeBy is "No."

residencyCertificationOptionVerification


Checkbox

1= Selected
Blank

Clent custom field. 

riskOfHomelessDetermination

If the answer is "Yes," did any of the following determine the student was homeless or at risk of becoming homeless?

Checkbox

1= Yes
2= No
Blank

Other Circumstances question

schoolList

N/A

Text Only


Client custom field. Text only. Column is blank in file for all clients.

senateBill13033

N/A

Text Only


Client custom field. Text only. Column is blank in file for all clients.

specialCircumstancesApproved

N/A



Client custom field. 

spouseAdjustedGrossIncome

Adjusted gross income

Textbox


Amount value

spouseCity

City

Textbox



spouseDateOfBirth

Spouse's date of birth

Date



spouseDeductiblePaymentsToIRAKeoghOther

IRA deductions and payments to self-employed SEP, SIMPLE, and qualified plans

Textbox


Amount value

spouseEducationCredits

Education credits (American Opportunity and Lifetime Learning credits)

Textbox


Amount value

spouseEmailAddress

Spouse's email address

Textbox



spouseFiled1040or1040NR

Did or will the student spouse file a XXXX IRS Form 1040 or 1040-NR?

Radio Button

1= Yes
2= No
Blank


spouseFiledNonUSTaxReturn

Did the spouse earn income in a foreign country in XXXX, were they employed by an international organization but not required to report their income on any tax return, or did they file a tax return with Puerto Rico or another U.S. territory?

Radio Button

1= Yes
2= No
Blank


spouseFiledScheduleABDEForH

Did the student spouse file a schedule A, B, D, E, F, or H with their XXXX IRS Form 1040?

Dropdown

1= Yes
2= No
3= Don't know
Blank


spouseFirstName

Spouse's first name

Textbox



spouseForeignEarnedIncomeExclusion

Foreign earned income exclusion

Textbox


Amount value

spouseIncomeTaxPaid

Income tax paid

Textbox


Amount value

spouseIRARollover

IRA rollover into another IRA or qualified plan

Textbox


Amount value

spouseITIN

Spouse's Individual Taxpayer Identification Number (ITIN) or Deferred Action for Childhood Arrivals (DACA) number

Textbox



spouseLastName

Spouse's last name

Textbox



spouseMiddleName

Spouse's middle name

Textbox



spousePensionRollover

Pension rollover into another IRA or qualified plan

Textbox


Amount value

spousePhoneNumber

Spouse's mobile phone number

Textbox



spouseScheduleCAmount

Net profit or loss from IRS Form 1040 Schedule C

Textbox


Amount value

spousesIncomeEarnedFromWork

Income earned from work

Textbox


Amount value

⚖️ spouseSocialSecurityNumber

Spouse's Social Security number (SSN)

Textbox

9-digit numeric value. Values may also be blank or nine zeroes (000000000)

spouseState

State

Dropdown

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

spouseStreetAddress

Spouse's permanent mailing address




spouseSuffix

Suffix

Textbox



spouseTaxExemptInterestIncome

Tax exempt interest income

Textbox


Amount value

spouseTaxReturnFilingStatus

Indicate the student spouse's income tax filing status for $App.Fay(-3).

Dropdown

1 = Single
2 = Married–Filing jointly
3 = Married–Filing separately
4 = Head of Household
5 = Qualifying Surviving Spouse
Blank


spouseUntaxedPortionsOfIRADistributions

Untaxed portions of IRA distributions

Textbox


Amount value

spouseUntaxedPortionsOfPensions

Untaxed portions of pensions

Textbox


Amount value

spouseZipCode

Zip Code

Textbox



stateTuitionRatesIneligle


Text Only


Client custom field. Text only. Column is blank in file for all clients.

studentDeductiblePaymentsToIRAKeoghOther

IRA deductions and payments to self-employed SEP, SIMPLE, and qualified plans

Textbox


Amount value

studentEarnedIncomeTaxCreditReceivedDuringTaxYear

Did the student receive the earned income tax credit (EITC)?

Dropdown

1= Yes
2= No
3= Don't know
Blank


studentEthnicity

Describe the student’s ethnicity.

Textbox



studentFederalBenefitsNoneOfTheAbove

None of these

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentFiled1040or1040NR

Did or will the student file a XXXX IRS Form 1040 or 1040-NR?

Radio Button

1= Yes
2= No
Blank


studentFiledJointReturnWithCurrentSpouse

Did or will the student file a XXXX joint tax return with their current spouse?

Radio Button

1= Yes
2= No
Blank


studentFiledNonUSTaxReturn

Did the student earn income in a foreign country in XXXX, were they employed by an international organization but not required to report their income on any tax return, or did they file a tax return with Puerto Rico or another U.S. territory?

Radio Button

1= Yes
2= No
Blank


studentFiledScheduleABDEForH

Did the student file a schedule A, B, D, E, F, or H with their XXXX IRS Form 1040?

Dropdown

1= Yes
2= No
3= Don't know
Blank


studentforeignEarnedIncomeExclusion

Foreign earned income exclusion

Textbox


Amount value

studentFreeOrReducedPriceSchoolLunchBenefits

Free or reduced-price school lunch

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentGender

What is the student’s gender?

Dropdown

1= Male
2= Female
3= Nonbinary
4= Prefer not to answer


studentIRARollover

IRA rollover into another IRA or qualified plan

Textbox


Amount value

studentITIN

Individual Taxpayer Identification Number (ITIN) or Deferred Action for Childhood Arrivals (DACA) number

Textbox



studentNameSuffix

Suffix

Textbox



studentPensionRollover

Pension rollover into another IRA or qualified plan

Textbox


Amount value

studentRace

What is the student’s race?

Checkbox

1= White
2= Black or African American
3= Asian
4= American Indian or Alaska Native
5= Native Hawaian or Other Pacific Islander
6= Prefer not to answer

Multiple responses are displayed in file as comma separated

studentReceivedEITC

Earned income tax credit (EITC)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentReceivedFederalHousingAssistance

Federal housing assistance

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentReceivedMedicaid

Medicaid

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentReceivedRefundableCreditFor36BHealthPlan

Refundable credit for coverage under a qualified health plan (QHP)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentReceivedSNAP

Supplemental Nutrition Assistance Program (SNAP)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentsAdjustedGrossIncomeFromIRSForm

Adjusted gross income

Textbox


Amount value

studentsBusinessAndOrInvestmentFarmNetWorth

Current net worth of businesses and investment farms

Textbox


Amount value

studentsCashSavingsAndChecking

Current total of cash, savings, and checking accounts

Textbox


Amount value

studentScheduleCAmount

Net profit or loss from IRS Form 1040 Schedule C

Textbox


Amount value

studentsChildSupportReceived

Annual Child Support Received

Textbox


Amount value

studentsDateofBirth

Date of Birth

MMDDYYYY Dropdown Date


Validation is for date between "today's date minus 15" and 'today's date minus ninety-one"

studentsEducationalCredits

Education credits (American Opportunity and Lifetime Learning credits)

Textbox


Amount value

studentsEmailAddress

Email address

Textbox



studentsGrantOrScholarshipAid

Amount of college grants or scholarships reported as income to the IRS

Textbox


Amount value

studentSignatureDate

N/A




studentSignatureLocation

N/A



If configured, City and State where student e-signed form

studentSignatureName

N/A




studentsIncomeEarnedFromWork

Income earned from work

Textbox


Amount value

studentsInvestmentNetWorth

Current net worth of investments, including real estate

Textbox


Amount value

studentsLegalResidenceDate

Month and year student became a full-time resident of the state/country indicated.

MMDDYYYY Dropdown Date

XX/XX/XXXX

Validation is for date between "today's date" and 'today's date minus ninety"

studentsMaritalStatus

Student Marital Status

Dropdown

1= Single
2= Married
3= Remarried
4= Separated
5= Divorced
6= Widowed

Note: Update needed to align option values with ISIR option values. 

studentsNumberinCollege

How many people in the student's family, including the student, will be in college between July 1, XXXX and June 30, XXXX?

Dropdown

1 through 9


studentsPermanentCity

City

Textbox



studentsPermanentPhoneNumber

Mobile phone number

Textbox



studentsPermanentState

State

Dropdown

Two-character state code

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

studentsPermanentZipCode

Zip Code

Textbox



studentsStateofLegalResidence

Student's State of Residence

Dropdown

Two-letter state code

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

studentsTaxReturnFilingStatus

Indicate the student's income tax filing status for XXXX.

Dropdown

1 = Single
2 = Married–Filing jointly
3 = Married–Filing separately
4 = Head of Household
5 = Qualifying Surviving Spouse
Blank


studentsUntaxedPensions

Untaxed portions of pensions

Textbox


Amount value

studentSupplementalSecurityIncomeBenefits

Supplemental Security Income (SSI)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentsUSIncomeTaxPaid

Income tax paid

Textbox


Amount value

studentTANFBenefits

Temporary Assistance for Needy Families (TANF)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

studentTaxExemptInterestIncome

Tax exempt interest income

Textbox


Amount value

studentUnaccompaniedHomelessYouthUnaccompaniedAtRiskofHomelessnessAndSelfSupporting

At any time on or after July 1, XXXX, was the student unaccompanied and either (1) homeless or (2) self-supporting and at risk of being homeless?

Dropdown

1= Yes
2= No
Blank

Other Circumstances question

studentUntaxedPortionsOfIRADistributions

Untaxed portions of IRA distributions

Textbox


Amount value

studentUpdatedFamilySize

How many people are in the student's family?

Dropdown

1 through 20


studentWICBenefits

Special Supplemental Nutrition Program for Women, Infants, and Children (WIC)

Checkbox

1= Selected
Blank

Student Federal Benefits Received option

transactionNumber

N/A




unaccompaniedAndHomelessFAA

Financial aid administrator (FAA)

Checkbox

1= Selected
Blank

Other Circumstances option

unaccompaniedAndHomelessGeneral

Director or designee of an emergency or transitional shelter, street outreach program, homeless youth drop-in center, or other program serving those experiencing homelessness.

Checkbox

1= Selected
Blank

Other Circumstances option

unaccompaniedAndHomelessHS

The student's high school or school district homeless liaison or designee.

Checkbox

1= Selected
Blank

Other Circumstances option

unaccompaniedAndHomelessTRIO

Director or designee of a project supported by a federal TRIO or GEAR UP program grant.

Checkbox

1= Selected
Blank

Other Circumstances option

unsubOnly

Are the student's parents unwilling to provide their information, but the student does not have an unusual circumstance that prevents them from contacting the parents or obtaining their information?

Radio Button

1= Yes
2= No
Blank

Unusual Circumstances question

unusualCircumstance

Do unusual circumstances prevent the student from contacting their parents or would contacting their parents pose a risk to the student?

Radio Button

1= Yes
2= No
Blank

Unusual Circumstances question

veteranofUSArmedForces

The student is a veteran of the U.S. armed forces.

Checkbox

1= Selected
Blank

Personal Circumstances option

WAInStateTuitionRates


Text Only


Client custom field. Text only. Column is blank in file for all clients.

WAInStateTuitionRatesIneligible


Text Only


Client custom field. Text only. Column is blank in file for all clients.

WAorphanOrWardOfCourtOrFosterCareCommentCode166


Text Only


Client custom field. Text only. Column is blank in file for all clients.

wardOfCourt

At any time since the student turned age 13, they were a ward of the court.

Checkbox


Personal Circumstances option

WAResidencyDACAStatus


Radio Button

1= Yes
2= No
Blank

Client custom field. 

transactionDataSourceTypeCode

N/A

3= FAFSA Partner Portal

Client requested ISIR fields populate default data for importing into other systems.

transactionType

N/A

A= Application

transactionLanguage

N/A

E= English

applicationDataSourceTypeCode

N/A

3= FAFSA Partner Portal

The table above can be downloaded as an Excel file here:

View file
name2024-2025 Master Access Database Extract File Layout and Field Mapping.xlsx

Notes

Multiple FAYs can be represented on the Access Database Extract File at the same time, but the table below shows only columns applicable to the 23-24 form.

Note: fields listed below are not in layout order of the CSV file.

Note: For clients who make application corrections via import file, this table can be used to identify column names that correspond to 23-24 questions. Uncorrectable fields can be identified by a N/A in the ‘Field on Form’ column or by a ‘Client custom field’ entry in the Notes column, for questions not applicable to the client’s form.

Expand
titleClick here to expand for the 2023-2024 Access Database Extract File (CSV) layout and field mapping

The table below represents the file Access Database Extract File layout and field mapping for the 2023-2024 Access master form.  To be added.

Column Name on File

Field on Form

Field Type on Form

Valid Values

Column Name on File

Field on Form

Field Type on Form

Valid Values

Notes

academicYear

N/A

 

 

 

academicYearRange

N/A

 

 

 

areYouMaleOrFemale

Are you male or female?

Dropdown 

1-Male;2-Female;

 

areYouOnActiveDutyInUSArmedForces

Are you currently serving on active duty in the U.S. Armed Forces or are a National Guard or Reserves enlistee called into federal active duty for purposes other than training?

Radio Button

1-Yes;2-No;

 

asofTodayAnEmancipatedMinor

Are you now or were you an emancipated minor (released from control by his or her parent or guardian) as determined by a court in your state of legal residence?

Radio Button

1-Yes;2-No;

 

asofTodayInLegalGuardianship

Does someone other than your parent or stepparent have legal guardianship of you, as determined by a court in your state of legal residence? 

Radio Button

1-Yes;2-No;

 

atRiskOfHomelessness

At any time on or after July 1, XXXX, did the director of a runaway or homeless youth basic center or transitional living program determine that you were an unaccompanied youth  who was homeless or was self-supporting and at risk of being homeless?

Radio Button

1-Yes;2-No;

 

bannerPrimaryBackgroundColor

N/A

 

 

 

bannerPrimaryForegroundColor

N/A

 

 

 

bannerSecondaryBackgroundColor

N/A

 

 

 

bannerSecondaryForegroundColor

N/A

 

 

 

certificationIntroduction

N/A

Text Only

 

 

certificationOptionA

 

Radio Button

1-Yes;2-No;

Client custom field.

certificationOptionB

 

Radio Button

1-Yes;2-No;

Client custom field.

certificationOptionC

 

Radio Button

1-Yes;2-No;

Client custom field.

certificationPermanentResidency

 

Radio Button

1-Yes;2-No;

Client custom field.

certifyPermandentResidencyApplication

N/A

Text Only

 

Client custom field. Text only. Column is blank in file for all clients.

contentWidth

N/A

Textbox

 

 

degreeCertificate

What college degree or certificate will you be working on when you begin the XXXX-XXXX school year?

Dropdown

1-1st Bachelors Degree;2-2nd Bachelors Degree;3-Associate Technical Degree;4-General Associates Degree;5-Certificate or Diploma of less than 2 Years;6-Certificate or Diploma of at least 2 years;7-Teaching Certificate;8-Graduate or Professional;9-Other or Undecided;

 

doYouWantSelectiveServiceToRegisterYou

 

Checkbox

1-I certify that I am in compliance with federal Selective Service registration requirements. 

 

drugConvictionAffectingEligibility

Have you been convicted for a drug offense while you were receiving student aid? 

Radio Button

1-No;3-Yes;

 

encourageCreateProfile

N/A

Text Only

 

Client custom field. Text only. Column is blank in file for all clients.

fathersHighestSchoolCompleted

Highest Level of Education Parent 1 Completed

Dropdown

1-Middle school/Jr. High;2-High School;3-College or Beyond;4-Other/unknown;

 

fathersStepfathersDateofBirth

Parent 1 Date of Birth

Date

 

 

fathersStepfathersFirstName

Parent 1 First Name 

Textbox

 

 

fathersStepfathersIncomeEarnedFromWork

Parent 1 Income Earned from Working ($)

Textbox 

 

 

fathersStepfathersLastName

Parent 1 Last Name 

Textbox

 

 

fathersStepfathersSocialSecurityNumber

Parent 1 SSN

Textbox

 

 

federalSchoolCode1

School 1

Dropdown

 

 

federalSchoolCode10

School 10

Dropdown

 

 

federalSchoolCode2

School 2

Dropdown

 

 

federalSchoolCode3

School 3

Dropdown

 

 

federalSchoolCode4

School 4

Dropdown

 

 

federalSchoolCode5

School 5

Dropdown

 

 

federalSchoolCode6

School 6

Dropdown

 

 

federalSchoolCode7

School 7

Dropdown

 

 

federalSchoolCode8

School 8

Dropdown

 

 

federalSchoolCode9

School 9

Dropdown

 

 

firstBachelorsDegreeBy

Will you have your first bachelor's degree before you begin the 2023-24 school year?

Radio Button

1-Yes;2-No;

 

gradeLevelInCollege

Expected Grade Level in College

Dropdown 

0-1st Year or Freshman, Never Attended;1-1st Year or Freshman, Attended Before;2-2nd Year or Sophomore;3-3rd Year or Junior;4-4th Year or Senior;5-5th Year or More, Undergraduate;6-1st Year Graduate or Professional;7-Continuing Graduate or Professional;

 

gradeLevelInCollegeFundingMessage

N/A

Text Only

 

Text is shown/hidden based on client. Column will be blank in file for all clients.

haveChildrenYouSupport

Do you have children who will receive more than half of their support from you between July 1, XXXX and June 30, XXXX?

Radio Button

1-Yes;2-No;

 

haveLegalDependentsOtherThanChildrenOrSpouse

Do you have dependents (other than your children or spouse) who live with you and who receive more than half of their support from you, now and through June 30, XXXX?

Radio Button

1-Yes;2-No;

 

highSchoolCity

High School City

Textbox

 

 

highSchoolName

Name of High School

Textbox

 

 

highSchoolState

High School State

Dropdown 

Two-letter state code
Blank

 

houseBill1079

 

Radio Button

1
2
blank

Client custom field.

HSDiplomaOrEquivalent

High School Diploma or Equivalent

Dropdown 

1-High School Diploma from a high school;2-GED or diploma equivalent;3-Homeschooled;4-None of the Above;

 

inStateRates

N/A

Text Only

 

Client custom field. Text only. Column is blank in file for all clients.

interestedInWorkStudy

Are you interested in being considered for work-study?

Radio Button

1-Yes;2-No;3-Don't Know;

 

logoAlignment

N/A

Textbox

 

 

logoHeight

N/A

Textbox

 

 

logoUrl

N/A

Textbox

 

 

middleInitial

Middle Name

Textbox

 

 

mothersHighestSchoolCompleted

Highest Level of Education Parent 2 Completed 

Dropdown

1-Middle school/Jr. High;2-High School;3-College or Beyond;4-Other/unknown;

 

mothersStepmothersDateofBirth

Parent 2 Date of Birth

Date

 

 

mothersStepmothersFirstName

Parent 2 First Name

Textbox

 

 

mothersStepmothersIncomeEarnedFromWork

Parent 2 Income Earned from Working ($)

Textbox 

 

 

mothersStepmothersLastName

Parent 2 Last Name

Textbox

 

 

mothersStepmothersSocialSecurityNumber

Parent 2 SSN

Textbox

 

 

originalSocialSecurityNumber

Social Security, DACA, or ITIN Number

Textbox

 

 

orphanOrWardOfCourtOrFosterCare

At any time since you turned age 13, were both of your parents deceased, or were you in foster care or were you a dependent or ward of the court? 

Radio Button

1-Yes;2-No;

 

parentDislocatedWorker

As of today, are either of your parents a dislocated worker? 

Radio Button

1-Yes;2-No;3-Don't know;

 

parentFoodStampBenefits

Parents' Supplemental Nutrition Assistance Program 

Radio Button

1-Yes;2-No;

 

parentFreeorReducedPriceSchoolLunchBenefits

Parents' Free or Reduced Price School Lunch

Radio Button

1-Yes;2-No;

 

parentReceivedFederalBenefits

Did you, your parents, or anyone in your parents' household receive benefits from any federal benefit programs such as Medicaid or SSI, Supplemental Nutrition Assistance Program, Free or Reduced Price School Lunch, TANF or WIC benefits? 

Radio Button

1-Yes;2-No;

 

parentsAdjustedGrossIncomeFromIRSForm

Parents' AGI from Income Tax Return 

Textbox 

 

 

parentsBusinessAndOrInvestmentFarmNetWorth

Parents' Businesses or Farm Net Worth ($)

Textbox 

 

 

parentsCashSavingsAndChecking

Parents' Cash, Savings, and Checking Account Amounts ($)

Textbox 

 

 

parentsChildSupportPaid

Parents' Child Support Paid

Textbox 

 

 

parentsChildSupportReceived

Parents' Child Support Received

Textbox 

 

 

parentsCombatPay

Parents' Combat Pay

Textbox 

 

 

parentsCoopEarnings

Parents' Co-op Earnings

Textbox 

 

 

parentsEducationalCredits

Parents' Education Credits

Textbox 

 

 

parentsEligibilityToFileSchedule1

Parent's Eligibility to file Schedule 1

Radio Button

1-No;2-Yes;3-Don't Know;

 

parentsEmailAddress

Parents' Primary E-Mail Address

Textbox

 

 

parentsGrantOrScholarshipAid

Parents' Grant or Scholarship Aid

Textbox 

 

 

parentSignatureDate

N/A

Textbox

 

 

parentSignatureName

N/A

Textbox

 

 

parentsInterestIncome

Parents' Interest Income

Textbox 

 

 

parentsInvestmentNetWorth

Parents' Real Estate or Investment Net Worth ($)

Textbox 

 

 

parentsIRAPayments

Parents' IRA Payments 

Textbox 

 

 

parentsLegalResidenceDate

Parents' Residency Date

Date

 

 

parentsLegalResidenceDateCO

Parents' Residency Date

Date

 

 

parentsLegalResidentsBefore

Parents' Residency Before 01/01/XXXX

Radio Button

1-Yes;2-No;

 

parentsMaritalStatus

Parents' Marital Status 

Dropdown

1-Married or Remarried;2-Never Married;3-Divorced or Separated;4-Widowed;5-Unmarried and Both Parents Living Together;

 

parentsMaritalStatusDate

Parents' Marital Status Date

Date

 

 

parentsMilitaryOrClergyAllowances

Parents' Military or Clergy Allowances

Textbox 

 

 

parentsNeedBasedEmployment

Parents' Need-Based Employment

Textbox 

 

 

parentsNumberinCollegeParentsExcluded

Parents' Household Number in College

Dropdown

1-9

 

parentsNumberofFamilyMembers

Parents' Household Number of Family Members

Dropdown

1-9

 

parentsOtherUntaxedIncome

Parents' Other Untaxed Income

Textbox 

 

 

parentsPensionPayments

Parents' Pension Payments

Textbox 

 

 

parentsSecondaryEmailAddress

Parents' Secondary E-Mail Address

Textbox

 

 

parentsStateofLegalResidence

Parents' State of Residency

Dropdown

Two-letter state code
Blank

 

parentsTaxFilingStatus

Parents' Income Tax Filing Status

Dropdown

1-Single;2-Married - Filed Joint Return;3-Married - Filed Separate Return;4-Head of Household;5-Qualifying Widow(er);6-Don't Know;

 

parentsTaxReturnCompleted

Parents' Income Tax Return Status

Dropdown

1-Already Completed and Filed;2-Will File;3-Will Not File;

 

parentsTypeOfTaxFormUsed

Parents' Type of Income Tax Return

Dropdown

1-IRS 1040;3-A foreign tax return, IRS 1040NR or IRS 1040NR-EZ;4-A tax return with Puerto Rico, another U.S. Territory, or Freely Associated State;

 

parentsUntaxedPortionsOfIRADistributionsAndPensions

Parents' untaxed portions of IRA distributions and pensions

Textbox 

 

 

parentSupplementalSecurityIncomeBenefits

Parents' Medicaid SSI Benefits

Radio Button

1-Yes;2-No;

 

parentsUSIncomeTaxPaid

Parents' Taxes Paid from Income Tax Return

Textbox 

 

 

parentsVeteransNoneducationBenefits

Parents' Veterans Noneducation Benefits

Textbox 

 

 

parentsWillFileInformation

N/A

Text Only

 

 

parentTANFBenefits

Parents' TANF Benefits

Radio Button

1-Yes;2-No;

 

parentWICBenefits

Parents' WIC Benefits

Radio Button

1-Yes;2-No;

 

permanentMailingAddress

Permanent Mailing Street Address

Textbox

 

 

RegentAccess_stateCode

N/A

Textbox

 

 

residencyCertificationOptionVerification

 

Checkbox

1- selected; blank

Client custom field.

senateBill13033

N/A

Text Only

 

Client custom field. Text only. Column is blank in file for all clients.

specialCircumstances

 

Radio Button

1-I will be unable to provide parent information on this application due to special circumstances.;2-My application requires parent information before submission - continue with the application process.

 

specialCircumstancesApproved

N/A

Dropdown

 

Client Custom Field

specialCircumstancesHint

N/A

Text Only

 

 

spousesIncomeEarnedFromWork

Spouse's Income Earned From Working ($)

Textbox

 

 

stateTuitionRatesIneligle

N/A

Text Only

 

Client custom field. Text only. Column is blank in file for all clients.

studentFoodStampBenefits

Supplemental Nutrition Assistance Program

Radio Button

1-Yes;2-No;

 

studentFreeOrReducedPriceSchoolLunchBenefits

Student's Free or Reduced School Price Lunch

Radio Button

1-Yes;2-No;

 

studentHousingStatus1

Housing Plan for School 1

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus10

Housing Plan for School 10

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus2

Housing Plan for School 2

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus3

Housing Plan for School 3

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus4

Housing Plan for School 4

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus5

Housing Plan for School 5

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus6

Housing Plan for School 6

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus7

Housing Plan for School 7

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus8

Housing Plan for School 8

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentHousingStatus9

Housing Plan for School 9

Dropdown

1-On Campus;2-With Parents;3-Off Campus or Other;

 

studentLegalResidentBefore

Did you become a full-time resident of the state/country you entered above before January 1, XXXX?
#end

Radio Button

1-Yes;2-No;

 

studentOrSpouseDislocatedWorker

As of today, are you (or your spouse) a dislocated worker?

Radio Button

1-Yes;2-No;3-Don't know;

 

studentReceivedFederalBenefits

In XXXX or XXXX, did you, your spouse, or anyone in your household receive benefits from any federal benefit programs such as Medicaid or SSI, Supplemental Nutrition Assistance Program, Free or Reduced Price School Lunch, TANF or WIC benefits? Answering these questions will NOT reduce eligibility for student aid or these programs.

Radio Button

1-Yes;2-No;

 

studentsAdjustedGrossIncomeFromIRSForm

Student's AGI from Income Tax Return

Textbox

 

 

studentsBusinessAndOrInvestmentFarmNetWorth

Student's Businesses or Farm Net Worth ($)

Textbox

 

 

studentsCashSavingsAndChecking

Student's Cash, Savings, and Checking Account Amounts ($)

Textbox

 

 

studentsChildSupportPaid

Student's Child Support Paid

Textbox

 

 

studentsChildSupportReceived

Student's Child Support Received

Textbox

 

 

studentsCombatPay

Student's Combat Pay

Textbox

 

 

studentsCoopEarnings

Student's Co-op Earnings

Textbox

 

 

studentsDateofBirth

Date of Birth

Date

01/01/2000-01/01/2000;

 

studentsDriversLicenseNumber

Student's Driver's License Number

Textbox

 

 

studentsDriversLicenseStateCode

Student's Driver's License State

Dropdown 

Two-letter state code
Blank

Field options are all fifty states plus US territories, Canadian provinces, and "Foreign Country"

studentsEducationalCredits

Student's Education Credits

Textbox

 

 

studentsEligibilityToFileSchedule1

Student's Eligibility to file Schedule 1

Dropdown

1-No;2-Yes;3-Don't know;

 

studentsEmailAddress

Student’s Primary Email Address

Textbox

 

 

studentsFirstName

First Name

Textbox

 

 

studentsGrantOrScholarshipAid

Student's Grant or Scholarship Aid

Textbox

 

 

studentSignatureDate

N/A

Textbox

 

 

studentSignatureLocation

N/A

Textbox

 

 

studentSignatureName

N/A

Textbox

 

 

studentsIncomeEarnedFromWork

Student's Income Earned from Working ($)

Textbox

 

 

studentsInterestIncome

Student's Interest Income

Textbox

 

 

studentsInvestmentNetWorth

Student's Real Estate or Investment Net Worth ($)

Textbox

 

 

studentsIRAPayments

Student's IRA Payments

Textbox

 

 

studentsLastName

Last Name

Textbox

 

 

studentsLegalResidenceDate

Please provide the month and year you became a full-time resident of the state indicated. 

Date

 

 

studentsLegalResidenceDateCO

Please provide the month and year you became a full-time resident of the state indicated. 

Date

 

 

studentsMaritalStatus

Student's Marital Status

Dropdown 

1-Single;2-Married or Remarried;3-Separated; 4-Divorced or Widowed;

 

studentsMaritalStatusDate

Student's Marital Status Date

Date

 

 

studentsMilitaryOrClergyAllowances

Student's Military or Clergy Allowances 

Textbox

 

 

studentsNeedBasedEmployment

Student's Need-Based Employment 

Textbox

 

 

studentsNumberinCollege

Student's Household Number in College

Dropdown

1-9

 

studentsNumberofFamilyMembers

Student's Household Number of Family Members

Dropdown

1-20

 

studentsOtherNonReportedMoney

Student's Other Non-Reported Money Received

Textbox

 

 

studentsOtherUntaxedIncome

Student's Other Untaxed Income

Textbox

 

 

studentsPensionPayments

Student's Pension Payments

Textbox

 

 

studentsPermanentCity

Permanent Mailing City

Textbox

 

 

studentsPermanentPhoneNumber

Student’s Primary Telephone Number

Textbox

 

 

studentsPermanentState

Permanent Mailing State

Dropdown 

Two-letter state code
Blank

 

studentsPermanentZipCode

Permanent Mailing Zip Code

Textbox

 

 

studentsStateofLegalResidence

Student's State/Country of Residence

Dropdown 

Two-letter state code
Blank

 

studentsTaxFilingStatus

Student's Income Tax Filing Status

Dropdown

1-Single;2-Married - Filed Joint Return;3-Married - Filed Separate Return;4-Head of Household;5-Qualifying Widow(er);6-Don't Know;

 

studentsTaxReturnCompleted

Student's Income Tax Return Status

Dropdown

1-Already Completed and Filed;2-Will File;3-Will Not File;

 

studentsTypeofTaxFormUsed

Student's Type of Income Tax Return

Dropdown

1-IRS 1040;3-A foreign tax return, IRS 1040NR or IRS 1040NR-EZ;4-A tax return with Puerto Rico, another U.S. Territory, or Freely Associated State;

 

studentsUntaxedPortionsOfIRADistributionsAndPensions

Students' untaxed portions of IRA distributions and pensions

Textbox

 

 

studentSupplementalSecurityIncomeBenefits

Student's Medicaid or SSI Benefits

Radio Button

1-Yes;2-No;

 

studentsUSIncomeTaxPaid

Student's Taxes Paid from Income Tax Return

Textbox

 

 

studentsVeteransNoneducationBenefits

Student's Veterans Noneducational Benefits

Textbox

 

 

studentTANFBenefits

Student's TANF Benefits 

Radio Button

1-Yes;2-No;

 

studentWICBenefits

Student's WIC Benefits

Radio Button

1-Yes;2-No;

 

studentWillFileInformation

N/A

Text Only

 

 

title

N/A

Textbox

 

 

transactionNumber

N/A

Textbox

 

 

unaccompaniedYouthDeterminedByHUD

At any time on or after July 1, XXXX, did the director of an emergency shelter or transitional housing program funded by the U.S. Department of Housing and Urban Development determine that you were an unaccompanied youth who was homeless or was self-supporting and at risk of being homeless?

Radio Button

1-Yes;2-No;

 

unaccompaniedYouthDeterminedBySchoolDistrictLiaison

At any time on or after July 1, XXXX, did your high school or school district homeless liaison determine that you were an unaccompanied youth who was homeless or was self-supporting and at risk of being homeless?

Radio Button

1-Yes;2-No;

 

veteranofUSArmedForces

Are you a veteran of the U.S. Armed Forces?

Radio Button

1-Yes;2-No;

 

WAareYouMaleOrFemale

Gender

Dropdown 

1-Male;2-Female;3-X;

Client custom field

WAfirstBachelorsDegreeBy

Will you have your first bachelor’s degree before July 1, XXXX? This includes bachelors degrees earned at non-US higher education institutions.

Radio Button

1-Yes;2-No;

Client custom field.

WAInStateTuitionRates

N/A

Text Only

 

Client Custom Field. Text only. Column is blank in file for all clients.

WAInStateTuitionRatesIneligible

N/A

Text Only

 

Client Custom Field. Text only. Column is blank in file for all clients.

WAorphanOrWardOfCourtOrFosterCareCommentCode166

N/A

Text Only

 

Client Custom Field. Text only. Column is blank in file for all clients.

WAResidencyDACAStatus

 

Radio Button

1-Yes;2-No;

Client custom field

username

N/A

 

 

 

userExternalId

N/A

 

 

 

userCreatedDate

N/A

 

 

 

userLastIpAddress

N/A

 

 

 

applicationId

N/A

 

 

 

institution

N/A

 

 

 

institutionExternalId

N/A

 

 

 

campus

N/A

 

 

 

campusExternalId

N/A

 

 

 

site

N/A

 

 

 

siteExternalId

N/A

 

 

 

program

N/A

 

 

 

programExternalId

N/A

 

 

 

electronicSignatureRequiredTypeCode

N/A

 

NOTREQUIRED; ONLYPARENTSIGNATUREREQUIRED; ONLYSTUDENTSIGNATUREREQUIRED; BOTHSTUDENTANDPARENTSIGNATURESREQUIRED

 

type

N/A

 

Financial Aid Application

 

name

N/A

 

 

Name from Document Setup

status

N/A

 

 

 

createdDate

N/A

 

 

 

eSigned

N/A

 

 

 

eSignedDate

N/A

 

 

 

EFC

N/A

 

 

 

dependencyStatusCode

N/A

 

I= Independent; D= Dependent

 

dependencyStatus

N/A

 

Independent; Dependent

 

correctionProcessDate

N/A

 

 

 

The table above can be downloaded as an Excel file here:

View file
nameInvalid file id - 8a8754ba-471f-4a35-b5e3-de995b9ad7d0

Permission

The "Access Export Processes" permission is required to generate the Access Database Extract File and is located under Global Permissions → Process Permissions → Export Processes. By default, all user roles, except the Regent admin role, will NOT have access to this permission (i.e. the permission will be disabled). The permission is enabled by default for the Regent admin user role.

Access Export File in an ISIR Layout Format

...

Expand

Below is a list of all derived values for 2024-2025 ISIRs.  If no derived value is present in the list below, the ISIR Data Record Layout from the EDE Technical Reference for the appropriate award year ( e.g. 2024-2025) will be used if the field is able to be mapped.  Note: Some questions will not be mapped, such as state-specific questions.

ISIR Field Name

Derived Value

yearIndicator

Uses 4 for the 2023-2024 Award Year,  5 for 2024-2025 Award Year, etc.

⚖️ originalSocialSecurityNumber

Uses SSN if provided; otherwise uses the student externalId1 (assigned to the student by Regent Access) with prefixed 0's to derive the 9-digit social security number.

In ISIR Corrections, is a 9-digit numeric value. Value may also be blank or nine zeroes (000000000)

originalNameID

Uses the first two characters of 'studentsLastName' 

transactionNumber

Uses transactionNumber = '01' for first time application is being exported and increments the transaction number subsequent exports

studentsCitizenshipStatus

Always uses 3 for neither a U.S. Citizen or an Eligible Non-Citizen

parentsStateofLegalResidence

Uses the parentsStateofLegalResidence (if it has a value); or if parentsStateofLegalResidence is blank, uses the studentsStateofLegalResidence; or if parentsStateofLegalResidence AND studentsPermanentState are both blank, use studentsPermanentState

transactionDataSourceTypeCode

Uses '3' for FAFSA Partner Portal for initial application and corrected application.

transactionType

Uses ‘A' for the initial application and 'C’ for an application correction.

transactionLanguage

Uses 'E” for English

transactionReceiptDate

Use the current date upon the export of the Access ISIR-formatted file.

applicationDataSourceTypeCode

Uses '3' for FAFSA Partner Portal for initial application and corrected application.

applicationReceiptDate

Uses the application or the correction date.

transactionProcessedDate

Use the current date upon the export of the Access ISIR-formatted file.

correctionFlags

Always uses zeros ("0") in each of the fields.

highlightFlags

Always uses zeros ("0") in each of the fields.

commentCodes

Always uses zeros ("0") in each of the fields.

studentIsSelectedForVerification

Always uses a value of No ("N").

dependencyStatusCode

Dependency Status. For the initial 6.6.0.0 release, some "Unsub Only" students with special circumstances have the "X" values replaced with "Z" values.

Possible values: D = Dependent, I = Independent, X = Rejected Dependent (allows awarding Unsub loans only), Y = Rejected Independent, and Z = Provisional Independent (2024-2025 and later). 

⚖️ EFC/SAI

For 2024-2025 FAY and later, holds the value of the Student Aid Index (SAI). Numeric values, -1500 to 999999 or Blank

For 2023-2024 FAY and earlier, holds the value of the Expected Family Contribution (EFC).

provisionalSAI

New for 2024-2025 and later. Provisional Student Aid Index (Provisional SAI). Numeric value, calculated instead of SAI for students with a Provisional Independent dependency status ("Z").

Numeric values, -1500 to 999999 or Blank

FISAPTotalIncome

Total Income for FISAP (Fiscal Operations Report and Application to Participate). Sum of Parents' Total Income and Student/Spouse Total Income.

Numeric Integer, up to 15 characters including a negative sign, can be negative or blank. Values -99999999999999 to 99999999999999 Blank

Filler (Access Field: AccessISIR)

A value of 1 will be present in the first position of this filler space and is able to be used to identify the ISIR is an Access ISIR, if Regent Access is enabled. 

Filler (Access Field: mainFederalSchoolCode)

A six-digit Federal School Code will be present beginning with the second position of this filler space and is able to be used to identify the school code to which the file is being routed, if Regent Access is enabled. 

Filler (Access Field: studentExternalId)

The Regent Award studentExternalId for the default Institution (e.g. state-level) will be present if Regent Access is enabled and right justified and allow up to 60 characters in length. 

Filler (Access Field: snapApplicationID)

The snapApplicationId on the Access ISIR provides a link between the ISIR ↔︎ and SNAP Application data for REM to use in the display as needed.  Allows up to 15 digits.

⚖️ parentSocialSecurityNumber

If value entered on form for Parent Social Security Number begins with any digit other than a '9', the entered value will map to this field. If value entered on form for Parent Social Security Number begins with a '9', the entered value will map to parentITIN.

Value may also be blank or nine zeroes (000000000)

⚖️ parentSpouseOrPartnerSocialSecurityNumber

If value entered on form for Parent Spouse or Partner Social Security Number begins with any digit other than a '9', the entered value will map to this field. If value entered on form for Parent Spouse or Partner Social Security Number begins with a '9', the entered value will map to parentSpouseOrPartnerITIN.

Value may also be blank or nine zeroes (000000000)

parentITIN

Mapped from parentSocialSecurityNumber field if value entered on form for Parent Social Security Number begins with a '9'.

⚖️ parentSpouseOrPartnerITIN

Mapped from parentSpouseOrPartnerSocialSecurityNumber field if value entered on form for Parent Spouse or Partner Social Security Number begins with a '9'.

Value may also be blank or nine zeroes (000000000)

Regent Access clients are responsible for determining the criteria and process in which an Access ISIR file is matched to students in their system if the student does not have a social security number or ITIN/DACA number (e.g. name, date of birth, and address).

Permission

The "Export eAccess ISIR Format" permission is required to generate the Access Export file in an ISIR Layout Format and is located under Global Permissions → Process Permissions → Export Processes. By default, all user roles, except the Regent admin role, will NOT have access to this permission (i.e. the permission will be disabled). The permission is enabled by default for the Regent admin user role.


Expand
titleChange Log

Change Log

Date

Editor

Description of Change

December 21, 2023

Jennifer Black

Added four fields to field mapping for 6.6.0.0 release: dependencyStatusCode, efc, provisionalSAI, and FISAPTotalIncome.

Also added this Change Log to the preexisting page.

December 27, 2023

Heather Smith

Updated with Access Database Extract File table reflecting 24-25 data and updated table with derived values for ISIR format file mapping to reflect only 24-25 fields

February 28, 2024

Bianca Bagwell

Updated Access Database Extract File Layout and Mapping Column Header from EFC to SAI for 2024-2025

March 5, 2024

Jennifer Black

Added notes for SSN fields that values may also be blank or nine zeroes (000000000): originalSocialSecurityNumber, parentSocialSecurityNumber, parentSpouseOrPartnerSocialSecurityNumber, spouseSocialSecurityNumber.

May 10, 2024

Heather Smith

Updated incorrect/missing ISIR file derived values

July 12, 2024

Heather Smith

Added ISIR-related fields to ISIR Layout Format values table per 6.8 update


...