VIEW: APPS.IGF_AP_CSS_INTERFACE

Source

View Text - Preformatted

SELECT rowid row_id, CSS_ID, ORG_ID, RECORD_STATUS, COLLEGE_CODE, ACADEMIC_YEAR, STU_RECORD_TYPE, CSS_ID_NUMBER, REGISTRATION_RECEIPT_DATE, REGISTRATION_TYPE, APPLICATION_RECEIPT_DATE, APPLICATION_TYPE, ORIGINAL_FNAR_COMPUTE, REVISION_FNAR_COMPUTE_DATE, ELECTRONIC_EXTRACT_DATE, INSTITUTIONAL_REPORTING_TYPE, ASR_RECEIPT_DATE, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, ADDRESS_NUMBER_AND_STREET, CITY, STATE_MAILING, ZIP_CODE, S_TELEPHONE_NUMBER, S_TITLE, DATE_OF_BIRTH, SOCIAL_SECURITY_NUMBER, STATE_LEGAL_RESIDENCE, FOREIGN_ADDRESS_INDICATOR, FOREIGN_POSTAL_CODE, COUNTRY, FINANCIAL_AID_STATUS, YEAR_IN_COLLEGE, MARITAL_STATUS, WARD_COURT, LEGAL_DEPENDENTS_OTHER, HOUSEHOLD_SIZE, NUMBER_IN_COLLEGE, CITIZENSHIP_STATUS, CITIZENSHIP_COUNTRY, VISA_CLASSIFICATION, TAX_FIGURES, NUMBER_EXEMPTIONS, ADJUSTED_GROSS_INC, US_TAX_PAID, ITEMIZED_DEDUCTIONS, STU_INCOME_WORK, SPOUSE_INCOME_WORK, DIVID_INT_INC, SOC_SEC_BENEFITS, WELFARE_TANF, CHILD_SUPP_RCVD, EARNED_INCOME_CREDIT, OTHER_UNTAX_INCOME, TAX_STU_AID, CASH_SAV_CHECK, IRA_KEOGH, INVEST_VALUE, INVEST_DEBT, HOME_VALUE, HOME_DEBT, OTH_REAL_VALUE, OTH_REAL_DEBT, BUS_FARM_VALUE, BUS_FARM_DEBT, LIVE_ON_FARM, HOME_PURCH_PRICE, HOPE_LL_CREDIT, HOME_PURCH_YEAR, TRUST_AMOUNT, TRUST_AVAIL, TRUST_ESTAB, CHILD_SUPPORT_PAID, MED_DENT_EXPENSES, VET_US, VET_BEN_AMOUNT, VET_BEN_MONTHS, STU_SUMMER_WAGES, STU_SCHOOL_YR_WAGES, SPOUSE_SUMMER_WAGES, SPOUSE_SCHOOL_YR_WAGES, SUMMER_OTHER_TAX_INC, SCHOOL_YR_OTHER_TAX_INC, SUMMER_UNTAX_INC, SCHOOL_YR_UNTAX_INC, GRANTS_SCHOL_ETC, TUIT_BENEFITS, CONT_PARENTS, CONT_RELATIVES, P_SIBLINGS_PRE_TUIT, P_STUDENT_PRE_TUIT, P_HOUSEHOLD_SIZE, P_NUMBER_IN_COLLEGE, P_PARENTS_IN_COLLEGE, P_MARITAL_STATUS, P_STATE_LEGAL_RESIDENCE, P_NATURAL_PAR_STATUS, P_CHILD_SUPP_PAID, P_REPAY_ED_LOANS, P_MED_DENT_EXPENSES, P_TUIT_PAID_AMOUNT, P_TUIT_PAID_NUMBER, P_EXP_CHILD_SUPP_PAID, P_EXP_REPAY_ED_LOANS, P_EXP_MED_DENT_EXPENSES, P_EXP_TUIT_PD_AMOUNT, P_EXP_TUIT_PD_NUMBER, P_CASH_SAV_CHECK, P_MONTH_MORTGAGE_PAY, P_INVEST_VALUE, P_INVEST_DEBT, P_HOME_VALUE, P_HOME_DEBT, P_HOME_PURCH_PRICE, P_OWN_BUSINESS_FARM, P_BUSINESS_VALUE, P_BUSINESS_DEBT, P_FARM_VALUE, P_FARM_DEBT, P_LIVE_ON_FARM, P_OTH_REAL_ESTATE_VALUE, P_OTH_REAL_ESTATE_DEBT, P_OTH_REAL_PURCH_PRICE, P_SIBLINGS_ASSETS, P_HOME_PURCH_YEAR, P_OTH_REAL_PURCH_YEAR, P_PRIOR_AGI, P_PRIOR_US_TAX_PAID, P_PRIOR_ITEM_DEDUCTIONS, P_PRIOR_OTHER_UNTAX_INC, P_TAX_FIGURES, P_NUMBER_EXEMPTIONS, P_ADJUSTED_GROSS_INC, P_WAGES_SAL_TIPS, P_INTEREST_INCOME, P_DIVIDEND_INCOME, P_NET_INC_BUS_FARM, P_OTHER_TAXABLE_INCOME, P_ADJ_TO_INCOME, P_US_TAX_PAID, P_ITEMIZED_DEDUCTIONS, P_FATHER_INCOME_WORK, P_MOTHER_INCOME_WORK, P_SOC_SEC_BEN, P_WELFARE_TANF, P_CHILD_SUPP_RCVD, P_DED_IRA_KEOGH, P_TAX_DEFER_PENS_SAVS, P_DEP_CARE_MED_SPENDING, P_EARNED_INCOME_CREDIT, P_LIVING_ALLOW, P_TAX_EXMPT_INT, P_FOREIGN_INC_EXCL, P_OTHER_UNTAX_INC, P_HOPE_LL_CREDIT, P_YR_SEPARATION, P_YR_DIVORCE, P_EXP_FATHER_INC, P_EXP_MOTHER_INC, P_EXP_OTHER_TAX_INC, P_EXP_OTHER_UNTAX_INC, LINE_2_RELATION, LINE_2_ATTEND_COLLEGE, LINE_3_RELATION, LINE_3_ATTEND_COLLEGE, LINE_4_RELATION, LINE_4_ATTEND_COLLEGE, LINE_5_RELATION, LINE_5_ATTEND_COLLEGE, LINE_6_RELATION, LINE_6_ATTEND_COLLEGE, LINE_7_RELATION, LINE_7_ATTEND_COLLEGE, LINE_8_RELATION, LINE_8_ATTEND_COLLEGE, P_AGE_FATHER, P_AGE_MOTHER, P_DIV_SEP_IND, B_CONT_NON_CUSTODIAL_PAR, COLLEGE_TYPE_2, COLLEGE_TYPE_3, COLLEGE_TYPE_4, COLLEGE_TYPE_5, COLLEGE_TYPE_6, COLLEGE_TYPE_7, COLLEGE_TYPE_8, SCHOOL_CODE_1, HOUSING_CODE_1, SCHOOL_CODE_2, HOUSING_CODE_2, SCHOOL_CODE_3, HOUSING_CODE_3, SCHOOL_CODE_4, HOUSING_CODE_4, SCHOOL_CODE_5, HOUSING_CODE_5, SCHOOL_CODE_6, HOUSING_CODE_6, SCHOOL_CODE_7, HOUSING_CODE_7, SCHOOL_CODE_8, HOUSING_CODE_8, SCHOOL_CODE_9, HOUSING_CODE_9, SCHOOL_CODE_10, HOUSING_CODE_10, ADDITIONAL_SCHOOL_CODE_1, ADDITIONAL_SCHOOL_CODE_2, ADDITIONAL_SCHOOL_CODE_3, ADDITIONAL_SCHOOL_CODE_4, ADDITIONAL_SCHOOL_CODE_5, ADDITIONAL_SCHOOL_CODE_6, ADDITIONAL_SCHOOL_CODE_7, ADDITIONAL_SCHOOL_CODE_8, ADDITIONAL_SCHOOL_CODE_9, ADDITIONAL_SCHOOL_CODE_10, EXPLANATION_SPEC_CIRCUM, SIGNATURE_STUDENT, SIGNATURE_SPOUSE, SIGNATURE_FATHER, SIGNATURE_MOTHER, MONTH_DAY_COMPLETED, YEAR_COMPLETED, AGE_LINE_2, AGE_LINE_3, AGE_LINE_4, AGE_LINE_5, AGE_LINE_6, AGE_LINE_7, AGE_LINE_8, A_ONLINE_SIGNATURE, QUESTION_1_NUMBER, QUESTION_1_SIZE, QUESTION_1_ANSWER, QUESTION_2_NUMBER, QUESTION_2_SIZE, QUESTION_2_ANSWER, QUESTION_3_NUMBER, QUESTION_3_SIZE, QUESTION_3_ANSWER, QUESTION_4_NUMBER, QUESTION_4_SIZE, QUESTION_4_ANSWER, QUESTION_5_NUMBER, QUESTION_5_SIZE, QUESTION_5_ANSWER, QUESTION_6_NUMBER, QUESTION_6_SIZE, QUESTION_6_ANSWER, QUESTION_7_NUMBER, QUESTION_7_SIZE, QUESTION_7_ANSWER, QUESTION_8_NUMBER, QUESTION_8_SIZE, QUESTION_8_ANSWER, QUESTION_9_NUMBER, QUESTION_9_SIZE, QUESTION_9_ANSWER, QUESTION_10_NUMBER, QUESTION_10_SIZE, QUESTION_10_ANSWER, QUESTION_11_NUMBER, QUESTION_11_SIZE, QUESTION_11_ANSWER, QUESTION_12_NUMBER, QUESTION_12_SIZE, QUESTION_12_ANSWER, QUESTION_13_NUMBER, QUESTION_13_SIZE, QUESTION_13_ANSWER, QUESTION_14_NUMBER, QUESTION_14_SIZE, QUESTION_14_ANSWER, QUESTION_15_NUMBER, QUESTION_15_SIZE, QUESTION_15_ANSWER, QUESTION_16_NUMBER, QUESTION_16_SIZE, QUESTION_16_ANSWER, QUESTION_17_NUMBER, QUESTION_17_SIZE, QUESTION_17_ANSWER, QUESTION_18_NUMBER, QUESTION_18_SIZE, QUESTION_18_ANSWER, QUESTION_19_NUMBER, QUESTION_19_SIZE, QUESTION_19_ANSWER, QUESTION_20_NUMBER, QUESTION_20_SIZE, QUESTION_20_ANSWER, QUESTION_21_NUMBER, QUESTION_21_SIZE, QUESTION_21_ANSWER, QUESTION_22_NUMBER, QUESTION_22_SIZE, QUESTION_22_ANSWER, QUESTION_23_NUMBER, QUESTION_23_SIZE, QUESTION_23_ANSWER, QUESTION_24_NUMBER, QUESTION_24_SIZE, QUESTION_24_ANSWER, QUESTION_25_NUMBER, QUESTION_25_SIZE, QUESTION_25_ANSWER, QUESTION_26_NUMBER, QUESTION_26_SIZE, QUESTION_26_ANSWER, QUESTION_27_NUMBER, QUESTION_27_SIZE, QUESTION_27_ANSWER, QUESTION_28_NUMBER, QUESTION_28_SIZE, QUESTION_28_ANSWER, QUESTION_29_NUMBER, QUESTION_29_SIZE, QUESTION_29_ANSWER, QUESTION_30_NUMBER, QUESTIONS_30_SIZE, QUESTION_30_ANSWER, R_S_EMAIL_ADDRESS, EPS_CODE, COMP_CSS_DEPENDENCY_STATUS, STU_AGE, ASSUMED_STU_YR_IN_COLL, COMP_STU_MARITAL_STATUS, STU_FAMILY_MEMBERS, STU_FAM_MEMBERS_IN_COLLEGE, PAR_MARITAL_STATUS, PAR_FAMILY_MEMBERS, PAR_TOTAL_IN_COLLEGE, PAR_PAR_IN_COLLEGE, PAR_OTHERS_IN_COLLEGE, PAR_AESA, PAR_CESA, STU_AESA, STU_CESA, IM_P_BAS_AGI_TAXABLE_INCOME, IM_P_BAS_UNTX_INC_AND_BEN, IM_P_BAS_INC_ADJ, IM_P_BAS_TOTAL_INCOME, IM_P_BAS_US_INCOME_TAX, IM_P_BAS_ST_AND_OTHER_TAX, IM_P_BAS_FICA_TAX, IM_P_BAS_MED_DENTAL, IM_P_BAS_EMPLOYMENT_ALLOW, IM_P_BAS_ANNUAL_ED_SAVINGS, IM_P_BAS_INC_PROT_ALLOW_M, IM_P_BAS_TOTAL_INC_ALLOW, IM_P_BAS_CAL_AVAIL_INC, IM_P_BAS_AVAIL_INCOME, IM_P_BAS_TOTAL_CONT_INC, IM_P_BAS_CASH_BANK_ACCOUNTS, IM_P_BAS_HOME_EQUITY, IM_P_BAS_OT_RL_EST_INV_EQ, IM_P_BAS_ADJ_BUS_FARM_WORTH, IM_P_BAS_ASS_SIBS_PRE_TUI, IM_P_BAS_NET_WORTH, IM_P_BAS_EMERG_RES_ALLOW, IM_P_BAS_CUM_ED_SAVINGS, IM_P_BAS_LOW_INC_ALLOW, IM_P_BAS_TOTAL_ASSET_ALLOW, IM_P_BAS_DISC_NET_WORTH, IM_P_BAS_TOTAL_CONT_ASSET, IM_P_BAS_TOTAL_CONT, IM_P_BAS_NUM_IN_COLL_ADJ, IM_P_BAS_CONT_FOR_STU, IM_P_BAS_CONT_FROM_INCOME, IM_P_BAS_CONT_FROM_ASSETS, IM_P_OPT_AGI_TAXABLE_INCOME, IM_P_OPT_UNTX_INC_AND_BEN, IM_P_OPT_INC_ADJ, IM_P_OPT_TOTAL_INCOME, IM_P_OPT_US_INCOME_TAX, IM_P_OPT_ST_AND_OTHER_TAX, IM_P_OPT_FICA_TAX, IM_P_OPT_MED_DENTAL, IM_P_OPT_ELEM_SEC_TUIT, IM_P_OPT_EMPLOYMENT_ALLOW, IM_P_OPT_ANNUAL_ED_SAVINGS, IM_P_OPT_INC_PROT_ALLOW_M, IM_P_OPT_TOTAL_INC_ALLOW, IM_P_OPT_CAL_AVAIL_INC, IM_P_OPT_AVAIL_INCOME, IM_P_OPT_TOTAL_CONT_INC, IM_P_OPT_CASH_BANK_ACCOUNTS, IM_P_OPT_HOME_EQUITY, IM_P_OPT_OT_RL_EST_INV_EQ, IM_P_OPT_ADJ_BUS_FARM_WORTH, IM_P_OPT_ASS_SIBS_PRE_T, IM_P_OPT_NET_WORTH, IM_P_OPT_EMERG_RES_ALLOW, IM_P_OPT_CUM_ED_SAVINGS, IM_P_OPT_LOW_INC_ALLOW, IM_P_OPT_TOTAL_ASSET_ALLOW, IM_P_OPT_DISC_NET_WORTH, IM_P_OPT_TOTAL_CONT_ASSET, IM_P_OPT_TOTAL_CONT, IM_P_OPT_NUM_IN_COLL_ADJ, IM_P_OPT_CONT_FOR_STU, IM_P_OPT_CONT_FROM_INCOME, IM_P_OPT_CONT_FROM_ASSETS, FM_P_ANALYSIS_TYPE, FM_P_AGI_TAXABLE_INCOME, FM_P_UNTX_INC_AND_BEN, FM_P_INC_ADJ, FM_P_TOTAL_INCOME, FM_P_US_INCOME_TAX, FM_P_STATE_AND_OTHER_TAXES, FM_P_FICA_TAX, FM_P_EMPLOYMENT_ALLOW, FM_P_INCOME_PROT_ALLOW, FM_P_TOTAL_ALLOW, FM_P_AVAIL_INCOME, FM_P_CASH_BANK_ACCOUNTS, FM_P_OT_RL_EST_INV_EQ, FM_P_ADJ_BUS_FARM_NET_WORTH, FM_P_NET_WORTH, FM_P_ASSET_PROT_ALLOW, FM_P_DISC_NET_WORTH, FM_P_TOTAL_CONTRIBUTION, FM_P_NUM_IN_COLL, FM_P_CONT_FOR_STU, FM_P_CONT_FROM_INCOME,FM_P_CONT_FROM_ASSETS, IM_S_BAS_AGI_TAXABLE_INCOME, IM_S_BAS_UNTX_INC_AND_BEN, IM_S_BAS_INC_ADJ, IM_S_BAS_TOTAL_INCOME, IM_S_BAS_US_INCOME_TAX, IM_S_BAS_ST_AND_OTH_TAX, IM_S_BAS_FICA_TAX, IM_S_BAS_MED_DENTAL, IM_S_BAS_EMPLOYMENT_ALLOW, IM_S_BAS_ANNUAL_ED_SAVINGS, IM_S_BAS_INC_PROT_ALLOW_M, IM_S_BAS_TOTAL_INC_ALLOW, IM_S_BAS_CAL_AVAIL_INCOME, IM_S_BAS_AVAIL_INCOME, IM_S_BAS_TOTAL_CONT_INC, IM_S_BAS_CASH_BANK_ACCOUNTS, IM_S_BAS_HOME_EQUITY, IM_S_BAS_OT_RL_EST_INV_EQ, IM_S_BAS_ADJ_BUS_FARM_WORTH, IM_S_BAS_TRUSTS, IM_S_BAS_NET_WORTH, IM_S_BAS_EMERG_RES_ALLOW, IM_S_BAS_CUM_ED_SAVINGS, IM_S_BAS_TOTAL_ASSET_ALLOW, IM_S_BAS_DISC_NET_WORTH, IM_S_BAS_TOTAL_CONT_ASSET, IM_S_BAS_TOTAL_CONT, IM_S_BAS_NUM_IN_COLL_ADJ, IM_S_BAS_CONT_FOR_STU, IM_S_BAS_CONT_FROM_INCOME, IM_S_BAS_CONT_FROM_ASSETS, IM_S_EST_AGI_TAXABLE_INCOME, IM_S_EST_UNTX_INC_AND_BEN, IM_S_EST_INC_ADJ, IM_S_EST_TOTAL_INCOME, IM_S_EST_US_INCOME_TAX, IM_S_EST_ST_AND_OTH_TAX, IM_S_EST_FICA_TAX, IM_S_EST_MED_DENTAL, IM_S_EST_EMPLOYMENT_ALLOW, IM_S_EST_ANNUAL_ED_SAVINGS, IM_S_EST_INC_PROT_ALLOW_M, IM_S_EST_TOTAL_INC_ALLOW, IM_S_EST_CAL_AVAIL_INCOME, IM_S_EST_AVAIL_INCOME, IM_S_EST_TOTAL_CONT_INC, IM_S_EST_CASH_BANK_ACCOUNTS, IM_S_EST_HOME_EQUITY, IM_S_EST_OT_RL_EST_INV_EQU, IM_S_EST_ADJ_BUS_FARM_WORTH, IM_S_EST_EST_TRUSTS, IM_S_EST_NET_WORTH, IM_S_EST_EMERG_RES_ALLOW, IM_S_EST_CUM_ED_SAVINGS, IM_S_EST_TOTAL_ASSET_ALLOW, IM_S_EST_DISC_NET_WORTH, IM_S_EST_TOTAL_CONT_ASSET, IM_S_EST_TOTAL_CONT, IM_S_EST_NUM_IN_COLL_ADJ, IM_S_EST_CONT_FOR_STU, IM_S_EST_CONT_FROM_INCOME, IM_S_EST_CONT_FROM_ASSETS, IM_S_OPT_AGI_TAXABLE_INCOME, IM_S_OPT_UNTX_INC_AND_BEN, IM_S_OPT_INC_ADJ, IM_S_OPT_TOTAL_INCOME, IM_S_OPT_US_INCOME_TAX, IM_S_OPT_STATE_AND_OTH_TAXES, IM_S_OPT_FICA_TAX, IM_S_OPT_MED_DENTAL, IM_S_OPT_EMPLOYMENT_ALLOW, IM_S_OPT_ANNUAL_ED_SAVINGS, IM_S_OPT_INC_PROT_ALLOW_M, IM_S_OPT_TOTAL_INC_ALLOW, IM_S_OPT_CAL_AVAIL_INCOME, IM_S_OPT_AVAIL_INCOME, IM_S_OPT_TOTAL_CONT_INC, IM_S_OPT_CASH_BANK_ACCOUNTS, IM_S_OPT_IRA_KEOGH_ACCOUNTS, IM_S_OPT_HOME_EQUITY, IM_S_OPT_OT_RL_EST_INV_EQ, IM_S_OPT_ADJ_BUS_FARM_WORTH, IM_S_OPT_TRUSTS, IM_S_OPT_NET_WORTH, IM_S_OPT_EMERG_RES_ALLOW, IM_S_OPT_CUM_ED_SAVINGS, IM_S_OPT_TOTAL_ASSET_ALLOW, IM_S_OPT_DISC_NET_WORTH, IM_S_OPT_TOTAL_CONT_ASSET, IM_S_OPT_TOTAL_CONT, IM_S_OPT_NUM_IN_COLL_ADJ, IM_S_OPT_CONT_FOR_STU, IM_S_OPT_CONT_FROM_INCOME, IM_S_OPT_CONT_FROM_ASSETS, FM_S_ANALYSIS_TYPE, FM_S_AGI_TAXABLE_INCOME, FM_S_UNTX_INC_AND_BEN, FM_S_INC_ADJ, FM_S_TOTAL_INCOME, FM_S_US_INCOME_TAX, FM_S_STATE_AND_OTH_TAXES, FM_S_FICA_TAX, FM_S_EMPLOYMENT_ALLOW, FM_S_INCOME_PROT_ALLOW, FM_S_TOTAL_ALLOW, FM_S_CAL_AVAIL_INCOME, FM_S_AVAIL_INCOME, FM_S_CASH_BANK_ACCOUNTS, FM_S_OT_RL_EST_INV_EQUITY, FM_S_ADJ_BUS_FARM_WORTH, FM_S_TRUSTS, FM_S_NET_WORTH, FM_S_ASSET_PROT_ALLOW, FM_S_DISC_NET_WORTH, FM_S_TOTAL_CONT, FM_S_NUM_IN_COLL, FM_S_CONT_FOR_STU, FM_S_CONT_FROM_INCOME, FM_S_CONT_FROM_ASSETS, IM_INST_RESIDENT_IND, INSTITUTIONAL_1_BUDGET_NAME, IM_INST_1_BUDGET_DURATION, IM_INST_1_TUITION_FEES, IM_INST_1_BOOKS_SUPPLIES, IM_INST_1_LIVING_EXPENSES, IM_INST_1_TOT_EXPENSES, IM_INST_1_TOT_STU_CONT, IM_INST_1_TOT_PAR_CONT, IM_INST_1_TOT_FAMILY_CONT, IM_INST_1_VA_BENEFITS, IM_INST_1_OT_CONT, IM_INST_1_EST_FINANCIAL_NEED, INSTITUTIONAL_2_BUDGET_NAME, IM_INST_2_BUDGET_DURATION, IM_INST_2_TUITION_FEES, IM_INST_2_BOOKS_SUPPLIES, IM_INST_2_LIVING_EXPENSES, IM_INST_2_TOT_EXPENSES, IM_INST_2_TOT_STU_CONT, IM_INST_2_TOT_PAR_CONT, IM_INST_2_TOT_FAMILY_CONT, IM_INST_2_VA_BENEFITS, IM_INST_2_EST_FINANCIAL_NEED, INSTITUTIONAL_3_BUDGET_NAME, IM_INST_3_BUDGET_DURATION, IM_INST_3_TUITION_FEES, IM_INST_3_BOOKS_SUPPLIES, IM_INST_3_LIVING_EXPENSES, IM_INST_3_TOT_EXPENSES, IM_INST_3_TOT_STU_CONT, IM_INST_3_TOT_PAR_CONT, IM_INST_3_TOT_FAMILY_CONT, IM_INST_3_VA_BENEFITS, IM_INST_3_EST_FINANCIAL_NEED, FM_INST_1_FEDERAL_EFC, FM_INST_1_VA_BENEFITS, FM_INST_1_FED_ELIGIBILITY, FM_INST_1_PELL, OPTION_PAR_LOSS_ALLOW_IND, OPTION_PAR_TUITION_IND, OPTION_PAR_HOME_IND, OPTION_PAR_HOME_VALUE, OPTION_PAR_HOME_DEBT, OPTION_STU_IRA_KEOGH_IND, OPTION_STU_HOME_IND, OPTION_STU_HOME_VALUE, OPTION_STU_HOME_DEBT, OPTION_STU_SUM_AY_INC_IND, OPTION_PAR_HOPE_LL_CREDIT, OPTION_STU_HOPE_LL_CREDIT, option_par_cola_adj_ind, option_par_stu_fa_assets_ind, option_par_ipt_assets_ind, option_stu_ipt_assets_ind, option_par_cola_adj_value, IM_PARENT_1_8_MONTHS_BAS, IM_P_MORE_THAN_9_MTH_BA, IM_PARENT_1_8_MONTHS_OPT, IM_P_MORE_THAN_9_MTH_OP, FNAR_MESSAGE_1, FNAR_MESSAGE_2, FNAR_MESSAGE_3, FNAR_MESSAGE_4, FNAR_MESSAGE_5, FNAR_MESSAGE_6, FNAR_MESSAGE_7, FNAR_MESSAGE_8, FNAR_MESSAGE_9, FNAR_MESSAGE_10, FNAR_MESSAGE_11, FNAR_MESSAGE_12, FNAR_MESSAGE_13, FNAR_MESSAGE_20, FNAR_MESSAGE_21, FNAR_MESSAGE_22, FNAR_MESSAGE_23, FNAR_MESSAGE_24, FNAR_MESSAGE_25, FNAR_MESSAGE_26, FNAR_MESSAGE_27, FNAR_MESSAGE_30, FNAR_MESSAGE_31, FNAR_MESSAGE_32, FNAR_MESSAGE_33, FNAR_MESSAGE_34, FNAR_MESSAGE_35, FNAR_MESSAGE_36, FNAR_MESSAGE_37, FNAR_MESSAGE_38, FNAR_MESSAGE_39, FNAR_MESSAGE_45, FNAR_MESSAGE_46, FNAR_MESSAGE_47, FNAR_MESSAGE_48, fnar_message_49, FNAR_MESSAGE_50, FNAR_MESSAGE_51, FNAR_MESSAGE_52, FNAR_MESSAGE_53, fnar_message_55, FNAR_MESSAGE_56, FNAR_MESSAGE_57, FNAR_MESSAGE_58, FNAR_MESSAGE_59, FNAR_MESSAGE_60, FNAR_MESSAGE_61, FNAR_MESSAGE_62, FNAR_MESSAGE_63, FNAR_MESSAGE_64, FNAR_MESSAGE_65, FNAR_MESSAGE_71, FNAR_MESSAGE_72, FNAR_MESSAGE_73, FNAR_MESSAGE_74, FNAR_MESSAGE_75, FNAR_MESSAGE_76, FNAR_MESSAGE_77, FNAR_MESSAGE_78, FNAR_MESG_10_STU_FAM_MEM, FNAR_MESG_11_STU_NO_IN_COLL, FNAR_MESG_24_STU_AVAIL_INC, FNAR_MESG_26_STU_TAXES, FNAR_MESG_33_STU_HOME_VALUE, FNAR_MESG_34_STU_HOME_VALUE, FNAR_MESG_34_STU_HOME_EQUITY, FNAR_MESG_35_STU_HOME_VALUE, FNAR_MESG_35_STU_HOME_EQUITY, FNAR_MESG_36_STU_HOME_EQUITY, FNAR_MESG_48_PAR_FAM_MEM, FNAR_MESG_49_PAR_NO_IN_COLL, FNAR_MESG_56_PAR_AGI, FNAR_MESG_62_PAR_TAXES, FNAR_MESG_73_PAR_HOME_VALUE, FNAR_MESG_74_PAR_HOME_VALUE, FNAR_MESG_74_PAR_HOME_EQUITY, FNAR_MESG_75_PAR_HOME_VALUE, FNAR_MESG_75_PAR_HOME_EQUITY, FNAR_MESG_76_PAR_HOME_EQUITY, ASSUMPTION_MESSAGE_1, ASSUMPTION_MESSAGE_2, ASSUMPTION_MESSAGE_3, ASSUMPTION_MESSAGE_4, ASSUMPTION_MESSAGE_5, ASSUMPTION_MESSAGE_6, RECORD_MARK, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, p_soc_sec_ben_student_amt, p_tuit_fee_deduct_amt, option_ind_stu_ipt_assets_flag, match_code, STU_LIVES_WITH_NUM, STU_MOST_SUPPORT_FROM_NUM, LOCATION_COMPUTER_NUM, CUST_PARENT_CONT_ADJ_NUM, CUSTODIAL_PARENT_NUM, CUST_PAR_BASE_PRCNT_INC_AMT, CUST_PAR_BASE_CONT_INC_AMT, CUST_PAR_BASE_CONT_AST_AMT, CUST_PAR_BASE_TOT_CONT_AMT, CUST_PAR_OPT_PRCNT_INC_AMT, CUST_PAR_OPT_CONT_INC_AMT, CUST_PAR_OPT_CONT_AST_AMT, CUST_PAR_OPT_TOT_CONT_AMT, PARENTS_EMAIL_TXT, PARENT_1_BIRTH_DATE, PARENT_2_BIRTH_DATE from IGF_AP_CSS_INTERFACE_ALL WHERE NVL(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)

