VIEW: APPS.IGF_AP_ISIR_INTRFACE

Source

View Text - Preformatted

SELECT ROWID ,SI_ID ,BATCH_YEAR ,TRANSACTION_NUM ,RECORD_STATUS ,SSN_NAME_CHANGE ,ORIGINAL_SSN ,ORIG_NAME_ID ,CURRENT_SSN ,LAST_NAME ,FIRST_NAME ,MIDDLE_INITIAL ,PERM_MAIL_ADD ,PERM_CITY ,PERM_STATE ,PERM_ZIP_CODE ,DATE_OF_BIRTH ,PHONE_NUMBER ,DRIVER_LICENSE_NUMBER ,DRIVER_LICENSE_STATE ,CITIZENSHIP_STATUS ,ALIEN_REG_NUMBER ,S_MARITAL_STATUS ,S_MARITAL_STATUS_DATE ,SUMM_ENRL_STATUS ,FALL_ENRL_STATUS ,WINTER_ENRL_STATUS ,SPRING_ENRL_STATUS ,SUMM2_ENRL_STATUS ,FATHERS_HIGHEST_EDU_LEVEL ,MOTHERS_HIGHEST_EDU_LEVEL ,S_STATE_LEGAL_RESIDENCE ,LEGAL_RESIDENCE_BEFORE_DATE ,S_LEGAL_RESD_DATE ,SS_R_U_MALE ,SELECTIVE_SERVICE_REG ,DEGREE_CERTIFICATION ,GRADE_LEVEL_IN_COLLEGE ,HIGH_SCHOOL_DIPLOMA_GED ,FIRST_BACHELOR_DEG_BY_DATE ,INTEREST_IN_LOAN ,INTEREST_IN_STUD_EMPLOYMENT ,DRUG_OFFENCE_CONVICTION ,S_TAX_RETURN_STATUS ,S_TYPE_TAX_RETURN ,S_ELIG_1040EZ ,S_ADJUSTED_GROSS_INCOME ,S_FED_TAXES_PAID ,S_EXEMPTIONS ,S_INCOME_FROM_WORK ,SPOUSE_INCOME_FROM_WORK ,S_TOA_AMT_FROM_WSA ,S_TOA_AMT_FROM_WSB ,S_TOA_AMT_FROM_WSC ,S_INVESTMENT_NETWORTH ,S_BUSI_FARM_NETWORTH ,S_CASH_SAVINGS ,VA_MONTHS ,VA_AMOUNT ,STUD_DOB_BEFORE_DATE ,DEG_BEYOND_BACHELOR ,S_MARRIED ,S_HAVE_CHILDREN ,LEGAL_DEPENDENTS ,ORPHAN_WARD_OF_COURT ,S_VETERAN ,P_MARITAL_STATUS ,FATHER_SSN ,F_LAST_NAME ,MOTHER_SSN ,M_LAST_NAME ,P_NUM_FAMILY_MEMBER ,P_NUM_IN_COLLEGE ,P_STATE_LEGAL_RESIDENCE ,P_STATE_LEGAL_RES_BEFORE_DT ,P_LEGAL_RES_DATE ,AGE_OLDER_PARENT ,P_TAX_RETURN_STATUS ,P_TYPE_TAX_RETURN ,P_ELIG_1040AEZ ,P_ADJUSTED_GROSS_INCOME ,P_TAXES_PAID ,P_EXEMPTIONS ,F_INCOME_WORK ,M_INCOME_WORK ,P_INCOME_WSA ,P_INCOME_WSB ,P_INCOME_WSC ,P_INVESTMENT_NETWORTH ,P_BUSINESS_NETWORTH ,P_CASH_SAVING ,S_NUM_FAMILY_MEMBERS ,S_NUM_IN_COLLEGE ,FIRST_COLLEGE ,FIRST_HOUSE_PLAN ,SECOND_COLLEGE ,SECOND_HOUSE_PLAN ,THIRD_COLLEGE ,THIRD_HOUSE_PLAN ,FOURTH_COLLEGE ,FOURTH_HOUSE_PLAN ,FIFTH_COLLEGE ,FIFTH_HOUSE_PLAN ,SIXTH_COLLEGE ,SIXTH_HOUSE_PLAN ,DATE_APP_COMPLETED ,SIGNED_BY ,PREPARER_SSN ,PREPARER_EMP_ID_NUMBER ,PREPARER_SIGN ,TRANSACTION_RECEIPT_DATE ,DEPENDENCY_OVERRIDE_IND ,FAA_FEDRAL_SCHL_CODE ,FAA_ADJUSTMENT ,INPUT_RECORD_TYPE ,SERIAL_NUMBER ,BATCH_NUMBER ,EARLY_ANALYSIS_FLAG ,APP_ENTRY_SOURCE_CODE ,ETI_DESTINATION_CODE ,REJECT_OVERRIDE_B ,REJECT_OVERRIDE_N ,REJECT_OVERRIDE_W ,ASSUM_OVERRIDE_1 ,ASSUM_OVERRIDE_2 ,ASSUM_OVERRIDE_3 ,ASSUM_OVERRIDE_4 ,ASSUM_OVERRIDE_5 ,ASSUM_OVERRIDE_6 ,DEPENDENCY_STATUS ,S_EMAIL_ADDRESS ,NSLDS_REASON_CODE ,APP_RECEIPT_DATE ,PROCESSED_REC_TYPE ,HIST_CORRECTION_FOR_TRAN_ID ,SYSTEM_GENERATED_INDICATOR ,DUP_REQUEST_INDICATOR ,SOURCE_OF_CORRECTION ,P_CAL_TAX_STATUS ,S_CAL_TAX_STATUS ,GRADUATE_FLAG ,AUTO_ZERO_EFC ,EFC_CHANGE_FLAG ,SARC_FLAG ,SIMPLIFIED_NEED_TEST ,REJECT_REASON_CODES ,SELECT_SERVICE_MATCH_FLAG ,SELECT_SERVICE_REG_FLAG ,INS_MATCH_FLAG ,NULL ,SEC_INS_MATCH_FLAG ,SEC_INS_VER_NUMBER ,SSN_MATCH_FLAG ,SSA_CITIZENSHIP_FLAG ,SSN_DATE_OF_DEATH ,NSLDS_MATCH_FLAG ,VA_MATCH_FLAG ,PRISONER_MATCH ,VERIFICATION_FLAG ,SUBSEQUENT_APP_FLAG ,APP_SOURCE_SITE_CODE ,TRAN_SOURCE_SITE_CODE ,DRN ,TRAN_PROCESS_DATE ,CORRECTION_FLAGS ,COMPUTER_BATCH_NUMBER ,HIGHLIGHT_FLAGS ,PAID_EFC ,PRIMARY_EFC ,SECONDARY_EFC ,FED_PELL_GRANT_EFC_TYPE ,PRIMARY_EFC_TYPE ,SEC_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 ,SEC_ALTERNATE_MONTH_1 ,SEC_ALTERNATE_MONTH_2 ,SEC_ALTERNATE_MONTH_3 ,SEC_ALTERNATE_MONTH_4 ,SEC_ALTERNATE_MONTH_5 ,SEC_ALTERNATE_MONTH_6 ,SEC_ALTERNATE_MONTH_7 ,SEC_ALTERNATE_MONTH_8 ,SEC_ALTERNATE_MONTH_10 ,SEC_ALTERNATE_MONTH_11 ,SEC_ALTERNATE_MONTH_12 ,TOTAL_INCOME ,ALLOW_TOTAL_INCOME ,STATE_TAX_ALLOW ,EMPLOYMENT_ALLOW ,INCOME_PROTECTION_ALLOW ,AVAILABLE_INCOME ,CONTRIBUTION_FROM_AI ,DISCRETIONARY_NETWORTH ,EFC_NETWORTH ,ASSET_PROTECT_ALLOW ,PARENTS_CONT_FROM_ASSETS ,ADJUSTED_AVAILABLE_INCOME ,TOTAL_STUDENT_CONTRIBUTION ,TOTAL_PARENT_CONTRIBUTION ,PARENTS_CONTRIBUTION ,STUDENT_TOTAL_INCOME ,SATI ,SIC ,SDNW ,SCA ,FTI ,SECTI ,SECATI ,SECSTX ,SECEA ,SECIPA ,SECAI ,SECCAI ,SECDNW ,SECNW ,SECAPA ,SECPCA ,SECAAI ,SECTSC ,SECTPC ,SECPC ,SECSTI ,SECSATI ,SECSIC ,SECSDNW ,SECSCA ,SECFTI ,A_CITIZENSHIP ,A_STUDENT_MARITAL_STATUS ,A_STUDENT_AGI ,A_S_US_TAX_PAID ,A_S_INCOME_WORK ,A_SPOUSE_INCOME_WORK ,A_S_TOTAL_WSC ,A_DATE_OF_BIRTH ,A_STUDENT_MARRIED ,A_HAVE_CHILDREN ,A_S_HAVE_DEPENDENTS ,A_VA_STATUS ,A_S_NUM_IN_FAMILY ,A_S_NUM_IN_COLLEGE ,A_P_MARITAL_STATUS ,A_FATHER_SSN ,A_MOTHER_SSN ,A_PARENTS_NUM_FAMILY ,A_PARENTS_NUM_COLLEGE ,A_PARENTS_AGI ,A_P_US_TAX_PAID ,A_F_WORK_INCOME ,A_M_WORK_INCOME ,A_P_TOTAL_WSC ,COMMENT_CODES ,SAR_ACK_COMM_CODE ,PELL_GRANT_ELIG_FLAG ,REPROCESS_REASON_CODE ,DUPLICATE_DATE ,ISIR_TRANSACTION_TYPE ,FEDRAL_SCHL_CODE_INDICATOR ,MULTI_SCHOOL_CODE_FLAGS ,DUP_SSN_INDICATOR ,NSLDS_TRANSACTION_NUM ,NSLDS_DATABASE_RESULTS_F ,NSLDS_F ,NSLDS_PELL_OVERPAY_F ,NSLDS_PELL_OVERPAY_CONTACT ,NSLDS_SEOG_OVERPAY_F ,NSLDS_SEOG_OVERPAY_CONTACT ,NSLDS_PERKINS_OVERPAY_F ,NSLDS_PERKINS_OVERPAY_CNTCT ,NSLDS_DEFAULTED_LOAN_F ,NSLDS_DISCHARGED_LOAN_F ,NSLDS_SATIS_REPAY_F ,NSLDS_ACT_BANKRUPTCY_F ,NSLDS_AGG_SUBSZ_OUT_PRIN_BAL ,NSLDS_AGG_UNSBZ_OUT_PRIN_BAL ,NSLDS_AGG_COMB_OUT_PRIN_BAL ,NSLDS_AGG_CONS_OUT_PRIN_BAL ,NSLDS_AGG_SUBSZ_PEND_DISMNT ,NSLDS_AGG_UNSBZ_PEND_DISMNT ,NSLDS_AGG_COMB_PEND_DISMNT ,NSLDS_AGG_SUBSZ_TOTAL ,NSLDS_AGG_UNSBZ_TOTAL ,NSLDS_AGG_COMB_TOTAL ,NSLDS_AGG_CONSD_TOTAL ,NSLDS_PERKINS_OUT_BAL ,NSLDS_PERKINS_CUR_YR_DISMNT ,NSLDS_DEFAULT_LOAN_CHNG_F ,NSLDS_DISCHGED_LOAN_CHNG_F ,NSLDS_SATIS_REPAY_CHNG_F ,NSLDS_ACT_BNKRUPT_CHNG_F ,NSLDS_OVERPAY_CHNG_F ,NSLDS_AGG_LOAN_CHNG_F ,NSLDS_PERKINS_LOAN_CHNG_F ,NSLDS_PELL_PAYMNT_CHNG_F ,NSLDS_ADDTNL_PELL_F ,NSLDS_ADDTNL_LOAN_F ,DIRECT_LOAN_MAS_PROM_NT_F ,NSLDS_PELL_SEQ_NUM_1 ,NSLDS_PELL_VERIFY_F_1 ,NSLDS_PELL_EFC_1 ,NSLDS_PELL_SCHOOL_CODE_1 ,NSLDS_PELL_TRANSCN_NUM_1 ,NSLDS_PELL_LAST_UPDT_DT_1 ,NSLDS_PELL_SCHEDULED_AMT_1 ,NSLDS_PELL_AMT_PAID_TODT_1 ,NSLDS_PELL_REMNG_AMT_1 ,NSLDS_PELL_PC_SCHD_AWD_US_1 ,NSLDS_PELL_AWARD_AMT_1 ,NSLDS_PELL_SEQ_NUM_2 ,NSLDS_PELL_VERIFY_F_2 ,NSLDS_PELL_EFC_2 ,NSLDS_PELL_SCHOOL_CODE_2 ,NSLDS_PELL_TRANSCN_NUM_2 ,NSLDS_PELL_LAST_UPDT_DT_2 ,NSLDS_PELL_SCHEDULED_AMT_2 ,NSLDS_PELL_AMT_PAID_TODT_2 ,NSLDS_PELL_REMNG_AMT_2 ,NSLDS_PELL_PC_SCHD_AWD_US_2 ,NSLDS_PELL_AWARD_AMT_2 ,NSLDS_PELL_SEQ_NUM_3 ,NSLDS_PELL_VERIFY_F_3 ,NSLDS_PELL_EFC_3 ,NSLDS_PELL_SCHOOL_CODE_3 ,NSLDS_PELL_TRANSCN_NUM_3 ,NSLDS_PELL_LAST_UPDT_DT_3 ,NSLDS_PELL_SCHEDULED_AMT_3 ,NSLDS_PELL_AMT_PAID_TODT_3 ,NSLDS_PELL_REMNG_AMT_3 ,NSLDS_PELL_PC_SCHD_AWD_US_3 ,NSLDS_PELL_AWARD_AMT_3 ,NSLDS_LOAN_SEQ_NUM_1 ,NSLDS_LOAN_TYPE_CODE_1 ,NSLDS_LOAN_CHNG_F_1 ,NSLDS_LOAN_PROG_CODE_1 ,NSLDS_LOAN_NET_AMNT_1 ,NSLDS_LOAN_CUR_ST_CODE_1 ,NSLDS_LOAN_CUR_ST_DATE_1 ,NSLDS_LOAN_AGG_PR_BAL_1 ,NSLDS_LOAN_OUT_PR_BAL_DT_1 ,NSLDS_LOAN_BEGIN_DT_1 ,NSLDS_LOAN_END_DT_1 ,NSLDS_LOAN_GA_CODE_1 ,NSLDS_LOAN_CONT_TYPE_1 ,NSLDS_LOAN_SCHOL_CODE_1 ,NSLDS_LOAN_CONT_CODE_1 ,NSLDS_LOAN_GRADE_LVL_1 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_1 ,NSLDS_LOAN_CAPITAL_INT_F_1 ,NSLDS_LOAN_SEQ_NUM_2 ,NSLDS_LOAN_TYPE_CODE_2 ,NSLDS_LOAN_CHNG_F_2 ,NSLDS_LOAN_PROG_CODE_2 ,NSLDS_LOAN_NET_AMNT_2 ,NSLDS_LOAN_CUR_ST_CODE_2 ,NSLDS_LOAN_CUR_ST_DATE_2 ,NSLDS_LOAN_AGG_PR_BAL_2 ,NSLDS_LOAN_OUT_PR_BAL_DT_2 ,NSLDS_LOAN_BEGIN_DT_2 ,NSLDS_LOAN_END_DT_2 ,NSLDS_LOAN_GA_CODE_2 ,NSLDS_LOAN_CONT_TYPE_2 ,NSLDS_LOAN_SCHOL_CODE_2 ,NSLDS_LOAN_CONT_CODE_2 ,NSLDS_LOAN_GRADE_LVL_2 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_2 ,NSLDS_LOAN_CAPITAL_INT_F_2 ,NSLDS_LOAN_SEQ_NUM_3 ,NSLDS_LOAN_TYPE_CODE_3 ,NSLDS_LOAN_CHNG_F_3 ,NSLDS_LOAN_PROG_CODE_3 ,NSLDS_LOAN_NET_AMNT_3 ,NSLDS_LOAN_CUR_ST_CODE_3 ,NSLDS_LOAN_CUR_ST_DATE_3 ,NSLDS_LOAN_AGG_PR_BAL_3 ,NSLDS_LOAN_OUT_PR_BAL_DT_3 ,NSLDS_LOAN_BEGIN_DT_3 ,NSLDS_LOAN_END_DT_3 ,NSLDS_LOAN_GA_CODE_3 ,NSLDS_LOAN_CONT_TYPE_3 ,NSLDS_LOAN_SCHOL_CODE_3 ,NSLDS_LOAN_CONT_CODE_3 ,NSLDS_LOAN_GRADE_LVL_3 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_3 ,NSLDS_LOAN_CAPITAL_INT_F_3 ,NSLDS_LOAN_SEQ_NUM_4 ,NSLDS_LOAN_TYPE_CODE_4 ,NSLDS_LOAN_CHNG_F_4 ,NSLDS_LOAN_PROG_CODE_4 ,NSLDS_LOAN_NET_AMNT_4 ,NSLDS_LOAN_CUR_ST_CODE_4 ,NSLDS_LOAN_CUR_ST_DATE_4 ,NSLDS_LOAN_AGG_PR_BAL_4 ,NSLDS_LOAN_OUT_PR_BAL_DT_4 ,NSLDS_LOAN_BEGIN_DT_4 ,NSLDS_LOAN_END_DT_4 ,NSLDS_LOAN_GA_CODE_4 ,NSLDS_LOAN_CONT_TYPE_4 ,NSLDS_LOAN_SCHOL_CODE_4 ,NSLDS_LOAN_CONT_CODE_4 ,NSLDS_LOAN_GRADE_LVL_4 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_4 ,NSLDS_LOAN_CAPITAL_INT_F_4 ,NSLDS_LOAN_SEQ_NUM_5 ,NSLDS_LOAN_TYPE_CODE_5 ,NSLDS_LOAN_CHNG_F_5 ,NSLDS_LOAN_PROG_CODE_5 ,NSLDS_LOAN_NET_AMNT_5 ,NSLDS_LOAN_CUR_ST_CODE_5 ,NSLDS_LOAN_CUR_ST_DATE_5 ,NSLDS_LOAN_AGG_PR_BAL_5 ,NSLDS_LOAN_OUT_PR_BAL_DT_5 ,NSLDS_LOAN_BEGIN_DT_5 ,NSLDS_LOAN_END_DT_5 ,NSLDS_LOAN_GA_CODE_5 ,NSLDS_LOAN_CONT_TYPE_5 ,NSLDS_LOAN_SCHOL_CODE_5 ,NSLDS_LOAN_CONT_CODE_5 ,NSLDS_LOAN_GRADE_LVL_5 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_5 ,NSLDS_LOAN_CAPITAL_INT_F_5 ,NSLDS_LOAN_SEQ_NUM_6 ,NSLDS_LOAN_TYPE_CODE_6 ,NSLDS_LOAN_CHNG_F_6 ,NSLDS_LOAN_PROG_CODE_6 ,NSLDS_LOAN_NET_AMNT_6 ,NSLDS_LOAN_CUR_ST_CODE_6 ,NSLDS_LOAN_CUR_ST_DATE_6 ,NSLDS_LOAN_AGG_PR_BAL_6 ,NSLDS_LOAN_OUT_PR_BAL_DT_6 ,NSLDS_LOAN_BEGIN_DT_6 ,NSLDS_LOAN_END_DT_6 ,NSLDS_LOAN_GA_CODE_6 ,NSLDS_LOAN_CONT_TYPE_6 ,NSLDS_LOAN_SCHOL_CODE_6 ,NSLDS_LOAN_CONT_CODE_6 ,NSLDS_LOAN_GRADE_LVL_6 ,NSLDS_LOAN_XTR_UNSBZ_LN_F_6 ,NSLDS_LOAN_CAPITAL_INT_F_6 ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,REQUEST_ID ,PROGRAM_APPLICATION_ID ,PROGRAM_ID ,PROGRAM_UPDATE_DATE ,ORG_ID ,NSLDS_LOAN_LAST_D_AMT_1 ,NSLDS_LOAN_LAST_D_DATE_1 ,NSLDS_LOAN_LAST_D_AMT_2 ,NSLDS_LOAN_LAST_D_DATE_2 ,NSLDS_LOAN_LAST_D_AMT_3 ,NSLDS_LOAN_LAST_D_DATE_3 ,NSLDS_LOAN_LAST_D_AMT_4 ,NSLDS_LOAN_LAST_D_DATE_4 ,NSLDS_LOAN_LAST_D_AMT_5 ,NSLDS_LOAN_LAST_D_DATE_5 ,NSLDS_LOAN_LAST_D_AMT_6 ,NSLDS_LOAN_LAST_D_DATE_6 ,VERIF_TRACK_FLAG ,FAFSA_DATA_VERIFY_FLAGS , REJECT_OVERRIDE_A , REJECT_OVERRIDE_C , PARENT_MARITAL_STATUS_DATE , DLP_MASTER_PROM_NOTE_FLAG, FATHER_FIRST_NAME_INITIAL_TXT, FATHER_STEP_FATHER_BIRTH_DATE, MOTHER_FIRST_NAME_INITIAL_TXT, MOTHER_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 FROM igf_ap_isir_intrface_all WHERE NVL (igf_ap_isir_intrface_all.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 ROWID
, SI_ID
, BATCH_YEAR
, TRANSACTION_NUM
, RECORD_STATUS
, SSN_NAME_CHANGE
, ORIGINAL_SSN
, ORIG_NAME_ID
, CURRENT_SSN
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERM_MAIL_ADD
, PERM_CITY
, PERM_STATE
, PERM_ZIP_CODE
, DATE_OF_BIRTH
, PHONE_NUMBER
, DRIVER_LICENSE_NUMBER
, DRIVER_LICENSE_STATE
, CITIZENSHIP_STATUS
, ALIEN_REG_NUMBER
, S_MARITAL_STATUS
, S_MARITAL_STATUS_DATE
, SUMM_ENRL_STATUS
, FALL_ENRL_STATUS
, WINTER_ENRL_STATUS
, SPRING_ENRL_STATUS
, SUMM2_ENRL_STATUS
, FATHERS_HIGHEST_EDU_LEVEL
, MOTHERS_HIGHEST_EDU_LEVEL
, S_STATE_LEGAL_RESIDENCE
, LEGAL_RESIDENCE_BEFORE_DATE
, S_LEGAL_RESD_DATE
, SS_R_U_MALE
, SELECTIVE_SERVICE_REG
, DEGREE_CERTIFICATION
, GRADE_LEVEL_IN_COLLEGE
, HIGH_SCHOOL_DIPLOMA_GED
, FIRST_BACHELOR_DEG_BY_DATE
, INTEREST_IN_LOAN
, INTEREST_IN_STUD_EMPLOYMENT
, DRUG_OFFENCE_CONVICTION
, S_TAX_RETURN_STATUS
, S_TYPE_TAX_RETURN
, S_ELIG_1040EZ
, S_ADJUSTED_GROSS_INCOME
, S_FED_TAXES_PAID
, S_EXEMPTIONS
, S_INCOME_FROM_WORK
, SPOUSE_INCOME_FROM_WORK
, S_TOA_AMT_FROM_WSA
, S_TOA_AMT_FROM_WSB
, S_TOA_AMT_FROM_WSC
, S_INVESTMENT_NETWORTH
, S_BUSI_FARM_NETWORTH
, S_CASH_SAVINGS
, VA_MONTHS
, VA_AMOUNT
, STUD_DOB_BEFORE_DATE
, DEG_BEYOND_BACHELOR
, S_MARRIED
, S_HAVE_CHILDREN
, LEGAL_DEPENDENTS
, ORPHAN_WARD_OF_COURT
, S_VETERAN
, P_MARITAL_STATUS
, FATHER_SSN
, F_LAST_NAME
, MOTHER_SSN
, M_LAST_NAME
, P_NUM_FAMILY_MEMBER
, P_NUM_IN_COLLEGE
, P_STATE_LEGAL_RESIDENCE
, P_STATE_LEGAL_RES_BEFORE_DT
, P_LEGAL_RES_DATE
, AGE_OLDER_PARENT
, P_TAX_RETURN_STATUS
, P_TYPE_TAX_RETURN
, P_ELIG_1040AEZ
, P_ADJUSTED_GROSS_INCOME
, P_TAXES_PAID
, P_EXEMPTIONS
, F_INCOME_WORK
, M_INCOME_WORK
, P_INCOME_WSA
, P_INCOME_WSB
, P_INCOME_WSC
, P_INVESTMENT_NETWORTH
, P_BUSINESS_NETWORTH
, P_CASH_SAVING
, S_NUM_FAMILY_MEMBERS
, S_NUM_IN_COLLEGE
, FIRST_COLLEGE
, FIRST_HOUSE_PLAN
, SECOND_COLLEGE
, SECOND_HOUSE_PLAN
, THIRD_COLLEGE
, THIRD_HOUSE_PLAN
, FOURTH_COLLEGE
, FOURTH_HOUSE_PLAN
, FIFTH_COLLEGE
, FIFTH_HOUSE_PLAN
, SIXTH_COLLEGE
, SIXTH_HOUSE_PLAN
, DATE_APP_COMPLETED
, SIGNED_BY
, PREPARER_SSN
, PREPARER_EMP_ID_NUMBER
, PREPARER_SIGN
, TRANSACTION_RECEIPT_DATE
, DEPENDENCY_OVERRIDE_IND
, FAA_FEDRAL_SCHL_CODE
, FAA_ADJUSTMENT
, INPUT_RECORD_TYPE
, SERIAL_NUMBER
, BATCH_NUMBER
, EARLY_ANALYSIS_FLAG
, APP_ENTRY_SOURCE_CODE
, ETI_DESTINATION_CODE
, REJECT_OVERRIDE_B
, REJECT_OVERRIDE_N
, REJECT_OVERRIDE_W
, ASSUM_OVERRIDE_1
, ASSUM_OVERRIDE_2
, ASSUM_OVERRIDE_3
, ASSUM_OVERRIDE_4
, ASSUM_OVERRIDE_5
, ASSUM_OVERRIDE_6
, DEPENDENCY_STATUS
, S_EMAIL_ADDRESS
, NSLDS_REASON_CODE
, APP_RECEIPT_DATE
, PROCESSED_REC_TYPE
, HIST_CORRECTION_FOR_TRAN_ID
, SYSTEM_GENERATED_INDICATOR
, DUP_REQUEST_INDICATOR
, SOURCE_OF_CORRECTION
, P_CAL_TAX_STATUS
, S_CAL_TAX_STATUS
, GRADUATE_FLAG
, AUTO_ZERO_EFC
, EFC_CHANGE_FLAG
, SARC_FLAG
, SIMPLIFIED_NEED_TEST
, REJECT_REASON_CODES
, SELECT_SERVICE_MATCH_FLAG
, SELECT_SERVICE_REG_FLAG
, INS_MATCH_FLAG
, NULL
, SEC_INS_MATCH_FLAG
, SEC_INS_VER_NUMBER
, SSN_MATCH_FLAG
, SSA_CITIZENSHIP_FLAG
, SSN_DATE_OF_DEATH
, NSLDS_MATCH_FLAG
, VA_MATCH_FLAG
, PRISONER_MATCH
, VERIFICATION_FLAG
, SUBSEQUENT_APP_FLAG
, APP_SOURCE_SITE_CODE
, TRAN_SOURCE_SITE_CODE
, DRN
, TRAN_PROCESS_DATE
, CORRECTION_FLAGS
, COMPUTER_BATCH_NUMBER
, HIGHLIGHT_FLAGS
, PAID_EFC
, PRIMARY_EFC
, SECONDARY_EFC
, FED_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SEC_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
, SEC_ALTERNATE_MONTH_1
, SEC_ALTERNATE_MONTH_2
, SEC_ALTERNATE_MONTH_3
, SEC_ALTERNATE_MONTH_4
, SEC_ALTERNATE_MONTH_5
, SEC_ALTERNATE_MONTH_6
, SEC_ALTERNATE_MONTH_7
, SEC_ALTERNATE_MONTH_8
, SEC_ALTERNATE_MONTH_10
, SEC_ALTERNATE_MONTH_11
, SEC_ALTERNATE_MONTH_12
, TOTAL_INCOME
, ALLOW_TOTAL_INCOME
, STATE_TAX_ALLOW
, EMPLOYMENT_ALLOW
, INCOME_PROTECTION_ALLOW
, AVAILABLE_INCOME
, CONTRIBUTION_FROM_AI
, DISCRETIONARY_NETWORTH
, EFC_NETWORTH
, ASSET_PROTECT_ALLOW
, PARENTS_CONT_FROM_ASSETS
, ADJUSTED_AVAILABLE_INCOME
, TOTAL_STUDENT_CONTRIBUTION
, TOTAL_PARENT_CONTRIBUTION
, PARENTS_CONTRIBUTION
, STUDENT_TOTAL_INCOME
, SATI
, SIC
, SDNW
, SCA
, FTI
, SECTI
, SECATI
, SECSTX
, SECEA
, SECIPA
, SECAI
, SECCAI
, SECDNW
, SECNW
, SECAPA
, SECPCA
, SECAAI
, SECTSC
, SECTPC
, SECPC
, SECSTI
, SECSATI
, SECSIC
, SECSDNW
, SECSCA
, SECFTI
, A_CITIZENSHIP
, A_STUDENT_MARITAL_STATUS
, A_STUDENT_AGI
, A_S_US_TAX_PAID
, A_S_INCOME_WORK
, A_SPOUSE_INCOME_WORK
, A_S_TOTAL_WSC
, A_DATE_OF_BIRTH
, A_STUDENT_MARRIED
, A_HAVE_CHILDREN
, A_S_HAVE_DEPENDENTS
, A_VA_STATUS
, A_S_NUM_IN_FAMILY
, A_S_NUM_IN_COLLEGE
, A_P_MARITAL_STATUS
, A_FATHER_SSN
, A_MOTHER_SSN
, A_PARENTS_NUM_FAMILY
, A_PARENTS_NUM_COLLEGE
, A_PARENTS_AGI
, A_P_US_TAX_PAID
, A_F_WORK_INCOME
, A_M_WORK_INCOME
, A_P_TOTAL_WSC
, COMMENT_CODES
, SAR_ACK_COMM_CODE
, PELL_GRANT_ELIG_FLAG
, REPROCESS_REASON_CODE
, DUPLICATE_DATE
, ISIR_TRANSACTION_TYPE
, FEDRAL_SCHL_CODE_INDICATOR
, MULTI_SCHOOL_CODE_FLAGS
, DUP_SSN_INDICATOR
, NSLDS_TRANSACTION_NUM
, NSLDS_DATABASE_RESULTS_F
, NSLDS_F
, NSLDS_PELL_OVERPAY_F
, NSLDS_PELL_OVERPAY_CONTACT
, NSLDS_SEOG_OVERPAY_F
, NSLDS_SEOG_OVERPAY_CONTACT
, NSLDS_PERKINS_OVERPAY_F
, NSLDS_PERKINS_OVERPAY_CNTCT
, NSLDS_DEFAULTED_LOAN_F
, NSLDS_DISCHARGED_LOAN_F
, NSLDS_SATIS_REPAY_F
, NSLDS_ACT_BANKRUPTCY_F
, NSLDS_AGG_SUBSZ_OUT_PRIN_BAL
, NSLDS_AGG_UNSBZ_OUT_PRIN_BAL
, NSLDS_AGG_COMB_OUT_PRIN_BAL
, NSLDS_AGG_CONS_OUT_PRIN_BAL
, NSLDS_AGG_SUBSZ_PEND_DISMNT
, NSLDS_AGG_UNSBZ_PEND_DISMNT
, NSLDS_AGG_COMB_PEND_DISMNT
, NSLDS_AGG_SUBSZ_TOTAL
, NSLDS_AGG_UNSBZ_TOTAL
, NSLDS_AGG_COMB_TOTAL
, NSLDS_AGG_CONSD_TOTAL
, NSLDS_PERKINS_OUT_BAL
, NSLDS_PERKINS_CUR_YR_DISMNT
, NSLDS_DEFAULT_LOAN_CHNG_F
, NSLDS_DISCHGED_LOAN_CHNG_F
, NSLDS_SATIS_REPAY_CHNG_F
, NSLDS_ACT_BNKRUPT_CHNG_F
, NSLDS_OVERPAY_CHNG_F
, NSLDS_AGG_LOAN_CHNG_F
, NSLDS_PERKINS_LOAN_CHNG_F
, NSLDS_PELL_PAYMNT_CHNG_F
, NSLDS_ADDTNL_PELL_F
, NSLDS_ADDTNL_LOAN_F
, DIRECT_LOAN_MAS_PROM_NT_F
, NSLDS_PELL_SEQ_NUM_1
, NSLDS_PELL_VERIFY_F_1
, NSLDS_PELL_EFC_1
, NSLDS_PELL_SCHOOL_CODE_1
, NSLDS_PELL_TRANSCN_NUM_1
, NSLDS_PELL_LAST_UPDT_DT_1
, NSLDS_PELL_SCHEDULED_AMT_1
, NSLDS_PELL_AMT_PAID_TODT_1
, NSLDS_PELL_REMNG_AMT_1
, NSLDS_PELL_PC_SCHD_AWD_US_1
, NSLDS_PELL_AWARD_AMT_1
, NSLDS_PELL_SEQ_NUM_2
, NSLDS_PELL_VERIFY_F_2
, NSLDS_PELL_EFC_2
, NSLDS_PELL_SCHOOL_CODE_2
, NSLDS_PELL_TRANSCN_NUM_2
, NSLDS_PELL_LAST_UPDT_DT_2
, NSLDS_PELL_SCHEDULED_AMT_2
, NSLDS_PELL_AMT_PAID_TODT_2
, NSLDS_PELL_REMNG_AMT_2
, NSLDS_PELL_PC_SCHD_AWD_US_2
, NSLDS_PELL_AWARD_AMT_2
, NSLDS_PELL_SEQ_NUM_3
, NSLDS_PELL_VERIFY_F_3
, NSLDS_PELL_EFC_3
, NSLDS_PELL_SCHOOL_CODE_3
, NSLDS_PELL_TRANSCN_NUM_3
, NSLDS_PELL_LAST_UPDT_DT_3
, NSLDS_PELL_SCHEDULED_AMT_3
, NSLDS_PELL_AMT_PAID_TODT_3
, NSLDS_PELL_REMNG_AMT_3
, NSLDS_PELL_PC_SCHD_AWD_US_3
, NSLDS_PELL_AWARD_AMT_3
, NSLDS_LOAN_SEQ_NUM_1
, NSLDS_LOAN_TYPE_CODE_1
, NSLDS_LOAN_CHNG_F_1
, NSLDS_LOAN_PROG_CODE_1
, NSLDS_LOAN_NET_AMNT_1
, NSLDS_LOAN_CUR_ST_CODE_1
, NSLDS_LOAN_CUR_ST_DATE_1
, NSLDS_LOAN_AGG_PR_BAL_1
, NSLDS_LOAN_OUT_PR_BAL_DT_1
, NSLDS_LOAN_BEGIN_DT_1
, NSLDS_LOAN_END_DT_1
, NSLDS_LOAN_GA_CODE_1
, NSLDS_LOAN_CONT_TYPE_1
, NSLDS_LOAN_SCHOL_CODE_1
, NSLDS_LOAN_CONT_CODE_1
, NSLDS_LOAN_GRADE_LVL_1
, NSLDS_LOAN_XTR_UNSBZ_LN_F_1
, NSLDS_LOAN_CAPITAL_INT_F_1
, NSLDS_LOAN_SEQ_NUM_2
, NSLDS_LOAN_TYPE_CODE_2
, NSLDS_LOAN_CHNG_F_2
, NSLDS_LOAN_PROG_CODE_2
, NSLDS_LOAN_NET_AMNT_2
, NSLDS_LOAN_CUR_ST_CODE_2
, NSLDS_LOAN_CUR_ST_DATE_2
, NSLDS_LOAN_AGG_PR_BAL_2
, NSLDS_LOAN_OUT_PR_BAL_DT_2
, NSLDS_LOAN_BEGIN_DT_2
, NSLDS_LOAN_END_DT_2
, NSLDS_LOAN_GA_CODE_2
, NSLDS_LOAN_CONT_TYPE_2
, NSLDS_LOAN_SCHOL_CODE_2
, NSLDS_LOAN_CONT_CODE_2
, NSLDS_LOAN_GRADE_LVL_2
, NSLDS_LOAN_XTR_UNSBZ_LN_F_2
, NSLDS_LOAN_CAPITAL_INT_F_2
, NSLDS_LOAN_SEQ_NUM_3
, NSLDS_LOAN_TYPE_CODE_3
, NSLDS_LOAN_CHNG_F_3
, NSLDS_LOAN_PROG_CODE_3
, NSLDS_LOAN_NET_AMNT_3
, NSLDS_LOAN_CUR_ST_CODE_3
, NSLDS_LOAN_CUR_ST_DATE_3
, NSLDS_LOAN_AGG_PR_BAL_3
, NSLDS_LOAN_OUT_PR_BAL_DT_3
, NSLDS_LOAN_BEGIN_DT_3
, NSLDS_LOAN_END_DT_3
, NSLDS_LOAN_GA_CODE_3
, NSLDS_LOAN_CONT_TYPE_3
, NSLDS_LOAN_SCHOL_CODE_3
, NSLDS_LOAN_CONT_CODE_3
, NSLDS_LOAN_GRADE_LVL_3
, NSLDS_LOAN_XTR_UNSBZ_LN_F_3
, NSLDS_LOAN_CAPITAL_INT_F_3
, NSLDS_LOAN_SEQ_NUM_4
, NSLDS_LOAN_TYPE_CODE_4
, NSLDS_LOAN_CHNG_F_4
, NSLDS_LOAN_PROG_CODE_4
, NSLDS_LOAN_NET_AMNT_4
, NSLDS_LOAN_CUR_ST_CODE_4
, NSLDS_LOAN_CUR_ST_DATE_4
, NSLDS_LOAN_AGG_PR_BAL_4
, NSLDS_LOAN_OUT_PR_BAL_DT_4
, NSLDS_LOAN_BEGIN_DT_4
, NSLDS_LOAN_END_DT_4
, NSLDS_LOAN_GA_CODE_4
, NSLDS_LOAN_CONT_TYPE_4
, NSLDS_LOAN_SCHOL_CODE_4
, NSLDS_LOAN_CONT_CODE_4
, NSLDS_LOAN_GRADE_LVL_4
, NSLDS_LOAN_XTR_UNSBZ_LN_F_4
, NSLDS_LOAN_CAPITAL_INT_F_4
, NSLDS_LOAN_SEQ_NUM_5
, NSLDS_LOAN_TYPE_CODE_5
, NSLDS_LOAN_CHNG_F_5
, NSLDS_LOAN_PROG_CODE_5
, NSLDS_LOAN_NET_AMNT_5
, NSLDS_LOAN_CUR_ST_CODE_5
, NSLDS_LOAN_CUR_ST_DATE_5
, NSLDS_LOAN_AGG_PR_BAL_5
, NSLDS_LOAN_OUT_PR_BAL_DT_5
, NSLDS_LOAN_BEGIN_DT_5
, NSLDS_LOAN_END_DT_5
, NSLDS_LOAN_GA_CODE_5
, NSLDS_LOAN_CONT_TYPE_5
, NSLDS_LOAN_SCHOL_CODE_5
, NSLDS_LOAN_CONT_CODE_5
, NSLDS_LOAN_GRADE_LVL_5
, NSLDS_LOAN_XTR_UNSBZ_LN_F_5
, NSLDS_LOAN_CAPITAL_INT_F_5
, NSLDS_LOAN_SEQ_NUM_6
, NSLDS_LOAN_TYPE_CODE_6
, NSLDS_LOAN_CHNG_F_6
, NSLDS_LOAN_PROG_CODE_6
, NSLDS_LOAN_NET_AMNT_6
, NSLDS_LOAN_CUR_ST_CODE_6
, NSLDS_LOAN_CUR_ST_DATE_6
, NSLDS_LOAN_AGG_PR_BAL_6
, NSLDS_LOAN_OUT_PR_BAL_DT_6
, NSLDS_LOAN_BEGIN_DT_6
, NSLDS_LOAN_END_DT_6
, NSLDS_LOAN_GA_CODE_6
, NSLDS_LOAN_CONT_TYPE_6
, NSLDS_LOAN_SCHOL_CODE_6
, NSLDS_LOAN_CONT_CODE_6
, NSLDS_LOAN_GRADE_LVL_6
, NSLDS_LOAN_XTR_UNSBZ_LN_F_6
, NSLDS_LOAN_CAPITAL_INT_F_6
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, NSLDS_LOAN_LAST_D_AMT_1
, NSLDS_LOAN_LAST_D_DATE_1
, NSLDS_LOAN_LAST_D_AMT_2
, NSLDS_LOAN_LAST_D_DATE_2
, NSLDS_LOAN_LAST_D_AMT_3
, NSLDS_LOAN_LAST_D_DATE_3
, NSLDS_LOAN_LAST_D_AMT_4
, NSLDS_LOAN_LAST_D_DATE_4
, NSLDS_LOAN_LAST_D_AMT_5
, NSLDS_LOAN_LAST_D_DATE_5
, NSLDS_LOAN_LAST_D_AMT_6
, NSLDS_LOAN_LAST_D_DATE_6
, VERIF_TRACK_FLAG
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_A
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, DLP_MASTER_PROM_NOTE_FLAG
, FATHER_FIRST_NAME_INITIAL_TXT
, FATHER_STEP_FATHER_BIRTH_DATE
, MOTHER_FIRST_NAME_INITIAL_TXT
, MOTHER_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
FROM IGF_AP_ISIR_INTRFACE_ALL
WHERE NVL (IGF_AP_ISIR_INTRFACE_ALL.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)