ISIR_STUDENT

(SQL Table)
 Index Back

Fed Student Application Data

This record houses all the data from the Free Application for Federal Student Aid (FAFSA). This table is effective dated to allow for changes to the application over time.

  • Parent record: ISIR_CONTROL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: ISIR_CONTROL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

    Default Value: 1

    7 NUM_FAMILY_MEMBERS Character(2) VARCHAR2(2) NOT NULL Nbr in Family
    8 DFLT_NUM_FAM_IND Character(1) VARCHAR2(1) NOT NULL Nbr Family Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    9 NUMBER_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    10 DFLT_NUM_COLL_IND Character(1) VARCHAR2(1) NOT NULL Nbr in College Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    11 DOB_PRIOR Character(1) VARCHAR2(1) NOT NULL DOB Before 1/1/74
    1=Yes
    2=No
    12 DFLT_DOB_PRIOR_IND Character(1) VARCHAR2(1) NOT NULL DOB Prior Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    13 VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran
    1=Yes
    2=No
    14 GRADUATE_STUDENT Character(1) VARCHAR2(1) NOT NULL Grad Student
    1=Yes
    2=No
    15 MARRIED Character(1) VARCHAR2(1) NOT NULL Student Married
    1=Yes
    2=No
    16 DFLT_MARRIED_IND Character(1) VARCHAR2(1) NOT NULL Married Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    17 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    18 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
    19 DFLT_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Marital Ststus Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    20 ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
    1=Yes
    2=No
    21 DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
    1=Yes
    2=No
    22 DFLT_DEPEND_IND Character(1) VARCHAR2(1) NOT NULL Dependents Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    23 TAX_FORM_FILED Character(1) VARCHAR2(1) NOT NULL Tax Form Filed
    1=Completed 1040A/EZ
    2=Completed 1040
    3=Estimated 1040A/EZ
    4=Estimated 1040
    5=Will Not File
    24 NUMBER_EXEMPTIONS Character(2) VARCHAR2(2) NOT NULL Nbr of Exemptions
    00=00
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    10=10
    11=11
    12=12
    ?=?
    25 AGI Signed Number(7,0) DECIMAL(6) NOT NULL Adjusted Gross Income
    26 DFLT_AGI_IND Character(1) VARCHAR2(1) NOT NULL AGI Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    27 TAXES_PAID Signed Number(7,0) DECIMAL(6) NOT NULL U. S. Tax Paid
    28 DFLT_TAXES_PD_IND Character(1) VARCHAR2(1) NOT NULL Taxes Paid Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    29 STD_EARNED_INCOME Signed Number(7,0) DECIMAL(6) NOT NULL Student's Earned Income
    30 DFLT_STD_INC_IND Character(1) VARCHAR2(1) NOT NULL Student Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    31 SPS_EARNED_INCOME Signed Number(7,0) DECIMAL(6) NOT NULL Spouse's Earned Income
    32 DFLT_SPS_INC_IND Character(1) VARCHAR2(1) NOT NULL Spouse Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    33 SOC_SEC_BENEFITS Signed Number(6,0) DECIMAL(5) NOT NULL SS Benefits
    34 DFLT_SS_BEN_IND Character(1) VARCHAR2(1) NOT NULL Soc Sec Benefits Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    35 AFDC_BENEFITS Signed Number(6,0) DECIMAL(5) NOT NULL AFDC Benefits
    36 DFLT_AFDC_BEN_IND Character(1) VARCHAR2(1) NOT NULL AFDC Benefit Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    37 CHILD_SUPPORT Signed Number(6,0) DECIMAL(5) NOT NULL Child Support
    38 DFLT_CHLD_SPPT_IND Character(1) VARCHAR2(1) NOT NULL Child Support Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    39 UNTAXED_INCOME Signed Number(6,0) DECIMAL(5) NOT NULL Untaxed Income
    40 DFLT_UNTXD_INC_IND Character(1) VARCHAR2(1) NOT NULL Untaxed Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    41 CASH_SAVINGS Signed Number(8,0) DECIMAL(7) NOT NULL Cash Savings
    42 RE_INVEST_VALUE Signed Number(8,0) DECIMAL(7) NOT NULL Real Estate Invest Value
    43 RE_INVEST_DEBT Signed Number(8,0) DECIMAL(7) NOT NULL Real Estate Invest Debt
    44 BUSINESS_VALUE Signed Number(8,0) DECIMAL(7) NOT NULL Business Value
    45 BUSINESS_DEBT Signed Number(8,0) DECIMAL(7) NOT NULL Business Debt
    46 FARM_VALUE Signed Number(8,0) DECIMAL(7) NOT NULL Investment Farm Value
    47 FARM_DEBT Signed Number(8,0) DECIMAL(7) NOT NULL Investment Farm Debt
    48 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    49 SCHOOL_CHOICE_1 Character(6) VARCHAR2(6) NOT NULL Student's 1st Choice School
    50 HOUSING_CODE_1 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 1
    1=On-Campus
    2=Off-Campus
    3=Parents
    51 SCHOOL_CHOICE_2 Character(6) VARCHAR2(6) NOT NULL Student's 2nd Choice School
    52 HOUSING_CODE_2 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 2
    1=On-Campus
    2=Off-Campus
    3=Parents
    53 SCHOOL_CHOICE_3 Character(6) VARCHAR2(6) NOT NULL Student's 3rd Choice School
    54 HOUSING_CODE_3 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 3
    1=On-Campus
    2=Off-Campus
    3=Parents
    55 SCHOOL_CHOICE_4 Character(6) VARCHAR2(6) NOT NULL Student's 4th Choice School
    56 HOUSING_CODE_4 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 4
    1=On-Campus
    2=Off-Campus
    3=Parents
    57 SCHOOL_CHOICE_5 Character(6) VARCHAR2(6) NOT NULL Student's 5th Choice School
    58 HOUSING_CODE_5 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 5
    1=On-Campus
    2=Off-Campus
    3=Parents
    59 SCHOOL_CHOICE_6 Character(6) VARCHAR2(6) NOT NULL Student's 6th Choice School
    60 HOUSING_CODE_6 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 6
    1=On-Campus
    2=Off-Campus
    3=Parents
    61 STATE_AGNCY_RLSE Character(1) VARCHAR2(1) NOT NULL Send Info to the State Agency
    1=Yes
    2=No
    62 SEL_SERV_REGISTER Character(1) VARCHAR2(1) NOT NULL Permit Sel Serv to Enroll
    1=Yes
    2=No
    63 SIGNED_BY_APPLICNT Character(1) VARCHAR2(1) NOT NULL Student Signed
    1=Yes
    2=No

    Default Value: 1

    64 SIGNED_BY_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Signed
    1=Yes
    65 SIGNED_BY_FATHER Character(1) VARCHAR2(1) NOT NULL Father Signed
    1=Yes
    66 SIGNED_BY_MOTHER Character(1) VARCHAR2(1) NOT NULL Mother Signed
    1=Yes
    67 FIRST_BACH_DEGREE Character(1) VARCHAR2(1) NOT NULL Received First Bachelor Degree
    1=Yes
    2=No
    68 MONTHLY_VET_BEN Signed Number(5,0) DECIMAL(4) NOT NULL Monthly Vet Edu Benefits
    69 NUM_MONTH_VET_BEN Character(2) VARCHAR2(2) NOT NULL VA Ben Nbr of Months
    70 INTERESTED_IN_WS Character(1) VARCHAR2(1) NOT NULL Interested In Work-Study
    1=Yes
    2=No
    71 INTERESTED_IN_SL Character(1) VARCHAR2(1) NOT NULL Interested In Student Loans
    1=Yes
    2=No
    72 INTERESTED_IN_PLUS Character(1) VARCHAR2(1) NOT NULL Interested In PLUS
    1=Yes
    2=No
    73 APP_SIGNED_BY Character(1) VARCHAR2(1) NOT NULL Application Signed By
    A=Applicant
    B=Applicant and Parent
    74 DT_APP_COMPLETED Date(10) DATE Date Application Completed
    75 DT_GED_EARNED Date(10) DATE Date GED Earned
    76 HS_GRAD_DT Date(10) DATE Highschool graduation date
    77 ATTEND_SAME_COLL Character(1) VARCHAR2(1) NOT NULL Attend Same College
    1=Yes
    2=No
    78 ENROLL_CURNT_SUM Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Current Sumr
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    79 ENROLL_FALL Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Fall
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    80 ENROLL_WINTER Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Winter
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    81 ENROLL_SPRING Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Spring
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    82 ENROLL_NEXT_SUM Character(1) VARCHAR2(1) NOT NULL Enroll Plan for Next Sumr
    1=Full Time
    2=3/4 Time
    3=1/2 Time
    4=LT 1/2 Time
    5=Not Attending
    83 DEGREE_CERTIF Character(1) VARCHAR2(1) NOT NULL Degree/Certificate
    1=1st Bachelor Degree
    2=2nd Bachelor Degree
    3=Associate Degree (Occ/Tech)
    4=Associate Degree (Gen Ed)
    5=Certificate or Diploma < 2 yrs
    6=Certificate or Diplome >= 2yrs
    7=Teaching Credential
    8=Graduate or Professional
    9=Other/Undecided
    84 COURSE_OF_STUDY Character(2) VARCHAR2(2) NOT NULL Course of Study
    01=Agriculture
    02=Architecture
    03=Biological Sciences
    04=Business Management
    05=Communications (Journalism)
    06=Computer Science
    07=Education
    08=Engineering
    09=English Lang/Literature
    10=Fine & Performing Arts
    11=Foreign Lang/Literature
    12=Health (Not Nursing)
    13=Home Economics
    14=Law
    15=Liberal Arts
    16=Library Sciences
    17=Mathematics
    18=Nursing
    19=Personal/Miscellaneous
    20=Philosophy
    21=Physical Science
    22=Social Science
    23=Psychology
    24=Theological studies
    25=Vocational/Technical
    26=Wildlife/Forestry
    27=Other/Undecided
    85 DT_EXPCT_TO_COMP Date(10) DATE Date Expected to Complete Prog
    86 CURRENT_GRADE_LVL Character(2) VARCHAR2(2) NOT NULL Current Grade Level
    01=1st yr Never Attended
    02=1st yr Attended Before
    03=2nd yr Sophmore
    04=3rd yr Junior
    05=4th yr Senior
    06=5th yr other UG
    07=1st yr Grad/Prof
    08=2nd yr Grad/Prof
    09=3rd yr Grad/Prof
    10=Beyond 3rd yr Grad/Prof
    87 PAY_NUM_DEPENDENTS Character(2) VARCHAR2(2) NOT NULL Care for how many Dependents
    88 TOTAL_FROM_WS3 Signed Number(7,0) DECIMAL(6) NOT NULL Total from Worksheet 3
    89 DFLT_WS3_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from WrkSht 3 Defaulted
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    90 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
    1=Independent
    2=Dependent
    3=Indepenedent/Pro Judgmnt
    D=Dependent w/Primary EFC
    I=Independent w/Primary EFC
    X=Dependent Reject No EFC
    Y=Independent Reject No EFC
    91 PROJECTED_YR_INC Character(1) VARCHAR2(1) NOT NULL Projected Year Income
    N=No
    Y=Yes

    Default Value: N

    92 EARLY_ADMISSION Character(1) VARCHAR2(1) NOT NULL Early Admission
    1=Estim. of Elig, Not Enrolling
    93 ERND_INC_CREDIT Signed Number(6,0) DECIMAL(5) NOT NULL Earned Income Credit
    94 DFLT_EIC_IND Character(1) VARCHAR2(1) NOT NULL Earned Inc Source Ind
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    95 GRADUATE Character(1) VARCHAR2(1) NOT NULL Graduate
    Y=Yes
    96 EXP_TOT_WS3 Signed Number(6,0) DECIMAL(5) NOT NULL Expected Tot From Worksheet 3
    97 DFLT_EXP_WS3_IND Character(1) VARCHAR2(1) NOT NULL WS3 Total Defaulted
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    98 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence
    99 RESIDENCY_DT Date(10) DATE Residency Date
    100 DRIV_LIC_STATE Character(6) VARCHAR2(6) NOT NULL Issuing State
    101 HS_GED_RCVD Character(1) VARCHAR2(1) NOT NULL HS Diploma or GED Received
    1=Yes
    2=No
    102 FISAP_TOT_INC Signed Number(8,0) DECIMAL(7) NOT NULL FISAP Total Income
    103 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    104 LEGAL_RES_PRI_94 Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-94
    1=Yes
    2=No
    105 STUDENT_MALE Character(1) VARCHAR2(1) NOT NULL Are You Male?
    1=Yes
    2=No
    106 TAX_RETURN_FILED Character(1) VARCHAR2(1) NOT NULL Tax Return Filed?
    1=Already Filed/Completed
    2=Will File
    3=Will Not File
    107 ELIG_FOR_1040A_EZ Character(1) VARCHAR2(1) NOT NULL Eligible For 1040A or 1040EZ
    1=Yes
    2=No/Don't Know
    108 TOTAL_FROM_WKA Number(5,0) INTEGER NOT NULL Total Amount from WK A
    109 INV_NET_WORTH Number(6,0) INTEGER NOT NULL Investment Net Worth
    110 BUS_NET_WORTH Number(6,0) INTEGER NOT NULL Business Net Worth
    111 FARM_NET_WORTH Number(6,0) INTEGER NOT NULL Farm Net Worth
    112 STUDENT_HAVE_DL Character(1) VARCHAR2(1) NOT NULL Do you have a driver's license
    1=Yes
    2=No
    113 DRUG_OFFENSE_CONV Character(1) VARCHAR2(1) NOT NULL Drug Offense Conviction
    1=Eligible
    2=Partially Eligible
    3=Ineligible or Don't know
    I=Institutional Override
    114 LEGAL_RES_PRIOR Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-95
    1=Yes
    2=No
    115 DFLT_WSA_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from Worksheet A
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    116 DFLT_VETERAN_IND Character(1) VARCHAR2(1) NOT NULL Default Veteran Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    117 DFLT_CITIZEN_IND Character(1) VARCHAR2(1) NOT NULL Default Citizenship Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    118 IWD_PERM_ADDR02 Character(35) VARCHAR2(35) NOT NULL Permanent Mailing Address
    119 IWD_CITY Character(16) VARCHAR2(16) NOT NULL City
    120 IWD_STATE Character(2) VARCHAR2(2) NOT NULL State
    121 IWD_ZIP Character(5) VARCHAR2(5) NOT NULL Zip
    122 IWD_PERM_PHONE Character(10) VARCHAR2(10) NOT NULL Perm Phone Number
    123 IWD_STD_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Last Name
    124 IWD_STD_FIRST_NM02 Character(12) VARCHAR2(12) NOT NULL Student's First Name
    125 IWD_STU_MI Character(1) VARCHAR2(1) NOT NULL Student Middle Initial
    126 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    127 BIRTHDATE Date(10) DATE Date of Birth
    128 DRIVERS_LICENSE_NO Character(20) VARCHAR2(20) NOT NULL Driver's License #
    129 IWD_STU_ALIEN_REG Character(9) VARCHAR2(9) NOT NULL Alien Registration Number
    130 CHILDREN Character(1) VARCHAR2(1) NOT NULL Have Children you support
    1=Yes
    2=No
    131 DFLT_CHILDREN_IND Character(1) VARCHAR2(1) NOT NULL Default Veteran Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    132 TOTAL_FROM_WKC Number(5,0) INTEGER NOT NULL Total Amount from WK C
    133 DFLT_WKC_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from WrkSht C Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    134 IWD_STD_EMAIL Character(50) VARCHAR2(50) NOT NULL Student's Email Address
    135 BLANK_AGI Character(1) VARCHAR2(1) NOT NULL AGI value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    136 BLANK_TAXES_PAID Character(1) VARCHAR2(1) NOT NULL Taxes Paid value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    137 BLANK_STD_EARN_INC Character(1) VARCHAR2(1) NOT NULL Student's Earned Income blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    138 BLANK_SPS_EARN_INC Character(1) VARCHAR2(1) NOT NULL Spouse's Earned Income blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    139 BLANK_TOT_FROM_WS3 Character(1) VARCHAR2(1) NOT NULL Total From Wksheet B is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    140 BLANK_TOT_FROM_WKA Character(1) VARCHAR2(1) NOT NULL Total From Wksheet A is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    141 BLANK_INV_NET_WRTH Character(1) VARCHAR2(1) NOT NULL Investment Net Worth is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    142 ISIR_STU_ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
    1=Full Time
    2=Three Quarter Time
    3=Half Time
    4=Less than Half Time
    5=Don't Know
    143 BLANK_CASH_SAV Character(1) VARCHAR2(1) NOT NULL Cash savings value is blank
    N=Non Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    144 SFA_ACTIVE_DUTY Character(1) VARCHAR2(1) NOT NULL Active Duty in U.S Military
    1=Yes
    2=No
    145 SFA_SSI_INCOME Character(1) VARCHAR2(1) NOT NULL Receives SSI Income
    1=Yes
    2=No
    146 SFA_FOOD_STAMPS Character(1) VARCHAR2(1) NOT NULL Receives Food Stamps
    1=Yes
    2=No
    147 SFA_SCHL_LUNCH_PRG Character(1) VARCHAR2(1) NOT NULL Participates in Sch Lunch Prog
    1=Yes
    2=No
    148 SFA_TANF_BENEFITS Character(1) VARCHAR2(1) NOT NULL TANF Recipient
    1=Yes
    2=No
    149 SFA_WIC_BENEFITS Character(1) VARCHAR2(1) NOT NULL WIC Benefits Recipient
    1=Yes
    2=No
    150 SFA_INTRSTD_IN_WSL Character(1) VARCHAR2(1) NOT NULL Work Study or Student Loans
    1=Work Study
    2=Student Loans
    3=Both
    4=Neither
    5=Don't Know
    151 SFA_STDNT_GENDER Character(1) VARCHAR2(1) NOT NULL Are You Male or Female
    1=Male
    2=Female
    152 SFA_HS_DIP_EQUIV Character(1) VARCHAR2(1) NOT NULL HS Diploma or Equivalent
    1=High School Diploma
    2=GED
    3=Home Schooled
    4=Other
    153 SFA_SCHL_CHOICE_7 Character(6) VARCHAR2(6) NOT NULL Student's 7th Choice School
    154 SFA_HOUSING_CODE7 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 7
    1=On-Campus
    2=Off-Campus
    3=Parents
    155 SFA_SCHL_CHOICE_8 Character(6) VARCHAR2(6) NOT NULL Student's 8th Choice School
    156 SFA_HOUSING_CODE8 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 8
    1=On-Campus
    2=Off-Campus
    3=Parents
    157 SFA_SCHL_CHOICE_9 Character(6) VARCHAR2(6) NOT NULL Student's 9th Choice School
    158 SFA_HOUSING_CODE9 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 9
    1=On-Campus
    2=Off-Campus
    3=Parents
    159 SFA_SCHL_CHOICE_10 Character(6) VARCHAR2(6) NOT NULL Student's 10th Choice School
    160 SFA_HOUSING_CODE10 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 10
    1=On-Campus
    2=Off-Campus
    3=Parents