View Text - HTML Formatted

SELECT ROWID ROW_ID
, CSS_ID
, ORG_ID
, RECORD_STATUS
, COLLEGE_CODE
, ACADEMIC_YEAR
, STU_RECORD_TYPE
, CSS_ID_NUMBER
, REGISTRATION_RECEIPT_DATE
, REGISTRATION_TYPE
, APPLICATION_RECEIPT_DATE
, APPLICATION_TYPE
, ORIGINAL_FNAR_COMPUTE
, REVISION_FNAR_COMPUTE_DATE
, ELECTRONIC_EXTRACT_DATE
, INSTITUTIONAL_REPORTING_TYPE
, ASR_RECEIPT_DATE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, ADDRESS_NUMBER_AND_STREET
, CITY
, STATE_MAILING
, ZIP_CODE
, S_TELEPHONE_NUMBER
, S_TITLE
, DATE_OF_BIRTH
, SOCIAL_SECURITY_NUMBER
, STATE_LEGAL_RESIDENCE
, FOREIGN_ADDRESS_INDICATOR
, FOREIGN_POSTAL_CODE
, COUNTRY
, FINANCIAL_AID_STATUS
, YEAR_IN_COLLEGE
, MARITAL_STATUS
, WARD_COURT
, LEGAL_DEPENDENTS_OTHER
, HOUSEHOLD_SIZE
, NUMBER_IN_COLLEGE
, CITIZENSHIP_STATUS
, CITIZENSHIP_COUNTRY
, VISA_CLASSIFICATION
, TAX_FIGURES
, NUMBER_EXEMPTIONS
, ADJUSTED_GROSS_INC
, US_TAX_PAID
, ITEMIZED_DEDUCTIONS
, STU_INCOME_WORK
, SPOUSE_INCOME_WORK
, DIVID_INT_INC
, SOC_SEC_BENEFITS
, WELFARE_TANF
, CHILD_SUPP_RCVD
, EARNED_INCOME_CREDIT
, OTHER_UNTAX_INCOME
, TAX_STU_AID
, CASH_SAV_CHECK
, IRA_KEOGH
, INVEST_VALUE
, INVEST_DEBT
, HOME_VALUE
, HOME_DEBT
, OTH_REAL_VALUE
, OTH_REAL_DEBT
, BUS_FARM_VALUE
, BUS_FARM_DEBT
, LIVE_ON_FARM
, HOME_PURCH_PRICE
, HOPE_LL_CREDIT
, HOME_PURCH_YEAR
, TRUST_AMOUNT
, TRUST_AVAIL
, TRUST_ESTAB
, CHILD_SUPPORT_PAID
, MED_DENT_EXPENSES
, VET_US
, VET_BEN_AMOUNT
, VET_BEN_MONTHS
, STU_SUMMER_WAGES
, STU_SCHOOL_YR_WAGES
, SPOUSE_SUMMER_WAGES
, SPOUSE_SCHOOL_YR_WAGES
, SUMMER_OTHER_TAX_INC
, SCHOOL_YR_OTHER_TAX_INC
, SUMMER_UNTAX_INC
, SCHOOL_YR_UNTAX_INC
, GRANTS_SCHOL_ETC
, TUIT_BENEFITS
, CONT_PARENTS
, CONT_RELATIVES
, P_SIBLINGS_PRE_TUIT
, P_STUDENT_PRE_TUIT
, P_HOUSEHOLD_SIZE
, P_NUMBER_IN_COLLEGE
, P_PARENTS_IN_COLLEGE
, P_MARITAL_STATUS
, P_STATE_LEGAL_RESIDENCE
, P_NATURAL_PAR_STATUS
, P_CHILD_SUPP_PAID
, P_REPAY_ED_LOANS
, P_MED_DENT_EXPENSES
, P_TUIT_PAID_AMOUNT
, P_TUIT_PAID_NUMBER
, P_EXP_CHILD_SUPP_PAID
, P_EXP_REPAY_ED_LOANS
, P_EXP_MED_DENT_EXPENSES
, P_EXP_TUIT_PD_AMOUNT
, P_EXP_TUIT_PD_NUMBER
, P_CASH_SAV_CHECK
, P_MONTH_MORTGAGE_PAY
, P_INVEST_VALUE
, P_INVEST_DEBT
, P_HOME_VALUE
, P_HOME_DEBT
, P_HOME_PURCH_PRICE
, P_OWN_BUSINESS_FARM
, P_BUSINESS_VALUE
, P_BUSINESS_DEBT
, P_FARM_VALUE
, P_FARM_DEBT
, P_LIVE_ON_FARM
, P_OTH_REAL_ESTATE_VALUE
, P_OTH_REAL_ESTATE_DEBT
, P_OTH_REAL_PURCH_PRICE
, P_SIBLINGS_ASSETS
, P_HOME_PURCH_YEAR
, P_OTH_REAL_PURCH_YEAR
, P_PRIOR_AGI
, P_PRIOR_US_TAX_PAID
, P_PRIOR_ITEM_DEDUCTIONS
, P_PRIOR_OTHER_UNTAX_INC
, P_TAX_FIGURES
, P_NUMBER_EXEMPTIONS
, P_ADJUSTED_GROSS_INC
, P_WAGES_SAL_TIPS
, P_INTEREST_INCOME
, P_DIVIDEND_INCOME
, P_NET_INC_BUS_FARM
, P_OTHER_TAXABLE_INCOME
, P_ADJ_TO_INCOME
, P_US_TAX_PAID
, P_ITEMIZED_DEDUCTIONS
, P_FATHER_INCOME_WORK
, P_MOTHER_INCOME_WORK
, P_SOC_SEC_BEN
, P_WELFARE_TANF
, P_CHILD_SUPP_RCVD
, P_DED_IRA_KEOGH
, P_TAX_DEFER_PENS_SAVS
, P_DEP_CARE_MED_SPENDING
, P_EARNED_INCOME_CREDIT
, P_LIVING_ALLOW
, P_TAX_EXMPT_INT
, P_FOREIGN_INC_EXCL
, P_OTHER_UNTAX_INC
, P_HOPE_LL_CREDIT
, P_YR_SEPARATION
, P_YR_DIVORCE
, P_EXP_FATHER_INC
, P_EXP_MOTHER_INC
, P_EXP_OTHER_TAX_INC
, P_EXP_OTHER_UNTAX_INC
, LINE_2_RELATION
, LINE_2_ATTEND_COLLEGE
, LINE_3_RELATION
, LINE_3_ATTEND_COLLEGE
, LINE_4_RELATION
, LINE_4_ATTEND_COLLEGE
, LINE_5_RELATION
, LINE_5_ATTEND_COLLEGE
, LINE_6_RELATION
, LINE_6_ATTEND_COLLEGE
, LINE_7_RELATION
, LINE_7_ATTEND_COLLEGE
, LINE_8_RELATION
, LINE_8_ATTEND_COLLEGE
, P_AGE_FATHER
, P_AGE_MOTHER
, P_DIV_SEP_IND
, B_CONT_NON_CUSTODIAL_PAR
, COLLEGE_TYPE_2
, COLLEGE_TYPE_3
, COLLEGE_TYPE_4
, COLLEGE_TYPE_5
, COLLEGE_TYPE_6
, COLLEGE_TYPE_7
, COLLEGE_TYPE_8
, SCHOOL_CODE_1
, HOUSING_CODE_1
, SCHOOL_CODE_2
, HOUSING_CODE_2
, SCHOOL_CODE_3
, HOUSING_CODE_3
, SCHOOL_CODE_4
, HOUSING_CODE_4
, SCHOOL_CODE_5
, HOUSING_CODE_5
, SCHOOL_CODE_6
, HOUSING_CODE_6
, SCHOOL_CODE_7
, HOUSING_CODE_7
, SCHOOL_CODE_8
, HOUSING_CODE_8
, SCHOOL_CODE_9
, HOUSING_CODE_9
, SCHOOL_CODE_10
, HOUSING_CODE_10
, ADDITIONAL_SCHOOL_CODE_1
, ADDITIONAL_SCHOOL_CODE_2
, ADDITIONAL_SCHOOL_CODE_3
, ADDITIONAL_SCHOOL_CODE_4
, ADDITIONAL_SCHOOL_CODE_5
, ADDITIONAL_SCHOOL_CODE_6
, ADDITIONAL_SCHOOL_CODE_7
, ADDITIONAL_SCHOOL_CODE_8
, ADDITIONAL_SCHOOL_CODE_9
, ADDITIONAL_SCHOOL_CODE_10
, EXPLANATION_SPEC_CIRCUM
, SIGNATURE_STUDENT
, SIGNATURE_SPOUSE
, SIGNATURE_FATHER
, SIGNATURE_MOTHER
, MONTH_DAY_COMPLETED
, YEAR_COMPLETED
, AGE_LINE_2
, AGE_LINE_3
, AGE_LINE_4
, AGE_LINE_5
, AGE_LINE_6
, AGE_LINE_7
, AGE_LINE_8
, A_ONLINE_SIGNATURE
, QUESTION_1_NUMBER
, QUESTION_1_SIZE
, QUESTION_1_ANSWER
, QUESTION_2_NUMBER
, QUESTION_2_SIZE
, QUESTION_2_ANSWER
, QUESTION_3_NUMBER
, QUESTION_3_SIZE
, QUESTION_3_ANSWER
, QUESTION_4_NUMBER
, QUESTION_4_SIZE
, QUESTION_4_ANSWER
, QUESTION_5_NUMBER
, QUESTION_5_SIZE
, QUESTION_5_ANSWER
, QUESTION_6_NUMBER
, QUESTION_6_SIZE
, QUESTION_6_ANSWER
, QUESTION_7_NUMBER
, QUESTION_7_SIZE
, QUESTION_7_ANSWER
, QUESTION_8_NUMBER
, QUESTION_8_SIZE
, QUESTION_8_ANSWER
, QUESTION_9_NUMBER
, QUESTION_9_SIZE
, QUESTION_9_ANSWER
, QUESTION_10_NUMBER
, QUESTION_10_SIZE
, QUESTION_10_ANSWER
, QUESTION_11_NUMBER
, QUESTION_11_SIZE
, QUESTION_11_ANSWER
, QUESTION_12_NUMBER
, QUESTION_12_SIZE
, QUESTION_12_ANSWER
, QUESTION_13_NUMBER
, QUESTION_13_SIZE
, QUESTION_13_ANSWER
, QUESTION_14_NUMBER
, QUESTION_14_SIZE
, QUESTION_14_ANSWER
, QUESTION_15_NUMBER
, QUESTION_15_SIZE
, QUESTION_15_ANSWER
, QUESTION_16_NUMBER
, QUESTION_16_SIZE
, QUESTION_16_ANSWER
, QUESTION_17_NUMBER
, QUESTION_17_SIZE
, QUESTION_17_ANSWER
, QUESTION_18_NUMBER
, QUESTION_18_SIZE
, QUESTION_18_ANSWER
, QUESTION_19_NUMBER
, QUESTION_19_SIZE
, QUESTION_19_ANSWER
, QUESTION_20_NUMBER
, QUESTION_20_SIZE
, QUESTION_20_ANSWER
, QUESTION_21_NUMBER
, QUESTION_21_SIZE
, QUESTION_21_ANSWER
, QUESTION_22_NUMBER
, QUESTION_22_SIZE
, QUESTION_22_ANSWER
, QUESTION_23_NUMBER
, QUESTION_23_SIZE
, QUESTION_23_ANSWER
, QUESTION_24_NUMBER
, QUESTION_24_SIZE
, QUESTION_24_ANSWER
, QUESTION_25_NUMBER
, QUESTION_25_SIZE
, QUESTION_25_ANSWER
, QUESTION_26_NUMBER
, QUESTION_26_SIZE
, QUESTION_26_ANSWER
, QUESTION_27_NUMBER
, QUESTION_27_SIZE
, QUESTION_27_ANSWER
, QUESTION_28_NUMBER
, QUESTION_28_SIZE
, QUESTION_28_ANSWER
, QUESTION_29_NUMBER
, QUESTION_29_SIZE
, QUESTION_29_ANSWER
, QUESTION_30_NUMBER
, QUESTIONS_30_SIZE
, QUESTION_30_ANSWER
, R_S_EMAIL_ADDRESS
, EPS_CODE
, COMP_CSS_DEPENDENCY_STATUS
, STU_AGE
, ASSUMED_STU_YR_IN_COLL
, COMP_STU_MARITAL_STATUS
, STU_FAMILY_MEMBERS
, STU_FAM_MEMBERS_IN_COLLEGE
, PAR_MARITAL_STATUS
, PAR_FAMILY_MEMBERS
, PAR_TOTAL_IN_COLLEGE
, PAR_PAR_IN_COLLEGE
, PAR_OTHERS_IN_COLLEGE
, PAR_AESA
, PAR_CESA
, STU_AESA
, STU_CESA
, IM_P_BAS_AGI_TAXABLE_INCOME
, IM_P_BAS_UNTX_INC_AND_BEN
, IM_P_BAS_INC_ADJ
, IM_P_BAS_TOTAL_INCOME
, IM_P_BAS_US_INCOME_TAX
, IM_P_BAS_ST_AND_OTHER_TAX
, IM_P_BAS_FICA_TAX
, IM_P_BAS_MED_DENTAL
, IM_P_BAS_EMPLOYMENT_ALLOW
, IM_P_BAS_ANNUAL_ED_SAVINGS
, IM_P_BAS_INC_PROT_ALLOW_M
, IM_P_BAS_TOTAL_INC_ALLOW
, IM_P_BAS_CAL_AVAIL_INC
, IM_P_BAS_AVAIL_INCOME
, IM_P_BAS_TOTAL_CONT_INC
, IM_P_BAS_CASH_BANK_ACCOUNTS
, IM_P_BAS_HOME_EQUITY
, IM_P_BAS_OT_RL_EST_INV_EQ
, IM_P_BAS_ADJ_BUS_FARM_WORTH
, IM_P_BAS_ASS_SIBS_PRE_TUI
, IM_P_BAS_NET_WORTH
, IM_P_BAS_EMERG_RES_ALLOW
, IM_P_BAS_CUM_ED_SAVINGS
, IM_P_BAS_LOW_INC_ALLOW
, IM_P_BAS_TOTAL_ASSET_ALLOW
, IM_P_BAS_DISC_NET_WORTH
, IM_P_BAS_TOTAL_CONT_ASSET
, IM_P_BAS_TOTAL_CONT
, IM_P_BAS_NUM_IN_COLL_ADJ
, IM_P_BAS_CONT_FOR_STU
, IM_P_BAS_CONT_FROM_INCOME
, IM_P_BAS_CONT_FROM_ASSETS
, IM_P_OPT_AGI_TAXABLE_INCOME
, IM_P_OPT_UNTX_INC_AND_BEN
, IM_P_OPT_INC_ADJ
, IM_P_OPT_TOTAL_INCOME
, IM_P_OPT_US_INCOME_TAX
, IM_P_OPT_ST_AND_OTHER_TAX
, IM_P_OPT_FICA_TAX
, IM_P_OPT_MED_DENTAL
, IM_P_OPT_ELEM_SEC_TUIT
, IM_P_OPT_EMPLOYMENT_ALLOW
, IM_P_OPT_ANNUAL_ED_SAVINGS
, IM_P_OPT_INC_PROT_ALLOW_M
, IM_P_OPT_TOTAL_INC_ALLOW
, IM_P_OPT_CAL_AVAIL_INC
, IM_P_OPT_AVAIL_INCOME
, IM_P_OPT_TOTAL_CONT_INC
, IM_P_OPT_CASH_BANK_ACCOUNTS
, IM_P_OPT_HOME_EQUITY
, IM_P_OPT_OT_RL_EST_INV_EQ
, IM_P_OPT_ADJ_BUS_FARM_WORTH
, IM_P_OPT_ASS_SIBS_PRE_T
, IM_P_OPT_NET_WORTH
, IM_P_OPT_EMERG_RES_ALLOW
, IM_P_OPT_CUM_ED_SAVINGS
, IM_P_OPT_LOW_INC_ALLOW
, IM_P_OPT_TOTAL_ASSET_ALLOW
, IM_P_OPT_DISC_NET_WORTH
, IM_P_OPT_TOTAL_CONT_ASSET
, IM_P_OPT_TOTAL_CONT
, IM_P_OPT_NUM_IN_COLL_ADJ
, IM_P_OPT_CONT_FOR_STU
, IM_P_OPT_CONT_FROM_INCOME
, IM_P_OPT_CONT_FROM_ASSETS
, FM_P_ANALYSIS_TYPE
, FM_P_AGI_TAXABLE_INCOME
, FM_P_UNTX_INC_AND_BEN
, FM_P_INC_ADJ
, FM_P_TOTAL_INCOME
, FM_P_US_INCOME_TAX
, FM_P_STATE_AND_OTHER_TAXES
, FM_P_FICA_TAX
, FM_P_EMPLOYMENT_ALLOW
, FM_P_INCOME_PROT_ALLOW
, FM_P_TOTAL_ALLOW
, FM_P_AVAIL_INCOME
, FM_P_CASH_BANK_ACCOUNTS
, FM_P_OT_RL_EST_INV_EQ
, FM_P_ADJ_BUS_FARM_NET_WORTH
, FM_P_NET_WORTH
, FM_P_ASSET_PROT_ALLOW
, FM_P_DISC_NET_WORTH
, FM_P_TOTAL_CONTRIBUTION
, FM_P_NUM_IN_COLL
, FM_P_CONT_FOR_STU
, FM_P_CONT_FROM_INCOME
, FM_P_CONT_FROM_ASSETS
, IM_S_BAS_AGI_TAXABLE_INCOME
, IM_S_BAS_UNTX_INC_AND_BEN
, IM_S_BAS_INC_ADJ
, IM_S_BAS_TOTAL_INCOME
, IM_S_BAS_US_INCOME_TAX
, IM_S_BAS_ST_AND_OTH_TAX
, IM_S_BAS_FICA_TAX
, IM_S_BAS_MED_DENTAL
, IM_S_BAS_EMPLOYMENT_ALLOW
, IM_S_BAS_ANNUAL_ED_SAVINGS
, IM_S_BAS_INC_PROT_ALLOW_M
, IM_S_BAS_TOTAL_INC_ALLOW
, IM_S_BAS_CAL_AVAIL_INCOME
, IM_S_BAS_AVAIL_INCOME
, IM_S_BAS_TOTAL_CONT_INC
, IM_S_BAS_CASH_BANK_ACCOUNTS
, IM_S_BAS_HOME_EQUITY
, IM_S_BAS_OT_RL_EST_INV_EQ
, IM_S_BAS_ADJ_BUS_FARM_WORTH
, IM_S_BAS_TRUSTS
, IM_S_BAS_NET_WORTH
, IM_S_BAS_EMERG_RES_ALLOW
, IM_S_BAS_CUM_ED_SAVINGS
, IM_S_BAS_TOTAL_ASSET_ALLOW
, IM_S_BAS_DISC_NET_WORTH
, IM_S_BAS_TOTAL_CONT_ASSET
, IM_S_BAS_TOTAL_CONT
, IM_S_BAS_NUM_IN_COLL_ADJ
, IM_S_BAS_CONT_FOR_STU
, IM_S_BAS_CONT_FROM_INCOME
, IM_S_BAS_CONT_FROM_ASSETS
, IM_S_EST_AGI_TAXABLE_INCOME
, IM_S_EST_UNTX_INC_AND_BEN
, IM_S_EST_INC_ADJ
, IM_S_EST_TOTAL_INCOME
, IM_S_EST_US_INCOME_TAX
, IM_S_EST_ST_AND_OTH_TAX
, IM_S_EST_FICA_TAX
, IM_S_EST_MED_DENTAL
, IM_S_EST_EMPLOYMENT_ALLOW
, IM_S_EST_ANNUAL_ED_SAVINGS
, IM_S_EST_INC_PROT_ALLOW_M
, IM_S_EST_TOTAL_INC_ALLOW
, IM_S_EST_CAL_AVAIL_INCOME
, IM_S_EST_AVAIL_INCOME
, IM_S_EST_TOTAL_CONT_INC
, IM_S_EST_CASH_BANK_ACCOUNTS
, IM_S_EST_HOME_EQUITY
, IM_S_EST_OT_RL_EST_INV_EQU
, IM_S_EST_ADJ_BUS_FARM_WORTH
, IM_S_EST_EST_TRUSTS
, IM_S_EST_NET_WORTH
, IM_S_EST_EMERG_RES_ALLOW
, IM_S_EST_CUM_ED_SAVINGS
, IM_S_EST_TOTAL_ASSET_ALLOW
, IM_S_EST_DISC_NET_WORTH
, IM_S_EST_TOTAL_CONT_ASSET
, IM_S_EST_TOTAL_CONT
, IM_S_EST_NUM_IN_COLL_ADJ
, IM_S_EST_CONT_FOR_STU
, IM_S_EST_CONT_FROM_INCOME
, IM_S_EST_CONT_FROM_ASSETS
, IM_S_OPT_AGI_TAXABLE_INCOME
, IM_S_OPT_UNTX_INC_AND_BEN
, IM_S_OPT_INC_ADJ
, IM_S_OPT_TOTAL_INCOME
, IM_S_OPT_US_INCOME_TAX
, IM_S_OPT_STATE_AND_OTH_TAXES
, IM_S_OPT_FICA_TAX
, IM_S_OPT_MED_DENTAL
, IM_S_OPT_EMPLOYMENT_ALLOW
, IM_S_OPT_ANNUAL_ED_SAVINGS
, IM_S_OPT_INC_PROT_ALLOW_M
, IM_S_OPT_TOTAL_INC_ALLOW
, IM_S_OPT_CAL_AVAIL_INCOME
, IM_S_OPT_AVAIL_INCOME
, IM_S_OPT_TOTAL_CONT_INC
, IM_S_OPT_CASH_BANK_ACCOUNTS
, IM_S_OPT_IRA_KEOGH_ACCOUNTS
, IM_S_OPT_HOME_EQUITY
, IM_S_OPT_OT_RL_EST_INV_EQ
, IM_S_OPT_ADJ_BUS_FARM_WORTH
, IM_S_OPT_TRUSTS
, IM_S_OPT_NET_WORTH
, IM_S_OPT_EMERG_RES_ALLOW
, IM_S_OPT_CUM_ED_SAVINGS
, IM_S_OPT_TOTAL_ASSET_ALLOW
, IM_S_OPT_DISC_NET_WORTH
, IM_S_OPT_TOTAL_CONT_ASSET
, IM_S_OPT_TOTAL_CONT
, IM_S_OPT_NUM_IN_COLL_ADJ
, IM_S_OPT_CONT_FOR_STU
, IM_S_OPT_CONT_FROM_INCOME
, IM_S_OPT_CONT_FROM_ASSETS
, FM_S_ANALYSIS_TYPE
, FM_S_AGI_TAXABLE_INCOME
, FM_S_UNTX_INC_AND_BEN
, FM_S_INC_ADJ
, FM_S_TOTAL_INCOME
, FM_S_US_INCOME_TAX
, FM_S_STATE_AND_OTH_TAXES
, FM_S_FICA_TAX
, FM_S_EMPLOYMENT_ALLOW
, FM_S_INCOME_PROT_ALLOW
, FM_S_TOTAL_ALLOW
, FM_S_CAL_AVAIL_INCOME
, FM_S_AVAIL_INCOME
, FM_S_CASH_BANK_ACCOUNTS
, FM_S_OT_RL_EST_INV_EQUITY
, FM_S_ADJ_BUS_FARM_WORTH
, FM_S_TRUSTS
, FM_S_NET_WORTH
, FM_S_ASSET_PROT_ALLOW
, FM_S_DISC_NET_WORTH
, FM_S_TOTAL_CONT
, FM_S_NUM_IN_COLL
, FM_S_CONT_FOR_STU
, FM_S_CONT_FROM_INCOME
, FM_S_CONT_FROM_ASSETS
, IM_INST_RESIDENT_IND
, INSTITUTIONAL_1_BUDGET_NAME
, IM_INST_1_BUDGET_DURATION
, IM_INST_1_TUITION_FEES
, IM_INST_1_BOOKS_SUPPLIES
, IM_INST_1_LIVING_EXPENSES
, IM_INST_1_TOT_EXPENSES
, IM_INST_1_TOT_STU_CONT
, IM_INST_1_TOT_PAR_CONT
, IM_INST_1_TOT_FAMILY_CONT
, IM_INST_1_VA_BENEFITS
, IM_INST_1_OT_CONT
, IM_INST_1_EST_FINANCIAL_NEED
, INSTITUTIONAL_2_BUDGET_NAME
, IM_INST_2_BUDGET_DURATION
, IM_INST_2_TUITION_FEES
, IM_INST_2_BOOKS_SUPPLIES
, IM_INST_2_LIVING_EXPENSES
, IM_INST_2_TOT_EXPENSES
, IM_INST_2_TOT_STU_CONT
, IM_INST_2_TOT_PAR_CONT
, IM_INST_2_TOT_FAMILY_CONT
, IM_INST_2_VA_BENEFITS
, IM_INST_2_EST_FINANCIAL_NEED
, INSTITUTIONAL_3_BUDGET_NAME
, IM_INST_3_BUDGET_DURATION
, IM_INST_3_TUITION_FEES
, IM_INST_3_BOOKS_SUPPLIES
, IM_INST_3_LIVING_EXPENSES
, IM_INST_3_TOT_EXPENSES
, IM_INST_3_TOT_STU_CONT
, IM_INST_3_TOT_PAR_CONT
, IM_INST_3_TOT_FAMILY_CONT
, IM_INST_3_VA_BENEFITS
, IM_INST_3_EST_FINANCIAL_NEED
, FM_INST_1_FEDERAL_EFC
, FM_INST_1_VA_BENEFITS
, FM_INST_1_FED_ELIGIBILITY
, FM_INST_1_PELL
, OPTION_PAR_LOSS_ALLOW_IND
, OPTION_PAR_TUITION_IND
, OPTION_PAR_HOME_IND
, OPTION_PAR_HOME_VALUE
, OPTION_PAR_HOME_DEBT
, OPTION_STU_IRA_KEOGH_IND
, OPTION_STU_HOME_IND
, OPTION_STU_HOME_VALUE
, OPTION_STU_HOME_DEBT
, OPTION_STU_SUM_AY_INC_IND
, OPTION_PAR_HOPE_LL_CREDIT
, OPTION_STU_HOPE_LL_CREDIT
, OPTION_PAR_COLA_ADJ_IND
, OPTION_PAR_STU_FA_ASSETS_IND
, OPTION_PAR_IPT_ASSETS_IND
, OPTION_STU_IPT_ASSETS_IND
, OPTION_PAR_COLA_ADJ_VALUE
, IM_PARENT_1_8_MONTHS_BAS
, IM_P_MORE_THAN_9_MTH_BA
, IM_PARENT_1_8_MONTHS_OPT
, IM_P_MORE_THAN_9_MTH_OP
, FNAR_MESSAGE_1
, FNAR_MESSAGE_2
, FNAR_MESSAGE_3
, FNAR_MESSAGE_4
, FNAR_MESSAGE_5
, FNAR_MESSAGE_6
, FNAR_MESSAGE_7
, FNAR_MESSAGE_8
, FNAR_MESSAGE_9
, FNAR_MESSAGE_10
, FNAR_MESSAGE_11
, FNAR_MESSAGE_12
, FNAR_MESSAGE_13
, FNAR_MESSAGE_20
, FNAR_MESSAGE_21
, FNAR_MESSAGE_22
, FNAR_MESSAGE_23
, FNAR_MESSAGE_24
, FNAR_MESSAGE_25
, FNAR_MESSAGE_26
, FNAR_MESSAGE_27
, FNAR_MESSAGE_30
, FNAR_MESSAGE_31
, FNAR_MESSAGE_32
, FNAR_MESSAGE_33
, FNAR_MESSAGE_34
, FNAR_MESSAGE_35
, FNAR_MESSAGE_36
, FNAR_MESSAGE_37
, FNAR_MESSAGE_38
, FNAR_MESSAGE_39
, FNAR_MESSAGE_45
, FNAR_MESSAGE_46
, FNAR_MESSAGE_47
, FNAR_MESSAGE_48
, FNAR_MESSAGE_49
, FNAR_MESSAGE_50
, FNAR_MESSAGE_51
, FNAR_MESSAGE_52
, FNAR_MESSAGE_53
, FNAR_MESSAGE_55
, FNAR_MESSAGE_56
, FNAR_MESSAGE_57
, FNAR_MESSAGE_58
, FNAR_MESSAGE_59
, FNAR_MESSAGE_60
, FNAR_MESSAGE_61
, FNAR_MESSAGE_62
, FNAR_MESSAGE_63
, FNAR_MESSAGE_64
, FNAR_MESSAGE_65
, FNAR_MESSAGE_71
, FNAR_MESSAGE_72
, FNAR_MESSAGE_73
, FNAR_MESSAGE_74
, FNAR_MESSAGE_75
, FNAR_MESSAGE_76
, FNAR_MESSAGE_77
, FNAR_MESSAGE_78
, FNAR_MESG_10_STU_FAM_MEM
, FNAR_MESG_11_STU_NO_IN_COLL
, FNAR_MESG_24_STU_AVAIL_INC
, FNAR_MESG_26_STU_TAXES
, FNAR_MESG_33_STU_HOME_VALUE
, FNAR_MESG_34_STU_HOME_VALUE
, FNAR_MESG_34_STU_HOME_EQUITY
, FNAR_MESG_35_STU_HOME_VALUE
, FNAR_MESG_35_STU_HOME_EQUITY
, FNAR_MESG_36_STU_HOME_EQUITY
, FNAR_MESG_48_PAR_FAM_MEM
, FNAR_MESG_49_PAR_NO_IN_COLL
, FNAR_MESG_56_PAR_AGI
, FNAR_MESG_62_PAR_TAXES
, FNAR_MESG_73_PAR_HOME_VALUE
, FNAR_MESG_74_PAR_HOME_VALUE
, FNAR_MESG_74_PAR_HOME_EQUITY
, FNAR_MESG_75_PAR_HOME_VALUE
, FNAR_MESG_75_PAR_HOME_EQUITY
, FNAR_MESG_76_PAR_HOME_EQUITY
, ASSUMPTION_MESSAGE_1
, ASSUMPTION_MESSAGE_2
, ASSUMPTION_MESSAGE_3
, ASSUMPTION_MESSAGE_4
, ASSUMPTION_MESSAGE_5
, ASSUMPTION_MESSAGE_6
, RECORD_MARK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, P_SOC_SEC_BEN_STUDENT_AMT
, P_TUIT_FEE_DEDUCT_AMT
, OPTION_IND_STU_IPT_ASSETS_FLAG
, MATCH_CODE
, STU_LIVES_WITH_NUM
, STU_MOST_SUPPORT_FROM_NUM
, LOCATION_COMPUTER_NUM
, CUST_PARENT_CONT_ADJ_NUM
, CUSTODIAL_PARENT_NUM
, CUST_PAR_BASE_PRCNT_INC_AMT
, CUST_PAR_BASE_CONT_INC_AMT
, CUST_PAR_BASE_CONT_AST_AMT
, CUST_PAR_BASE_TOT_CONT_AMT
, CUST_PAR_OPT_PRCNT_INC_AMT
, CUST_PAR_OPT_CONT_INC_AMT
, CUST_PAR_OPT_CONT_AST_AMT
, CUST_PAR_OPT_TOT_CONT_AMT
, PARENTS_EMAIL_TXT
, PARENT_1_BIRTH_DATE
, PARENT_2_BIRTH_DATE
FROM IGF_AP_CSS_INTERFACE_ALL
WHERE NVL(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)