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]

View: IGFBV_ISIRS

Product:	IGF - Financial Aid (Obsolete)
Description:	Base View for the Entity that holds the complete ISIR record of the students
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ISIRM.BATCH_YEAR
, ISIRM.TRANSACTION_NUM
, ISIRM.CURRENT_SSN
, '_LA:ISIRM.SSN_NAME_CHANGE:IGF_LOOKUPS_VIEW:IGF_SSNCHANGE_TYPE:MEANING'
, ISIRM.ORIGINAL_SSN
, ISIRM.ORIG_NAME_ID
, ISIRM.LAST_NAME
, ISIRM.FIRST_NAME
, ISIRM.MIDDLE_INITIAL
, ISIRM.PERM_MAIL_ADD
, ISIRM.PERM_CITY
, '_LA:ISIRM.PERM_STATE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, ISIRM.PERM_ZIP_CODE
, ISIRM.DATE_OF_BIRTH
, ISIRM.PHONE_NUMBER
, ISIRM.DRIVER_LICENSE_NUMBER
, '_LA:ISIRM.DRIVER_LICENSE_STATE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, '_LA:ISIRM.CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_CITIZENSHIP_TYPE:MEANING'
, ISIRM.ALIEN_REG_NUMBER
, '_LA:ISIRM.S_MARITAL_STATUS:IGF_LOOKUPS_VIEW:IGF_ST_MARITAL_STAT_TYPE:MEANING'
, ISIRM.S_MARITAL_STATUS_DATE
, '_LA:ISIRM.SUMM_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.FALL_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.WINTER_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.SPRING_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.SUMM2_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.FATHERS_HIGHEST_EDU_LEVEL:IGF_LOOKUPS_VIEW:IGF_HIGH_GRAD_LVL_TYPE:MEANING'
, '_LA:ISIRM.MOTHERS_HIGHEST_EDU_LEVEL:IGF_LOOKUPS_VIEW:IGF_HIGH_GRAD_LVL_TYPE:MEANING'
, '_LA:ISIRM.S_STATE_LEGAL_RESIDENCE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, '_LA:ISIRM.LEGAL_RESIDENCE_BEFORE_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, ISIRM.S_LEGAL_RESD_DATE
, '_LA:ISIRM.SS_R_U_MALE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.SELECTIVE_SERVICE_REG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DEGREE_CERTIFICATION:IGF_LOOKUPS_VIEW:IGF_DEG_CERT_TYPE:MEANING'
, '_LA:ISIRM.GRADE_LEVEL_IN_COLLEGE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING'
, '_LA:ISIRM.HIGH_SCHOOL_DIPLOMA_GED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.FIRST_BACHELOR_DEG_BY_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.INTEREST_IN_LOAN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.INTEREST_IN_STUD_EMPLOYMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DRUG_OFFENCE_CONVICTION:IGF_LOOKUPS_VIEW:IGF_DRUG_ELIGIBILITY_TYPE:MEANING'
, '_LA:ISIRM.S_TAX_RETURN_STATUS:IGF_LOOKUPS_VIEW:IGF_TAX_RET_STAT_TYPE:MEANING'
, '_LA:ISIRM.S_TYPE_TAX_RETURN:IGF_LOOKUPS_VIEW:IGF_TAX_FORM_TYPE:MEANING'
, '_LA:ISIRM.S_ELIG_1040EZ:IGF_LOOKUPS_VIEW:IGF_TAX_EXEMPTION_ELIG_TYPE:MEANING'
, ISIRM.S_ADJUSTED_GROSS_INCOME
, ISIRM.S_FED_TAXES_PAID
, ISIRM.S_EXEMPTIONS
, ISIRM.S_INCOME_FROM_WORK
, ISIRM.SPOUSE_INCOME_FROM_WORK
, ISIRM.S_TOA_AMT_FROM_WSA
, ISIRM.S_TOA_AMT_FROM_WSB
, ISIRM.S_TOA_AMT_FROM_WSC
, ISIRM.S_INVESTMENT_NETWORTH
, ISIRM.S_BUSI_FARM_NETWORTH
, ISIRM.S_CASH_SAVINGS
, ISIRM.VA_MONTHS
, ISIRM.VA_AMOUNT
, '_LA:ISIRM.STUD_DOB_BEFORE_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DEG_BEYOND_BACHELOR:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_MARRIED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_HAVE_CHILDREN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.LEGAL_DEPENDENTS:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.ORPHAN_WARD_OF_COURT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_VETERAN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.P_MARITAL_STATUS:IGF_LOOKUPS_VIEW:IGF_P_MARITAL_STAT_TYPE:MEANING'
, ISIRM.FATHER_SSN
, ISIRM.F_LAST_NAME
, ISIRM.MOTHER_SSN
, ISIRM.M_LAST_NAME
, ISIRM.P_NUM_FAMILY_MEMBER
, ISIRM.P_NUM_IN_COLLEGE
, '_LA:ISIRM.P_STATE_LEGAL_RESIDENCE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, ISIRM.P_STATE_LEGAL_RES_BEFORE_DT
, ISIRM.P_LEGAL_RES_DATE
, ISIRM.AGE_OLDER_PARENT
, '_LA:ISIRM.P_TAX_RETURN_STATUS:IGF_LOOKUPS_VIEW:IGF_TAX_RET_STAT_TYPE:MEANING'
, '_LA:ISIRM.P_TYPE_TAX_RETURN:IGF_LOOKUPS_VIEW:IGF_TAX_FORM_TYPE:MEANING'
, '_LA:ISIRM.P_ELIG_1040AEZ:IGF_LOOKUPS_VIEW:IGF_TAX_EXEMPTION_ELIG_TYPE:MEANING'
, ISIRM.P_ADJUSTED_GROSS_INCOME
, ISIRM.P_TAXES_PAID
, ISIRM.P_EXEMPTIONS
, ISIRM.F_INCOME_WORK
, ISIRM.M_INCOME_WORK
, ISIRM.P_INCOME_WSA
, ISIRM.P_INCOME_WSB
, ISIRM.P_INCOME_WSC
, ISIRM.P_INVESTMENT_NETWORTH
, ISIRM.P_BUSINESS_NETWORTH
, ISIRM.P_CASH_SAVING
, ISIRM.S_NUM_FAMILY_MEMBERS
, ISIRM.S_NUM_IN_COLLEGE
, ISIRM.FIRST_COLLEGE
, '_LA:ISIRM.FIRST_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.SECOND_COLLEGE
, '_LA:ISIRM.SECOND_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.THIRD_COLLEGE
, '_LA:ISIRM.THIRD_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.FOURTH_COLLEGE
, '_LA:ISIRM.FOURTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.FIFTH_COLLEGE
, '_LA:ISIRM.FIFTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.SIXTH_COLLEGE
, '_LA:ISIRM.SIXTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.DATE_APP_COMPLETED
, '_LA:ISIRM.SIGNED_BY:IGF_LOOKUPS_VIEW:IGF_SIGN_TYPE:MEANING'
, ISIRM.PREPARER_SSN
, ISIRM.PREPARER_EMP_ID_NUMBER
, ISIRM.PREPARER_SIGN
, ISIRM.TRANSACTION_RECEIPT_DATE
, '_LA:ISIRM.DEPENDENCY_OVERRIDE_IND:IGF_LOOKUPS_VIEW:IGF_DPND_ORIDE_TYPE:MEANING'
, ISIRM.FAA_FEDRAL_SCHL_CODE
, '_LA:ISIRM.FAA_ADJUSTMENT:IGF_LOOKUPS_VIEW:IGF_FAA_EFC_TYPE:MEANING'
, '_LA:ISIRM.INPUT_RECORD_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_INPUT_RECORD_TYPE:MEANING'
, ISIRM.SERIAL_NUMBER
, ISIRM.BATCH_NUMBER
, '_LA:ISIRM.EARLY_ANALYSIS_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_EARLY_ANALYSIS_FLAG:MEANING'
, ISIRM.APP_ENTRY_SOURCE_CODE
, ISIRM.ETI_DESTINATION_CODE
, ISIRM.REJECT_OVERRIDE_B
, ISIRM.REJECT_OVERRIDE_N
, ISIRM.REJECT_OVERRIDE_W
, ISIRM.ASSUM_OVERRIDE_1
, ISIRM.ASSUM_OVERRIDE_2
, ISIRM.ASSUM_OVERRIDE_3
, ISIRM.ASSUM_OVERRIDE_4
, ISIRM.ASSUM_OVERRIDE_5
, ISIRM.ASSUM_OVERRIDE_6
, '_LA:ISIRM.DEPENDENCY_STATUS:IGF_LOOKUPS_VIEW:IGF_AP_DEP_STATUS:MEANING'
, ISIRM.S_EMAIL_ADDRESS
, ISIRM.NSLDS_REASON_CODE
, ISIRM.APP_RECEIPT_DATE
, ISIRM.PROCESSED_REC_TYPE
, ISIRM.HIST_CORRECTION_FOR_TRAN_ID
, ISIRM.SYSTEM_GENERATED_INDICATOR
, ISIRM.DUP_REQUEST_INDICATOR
, ISIRM.SOURCE_OF_CORRECTION
, ISIRM.P_CAL_TAX_STATUS
, ISIRM.S_CAL_TAX_STATUS
, ISIRM.GRADUATE_FLAG
, ISIRM.AUTO_ZERO_EFC
, ISIRM.EFC_CHANGE_FLAG
, ISIRM.SARC_FLAG
, ISIRM.SIMPLIFIED_NEED_TEST
, ISIRM.REJECT_REASON_CODES
, ISIRM.SELECT_SERVICE_MATCH_FLAG
, ISIRM.SELECT_SERVICE_REG_FLAG
, ISIRM.INS_MATCH_FLAG
, ISIRM.INS_VERIFICATION_NUMBER
, ISIRM.SEC_INS_MATCH_FLAG
, ISIRM.SEC_INS_VER_NUMBER
, ISIRM.SSN_MATCH_FLAG
, ISIRM.SSA_CITIZENSHIP_FLAG
, ISIRM.SSN_DATE_OF_DEATH
, ISIRM.NSLDS_MATCH_FLAG
, ISIRM.VA_MATCH_FLAG
, ISIRM.PRISONER_MATCH
, ISIRM.VERIFICATION_FLAG
, ISIRM.SUBSEQUENT_APP_FLAG
, ISIRM.APP_SOURCE_SITE_CODE
, ISIRM.TRAN_SOURCE_SITE_CODE
, ISIRM.DRN
, ISIRM.TRAN_PROCESS_DATE
, ISIRM.CORRECTION_FLAGS
, ISIRM.COMPUTER_BATCH_NUMBER
, ISIRM.HIGHLIGHT_FLAGS
, ISIRM.PAID_EFC
, ISIRM.PRIMARY_EFC
, ISIRM.SECONDARY_EFC
, ISIRM.FED_PELL_GRANT_EFC_TYPE
, ISIRM.PRIMARY_EFC_TYPE
, ISIRM.SEC_EFC_TYPE
, ISIRM.PRIMARY_ALTERNATE_MONTH_1
, ISIRM.PRIMARY_ALTERNATE_MONTH_2
, ISIRM.PRIMARY_ALTERNATE_MONTH_3
, ISIRM.PRIMARY_ALTERNATE_MONTH_4
, ISIRM.PRIMARY_ALTERNATE_MONTH_5
, ISIRM.PRIMARY_ALTERNATE_MONTH_6
, ISIRM.PRIMARY_ALTERNATE_MONTH_7
, ISIRM.PRIMARY_ALTERNATE_MONTH_8
, ISIRM.PRIMARY_ALTERNATE_MONTH_10
, ISIRM.PRIMARY_ALTERNATE_MONTH_11
, ISIRM.PRIMARY_ALTERNATE_MONTH_12
, ISIRM.SEC_ALTERNATE_MONTH_1
, ISIRM.SEC_ALTERNATE_MONTH_2
, ISIRM.SEC_ALTERNATE_MONTH_3
, ISIRM.SEC_ALTERNATE_MONTH_4
, ISIRM.SEC_ALTERNATE_MONTH_5
, ISIRM.SEC_ALTERNATE_MONTH_6
, ISIRM.SEC_ALTERNATE_MONTH_7
, ISIRM.SEC_ALTERNATE_MONTH_8
, ISIRM.SEC_ALTERNATE_MONTH_10
, ISIRM.SEC_ALTERNATE_MONTH_11
, ISIRM.SEC_ALTERNATE_MONTH_12
, ISIRM.TOTAL_INCOME
, ISIRM.ALLOW_TOTAL_INCOME
, ISIRM.STATE_TAX_ALLOW
, ISIRM.EMPLOYMENT_ALLOW
, ISIRM.INCOME_PROTECTION_ALLOW
, ISIRM.AVAILABLE_INCOME
, ISIRM.CONTRIBUTION_FROM_AI
, ISIRM.DISCRETIONARY_NETWORTH
, ISIRM.EFC_NETWORTH
, ISIRM.ASSET_PROTECT_ALLOW
, ISIRM.PARENTS_CONT_FROM_ASSETS
, ISIRM.ADJUSTED_AVAILABLE_INCOME
, ISIRM.TOTAL_STUDENT_CONTRIBUTION
, ISIRM.TOTAL_PARENT_CONTRIBUTION
, ISIRM.PARENTS_CONTRIBUTION
, ISIRM.STUDENT_TOTAL_INCOME
, ISIRM.SATI
, ISIRM.SIC
, ISIRM.SDNW
, ISIRM.SCA
, ISIRM.FTI
, ISIRM.SECTI
, ISIRM.SECATI
, ISIRM.SECSTX
, ISIRM.SECEA
, ISIRM.SECIPA
, ISIRM.SECAI
, ISIRM.SECCAI
, ISIRM.SECDNW
, ISIRM.SECNW
, ISIRM.SECAPA
, ISIRM.SECPCA
, ISIRM.SECAAI
, ISIRM.SECTSC
, ISIRM.SECTPC
, ISIRM.SECPC
, ISIRM.SECSTI
, ISIRM.SECSATI
, ISIRM.SECSIC
, ISIRM.SECSDNW
, ISIRM.SECSCA
, ISIRM.SECFTI
, ISIRM.A_CITIZENSHIP
, ISIRM.A_STUDENT_MARITAL_STATUS
, ISIRM.A_STUDENT_AGI
, ISIRM.A_S_US_TAX_PAID
, ISIRM.A_S_INCOME_WORK
, ISIRM.A_SPOUSE_INCOME_WORK
, ISIRM.A_S_TOTAL_WSC
, ISIRM.A_DATE_OF_BIRTH
, ISIRM.A_STUDENT_MARRIED
, ISIRM.A_HAVE_CHILDREN
, ISIRM.A_S_HAVE_DEPENDENTS
, ISIRM.A_VA_STATUS
, ISIRM.A_S_NUM_IN_FAMILY
, ISIRM.A_S_NUM_IN_COLLEGE
, ISIRM.A_P_MARITAL_STATUS
, ISIRM.A_FATHER_SSN
, ISIRM.A_MOTHER_SSN
, ISIRM.A_PARENTS_NUM_FAMILY
, ISIRM.A_PARENTS_NUM_COLLEGE
, ISIRM.A_PARENTS_AGI
, ISIRM.A_P_US_TAX_PAID
, ISIRM.A_F_WORK_INCOME
, ISIRM.A_M_WORK_INCOME
, ISIRM.A_P_TOTAL_WSC
, ISIRM.COMMENT_CODES
, ISIRM.SAR_ACK_COMM_CODE
, ISIRM.PELL_GRANT_ELIG_FLAG
, ISIRM.REPROCESS_REASON_CODE
, ISIRM.DUPLICATE_DATE
, '_LA:ISIRM.ISIR_TRANSACTION_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_TRANSACTION_TYPE:MEANING'
, ISIRM.FEDRAL_SCHL_CODE_INDICATOR
, ISIRM.MULTI_SCHOOL_CODE_FLAGS
, ISIRM.DUP_SSN_INDICATOR
, ISIRM.PAYMENT_ISIR
, ISIRM.RECEIPT_STATUS
, ISIRM.ISIR_RECEIPT_COMPLETED
, ISIRM.SYSTEM_RECORD_TYPE
, ISIRM.VERIF_TRACK_FLAG
, ISIRM.ACTIVE_ISIR
, ISIRM.REJECT_OVERRIDE_A
, ISIRM.FAFSA_DATA_VERIFY_FLAGS
, ISIRM.REJECT_OVERRIDE_C
, ISIRM.PARENT_MARITAL_STATUS_DATE
, '_LA:LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, ISIRM.FATHER_FIRST_NAME_INITIAL_TXT
, ISIRM.FATHER_STEP_FATHER_BIRTH_DATE
, ISIRM.MOTHER_FIRST_NAME_INITIAL_TXT
, ISIRM.MOTHER_STEP_MOTHER_BIRTH_DATE
, ISIRM.PARENTS_EMAIL_ADDRESS_TXT
, ISIRM.ADDRESS_CHANGE_TYPE
, ISIRM.CPS_PUSHED_ISIR_FLAG
, ISIRM.ELECTRONIC_TRANSACTION_TYPE
, ISIRM.SAR_C_CHANGE_TYPE
, ISIRM.FATHER_SSN_MATCH_TYPE
, ISIRM.MOTHER_SSN_MATCH_TYPE
, ISIRM.DATA_FILE_NAME_TXT
, ISIRM.MESSAGE_CLASS_TXT
, '_LA:ISIRM.REJECT_OVERRIDE_G_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_3_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_12_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_J_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_K_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, ISIRM.REJECTED_STATUS_CHANGE_FLAG
, ISIRM.VERIFICATION_SELECTION_FLAG
, ISIRM.BASE_ID
, ISIRM.ISIR_ID
, ISIRM.CREATED_BY
, ISIRM.CREATION_DATE
, ISIRM.LAST_UPDATED_BY
, ISIRM.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_AP_ISIR_MATCHED_ALL ISIRM
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE FABASE.BASE_ID = ISIRM.BASE_ID WITH READ ONLY

