View: IGF_AP_ISIR_MATCHED

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AP_ISIR_MATCHED

View Text

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)

Columns