VIEW: APPS.IGF_AP_ISIR_SAR_V

Source

View Text - Preformatted

SELECT ISIR_ID, BASE_ID, original_ssn, orig_name_id,transaction_num, Paid_EFC, TRAN_SOURCE_SITE_CODE, LAST_NAME , FIRST_NAME , MIDDLE_INITIAL , PERM_MAIL_ADD , PERM_CITY , PERM_STATE , PERM_ZIP_CODE , CURRENT_SSN, DATE_OF_BIRTH , PHONE_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 , DEGREE_CERTIFICATION , GRADE_LEVEL_IN_COLLEGE , HIGH_SCHOOL_DIPLOMA_GED , FIRST_BACHELOR_DEG_BY_DATE , 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, 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, 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 , FAA_FEDRAL_SCHL_CODE , FAA_ADJUSTMENT , SSN_NAME_CHANGE , EARLY_ANALYSIS_FLAG, SERIAL_NUMBER, dependency_status, verification_flag, driver_license_number, selective_service_reg, interest_in_loan, p_state_legal_res_before_dt, p_legal_res_date, dependency_override_ind, legal_dependents, SYSTEM_RECORD_TYPE,ORIGINAL_SSN||ORIG_NAME_ID||TRANSACTION_NUM, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, VERIF_TRACK_FLAG from igf_ap_isir_matched WHERE SYSTEM_RECORD_TYPE='ORIGINAL'

View Text - HTML Formatted

SELECT ISIR_ID
, BASE_ID
, ORIGINAL_SSN
, ORIG_NAME_ID
, TRANSACTION_NUM
, PAID_EFC
, TRAN_SOURCE_SITE_CODE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERM_MAIL_ADD
, PERM_CITY
, PERM_STATE
, PERM_ZIP_CODE
, CURRENT_SSN
, DATE_OF_BIRTH
, PHONE_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
, DEGREE_CERTIFICATION
, GRADE_LEVEL_IN_COLLEGE
, HIGH_SCHOOL_DIPLOMA_GED
, FIRST_BACHELOR_DEG_BY_DATE
, 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
, 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
, 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
, FAA_FEDRAL_SCHL_CODE
, FAA_ADJUSTMENT
, SSN_NAME_CHANGE
, EARLY_ANALYSIS_FLAG
, SERIAL_NUMBER
, DEPENDENCY_STATUS
, VERIFICATION_FLAG
, DRIVER_LICENSE_NUMBER
, SELECTIVE_SERVICE_REG
, INTEREST_IN_LOAN
, P_STATE_LEGAL_RES_BEFORE_DT
, P_LEGAL_RES_DATE
, DEPENDENCY_OVERRIDE_IND
, LEGAL_DEPENDENTS
, SYSTEM_RECORD_TYPE
, ORIGINAL_SSN||ORIG_NAME_ID||TRANSACTION_NUM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, VERIF_TRACK_FLAG
FROM IGF_AP_ISIR_MATCHED
WHERE SYSTEM_RECORD_TYPE='ORIGINAL'