VIEW: APPS.IGF_AP_CSS_FNAR

Source

View Text - Preformatted

SELECT rowid row_id, fnar_id , cssp_id , 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_tui , 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_equity , 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_state_and_oth_taxes , 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_busfarm_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_agitaxable_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_state_and_oth_taxes , 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_eq , 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,legacy_record_flag, creation_date, created_by, last_updated_by, last_update_date, last_update_login, option_ind_stu_ipt_assets_flag, 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_FNAR_ALL WHERE NVL (IGF_AP_CSS_FNAR_ALL.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
, FNAR_ID
, CSSP_ID
, 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_TUI
, 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_EQUITY
, 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_STATE_AND_OTH_TAXES
, 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_BUSFARM_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_AGITAXABLE_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_STATE_AND_OTH_TAXES
, 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_EQ
, 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
, LEGACY_RECORD_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OPTION_IND_STU_IPT_ASSETS_FLAG
, 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_FNAR_ALL
WHERE NVL (IGF_AP_CSS_FNAR_ALL.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)