Columns

Name
BATCH_YEAR
TRANSACTION_NUMBER
CURRENT_SSN
"_LA:SSN_LAST_NAME_CHNGE_FLAG"
ORIGINAL_SSN
ORIGINAL_NAME_ID
LAST_NAME
FIRST_NAME
MIDDLE_INITIAL
PERMANENT_MAIL_ADDRESS
PERMANENT_CITY
"_LA:PERMANENT_STATE"
PERMANENT_ZIP_CODE
DATE_OF_BIRTH
PERMANENT_PHONE_NUMBER
DRIVERS_LICENSE_NUMBER
"_LA:DRIVERS_LICENSE_STATE"
"_LA:CITIZENSHIP_STATUS"
ALIEN_REGISTRATION_NUMBER
"_LA:MARITAL_STATUS"
MARITAL_STATUS_DATE
"_LA:SUMMER_ENROLLMENT_STATUS"
"_LA:FALL_ENROLLMENT_STATUS"
"_LA:WINTER_ENROLLMENT_STATUS"
"_LA:SPRING_ENROLLMENT_STATUS"
"_LA:SUMMER2_ENROLMENT_STATUS"
"_LA:FATHERS_HIGH_GRADE_LEVEL"
"_LA:MOTHERS_HIGH_GRADE_LEVEL"
"_LA:STATE_LEGAL_RESIDENCE"
"_LA:LEGAL_RESIDN_BEFORE_DATE"
LEGAL_RESIDENCE_DATE
"_LA:ARE_YOU_MALE"
"_LA:SELECT_SERVICE_REG_FLAG"
"_LA:DEGREE_CERTIFICATION"
"_LA:GRADE_LEVEL_IN_COLLEGE"
"_LA:HS_DIPLOMA_GED_RECEIVED"
"_LA:FIRST_BACHELOR_DEG_DATE"
"_LA:INTERESTED_IN_LOANS"
"_LA:INTERESTED_IN_EMPLOYMENT"
"_LA:DRUG_OFENCE_CONVICT_ELIG"
"_LA:TAX_RETURN_STATUS"
"_LA:TYPE_OF_TAX_RETURN_FORM"
"_LA:ELIGIBLE_TO_FILE_1040EZ"
ADJUSTED_IRS_GROSS_INCOME
FEDERAL_TAXES_PAID
EXEMPTIONS_CLAIMED
INCOME_EARNED_FROM_WORK
SPOUSE_INCOME_EARN_FROM_WORK
TOTAL_AMOUNT_FROM_WORKSHEET_A
TOTAL_AMOUNT_FROM_WORKSHEET_B
TOTAL_AMOUNT_FROM_WORKSHEET_C
INVESTMENT_NETWORTH
BUSINESS_INVEST_FARM_NETWORTH
CASH_SAVINGS_CHECKING
NUMBER_OF_VETERAN_MONTHS
MONTHLY_VETERANS_EDU_BENFITS
"_LA:BORN_BEFORE_DATE"
"_LA:DEGREE_BEYOND_BACHELOR"
"_LA:IS_STUDENT_MARRIED"
"_LA:HAVE_CHILDREN_YOU_SUPORT"
"_LA:LEGAL_DEPENDENTS"
"_LA:ORPHAN_WARD_OF_COURT"
"_LA:VETERAN_OF_USA_FORCES"
"_LA:PARENT_MARITAL_STATUS"
FATHER_SSN
FATHER_LAST_NAME
MOTHER_SSN
MOTHER_LAST_NAME
PARENTS_NUMBER_FAMILY_MEMBERS
PARENTS_NUMBER_IN_COLLEGE
"_LA:PARENTS_ST_LEGL_RESDENCE"
PARENTS_LEGAL_RESID_BEFORE_DT
PARENTS_LEGAL_RESIDENCE_DATE
AGE_OF_OLDER_PARENT
"_LA:PARENTS_TAX_RETUN_STATUS"
"_LA:PARENTS_TYPE_TAX_RETURN"
"_LA:PARENTS_ELIGIBLE_1040AEZ"
PARENTS_ADJUSTED_GROSS_INCOME
PARENTS_TAXES_PAID
PARENTS_EXEMPTIONS_CLAIMED
FATHER_INCOME_FROM_WORK
MOTHER_INCOME_FROM_WORK
PARENT_INCOME_FROM_WORKSHEET_A
PARENT_INCOME_FROM_WORKSHEET_B
PARENT_INCOME_FROM_WORKSHEET_C
PPARENT_INVESTMENT_NETWORTH
PARENT_BUSINESS_NETWORTH
PARENT_CASH_SAVING_CHECKING
STUDENT_NUMBER_FAMILY_MEMBERS
STUDENT_NUMBER_IN_COLLEGE
FEDERAL_1_SCHOOL_CODE
"_LA:FEDERAL_1_HOUSING_PLAN"
FEDERAL_2_SCHOOL_CODE
"_LA:FEDERAL_2_HOUSING_PLAN"
FEDERAL_3_SCHOOL_CODE
"_LA:FEDERAL_3_HOUSING_PLAN"
FEDERAL_4_SCHOOL_CODE
"_LA:FEDERAL_4_HOUSING_PLAN"
FEDERAL_5_SCHOOL_CODE
"_LA:FEDERAL_5_HOUSING_PLAN"
FEDERAL_6_SCHOOL_CODE
"_LA:FEDERAL_6_HOUSING_PLAN"
DATE_APPLICATION_COMPLETED
"_LA:SIGNED_BY"
PREPARER_SSN
PREPARER_EMPLOYEE_ID_NUMBER
PREPARER_SIGNATURE
TRANSACTION_RECEIPT_DATE
"_LA:DEPENDENCY_OVERRIDE_IND"
FAA_FEDRAL_SCHOOL_CODE
"_LA:FAA_ADJUSTMENT"
"_LA:INPUT_RECORD_TYPE"
SERIAL_NUMBER
BATCH_NUMBER
"_LA:EARLY_ANALYSIS_FLAG"
APPLICATION_ENTRY_SOURCE_CODE
ETI_DESTINATION_CODE
REJECT_OVERRIDE_B
REJECT_OVERRIDE_N
REJECT_OVERRIDE_W
ASSUMPTION_1_OVERRIDE
ASSUMPTION_2_OVERRIDE
ASSUMPTION_3_OVERRIDE
ASSUMPTION_4_OVERRIDE
ASSUMPTION_5_OVERRIDE
ASSUMPTION_6_OVERRIDE
"_LA:DEPENDENCY_STATUS"
STUDENT_EMAIL_ADDRESS
NSLDS_REASON_CODE
APPLICATION_RECEIPT_DATE
PROCESSED_RECORD_TYPE
HIST_CORRECTION_FOR_TRAN_ID
SYSTEM_GENERATED_INDICATOR
DUPLICATE_REQUEST_INDICATOR
SOURCE_OF_CORRECTION
PARENT_CALCULATED_TAX_STATUS
STUDENT_CALCULATED_TAX_STATUS
GRADUATE_FLAG
AUTOMATIC_ZERO_EFC
EFC_CHANGE_FLAG
SAR_C_FLAG
SIMPLIFIED_NEEDS_TEST
REJECT_REASON_CODES
SELECT_SERVICE_MATCH_FLAG
SELECT_SERVICE_REGISTR_FLAG
INS_MATCH_FLAG
INS_VERIFICATION_NUMBER
SECONDARY_INS_MATCH_FLAG
SECONDARY_INS_VER_NUMBER
SSN_MATCH_FLAG
SSA_CITIZENSHIP_FLAG
SSN_DATE_OF_DEATH
NSLDS_MATCH_FLAG
VA_MATCH_FLAG
PRISONER_MATCH
VERIFICATION_TRACKING_FLAG
SUBSEQUENT_APPLICATION_FLAG
APP_DATA_SOURCE_SITE_CODE
TRANSACTION_SOURCE_SITE_CODE
DATA_RELEASE_NUMBER
TRANSACTION_PROCESSED_DATE
CORRECTION_FLAGS
COMPUTER_BATCH_NUMBER
HIGHLIGHT_FLAGS
PAID_EFC
PRIMARY_EFC
SECONDARY_EFC
FEDERAL_PELL_GRANT_EFC_TYPE
PRIMARY_EFC_TYPE
SECONDARY_EFC_TYPE
PRIMARY_ALTERNATE_MONTH_1
PRIMARY_ALTERNATE_MONTH_2
PRIMARY_ALTERNATE_MONTH_3
PRIMARY_ALTERNATE_MONTH_4
PRIMARY_ALTERNATE_MONTH_5
PRIMARY_ALTERNATE_MONTH_6
PRIMARY_ALTERNATE_MONTH_7
PRIMARY_ALTERNATE_MONTH_8
PRIMARY_ALTERNATE_MONTH_10
PRIMARY_ALTERNATE_MONTH_11
PRIMARY_ALTERNATE_MONTH_12
SECONDARY_ALTERNATE_MONTH_1
SECONDARY_ALTERNATE_MONTH_2
SECONDARY_ALTERNATE_MONTH_3
SECONDARY_ALTERNATE_MONTH_4
SECONDARY_ALTERNATE_MONTH_5
SECONDARY_ALTERNATE_MONTH_6
SECONDARY_ALTERNATE_MONTH_7
SECONDARY_ALTERNATE_MONTH_8
SECONDARY_ALTERNATE_MONTH_10
SECONDARY_ALTERNATE_MONTH_11
SECONDARY_ALTERNATE_MONTH_12
TOTAL_INCOME
ALLOWANCES_TOTAL_INCOME
STATE_AND_OTHER_TAX_ALLOWANCE
EMPLOYMENT_ALLOWANCE
INCOME_PROTECTION_ALLOWANCE
AVAILABLE_INCOME
CONTRIBUTION_FROM_AI
DISCRETIONARY_NET_WORTH
EFC_NET_WORTH
ASSET_PROTECT_ALLOWANCE
PARENTS_CONT_FROM_ASSETS
ADJUSTED_AVAILABLE_INCOME
TOTAL_STUDENT_CONTRIBUTION
TOTAL_PARENT_CONTRIBUTION
PARENTS_CONTRIBUTION
STUDENT_TOTAL_INCOME
STUDENT_ATI
STU_DEPENDENET_INCOME_CONTIBUT
STU_DISCRETIONARY_NET_WORTH
STU_CONTRIBUTION_FROM_ASSETS
FISAP_TOTAL_INCOME
SECONDARY_TOTAL_INCOME
SEC_ALLOW_AGAINST_TOTAL_INCOME
SEC_STATE_TAX_ALLOWANCE
SEC_EMPLOYMENT_ALLOWANCE
SEC_INCOME_PROTECT_ALLOWANCE
SEC_AVAILABLE_INCOME
SEC_CONTR_FROM_AVAIAL_INCOME
SEC_DISCRETIONARY_NET_WORTH
SEC_NET_WORTH
SEC_ASSET_PROTECT_ALLOWANCE
SEC_PARENTS_CONT_FROM_ASSETS
SEC_ADJUSTED_AVAILABLE_INCOME
SEC_TOTAL_STUDENT_CONTRIBUTION
SEC_TOTAL_PARENT_CONTRIBUTION
SEC_PARENTS_CONTRIBUTION
SEC_STUDENT_TOTAL_INCOME
SEC_STUDENT_ALLOWANCE_ATI
SEC_STUD_DEPEN_INCOME_CONTIBUT
SEC_STUD_DISCRET_NET_WORTH
SEC_STUD_CONTRIB_FROM_ASSETS
SEC_STUD_FISAP_TOTAL_INCOME
ASSUMED_CITIZENSHIP
ASSUMED_STUDENT_MARITAL_STATUS
ASSUMED_STUDENT_AGI
ASSUMED_STUDENT_US_TAX_PAID
ASSUMED_STUDENT_INCOME_WORK
ASSUMED_SPOUSE_INCOME_WORK
ASSUMED_STUDENT_TOTAL_WSC
ASSUMED_DATE_OF_BIRTH
ASSUMED_STUDENT_MARRIED
ASSUMED_HAVE_CHILDREN
ASSUMED_STUDENT_HAVE_DEPENDENT
ASSUMED_VA_STATUS
ASSUMED_STUDENT_NUM_IN_FAMILY
ASSUMED_STUDENT_NUM_IN_COLLEGE
ASSUMED_PARENT_MARITAL_STATUS
ASSUMED_FATHER_SSN
ASSUMED_MOTHER_SSN
ASSUMED_PARENT_NUMBER_FAMILY
ASSUMED_PARENT_NUMBER_COLLEGE
ASSUMED_PARENT_AGI
ASSUMED_PARENT_US_TAX_PAID
ASSUMED_FATHER_WORK_INCOME
ASSUMED_MOTHER_WORK_INCOME
ASSUMED_PARENT_TOTAL_WSC
COMMENT_CODES
SAR_ACKNOWLEDGE_COMMENT_CODES
PELL_GRANT_ELIGIBILITY_FLAG
REPROCESSED_REASON_CODE
DUPLICATE_DATE
"_LA:ISIR_TRANSACTION_TYPE"
FEDRAL_SCHOOL_CODE_INDICATOR
MULTI_SCHOOL_CODE_FLAGS
DUPLICATE_SSN_INDICATOR
PAYMENT_ISIR
RECEIPT_STATUS
ISIR_RECEIPT_COMPLETED
SYSTEM_RECORD_TYPE
VERIFICATION_TRACK_FLAG
ACTIVE_ISIR
REJECT_OVERRIDE_A
FAFSA_DATA_VERIFY_FLAGS
REJECT_OVERRIDE_C
PARENT_MARITAL_STATUS_DATE
"_LA:LEGACY_RECORD_FLAG"
FATHER_STEP_FIRST_NAME_INITIAL
FATHER_STEP_FATHER_BIRTH_DATE
MOTHER_STEP_FIRST_NAME_INITIAL
MOTHER_STEP_MOTHER_BIRTH_DATE
PARENTS_EMAIL_ADDRESS
ADDRESS_CHANGE_TYPE
CPS_PUSHED_ISIR_FLAG
ELECTRONIC_TRANSACT_TYPE
SAR_C_CHANGE_TYPE
FATHER_SSN_MATCH_TYPE
MOTHER_SSN_MATCH_TYPE
DATA_FILE_NAME
MESSAGE_CLASS
"_LA:REJECT_OVERRIDE_G_FLAG"
"_LA:REJECT_OVERRIDE_3_FLAG"
"_LA:REJECT_OVERRIDE_12_FLAG"
"_LA:REJECT_OVERRIDE_J_FLAG"
"_LA:REJECT_OVERRIDE_K_FLAG"
REJECTED_STATUS_CHANGE_FLAG
VERIFICATION_SELECTION_FLAG
BASE_ID
ISIR_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
PERSON_ID