FND Design Data [Home] [Help]

Lookup Type: IGF_SAR_FIELD_MAP

Product: IGF - Financial Aid
Meaning: SAR Column Mapping
Description: SAR Column Mapping
Quick Codes
Code Meaning Description
1 Student's Last Name LAST_NAME
10 Phone Number PHONE_NUMBER
100 Preparer's Social Security Number PREPARER_SSN
101 Employee Number of Preparer PREPARER_EMP_ID_NUMBER
102 Preparer's Signature PREPARER_SIGN
103 Transaction Receipt Date TRANSACTION_RECEIPT_DATE
104 Dependency Override Indicator DEPENDENCY_OVERRIDE_IND
105 Family Contribution Adjustment FAA_ADJUSTMENT
106 FAA Federal School Code FAA_FEDRAL_SCHL_CODE
11 Driver's License Number DRIVER_LICENSE_NUMBER
110 Last Name/SSN Change SSN_NAME_CHANGE
111 Early Analysis Flag EARLY_ANALYSIS_FLAG
112 Data Release Number DRN
114 Student Email Address S_EMAIL_ADDRESS
12 Driver's License State Code DRIVER_LICENSE_STATE
13 Student Citizenship Status CITIZENSHIP_STATUS
14 Alien Registration Number ALIEN_REG_NUMBER
15 Marital Status S_MARITAL_STATUS
16 Marital Status Date S_MARITAL_STATUS_DATE
17 Enrollment Plan for Summer SUMM_ENRL_STATUS
18 Enrollment Plan for Fall FALL_ENRL_STATUS
19 Enrollment Plan for Winter WINTER_ENRL_STATUS
2 Student's First Name FIRST_NAME
20 Enrollment Plan for Spring SPRING_ENRL_STATUS
21 Enrollment Plan for Next Year Summer SUMM2_ENRL_STATUS
22 Father's Highest Education Level FATHERS_HIGHEST_EDU_LEVEL
23 Mother's Highest Education Level MOTHERS_HIGHEST_EDU_LEVEL
24 State of Legal residence S_STATE_LEGAL_RESIDENCE
25 Legal Residence Before 1/1/95 LEGAL_RESIDENCE_BEFORE_DATE
26 Legal Residence Date S_LEGAL_RESD_DATE
27 Male SS_R_U_MALE
28 Selective Service Registration SELECTIVE_SERVICE_REG
29 Degree/Certification DEGREE_CERTIFICATION
3 Student's Middle Name MIDDLE_INITIAL
30 Grade Level in College GRADE_LEVEL_IN_COLLEGE
31 High School Diploma GED HIGH_SCHOOL_DIPLOMA_GED
32 First Bachelor Degree by Date FIRST_BACHELOR_DEG_BY_DATE
33 Interested in Student Loan INTEREST_IN_LOAN
34 Interested in Student Employment INTEREST_IN_STUD_EMPLOYMENT
35 Drug Offence Conviction DRUG_OFFENCE_CONVICTION
36 Tax Return Status S_TAX_RETURN_STATUS
37 Type S_TYPE_TAX_RETURN
38 Eligible for 1040A/EZ S_ELIG_1040EZ
39 Adjusted Gross Income S_ADJUSTED_GROSS_INCOME
4 Student's Address PERM_MAIL_ADD
40 Federal Taxes Paid S_FED_TAXES_PAID
41 Exemptions S_EXEMPTIONS
42 Student's Income from work S_INCOME_FROM_WORK
43 Spouse's Income from Work SPOUSE_INCOME_FROM_WORK
44 Worksheet A S_TOA_AMT_FROM_WSA
45 Worksheet B S_TOA_AMT_FROM_WSB
46 Worksheet C S_TOA_AMT_FROM_WSC
47 Investment Net worth S_INVESTMENT_NETWORTH
48 Business Net worth S_BUSI_FARM_NETWORTH
49 Cash Saving & Checking S_CASH_SAVINGS
5 City PERM_CITY
50 VA Months VA_MONTHS
51 VA Amount VA_AMOUNT
52 Born Before 01/01/77 STUD_DOB_BEFORE_DATE
53 Graduate/Professional Student in Current Year DEG_BEYOND_BACHELOR
54 Married S_MARRIED
55 Children S_HAVE_CHILDREN
56 Legal Dependents other than Spouse LEGAL_DEPENDENTS
57 Orphan or Ward of Court ORPHAN_WARD_OF_COURT
58 Veteran S_VETERAN
59 Parents' Marital Status P_MARITAL_STATUS
6 State PERM_STATE
60 Father's SSN FATHER_SSN
61 Father's Last Name F_LAST_NAME
62 Mother's SSN MOTHER_SSN
63 Mother's Last Name M_LAST_NAME
64 Parents' Number of Family Members P_NUM_FAMILY_MEMBER
65 Parents' number in college P_NUM_IN_COLLEGE
66 Parents' State of Legal residence P_STATE_LEGAL_RESIDENCE
67 Parents' Legal residence Before 1/1/96 P_STATE_LEGAL_RES_BEFORE_DT
68 Parents' Legal Residence Date P_LEGAL_RES_DATE
69 Age of Older Parent AGE_OLDER_PARENT
7 Zip Code PERM_ZIP_CODE
70 Parents' Tax Return Status P_TAX_RETURN_STATUS
71 Parents' Type of Tax Form Used P_TYPE_TAX_RETURN
72 Parent Eligible to File 1040/EZ P_ELIG_1040AEZ
73 Parents' Adjusted Gross Income P_ADJUSTED_GROSS_INCOME
74 Parents' Federal Taxes Paid P_TAXES_PAID
75 Parents' Exemptions Claimed P_EXEMPTIONS
76 Father's/Step Father's Income from work F_INCOME_WORK
77 Mother's/Step Mother's Income From Work M_INCOME_WORK
78 Parents' total Income from Worksheet A P_INCOME_WSA
79 Parents' Income from Worksheet B P_INCOME_WSB
8 SSN CURRENT_SSN
80 Parents' Income from Worksheet C P_INCOME_WSC
81 Parents' Investment Net worth P_INVESTMENT_NETWORTH
82 Parents' Business / Farm Net worth P_BUSINESS_NETWORTH
83 Parents' Cash,Savings and Checking P_CASH_SAVING
84 Student's Number of family Members S_NUM_FAMILY_MEMBERS
85 Student's Number in College S_NUM_IN_COLLEGE
86 Federal School Code #1 FIRST_COLLEGE
87 Federal School Code #1 Housing Plan FIRST_HOUSE_PLAN
88 Federal School Code #2 SECOND_COLLEGE
89 Federal School Code #2 Housing Plan SECOND_HOUSE_PLAN
9 Date of Birth DATE_OF_BIRTH
90 Federal School Code #3 THIRD_COLLEGE
91 Federal School Code #3 Housing Plan THIRD_HOUSE_PLAN
92 Federal School Code #4 FOURTH_COLLEGE
93 Federal School Code #4 Housing Plan FOURTH_HOUSE_PLAN
94 Federal School Code #5 FIFTH_COLLEGE
95 Federal School Code #5 Housing Plan FIFTH_HOUSE_PLAN
96 Federal School Code #6 SIXTH_COLLEGE
97 Federal School Code #6 Housing Plan SIXTH_HOUSE_PLAN
98 Date Application Completed DATE_APP_COMPLETED
99 Students Email Address S_EMAIL_ADDRESS