VIEW: APPS.IGF_AP_ISIR_INTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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