The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
A.ROWID ROW_ID ,
A.PERSON_NUMBER ,
A.CSSINT_ID ,
A.COLLEGE_CD ,
A.ACADEMIC_YEAR_TXT ,
A.STU_RECORD_TYPE ,
A.CSS_ID_NUMBER_TXT ,
A.REGISTRATION_RECEIPT_DATE ,
A.REGISTRATION_TYPE ,
A.APPLICATION_RECEIPT_DATE ,
A.APPLICATION_TYPE ,
A.ORIGINAL_FNAR_COMPUTE_TXT ,
A.REVISION_FNAR_COMPUTE_DATE ,
A.ELECTRONIC_EXTRACT_DATE ,
A.INSTIT_REPORTING_TYPE ,
A.ASR_RECEIPT_DATE ,
A.LAST_NAME ,
A.FIRST_NAME ,
A.MIDDLE_INITIAL_TXT ,
A.ADDRESS_NUMBER_AND_STREET_TXT ,
A.CITY_TXT ,
A.STATE_MAILING_TXT ,
A.ZIP_CD ,
A.S_TELEPHONE_NUMBER_TXT ,
A.S_TITLE_TYPE ,
A.BIRTH_DATE ,
A.SOCIAL_SECURITY_NUM ,
A.STATE_LEGAL_RESIDENCE_TXT ,
A.FOREIGN_ADDRESS_FLAG ,
A.FOREIGN_POSTAL_CD ,
A.COUNTRY_CD ,
A.FINANCIAL_AID_STATUS_TYPE ,
A.YEAR_IN_COLLEGE_TYPE ,
A.MARITAL_STATUS_FLAG ,
A.WARD_COURT_FLAG ,
A.LEGAL_DEPENDENTS_OTHER_FLAG ,
A.HOUSEHOLD_SIZE_NUM ,
A.NUMBER_IN_COLLEGE_NUM ,
A.CITIZENSHIP_STATUS_TYPE ,
A.CITIZENSHIP_COUNTRY_CD ,
A.VISA_CLASSIFICATION_TYPE ,
A.TAX_FIGURES_TYPE ,
A.NUMBER_EXEMPTIONS_TXT ,
A.ADJUSTED_GROSS_AMT ,
A.US_TAX_PAID_AMT ,
A.ITEMIZED_DEDUCTIONS_AMT ,
A.STU_INCOME_WORK_AMT ,
A.SPOUSE_INCOME_WORK_AMT ,
A.DIVID_INT_INCOME_AMT ,
A.SOC_SEC_BENEFITS_AMT ,
A.WELFARE_TANF_AMT ,
A.CHILD_SUPP_RCVD_AMT ,
A.EARNED_INCOME_CREDIT_AMT ,
A.OTHER_UNTAX_INCOME_AMT ,
A.TAX_STU_AID_AMT ,
A.CASH_SAV_CHECK_AMT ,
A.IRA_KEOGH_AMT ,
A.INVEST_VALUE_AMT ,
A.INVEST_DEBT_AMT ,
A.HOME_VALUE_AMT ,
A.HOME_DEBT_AMT ,
A.OTH_REAL_VALUE_AMT ,
A.OTH_REAL_DEBT_AMT ,
A.BUS_FARM_VALUE_AMT ,
A.BUS_FARM_DEBT_AMT ,
A.LIVE_ON_FARM_FLAG ,
A.HOME_PURCH_PRICE_AMT ,
A.HOPE_LL_CREDIT_AMT ,
A.HOME_PURCH_YEAR_TXT ,
A.TRUST_AMOUNT_TXT ,
A.TRUST_AVAIL_FLAG ,
A.TRUST_ESTAB_FLAG ,
A.CHILD_SUPPORT_PAID_TXT ,
A.MED_DENT_EXPENSES_TXT ,
A.VET_US_FLAG ,
A.VET_BEN_AMT ,
A.VET_BEN_MONTHS_NUM ,
A.STU_SUMMER_WAGES_AMT ,
A.STU_SCHOOL_YR_WAGES_AMT ,
A.SPOUSE_SUMMER_WAGES_AMT ,
A.SPOUSE_SCHOOL_YR_WAGES_AMT ,
A.SUMMER_OTHER_TAX_INC_AMT ,
A.SCHOOL_YR_OTHER_TAX_INC_AMT ,
A.SUMMER_UNTAX_INC_AMT ,
A.SCHOOL_YR_UNTAX_INC_AMT ,
A.GRANTS_SCHOL_ETC_AMT ,
A.TUIT_BENEFITS_AMT ,
A.CONT_PARENTS_AMT ,
A.CONT_RELATIVES_AMT ,
A.P_SIBLINGS_PRE_TUIT_AMT ,
A.P_STUDENT_PRE_TUIT_AMT ,
A.P_HOUSEHOLD_SIZE_NUM ,
A.P_IN_COLLEGE_NUM ,
A.P_PARENTS_IN_COLLEGE_NUM ,
A.P_MARITAL_STATUS_TYPE ,
A.P_STATE_LEGAL_RESIDENCE_CD ,
A.P_NATURAL_PAR_STATUS_FLAG ,
A.P_CHILD_SUPP_PAID_AMT ,
A.P_REPAY_ED_LOANS_AMT ,
A.P_MED_DENT_EXPENSES_AMT ,
A.P_TUIT_PAID_AMT ,
A.P_TUIT_PAID_NUM ,
A.P_EXP_CHILD_SUPP_PAID_AMT ,
A.P_EXP_REPAY_ED_LOANS_AMT ,
A.P_EXP_MED_DENT_EXPENSES_AMT ,
A.P_EXP_TUIT_PD_AMT ,
A.P_EXP_TUIT_PD_NUM ,
A.P_CASH_SAV_CHECK_AMT ,
A.P_MONTH_MORTGAGE_PAY_AMT ,
A.P_INVEST_VALUE_AMT ,
A.P_INVEST_DEBT_AMT ,
A.P_HOME_VALUE_AMT ,
A.P_HOME_DEBT_AMT ,
A.P_HOME_PURCH_PRICE_AMT ,
A.P_OWN_BUSINESS_FARM_FLAG ,
A.P_BUSINESS_VALUE_AMT ,
A.P_BUSINESS_DEBT_AMT ,
A.P_FARM_VALUE_AMT ,
A.P_FARM_DEBT_AMT ,
A.P_LIVE_ON_FARM_NUM ,
A.P_OTH_REAL_ESTATE_VALUE_AMT ,
A.P_OTH_REAL_ESTATE_DEBT_AMT ,
A.P_OTH_REAL_PURCH_PRICE_AMT ,
A.P_SIBLINGS_ASSETS_AMT ,
A.P_HOME_PURCH_YEAR_TXT ,
A.P_OTH_REAL_PURCH_YEAR_TXT ,
A.P_PRIOR_AGI_AMT ,
A.P_PRIOR_US_TAX_PAID_AMT ,
A.P_PRIOR_ITEM_DEDUCTIONS_AMT ,
A.P_PRIOR_OTHER_UNTAX_INC_AMT ,
A.P_TAX_FIGURES_NUM ,
A.P_NUMBER_EXEMPTIONS_NUM ,
A.P_ADJUSTED_GROSS_INC_AMT ,
A.P_WAGES_SAL_TIPS_AMT ,
A.P_INTEREST_INCOME_AMT ,
A.P_DIVIDEND_INCOME_AMT ,
A.P_NET_INC_BUS_FARM_AMT ,
A.P_OTHER_TAXABLE_INCOME_AMT ,
A.P_ADJ_TO_INCOME_AMT ,
A.P_US_TAX_PAID_AMT ,
A.P_ITEMIZED_DEDUCTIONS_AMT ,
A.P_FATHER_INCOME_WORK_AMT ,
A.P_MOTHER_INCOME_WORK_AMT ,
A.P_SOC_SEC_BEN_AMT ,
A.P_WELFARE_TANF_AMT ,
A.P_CHILD_SUPP_RCVD_AMT ,
A.P_DED_IRA_KEOGH_AMT ,
A.P_TAX_DEFER_PENS_SAVS_AMT ,
A.P_DEP_CARE_MED_SPENDING_AMT ,
A.P_EARNED_INCOME_CREDIT_AMT ,
A.P_LIVING_ALLOW_AMT ,
A.P_TAX_EXMPT_INT_AMT ,
A.P_FOREIGN_INC_EXCL_AMT ,
A.P_OTHER_UNTAX_INC_AMT ,
A.P_HOPE_LL_CREDIT_AMT ,
A.P_YR_SEPARATION_AMT ,
A.P_YR_DIVORCE_AMT ,
A.P_EXP_FATHER_INC_AMT ,
A.P_EXP_MOTHER_INC_AMT ,
A.P_EXP_OTHER_TAX_INC_AMT ,
A.P_EXP_OTHER_UNTAX_INC_AMT ,
A.LINE_2_RELATION_TYPE ,
A.LINE_2_ATTEND_COLLEGE_TYPE ,
A.LINE_3_RELATION_TYPE ,
A.LINE_3_ATTEND_COLLEGE_TYPE ,
A.LINE_4_RELATION_TYPE ,
A.LINE_4_ATTEND_COLLEGE_TYPE ,
A.LINE_5_RELATION_TYPE ,
A.LINE_5_ATTEND_COLLEGE_TYPE ,
A.LINE_6_RELATION_TYPE ,
A.LINE_6_ATTEND_COLLEGE_TYPE ,
A.LINE_7_RELATION_TYPE ,
A.LINE_7_ATTEND_COLLEGE_TYPE ,
A.LINE_8_RELATION_TYPE ,
A.LINE_8_ATTEND_COLLEGE_TYPE ,
A.P_AGE_FATHER_NUM ,
A.P_AGE_MOTHER_NUM ,
A.P_DIV_SEP_FLAG ,
A.B_CONT_NON_CUSTODIAL_PAR_TXT ,
A.COLLEGE_2_TYPE ,
A.COLLEGE_3_TYPE ,
A.COLLEGE_4_TYPE ,
A.COLLEGE_5_TYPE ,
A.COLLEGE_6_TYPE ,
A.COLLEGE_7_TYPE ,
A.COLLEGE_8_TYPE ,
A.SCHOOL_1_CD ,
A.HOUSING_1_TYPE ,
A.SCHOOL_2_CD ,
A.HOUSING_2_TYPE ,
A.SCHOOL_3_CD ,
A.HOUSING_3_TYPE ,
A.SCHOOL_4_CD ,
A.HOUSING_4_TYPE ,
A.SCHOOL_5_CD ,
A.HOUSING_5_TYPE ,
A.SCHOOL_6_CD ,
A.HOUSING_6_TYPE ,
A.SCHOOL_7_CD ,
A.HOUSING_7_TYPE ,
A.SCHOOL_8_CD ,
A.HOUSING_8_TYPE ,
A.SCHOOL_9_CD ,
A.HOUSING_9_TYPE ,
A.SCHOOL_10_CD ,
A.HOUSING_10_TYPE ,
A.ADDITIONAL_SCHOOL_1_CD ,
A.ADDITIONAL_SCHOOL_2_CD ,
A.ADDITIONAL_SCHOOL_3_CD ,
A.ADDITIONAL_SCHOOL_4_CD ,
A.ADDITIONAL_SCHOOL_5_CD ,
A.ADDITIONAL_SCHOOL_6_CD ,
A.ADDITIONAL_SCHOOL_7_CD ,
A.ADDITIONAL_SCHOOL_8_CD ,
A.ADDITIONAL_SCHOOL_9_CD ,
A.ADDITIONAL_SCHOOL_10_CD ,
A.EXPLANATION_SPEC_CIRCUM_FLAG ,
A.SIGNATURE_STUDENT_FLAG ,
A.SIGNATURE_SPOUSE_FLAG ,
A.SIGNATURE_FATHER_FLAG ,
A.SIGNATURE_MOTHER_FLAG ,
A.MONTH_DAY_COMPLETED ,
A.YEAR_COMPLETED_FLAG ,
A.AGE_LINE_2_NUM ,
A.AGE_LINE_3_NUM ,
A.AGE_LINE_4_NUM ,
A.AGE_LINE_5_NUM ,
A.AGE_LINE_6_NUM ,
A.AGE_LINE_7_NUM ,
A.AGE_LINE_8_NUM ,
A.A_ONLINE_SIGNATURE_FLAG ,
A.QUESTION_1_NUMBER_TXT ,
A.QUESTION_1_SIZE_NUM ,
A.QUESTION_1_ANSWER_TXT ,
A.QUESTION_2_NUMBER_TXT ,
A.QUESTION_2_SIZE_NUM ,
A.QUESTION_2_ANSWER_TXT ,
A.QUESTION_3_NUMBER_TXT ,
A.QUESTION_3_SIZE_NUM ,
A.QUESTION_3_ANSWER_TXT ,
A.QUESTION_4_NUMBER_TXT ,
A.QUESTION_4_SIZE_NUM ,
A.QUESTION_4_ANSWER_TXT ,
A.QUESTION_5_NUMBER_TXT ,
A.QUESTION_5_SIZE_NUM ,
A.QUESTION_5_ANSWER_TXT ,
A.QUESTION_6_NUMBER_TXT ,
A.QUESTION_6_SIZE_NUM ,
A.QUESTION_6_ANSWER_TXT ,
A.QUESTION_7_NUMBER_TXT ,
A.QUESTION_7_SIZE_NUM ,
A.QUESTION_7_ANSWER_TXT ,
A.QUESTION_8_NUMBER_TXT ,
A.QUESTION_8_SIZE_NUM ,
A.QUESTION_8_ANSWER_TXT ,
A.QUESTION_9_NUMBER_TXT ,
A.QUESTION_9_SIZE_NUM ,
A.QUESTION_9_ANSWER_TXT ,
A.QUESTION_10_NUMBER_TXT ,
A.QUESTION_10_SIZE_NUM ,
A.QUESTION_10_ANSWER_TXT ,
A.QUESTION_11_NUMBER_TXT ,
A.QUESTION_11_SIZE_NUM ,
A.QUESTION_11_ANSWER_TXT ,
A.QUESTION_12_NUMBER_TXT ,
A.QUESTION_12_SIZE_NUM ,
A.QUESTION_12_ANSWER_TXT ,
A.QUESTION_13_NUMBER_TXT ,
A.QUESTION_13_SIZE_NUM ,
A.QUESTION_13_ANSWER_TXT ,
A.QUESTION_14_NUMBER_TXT ,
A.QUESTION_14_SIZE_NUM ,
A.QUESTION_14_ANSWER_TXT ,
A.QUESTION_15_NUMBER_TXT ,
A.QUESTION_15_SIZE_NUM ,
A.QUESTION_15_ANSWER_TXT ,
A.QUESTION_16_NUMBER_TXT ,
A.QUESTION_16_SIZE_NUM ,
A.QUESTION_16_ANSWER_TXT ,
A.QUESTION_17_NUMBER_TXT ,
A.QUESTION_17_SIZE_NUM ,
A.QUESTION_17_ANSWER_TXT ,
A.QUESTION_18_NUMBER_TXT ,
A.QUESTION_18_SIZE_NUM ,
A.QUESTION_18_ANSWER_TXT ,
A.QUESTION_19_NUMBER_TXT ,
A.QUESTION_19_SIZE_NUM ,
A.QUESTION_19_ANSWER_TXT ,
A.QUESTION_20_NUMBER_TXT ,
A.QUESTION_20_SIZE_NUM ,
A.QUESTION_20_ANSWER_TXT ,
A.QUESTION_21_NUMBER_TXT ,
A.QUESTION_21_SIZE_NUM ,
A.QUESTION_21_ANSWER_TXT ,
A.QUESTION_22_NUMBER_TXT ,
A.QUESTION_22_SIZE_NUM ,
A.QUESTION_22_ANSWER_TXT ,
A.QUESTION_23_NUMBER_TXT ,
A.QUESTION_23_SIZE_NUM ,
A.QUESTION_23_ANSWER_TXT ,
A.QUESTION_24_NUMBER_TXT ,
A.QUESTION_24_SIZE_NUM ,
A.QUESTION_24_ANSWER_TXT ,
A.QUESTION_25_NUMBER_TXT ,
A.QUESTION_25_SIZE_NUM ,
A.QUESTION_25_ANSWER_TXT ,
A.QUESTION_26_NUMBER_TXT ,
A.QUESTION_26_SIZE_NUM ,
A.QUESTION_26_ANSWER_TXT ,
A.QUESTION_27_NUMBER_TXT ,
A.QUESTION_27_SIZE_NUM ,
A.QUESTION_27_ANSWER_TXT ,
A.QUESTION_28_NUMBER_TXT ,
A.QUESTION_28_SIZE_NUM ,
A.QUESTION_28_ANSWER_TXT ,
A.QUESTION_29_NUMBER_TXT ,
A.QUESTION_29_SIZE_NUM ,
A.QUESTION_29_ANSWER_TXT ,
A.QUESTION_30_NUMBER_TXT ,
A.QUESTIONS_30_SIZE_NUM ,
A.QUESTION_30_ANSWER_TXT ,
A.R_S_EMAIL_ADDRESS_TXT ,
A.EPS_CD ,
A.COMP_CSS_DEPENDCY_STATUS_TYPE ,
A.STU_AGE_NUM ,
A.ASSUMED_STU_YR_IN_COLL_TYPE ,
A.COMP_STU_MARITAL_STATUS_TYPE ,
A.STU_FAMILY_MEMBERS_NUM ,
A.STU_FAM_MEMBERS_IN_COLLEGE_NUM ,
A.PAR_MARITAL_STATUS_TYPE ,
A.PAR_FAMILY_MEMBERS_NUM ,
A.PAR_TOTAL_IN_COLLEGE_NUM ,
A.PAR_PAR_IN_COLLEGE_NUM ,
A.PAR_OTHERS_IN_COLLEGE_NUM ,
A.PAR_AESA_NUM ,
A.PAR_CESA_NUM ,
A.STU_AESA_NUM ,
A.STU_CESA_NUM ,
A.IM_P_BAS_AGI_TAXABLE_AMT ,
A.IM_P_BAS_UNTX_INC_AND_BEN_AMT ,
A.IM_P_BAS_INC_ADJ_AMT ,
A.IM_P_BAS_TOTAL_INCOME_AMT ,
A.IM_P_BAS_US_INCOME_TAX_AMT ,
A.IM_P_BAS_ST_AND_OTHER_TAX_AMT ,
A.IM_P_BAS_FICA_TAX_AMT ,
A.IM_P_BAS_MED_DENTAL_AMT ,
A.IM_P_BAS_EMPLOYMENT_ALLOW_AMT ,
A.IM_P_BAS_ANNUAL_ED_SAVINGS_AMT ,
A.IM_P_BAS_INC_PROT_ALLOW_M_AMT ,
A.IM_P_BAS_TOTAL_INC_ALLOW_AMT ,
A.IM_P_BAS_CAL_AVAIL_INC_AMT ,
A.IM_P_BAS_AVAIL_INCOME_AMT ,
A.IM_P_BAS_TOTAL_CONT_INC_AMT ,
A.IM_P_BAS_CASH_BANK_ACCOUNT_AMT ,
A.IM_P_BAS_HOME_EQUITY_AMT ,
A.IM_P_BAS_OT_RL_EST_INV_EQ_AMT ,
A.IM_P_BAS_ADJ_BUS_FARM_WRTH_AMT ,
A.IM_P_BAS_ASS_SIBS_PRE_TUI_AMT ,
A.IM_P_BAS_NET_WORTH_AMT ,
A.IM_P_BAS_EMERG_RES_ALLOW_AMT ,
A.IM_P_BAS_CUM_ED_SAVINGS_AMT ,
A.IM_P_BAS_LOW_INC_ALLOW_AMT ,
A.IM_P_BAS_TOTAL_ASSET_ALLOW_AMT ,
A.IM_P_BAS_DISC_NET_WORTH_AMT ,
A.IM_P_BAS_TOTAL_CONT_ASSET_AMT ,
A.IM_P_BAS_TOTAL_CONT_AMT ,
A.IM_P_BAS_NUM_IN_COLL_ADJ_AMT ,
A.IM_P_BAS_CONT_FOR_STU_AMT ,
A.IM_P_BAS_CONT_FROM_INCOME_AMT ,
A.IM_P_BAS_CONT_FROM_ASSETS_AMT ,
A.IM_P_OPT_AGI_TAX_INCOME_AMT ,
A.IM_P_OPT_UNTX_INC_BEN_AMT ,
A.IM_P_OPT_INC_ADJ_AMT ,
A.IM_P_OPT_TOTAL_INCOME_AMT ,
A.IM_P_OPT_US_INCOME_TAX_AMT ,
A.IM_P_OPT_ST_AND_OTHER_TAX_AMT ,
A.IM_P_OPT_FICA_TAX_AMT ,
A.IM_P_OPT_MED_DENTAL_AMT ,
A.IM_P_OPT_ELEM_SEC_TUIT_AMT ,
A.IM_P_OPT_EMPLOYMENT_ALLOW_AMT ,
A.IM_P_OPT_ANNUAL_ED_SAVING_AMT ,
A.IM_P_OPT_INC_PROT_ALLOW_M_AMT ,
A.IM_P_OPT_TOTAL_INC_ALLOW_AMT ,
A.IM_P_OPT_CAL_AVAIL_INC_AMT ,
A.IM_P_OPT_AVAIL_INCOME_AMT ,
A.IM_P_OPT_TOTAL_CONT_INC_AMT ,
A.IM_P_OPT_CASH_BANK_ACCNT_AMT ,
A.IM_P_OPT_HOME_EQUITY_AMT ,
A.IM_P_OPT_OT_RL_EST_INV_EQ_AMT ,
A.IM_P_OPT_ADJ_FARM_WORTH_AMT ,
A.IM_P_OPT_ASS_SIBS_PRE_T_AMT ,
A.IM_P_OPT_NET_WORTH_AMT ,
A.IM_P_OPT_EMERG_RES_ALLOW_AMT ,
A.IM_P_OPT_CUM_ED_SAVINGS_AMT ,
A.IM_P_OPT_LOW_INC_ALLOW_AMT ,
A.IM_P_OPT_TOTAL_ASSET_ALLOW_AMT ,
A.IM_P_OPT_DISC_NET_WORTH_AMT ,
A.IM_P_OPT_TOTAL_CONT_ASSET_AMT ,
A.IM_P_OPT_TOTAL_CONT_AMT ,
A.IM_P_OPT_NUM_IN_COLL_ADJ_AMT ,
A.IM_P_OPT_CONT_FOR_STU_AMT ,
A.IM_P_OPT_CONT_FROM_INCOME_AMT ,
A.IM_P_OPT_CONT_FROM_ASSETS_AMT ,
A.FM_P_ANALYSIS_TYPE ,
A.FM_P_AGI_TAXABLE_INCOME_AMT ,
A.FM_P_UNTX_INC_AND_BEN_AMT ,
A.FM_P_INC_ADJ_AMT ,
A.FM_P_TOTAL_INCOME_AMT ,
A.FM_P_US_INCOME_TAX_AMT ,
A.FM_P_STATE_AND_OTHER_TAX_AMT ,
A.FM_P_FICA_TAX_AMT ,
A.FM_P_EMPLOYMENT_ALLOW_AMT ,
A.FM_P_INCOME_PROT_ALLOW_AMT ,
A.FM_P_TOTAL_ALLOW_AMT ,
A.FM_P_AVAIL_INCOME_AMT ,
A.FM_P_CASH_BANK_ACCOUNTS_AMT ,
A.FM_P_OT_RL_EST_INV_EQ_AMT ,
A.FM_P_ADJ_FARM_NET_WORTH_AMT ,
A.FM_P_NET_WORTH_AMT ,
A.FM_P_ASSET_PROT_ALLOW_AMT ,
A.FM_P_DISC_NET_WORTH_AMT ,
A.FM_P_TOTAL_CONTRIBUTION_AMT ,
A.FM_P_NUM_IN_COLL_NUM ,
A.FM_P_CONT_FOR_STU_AMT ,
A.FM_P_CONT_FROM_INCOME_AMT ,
A.FM_P_CONT_FROM_ASSETS_AMT ,
A.IM_S_BAS_AGI_TAX_INCOME_AMT ,
A.IM_S_BAS_UNTX_INC_AND_BEN_AMT ,
A.IM_S_BAS_INC_ADJ_AMT ,
A.IM_S_BAS_TOTAL_INCOME_AMT ,
A.IM_S_BAS_US_INCOME_TAX_AMT ,
A.IM_S_BAS_ST_AND_OTH_TAX_AMT ,
A.IM_S_BAS_FICA_TAX_AMT ,
A.IM_S_BAS_MED_DENTAL_AMT ,
A.IM_S_BAS_EMPLOYMENT_ALLOW_AMT ,
A.IM_S_BAS_ANNUAL_ED_SAVINGS_AMT ,
A.IM_S_BAS_INC_PROT_ALLOW_M_AMT ,
A.IM_S_BAS_TOTAL_INC_ALLOW_AMT ,
A.IM_S_BAS_CAL_AVAIL_INCOME_AMT ,
A.IM_S_BAS_AVAIL_INCOME_AMT ,
A.IM_S_BAS_TOTAL_CONT_INC_AMT ,
A.IM_S_BAS_CASH_BANK_ACCOUNT_AMT ,
A.IM_S_BAS_HOME_EQUITY_AMT ,
A.IM_S_BAS_OT_RL_EST_INV_EQ_AMT ,
A.IM_S_BAS_ADJ_FARM_WORTH_AMT ,
A.IM_S_BAS_TRUSTS_AMT ,
A.IM_S_BAS_NET_WORTH_AMT ,
A.IM_S_BAS_EMERG_RES_ALLOW_AMT ,
A.IM_S_BAS_CUM_ED_SAVINGS_AMT ,
A.IM_S_BAS_TOTAL_ASSET_ALLOW_AMT ,
A.IM_S_BAS_DISC_NET_WORTH_AMT ,
A.IM_S_BAS_TOTAL_CONT_ASSET_AMT ,
A.IM_S_BAS_TOTAL_CONT_AMT ,
A.IM_S_BAS_NUM_IN_COLL_ADJ_AMT ,
A.IM_S_BAS_CONT_FOR_STU_AMT ,
A.IM_S_BAS_CONT_FROM_INCOME_AMT ,
A.IM_S_BAS_CONT_FROM_ASSETS_AMT ,
A.IM_S_EST_AGI_TAX_INCOME_AMT ,
A.IM_S_EST_UNTX_INC_AND_BEN_AMT ,
A.IM_S_EST_INC_ADJ_AMT ,
A.IM_S_EST_TOTAL_INCOME_AMT ,
A.IM_S_EST_US_INCOME_TAX_AMT ,
A.IM_S_EST_ST_AND_OTH_TAX_AMT ,
A.IM_S_EST_FICA_TAX_AMT ,
A.IM_S_EST_MED_DENTAL_AMT ,
A.IM_S_EST_EMPLOYMENT_ALLOW_AMT ,
A.IM_S_EST_ANNUAL_ED_SAVINGS_AMT ,
A.IM_S_EST_INC_PROT_ALLOW_M_AMT ,
A.IM_S_EST_TOTAL_INC_ALLOW_AMT ,
A.IM_S_EST_CAL_AVAIL_INCOME_AMT ,
A.IM_S_EST_AVAIL_INCOME_AMT ,
A.IM_S_EST_TOTAL_CONT_INC_AMT ,
A.IM_S_EST_CASH_BANK_ACCOUNT_AMT ,
A.IM_S_EST_HOME_EQUITY_AMT ,
A.IM_S_EST_OT_RL_EST_INV_EQU_AMT ,
A.IM_S_EST_ADJ_FARM_WORTH_AMT ,
A.IM_S_EST_EST_TRUSTS_AMT ,
A.IM_S_EST_NET_WORTH_AMT ,
A.IM_S_EST_EMERG_RES_ALLOW_AMT ,
A.IM_S_EST_CUM_ED_SAVINGS_AMT ,
A.IM_S_EST_TOTAL_ASSET_ALLOW_AMT ,
A.IM_S_EST_DISC_NET_WORTH_AMT ,
A.IM_S_EST_TOTAL_CONT_ASSET_AMT ,
A.IM_S_EST_TOTAL_CONT_AMT ,
A.IM_S_EST_NUM_IN_COLL_ADJ_AMT ,
A.IM_S_EST_CONT_FOR_STU_AMT ,
A.IM_S_EST_CONT_FROM_INCOME_AMT ,
A.IM_S_EST_CONT_FROM_ASSETS_AMT ,
A.IM_S_OPT_AGI_TAX_INCOME_AMT ,
A.IM_S_OPT_UNTX_INC_AND_BEN_AMT ,
A.IM_S_OPT_INC_ADJ_AMT ,
A.IM_S_OPT_TOTAL_INCOME_AMT ,
A.IM_S_OPT_US_INCOME_TAX_AMT ,
A.IM_S_OPT_STATE_OTH_TAXES_AMT ,
A.IM_S_OPT_FICA_TAX_AMT ,
A.IM_S_OPT_MED_DENTAL_AMT ,
A.IM_S_OPT_EMPLOYMENT_ALLOW_AMT ,
A.IM_S_OPT_ANNUAL_ED_SAVINGS_AMT ,
A.IM_S_OPT_INC_PROT_ALLOW_M_AMT ,
A.IM_S_OPT_TOTAL_INC_ALLOW_AMT ,
A.IM_S_OPT_CAL_AVAIL_INCOME_AMT ,
A.IM_S_OPT_AVAIL_INCOME_AMT ,
A.IM_S_OPT_TOTAL_CONT_INC_AMT ,
A.IM_S_OPT_CASH_BANK_ACCOUNT_AMT ,
A.IM_S_OPT_IRA_KEOGH_ACCOUNT_AMT ,
A.IM_S_OPT_HOME_EQUITY_AMT ,
A.IM_S_OPT_OT_RL_EST_INV_EQ_AMT ,
A.IM_S_OPT_ADJ_BUS_FRM_WORTH_AMT ,
A.IM_S_OPT_TRUSTS_AMT ,
A.IM_S_OPT_NET_WORTH_AMT ,
A.IM_S_OPT_EMERG_RES_ALLOW_AMT ,
A.IM_S_OPT_CUM_ED_SAVINGS_AMT ,
A.IM_S_OPT_TOTAL_ASSET_ALLOW_AMT ,
A.IM_S_OPT_DISC_NET_WORTH_AMT ,
A.IM_S_OPT_TOTAL_CONT_ASSET_AMT ,
A.IM_S_OPT_TOTAL_CONT_AMT ,
A.IM_S_OPT_NUM_IN_COLL_ADJ_AMT ,
A.IM_S_OPT_CONT_FOR_STU_AMT ,
A.IM_S_OPT_CONT_FROM_INCOME_AMT ,
A.IM_S_OPT_CONT_FROM_ASSETS_AMT ,
A.FM_S_ANALYSIS_TYPE ,
A.FM_S_AGI_TAXABLE_INCOME_AMT ,
A.FM_S_UNTX_INC_AND_BEN_AMT ,
A.FM_S_INC_ADJ_AMT ,
A.FM_S_TOTAL_INCOME_AMT ,
A.FM_S_US_INCOME_TAX_AMT ,
A.FM_S_STATE_AND_OTH_TAXES_AMT ,
A.FM_S_FICA_TAX_AMT ,
A.FM_S_EMPLOYMENT_ALLOW_AMT ,
A.FM_S_INCOME_PROT_ALLOW_AMT ,
A.FM_S_TOTAL_ALLOW_AMT ,
A.FM_S_CAL_AVAIL_INCOME_AMT ,
A.FM_S_AVAIL_INCOME_AMT ,
A.FM_S_CASH_BANK_ACCOUNTS_AMT ,
A.FM_S_OT_RL_EST_INV_EQUITY_AMT ,
A.FM_S_ADJ_BUS_FARM_WORTH_AMT ,
A.FM_S_TRUSTS_AMT ,
A.FM_S_NET_WORTH_AMT ,
A.FM_S_ASSET_PROT_ALLOW_AMT ,
A.FM_S_DISC_NET_WORTH_AMT ,
A.FM_S_TOTAL_CONT_AMT ,
A.FM_S_NUM_IN_COLL_NUM ,
A.FM_S_CONT_FOR_STU_AMT ,
A.FM_S_CONT_FROM_INCOME_AMT ,
A.FM_S_CONT_FROM_ASSETS_AMT ,
A.IM_INST_RESIDENT_FLAG ,
A.INSTITUTIONAL_1_BUDGET_NAME ,
A.IM_INST_1_BUDGET_DURATION_NUM ,
A.IM_INST_1_TUITION_FEES_AMT ,
A.IM_INST_1_BOOKS_SUPPLIES_AMT ,
A.IM_INST_1_LIVING_EXPENSES_AMT ,
A.IM_INST_1_TOT_EXPENSES_AMT ,
A.IM_INST_1_TOT_STU_CONT_AMT ,
A.IM_INST_1_TOT_PAR_CONT_AMT ,
A.IM_INST_1_TOT_FAMILY_CONT_AMT ,
A.IM_INST_1_VA_BENEFITS_AMT ,
A.IM_INST_1_OT_CONT_AMT ,
A.IM_INST_1_EST_FINAN_NEED_AMT ,
A.INSTITUTIONAL_2_BUDGET_TXT ,
A.IM_INST_2_BUDGET_DURATION_NUM ,
A.IM_INST_2_TUITION_FEES_AMT ,
A.IM_INST_2_BOOKS_SUPPLIES_AMT ,
A.IM_INST_2_LIVING_EXPENSES_AMT ,
A.IM_INST_2_TOT_EXPENSES_AMT ,
A.IM_INST_2_TOT_STU_CONT_AMT ,
A.IM_INST_2_TOT_PAR_CONT_AMT ,
A.IM_INST_2_TOT_FAMILY_CONT_AMT ,
A.IM_INST_2_VA_BENEFITS_AMT ,
A.IM_INST_2_EST_FINAN_NEED_AMT ,
A.INSTITUTIONAL_3_BUDGET_TXT ,
A.IM_INST_3_BUDGET_DURATION_NUM ,
A.IM_INST_3_TUITION_FEES_AMT ,
A.IM_INST_3_BOOKS_SUPPLIES_AMT ,
A.IM_INST_3_LIVING_EXPENSES_AMT ,
A.IM_INST_3_TOT_EXPENSES_AMT ,
A.IM_INST_3_TOT_STU_CONT_AMT,
A.IM_INST_3_TOT_PAR_CONT_AMT ,
A.IM_INST_3_TOT_FAMILY_CONT_AMT ,
A.IM_INST_3_VA_BENEFITS_AMT ,
A.IM_INST_3_EST_FINAN_NEED_AMT ,
A.FM_INST_1_FEDERAL_EFC_TXT ,
A.FM_INST_1_VA_BENEFITS_TXT ,
A.FM_INST_1_FED_ELIGIBILITY_TXT ,
A.FM_INST_1_PELL_TXT ,
A.OPTION_PAR_LOSS_ALLOW_FLAG ,
A.OPTION_PAR_TUITION_FLAG ,
A.OPTION_PAR_HOME_TYPE ,
A.OPTION_PAR_HOME_VALUE_TXT ,
A.OPTION_PAR_HOME_DEBT_TXT ,
A.OPTION_STU_IRA_KEOGH_FLAG ,
A.OPTION_STU_HOME_TYPE ,
A.OPTION_STU_HOME_VALUE_TXT ,
A.OPTION_STU_HOME_DEBT_TXT ,
A.OPTION_STU_SUM_AY_INC_FLAG ,
A.OPTION_PAR_HOPE_LL_CREDIT_FLAG ,
A.OPTION_STU_HOPE_LL_CREDIT_FLAG ,
A.IM_PARENT_1_8_MONTHS_BAS_TXT ,
A.IM_P_MORE_THAN_9_MTH_BA_TXT ,
A.IM_PARENT_1_8_MONTHS_OPT_TXT ,
A.IM_P_MORE_THAN_9_MTH_OP_TXT ,
A.FNAR_MESSAGE_1_FLAG ,
A.FNAR_MESSAGE_2_FLAG ,
A.FNAR_MESSAGE_3_FLAG ,
A.FNAR_MESSAGE_4_FLAG ,
A.FNAR_MESSAGE_5_FLAG ,
A.FNAR_MESSAGE_6_FLAG ,
A.FNAR_MESSAGE_7_FLAG ,
A.FNAR_MESSAGE_8_FLAG ,
A.FNAR_MESSAGE_9_FLAG ,
A.FNAR_MESSAGE_10_FLAG ,
A.FNAR_MESSAGE_11_FLAG ,
A.FNAR_MESSAGE_12_FLAG ,
A.FNAR_MESSAGE_13_FLAG ,
A.FNAR_MESSAGE_20_FLAG ,
A.FNAR_MESSAGE_21_FLAG ,
A.FNAR_MESSAGE_22_FLAG ,
A.FNAR_MESSAGE_23_FLAG ,
A.FNAR_MESSAGE_24_FLAG ,
A.FNAR_MESSAGE_25_FLAG ,
A.FNAR_MESSAGE_26_FLAG ,
A.FNAR_MESSAGE_27_FLAG ,
A.FNAR_MESSAGE_30_FLAG ,
A.FNAR_MESSAGE_31_FLAG ,
A.FNAR_MESSAGE_32_FLAG ,
A.FNAR_MESSAGE_33_FLAG ,
A.FNAR_MESSAGE_34_FLAG ,
A.FNAR_MESSAGE_35_FLAG ,
A.FNAR_MESSAGE_36_FLAG ,
A.FNAR_MESSAGE_37_FLAG ,
A.FNAR_MESSAGE_38_FLAG ,
A.FNAR_MESSAGE_39_FLAG ,
A.FNAR_MESSAGE_45_FLAG ,
A.FNAR_MESSAGE_46_FLAG ,
A.FNAR_MESSAGE_47_FLAG ,
A.FNAR_MESSAGE_48_FLAG ,
A.FNAR_MESSAGE_50_FLAG ,
A.FNAR_MESSAGE_51_FLAG ,
A.FNAR_MESSAGE_52_FLAG ,
A.FNAR_MESSAGE_53_FLAG ,
A.FNAR_MESSAGE_56_FLAG ,
A.FNAR_MESSAGE_57_FLAG ,
A.FNAR_MESSAGE_58_FLAG ,
A.FNAR_MESSAGE_59_FLAG ,
A.FNAR_MESSAGE_60_FLAG ,
A.FNAR_MESSAGE_61_FLAG ,
A.FNAR_MESSAGE_62_FLAG ,
A.FNAR_MESSAGE_63_FLAG ,
A.FNAR_MESSAGE_64_FLAG ,
A.FNAR_MESSAGE_65_FLAG ,
A.FNAR_MESSAGE_71_FLAG ,
A.FNAR_MESSAGE_72_FLAG ,
A.FNAR_MESSAGE_73_FLAG ,
A.FNAR_MESSAGE_74_FLAG ,
A.FNAR_MESSAGE_75_FLAG ,
A.FNAR_MESSAGE_76_FLAG ,
A.FNAR_MESSAGE_77_FLAG ,
A.FNAR_MESSAGE_78_FLAG ,
A.FNAR_MESG_10_STU_FAM_MEM_NUM ,
A.FNAR_MESG_11_STU_NO_IN_COL_NUM ,
A.FNAR_MESG_24_STU_AVAIL_INC_AMT ,
A.FNAR_MESG_26_STU_TAXES_AMT ,
A.FNAR_MESG_33_STU_HOME_VAL_AMT ,
A.FNAR_MESG_34_STU_HOME_VAL_AMT ,
A.FNAR_MESG_34_STU_HOME_EQU_AMT ,
A.FNAR_MESG_35_STU_HOME_VAL_AMT ,
A.FNAR_MESG_35_STU_HOME_EQU_AMT ,
A.FNAR_MESG_36_STU_HOME_EQU_AMT ,
A.FNAR_MESG_48_PAR_FAM_MEM_NUM ,
A.FNAR_MESG_49_PAR_NO_IN_COL_NUM ,
A.FNAR_MESG_56_PAR_AGI_AMT ,
A.FNAR_MESG_62_PAR_TAXES_AMT ,
A.FNAR_MESG_73_PAR_HOME_VAL_AMT ,
A.FNAR_MESG_74_PAR_HOME_VAL_AMT ,
A.FNAR_MESG_74_PAR_HOME_EQU_AMT ,
A.FNAR_MESG_75_PAR_HOME_VAL_AMT ,
A.FNAR_MESG_75_PAR_HOME_EQU_AMT ,
A.FNAR_MESG_76_PAR_HOME_EQU_AMT ,
A.ASSUMPTION_MESSAGE_1_FLAG ,
A.ASSUMPTION_MESSAGE_2_FLAG ,
A.ASSUMPTION_MESSAGE_3_FLAG ,
A.ASSUMPTION_MESSAGE_4_FLAG ,
A.ASSUMPTION_MESSAGE_5_FLAG ,
A.ASSUMPTION_MESSAGE_6_FLAG ,
A.FNAR_MESSAGE_49_FLAG ,
A.FNAR_MESSAGE_55_FLAG ,
A.OPTION_PAR_COLA_ADJ_FLAG,
A.OPTION_PAR_STU_FA_ASSETS_FLAG,
A.OPTION_PAR_IPT_ASSETS_FLAG,
A.OPTION_STU_IPT_ASSETS_FLAG,
A.OPTION_PAR_COLA_ADJ_VALUE,
A.P_SOC_SEC_BEN_STUDENT_AMT,
A.P_TUIT_FEE_DEDUCT_AMT,
A.OPTION_IND_STU_IPT_ASSETS_FLAG,
A.stu_lives_with_num,
A.stu_most_support_from_num,
A.location_computer_num,
A.cust_parent_cont_adj_num,
A.custodial_parent_num,
A.cust_par_base_prcnt_inc_amt,
A.cust_par_base_cont_inc_amt,
A.cust_par_base_cont_ast_amt,
A.cust_par_base_tot_cont_amt,
A.cust_par_opt_prcnt_inc_amt,
A.cust_par_opt_cont_inc_amt,
A.cust_par_opt_cont_ast_amt,
A.cust_par_opt_tot_cont_amt,
A.parents_email_txt,
A.parent_1_birth_date,
A.parent_2_birth_date
FROM
IGF_AP_LI_CSS_INTS A
WHERE
A.BATCH_NUM = p_batch_id AND
A.IMPORT_STATUS_TYPE IN ('U','R') ;
SELECT
ROWID row_id, A.*
FROM IGF_AP_CSS_INTERFACE_ALL A
WHERE A.RECORD_STATUS = 'LEGACY' AND
TO_NUMBER(A.ACADEMIC_YEAR) = p_award_year;
PROCEDURE css_insert_row( c_int_data_rec IN c_int_data%ROWTYPE,
p_base_id IN NUMBER,
p_cssp_id OUT NOCOPY NUMBER) AS
/*
|| Created By : rasahoo
|| Created On : 03-June-2003
|| Purpose : insert into the isir matched table
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
l_rowid VARCHAR2(30);
igf_ap_css_profile_pkg.insert_row(
x_mode => 'R',
x_rowid => l_rowid,
x_cssp_id => l_cssp_id,
x_base_id => p_base_id,
x_system_record_type => 'ORIGINAL',
x_active_profile => 'N',
x_college_code =>c_int_data_rec.college_cd ,
x_academic_year =>c_int_data_rec.academic_year_txt ,
x_stu_record_type =>c_int_data_rec.stu_record_type ,
x_css_id_number =>c_int_data_rec.css_id_number_txt ,
x_registration_receipt_date =>TO_CHAR(c_int_data_rec.registration_receipt_date,'MMDDYYYY') , -- NULL, --
x_registration_type =>c_int_data_rec.registration_type , --NULL, --
x_application_receipt_date =>TO_CHAR(c_int_data_rec.application_receipt_date,'MMDDYYYY') , --NULL
x_application_type =>c_int_data_rec.application_type ,
x_original_fnar_compute =>c_int_data_rec.original_fnar_compute_txt ,
x_revision_fnar_compute_date =>TO_CHAR(c_int_data_rec.revision_fnar_compute_date,'MMDDYYYY') , --NULL, --
x_electronic_extract_date =>TO_CHAR(c_int_data_rec.electronic_extract_date,'MMDDYYYY') , --NULL, --
x_institutional_reporting_type =>c_int_data_rec.instit_reporting_type ,
x_asr_receipt_date =>TO_CHAR(c_int_data_rec.asr_receipt_date,'MMDDYYYY') ,
x_last_name =>c_int_data_rec.last_name ,
x_first_name =>c_int_data_rec.first_name ,
x_middle_initial =>c_int_data_rec.middle_initial_txt ,
x_address_number_and_street =>c_int_data_rec.address_number_and_street_txt ,
x_city =>c_int_data_rec.city_txt ,
x_state_mailing =>c_int_data_rec.state_mailing_txt ,
x_zip_code =>c_int_data_rec.zip_cd ,
x_s_telephone_number =>c_int_data_rec.s_telephone_number_txt ,
x_s_title =>c_int_data_rec.s_title_type ,
x_date_of_birth =>c_int_data_rec.birth_date ,
x_social_security_number =>convert_to_number(c_int_data_rec.social_security_num) ,
x_state_legal_residence =>c_int_data_rec.state_legal_residence_txt ,
x_foreign_address_indicator =>c_int_data_rec.foreign_address_flag ,
x_foreign_postal_code =>c_int_data_rec.foreign_postal_cd ,
x_country =>c_int_data_rec.country_cd ,
x_financial_aid_status =>c_int_data_rec.financial_aid_status_type ,
x_year_in_college =>c_int_data_rec.year_in_college_type ,
x_marital_status =>c_int_data_rec.marital_status_flag ,
x_ward_court =>c_int_data_rec.ward_court_flag ,
x_legal_dependents_other =>c_int_data_rec.legal_dependents_other_flag ,
x_household_size =>c_int_data_rec.household_size_num ,
x_number_in_college =>c_int_data_rec.number_in_college_num ,
x_citizenship_status =>c_int_data_rec.citizenship_status_type ,
x_citizenship_country =>c_int_data_rec.citizenship_country_cd ,
x_visa_classification =>c_int_data_rec.visa_classification_type ,
x_tax_figures =>c_int_data_rec.tax_figures_type ,
x_number_exemptions =>convert_to_number(c_int_data_rec.number_exemptions_txt) ,
x_adjusted_gross_inc =>c_int_data_rec.adjusted_gross_amt ,
x_us_tax_paid =>c_int_data_rec.us_tax_paid_amt ,
x_itemized_deductions =>c_int_data_rec.itemized_deductions_amt ,
x_stu_income_work =>c_int_data_rec.stu_income_work_amt ,
x_spouse_income_work =>c_int_data_rec.spouse_income_work_amt ,
x_divid_int_inc =>c_int_data_rec.divid_int_income_amt ,
x_soc_sec_benefits =>c_int_data_rec.soc_sec_benefits_amt ,
x_welfare_tanf =>c_int_data_rec.welfare_tanf_amt ,
x_child_supp_rcvd =>c_int_data_rec.child_supp_rcvd_amt ,
x_earned_income_credit =>c_int_data_rec.earned_income_credit_amt ,
x_other_untax_income =>c_int_data_rec.other_untax_income_amt ,
x_tax_stu_aid =>c_int_data_rec.tax_stu_aid_amt ,
x_cash_sav_check =>c_int_data_rec.cash_sav_check_amt ,
x_ira_keogh =>c_int_data_rec.ira_keogh_amt ,
x_invest_value =>c_int_data_rec.invest_value_amt ,
x_invest_debt =>c_int_data_rec.invest_debt_amt ,
x_home_value =>c_int_data_rec.home_value_amt ,
x_home_debt =>c_int_data_rec.home_debt_amt ,
x_oth_real_value =>c_int_data_rec.oth_real_value_amt ,
x_oth_real_debt =>c_int_data_rec.oth_real_debt_amt ,
x_bus_farm_value =>c_int_data_rec.bus_farm_value_amt ,
x_bus_farm_debt =>c_int_data_rec.bus_farm_debt_amt ,
x_live_on_farm =>c_int_data_rec.live_on_farm_flag ,
x_home_purch_price =>c_int_data_rec.home_purch_price_amt ,
x_hope_ll_credit =>c_int_data_rec.hope_ll_credit_amt ,
x_home_purch_year =>c_int_data_rec.home_purch_year_txt ,
x_trust_amount =>convert_to_number(c_int_data_rec.trust_amount_txt) ,
x_trust_avail =>c_int_data_rec.trust_avail_flag ,
x_trust_estab =>c_int_data_rec.trust_estab_flag ,
x_child_support_paid =>convert_to_number(c_int_data_rec.child_support_paid_txt) ,
x_med_dent_expenses =>convert_to_number(c_int_data_rec.med_dent_expenses_txt) ,
x_vet_us =>c_int_data_rec.vet_us_flag ,
x_vet_ben_amount =>c_int_data_rec.vet_ben_amt ,
x_vet_ben_months =>c_int_data_rec.vet_ben_months_num ,
x_stu_summer_wages =>c_int_data_rec.stu_summer_wages_amt ,
x_stu_school_yr_wages =>c_int_data_rec.stu_school_yr_wages_amt ,
x_spouse_summer_wages =>c_int_data_rec.spouse_summer_wages_amt ,
x_spouse_school_yr_wages =>c_int_data_rec.spouse_school_yr_wages_amt ,
x_summer_other_tax_inc =>c_int_data_rec.summer_other_tax_inc_amt ,
x_school_yr_other_tax_inc =>c_int_data_rec.school_yr_other_tax_inc_amt ,
x_summer_untax_inc =>c_int_data_rec.summer_untax_inc_amt ,
x_school_yr_untax_inc =>c_int_data_rec.school_yr_untax_inc_amt ,
x_grants_schol_etc =>c_int_data_rec.grants_schol_etc_amt ,
x_tuit_benefits =>c_int_data_rec.tuit_benefits_amt ,
x_cont_parents =>c_int_data_rec.cont_parents_amt ,
x_cont_relatives =>c_int_data_rec.cont_relatives_amt ,
x_p_siblings_pre_tuit =>c_int_data_rec.p_siblings_pre_tuit_amt ,
x_p_student_pre_tuit =>c_int_data_rec.p_student_pre_tuit_amt ,
x_p_household_size =>c_int_data_rec.p_household_size_num ,
x_p_number_in_college =>c_int_data_rec.p_in_college_num ,
x_p_parents_in_college =>c_int_data_rec.p_parents_in_college_num ,
x_p_marital_status =>c_int_data_rec.p_marital_status_type ,
x_p_state_legal_residence =>c_int_data_rec.p_state_legal_residence_cd ,
x_p_natural_par_status =>c_int_data_rec.p_natural_par_status_flag ,
x_p_child_supp_paid =>c_int_data_rec.p_child_supp_paid_amt ,
x_p_repay_ed_loans =>c_int_data_rec.p_repay_ed_loans_amt ,
x_p_med_dent_expenses =>c_int_data_rec.p_med_dent_expenses_amt ,
x_p_tuit_paid_amount =>c_int_data_rec.p_tuit_paid_amt ,
x_p_tuit_paid_number =>c_int_data_rec.p_tuit_paid_num ,
x_p_exp_child_supp_paid =>c_int_data_rec.p_exp_child_supp_paid_amt ,
x_p_exp_repay_ed_loans =>c_int_data_rec.p_exp_repay_ed_loans_amt ,
x_p_exp_med_dent_expenses =>c_int_data_rec.p_exp_med_dent_expenses_amt ,
x_p_exp_tuit_pd_amount =>c_int_data_rec.p_exp_tuit_pd_amt ,
x_p_exp_tuit_pd_number =>c_int_data_rec.p_exp_tuit_pd_num ,
x_p_cash_sav_check =>c_int_data_rec.p_cash_sav_check_amt ,
x_p_month_mortgage_pay =>c_int_data_rec.p_month_mortgage_pay_amt ,
x_p_invest_value =>c_int_data_rec.p_invest_value_amt ,
x_p_invest_debt =>c_int_data_rec.p_invest_debt_amt ,
x_p_home_value =>c_int_data_rec.p_home_value_amt ,
x_p_home_debt =>c_int_data_rec.p_home_debt_amt ,
x_p_home_purch_price =>c_int_data_rec.p_home_purch_price_amt ,
x_p_own_business_farm =>c_int_data_rec.p_own_business_farm_flag ,
x_p_business_value =>c_int_data_rec.p_business_value_amt ,
x_p_business_debt =>c_int_data_rec.p_business_debt_amt ,
x_p_farm_value =>c_int_data_rec.p_farm_value_amt ,
x_p_farm_debt =>c_int_data_rec.p_farm_debt_amt ,
x_p_live_on_farm =>c_int_data_rec.p_live_on_farm_num ,
x_p_oth_real_estate_value =>c_int_data_rec.p_oth_real_estate_value_amt ,
x_p_oth_real_estate_debt =>c_int_data_rec.p_oth_real_estate_debt_amt ,
x_p_oth_real_purch_price =>c_int_data_rec.p_oth_real_purch_price_amt ,
x_p_siblings_assets =>c_int_data_rec.p_siblings_assets_amt ,
x_p_home_purch_year =>c_int_data_rec.p_home_purch_year_txt ,
x_p_oth_real_purch_year =>c_int_data_rec.p_oth_real_purch_year_txt ,
x_p_prior_agi =>c_int_data_rec.p_prior_agi_amt ,
x_p_prior_us_tax_paid =>c_int_data_rec.p_prior_us_tax_paid_amt ,
x_p_prior_item_deductions =>c_int_data_rec.p_prior_item_deductions_amt ,
x_p_prior_other_untax_inc =>c_int_data_rec.p_prior_other_untax_inc_amt ,
x_p_tax_figures =>c_int_data_rec.p_tax_figures_num ,
x_p_number_exemptions =>c_int_data_rec.p_number_exemptions_num ,
x_p_adjusted_gross_inc =>c_int_data_rec.p_adjusted_gross_inc_amt ,
x_p_wages_sal_tips =>c_int_data_rec.p_wages_sal_tips_amt ,
x_p_interest_income =>c_int_data_rec.p_interest_income_amt ,
x_p_dividend_income =>c_int_data_rec.p_dividend_income_amt ,
x_p_net_inc_bus_farm =>c_int_data_rec.p_net_inc_bus_farm_amt ,
x_p_other_taxable_income =>c_int_data_rec.p_other_taxable_income_amt ,
x_p_adj_to_income =>c_int_data_rec.p_adj_to_income_amt ,
x_p_us_tax_paid =>c_int_data_rec.p_us_tax_paid_amt ,
x_p_itemized_deductions =>c_int_data_rec.p_itemized_deductions_amt ,
x_p_father_income_work =>c_int_data_rec.p_father_income_work_amt ,
x_p_mother_income_work =>c_int_data_rec.p_mother_income_work_amt ,
x_p_soc_sec_ben =>c_int_data_rec.p_soc_sec_ben_amt ,
x_p_welfare_tanf =>c_int_data_rec.p_welfare_tanf_amt ,
x_p_child_supp_rcvd =>c_int_data_rec.p_child_supp_rcvd_amt ,
x_p_ded_ira_keogh =>c_int_data_rec.p_ded_ira_keogh_amt ,
x_p_tax_defer_pens_savs =>c_int_data_rec.p_tax_defer_pens_savs_amt ,
x_p_dep_care_med_spending =>c_int_data_rec.p_dep_care_med_spending_amt ,
x_p_earned_income_credit =>c_int_data_rec.p_earned_income_credit_amt ,
x_p_living_allow =>c_int_data_rec.p_living_allow_amt ,
x_p_tax_exmpt_int =>c_int_data_rec.p_tax_exmpt_int_amt ,
x_p_foreign_inc_excl =>c_int_data_rec.p_foreign_inc_excl_amt ,
x_p_other_untax_inc =>c_int_data_rec.p_other_untax_inc_amt ,
x_p_hope_ll_credit =>c_int_data_rec.p_hope_ll_credit_amt ,
x_p_yr_separation =>c_int_data_rec.p_yr_separation_amt ,
x_p_yr_divorce =>c_int_data_rec.p_yr_divorce_amt ,
x_p_exp_father_inc =>c_int_data_rec.p_exp_father_inc_amt ,
x_p_exp_mother_inc =>c_int_data_rec.p_exp_mother_inc_amt ,
x_p_exp_other_tax_inc =>c_int_data_rec.p_exp_other_tax_inc_amt ,
x_p_exp_other_untax_inc =>c_int_data_rec.p_exp_other_untax_inc_amt ,
x_line_2_relation =>c_int_data_rec.line_2_relation_type ,
x_line_2_attend_college =>c_int_data_rec.line_2_attend_college_type ,
x_line_3_relation =>c_int_data_rec.line_3_relation_type ,
x_line_3_attend_college =>c_int_data_rec.line_3_attend_college_type ,
x_line_4_relation =>c_int_data_rec.line_4_relation_type ,
x_line_4_attend_college =>c_int_data_rec.line_4_attend_college_type ,
x_line_5_relation =>c_int_data_rec.line_5_relation_type ,
x_line_5_attend_college =>c_int_data_rec.line_5_attend_college_type ,
x_line_6_relation =>c_int_data_rec.line_6_relation_type ,
x_line_6_attend_college =>c_int_data_rec.line_6_attend_college_type ,
x_line_7_relation =>c_int_data_rec.line_7_relation_type ,
x_line_7_attend_college =>c_int_data_rec.line_7_attend_college_type ,
x_line_8_relation =>c_int_data_rec.line_8_relation_type ,
x_line_8_attend_college =>c_int_data_rec.line_8_attend_college_type ,
x_p_age_father =>convert_to_number(c_int_data_rec.p_age_father_num) ,
x_p_age_mother =>convert_to_number(c_int_data_rec.p_age_mother_num) ,
x_p_div_sep_ind =>c_int_data_rec.p_div_sep_flag ,
x_b_cont_non_custodial_par =>c_int_data_rec.b_cont_non_custodial_par_txt ,
x_college_type_2 =>c_int_data_rec.college_2_type ,
x_college_type_3 =>c_int_data_rec.college_3_type ,
x_college_type_4 =>c_int_data_rec.college_4_type ,
x_college_type_5 =>c_int_data_rec.college_5_type ,
x_college_type_6 =>c_int_data_rec.college_6_type ,
x_college_type_7 =>c_int_data_rec.college_7_type ,
x_college_type_8 =>c_int_data_rec.college_8_type ,
x_school_code_1 =>c_int_data_rec.school_1_cd ,
x_housing_code_1 =>c_int_data_rec.housing_1_type ,
x_school_code_2 =>c_int_data_rec.school_2_cd ,
x_housing_code_2 =>c_int_data_rec.housing_2_type ,
x_school_code_3 =>c_int_data_rec.school_3_cd ,
x_housing_code_3 =>c_int_data_rec.housing_3_type ,
x_school_code_4 =>c_int_data_rec.school_4_cd ,
x_housing_code_4 =>c_int_data_rec.housing_4_type ,
x_school_code_5 =>c_int_data_rec.school_5_cd ,
x_housing_code_5 =>c_int_data_rec.housing_5_type ,
x_school_code_6 =>c_int_data_rec.school_6_cd ,
x_housing_code_6 =>c_int_data_rec.housing_6_type ,
x_school_code_7 =>c_int_data_rec.school_7_cd ,
x_housing_code_7 =>c_int_data_rec.housing_7_type ,
x_school_code_8 =>c_int_data_rec.school_8_cd ,
x_housing_code_8 =>c_int_data_rec.housing_8_type ,
x_school_code_9 =>c_int_data_rec.school_9_cd ,
x_housing_code_9 =>c_int_data_rec.housing_9_type ,
x_school_code_10 =>c_int_data_rec.school_10_cd ,
x_housing_code_10 =>c_int_data_rec.housing_10_type ,
x_additional_school_code_1 =>c_int_data_rec.additional_school_1_cd ,
x_additional_school_code_2 =>c_int_data_rec.additional_school_2_cd ,
x_additional_school_code_3 =>c_int_data_rec.additional_school_3_cd ,
x_additional_school_code_4 =>c_int_data_rec.additional_school_4_cd ,
x_additional_school_code_5 =>c_int_data_rec.additional_school_5_cd ,
x_additional_school_code_6 =>c_int_data_rec.additional_school_6_cd ,
x_additional_school_code_7 =>c_int_data_rec.additional_school_7_cd ,
x_additional_school_code_8 =>c_int_data_rec.additional_school_8_cd ,
x_additional_school_code_9 =>c_int_data_rec.additional_school_9_cd ,
x_additional_school_code_10 =>c_int_data_rec.additional_school_10_cd ,
x_explanation_spec_circum =>c_int_data_rec.explanation_spec_circum_flag ,
x_signature_student =>c_int_data_rec.signature_student_flag ,
x_signature_spouse =>c_int_data_rec.signature_spouse_flag ,
x_signature_father =>c_int_data_rec.signature_father_flag ,
x_signature_mother =>c_int_data_rec.signature_mother_flag ,
x_month_day_completed =>c_int_data_rec.month_day_completed ,
x_year_completed =>c_int_data_rec.year_completed_flag ,
x_age_line_2 =>c_int_data_rec.age_line_2_num ,
x_age_line_3 =>c_int_data_rec.age_line_3_num ,
x_age_line_4 =>c_int_data_rec.age_line_4_num ,
x_age_line_5 =>c_int_data_rec.age_line_5_num ,
x_age_line_6 =>c_int_data_rec.age_line_6_num ,
x_age_line_7 =>c_int_data_rec.age_line_7_num ,
x_age_line_8 =>c_int_data_rec.age_line_8_num ,
x_a_online_signature =>c_int_data_rec.a_online_signature_flag ,
x_question_1_number =>c_int_data_rec.question_1_number_txt ,
x_question_1_size =>c_int_data_rec.question_1_size_num ,
x_question_1_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_1_answer_txt) ,
x_question_2_number =>c_int_data_rec.question_2_number_txt ,
x_question_2_size =>c_int_data_rec.question_2_size_num ,
x_question_2_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_2_answer_txt) ,
x_question_3_number =>c_int_data_rec.question_3_number_txt ,
x_question_3_size =>c_int_data_rec.question_3_size_num ,
x_question_3_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_3_answer_txt) ,
x_question_4_number =>c_int_data_rec.question_4_number_txt ,
x_question_4_size =>c_int_data_rec.question_4_size_num ,
x_question_4_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_4_answer_txt) ,
x_question_5_number =>c_int_data_rec.question_5_number_txt ,
x_question_5_size =>c_int_data_rec.question_5_size_num ,
x_question_5_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_5_answer_txt) ,
x_question_6_number =>c_int_data_rec.question_6_number_txt ,
x_question_6_size =>c_int_data_rec.question_6_size_num ,
x_question_6_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_6_answer_txt) ,
x_question_7_number =>c_int_data_rec.question_7_number_txt ,
x_question_7_size =>c_int_data_rec.question_7_size_num ,
x_question_7_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_7_answer_txt) ,
x_question_8_number =>c_int_data_rec.question_8_number_txt ,
x_question_8_size =>c_int_data_rec.question_8_size_num ,
x_question_8_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_8_answer_txt) ,
x_question_9_number =>c_int_data_rec.question_9_number_txt ,
x_question_9_size =>c_int_data_rec.question_9_size_num ,
x_question_9_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_9_answer_txt) ,
x_question_10_number =>c_int_data_rec.question_10_number_txt ,
x_question_10_size =>c_int_data_rec.question_10_size_num ,
x_question_10_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_10_answer_txt) ,
x_question_11_number =>c_int_data_rec.question_11_number_txt ,
x_question_11_size =>c_int_data_rec.question_11_size_num ,
x_question_11_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_11_answer_txt) ,
x_question_12_number =>c_int_data_rec.question_12_number_txt ,
x_question_12_size =>c_int_data_rec.question_12_size_num ,
x_question_12_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_12_answer_txt) ,
x_question_13_number =>c_int_data_rec.question_13_number_txt ,
x_question_13_size =>c_int_data_rec.question_13_size_num ,
x_question_13_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_13_answer_txt) ,
x_question_14_number =>c_int_data_rec.question_14_number_txt ,
x_question_14_size =>c_int_data_rec.question_14_size_num ,
x_question_14_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_14_answer_txt) ,
x_question_15_number =>c_int_data_rec.question_15_number_txt ,
x_question_15_size =>c_int_data_rec.question_15_size_num ,
x_question_15_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_15_answer_txt) ,
x_question_16_number =>c_int_data_rec.question_16_number_txt ,
x_question_16_size =>c_int_data_rec.question_16_size_num ,
x_question_16_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_16_answer_txt) ,
x_question_17_number =>c_int_data_rec.question_17_number_txt ,
x_question_17_size =>c_int_data_rec.question_17_size_num ,
x_question_17_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_17_answer_txt) ,
x_question_18_number =>c_int_data_rec.question_18_number_txt ,
x_question_18_size =>c_int_data_rec.question_18_size_num ,
x_question_18_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_18_answer_txt) ,
x_question_19_number =>c_int_data_rec.question_19_number_txt ,
x_question_19_size =>c_int_data_rec.question_19_size_num ,
x_question_19_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_19_answer_txt) ,
x_question_20_number =>c_int_data_rec.question_20_number_txt ,
x_question_20_size =>c_int_data_rec.question_20_size_num ,
x_question_20_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_20_answer_txt) ,
x_question_21_number =>c_int_data_rec.question_21_number_txt ,
x_question_21_size =>c_int_data_rec.question_21_size_num ,
x_question_21_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_21_answer_txt) ,
x_question_22_number =>c_int_data_rec.question_22_number_txt ,
x_question_22_size =>c_int_data_rec.question_22_size_num ,
x_question_22_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_22_answer_txt) ,
x_question_23_number =>c_int_data_rec.question_23_number_txt ,
x_question_23_size =>c_int_data_rec.question_23_size_num ,
x_question_23_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_23_answer_txt) ,
x_question_24_number =>c_int_data_rec.question_24_number_txt ,
x_question_24_size =>c_int_data_rec.question_24_size_num ,
x_question_24_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_24_answer_txt) ,
x_question_25_number =>c_int_data_rec.question_25_number_txt ,
x_question_25_size =>c_int_data_rec.question_25_size_num ,
x_question_25_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_25_answer_txt) ,
x_question_26_number =>c_int_data_rec.question_26_number_txt ,
x_question_26_size =>c_int_data_rec.question_26_size_num ,
x_question_26_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_26_answer_txt) ,
x_question_27_number =>c_int_data_rec.question_27_number_txt ,
x_question_27_size =>c_int_data_rec.question_27_size_num ,
x_question_27_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_27_answer_txt) ,
x_question_28_number =>c_int_data_rec.question_28_number_txt ,
x_question_28_size =>c_int_data_rec.question_28_size_num ,
x_question_28_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_28_answer_txt) ,
x_question_29_number =>c_int_data_rec.question_29_number_txt ,
x_question_29_size =>c_int_data_rec.question_29_size_num ,
x_question_29_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_29_answer_txt) ,
x_question_30_number =>c_int_data_rec.question_30_number_txt ,
x_questions_30_size =>c_int_data_rec.questions_30_size_num ,
x_question_30_answer =>igf_ap_profile_matching_pkg.convert_int(c_int_data_rec.question_30_answer_txt) ,
x_legacy_record_flag => 'Y',
x_coa_duration_efc_amt => NULL,
x_coa_duration_num => NULL,
x_p_soc_sec_ben_student_amt => c_int_data_rec.p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt => c_int_data_rec.p_tuit_fee_deduct_amt,
x_stu_lives_with_num => c_int_data_rec.stu_lives_with_num,
x_stu_most_support_from_num => c_int_data_rec.stu_most_support_from_num,
x_location_computer_num => c_int_data_rec.location_computer_num
);
END css_insert_row;
PROCEDURE fnar_insert_row(c_int_data_rec IN c_int_data%ROWTYPE,
p_cssp_id IN NUMBER)AS
/*
|| Created By : rasahoo
|| Created On : 03-June-2003
|| Purpose : Insert NSLDS data
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
l_rowid VARCHAR2(30);
igf_ap_css_fnar_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fnar_id => ln_fnar_id,
x_cssp_id => p_cssp_id,
x_r_s_email_address =>c_int_data_rec.r_s_email_address_txt ,
x_eps_code =>c_int_data_rec.eps_cd ,
x_comp_css_dependency_status =>c_int_data_rec.comp_css_dependcy_status_type ,
x_stu_age =>c_int_data_rec.stu_age_num ,
x_assumed_stu_yr_in_coll =>c_int_data_rec.assumed_stu_yr_in_coll_type ,
x_comp_stu_marital_status =>c_int_data_rec.comp_stu_marital_status_type ,
x_stu_family_members =>c_int_data_rec.stu_family_members_num ,
x_stu_fam_members_in_college =>c_int_data_rec.stu_fam_members_in_college_num ,
x_par_marital_status =>c_int_data_rec.par_marital_status_type ,
x_par_family_members =>c_int_data_rec.par_family_members_num ,
x_par_total_in_college =>c_int_data_rec.par_total_in_college_num ,
x_par_par_in_college =>c_int_data_rec.par_par_in_college_num ,
x_par_others_in_college =>c_int_data_rec.par_others_in_college_num ,
x_par_aesa =>c_int_data_rec.par_aesa_num ,
x_par_cesa =>c_int_data_rec.par_cesa_num ,
x_stu_aesa =>c_int_data_rec.stu_aesa_num ,
x_stu_cesa =>c_int_data_rec.stu_cesa_num ,
x_im_p_bas_agi_taxable_income =>c_int_data_rec.im_p_bas_agi_taxable_amt ,
x_im_p_bas_untx_inc_and_ben =>c_int_data_rec.im_p_bas_untx_inc_and_ben_amt ,
x_im_p_bas_inc_adj =>c_int_data_rec.im_p_bas_inc_adj_amt ,
x_im_p_bas_total_income =>c_int_data_rec.im_p_bas_total_income_amt ,
x_im_p_bas_us_income_tax =>c_int_data_rec.im_p_bas_us_income_tax_amt ,
x_im_p_bas_st_and_other_tax =>c_int_data_rec.im_p_bas_st_and_other_tax_amt ,
x_im_p_bas_fica_tax =>c_int_data_rec.im_p_bas_fica_tax_amt ,
x_im_p_bas_med_dental =>c_int_data_rec.im_p_bas_med_dental_amt ,
x_im_p_bas_employment_allow =>c_int_data_rec.im_p_bas_employment_allow_amt ,
x_im_p_bas_annual_ed_savings =>c_int_data_rec.im_p_bas_annual_ed_savings_amt ,
x_im_p_bas_inc_prot_allow_m =>c_int_data_rec.im_p_bas_inc_prot_allow_m_amt ,
x_im_p_bas_total_inc_allow =>c_int_data_rec.im_p_bas_total_inc_allow_amt ,
x_im_p_bas_cal_avail_inc =>c_int_data_rec.im_p_bas_cal_avail_inc_amt ,
x_im_p_bas_avail_income =>c_int_data_rec.im_p_bas_avail_income_amt ,
x_im_p_bas_total_cont_inc =>c_int_data_rec.im_p_bas_total_cont_inc_amt ,
x_im_p_bas_cash_bank_accounts =>c_int_data_rec.im_p_bas_cash_bank_account_amt ,
x_im_p_bas_home_equity =>c_int_data_rec.im_p_bas_home_equity_amt ,
x_im_p_bas_ot_rl_est_inv_eq =>c_int_data_rec.im_p_bas_ot_rl_est_inv_eq_amt ,
x_im_p_bas_adj_bus_farm_worth =>c_int_data_rec.im_p_bas_adj_bus_farm_wrth_amt ,
x_im_p_bas_ass_sibs_pre_tui =>c_int_data_rec.im_p_bas_ass_sibs_pre_tui_amt ,
x_im_p_bas_net_worth =>c_int_data_rec.im_p_bas_net_worth_amt ,
x_im_p_bas_emerg_res_allow =>c_int_data_rec.im_p_bas_emerg_res_allow_amt ,
x_im_p_bas_cum_ed_savings =>c_int_data_rec.im_p_bas_cum_ed_savings_amt ,
x_im_p_bas_low_inc_allow =>c_int_data_rec.im_p_bas_low_inc_allow_amt ,
x_im_p_bas_total_asset_allow =>c_int_data_rec.im_p_bas_total_asset_allow_amt ,
x_im_p_bas_disc_net_worth =>c_int_data_rec.im_p_bas_disc_net_worth_amt ,
x_im_p_bas_total_cont_asset =>c_int_data_rec.im_p_bas_total_cont_asset_amt ,
x_im_p_bas_total_cont =>c_int_data_rec.im_p_bas_total_cont_amt ,
x_im_p_bas_num_in_coll_adj =>c_int_data_rec.im_p_bas_num_in_coll_adj_amt ,
x_im_p_bas_cont_for_stu =>c_int_data_rec.im_p_bas_cont_for_stu_amt ,
x_im_p_bas_cont_from_income =>c_int_data_rec.im_p_bas_cont_from_income_amt ,
x_im_p_bas_cont_from_assets =>c_int_data_rec.im_p_bas_cont_from_assets_amt ,
x_im_p_opt_agi_taxable_income =>c_int_data_rec.im_p_opt_agi_tax_income_amt ,
x_im_p_opt_untx_inc_and_ben =>c_int_data_rec.im_p_opt_untx_inc_ben_amt ,
x_im_p_opt_inc_adj =>c_int_data_rec.im_p_opt_inc_adj_amt ,
x_im_p_opt_total_income =>c_int_data_rec.im_p_opt_total_income_amt ,
x_im_p_opt_us_income_tax =>c_int_data_rec.im_p_opt_us_income_tax_amt ,
x_im_p_opt_st_and_other_tax =>c_int_data_rec.im_p_opt_st_and_other_tax_amt ,
x_im_p_opt_fica_tax =>c_int_data_rec.im_p_opt_fica_tax_amt ,
x_im_p_opt_med_dental =>c_int_data_rec.im_p_opt_med_dental_amt ,
x_im_p_opt_elem_sec_tuit =>c_int_data_rec.im_p_opt_elem_sec_tuit_amt ,
x_im_p_opt_employment_allow =>c_int_data_rec.im_p_opt_employment_allow_amt ,
x_im_p_opt_annual_ed_savings =>c_int_data_rec.im_p_opt_annual_ed_saving_amt ,
x_im_p_opt_inc_prot_allow_m =>c_int_data_rec.im_p_opt_inc_prot_allow_m_amt ,
x_im_p_opt_total_inc_allow =>c_int_data_rec.im_p_opt_total_inc_allow_amt ,
x_im_p_opt_cal_avail_inc =>c_int_data_rec.im_p_opt_cal_avail_inc_amt ,
x_im_p_opt_avail_income =>c_int_data_rec.im_p_opt_avail_income_amt ,
x_im_p_opt_total_cont_inc =>c_int_data_rec.im_p_opt_total_cont_inc_amt ,
x_im_p_opt_cash_bank_accounts =>c_int_data_rec.im_p_opt_cash_bank_accnt_amt ,
x_im_p_opt_home_equity =>c_int_data_rec.im_p_opt_home_equity_amt ,
x_im_p_opt_ot_rl_est_inv_eq =>c_int_data_rec.im_p_opt_ot_rl_est_inv_eq_amt ,
x_im_p_opt_adj_bus_farm_worth =>c_int_data_rec.im_p_opt_adj_farm_worth_amt ,
x_im_p_opt_ass_sibs_pre_tui =>c_int_data_rec.im_p_opt_ass_sibs_pre_t_amt ,
x_im_p_opt_net_worth =>c_int_data_rec.im_p_opt_net_worth_amt ,
x_im_p_opt_emerg_res_allow =>c_int_data_rec.im_p_opt_emerg_res_allow_amt ,
x_im_p_opt_cum_ed_savings =>c_int_data_rec.im_p_opt_cum_ed_savings_amt ,
x_im_p_opt_low_inc_allow =>c_int_data_rec.im_p_opt_low_inc_allow_amt ,
x_im_p_opt_total_asset_allow =>c_int_data_rec.im_p_opt_total_asset_allow_amt ,
x_im_p_opt_disc_net_worth =>c_int_data_rec.im_p_opt_disc_net_worth_amt ,
x_im_p_opt_total_cont_asset =>c_int_data_rec.im_p_opt_total_cont_asset_amt ,
x_im_p_opt_total_cont =>c_int_data_rec.im_p_opt_total_cont_amt ,
x_im_p_opt_num_in_coll_adj =>c_int_data_rec.im_p_opt_num_in_coll_adj_amt ,
x_im_p_opt_cont_for_stu =>c_int_data_rec.im_p_opt_cont_for_stu_amt ,
x_im_p_opt_cont_from_income =>c_int_data_rec.im_p_opt_cont_from_income_amt ,
x_im_p_opt_cont_from_assets =>c_int_data_rec.im_p_opt_cont_from_assets_amt ,
x_fm_p_analysis_type =>c_int_data_rec.fm_p_analysis_type ,
x_fm_p_agi_taxable_income =>c_int_data_rec.fm_p_agi_taxable_income_amt ,
x_fm_p_untx_inc_and_ben =>c_int_data_rec.fm_p_untx_inc_and_ben_amt ,
x_fm_p_inc_adj =>c_int_data_rec.fm_p_inc_adj_amt ,
x_fm_p_total_income =>c_int_data_rec.fm_p_total_income_amt ,
x_fm_p_us_income_tax =>c_int_data_rec.fm_p_us_income_tax_amt ,
x_fm_p_state_and_other_taxes =>c_int_data_rec.fm_p_state_and_other_tax_amt ,
x_fm_p_fica_tax =>c_int_data_rec.fm_p_fica_tax_amt ,
x_fm_p_employment_allow =>c_int_data_rec.fm_p_employment_allow_amt ,
x_fm_p_income_prot_allow =>c_int_data_rec.fm_p_income_prot_allow_amt ,
x_fm_p_total_allow =>c_int_data_rec.fm_p_total_allow_amt ,
x_fm_p_avail_income =>c_int_data_rec.fm_p_avail_income_amt ,
x_fm_p_cash_bank_accounts =>c_int_data_rec.fm_p_cash_bank_accounts_amt ,
x_fm_p_ot_rl_est_inv_equity =>c_int_data_rec.fm_p_ot_rl_est_inv_eq_amt ,
x_fm_p_adj_bus_farm_net_worth =>c_int_data_rec.fm_p_adj_farm_net_worth_amt ,
x_fm_p_net_worth =>c_int_data_rec.fm_p_net_worth_amt ,
x_fm_p_asset_prot_allow =>c_int_data_rec.fm_p_asset_prot_allow_amt ,
x_fm_p_disc_net_worth =>c_int_data_rec.fm_p_disc_net_worth_amt ,
x_fm_p_total_contribution =>c_int_data_rec.fm_p_total_contribution_amt ,
x_fm_p_num_in_coll =>c_int_data_rec.fm_p_num_in_coll_num ,
x_fm_p_cont_for_stu =>c_int_data_rec.fm_p_cont_for_stu_amt ,
x_fm_p_cont_from_income =>c_int_data_rec.fm_p_cont_from_income_amt ,
x_fm_p_cont_from_assets =>c_int_data_rec.fm_p_cont_from_assets_amt ,
x_im_s_bas_agi_taxable_income =>c_int_data_rec.im_s_bas_agi_tax_income_amt ,
x_im_s_bas_untx_inc_and_ben =>c_int_data_rec.im_s_bas_untx_inc_and_ben_amt ,
x_im_s_bas_inc_adj =>c_int_data_rec.im_s_bas_inc_adj_amt ,
x_im_s_bas_total_income =>c_int_data_rec.im_s_bas_total_income_amt ,
x_im_s_bas_us_income_tax =>c_int_data_rec.im_s_bas_us_income_tax_amt ,
x_im_s_bas_state_and_oth_taxes =>c_int_data_rec.im_s_bas_st_and_oth_tax_amt ,
x_im_s_bas_fica_tax =>c_int_data_rec.im_s_bas_fica_tax_amt ,
x_im_s_bas_med_dental =>c_int_data_rec.im_s_bas_med_dental_amt ,
x_im_s_bas_employment_allow =>c_int_data_rec.im_s_bas_employment_allow_amt ,
x_im_s_bas_annual_ed_savings =>c_int_data_rec.im_s_bas_annual_ed_savings_amt ,
x_im_s_bas_inc_prot_allow_m =>c_int_data_rec.im_s_bas_inc_prot_allow_m_amt ,
x_im_s_bas_total_inc_allow =>c_int_data_rec.im_s_bas_total_inc_allow_amt ,
x_im_s_bas_cal_avail_income =>c_int_data_rec.im_s_bas_cal_avail_income_amt ,
x_im_s_bas_avail_income =>c_int_data_rec.im_s_bas_avail_income_amt ,
x_im_s_bas_total_cont_inc =>c_int_data_rec.im_s_bas_total_cont_inc_amt ,
x_im_s_bas_cash_bank_accounts =>c_int_data_rec.im_s_bas_cash_bank_account_amt ,
x_im_s_bas_home_equity =>c_int_data_rec.im_s_bas_home_equity_amt ,
x_im_s_bas_ot_rl_est_inv_eq =>c_int_data_rec.im_s_bas_ot_rl_est_inv_eq_amt ,
x_im_s_bas_adj_busfarm_worth =>c_int_data_rec.im_s_bas_adj_farm_worth_amt ,
x_im_s_bas_trusts =>c_int_data_rec.im_s_bas_trusts_amt ,
x_im_s_bas_net_worth =>c_int_data_rec.im_s_bas_net_worth_amt ,
x_im_s_bas_emerg_res_allow =>c_int_data_rec.im_s_bas_emerg_res_allow_amt ,
x_im_s_bas_cum_ed_savings =>c_int_data_rec.im_s_bas_cum_ed_savings_amt ,
x_im_s_bas_total_asset_allow =>c_int_data_rec.im_s_bas_total_asset_allow_amt ,
x_im_s_bas_disc_net_worth =>c_int_data_rec.im_s_bas_disc_net_worth_amt ,
x_im_s_bas_total_cont_asset =>c_int_data_rec.im_s_bas_total_cont_asset_amt ,
x_im_s_bas_total_cont =>c_int_data_rec.im_s_bas_total_cont_amt ,
x_im_s_bas_num_in_coll_adj =>c_int_data_rec.im_s_bas_num_in_coll_adj_amt ,
x_im_s_bas_cont_for_stu =>c_int_data_rec.im_s_bas_cont_for_stu_amt ,
x_im_s_bas_cont_from_income =>c_int_data_rec.im_s_bas_cont_from_income_amt ,
x_im_s_bas_cont_from_assets =>c_int_data_rec.im_s_bas_cont_from_assets_amt ,
x_im_s_est_agitaxable_income =>c_int_data_rec.im_s_est_agi_tax_income_amt ,
x_im_s_est_untx_inc_and_ben =>c_int_data_rec.im_s_est_untx_inc_and_ben_amt ,
x_im_s_est_inc_adj =>c_int_data_rec.im_s_est_inc_adj_amt ,
x_im_s_est_total_income =>c_int_data_rec.im_s_est_total_income_amt ,
x_im_s_est_us_income_tax =>c_int_data_rec.im_s_est_us_income_tax_amt ,
x_im_s_est_state_and_oth_taxes =>c_int_data_rec.im_s_est_st_and_oth_tax_amt ,
x_im_s_est_fica_tax =>c_int_data_rec.im_s_est_fica_tax_amt ,
x_im_s_est_med_dental =>c_int_data_rec.im_s_est_med_dental_amt ,
x_im_s_est_employment_allow =>c_int_data_rec.im_s_est_employment_allow_amt ,
x_im_s_est_annual_ed_savings =>c_int_data_rec.im_s_est_annual_ed_savings_amt ,
x_im_s_est_inc_prot_allow_m =>c_int_data_rec.im_s_est_inc_prot_allow_m_amt ,
x_im_s_est_total_inc_allow =>c_int_data_rec.im_s_est_total_inc_allow_amt ,
x_im_s_est_cal_avail_income =>c_int_data_rec.im_s_est_cal_avail_income_amt ,
x_im_s_est_avail_income =>c_int_data_rec.im_s_est_avail_income_amt ,
x_im_s_est_total_cont_inc =>c_int_data_rec.im_s_est_total_cont_inc_amt ,
x_im_s_est_cash_bank_accounts =>c_int_data_rec.im_s_est_cash_bank_account_amt ,
x_im_s_est_home_equity =>c_int_data_rec.im_s_est_home_equity_amt ,
x_im_s_est_ot_rl_est_inv_eq =>c_int_data_rec.im_s_est_ot_rl_est_inv_equ_amt ,
x_im_s_est_adj_bus_farm_worth =>c_int_data_rec.im_s_est_adj_farm_worth_amt ,
x_im_s_est_est_trusts =>c_int_data_rec.im_s_est_est_trusts_amt ,
x_im_s_est_net_worth =>c_int_data_rec.im_s_est_net_worth_amt ,
x_im_s_est_emerg_res_allow =>c_int_data_rec.im_s_est_emerg_res_allow_amt ,
x_im_s_est_cum_ed_savings =>c_int_data_rec.im_s_est_cum_ed_savings_amt ,
x_im_s_est_total_asset_allow =>c_int_data_rec.im_s_est_total_asset_allow_amt ,
x_im_s_est_disc_net_worth =>c_int_data_rec.im_s_est_disc_net_worth_amt ,
x_im_s_est_total_cont_asset =>c_int_data_rec.im_s_est_total_cont_asset_amt ,
x_im_s_est_total_cont =>c_int_data_rec.im_s_est_total_cont_amt ,
x_im_s_est_num_in_coll_adj =>c_int_data_rec.im_s_est_num_in_coll_adj_amt ,
x_im_s_est_cont_for_stu =>c_int_data_rec.im_s_est_cont_for_stu_amt ,
x_im_s_est_cont_from_income =>c_int_data_rec.im_s_est_cont_from_income_amt ,
x_im_s_est_cont_from_assets =>c_int_data_rec.im_s_est_cont_from_assets_amt ,
x_im_s_opt_agi_taxable_income =>c_int_data_rec.im_s_opt_agi_tax_income_amt ,
x_im_s_opt_untx_inc_and_ben =>c_int_data_rec.im_s_opt_untx_inc_and_ben_amt ,
x_im_s_opt_inc_adj =>c_int_data_rec.im_s_opt_inc_adj_amt ,
x_im_s_opt_total_income =>c_int_data_rec.im_s_opt_total_income_amt ,
x_im_s_opt_us_income_tax =>c_int_data_rec.im_s_opt_us_income_tax_amt ,
x_im_s_opt_state_and_oth_taxes =>c_int_data_rec.im_s_opt_state_oth_taxes_amt ,
x_im_s_opt_fica_tax =>c_int_data_rec.im_s_opt_fica_tax_amt ,
x_im_s_opt_med_dental =>c_int_data_rec.im_s_opt_med_dental_amt ,
x_im_s_opt_employment_allow =>c_int_data_rec.im_s_opt_employment_allow_amt ,
x_im_s_opt_annual_ed_savings =>c_int_data_rec.im_s_opt_annual_ed_savings_amt ,
x_im_s_opt_inc_prot_allow_m =>c_int_data_rec.im_s_opt_inc_prot_allow_m_amt ,
x_im_s_opt_total_inc_allow =>c_int_data_rec.im_s_opt_total_inc_allow_amt ,
x_im_s_opt_cal_avail_income =>c_int_data_rec.im_s_opt_cal_avail_income_amt ,
x_im_s_opt_avail_income =>c_int_data_rec.im_s_opt_avail_income_amt ,
x_im_s_opt_total_cont_inc =>c_int_data_rec.im_s_opt_total_cont_inc_amt ,
x_im_s_opt_cash_bank_accounts =>c_int_data_rec.im_s_opt_cash_bank_account_amt ,
x_im_s_opt_ira_keogh_accounts =>c_int_data_rec.im_s_opt_ira_keogh_account_amt ,
x_im_s_opt_home_equity =>c_int_data_rec.im_s_opt_home_equity_amt ,
x_im_s_opt_ot_rl_est_inv_eq =>c_int_data_rec.im_s_opt_ot_rl_est_inv_eq_amt ,
x_im_s_opt_adj_bus_farm_worth =>c_int_data_rec.im_s_opt_adj_bus_frm_worth_amt ,
x_im_s_opt_trusts =>c_int_data_rec.im_s_opt_trusts_amt ,
x_im_s_opt_net_worth =>c_int_data_rec.im_s_opt_net_worth_amt ,
x_im_s_opt_emerg_res_allow =>c_int_data_rec.im_s_opt_emerg_res_allow_amt ,
x_im_s_opt_cum_ed_savings =>c_int_data_rec.im_s_opt_cum_ed_savings_amt ,
x_im_s_opt_total_asset_allow =>c_int_data_rec.im_s_opt_total_asset_allow_amt ,
x_im_s_opt_disc_net_worth =>c_int_data_rec.im_s_opt_disc_net_worth_amt ,
x_im_s_opt_total_cont_asset =>c_int_data_rec.im_s_opt_total_cont_asset_amt ,
x_im_s_opt_total_cont =>c_int_data_rec.im_s_opt_total_cont_amt ,
x_im_s_opt_num_in_coll_adj =>c_int_data_rec.im_s_opt_num_in_coll_adj_amt ,
x_im_s_opt_cont_for_stu =>c_int_data_rec.im_s_opt_cont_for_stu_amt ,
x_im_s_opt_cont_from_income =>c_int_data_rec.im_s_opt_cont_from_income_amt ,
x_im_s_opt_cont_from_assets =>c_int_data_rec.im_s_opt_cont_from_assets_amt ,
x_fm_s_analysis_type =>c_int_data_rec.fm_s_analysis_type ,
x_fm_s_agi_taxable_income =>c_int_data_rec.fm_s_agi_taxable_income_amt ,
x_fm_s_untx_inc_and_ben =>c_int_data_rec.fm_s_untx_inc_and_ben_amt ,
x_fm_s_inc_adj =>c_int_data_rec.fm_s_inc_adj_amt ,
x_fm_s_total_income =>c_int_data_rec.fm_s_total_income_amt ,
x_fm_s_us_income_tax =>c_int_data_rec.fm_s_us_income_tax_amt ,
x_fm_s_state_and_oth_taxes =>c_int_data_rec.fm_s_state_and_oth_taxes_amt ,
x_fm_s_fica_tax =>c_int_data_rec.fm_s_fica_tax_amt ,
x_fm_s_employment_allow =>c_int_data_rec.fm_s_employment_allow_amt ,
x_fm_s_income_prot_allow =>c_int_data_rec.fm_s_income_prot_allow_amt ,
x_fm_s_total_allow =>c_int_data_rec.fm_s_total_allow_amt ,
x_fm_s_cal_avail_income =>c_int_data_rec.fm_s_cal_avail_income_amt ,
x_fm_s_avail_income =>c_int_data_rec.fm_s_avail_income_amt ,
x_fm_s_cash_bank_accounts =>c_int_data_rec.fm_s_cash_bank_accounts_amt ,
x_fm_s_ot_rl_est_inv_equity =>c_int_data_rec.fm_s_ot_rl_est_inv_equity_amt ,
x_fm_s_adj_bus_farm_worth =>c_int_data_rec.fm_s_adj_bus_farm_worth_amt ,
x_fm_s_trusts =>c_int_data_rec.fm_s_trusts_amt ,
x_fm_s_net_worth =>c_int_data_rec.fm_s_net_worth_amt ,
x_fm_s_asset_prot_allow =>c_int_data_rec.fm_s_asset_prot_allow_amt ,
x_fm_s_disc_net_worth =>c_int_data_rec.fm_s_disc_net_worth_amt ,
x_fm_s_total_cont =>c_int_data_rec.fm_s_total_cont_amt ,
x_fm_s_num_in_coll =>c_int_data_rec.fm_s_num_in_coll_num ,
x_fm_s_cont_for_stu =>c_int_data_rec.fm_s_cont_for_stu_amt ,
x_fm_s_cont_from_income =>c_int_data_rec.fm_s_cont_from_income_amt ,
x_fm_s_cont_from_assets =>c_int_data_rec.fm_s_cont_from_assets_amt ,
x_im_inst_resident_ind =>c_int_data_rec.im_inst_resident_flag ,
x_institutional_1_budget_name =>c_int_data_rec.institutional_1_budget_name ,
x_im_inst_1_budget_duration =>c_int_data_rec.im_inst_1_budget_duration_num ,
x_im_inst_1_tuition_fees =>c_int_data_rec.im_inst_1_tuition_fees_amt ,
x_im_inst_1_books_supplies =>c_int_data_rec.im_inst_1_books_supplies_amt ,
x_im_inst_1_living_expenses =>c_int_data_rec.im_inst_1_living_expenses_amt ,
x_im_inst_1_tot_expenses =>c_int_data_rec.im_inst_1_tot_expenses_amt ,
x_im_inst_1_tot_stu_cont =>c_int_data_rec.im_inst_1_tot_stu_cont_amt ,
x_im_inst_1_tot_par_cont =>c_int_data_rec.im_inst_1_tot_par_cont_amt ,
x_im_inst_1_tot_family_cont =>c_int_data_rec.im_inst_1_tot_family_cont_amt ,
x_im_inst_1_va_benefits =>c_int_data_rec.im_inst_1_va_benefits_amt ,
x_im_inst_1_ot_cont =>c_int_data_rec.im_inst_1_ot_cont_amt ,
x_im_inst_1_est_financial_need =>c_int_data_rec.im_inst_1_est_finan_need_amt ,
x_institutional_2_budget_name =>c_int_data_rec.institutional_2_budget_txt ,
x_im_inst_2_budget_duration =>c_int_data_rec.im_inst_2_budget_duration_num ,
x_im_inst_2_tuition_fees =>c_int_data_rec.im_inst_2_tuition_fees_amt ,
x_im_inst_2_books_supplies =>c_int_data_rec.im_inst_2_books_supplies_amt ,
x_im_inst_2_living_expenses =>c_int_data_rec.im_inst_2_living_expenses_amt ,
x_im_inst_2_tot_expenses =>c_int_data_rec.im_inst_2_tot_expenses_amt ,
x_im_inst_2_tot_stu_cont =>c_int_data_rec.im_inst_2_tot_stu_cont_amt ,
x_im_inst_2_tot_par_cont =>c_int_data_rec.im_inst_2_tot_par_cont_amt ,
x_im_inst_2_tot_family_cont =>c_int_data_rec.im_inst_2_tot_family_cont_amt ,
x_im_inst_2_va_benefits =>c_int_data_rec.im_inst_2_va_benefits_amt ,
x_im_inst_2_est_financial_need =>c_int_data_rec.im_inst_2_est_finan_need_amt ,
x_institutional_3_budget_name =>c_int_data_rec.institutional_3_budget_txt ,
x_im_inst_3_budget_duration =>c_int_data_rec.im_inst_3_budget_duration_num ,
x_im_inst_3_tuition_fees =>c_int_data_rec.im_inst_3_tuition_fees_amt ,
x_im_inst_3_books_supplies =>c_int_data_rec.im_inst_3_books_supplies_amt ,
x_im_inst_3_living_expenses =>c_int_data_rec.im_inst_3_living_expenses_amt ,
x_im_inst_3_tot_expenses =>c_int_data_rec.im_inst_3_tot_expenses_amt ,
x_im_inst_3_tot_stu_cont =>c_int_data_rec.im_inst_3_tot_stu_cont_amt,
x_im_inst_3_tot_par_cont =>c_int_data_rec.im_inst_3_tot_par_cont_amt ,
x_im_inst_3_tot_family_cont =>c_int_data_rec.im_inst_3_tot_family_cont_amt ,
x_im_inst_3_va_benefits =>c_int_data_rec.im_inst_3_va_benefits_amt ,
x_im_inst_3_est_financial_need =>c_int_data_rec.im_inst_3_est_finan_need_amt ,
x_fm_inst_1_federal_efc =>c_int_data_rec.fm_inst_1_federal_efc_txt ,
x_fm_inst_1_va_benefits =>c_int_data_rec.fm_inst_1_va_benefits_txt ,
x_fm_inst_1_fed_eligibility =>c_int_data_rec.fm_inst_1_fed_eligibility_txt ,
x_fm_inst_1_pell =>c_int_data_rec.fm_inst_1_pell_txt ,
x_option_par_loss_allow_ind =>c_int_data_rec.option_par_loss_allow_flag ,
x_option_par_tuition_ind =>c_int_data_rec.option_par_tuition_flag ,
x_option_par_home_ind =>c_int_data_rec.option_par_home_type ,
x_option_par_home_value =>c_int_data_rec.option_par_home_value_txt ,
x_option_par_home_debt =>c_int_data_rec.option_par_home_debt_txt ,
x_option_stu_ira_keogh_ind =>c_int_data_rec.option_stu_ira_keogh_flag ,
x_option_stu_home_ind =>c_int_data_rec.option_stu_home_type ,
x_option_stu_home_value =>c_int_data_rec.option_stu_home_value_txt ,
x_option_stu_home_debt =>c_int_data_rec.option_stu_home_debt_txt ,
x_option_stu_sum_ay_inc_ind =>c_int_data_rec.option_stu_sum_ay_inc_flag ,
x_option_par_hope_ll_credit =>c_int_data_rec.option_par_hope_ll_credit_flag ,
x_option_stu_hope_ll_credit =>c_int_data_rec.option_stu_hope_ll_credit_flag ,
x_im_parent_1_8_months_bas =>c_int_data_rec.im_parent_1_8_months_bas_txt ,
x_im_p_more_than_9_mth_ba =>c_int_data_rec.im_p_more_than_9_mth_ba_txt ,
x_im_parent_1_8_months_opt =>c_int_data_rec.im_parent_1_8_months_opt_txt ,
x_im_p_more_than_9_mth_op =>c_int_data_rec.im_p_more_than_9_mth_op_txt ,
x_fnar_message_1 =>c_int_data_rec.fnar_message_1_flag ,
x_fnar_message_2 =>c_int_data_rec.fnar_message_2_flag ,
x_fnar_message_3 =>c_int_data_rec.fnar_message_3_flag ,
x_fnar_message_4 =>c_int_data_rec.fnar_message_4_flag ,
x_fnar_message_5 =>c_int_data_rec.fnar_message_5_flag ,
x_fnar_message_6 =>c_int_data_rec.fnar_message_6_flag ,
x_fnar_message_7 =>c_int_data_rec.fnar_message_7_flag ,
x_fnar_message_8 =>c_int_data_rec.fnar_message_8_flag ,
x_fnar_message_9 =>c_int_data_rec.fnar_message_9_flag ,
x_fnar_message_10 =>c_int_data_rec.fnar_message_10_flag ,
x_fnar_message_11 =>c_int_data_rec.fnar_message_11_flag ,
x_fnar_message_12 =>c_int_data_rec.fnar_message_12_flag ,
x_fnar_message_13 =>c_int_data_rec.fnar_message_13_flag,
x_fnar_message_20 =>c_int_data_rec.fnar_message_20_flag ,
x_fnar_message_21 =>c_int_data_rec.fnar_message_21_flag ,
x_fnar_message_22 =>c_int_data_rec.fnar_message_22_flag ,
x_fnar_message_23 =>c_int_data_rec.fnar_message_23_flag ,
x_fnar_message_24 =>c_int_data_rec.fnar_message_24_flag ,
x_fnar_message_25 =>c_int_data_rec.fnar_message_25_flag ,
x_fnar_message_26 =>c_int_data_rec.fnar_message_26_flag ,
x_fnar_message_27 =>c_int_data_rec.fnar_message_27_flag ,
x_fnar_message_30 =>c_int_data_rec.fnar_message_30_flag ,
x_fnar_message_31 =>c_int_data_rec.fnar_message_31_flag ,
x_fnar_message_32 =>c_int_data_rec.fnar_message_32_flag ,
x_fnar_message_33 =>c_int_data_rec.fnar_message_33_flag ,
x_fnar_message_34 =>c_int_data_rec.fnar_message_34_flag ,
x_fnar_message_35 =>c_int_data_rec.fnar_message_35_flag ,
x_fnar_message_36 =>c_int_data_rec.fnar_message_36_flag ,
x_fnar_message_37 =>c_int_data_rec.fnar_message_37_flag ,
x_fnar_message_38 =>c_int_data_rec.fnar_message_38_flag ,
x_fnar_message_39 =>c_int_data_rec.fnar_message_39_flag ,
x_fnar_message_45 =>c_int_data_rec.fnar_message_45_flag ,
x_fnar_message_46 =>c_int_data_rec.fnar_message_46_flag ,
x_fnar_message_47 =>c_int_data_rec.fnar_message_47_flag ,
x_fnar_message_48 =>c_int_data_rec.fnar_message_48_flag ,
x_fnar_message_50 =>c_int_data_rec.fnar_message_50_flag ,
x_fnar_message_51 =>c_int_data_rec.fnar_message_51_flag ,
x_fnar_message_52 =>c_int_data_rec.fnar_message_52_flag ,
x_fnar_message_53 =>NULL ,
x_fnar_message_56 =>c_int_data_rec.fnar_message_56_flag ,
x_fnar_message_57 =>c_int_data_rec.fnar_message_57_flag ,
x_fnar_message_58 =>c_int_data_rec.fnar_message_58_flag ,
x_fnar_message_59 =>c_int_data_rec.fnar_message_59_flag ,
x_fnar_message_60 =>c_int_data_rec.fnar_message_60_flag ,
x_fnar_message_61 =>c_int_data_rec.fnar_message_61_flag ,
x_fnar_message_62 =>c_int_data_rec.fnar_message_62_flag ,
x_fnar_message_63 =>c_int_data_rec.fnar_message_63_flag ,
x_fnar_message_64 =>c_int_data_rec.fnar_message_64_flag ,
x_fnar_message_65 =>c_int_data_rec.fnar_message_65_flag ,
x_fnar_message_71 =>c_int_data_rec.fnar_message_71_flag ,
x_fnar_message_72 =>c_int_data_rec.fnar_message_72_flag ,
x_fnar_message_73 =>c_int_data_rec.fnar_message_73_flag ,
x_fnar_message_74 =>c_int_data_rec.fnar_message_74_flag ,
x_fnar_message_75 =>c_int_data_rec.fnar_message_75_flag ,
x_fnar_message_76 =>c_int_data_rec.fnar_message_76_flag ,
x_fnar_message_77 =>c_int_data_rec.fnar_message_77_flag ,
x_fnar_message_78 =>c_int_data_rec.fnar_message_78_flag ,
x_fnar_mesg_10_stu_fam_mem =>c_int_data_rec.fnar_mesg_10_stu_fam_mem_num ,
x_fnar_mesg_11_stu_no_in_coll =>c_int_data_rec.fnar_mesg_11_stu_no_in_col_num ,
x_fnar_mesg_24_stu_avail_inc =>c_int_data_rec.fnar_mesg_24_stu_avail_inc_amt ,
x_fnar_mesg_26_stu_taxes =>c_int_data_rec.fnar_mesg_26_stu_taxes_amt ,
x_fnar_mesg_33_stu_home_value =>c_int_data_rec.fnar_mesg_33_stu_home_val_amt ,
x_fnar_mesg_34_stu_home_value =>c_int_data_rec.fnar_mesg_34_stu_home_val_amt ,
x_fnar_mesg_34_stu_home_equity =>c_int_data_rec.fnar_mesg_34_stu_home_equ_amt ,
x_fnar_mesg_35_stu_home_value =>c_int_data_rec.fnar_mesg_35_stu_home_val_amt ,
x_fnar_mesg_35_stu_home_equity =>c_int_data_rec.fnar_mesg_35_stu_home_equ_amt ,
x_fnar_mesg_36_stu_home_equity =>c_int_data_rec.fnar_mesg_36_stu_home_equ_amt ,
x_fnar_mesg_48_par_fam_mem =>c_int_data_rec.fnar_mesg_48_par_fam_mem_num ,
x_fnar_mesg_49_par_no_in_coll =>c_int_data_rec.fnar_mesg_49_par_no_in_col_num ,
x_fnar_mesg_56_par_agi =>c_int_data_rec.fnar_mesg_56_par_agi_amt ,
x_fnar_mesg_62_par_taxes =>c_int_data_rec.fnar_mesg_62_par_taxes_amt ,
x_fnar_mesg_73_par_home_value =>c_int_data_rec.fnar_mesg_73_par_home_val_amt ,
x_fnar_mesg_74_par_home_value =>c_int_data_rec.fnar_mesg_74_par_home_val_amt ,
x_fnar_mesg_74_par_home_equity =>c_int_data_rec.fnar_mesg_74_par_home_equ_amt ,
x_fnar_mesg_75_par_home_value =>c_int_data_rec.fnar_mesg_75_par_home_val_amt ,
x_fnar_mesg_75_par_home_equity =>c_int_data_rec.fnar_mesg_75_par_home_equ_amt ,
x_fnar_mesg_76_par_home_equity =>c_int_data_rec.fnar_mesg_76_par_home_equ_amt ,
x_assumption_message_1 =>c_int_data_rec.assumption_message_1_flag ,
x_assumption_message_2 =>c_int_data_rec.assumption_message_2_flag ,
x_assumption_message_3 =>c_int_data_rec.assumption_message_3_flag ,
x_assumption_message_4 =>c_int_data_rec.assumption_message_4_flag ,
x_assumption_message_5 =>c_int_data_rec.assumption_message_5_flag ,
x_assumption_message_6 =>c_int_data_rec.assumption_message_6_flag ,
x_record_mark => NULL ,
x_fnar_message_55 => c_int_data_rec.fnar_message_55_flag ,
x_fnar_message_49 => c_int_data_rec.fnar_message_49_flag ,
x_opt_par_cola_adj_ind => c_int_data_rec.option_par_cola_adj_flag ,
x_opt_par_stu_fa_assets_ind => c_int_data_rec.option_par_stu_fa_assets_flag ,
x_opt_par_ipt_assets_ind => c_int_data_rec.option_par_ipt_assets_flag ,
x_opt_stu_ipt_assets_ind => c_int_data_rec.option_stu_ipt_assets_flag ,
x_opt_par_cola_adj_value => c_int_data_rec.option_par_cola_adj_value,
x_opt_ind_stu_ipt_assets_flag => c_int_data_rec.option_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num => c_int_data_rec.cust_parent_cont_adj_num,
x_custodial_parent_num => c_int_data_rec.custodial_parent_num,
x_cust_par_base_prcnt_inc_amt => c_int_data_rec.cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt => c_int_data_rec.cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt => c_int_data_rec.cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt => c_int_data_rec.cust_par_base_tot_cont_amt,
x_cust_par_opt_prcnt_inc_amt => c_int_data_rec.cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt => c_int_data_rec.cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt => c_int_data_rec.cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt => c_int_data_rec.cust_par_opt_cont_ast_amt,
x_parents_email_txt => c_int_data_rec.parents_email_txt,
x_parent_1_birth_date => c_int_data_rec.parent_1_birth_date,
x_parent_2_birth_date => c_int_data_rec.parent_2_birth_date
);
END fnar_insert_row;
p_delete_flag IN VARCHAR2 ) IS
/*
|| Created By : masehgal
|| Created On : 28-May-2003
|| Purpose : Logs all the Input Parameters
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
-- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
SELECT batch_desc, batch_type
FROM igf_ap_li_bat_ints
WHERE batch_num = cp_batch_num ;
SELECT message_text
FROM fnd_new_messages
WHERE message_name = cp_message_name;
l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
FETCH c_get_message INTO l_delete_flag_prmpt;
l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
SELECT LOOKUP_CODE
FROM IGF_AW_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = p_lookup_type
AND SYS_AWARD_YEAR =p_award_year
AND enabled_flag = 'Y' ;
SELECT meaning
FROM igf_lookups_view
WHERE lookup_code=p_lookup_code
AND lookup_type = p_lookup_type
AND enabled_flag = 'Y' ;
SELECT meaning
FROM igf_lookups_view
WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
AND lookup_code =p_lookup_code
AND enabled_flag = 'Y' ;
SELECT TRANSLATE (pv_ssn,'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ`~!@#$%^&*_+=-,./?><():; ','1234567890')
SELECT alternate_code
FROM igs_ca_inst
WHERE cal_type = cp_ci_cal_type
AND sequence_number = cp_ci_sequence_number ;
SELECT award_year_status_code, sys_award_year
FROM igf_ap_batch_aw_map map
WHERE map.ci_cal_type = p_ci_cal_type
AND map.ci_sequence_number = p_ci_sequence_number ;
SELECT meaning
FROM igf_aw_lookups_view
WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
AND lookup_code =p_lookup_code
AND enabled_flag = 'Y' ;
SELECT BATCH_YEAR batch_year ,
AWARD_YEAR_STATUS_CODE ,
CSS_ACADEMIC_YEAR,
SYS_AWARD_YEAR
FROM IGF_AP_BATCH_AW_MAP
WHERE CI_CAL_TYPE = p_ci_cal_type
AND CI_SEQUENCE_NUMBER = p_ci_sequence_number;
SELECT im.css_id_number transaction_num
FROM igf_ap_css_profile im
WHERE im.base_id = p_base_id
AND im.css_id_number = p_css_id_number
AND im.stu_record_type = p_stu_record_type
AND rownum = 1 ;
SELECT 'SSN' rec_type,
api.pe_person_id person_id
FROM igs_pe_alt_pers_id api,
igs_pe_person_id_typ pit
WHERE api.person_id_type = pit.person_id_type
AND pit.s_person_id_type = 'SSN'
AND sysdate between api.start_dt AND NVL(api.end_dt,sysdate)
AND api.api_person_id_uf = lv_ssn ;
l_update VARCHAR2(2);
l_update := NULL;
UPDATE igf_ap_li_css_ints
SET IMPORT_STATUS_TYPE='E'
WHERE ROWID = c_int_data_rec.ROW_ID ;
css_insert_row( c_int_data_rec,lv_fa_base_id,p_cssp_id);
fnar_insert_row(c_int_data_rec ,p_cssp_id);
UPDATE igf_ap_li_css_ints
SET import_status_type='I'
WHERE ROWID = c_int_data_rec.row_id ;
UPDATE igf_ap_css_interface
SET RECORD_STATUS = 'MATCHED'
WHERE ROWID = c_int_data_rec.row_id ;
l_debug_str := l_debug_str || lv_person_number || ' PROFILE Record updated ';
UPDATE igf_ap_li_css_ints
SET import_status_type='E'
WHERE ROWID = c_int_data_rec.row_id ;