Product: | IGF - Financial Aid |
---|---|
Description: | Base View for the Entity that holds the complete ISIR record of the students |
Implementation/DBA Data: | APPS.IGFBV_ISIRS |
SELECT ISIRM.BATCH_YEAR
, ISIRM.TRANSACTION_NUM
, ISIRM.CURRENT_SSN
, '_LA:ISIRM.SSN_NAME_CHANGE:IGF_LOOKUPS_VIEW:IGF_SSNCHANGE_TYPE:MEANING'
, ISIRM.ORIGINAL_SSN
, ISIRM.ORIG_NAME_ID
, ISIRM.LAST_NAME
, ISIRM.FIRST_NAME
, ISIRM.MIDDLE_INITIAL
, ISIRM.PERM_MAIL_ADD
, ISIRM.PERM_CITY
, '_LA:ISIRM.PERM_STATE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, ISIRM.PERM_ZIP_CODE
, ISIRM.DATE_OF_BIRTH
, ISIRM.PHONE_NUMBER
, ISIRM.DRIVER_LICENSE_NUMBER
, '_LA:ISIRM.DRIVER_LICENSE_STATE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, '_LA:ISIRM.CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_CITIZENSHIP_TYPE:MEANING'
, ISIRM.ALIEN_REG_NUMBER
, '_LA:ISIRM.S_MARITAL_STATUS:IGF_LOOKUPS_VIEW:IGF_ST_MARITAL_STAT_TYPE:MEANING'
, ISIRM.S_MARITAL_STATUS_DATE
, '_LA:ISIRM.SUMM_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.FALL_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.WINTER_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.SPRING_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.SUMM2_ENRL_STATUS:IGF_LOOKUPS_VIEW:IGF_ENROLMENT_TYPE:MEANING'
, '_LA:ISIRM.FATHERS_HIGHEST_EDU_LEVEL:IGF_LOOKUPS_VIEW:IGF_HIGH_GRAD_LVL_TYPE:MEANING'
, '_LA:ISIRM.MOTHERS_HIGHEST_EDU_LEVEL:IGF_LOOKUPS_VIEW:IGF_HIGH_GRAD_LVL_TYPE:MEANING'
, '_LA:ISIRM.S_STATE_LEGAL_RESIDENCE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, '_LA:ISIRM.LEGAL_RESIDENCE_BEFORE_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, ISIRM.S_LEGAL_RESD_DATE
, '_LA:ISIRM.SS_R_U_MALE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.SELECTIVE_SERVICE_REG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DEGREE_CERTIFICATION:IGF_LOOKUPS_VIEW:IGF_DEG_CERT_TYPE:MEANING'
, '_LA:ISIRM.GRADE_LEVEL_IN_COLLEGE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING'
, '_LA:ISIRM.HIGH_SCHOOL_DIPLOMA_GED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.FIRST_BACHELOR_DEG_BY_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.INTEREST_IN_LOAN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.INTEREST_IN_STUD_EMPLOYMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DRUG_OFFENCE_CONVICTION:IGF_LOOKUPS_VIEW:IGF_DRUG_ELIGIBILITY_TYPE:MEANING'
, '_LA:ISIRM.S_TAX_RETURN_STATUS:IGF_LOOKUPS_VIEW:IGF_TAX_RET_STAT_TYPE:MEANING'
, '_LA:ISIRM.S_TYPE_TAX_RETURN:IGF_LOOKUPS_VIEW:IGF_TAX_FORM_TYPE:MEANING'
, '_LA:ISIRM.S_ELIG_1040EZ:IGF_LOOKUPS_VIEW:IGF_TAX_EXEMPTION_ELIG_TYPE:MEANING'
, 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
, '_LA:ISIRM.STUD_DOB_BEFORE_DATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.DEG_BEYOND_BACHELOR:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_MARRIED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_HAVE_CHILDREN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.LEGAL_DEPENDENTS:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.ORPHAN_WARD_OF_COURT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.S_VETERAN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:ISIRM.P_MARITAL_STATUS:IGF_LOOKUPS_VIEW:IGF_P_MARITAL_STAT_TYPE:MEANING'
, ISIRM.FATHER_SSN
, ISIRM.F_LAST_NAME
, ISIRM.MOTHER_SSN
, ISIRM.M_LAST_NAME
, ISIRM.P_NUM_FAMILY_MEMBER
, ISIRM.P_NUM_IN_COLLEGE
, '_LA:ISIRM.P_STATE_LEGAL_RESIDENCE:IGF_LOOKUPS_VIEW:IGF_AP_STATE_CODES:MEANING'
, ISIRM.P_STATE_LEGAL_RES_BEFORE_DT
, ISIRM.P_LEGAL_RES_DATE
, ISIRM.AGE_OLDER_PARENT
, '_LA:ISIRM.P_TAX_RETURN_STATUS:IGF_LOOKUPS_VIEW:IGF_TAX_RET_STAT_TYPE:MEANING'
, '_LA:ISIRM.P_TYPE_TAX_RETURN:IGF_LOOKUPS_VIEW:IGF_TAX_FORM_TYPE:MEANING'
, '_LA:ISIRM.P_ELIG_1040AEZ:IGF_LOOKUPS_VIEW:IGF_TAX_EXEMPTION_ELIG_TYPE:MEANING'
, 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
, '_LA:ISIRM.FIRST_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.SECOND_COLLEGE
, '_LA:ISIRM.SECOND_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.THIRD_COLLEGE
, '_LA:ISIRM.THIRD_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.FOURTH_COLLEGE
, '_LA:ISIRM.FOURTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.FIFTH_COLLEGE
, '_LA:ISIRM.FIFTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.SIXTH_COLLEGE
, '_LA:ISIRM.SIXTH_HOUSE_PLAN:IGF_LOOKUPS_VIEW:IGF_AP_HOUSING_STAT:MEANING'
, ISIRM.DATE_APP_COMPLETED
, '_LA:ISIRM.SIGNED_BY:IGF_LOOKUPS_VIEW:IGF_SIGN_TYPE:MEANING'
, ISIRM.PREPARER_SSN
, ISIRM.PREPARER_EMP_ID_NUMBER
, ISIRM.PREPARER_SIGN
, ISIRM.TRANSACTION_RECEIPT_DATE
, '_LA:ISIRM.DEPENDENCY_OVERRIDE_IND:IGF_LOOKUPS_VIEW:IGF_DPND_ORIDE_TYPE:MEANING'
, ISIRM.FAA_FEDRAL_SCHL_CODE
, '_LA:ISIRM.FAA_ADJUSTMENT:IGF_LOOKUPS_VIEW:IGF_FAA_EFC_TYPE:MEANING'
, '_LA:ISIRM.INPUT_RECORD_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_INPUT_RECORD_TYPE:MEANING'
, ISIRM.SERIAL_NUMBER
, ISIRM.BATCH_NUMBER
, '_LA:ISIRM.EARLY_ANALYSIS_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_EARLY_ANALYSIS_FLAG:MEANING'
, 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
, '_LA:ISIRM.DEPENDENCY_STATUS:IGF_LOOKUPS_VIEW:IGF_AP_DEP_STATUS:MEANING'
, 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
, ISIRM.INS_VERIFICATION_NUMBER
, 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
, '_LA:ISIRM.ISIR_TRANSACTION_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_TRANSACTION_TYPE:MEANING'
, 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.VERIF_TRACK_FLAG
, ISIRM.ACTIVE_ISIR
, ISIRM.REJECT_OVERRIDE_A
, ISIRM.FAFSA_DATA_VERIFY_FLAGS
, ISIRM.REJECT_OVERRIDE_C
, ISIRM.PARENT_MARITAL_STATUS_DATE
, '_LA:LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, 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.DATA_FILE_NAME_TXT
, ISIRM.MESSAGE_CLASS_TXT
, '_LA:ISIRM.REJECT_OVERRIDE_G_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_3_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_12_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_J_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, '_LA:ISIRM.REJECT_OVERRIDE_K_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_REJECT_OVERRIDE_FLAG:MEANING'
, ISIRM.REJECTED_STATUS_CHANGE_FLAG
, ISIRM.VERIFICATION_SELECTION_FLAG
, ISIRM.BASE_ID
, ISIRM.ISIR_ID
, ISIRM.CREATED_BY
, ISIRM.CREATION_DATE
, ISIRM.LAST_UPDATED_BY
, ISIRM.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_AP_ISIR_MATCHED_ALL ISIRM
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE FABASE.BASE_ID = ISIRM.BASE_ID WITH READ ONLY