VIEW: APPS.IGF_AP_ISIR_MATCHED

Source

View Text - Preformatted

SELECT ISIRM.ROWID ,ISIRM.ISIR_ID ,ISIRM.BASE_ID ,ISIRM.BATCH_YEAR ,ISIRM.TRANSACTION_NUM ,ISIRM.CURRENT_SSN ,ISIRM.SSN_NAME_CHANGE ,ISIRM.ORIGINAL_SSN ,ISIRM.ORIG_NAME_ID ,ISIRM.LAST_NAME ,ISIRM.FIRST_NAME ,ISIRM.MIDDLE_INITIAL ,ISIRM.PERM_MAIL_ADD ,ISIRM.PERM_CITY ,ISIRM.PERM_STATE ,ISIRM.PERM_ZIP_CODE ,ISIRM.DATE_OF_BIRTH ,ISIRM.PHONE_NUMBER ,ISIRM.DRIVER_LICENSE_NUMBER ,ISIRM.DRIVER_LICENSE_STATE ,ISIRM.CITIZENSHIP_STATUS ,ISIRM.ALIEN_REG_NUMBER ,ISIRM.S_MARITAL_STATUS ,ISIRM.S_MARITAL_STATUS_DATE ,ISIRM.SUMM_ENRL_STATUS ,ISIRM.FALL_ENRL_STATUS ,ISIRM.WINTER_ENRL_STATUS ,ISIRM.SPRING_ENRL_STATUS ,ISIRM.SUMM2_ENRL_STATUS ,ISIRM.FATHERS_HIGHEST_EDU_LEVEL ,ISIRM.MOTHERS_HIGHEST_EDU_LEVEL ,ISIRM.S_STATE_LEGAL_RESIDENCE ,ISIRM.LEGAL_RESIDENCE_BEFORE_DATE ,ISIRM.S_LEGAL_RESD_DATE ,ISIRM.SS_R_U_MALE ,ISIRM.SELECTIVE_SERVICE_REG ,ISIRM.DEGREE_CERTIFICATION ,ISIRM.GRADE_LEVEL_IN_COLLEGE ,ISIRM.HIGH_SCHOOL_DIPLOMA_GED ,ISIRM.FIRST_BACHELOR_DEG_BY_DATE ,ISIRM.INTEREST_IN_LOAN ,ISIRM.INTEREST_IN_STUD_EMPLOYMENT ,ISIRM.DRUG_OFFENCE_CONVICTION ,ISIRM.S_TAX_RETURN_STATUS ,ISIRM.S_TYPE_TAX_RETURN ,ISIRM.S_ELIG_1040EZ ,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 ,ISIRM.STUD_DOB_BEFORE_DATE ,ISIRM.DEG_BEYOND_BACHELOR ,ISIRM.S_MARRIED ,ISIRM.S_HAVE_CHILDREN ,ISIRM.LEGAL_DEPENDENTS ,ISIRM.ORPHAN_WARD_OF_COURT ,ISIRM.S_VETERAN ,ISIRM.P_MARITAL_STATUS ,ISIRM.FATHER_SSN ,ISIRM.F_LAST_NAME ,ISIRM.MOTHER_SSN ,ISIRM.M_LAST_NAME ,ISIRM.P_NUM_FAMILY_MEMBER ,ISIRM.P_NUM_IN_COLLEGE ,ISIRM.P_STATE_LEGAL_RESIDENCE ,ISIRM.P_STATE_LEGAL_RES_BEFORE_DT ,ISIRM.P_LEGAL_RES_DATE ,ISIRM.AGE_OLDER_PARENT ,ISIRM.P_TAX_RETURN_STATUS ,ISIRM.P_TYPE_TAX_RETURN ,ISIRM.P_ELIG_1040AEZ ,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 ,ISIRM.FIRST_HOUSE_PLAN ,ISIRM.SECOND_COLLEGE ,ISIRM.SECOND_HOUSE_PLAN ,ISIRM.THIRD_COLLEGE ,ISIRM.THIRD_HOUSE_PLAN ,ISIRM.FOURTH_COLLEGE ,ISIRM.FOURTH_HOUSE_PLAN ,ISIRM.FIFTH_COLLEGE ,ISIRM.FIFTH_HOUSE_PLAN ,ISIRM.SIXTH_COLLEGE ,ISIRM.SIXTH_HOUSE_PLAN ,ISIRM.DATE_APP_COMPLETED ,ISIRM.SIGNED_BY ,ISIRM.PREPARER_SSN ,ISIRM.PREPARER_EMP_ID_NUMBER ,ISIRM.PREPARER_SIGN ,ISIRM.TRANSACTION_RECEIPT_DATE ,ISIRM.DEPENDENCY_OVERRIDE_IND ,ISIRM.FAA_FEDRAL_SCHL_CODE ,ISIRM.FAA_ADJUSTMENT ,ISIRM.INPUT_RECORD_TYPE ,ISIRM.SERIAL_NUMBER ,ISIRM.BATCH_NUMBER ,ISIRM.EARLY_ANALYSIS_FLAG ,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 ,ISIRM.DEPENDENCY_STATUS ,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 ,NULL ,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 ,ISIRM.ISIR_TRANSACTION_TYPE ,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.CREATED_BY ,ISIRM.CREATION_DATE ,ISIRM.LAST_UPDATED_BY ,ISIRM.LAST_UPDATE_DATE ,ISIRM.LAST_UPDATE_LOGIN ,ISIRM.REQUEST_ID ,ISIRM.PROGRAM_APPLICATION_ID ,ISIRM.PROGRAM_ID ,ISIRM.PROGRAM_UPDATE_DATE ,ISIRM.ORG_ID ,ISIRM.VERIF_TRACK_FLAG ,ISIRM.ACTIVE_ISIR , ISIRM.FAFSA_DATA_VERIFY_FLAGS , ISIRM.REJECT_OVERRIDE_A , ISIRM.REJECT_OVERRIDE_C , ISIRM.PARENT_MARITAL_STATUS_DATE ,LEGACY_RECORD_FLAG , 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.REJECT_OVERRIDE_G_FLAG , ISIRM.DHS_VERIFICATION_NUM_TXT , ISIRM.DATA_FILE_NAME_TXT , ISIRM.MESSAGE_CLASS_TXT , ISIRM.REJECT_OVERRIDE_3_FLAG , ISIRM.REJECT_OVERRIDE_12_FLAG , ISIRM.REJECT_OVERRIDE_J_FLAG , ISIRM.REJECT_OVERRIDE_K_FLAG , ISIRM.REJECTED_STATUS_CHANGE_FLAG , ISIRM.VERIFICATION_SELECTION_FLAG FROM igf_ap_isir_matched_all isirm WHERE NVL (isirm.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ISIRM.ROWID
, ISIRM.ISIR_ID
, ISIRM.BASE_ID
, ISIRM.BATCH_YEAR
, ISIRM.TRANSACTION_NUM
, ISIRM.CURRENT_SSN
, ISIRM.SSN_NAME_CHANGE
, ISIRM.ORIGINAL_SSN
, ISIRM.ORIG_NAME_ID
, ISIRM.LAST_NAME
, ISIRM.FIRST_NAME
, ISIRM.MIDDLE_INITIAL
, ISIRM.PERM_MAIL_ADD
, ISIRM.PERM_CITY
, ISIRM.PERM_STATE
, ISIRM.PERM_ZIP_CODE
, ISIRM.DATE_OF_BIRTH
, ISIRM.PHONE_NUMBER
, ISIRM.DRIVER_LICENSE_NUMBER
, ISIRM.DRIVER_LICENSE_STATE
, ISIRM.CITIZENSHIP_STATUS
, ISIRM.ALIEN_REG_NUMBER
, ISIRM.S_MARITAL_STATUS
, ISIRM.S_MARITAL_STATUS_DATE
, ISIRM.SUMM_ENRL_STATUS
, ISIRM.FALL_ENRL_STATUS
, ISIRM.WINTER_ENRL_STATUS
, ISIRM.SPRING_ENRL_STATUS
, ISIRM.SUMM2_ENRL_STATUS
, ISIRM.FATHERS_HIGHEST_EDU_LEVEL
, ISIRM.MOTHERS_HIGHEST_EDU_LEVEL
, ISIRM.S_STATE_LEGAL_RESIDENCE
, ISIRM.LEGAL_RESIDENCE_BEFORE_DATE
, ISIRM.S_LEGAL_RESD_DATE
, ISIRM.SS_R_U_MALE
, ISIRM.SELECTIVE_SERVICE_REG
, ISIRM.DEGREE_CERTIFICATION
, ISIRM.GRADE_LEVEL_IN_COLLEGE
, ISIRM.HIGH_SCHOOL_DIPLOMA_GED
, ISIRM.FIRST_BACHELOR_DEG_BY_DATE
, ISIRM.INTEREST_IN_LOAN
, ISIRM.INTEREST_IN_STUD_EMPLOYMENT
, ISIRM.DRUG_OFFENCE_CONVICTION
, ISIRM.S_TAX_RETURN_STATUS
, ISIRM.S_TYPE_TAX_RETURN
, ISIRM.S_ELIG_1040EZ
, 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
, ISIRM.STUD_DOB_BEFORE_DATE
, ISIRM.DEG_BEYOND_BACHELOR
, ISIRM.S_MARRIED
, ISIRM.S_HAVE_CHILDREN
, ISIRM.LEGAL_DEPENDENTS
, ISIRM.ORPHAN_WARD_OF_COURT
, ISIRM.S_VETERAN
, ISIRM.P_MARITAL_STATUS
, ISIRM.FATHER_SSN
, ISIRM.F_LAST_NAME
, ISIRM.MOTHER_SSN
, ISIRM.M_LAST_NAME
, ISIRM.P_NUM_FAMILY_MEMBER
, ISIRM.P_NUM_IN_COLLEGE
, ISIRM.P_STATE_LEGAL_RESIDENCE
, ISIRM.P_STATE_LEGAL_RES_BEFORE_DT
, ISIRM.P_LEGAL_RES_DATE
, ISIRM.AGE_OLDER_PARENT
, ISIRM.P_TAX_RETURN_STATUS
, ISIRM.P_TYPE_TAX_RETURN
, ISIRM.P_ELIG_1040AEZ
, 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
, ISIRM.FIRST_HOUSE_PLAN
, ISIRM.SECOND_COLLEGE
, ISIRM.SECOND_HOUSE_PLAN
, ISIRM.THIRD_COLLEGE
, ISIRM.THIRD_HOUSE_PLAN
, ISIRM.FOURTH_COLLEGE
, ISIRM.FOURTH_HOUSE_PLAN
, ISIRM.FIFTH_COLLEGE
, ISIRM.FIFTH_HOUSE_PLAN
, ISIRM.SIXTH_COLLEGE
, ISIRM.SIXTH_HOUSE_PLAN
, ISIRM.DATE_APP_COMPLETED
, ISIRM.SIGNED_BY
, ISIRM.PREPARER_SSN
, ISIRM.PREPARER_EMP_ID_NUMBER
, ISIRM.PREPARER_SIGN
, ISIRM.TRANSACTION_RECEIPT_DATE
, ISIRM.DEPENDENCY_OVERRIDE_IND
, ISIRM.FAA_FEDRAL_SCHL_CODE
, ISIRM.FAA_ADJUSTMENT
, ISIRM.INPUT_RECORD_TYPE
, ISIRM.SERIAL_NUMBER
, ISIRM.BATCH_NUMBER
, ISIRM.EARLY_ANALYSIS_FLAG
, 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
, ISIRM.DEPENDENCY_STATUS
, 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
, NULL
, 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
, ISIRM.ISIR_TRANSACTION_TYPE
, 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.CREATED_BY
, ISIRM.CREATION_DATE
, ISIRM.LAST_UPDATED_BY
, ISIRM.LAST_UPDATE_DATE
, ISIRM.LAST_UPDATE_LOGIN
, ISIRM.REQUEST_ID
, ISIRM.PROGRAM_APPLICATION_ID
, ISIRM.PROGRAM_ID
, ISIRM.PROGRAM_UPDATE_DATE
, ISIRM.ORG_ID
, ISIRM.VERIF_TRACK_FLAG
, ISIRM.ACTIVE_ISIR
, ISIRM.FAFSA_DATA_VERIFY_FLAGS
, ISIRM.REJECT_OVERRIDE_A
, ISIRM.REJECT_OVERRIDE_C
, ISIRM.PARENT_MARITAL_STATUS_DATE
, LEGACY_RECORD_FLAG
, 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.REJECT_OVERRIDE_G_FLAG
, ISIRM.DHS_VERIFICATION_NUM_TXT
, ISIRM.DATA_FILE_NAME_TXT
, ISIRM.MESSAGE_CLASS_TXT
, ISIRM.REJECT_OVERRIDE_3_FLAG
, ISIRM.REJECT_OVERRIDE_12_FLAG
, ISIRM.REJECT_OVERRIDE_J_FLAG
, ISIRM.REJECT_OVERRIDE_K_FLAG
, ISIRM.REJECTED_STATUS_CHANGE_FLAG
, ISIRM.VERIFICATION_SELECTION_FLAG
FROM IGF_AP_ISIR_MATCHED_ALL ISIRM
WHERE NVL (ISIRM.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)