FAN_ISIR_STD_VW

(SQL View)
 Index Back

Federal Student Application

This is a view of the ISIR_STUDENT table used for Financial Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.NUM_FAMILY_MEMBERS ,A.DFLT_NUM_FAM_IND ,A.NUMBER_IN_COLLEGE ,A.DFLT_NUM_COLL_IND ,A.DOB_PRIOR ,A.DFLT_DOB_PRIOR_IND ,A.VETERAN ,A.GRADUATE_STUDENT ,A.MARRIED ,A.DFLT_MARRIED_IND ,A.MARITAL_STAT ,A.MAR_STATUS_DT ,A.DFLT_MAR_STAT_IND ,A.ORPHAN ,A.DEPENDENTS ,A.DFLT_DEPEND_IND ,A.TAX_FORM_FILED ,A.NUMBER_EXEMPTIONS ,A.AGI ,A.DFLT_AGI_IND ,A.TAXES_PAID ,A.DFLT_TAXES_PD_IND ,A.STD_EARNED_INCOME ,A.DFLT_STD_INC_IND ,A.SPS_EARNED_INCOME ,A.DFLT_SPS_INC_IND ,A.SOC_SEC_BENEFITS ,A.DFLT_SS_BEN_IND ,A.AFDC_BENEFITS ,A.DFLT_AFDC_BEN_IND ,A.CHILD_SUPPORT ,A.DFLT_CHLD_SPPT_IND ,A.UNTAXED_INCOME ,A.DFLT_UNTXD_INC_IND ,A.CASH_SAVINGS ,A.RE_INVEST_VALUE ,A.RE_INVEST_DEBT ,A.BUSINESS_VALUE ,A.BUSINESS_DEBT ,A.FARM_VALUE ,A.FARM_DEBT ,A.CURRENCY_CD ,A.SCHOOL_CHOICE_1 ,A.HOUSING_CODE_1 ,A.SCHOOL_CHOICE_2 ,A.HOUSING_CODE_2 ,A.SCHOOL_CHOICE_3 ,A.HOUSING_CODE_3 ,A.SCHOOL_CHOICE_4 ,A.HOUSING_CODE_4 ,A.SCHOOL_CHOICE_5 ,A.HOUSING_CODE_5 ,A.SCHOOL_CHOICE_6 ,A.HOUSING_CODE_6 ,A.STATE_AGNCY_RLSE ,A.SEL_SERV_REGISTER ,A.SIGNED_BY_APPLICNT ,A.SIGNED_BY_SPOUSE ,A.SIGNED_BY_FATHER ,A.SIGNED_BY_MOTHER ,A.FIRST_BACH_DEGREE ,A.MONTHLY_VET_BEN ,A.NUM_MONTH_VET_BEN ,A.INTERESTED_IN_WS ,A.INTERESTED_IN_SL ,A.INTERESTED_IN_PLUS ,A.APP_SIGNED_BY ,A.DT_APP_COMPLETED ,A.DT_GED_EARNED ,A.HS_GRAD_DT ,A.ATTEND_SAME_COLL ,A.ENROLL_CURNT_SUM ,A.ENROLL_FALL ,A.ENROLL_WINTER ,A.ENROLL_SPRING ,A.ENROLL_NEXT_SUM ,A.DEGREE_CERTIF ,A.COURSE_OF_STUDY ,A.DT_EXPCT_TO_COMP ,A.CURRENT_GRADE_LVL ,A.PAY_NUM_DEPENDENTS ,A.TOTAL_FROM_WS3 ,A.DFLT_WS3_TOT_IND ,A.DEPNDNCY_STAT ,A.PROJECTED_YR_INC ,A.EARLY_ADMISSION ,A.ERND_INC_CREDIT ,A.DFLT_EIC_IND ,A.GRADUATE ,A.EXP_TOT_WS3 ,A.DFLT_EXP_WS3_IND ,A.STATE_RESIDENCE ,A.RESIDENCY_DT ,A.DRIV_LIC_STATE ,A.HS_GED_RCVD ,A.FISAP_TOT_INC ,A.CITIZENSHIP_STATUS ,A.LEGAL_RES_PRI_94 ,A.STUDENT_MALE ,A.TAX_RETURN_FILED ,A.ELIG_FOR_1040A_EZ ,A.TOTAL_FROM_WKA ,A.INV_NET_WORTH ,A.BUS_NET_WORTH ,A.FARM_NET_WORTH ,A.STUDENT_HAVE_DL ,A.DRUG_OFFENSE_CONV ,A.LEGAL_RES_PRIOR ,A.DFLT_WSA_TOT_IND ,A.DFLT_VETERAN_IND ,A.DFLT_CITIZEN_IND ,A.IWD_PERM_ADDR02 ,A.IWD_CITY ,A.IWD_STATE ,A.IWD_ZIP ,A.IWD_PERM_PHONE ,A.IWD_STD_LAST_NAME ,A.IWD_STD_FIRST_NM02 ,A.IWD_STU_MI ,A.SSN ,A.BIRTHDATE ,A.DRIVERS_LICENSE_NO ,A.IWD_STU_ALIEN_REG ,A.CHILDREN ,A.DFLT_CHILDREN_IND ,A.TOTAL_FROM_WKC ,A.DFLT_WKC_TOT_IND ,A.IWD_STD_EMAIL ,A.BLANK_AGI ,A.BLANK_TAXES_PAID ,A.BLANK_STD_EARN_INC ,A.BLANK_SPS_EARN_INC ,A.BLANK_TOT_FROM_WS3 ,A.BLANK_TOT_FROM_WKA ,A.BLANK_INV_NET_WRTH ,A.ISIR_STU_ENRL_STAT ,A.BLANK_CASH_SAV ,A.SFA_ACTIVE_DUTY ,A.SFA_SSI_INCOME ,A.SFA_FOOD_STAMPS ,A.SFA_SCHL_LUNCH_PRG ,A.SFA_TANF_BENEFITS ,A.SFA_WIC_BENEFITS ,A.SFA_INTRSTD_IN_WSL ,A.SFA_STDNT_GENDER ,A.SFA_HS_DIP_EQUIV ,A.SFA_SCHL_CHOICE_7 ,A.SFA_HOUSING_CODE7 ,A.SFA_SCHL_CHOICE_8 ,A.SFA_HOUSING_CODE8 ,A.SFA_SCHL_CHOICE_9 ,A.SFA_HOUSING_CODE9 ,A.SFA_SCHL_CHOICE_10 ,A.SFA_HOUSING_CODE10 ,A.SFA_TCH_COURSE_WRK ,A.SFA_EMANCIPT_MINOR ,A.SFA_LEGAL_GUARDIAN ,A.SFA_YOUTH_LIASON ,A.SFA_YOUTH_HUD ,A.SFA_RISK_HOMELESS ,A.SFA_DISLOCATE_WRK ,A.SFA_EDU_CREDITS ,A.SFA_CHILD_SUP_PAID ,A.SFA_NEED_EMPLOYMNT ,A.SFA_GRANT_AID ,A.SFA_COMBATPAY ,A.SFA_PENSION_PAY ,A.SFA_IRA_PAY ,A.SFA_CHILD_SUP_RECV ,A.SFA_INTERST_INCOME ,A.SFA_IRA_DIST ,A.SFA_UNTAX_PENSION ,A.SFA_MILITARY_ALLOW ,A.SFA_VET_NONEDU_BEN ,A.SFA_UNTAX_INCOME ,A.SFA_NON_REP_MONEY ,A.SFA_RECV_VET_BEN ,A.SFA_VET_BEN_TYPE ,A.SFA_COOP_EARN ,A.SFA_DFLT_YOUTH_SCH ,A.SFA_DFLT_YOUTH_HUD ,A.SFA_DFLT_RISK_HOME ,A.SFA_BLANK_BUSNET ,A.SFA_BLANK_EDUCREDT ,A.SFA_BLANK_CHILDSUP ,A.SFA_BLANK_NEEDEMPL ,A.SFA_BLANK_GRANTAID ,A.SFA_BLANK_COMBAT ,A.SFA_BLANK_COOPEARN ,A.SFA_BLANK_PENSION ,A.SFA_BLANK_IRA_PAY ,A.SFA_BLANK_CHILDREC ,A.SFA_BLANK_INT_INC ,A.SFA_BLANK_IRA_DIST ,A.SFA_BLANK_UNTAXPEN ,A.SFA_BLANK_MILITARY ,A.SFA_BLANK_VET_NON ,A.SFA_BLANK_UNTAXINC ,A.SFA_BLANK_NON_REP ,A.SFA_HIGH_SCHL_NAME ,A.SFA_HIGH_SCHL_CITY ,A.SFA_HIGH_SCHL_STAT ,A.SFA_HIGH_SCHL_CODE ,A.SFA_STU_ASSET_THRS ,A.SFA_DFLT_ASM_ASSET ,A.SFA_STU_TAX_RET ,D.SFA_FAFSA_UUID ,D.SFA_TRANSACT_UUID ,D.SFA_PERSON_UUID ,D.SFA_STUDENT_SUFFIX ,D.SFA_STUDENT_ITIN ,D.SFA_STD_STREET ,D.SFA_STD_CITY ,D.SFA_STD_ZIPCODE ,D.SFA_STD_COUNTRY ,D.SFA_TEACHER_CERT ,D.SFA_ORPHAN_DEC ,D.SFA_ORPHAN_FOSTER ,D.SFA_ORPHAN_WARD ,D.SFA_STD_CIRCUM ,D.SFA_HOMELESS_TRIO ,D.SFA_HOMELESS_FAA ,D.SFA_STD_OTHER ,D.SFA_STD_UNUSUAL ,D.SFA_STD_UNSUB ,D.SFA_STD_PARATT ,D.SFA_STD_PARKILL ,D.SFA_HIGH_SCHL_DIPL ,D.SFA_HIGH_SCHL_DPST ,D.SFA_STD_ETIC ,D.SFA_STD_HOUSING ,D.SFA_STD_MEDICAID ,D.SFA_STD_36B ,D.SFA_STD_FED_NONE ,D.SFA_STD_1040 ,D.SFA_STD_NON_TAX ,D.SFA_STD_JOINT_TAX ,D.SFA_STD_TAX_RET ,D.SFA_INC_WORK1 ,D.SFA_TAX_EXEMPT1 ,D.SFA_UNTAX_IRA1 ,D.SFA_IRA_ROLL1 ,D.SFA_UNTAX_PEN1 ,D.SFA_PEN_ROLL1 ,D.SFA_TAX_CREDIT1 ,D.SFA_DEDUCT_IRA1 ,D.SFA_FILED_SCHD1 ,D.SFA_SCHED_CAMT1 ,D.SFA_FED_TAX1 ,D.SFA_TAXES_PAID1 ,D.SFA_BL_INC_WORK1 ,D.SFA_BL_TAX_EXEMPT1 ,D.SFA_BL_UNTAX_IRA1 ,D.SFA_BL_IRA_ROLL1 ,D.SFA_BL_UNTAX_PEN1 ,D.SFA_BL_PEN_ROLL1 ,D.SFA_BL_AGI1 ,D.SFA_BL_DEDUCT_IRA1 ,D.SFA_BL_EDU_CREDIT1 ,D.SFA_BL_SCHED_CAMT1 ,D.SFA_BL_FED_TAX1 ,D.SFA_BL_TAX_PAID1 ,D.SFA_STD_CONSENT ,D.SFA_STD_SIGNATURE ,D.SFA_STD_SIGNDATE ,D.SFA_SPS_FIRSTNAME ,D.SFA_SPS_MIDDLENAME ,D.SFA_SPS_LASTNAME ,D.SFA_SPS_SUFFIX ,D.SFA_SPS_BIRTHDATE ,D.SFA_SPS_SSN ,D.SFA_SPS_ITIN ,D.SFA_SPS_PHONE ,D.SFA_SPS_EMAIL ,D.SFA_SPS_STREET ,D.SFA_SPS_CITY ,D.SFA_SPS_STATE ,D.SFA_SPS_ZIPCODE ,D.SFA_SPS_COUNTRY ,D.SFA_SPS_1040 ,D.SFA_SPS_NON_TAX ,D.SFA_SPS_TAX_RET ,D.SFA_INC_WORK2 ,D.SFA_TAX_EXEMPT2 ,D.SFA_UNTAX_IRA2 ,D.SFA_IRA_ROLL2 ,D.SFA_UNTAX_PEN2 ,D.SFA_PEN_ROLL2 ,D.SFA_AGI ,D.SFA_TAXES_PAID2 ,D.SFA_DEDUCT_IRA2 ,D.SFA_EDU_CREDIT2 ,D.SFA_FILED_SCHD2 ,D.SFA_SCHED_CAMT2 ,D.SFA_FED_TAX2 ,D.SFA_BL_INC_WORK2 ,D.SFA_BL_TAX_EXEMPT2 ,D.SFA_BL_UNTAX_IRA2 ,D.SFA_BL_IRA_ROLL2 ,D.SFA_BL_UNTAX_PEN2 ,D.SFA_BL_PEN_ROLL2 ,D.SFA_BL_AGI2 ,D.SFA_BL_TAX_PAID2 ,D.SFA_BL_DEDUCT_IRA2 ,D.SFA_BL_EDU_CREDIT2 ,D.SFA_BL_SCHED_CAMT2 ,D.SFA_BL_FED_TAX2 ,D.SFA_SPS_CONSENT ,D.SFA_SPS_SIGNATURE ,D.SFA_SPS_SIGNDATE ,D.SFA_ASMD_STD FROM PS_ISIR_STUDENT A LEFT JOIN PS_SFA_ISIR_STU D ON A.EMPLID = D.EMPLID AND A.TABLE_ID = '1' AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = D.AID_YEAR AND A.EFFDT = D.EFFDT AND A.EFFSEQ = D.EFFSEQ AND A.TABLE_ID = D.TABLE_ID where A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ISIR_STUDENT B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.TABLE_ID = A.TABLE_ID AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ISIR_STUDENT C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.TABLE_ID = A.TABLE_ID AND C.EFFDT = A.EFFDT)

  • Parent record: ISIR_CONTROL

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

    Prompt Table: STDNT_AID_SRCH

    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 NUM_FAMILY_MEMBERS Character(2) VARCHAR2(2) NOT NULL Nbr in Family
    5 DFLT_NUM_FAM_IND Character(1) VARCHAR2(1) NOT NULL Nbr Family Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    6 NUMBER_IN_COLLEGE Character(2) VARCHAR2(2) NOT NULL Nbr in College
    7 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
    8 DOB_PRIOR Character(1) VARCHAR2(1) NOT NULL DOB Before 1/1/74
    1=Yes
    2=No
    9 DFLT_DOB_PRIOR_IND Character(1) VARCHAR2(1) NOT NULL DOB Prior Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    10 VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran
    1=Yes
    2=No
    N=No
    Y=Yes
    11 GRADUATE_STUDENT Character(1) VARCHAR2(1) NOT NULL Grad Student
    1=Yes
    2=No
    12 MARRIED Character(1) VARCHAR2(1) NOT NULL Student Married
    1=Yes
    2=No
    13 DFLT_MARRIED_IND Character(1) VARCHAR2(1) NOT NULL Married Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    14 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    15 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. */
    16 DFLT_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Marital Status Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    17 ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
    1=Yes
    2=No
    N=No
    Y=Yes
    18 DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
    1=Yes
    2=No
    N=No
    Y=Yes
    19 DFLT_DEPEND_IND Character(1) VARCHAR2(1) NOT NULL Dependents Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    20 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
    21 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
    1=1
    10=10
    11=11
    12=12
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    9=9
    ?=?
    22 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    23 DFLT_AGI_IND Character(1) VARCHAR2(1) NOT NULL AGI Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    24 TAXES_PAID Signed Number(11,0) DECIMAL(10) NOT NULL U.S. Tax Paid
    25 DFLT_TAXES_PD_IND Character(1) VARCHAR2(1) NOT NULL Taxes Paid Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    26 STD_EARNED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Student's Earned Income
    27 DFLT_STD_INC_IND Character(1) VARCHAR2(1) NOT NULL Student Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    28 SPS_EARNED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Spouse's Earned Income
    29 DFLT_SPS_INC_IND Character(1) VARCHAR2(1) NOT NULL Spouse Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    30 SOC_SEC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL SS Benefits
    31 DFLT_SS_BEN_IND Character(1) VARCHAR2(1) NOT NULL Soc Sec Benefits Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    32 AFDC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL AFDC Benefits
    33 DFLT_AFDC_BEN_IND Character(1) VARCHAR2(1) NOT NULL AFDC Benefit Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    34 CHILD_SUPPORT Signed Number(6,0) DECIMAL(5) NOT NULL Child Support
    35 DFLT_CHLD_SPPT_IND Character(1) VARCHAR2(1) NOT NULL Child Support Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    36 UNTAXED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Untaxed Income
    37 DFLT_UNTXD_INC_IND Character(1) VARCHAR2(1) NOT NULL Untaxed Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    38 CASH_SAVINGS Signed Number(11,0) DECIMAL(10) NOT NULL Cash Savings
    39 RE_INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Value
    40 RE_INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Debt
    41 BUSINESS_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Business Value
    42 BUSINESS_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Business Debt
    43 FARM_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Value
    44 FARM_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Debt
    45 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    46 SCHOOL_CHOICE_1 Character(6) VARCHAR2(6) NOT NULL Student's 1st Choice School

    Prompt Table: TITLE_IV_SRCH

    47 HOUSING_CODE_1 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 1
    1=On-Campus
    2=Off-Campus
    3=Parents
    48 SCHOOL_CHOICE_2 Character(6) VARCHAR2(6) NOT NULL Student's 2nd Choice School

    Prompt Table: TITLE_IV_SRCH

    49 HOUSING_CODE_2 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 2
    1=On-Campus
    2=Off-Campus
    3=Parents
    50 SCHOOL_CHOICE_3 Character(6) VARCHAR2(6) NOT NULL Student's 3rd Choice School

    Prompt Table: TITLE_IV_SRCH

    51 HOUSING_CODE_3 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 3
    1=On-Campus
    2=Off-Campus
    3=Parents
    52 SCHOOL_CHOICE_4 Character(6) VARCHAR2(6) NOT NULL Student's 4th Choice School

    Prompt Table: TITLE_IV_SRCH

    53 HOUSING_CODE_4 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 4
    1=On-Campus
    2=Off-Campus
    3=Parents
    54 SCHOOL_CHOICE_5 Character(6) VARCHAR2(6) NOT NULL Student's 5th Choice School

    Prompt Table: TITLE_IV_SRCH

    55 HOUSING_CODE_5 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 5
    1=On-Campus
    2=Off-Campus
    3=Parents
    56 SCHOOL_CHOICE_6 Character(6) VARCHAR2(6) NOT NULL Student's 6th Choice School

    Prompt Table: TITLE_IV_SRCH

    57 HOUSING_CODE_6 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 6
    1=On-Campus
    2=Off-Campus
    3=Parents
    58 STATE_AGNCY_RLSE Character(1) VARCHAR2(1) NOT NULL Send Info to the State Agency
    1=Yes
    2=No
    59 SEL_SERV_REGISTER Character(1) VARCHAR2(1) NOT NULL Permit Sel Serv to Enroll
    1=Yes
    2=No
    60 SIGNED_BY_APPLICNT Character(1) VARCHAR2(1) NOT NULL Student Signed
    1=Yes
    2=No
    61 SIGNED_BY_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Signed
    1=Yes
    62 SIGNED_BY_FATHER Character(1) VARCHAR2(1) NOT NULL Father Signed
    1=Yes
    63 SIGNED_BY_MOTHER Character(1) VARCHAR2(1) NOT NULL Mother Signed
    1=Yes
    64 FIRST_BACH_DEGREE Character(1) VARCHAR2(1) NOT NULL Received First Bachelor Degree
    1=Yes
    2=No
    65 MONTHLY_VET_BEN Signed Number(11,0) DECIMAL(10) NOT NULL Monthly Vet Edu Benefits
    66 NUM_MONTH_VET_BEN Character(2) VARCHAR2(2) NOT NULL VA Ben Number of Months
    67 INTERESTED_IN_WS Character(1) VARCHAR2(1) NOT NULL Interested In Work-Study
    1=Yes
    2=No
    3=Don't Know
    68 INTERESTED_IN_SL Character(1) VARCHAR2(1) NOT NULL Interested In Student Loans
    1=Yes
    2=No
    69 INTERESTED_IN_PLUS Character(1) VARCHAR2(1) NOT NULL Interested In PLUS
    1=Yes
    2=No
    70 APP_SIGNED_BY Character(1) VARCHAR2(1) NOT NULL Application Signed By
    A=Applicant
    B=Applicant and Parent
    71 DT_APP_COMPLETED Date(10) DATE Date Application Completed
    72 DT_GED_EARNED Date(10) DATE Date GED Earned
    73 HS_GRAD_DT Date(10) DATE Highschool graduation date
    74 ATTEND_SAME_COLL Character(1) VARCHAR2(1) NOT NULL Attend Same College
    1=Yes
    2=No
    75 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
    76 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
    77 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
    78 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
    79 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
    80 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
    81 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
    82 DT_EXPCT_TO_COMP Date(10) DATE Date Expected to Complete Prog
    83 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
    84 PAY_NUM_DEPENDENTS Character(2) VARCHAR2(2) NOT NULL Care for how many Dependents
    85 TOTAL_FROM_WS3 Signed Number(9,0) DECIMAL(8) NOT NULL Total from Worksheet 3
    86 DFLT_WS3_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from WrkSht 3 Defaulted
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    87 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
    1=Independent
    2=Dependent
    3=Indepenedent/Pro Judgmnt
    D=Dependent
    I=Independent
    X=Dependent Reject
    Y=Independent Reject
    Z=Provisional Independent
    88 PROJECTED_YR_INC Character(1) VARCHAR2(1) NOT NULL Projected Year Income
    N=No
    Y=Yes
    89 EARLY_ADMISSION Character(1) VARCHAR2(1) NOT NULL Early Admission
    1=Estim. of Elig, Not Enrolling
    90 ERND_INC_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Earned Income Credit
    91 DFLT_EIC_IND Character(1) VARCHAR2(1) NOT NULL Earned Inc Source Ind
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    92 GRADUATE Character(1) VARCHAR2(1) NOT NULL Graduate
    Y=Yes
    93 EXP_TOT_WS3 Signed Number(6,0) DECIMAL(5) NOT NULL Expected Tot From Worksheet 3
    94 DFLT_EXP_WS3_IND Character(1) VARCHAR2(1) NOT NULL WS3 Total Defaulted
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    95 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence

    Prompt Table: USA_STATE_VW

    96 RESIDENCY_DT Date(10) DATE Residency Date
    97 DRIV_LIC_STATE Character(6) VARCHAR2(6) NOT NULL Issuing State
    98 HS_GED_RCVD Character(1) VARCHAR2(1) NOT NULL HS Diploma or GED Received
    1=Yes
    2=No
    99 FISAP_TOT_INC Signed Number(16,0) DECIMAL(15) NOT NULL FISAP Total Income
    100 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    101 LEGAL_RES_PRI_94 Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-94
    1=Yes
    2=No
    102 STUDENT_MALE Character(1) VARCHAR2(1) NOT NULL Are You Male?
    1=Yes
    2=No
    103 TAX_RETURN_FILED Character(1) VARCHAR2(1) NOT NULL Tax Return Filed?
    1=Already Filed/Completed
    2=Will File
    3=Will Not File
    104 ELIG_FOR_1040A_EZ Character(1) VARCHAR2(1) NOT NULL Eligible For 1040A or 1040EZ
    1=Yes
    2=No/Don't Know
    105 TOTAL_FROM_WKA Number(5,0) INTEGER NOT NULL Total Amount from WK A
    106 INV_NET_WORTH Number(10,0) DECIMAL(10) NOT NULL Investment Net Worth
    107 BUS_NET_WORTH Number(10,0) DECIMAL(10) NOT NULL Business Net Worth
    108 FARM_NET_WORTH Number(6,0) INTEGER NOT NULL Farm Net Worth
    109 STUDENT_HAVE_DL Character(1) VARCHAR2(1) NOT NULL Do you have a driver's license
    1=Yes
    2=No
    110 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
    111 LEGAL_RES_PRIOR Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-95
    1=Yes
    2=No
    112 DFLT_WSA_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from Worksheet A
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    113 DFLT_VETERAN_IND Character(1) VARCHAR2(1) NOT NULL Default Veteran Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    114 DFLT_CITIZEN_IND Character(1) VARCHAR2(1) NOT NULL Default Citizenship Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    115 IWD_PERM_ADDR02 Character(35) VARCHAR2(35) NOT NULL Permanent Mailing Address
    116 IWD_CITY Character(16) VARCHAR2(16) NOT NULL City
    117 IWD_STATE Character(2) VARCHAR2(2) NOT NULL State
    118 IWD_ZIP Character(5) VARCHAR2(5) NOT NULL Zip
    119 IWD_PERM_PHONE Character(10) VARCHAR2(10) NOT NULL Perm Phone Number
    120 IWD_STD_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
    121 IWD_STD_FIRST_NM02 Character(35) VARCHAR2(35) NOT NULL Student's First Name
    122 IWD_STU_MI Character(15) VARCHAR2(15) NOT NULL Student Middle Initial
    123 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    124 BIRTHDATE Date(10) DATE Date of Birth
    125 DRIVERS_LICENSE_NO Character(20) VARCHAR2(20) NOT NULL Driver's License #

    Prompt Table: ISIR_DRVLIC2_VW

    126 IWD_STU_ALIEN_REG Character(9) VARCHAR2(9) NOT NULL Alien Registration Number
    127 CHILDREN Character(1) VARCHAR2(1) NOT NULL Have Children you support
    1=Yes
    2=No
    128 DFLT_CHILDREN_IND Character(1) VARCHAR2(1) NOT NULL Default Veteran Indicator
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    129 TOTAL_FROM_WKC Number(8,0) INTEGER NOT NULL Total Amount from WK C
    130 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
    131 IWD_STD_EMAIL Character(50) VARCHAR2(50) NOT NULL Student's Email Address
    132 BLANK_AGI Character(1) VARCHAR2(1) NOT NULL AGI value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    136 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

    137 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

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

    Y/N Table Edit

    139 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
    140 BLANK_CASH_SAV Character(1) VARCHAR2(1) NOT NULL Cash savings value is blank
    N=Non Blank
    Y=Blank
    141 SFA_ACTIVE_DUTY Character(1) VARCHAR2(1) NOT NULL Active Duty in U.S Military
    1=Yes
    2=No
    142 SFA_SSI_INCOME Character(1) VARCHAR2(1) NOT NULL Receives SSI Income
    1=Yes
    2=No
    143 SFA_FOOD_STAMPS Character(1) VARCHAR2(1) NOT NULL Receives Food Stamps
    1=Yes
    2=No
    144 SFA_SCHL_LUNCH_PRG Character(1) VARCHAR2(1) NOT NULL Participates in Sch Lunch Prog
    1=Yes
    2=No
    145 SFA_TANF_BENEFITS Character(1) VARCHAR2(1) NOT NULL TANF Recipient
    1=Yes
    2=No
    146 SFA_WIC_BENEFITS Character(1) VARCHAR2(1) NOT NULL WIC Benefits Recipient
    1=Yes
    2=No
    147 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
    148 SFA_STDNT_GENDER Character(1) VARCHAR2(1) NOT NULL Are You Male or Female
    1=Male
    2=Female
    149 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
    150 SFA_SCHL_CHOICE_7 Character(6) VARCHAR2(6) NOT NULL Student's 7th Choice School
    151 SFA_HOUSING_CODE7 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 7
    1=On-Campus
    2=Off-Campus
    3=Parents
    152 SFA_SCHL_CHOICE_8 Character(6) VARCHAR2(6) NOT NULL Student's 8th Choice School
    153 SFA_HOUSING_CODE8 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 8
    1=On-Campus
    2=Off-Campus
    3=Parents
    154 SFA_SCHL_CHOICE_9 Character(6) VARCHAR2(6) NOT NULL Student's 9th Choice School
    155 SFA_HOUSING_CODE9 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 9
    1=On-Campus
    2=Off-Campus
    3=Parents
    156 SFA_SCHL_CHOICE_10 Character(6) VARCHAR2(6) NOT NULL Student's 10th Choice School
    157 SFA_HOUSING_CODE10 Character(1) VARCHAR2(1) NOT NULL Student's Housing Code Col 10
    1=On-Campus
    2=Off-Campus
    3=Parents
    158 SFA_TCH_COURSE_WRK Character(1) VARCHAR2(1) NOT NULL Teacher Coursework
    1=Yes
    2=No
    3=Don't Know
    159 SFA_EMANCIPT_MINOR Character(1) VARCHAR2(1) NOT NULL Emancipated Minor
    1=Yes
    2=No
    160 SFA_LEGAL_GUARDIAN Character(1) VARCHAR2(1) NOT NULL Legal Guardianship
    1=Yes
    2=No
    161 SFA_YOUTH_LIASON Character(1) VARCHAR2(1) NOT NULL Youth determined by SDL
    1=Yes
    2=No
    162 SFA_YOUTH_HUD Character(1) VARCHAR2(1) NOT NULL Youth determined by HUD
    1=Yes
    2=No
    163 SFA_RISK_HOMELESS Character(1) VARCHAR2(1) NOT NULL At Risk of Homelessness
    1=Yes
    2=No
    164 SFA_DISLOCATE_WRK Character(1) VARCHAR2(1) NOT NULL Dislocated Worker
    1=Yes
    2=No
    3=Don't Know
    165 SFA_EDU_CREDITS Number(10,0) DECIMAL(10) NOT NULL Educational Credits
    166 SFA_CHILD_SUP_PAID Number(10,0) DECIMAL(10) NOT NULL Child Support Paid
    167 SFA_NEED_EMPLOYMNT Number(7,0) INTEGER NOT NULL Need-Based Employment
    168 SFA_GRANT_AID Number(10,0) DECIMAL(10) NOT NULL Grant/Scholarship Aid
    169 SFA_COMBATPAY Number(10,0) DECIMAL(10) NOT NULL Combat Pay
    170 SFA_PENSION_PAY Number(7,0) INTEGER NOT NULL Pension Payments
    171 SFA_IRA_PAY Number(7,0) INTEGER NOT NULL IRA Payments
    172 SFA_CHILD_SUP_RECV Number(10,0) DECIMAL(10) NOT NULL Child Support Received
    173 SFA_INTERST_INCOME Number(7,0) INTEGER NOT NULL Interest Income
    174 SFA_IRA_DIST Number(7,0) INTEGER NOT NULL IRA Distributions
    175 SFA_UNTAX_PENSION Number(7,0) INTEGER NOT NULL Untaxed Pensions
    176 SFA_MILITARY_ALLOW Number(10,0) DECIMAL(10) NOT NULL Military/Clergy Allowances
    177 SFA_VET_NONEDU_BEN Number(10,0) DECIMAL(10) NOT NULL Veterans Non-Ed Benefits
    178 SFA_UNTAX_INCOME Number(10,0) DECIMAL(10) NOT NULL Other Untaxed Income
    179 SFA_NON_REP_MONEY Number(7,0) INTEGER NOT NULL Other Non-Reported Money
    180 SFA_RECV_VET_BEN Character(1) VARCHAR2(1) NOT NULL Receiving Veterans Benefits
    1=Yes
    2=No
    181 SFA_VET_BEN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Veterans Benefits
    1=GI Bill - Active Duty
    2=Post-9/11 GI Bill
    3=GI Bill - Selected Reserve
    4=Reserve Edu Assistance Program
    5=Vocational Rehab & Employment
    6=Dependents Educational Assist
    7=Other Type of Vet Edu Benefits
    182 SFA_COOP_EARN Number(7,0) INTEGER NOT NULL Co-op Earnings
    183 SFA_DFLT_YOUTH_SCH Character(1) VARCHAR2(1) NOT NULL Homeless Youth - School
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    184 SFA_DFLT_YOUTH_HUD Character(1) VARCHAR2(1) NOT NULL Homeless Youth - HUD
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    185 SFA_DFLT_RISK_HOME Character(1) VARCHAR2(1) NOT NULL Risk of Homelessness
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    186 SFA_BLANK_BUSNET Character(1) VARCHAR2(1) NOT NULL Business Net Worth is Blank
    N=Not Blank
    Y=Blank
    187 SFA_BLANK_EDUCREDT Character(1) VARCHAR2(1) NOT NULL Educational Credit is Blank
    N=Not Blank
    Y=Blank
    188 SFA_BLANK_CHILDSUP Character(1) VARCHAR2(1) NOT NULL Child Support Paid is Blank
    N=Not Blank
    Y=Blank
    189 SFA_BLANK_NEEDEMPL Character(1) VARCHAR2(1) NOT NULL Need Employment is Blank
    N=Not Blank
    Y=Blank
    190 SFA_BLANK_GRANTAID Character(1) VARCHAR2(1) NOT NULL Grant Aid is Blank
    N=Not Blank
    Y=Blank
    191 SFA_BLANK_COMBAT Character(1) VARCHAR2(1) NOT NULL Combat Pay is Blank
    N=Not Blank
    Y=Blank
    192 SFA_BLANK_COOPEARN Character(1) VARCHAR2(1) NOT NULL Co-op Earnings is Blank
    N=Not Blank
    Y=Blank
    193 SFA_BLANK_PENSION Character(1) VARCHAR2(1) NOT NULL Pension Pay is Blank
    N=Not Blank
    Y=Blank
    194 SFA_BLANK_IRA_PAY Character(1) VARCHAR2(1) NOT NULL Self Employment Pay is Blank
    N=Not Blank
    Y=Blank
    195 SFA_BLANK_CHILDREC Character(1) VARCHAR2(1) NOT NULL Child Support Receive is Blank
    N=Not Blank
    Y=Blank
    196 SFA_BLANK_INT_INC Character(1) VARCHAR2(1) NOT NULL Tax Exempt Interest is Blank
    N=Not Blank
    Y=Blank
    197 SFA_BLANK_IRA_DIST Character(1) VARCHAR2(1) NOT NULL IRA Distributions is Blank
    N=Not Blank
    Y=Blank
    198 SFA_BLANK_UNTAXPEN Character(1) VARCHAR2(1) NOT NULL Untax Pension is Blank
    N=Not Blank
    Y=Blank
    199 SFA_BLANK_MILITARY Character(1) VARCHAR2(1) NOT NULL Military Allowance is Blank
    N=Not Blank
    Y=Blank
    200 SFA_BLANK_VET_NON Character(1) VARCHAR2(1) NOT NULL Veterans Non-Ed Ben is Blank
    N=Not Blank
    Y=Blank
    201 SFA_BLANK_UNTAXINC Character(1) VARCHAR2(1) NOT NULL Other Untax Income is Blank
    N=Not Blank
    Y=Blank
    202 SFA_BLANK_NON_REP Character(1) VARCHAR2(1) NOT NULL Other Unreported Inc is Blank
    N=Not Blank
    Y=Blank
    203 SFA_HIGH_SCHL_NAME Character(60) VARCHAR2(60) NOT NULL High School Name
    204 SFA_HIGH_SCHL_CITY Character(28) VARCHAR2(28) NOT NULL High School City
    205 SFA_HIGH_SCHL_STAT Character(2) VARCHAR2(2) NOT NULL High School State

    Prompt Table: SFA_ISIRSTATEVW

    206 SFA_HIGH_SCHL_CODE Character(12) VARCHAR2(12) NOT NULL High School Code
    207 SFA_STU_ASSET_THRS Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceeded
    1=Yes
    2=No
    208 SFA_DFLT_ASM_ASSET Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceed Def
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    209 SFA_STU_TAX_RET Character(1) VARCHAR2(1) NOT NULL Student Return Filing Status Added for regs1 1415
    1=Single
    2=Married-Joint
    3=Married-Separate
    4=Head of House
    5=Widow(er)
    6=Don't Know
    210 SFA_FAFSA_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    211 SFA_TRANSACT_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    212 SFA_PERSON_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    213 SFA_STUDENT_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Student Suffix
    214 SFA_STUDENT_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Student ITIN
    215 SFA_STD_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Street Address
    216 SFA_STD_CITY Character(30) VARCHAR2(30) NOT NULL 2425:City
    217 SFA_STD_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Zip Code
    218 SFA_STD_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Country
    219 SFA_TEACHER_CERT Character(1) VARCHAR2(1) NOT NULL 2425: Pursuing Teaher Certification
    1=Yes
    2=No
    220 SFA_ORPHAN_DEC Character(1) VARCHAR2(1) NOT NULL 2425: Parent Deceased
    221 SFA_ORPHAN_FOSTER Character(1) VARCHAR2(1) NOT NULL 2425:In Foster Care
    222 SFA_ORPHAN_WARD Character(1) VARCHAR2(1) NOT NULL 2425: Ward of Court
    1=Yes
    223 SFA_STD_CIRCUM Character(1) VARCHAR2(1) NOT NULL 2425:Personal Circumstances: None of the above
    1=Yes
    2=No
    224 SFA_HOMELESS_TRIO Character(1) VARCHAR2(1) NOT NULL 2425:Unaccompanied and Homeless (TRIO)?
    1=Yes
    225 SFA_HOMELESS_FAA Character(1) VARCHAR2(1) NOT NULL 2425:Unaccompanied and Homeless (FAA)?
    1=Yes
    226 SFA_STD_OTHER Character(1) VARCHAR2(1) NOT NULL 2425:None of the above (Other Circumstances)
    1=Yes
    227 SFA_STD_UNUSUAL Character(1) VARCHAR2(1) NOT NULL 2425:Unusual Circumstance
    1=Yes
    228 SFA_STD_UNSUB Character(1) VARCHAR2(1) NOT NULL 2425: Unsub Only
    1=Yes
    2=No
    229 SFA_STD_PARATT Character(1) VARCHAR2(1) NOT NULL 2425:Either Parent Attend College
    1=Yes
    2=No
    3=Dont Know
    230 SFA_STD_PARKILL Character(1) VARCHAR2(1) NOT NULL 2425:Parent Killed in the Line of Duty
    1=Yes
    2=No
    231 SFA_HIGH_SCHL_DIPL Character(1) VARCHAR2(1) NOT NULL 2425: High School Equivalent Diploma
    232 SFA_HIGH_SCHL_DPST Character(2) VARCHAR2(2) NOT NULL 2425: High School Equivalent Diploma State
    233 SFA_STD_ETIC Character(1) VARCHAR2(1) NOT NULL 2425:Received EITC
    1=Yes
    234 SFA_STD_HOUSING Character(1) VARCHAR2(1) NOT NULL 2425:Received Federal Housing Assistance
    1=Yes
    235 SFA_STD_MEDICAID Character(1) VARCHAR2(1) NOT NULL 2425:Received Medicaid
    1=Yes
    236 SFA_STD_36B Character(1) VARCHAR2(1) NOT NULL 2425:Received Refundable Credit for 36B Health Plan
    1=Yes
    237 SFA_STD_FED_NONE Character(1) VARCHAR2(1) NOT NULL 2425:Federal Benefits: None of the Above�
    1=Yes
    238 SFA_STD_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    1=Yes
    2=No
    239 SFA_STD_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    1=Yes
    2=No
    240 SFA_STD_JOINT_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Joint Return with Current Spouse
    1=Yes
    2=No
    241 SFA_STD_TAX_RET Character(1) VARCHAR2(1) NOT NULL 2425: Student Tax Return Filing Status
    1=Yes
    2=No
    242 SFA_INC_WORK1 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    243 SFA_TAX_EXEMPT1 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    244 SFA_UNTAX_IRA1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    245 SFA_IRA_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    246 SFA_UNTAX_PEN1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    247 SFA_PEN_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    248 SFA_TAX_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425:Earned Income Tax Credit Received During Tax Year?
    249 SFA_DEDUCT_IRA1 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    250 SFA_FILED_SCHD1 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    251 SFA_SCHED_CAMT1 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    252 SFA_FED_TAX1 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    253 SFA_TAXES_PAID1 Number(9,0) DECIMAL(9) NOT NULL 2425:Income Tax Paid
    254 SFA_BL_INC_WORK1 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    255 SFA_BL_TAX_EXEMPT1 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    256 SFA_BL_UNTAX_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    257 SFA_BL_IRA_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    258 SFA_BL_UNTAX_PEN1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    259 SFA_BL_PEN_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    260 SFA_BL_AGI1 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    261 SFA_BL_DEDUCT_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    262 SFA_BL_EDU_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    263 SFA_BL_SCHED_CAMT1 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    264 SFA_BL_FED_TAX1 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    265 SFA_BL_TAX_PAID1 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    266 SFA_STD_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    267 SFA_STD_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    268 SFA_STD_SIGNDATE Date(10) DATE 2425:Signature Date
    269 SFA_SPS_FIRSTNAME Character(35) VARCHAR2(35) NOT NULL 2425: First Name
    270 SFA_SPS_MIDDLENAME Character(15) VARCHAR2(15) NOT NULL 2425:Middle Name�
    271 SFA_SPS_LASTNAME Character(35) VARCHAR2(35) NOT NULL 2425:Last Name
    272 SFA_SPS_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Spouse Suffix
    273 SFA_SPS_BIRTHDATE Date(10) DATE 2425:Spouse Birthdate
    274 SFA_SPS_SSN Character(9) VARCHAR2(9) NOT NULL 2425:Social Security Number
    275 SFA_SPS_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Spouse ITIN
    276 SFA_SPS_PHONE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Phone Number
    277 SFA_SPS_EMAIL Character(50) VARCHAR2(50) NOT NULL 2425:Spouse Email Address
    278 SFA_SPS_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Spouse Street Address
    279 SFA_SPS_CITY Character(30) VARCHAR2(30) NOT NULL 2425:Spouse City
    280 SFA_SPS_STATE Character(2) VARCHAR2(2) NOT NULL 2425:Spouse State
    281 SFA_SPS_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Zip Code
    282 SFA_SPS_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Spouse Country
    283 SFA_SPS_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    284 SFA_SPS_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    285 SFA_SPS_TAX_RET Character(1) VARCHAR2(1) NOT NULL 2425: Spouse Tax Return Filing Status
    286 SFA_INC_WORK2 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    287 SFA_TAX_EXEMPT2 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    288 SFA_UNTAX_IRA2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    289 SFA_IRA_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    290 SFA_UNTAX_PEN2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    291 SFA_PEN_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    292 SFA_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
    293 SFA_TAXES_PAID2 Number(9,0) DECIMAL(9) NOT NULL 2425: Income Tax Paid
    294 SFA_DEDUCT_IRA2 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    295 SFA_EDU_CREDIT2 Number(10,0) DECIMAL(10) NOT NULL 2425: Educational Credit
    296 SFA_FILED_SCHD2 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    297 SFA_SCHED_CAMT2 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    298 SFA_FED_TAX2 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    299 SFA_BL_INC_WORK2 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    300 SFA_BL_TAX_EXEMPT2 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    301 SFA_BL_UNTAX_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    302 SFA_BL_IRA_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    303 SFA_BL_UNTAX_PEN2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    304 SFA_BL_PEN_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    305 SFA_BL_AGI2 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    306 SFA_BL_TAX_PAID2 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    307 SFA_BL_DEDUCT_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    308 SFA_BL_EDU_CREDIT2 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    309 SFA_BL_SCHED_CAMT2 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    310 SFA_BL_FED_TAX2 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    311 SFA_SPS_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    312 SFA_SPS_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    313 SFA_SPS_SIGNDATE Date(10) DATE 2425:Signature Date
    314 SFA_ASMD_STD Character(3) VARCHAR2(3) NOT NULL 2425:Assumed Student Family Size