VIEW: APPS.IGF_AP_ISIR_MATCHED_V

Source

View Text - Preformatted

SELECT ROW_ID , ISIR_ID , BASE_ID , BATCH_YEAR , SSN_NAME_CHANGE , ORIGINAL_SSN , ORIG_NAME_ID , TRANSACTION_NUM , 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 , COMPUTER_BATCH_NUMBER , CORRECTION_FLAGS , 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 , SECSIC , SECSDNW , SECSCA , SECFTI , SECSATI, 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 , PAYMENT_ISIR , RECEIPT_STATUS , ISIR_RECEIPT_COMPLETED , legacy_record_flag, CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , VERIF_TRACK_FLAG , ACTIVE_ISIR, FAFSA_DATA_VERIFY_FLAGS, REJECT_OVERRIDE_A, REJECT_OVERRIDE_C, PARENT_MARITAL_STATUS_DATE ,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 ,REJECT_OVERRIDE_G_FLAG ,DHS_VERIFICATION_NUM_TXT , DATA_FILE_NAME_TXT , MESSAGE_CLASS_TXT ,REJECT_OVERRIDE_3_FLAG ,REJECT_OVERRIDE_12_FLAG ,REJECT_OVERRIDE_J_FLAG ,REJECT_OVERRIDE_K_FLAG ,REJECTED_STATUS_CHANGE_FLAG ,VERIFICATION_SELECTION_FLAG FROM IGF_AP_ISIR_MATCHED

View Text - HTML Formatted

SELECT ROW_ID
, ISIR_ID
, BASE_ID
, BATCH_YEAR
, SSN_NAME_CHANGE
, ORIGINAL_SSN
, ORIG_NAME_ID
, TRANSACTION_NUM
, 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
, COMPUTER_BATCH_NUMBER
, CORRECTION_FLAGS
, 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
, SECSIC
, SECSDNW
, SECSCA
, SECFTI
, SECSATI
, 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
, PAYMENT_ISIR
, RECEIPT_STATUS
, ISIR_RECEIPT_COMPLETED
, LEGACY_RECORD_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, VERIF_TRACK_FLAG
, ACTIVE_ISIR
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_A
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, 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
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
, DATA_FILE_NAME_TXT
, MESSAGE_CLASS_TXT
, REJECT_OVERRIDE_3_FLAG
, REJECT_OVERRIDE_12_FLAG
, REJECT_OVERRIDE_J_FLAG
, REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
FROM IGF_AP_ISIR_MATCHED