View: IGF_AP_ISIR_INTS

Product:	IGF - Financial Aid
Description:	ISIR Interface view for holding ISIRs received from CPS
Implementation/DBA Data:	APPS.IGF_AP_ISIR_INTS

View Text

SELECT ROWID ROW_ID
, SI_ID
, BATCH_YEAR_NUM
, TRANSACTION_NUM_TXT
, SSN_NAME_CHANGE_TYPE
, ORIGINAL_SSN_TXT
, ORIG_NAME_ID_TXT
, CURRENT_SSN_TXT
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL_TXT
, PERM_MAIL_ADDRESS_TXT
, PERM_CITY_TXT
, PERM_STATE_TXT
, PERM_ZIP_CD
, BIRTH_DATE
, PHONE_NUMBER_TXT
, DRIVER_LICENSE_NUMBER_TXT
, DRIVER_LICENSE_STATE_TXT
, CITIZENSHIP_STATUS_TYPE
, ALIEN_REG_NUMBER_TXT
, S_MARITAL_STATUS_TYPE
, S_MARITAL_STATUS_DATE
, SUMM_ENRL_STATUS_TYPE
, FALL_ENRL_STATUS_TYPE
, WINTER_ENRL_STATUS_TYPE
, SPRING_ENRL_STATUS_TYPE
, SUMM2_ENRL_STATUS_TYPE
, FATHERS_HIGHST_EDU_LVL_TYPE
, MOTHERS_HIGHST_EDU_LVL_TYPE
, S_STATE_LEGAL_RESIDENCE
, LEGAL_RES_BEFORE_YEAR_FLAG
, S_LEGAL_RESD_DATE
, SS_R_U_MALE_FLAG
, SELECTIVE_SERVICE_REG_FLAG
, DEGREE_CERTIFICATION_TYPE
, GRADE_LEVEL_IN_COLLEGE_TYPE
, HIGH_SCHL_DIPLOMA_GED_FLAG
, FIRST_BACHLR_DEG_YEAR_FLAG
, INTEREST_IN_LOAN_FLAG
, INTEREST_IN_STU_EMPLOY_FLAG
, DRUG_OFFENCE_CONVICT_TYPE
, S_TAX_RETURN_STATUS_TYPE
, S_TYPE_TAX_RETURN_TYPE
, S_ELIG_1040EZ_TYPE
, S_ADJUSTED_GROSS_INCOME_AMT
, S_FED_TAXES_PAID_AMT
, S_EXEMPTIONS_AMT
, S_INCOME_FROM_WORK_AMT
, SPOUSE_INCOME_FROM_WORK_AMT
, S_TOTAL_FROM_WSA_AMT
, S_TOTAL_FROM_WSB_AMT
, S_TOTAL_FROM_WSC_AMT
, S_INVESTMENT_NETWORTH_AMT
, S_BUSI_FARM_NETWORTH_AMT
, S_CASH_SAVINGS_AMT
, VA_MONTHS_NUM
, VA_AMT
, STUD_DOB_BEFORE_YEAR_FLAG
, DEG_BEYOND_BACHELOR_FLAG
, S_MARRIED_FLAG
, S_HAVE_CHILDREN_FLAG
, LEGAL_DEPENDENTS_FLAG
, ORPHAN_WARD_OF_COURT_FLAG
, S_VETERAN_FLAG
, P_MARITAL_STATUS_TYPE
, FATHER_SSN_TXT
, F_LAST_NAME
, MOTHER_SSN_TXT
, M_LAST_NAME
, P_FAMILY_MEMBERS_NUM
, P_IN_COLLEGE_NUM
, P_STATE_LEGAL_RESIDENCE_TXT
, P_LEGAL_RES_BEFORE_DT_FLAG
, P_LEGAL_RES_DATE
, AGE_OLDER_PARENT_NUM
, P_TAX_RETURN_STATUS_TYPE
, P_TYPE_TAX_RETURN_TYPE
, P_ELIG_1040AEZ_TYPE
, P_ADJUSTED_GROSS_INCOME_AMT
, P_TAXES_PAID_AMT
, P_EXEMPTIONS_AMT
, F_INCOME_WORK_AMT
, M_INCOME_WORK_AMT
, P_INCOME_WSA_AMT
, P_INCOME_WSB_AMT
, P_INCOME_WSC_AMT
, P_INVESTMENT_NETWORTH_AMT
, P_BUSINESS_NETWORTH_AMT
, P_CASH_SAVING_AMT
, S_FAMILY_MEMBERS_NUM
, S_IN_COLLEGE_NUM
, FIRST_COLLEGE_CD
, FIRST_HOUSE_PLAN_TYPE
, SECOND_COLLEGE_CD
, SECOND_HOUSE_PLAN_TYPE
, THIRD_COLLEGE_CD
, THIRD_HOUSE_PLAN_TYPE
, FOURTH_COLLEGE_CD
, FOURTH_HOUSE_PLAN_TYPE
, FIFTH_COLLEGE_CD
, FIFTH_HOUSE_PLAN_TYPE
, SIXTH_COLLEGE_CD
, SIXTH_HOUSE_PLAN_TYPE
, APP_COMPLETED_DATE
, SIGNED_BY_TYPE
, PREPARER_SSN_TXT
, PREPARER_EMP_ID_NUMBER_TXT
, PREPARER_SIGN_FLAG
, TRANSACTION_RECEIPT_DATE
, DEPENDENCY_OVERRIDE_TYPE
, FAA_FEDRAL_SCHL_CD
, FAA_ADJUSTMENT_TYPE
, INPUT_RECORD_TYPE
, SERIAL_NUM
, BATCH_NUMBER_TXT
, EARLY_ANALYSIS_FLAG
, APP_ENTRY_SOURCE_TYPE
, ETI_DESTINATION_CD
, REJECT_OVERRIDE_B_FLAG
, REJECT_OVERRIDE_N_FLAG
, REJECT_OVERRIDE_W_FLAG
, ASSUM_OVERRIDE_1_FLAG
, ASSUM_OVERRIDE_2_FLAG
, ASSUM_OVERRIDE_3_FLAG
, ASSUM_OVERRIDE_4_FLAG
, ASSUM_OVERRIDE_5_FLAG
, ASSUM_OVERRIDE_6_FLAG
, DEPENDENCY_STATUS_TYPE
, S_EMAIL_ADDRESS_TXT
, NSLDS_REASON_CD
, APP_RECEIPT_DATE
, PROCESSED_REC_TYPE
, HIST_CORR_FOR_TRAN_NUM
, SYS_GENERATED_INDICATOR_TYPE
, DUP_REQUEST_INDICATOR_TYPE
, SOURCE_OF_CORRECTION_TYPE
, P_CAL_TAX_STATUS_TYPE
, S_CAL_TAX_STATUS_TYPE
, GRADUATE_FLAG
, AUTO_ZERO_EFC_FLAG
, EFC_CHANGE_FLAG
, SARC_FLAG
, SIMPLIFIED_NEED_TEST_FLAG
, REJECT_REASON_CODES_TXT
, SELECT_SERVICE_MATCH_TYPE
, SELECT_SERVICE_REG_TYPE
, INS_MATCH_FLAG
, INS_VERIFICATION_NUM
, SEC_INS_MATCH_TYPE
, SEC_INS_VER_NUM
, SSN_MATCH_TYPE
, SSA_CITIZENSHIP_TYPE
, SSN_DEATH_DATE
, NSLDS_MATCH_TYPE
, VA_MATCH_TYPE
, PRISONER_MATCH_FLAG
, VERIFICATION_FLAG
, SUBSEQUENT_APP_FLAG
, APP_SOURCE_SITE_CD
, TRAN_SOURCE_SITE_CD
, DRN_NUM
, TRAN_PROCESS_DATE
, CORRECTION_FLAGS_TXT
, COMPUTER_BATCH_NUM
, HIGHLIGHT_FLAGS_TXT
, PAID_EFC_AMT
, PRIMARY_EFC_AMT
, SECONDARY_EFC_AMT
, FED_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SEC_EFC_TYPE
, PRIMARY_ALT_MONTH_1_AMT
, PRIMARY_ALT_MONTH_2_AMT
, PRIMARY_ALT_MONTH_3_AMT
, PRIMARY_ALT_MONTH_4_AMT
, PRIMARY_ALT_MONTH_5_AMT
, PRIMARY_ALT_MONTH_6_AMT
, PRIMARY_ALT_MONTH_7_AMT
, PRIMARY_ALT_MONTH_8_AMT
, PRIMARY_ALT_MONTH_10_AMT
, PRIMARY_ALT_MONTH_11_AMT
, PRIMARY_ALT_MONTH_12_AMT
, SEC_ALTERNATE_MONTH_1_AMT
, SEC_ALTERNATE_MONTH_2_AMT
, SEC_ALTERNATE_MONTH_3_AMT
, SEC_ALTERNATE_MONTH_4_AMT
, SEC_ALTERNATE_MONTH_5_AMT
, SEC_ALTERNATE_MONTH_6_AMT
, SEC_ALTERNATE_MONTH_7_AMT
, SEC_ALTERNATE_MONTH_8_AMT
, SEC_ALTERNATE_MONTH_10_AMT
, SEC_ALTERNATE_MONTH_11_AMT
, SEC_ALTERNATE_MONTH_12_AMT
, TOTAL_INCOME_AMT
, ALLOW_TOTAL_INCOME_AMT
, STATE_TAX_ALLOW_AMT
, EMPLOYMENT_ALLOW_AMT
, INCOME_PROTECTION_ALLOW_AMT
, AVAILABLE_INCOME_AMT
, CONTRIBUTION_FROM_AI_AMT
, DISCRETIONARY_NETWORTH_AMT
, EFC_NETWORTH_AMT
, ASSET_PROTECT_ALLOW_AMT
, PARENTS_CONT_FROM_ASSETS_AMT
, ADJUSTED_AVAIL_INCOME_AMT
, TOTAL_STUDENT_CONTRIB_AMT
, TOTAL_PARENT_CONTRIB_AMT
, PARENTS_CONTRIBUTION_AMT
, STUDENT_TOTAL_INCOME_AMT
, SATI_AMT
, SIC_AMT
, SDNW_AMT
, SCA_AMT
, FTI_AMT
, SECTI_AMT
, SECATI_AMT
, SECSTX_AMT
, SECEA_AMT
, SECIPA_AMT
, SECAI_AMT
, SECCAI_AMT
, SECDNW_AMT
, SECNW_AMT
, SECAPA_AMT
, SECPCA_AMT
, SECAAI_AMT
, SECTSC_AMT
, SECTPC_AMT
, SECPC_AMT
, SECSTI_AMT
, SECSATI_AMT
, SECSIC_AMT
, SECSDNW_AMT
, SECSCA_AMT
, SECFTI_AMT
, A_CITIZENSHIP_FLAG
, A_STUDNT_MARITAL_STATUS_FLAG
, A_STUDENT_AGI_AMT
, A_S_US_TAX_PAID_AMT
, A_S_INCOME_WORK_AMT
, A_SPOUSE_INCOME_WORK_AMT
, A_S_TOTAL_WSC_AMT
, A_DATE_OF_BIRTH_FLAG
, A_STUDENT_MARRIED_FLAG
, A_HAVE_CHILDREN_FLAG
, A_S_HAVE_DEPENDENTS_FLAG
, A_VA_STATUS_FLAG
, A_S_IN_FAMILY_NUM
, A_S_IN_COLLEGE_NUM
, A_P_MARITAL_STATUS_FLAG
, A_FATHER_SSN_TXT
, A_MOTHER_SSN_TXT
, A_PARENTS_FAMILY_NUM
, A_PARENTS_COLLEGE_NUM
, A_PARENTS_AGI_AMT
, A_P_US_TAX_PAID_AMT
, A_F_WORK_INCOME_AMT
, A_M_WORK_INCOME_AMT
, A_P_TOTAL_WSC_AMT
, COMMENT_CODES_TXT
, SAR_ACK_COMM_CODES_TXT
, PELL_GRANT_ELIG_FLAG
, REPROCESS_REASON_CD
, DUPLICATE_DATE
, ISIR_TRANSACTION_TYPE
, FEDRAL_SCHL_TYPE
, MULTI_SCHOOL_CD_FLAGS_TXT
, DUP_SSN_INDICATOR_FLAG
, NSLDS_TRANSACTION_NUM
, NSLDS_DATABASE_RESULTS_TYPE
, NSLDS_FLAG
, NSLDS_PELL_OVERPAY_TYPE
, NSLDS_PELL_OVERPAY_CONT_TXT
, NSLDS_SEOG_OVERPAY_TYPE
, NSLDS_SEOG_OVERPAY_CONT_TXT
, NSLDS_PERKINS_OVERPAY_TYPE
, NSLDS_PERK_OVRPAY_CNTCT_TXT
, NSLDS_DEFAULTED_LOAN_FLAG
, NSLDS_DISCHARGED_LOAN_TYPE
, NSLDS_SATIS_REPAY_FLAG
, NSLDS_ACT_BANKRUPTCY_FLAG
, NSLDS_AGG_SUBSZ_OUT_PBAL_AMT
, NSLDS_AGG_UNSBZ_OUT_PBAL_AMT
, NSLDS_AGG_COMB_OUT_PBAL_AMT
, NSLDS_AGG_CONS_OUT_PBAL_AMT
, NSLDS_AGG_SUBSZ_PND_DISB_AMT
, NSLDS_AGG_UNSBZ_PND_DISB_AMT
, NSLDS_AGG_COMB_PEND_DISB_AMT
, NSLDS_AGG_SUBSZ_TOTAL_AMT
, NSLDS_AGG_UNSBZ_TOTAL_AMT
, NSLDS_AGG_COMB_TOTAL_AMT
, NSLDS_AGG_CONSD_TOTAL_AMT
, NSLDS_PERKINS_OUT_BAL_AMT
, NSLDS_PERKIN_CUR_YR_DISB_AMT
, NSLDS_DEFAULT_LOAN_CHNG_FLAG
, NSLDS_DISCHGD_LOAN_CHNG_FLAG
, NSLDS_SATIS_REPAY_CHNG_FLAG
, NSLDS_ACT_BNKRUPT_CHNG_FLAG
, NSLDS_OVERPAY_CHNG_FLAG
, NSLDS_AGG_LOAN_CHNG_FLAG
, NSLDS_PERKINS_LOAN_CHNG_FLAG
, NSLDS_PELL_PAYMNT_CHNG_FLAG
, NSLDS_ADDTNL_PELL_FLAG
, NSLDS_ADDTNL_LOAN_FLAG
, DIRECT_LOAN_MAS_PROM_NT_TYPE
, NSLDS_PELL_1_SEQ_NUM
, NSLDS_PELL_1_VERIFY_F_TXT
, NSLDS_PELL_1_EFC_AMT
, NSLDS_PELL_1_SCHOOL_NUM
, NSLDS_PELL_1_TRANSCN_NUM
, NSLDS_PELL_1_LAST_UPDT_DATE
, NSLDS_PELL_1_SCHEDULED_AMT
, NSLDS_PELL_1_PAID_TODT_AMT
, NSLDS_PELL_1_REMNG_AMT
, NSLDS_PELL_1_PC_SCWD_USE_AMT
, NSLDS_PELL_1_AWARD_AMT
, NSLDS_PELL_2_SEQ_NUM
, NSLDS_PELL_2_VERIFY_F_TXT
, NSLDS_PELL_2_EFC_AMT
, NSLDS_PELL_2_SCHOOL_NUM
, NSLDS_PELL_2_TRANSCN_NUM
, NSLDS_PELL_2_LAST_UPDT_DATE
, NSLDS_PELL_2_SCHEDULED_AMT
, NSLDS_PELL_2_PAID_TODT_AMT
, NSLDS_PELL_2_REMNG_AMT
, NSLDS_PELL_2_PC_SCWD_USE_AMT
, NSLDS_PELL_2_AWARD_AMT
, NSLDS_PELL_3_SEQ_NUM
, NSLDS_PELL_3_VERIFY_F_TXT
, NSLDS_PELL_3_EFC_AMT
, NSLDS_PELL_3_SCHOOL_NUM
, NSLDS_PELL_3_TRANSCN_NUM
, NSLDS_PELL_3_LAST_UPDT_DATE
, NSLDS_PELL_3_SCHEDULED_AMT
, NSLDS_PELL_3_PAID_TODT_AMT
, NSLDS_PELL_3_REMNG_AMT
, NSLDS_PELL_3_PC_SCWD_USE_AMT
, NSLDS_PELL_3_AWARD_AMT
, NSLDS_LOAN_1_SEQ_NUM
, NSLDS_LOAN_1_TYPE
, NSLDS_LOAN_1_CHNG_FLAG
, NSLDS_LOAN_1_PROG_CD
, NSLDS_LOAN_1_NET_AMT
, NSLDS_LOAN_1_CUR_ST_CD
, NSLDS_LOAN_1_CUR_ST_DATE
, NSLDS_LOAN_1_AGG_PR_BAL_AMT
, NSLDS_LOAN_1_OUT_PR_BAL_DATE
, NSLDS_LOAN_1_BEGIN_DATE
, NSLDS_LOAN_1_END_DATE
, NSLDS_LOAN_1_GA_CD
, NSLDS_LOAN_1_CONT_TYPE
, NSLDS_LOAN_1_SCHOL_CD
, NSLDS_LOAN_1_CONT_CD
, NSLDS_LOAN_1_GRADE_LVL_TXT
, NSLDS_LOAN_1_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_1_CAPTAL_INT_FLAG
, NSLDS_LOAN_2_SEQ_NUM
, NSLDS_LOAN_2_TYPE
, NSLDS_LOAN_2_CHNG_FLAG
, NSLDS_LOAN_2_PROG_CD
, NSLDS_LOAN_2_NET_AMT
, NSLDS_LOAN_2_CUR_ST_CD
, NSLDS_LOAN_2_CUR_ST_DATE
, NSLDS_LOAN_2_AGG_PR_BAL_AMT
, NSLDS_LOAN_2_OUT_PR_BAL_DATE
, NSLDS_LOAN_2_BEGIN_DATE
, NSLDS_LOAN_2_END_DATE
, NSLDS_LOAN_2_GA_CD
, NSLDS_LOAN_2_CONT_TYPE
, NSLDS_LOAN_2_SCHOL_CD
, NSLDS_LOAN_2_CONT_CD
, NSLDS_LOAN_2_GRADE_LVL_TXT
, NSLDS_LOAN_2_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_2_CAPTAL_INT_FLAG
, NSLDS_LOAN_3_SEQ_NUM
, NSLDS_LOAN_3_TYPE
, NSLDS_LOAN_3_CHNG_FLAG
, NSLDS_LOAN_3_PROG_CD
, NSLDS_LOAN_3_NET_AMT
, NSLDS_LOAN_3_CUR_ST_CD
, NSLDS_LOAN_3_CUR_ST_DATE
, NSLDS_LOAN_3_AGG_PR_BAL_AMT
, NSLDS_LOAN_3_OUT_PR_BAL_DATE
, NSLDS_LOAN_3_BEGIN_DATE
, NSLDS_LOAN_3_END_DATE
, NSLDS_LOAN_3_GA_CD
, NSLDS_LOAN_3_CONT_TYPE
, NSLDS_LOAN_3_SCHOL_CD
, NSLDS_LOAN_3_CONT_CD
, NSLDS_LOAN_3_GRADE_LVL_TXT
, NSLDS_LOAN_3_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_3_CAPTAL_INT_FLAG
, NSLDS_LOAN_4_SEQ_NUM
, NSLDS_LOAN_4_TYPE
, NSLDS_LOAN_4_CHNG_FLAG
, NSLDS_LOAN_4_PROG_CD
, NSLDS_LOAN_4_NET_AMT
, NSLDS_LOAN_4_CUR_ST_CD
, NSLDS_LOAN_4_CUR_ST_DATE
, NSLDS_LOAN_4_AGG_PR_BAL_AMT
, NSLDS_LOAN_4_OUT_PR_BAL_DATE
, NSLDS_LOAN_4_BEGIN_DATE
, NSLDS_LOAN_4_END_DATE
, NSLDS_LOAN_4_GA_CD
, NSLDS_LOAN_4_CONT_TYPE
, NSLDS_LOAN_4_SCHOL_CD
, NSLDS_LOAN_4_CONT_CD
, NSLDS_LOAN_4_GRADE_LVL_TXT
, NSLDS_LOAN_4_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_4_CAPTAL_INT_FLAG
, NSLDS_LOAN_5_SEQ_NUM
, NSLDS_LOAN_5_TYPE
, NSLDS_LOAN_5_CHNG_FLAG
, NSLDS_LOAN_5_PROG_CD
, NSLDS_LOAN_5_NET_AMT
, NSLDS_LOAN_5_CUR_ST_CD
, NSLDS_LOAN_5_CUR_ST_DATE
, NSLDS_LOAN_5_AGG_PR_BAL_AMT
, NSLDS_LOAN_5_OUT_PR_BAL_DATE
, NSLDS_LOAN_5_BEGIN_DATE
, NSLDS_LOAN_5_END_DATE
, NSLDS_LOAN_5_GA_CD
, NSLDS_LOAN_5_CONT_TYPE
, NSLDS_LOAN_5_SCHOL_CD
, NSLDS_LOAN_5_CONT_CD
, NSLDS_LOAN_5_GRADE_LVL_TXT
, NSLDS_LOAN_5_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_5_CAPTAL_INT_FLAG
, NSLDS_LOAN_6_SEQ_NUM
, NSLDS_LOAN_6_TYPE
, NSLDS_LOAN_6_CHNG_FLAG
, NSLDS_LOAN_6_PROG_CD
, NSLDS_LOAN_6_NET_AMT
, NSLDS_LOAN_6_CUR_ST_CD
, NSLDS_LOAN_6_CUR_ST_DATE
, NSLDS_LOAN_6_AGG_PR_BAL_AMT
, NSLDS_LOAN_6_OUT_PR_BAL_DATE
, NSLDS_LOAN_6_BEGIN_DATE
, NSLDS_LOAN_6_END_DATE
, NSLDS_LOAN_6_GA_CD
, NSLDS_LOAN_6_CONT_TYPE
, NSLDS_LOAN_6_SCHOL_CD
, NSLDS_LOAN_6_CONT_CD
, NSLDS_LOAN_6_GRADE_LVL_TXT
, NSLDS_LOAN_6_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_6_CAPTAL_INT_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NSLDS_LOAN_1_LAST_DISB_AMT
, NSLDS_LOAN_1_LAST_DISB_DATE
, NSLDS_LOAN_2_LAST_DISB_AMT
, NSLDS_LOAN_2_LAST_DISB_DATE
, NSLDS_LOAN_3_LAST_DISB_AMT
, NSLDS_LOAN_3_LAST_DISB_DATE
, NSLDS_LOAN_4_LAST_DISB_AMT
, NSLDS_LOAN_4_LAST_DISB_DATE
, NSLDS_LOAN_5_LAST_DISB_AMT
, NSLDS_LOAN_5_LAST_DISB_DATE
, NSLDS_LOAN_6_LAST_DISB_AMT
, NSLDS_LOAN_6_LAST_DISB_DATE
, VERIF_TRACK_TYPE
, FAFSA_DATA_VERIFICATION_TXT
, REJECT_OVERRIDE_A_FLAG
, REJECT_OVERRIDE_C_FLAG
, PARENT_MARITAL_STATUS_DATE
, DLP_MASTER_PROM_NOTE_TYPE
, FATHR_FIRST_NAME_INITIAL_TXT
, FATHR_STEP_FATHER_BIRTH_DATE
, MOTHR_FIRST_NAME_INITIAL_TXT
, MOTHR_STEP_MOTHER_BIRTH_DATE
, PARENTS_EMAIL_ADDRESS_TXT
, ADDRESS_CHANGE_TYPE
, CPS_PUSHED_ISIR_FLAG
, ELECTRONIC_TRANSACTION_TYPE
, SAR_C_CHANGE_TYPE
, FATHER_SSN_MATCH_TYPE
, MOTHER_SSN_MATCH_TYPE
, SUBSIDIZED_LOAN_LIMIT_TYPE
, COMBINED_LOAN_LIMIT_TYPE
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
, RECORD_STATUS
, DATA_FILE_NAME_TXT
, MATCH_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REJECT_OVERRIDE_3_FLAG
, REJECT_OVERRIDE_12_FLAG
, REJECT_OVERRIDE_J_FLAG
, REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
, PARENT_REQ_ID
, SUB_REQ_NUM
FROM IGF_AP_ISIR_INTS_ALL

Columns