Product: | IGF - Financial Aid |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.IGF_AP_ISIR_SAR_V |
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'