VIEW: APPS.IGFBV_ISIRS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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