VIEW: APPS.IGFFV_PROFILE_INFORMATION

Source

View Text - Preformatted

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

View Text - HTML Formatted

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