eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Lookup Type: IGF_AP_SAR_FIELD_MAP

Product:	IGF - Financial Aid
Meaning:	ISIR SAR Column Mapping
Description:	ISIR SAR Column Mapping

Quick Codes

Code	Meaning	Description
AGE_OLDER_PARENT	Age of Older Parent	Age of Older Parent
ALIEN_REG_NUMBER	Alien Registration Number	Alien Registration Number
CITIZENSHIP_STATUS	Student Citizenship Status	Student Citizenship Status
CURRENT_SSN	Current SSN	Current SSN
DATE_APP_COMPLETED	Date Application Completed	Date Application Completed
DATE_OF_BIRTH	Date of Birth	Date of Birth
DEGREE_CERTIFICATION	Degree/Certification	Degree/Certification
DEG_BEYOND_BACHELOR	Graduate/Professional Student in Current Year	Graduate/Professional Student in Current Year
DEPENDENCY_OVERRIDE_IND	Dependency Override Indicator	Dependency Override Indicator
DRIVER_LICENSE_NUMBER	Driver's License Number	Driver's License Number
DRIVER_LICENSE_STATE	Driver's License State Code	Driver's License State Code
DRN	Data Release Number	Data Release Number
DRUG_OFFENCE_CONVICTION	Drug Offence Conviction	Drug Offence Conviction
EARLY_ANALYSIS_FLAG	Early Analysis Flag	Early Analysis Flag
FAA_ADJUSTMENT	FAA Adjustment	FAA Adjustment
FAA_FEDRAL_SCHL_CODE	FAA Federal School Code	FAA Federal School Code
FALL_ENRL_STATUS	Enrollment Plan for Fall	Enrollment Plan for Fall
FATHERS_HIGHEST_EDU_LEVEL	Father's Highest Education Level	Father's Highest Education Level
FATHER_FIRST_NAME_INITIAL_TXT	Father's/Stepfather's First Name Initial	Father's/Stepfather's First Name Initial
FATHER_SSN	Father's SSN	Father's SSN
FATHER_STEP_FATHER_BIRTH_DATE	Father's/Stepfather's Date of Birth	Father's/Stepfather's Date of Birth
FIFTH_COLLEGE	Federal School Code #5	Federal School Code #5
FIFTH_HOUSE_PLAN	Federal School Code #5 Housing Plan	Federal School Code #5 Housing Plan
FIRST_BACHELOR_DEG_BY_DATE	First Bachelor Degree by Date	First Bachelor Degree by Date
FIRST_COLLEGE	Federal School Code #1	Federal School Code #1
FIRST_HOUSE_PLAN	Federal School Code #1 Housing Plan	Federal School Code #1 Housing Plan
FIRST_NAME	First Name	First Name
FOURTH_COLLEGE	Federal School Code #4	Federal School Code #4
FOURTH_HOUSE_PLAN	Federal School Code #4 Housing Plan	Federal School Code #4 Housing Plan
F_INCOME_WORK	Father's/Step Father's Income from work	Father's/Step Father's Income from work
F_LAST_NAME	Father's Last Name	Father's Last Name
GRADE_LEVEL_IN_COLLEGE	Grade Level in College	Grade Level in College
HIGH_SCHOOL_DIPLOMA_GED	High School Diploma GED	High School Diploma GED
INTEREST_IN_LOAN	Interested in Student Loan	Interested in Student Loan
INTEREST_IN_STUD_EMPLOYMENT	Interested in Student Employment	Interested in Student Employment
LAST_NAME	Last Name	Last Name
LEGAL_DEPENDENTS	Legal Dependents other than Spouse	Legal Dependents other than Spouse
LEGAL_RESIDENCE_BEFORE_DATE	Legal Resident Before corresponding year	Legal Resident Before corresponding year
MIDDLE_INITIAL	Middle Name	Middle Name
MOTHERS_HIGHEST_EDU_LEVEL	Mother's Highest Education Level	Mother's Highest Education Level
MOTHER_FIRST_NAME_INITIAL_TXT	Mother's/Stepmother's First Name Initial	Mother's/Stepmother's First Name Initial
MOTHER_SSN	Mother's SSN	Mother's SSN
MOTHER_STEP_MOTHER_BIRTH_DATE	Mother's/Stepmother's Date of Birth	Mother's/Stepmother's Date of Birth
M_INCOME_WORK	Mother's/Step Mother's Income From Work	Mother's/Step Mother's Income From Work
M_LAST_NAME	Mother's Last Name	Mother's Last Name
ORPHAN_WARD_OF_COURT	Orphan or Ward of Court	Orphan or Ward of Court
PARENTS_EMAIL_ADDRESS_TXT	Parent's E-mail Address	Parent's E-mail Address
PARENT_MARITAL_STATUS_DATE	Parents' Marital Status Date	Parents' Marital Status Date
PERM_CITY	Permanent City	Permanent City
PERM_MAIL_ADD	Permanent Address	Permanent Address
PERM_STATE	Permanent State	Permanent State
PERM_ZIP_CODE	Permanent Zip Code	Permanent Zip Code
PHONE_NUMBER	Phone Number	Phone Number
PREPARER_EMP_ID_NUMBER	Employee Number of Preparer	Employee Number of Preparer
PREPARER_SIGN	Preparer's Signature	Preparer's Signature
PREPARER_SSN	Preparer's Social Security Number	Preparer's Social Security Number
P_ADJUSTED_GROSS_INCOME	Parents' Adjusted Gross Income	Parents' Adjusted Gross Income
P_BUSINESS_NETWORTH	Parents' Business / Farm Net worth	Parents' Business / Farm Net worth
P_CASH_SAVING	Parents' Cash,Savings and Checking	Parents' Cash,Savings and Checking
P_ELIG_1040AEZ	Parent Eligible to File 1040/EZ	Parent Eligible to File 1040/EZ
P_EXEMPTIONS	Parents' Exemptions Claimed	Parents' Exemptions Claimed
P_INCOME_WSA	Parents' total Income from Worksheet A	Parents' total Income from Worksheet A
P_INCOME_WSB	Parents' Income from Worksheet B	Parents' Income from Worksheet B
P_INCOME_WSC	Parents' Income from Worksheet C	Parents' Income from Worksheet C
P_INVESTMENT_NETWORTH	Parents' Investment Net worth	Parents' Investment Net worth
P_LEGAL_RES_DATE	Parents' Legal Residence Date	Parents' Legal Residence Date
P_MARITAL_STATUS	Parents' Marital Status	Parents' Marital Status
P_NUM_FAMILY_MEMBER	Parents' Number of Family Members	Parents' Number of Family Members
P_NUM_IN_COLLEGE	Parents' number in college	Parents' number in college
P_STATE_LEGAL_RESIDENCE	Parents' State of Legal residence	Parents' State of Legal residence
P_STATE_LEGAL_RES_BEFORE_DT	Parents' Legal Residents Before corresponding year	Parents' Legal Residents Before corresponding year
P_TAXES_PAID	Parents' Federal Taxes Paid	Parents' Federal Taxes Paid
P_TAX_RETURN_STATUS	Parents' Tax Return Status	Parents' Tax Return Status
P_TYPE_TAX_RETURN	Parents' Type of Tax Form Used	Parents' Type of Tax Form Used
SECOND_COLLEGE	Federal School Code #2	Federal School Code #2
SECOND_HOUSE_PLAN	Federal School Code #2 Housing Plan	Federal School Code #2 Housing Plan
SELECTIVE_SERVICE_REG	Selective Service Registration	Selective Service Registration
SIGNED_BY	Signed By	Signed By
SIXTH_COLLEGE	Federal School Code #6	Federal School Code #6
SIXTH_HOUSE_PLAN	Federal School Code #6 Housing Plan	Federal School Code #6 Housing Plan
SPOUSE_INCOME_FROM_WORK	Spouse's Income from Work	Spouse's Income from Work
SPRING_ENRL_STATUS	Enrollment Plan for Spring	Enrollment Plan for Spring
SSN_NAME_CHANGE	Last Name/SSN Change	Last Name/SSN Change
SS_R_U_MALE	Are You male?	Are You male?
STUD_DOB_BEFORE_DATE	Born Before corresponding Year	Born Before corresponding Year
SUMM2_ENRL_STATUS	Enrollment Plan for Next Year Summer	Enrollment Plan for Next Year Summer
SUMM_ENRL_STATUS	Enrollment Status	Enrollment Status
S_ADJUSTED_GROSS_INCOME	Adjusted Gross Income	Adjusted Gross Income
S_BUSI_FARM_NETWORTH	Business Net worth	Business Net worth
S_CASH_SAVINGS	Cash Saving & Checking	Cash Saving & Checking
S_ELIG_1040EZ	Eligible for 1040A/EZ	Eligible for 1040A/EZ
S_EMAIL_ADDRESS	Student Email Address	Student Email Address
S_EXEMPTIONS	Exemptions	Exemptions
S_FED_TAXES_PAID	Federal Taxes Paid	Federal Taxes Paid
S_HAVE_CHILDREN	Does Student have children	Does Student have children
S_INCOME_FROM_WORK	Income from work	Income from work
S_INVESTMENT_NETWORTH	Investment Net worth	Investment Net worth
S_LEGAL_RESD_DATE	Legal Residence Date	Legal Residence Date
S_MARITAL_STATUS	Student's Marital Status	Student's Marital Status
S_MARITAL_STATUS_DATE	Student's Marital Status Date	Student's Marital Status Date
S_MARRIED	Is Student Married	Is Student Married
S_NUM_FAMILY_MEMBERS	Student's Number of family Members	Student's Number of family Members
S_NUM_IN_COLLEGE	Student's Number in College	Student's Number in College
S_STATE_LEGAL_RESIDENCE	State of Legal residence	State of Legal residence
S_TAX_RETURN_STATUS	Tax Return Status	Tax Return Status
S_TOA_AMT_FROM_WSA	Total Amount from Worksheet A	Total Amount from Worksheet A
S_TOA_AMT_FROM_WSB	Total Amount from Worksheet B	Total Amount from Worksheet B
S_TOA_AMT_FROM_WSC	Total Amount from Worksheet C	Total Amount from Worksheet C
S_TYPE_TAX_RETURN	Tax Return Type	Tax Return Type
S_VETERAN	Veteran	Veteran
THIRD_COLLEGE	Federal School Code #3	Federal School Code #3
THIRD_HOUSE_PLAN	Federal School Code #3 Housing Plan	Federal School Code #3 Housing Plan
TRANSACTION_RECEIPT_DATE	Transaction Receipt Date	Transaction Receipt Date
VA_AMOUNT	Veteran Allowance Amount	Veteran Allowance Amount
VA_MONTHS	Veteran Allowance Months	Veteran Allowance Months
WINTER_ENRL_STATUS	Enrollment Plan for Winter	Enrollment Plan for Winter