VIEW: APPS.IGF_AP_CSS_PROFILE_V

Source

View Text - Preformatted

SELECT css.row_id row_id, css.cssp_id,farv.base_id,css.active_profile, css.college_code, css.academic_year, css.stu_record_type, css.css_id_number, css.registration_receipt_date, css.registration_type, css.application_receipt_date, css.application_type, css.original_fnar_compute, css.revision_fnar_compute_date, css.electronic_extract_date, css.institutional_reporting_type, css.asr_receipt_date, css.last_name, css.first_name, css.middle_initial, css.address_number_and_street, css.city, css.state_mailing, css.zip_code, css.s_telephone_number, css.s_title, css.date_of_birth, css.social_security_number, css.state_legal_residence, css.foreign_address_indicator, css.foreign_postal_code, css.country, css.financial_aid_status, css.year_in_college, css.marital_status, css.ward_court, css.legal_dependents_other, css.household_size, css.number_in_college, css.citizenship_status, css.citizenship_country, css.visa_classification, css.tax_figures, css.number_exemptions, css.adjusted_gross_inc, css.us_tax_paid, css.itemized_deductions, css.stu_income_work, css.spouse_income_work, css.divid_int_inc, css.soc_sec_benefits, css.welfare_tanf, css.child_supp_rcvd, css.earned_income_credit, css.other_untax_income, css.tax_stu_aid, css.cash_sav_check, css.ira_keogh, css.invest_value, css.invest_debt, css.home_value, css.home_debt, css.oth_real_value, css.oth_real_debt, css.bus_farm_value, css.bus_farm_debt, css.live_on_farm, css.home_purch_price, css.hope_ll_credit, css.home_purch_year, css.trust_amount, css.trust_avail, css.trust_estab, css.child_support_paid, css.med_dent_expenses, css.vet_US, css.vet_ben_amount, css.vet_ben_months, css.stu_summer_wages, css.stu_school_yr_wages, css.spouse_summer_wages, css.spouse_school_yr_wages, css.summer_other_tax_inc, css.school_yr_other_tax_inc, css.summer_untax_inc, css.school_yr_untax_inc, css.grants_schol_etc, css.tuit_benefits, css.cont_parents, css.cont_relatives, css.p_siblings_pre_tuit, css.p_student_pre_tuit, css.p_household_size, css.p_number_in_college, css.p_parents_in_college, css.p_marital_status, css.p_state_legal_residence, css.p_natural_par_status, css.p_child_supp_paid, css.p_repay_ed_loans, css.p_med_dent_expenses, css.p_tuit_paid_amount, css.p_tuit_paid_number, css.p_exp_child_supp_paid, css.p_exp_repay_ed_loans, css.p_exp_med_dent_expenses, css.p_exp_tuit_pd_amount, css.p_exp_tuit_pd_number, css.p_cash_sav_check, css.p_month_mortgage_pay, css.p_invest_value, css.p_invest_debt, css.p_home_value, css.p_home_debt, css.p_home_purch_price, css.p_own_business_farm, css.p_business_value, css.p_business_debt, css.p_farm_value, css.p_farm_debt, css.p_live_on_farm, css.p_oth_real_estate_value, css.p_oth_real_estate_debt, css.p_oth_real_purch_price, css.p_siblings_assets, css.p_home_purch_year, css.p_oth_real_purch_year, css.p_prior_agi, css.p_prior_us_tax_paid, css.p_prior_item_deductions, css.p_prior_other_untax_inc, css.p_tax_figures, css.p_number_exemptions, css.p_adjusted_gross_inc, css.p_wages_sal_tips, css.p_interest_income, css.p_dividend_income, css.p_net_inc_bus_farm, css.p_other_taxable_income, css.p_adj_to_income, css.p_us_tax_paid, css.p_itemized_deductions, css.p_father_income_work, css.p_mother_income_work, css.p_soc_sec_ben, css.p_welfare_tanf, css.p_child_supp_rcvd, css.p_ded_ira_keogh, css.p_tax_defer_pens_savs, css.p_dep_care_med_spending, css.p_earned_income_credit, css.p_living_allow, css.p_tax_exmpt_int, css.p_foreign_inc_excl, css.p_other_untax_inc, css.p_hope_ll_credit, css.p_yr_separation, css.p_yr_divorce, css.p_exp_father_inc, css.p_exp_mother_inc, css.p_exp_other_tax_inc, css.p_exp_other_untax_inc, css.line_2_relation, css.line_2_attend_college, css.line_3_relation, css.line_3_attend_college, css.line_4_relation, css.line_4_attend_college, css.line_5_relation, css.line_5_attend_college, css.line_6_relation, css.line_6_attend_college, css.line_7_relation, css.line_7_attend_college, css.line_8_relation, css.line_8_attend_college, css.p_age_father, css.p_age_mother, css.p_div_sep_ind, css.b_cont_non_custodial_par, css.college_type_2, css.college_type_3, css.college_type_4, css.college_type_5, css.college_type_6, css.college_type_7, css.college_type_8, css.school_code_1, css.housing_code_1, css.school_code_2, css.housing_code_2, css.school_code_3, css.housing_code_3, css.school_code_4, css.housing_code_4, css.school_code_5, css.housing_code_5, css.school_code_6, css.housing_code_6, css.school_code_7, css.housing_code_7, css.school_code_8, css.housing_code_8, css.school_code_9, css.housing_code_9, css.school_code_10, css.housing_code_10, css.additional_school_code_1, css.additional_school_code_2, css.additional_school_code_3, css.additional_school_code_4, css.additional_school_code_5, css.additional_school_code_6, css.additional_school_code_7, css.additional_school_code_8, css.additional_school_code_9, css.additional_school_code_10, css.explanation_spec_circum, css.signature_student, css.signature_spouse, css.signature_father, css.signature_mother, css.month_day_completed, css.year_completed, css.age_line_2, css.age_line_3, css.age_line_4, css.age_line_5, css.age_line_6, css.age_line_7, css.age_line_8, css.a_online_signature, css.question_1_number, css.question_1_size, css.question_1_answer, css.question_2_number, css.question_2_size, css.question_2_answer, css.question_3_number, css.question_3_size, css.question_3_answer, css.question_4_number, css.question_4_size, css.question_4_answer, css.question_5_number, css.question_5_size, css.question_5_answer, css.question_6_number, css.question_6_size, css.question_6_answer, css.question_7_number, css.question_7_size, css.question_7_answer, css.question_8_number, css.question_8_size, css.question_8_answer, css.question_9_number, css.question_9_size, css.question_9_answer, css.question_10_number, css.question_10_size, css.question_10_answer, css.question_11_number, css.question_11_size, css.question_11_answer, css.question_12_number, css.question_12_size, css.question_12_answer, css.question_13_number, css.question_13_size, css.question_13_answer, css.question_14_number, css.question_14_size, css.question_14_answer, css.question_15_number, css.question_15_size, css.question_15_answer, css.question_16_number, css.question_16_size, css.question_16_answer, css.question_17_number, css.question_17_size, css.question_17_answer, css.question_18_number, css.question_18_size, css.question_18_answer, css.question_19_number, css.question_19_size, css.question_19_answer, css.question_20_number, css.question_20_size, css.question_20_answer, css.question_21_number, css.question_21_size, css.question_21_answer, css.question_22_number, css.question_22_size, css.question_22_answer, css.question_23_number, css.question_23_size, css.question_23_answer, css.question_24_number, css.question_24_size, css.question_24_answer, css.question_25_number, css.question_25_size, css.question_25_answer, css.question_26_number, css.question_26_size, css.question_26_answer, css.question_27_number, css.question_27_size, css.question_27_answer, css.question_28_number, css.question_28_size, css.question_28_answer, css.question_29_number, css.question_29_size, css.question_29_answer, css.question_30_number, css.questions_30_size, css.question_30_answer , css.creation_date, css.created_by, css.last_update_date, css.last_updated_by, css.last_update_login, farv.profile_status, farv.profile_status_date , farv.profile_fc, fnar.comp_css_dependency_status, css.system_record_type, CSS.LEGACY_RECORD_FLAG, css.coa_duration_efc_amt, css.coa_duration_num, css.p_soc_sec_ben_student_amt, css.p_tuit_fee_deduct_amt, CSS.STU_LIVES_WITH_NUM, CSS.STU_MOST_SUPPORT_FROM_NUM, CSS.LOCATION_COMPUTER_NUM FROM igf_ap_css_profile css, igf_ap_fa_base_rec farv , igf_ap_css_fnar fnar WHERE css.base_id = farv.base_id and css.cssp_id = fnar.cssp_id

View Text - HTML Formatted

SELECT CSS.ROW_ID ROW_ID
, CSS.CSSP_ID
, FARV.BASE_ID
, CSS.ACTIVE_PROFILE
, CSS.COLLEGE_CODE
, CSS.ACADEMIC_YEAR
, CSS.STU_RECORD_TYPE
, CSS.CSS_ID_NUMBER
, CSS.REGISTRATION_RECEIPT_DATE
, CSS.REGISTRATION_TYPE
, CSS.APPLICATION_RECEIPT_DATE
, CSS.APPLICATION_TYPE
, CSS.ORIGINAL_FNAR_COMPUTE
, CSS.REVISION_FNAR_COMPUTE_DATE
, CSS.ELECTRONIC_EXTRACT_DATE
, CSS.INSTITUTIONAL_REPORTING_TYPE
, CSS.ASR_RECEIPT_DATE
, CSS.LAST_NAME
, CSS.FIRST_NAME
, CSS.MIDDLE_INITIAL
, CSS.ADDRESS_NUMBER_AND_STREET
, CSS.CITY
, CSS.STATE_MAILING
, CSS.ZIP_CODE
, CSS.S_TELEPHONE_NUMBER
, CSS.S_TITLE
, CSS.DATE_OF_BIRTH
, CSS.SOCIAL_SECURITY_NUMBER
, CSS.STATE_LEGAL_RESIDENCE
, CSS.FOREIGN_ADDRESS_INDICATOR
, CSS.FOREIGN_POSTAL_CODE
, CSS.COUNTRY
, CSS.FINANCIAL_AID_STATUS
, CSS.YEAR_IN_COLLEGE
, CSS.MARITAL_STATUS
, CSS.WARD_COURT
, CSS.LEGAL_DEPENDENTS_OTHER
, CSS.HOUSEHOLD_SIZE
, CSS.NUMBER_IN_COLLEGE
, CSS.CITIZENSHIP_STATUS
, CSS.CITIZENSHIP_COUNTRY
, CSS.VISA_CLASSIFICATION
, CSS.TAX_FIGURES
, CSS.NUMBER_EXEMPTIONS
, CSS.ADJUSTED_GROSS_INC
, CSS.US_TAX_PAID
, CSS.ITEMIZED_DEDUCTIONS
, CSS.STU_INCOME_WORK
, CSS.SPOUSE_INCOME_WORK
, CSS.DIVID_INT_INC
, CSS.SOC_SEC_BENEFITS
, CSS.WELFARE_TANF
, CSS.CHILD_SUPP_RCVD
, CSS.EARNED_INCOME_CREDIT
, CSS.OTHER_UNTAX_INCOME
, CSS.TAX_STU_AID
, CSS.CASH_SAV_CHECK
, CSS.IRA_KEOGH
, CSS.INVEST_VALUE
, CSS.INVEST_DEBT
, CSS.HOME_VALUE
, CSS.HOME_DEBT
, CSS.OTH_REAL_VALUE
, CSS.OTH_REAL_DEBT
, CSS.BUS_FARM_VALUE
, CSS.BUS_FARM_DEBT
, CSS.LIVE_ON_FARM
, CSS.HOME_PURCH_PRICE
, CSS.HOPE_LL_CREDIT
, CSS.HOME_PURCH_YEAR
, CSS.TRUST_AMOUNT
, CSS.TRUST_AVAIL
, CSS.TRUST_ESTAB
, CSS.CHILD_SUPPORT_PAID
, CSS.MED_DENT_EXPENSES
, CSS.VET_US
, CSS.VET_BEN_AMOUNT
, CSS.VET_BEN_MONTHS
, CSS.STU_SUMMER_WAGES
, CSS.STU_SCHOOL_YR_WAGES
, CSS.SPOUSE_SUMMER_WAGES
, CSS.SPOUSE_SCHOOL_YR_WAGES
, CSS.SUMMER_OTHER_TAX_INC
, CSS.SCHOOL_YR_OTHER_TAX_INC
, CSS.SUMMER_UNTAX_INC
, CSS.SCHOOL_YR_UNTAX_INC
, CSS.GRANTS_SCHOL_ETC
, CSS.TUIT_BENEFITS
, CSS.CONT_PARENTS
, CSS.CONT_RELATIVES
, CSS.P_SIBLINGS_PRE_TUIT
, CSS.P_STUDENT_PRE_TUIT
, CSS.P_HOUSEHOLD_SIZE
, CSS.P_NUMBER_IN_COLLEGE
, CSS.P_PARENTS_IN_COLLEGE
, CSS.P_MARITAL_STATUS
, CSS.P_STATE_LEGAL_RESIDENCE
, CSS.P_NATURAL_PAR_STATUS
, CSS.P_CHILD_SUPP_PAID
, CSS.P_REPAY_ED_LOANS
, CSS.P_MED_DENT_EXPENSES
, CSS.P_TUIT_PAID_AMOUNT
, CSS.P_TUIT_PAID_NUMBER
, CSS.P_EXP_CHILD_SUPP_PAID
, CSS.P_EXP_REPAY_ED_LOANS
, CSS.P_EXP_MED_DENT_EXPENSES
, CSS.P_EXP_TUIT_PD_AMOUNT
, CSS.P_EXP_TUIT_PD_NUMBER
, CSS.P_CASH_SAV_CHECK
, CSS.P_MONTH_MORTGAGE_PAY
, CSS.P_INVEST_VALUE
, CSS.P_INVEST_DEBT
, CSS.P_HOME_VALUE
, CSS.P_HOME_DEBT
, CSS.P_HOME_PURCH_PRICE
, CSS.P_OWN_BUSINESS_FARM
, CSS.P_BUSINESS_VALUE
, CSS.P_BUSINESS_DEBT
, CSS.P_FARM_VALUE
, CSS.P_FARM_DEBT
, CSS.P_LIVE_ON_FARM
, CSS.P_OTH_REAL_ESTATE_VALUE
, CSS.P_OTH_REAL_ESTATE_DEBT
, CSS.P_OTH_REAL_PURCH_PRICE
, CSS.P_SIBLINGS_ASSETS
, CSS.P_HOME_PURCH_YEAR
, CSS.P_OTH_REAL_PURCH_YEAR
, CSS.P_PRIOR_AGI
, CSS.P_PRIOR_US_TAX_PAID
, CSS.P_PRIOR_ITEM_DEDUCTIONS
, CSS.P_PRIOR_OTHER_UNTAX_INC
, CSS.P_TAX_FIGURES
, CSS.P_NUMBER_EXEMPTIONS
, CSS.P_ADJUSTED_GROSS_INC
, CSS.P_WAGES_SAL_TIPS
, CSS.P_INTEREST_INCOME
, CSS.P_DIVIDEND_INCOME
, CSS.P_NET_INC_BUS_FARM
, CSS.P_OTHER_TAXABLE_INCOME
, CSS.P_ADJ_TO_INCOME
, CSS.P_US_TAX_PAID
, CSS.P_ITEMIZED_DEDUCTIONS
, CSS.P_FATHER_INCOME_WORK
, CSS.P_MOTHER_INCOME_WORK
, CSS.P_SOC_SEC_BEN
, CSS.P_WELFARE_TANF
, CSS.P_CHILD_SUPP_RCVD
, CSS.P_DED_IRA_KEOGH
, CSS.P_TAX_DEFER_PENS_SAVS
, CSS.P_DEP_CARE_MED_SPENDING
, CSS.P_EARNED_INCOME_CREDIT
, CSS.P_LIVING_ALLOW
, CSS.P_TAX_EXMPT_INT
, CSS.P_FOREIGN_INC_EXCL
, CSS.P_OTHER_UNTAX_INC
, CSS.P_HOPE_LL_CREDIT
, CSS.P_YR_SEPARATION
, CSS.P_YR_DIVORCE
, CSS.P_EXP_FATHER_INC
, CSS.P_EXP_MOTHER_INC
, CSS.P_EXP_OTHER_TAX_INC
, CSS.P_EXP_OTHER_UNTAX_INC
, CSS.LINE_2_RELATION
, CSS.LINE_2_ATTEND_COLLEGE
, CSS.LINE_3_RELATION
, CSS.LINE_3_ATTEND_COLLEGE
, CSS.LINE_4_RELATION
, CSS.LINE_4_ATTEND_COLLEGE
, CSS.LINE_5_RELATION
, CSS.LINE_5_ATTEND_COLLEGE
, CSS.LINE_6_RELATION
, CSS.LINE_6_ATTEND_COLLEGE
, CSS.LINE_7_RELATION
, CSS.LINE_7_ATTEND_COLLEGE
, CSS.LINE_8_RELATION
, CSS.LINE_8_ATTEND_COLLEGE
, CSS.P_AGE_FATHER
, CSS.P_AGE_MOTHER
, CSS.P_DIV_SEP_IND
, CSS.B_CONT_NON_CUSTODIAL_PAR
, CSS.COLLEGE_TYPE_2
, CSS.COLLEGE_TYPE_3
, CSS.COLLEGE_TYPE_4
, CSS.COLLEGE_TYPE_5
, CSS.COLLEGE_TYPE_6
, CSS.COLLEGE_TYPE_7
, CSS.COLLEGE_TYPE_8
, CSS.SCHOOL_CODE_1
, CSS.HOUSING_CODE_1
, CSS.SCHOOL_CODE_2
, CSS.HOUSING_CODE_2
, CSS.SCHOOL_CODE_3
, CSS.HOUSING_CODE_3
, CSS.SCHOOL_CODE_4
, CSS.HOUSING_CODE_4
, CSS.SCHOOL_CODE_5
, CSS.HOUSING_CODE_5
, CSS.SCHOOL_CODE_6
, CSS.HOUSING_CODE_6
, CSS.SCHOOL_CODE_7
, CSS.HOUSING_CODE_7
, CSS.SCHOOL_CODE_8
, CSS.HOUSING_CODE_8
, CSS.SCHOOL_CODE_9
, CSS.HOUSING_CODE_9
, CSS.SCHOOL_CODE_10
, CSS.HOUSING_CODE_10
, CSS.ADDITIONAL_SCHOOL_CODE_1
, CSS.ADDITIONAL_SCHOOL_CODE_2
, CSS.ADDITIONAL_SCHOOL_CODE_3
, CSS.ADDITIONAL_SCHOOL_CODE_4
, CSS.ADDITIONAL_SCHOOL_CODE_5
, CSS.ADDITIONAL_SCHOOL_CODE_6
, CSS.ADDITIONAL_SCHOOL_CODE_7
, CSS.ADDITIONAL_SCHOOL_CODE_8
, CSS.ADDITIONAL_SCHOOL_CODE_9
, CSS.ADDITIONAL_SCHOOL_CODE_10
, CSS.EXPLANATION_SPEC_CIRCUM
, CSS.SIGNATURE_STUDENT
, CSS.SIGNATURE_SPOUSE
, CSS.SIGNATURE_FATHER
, CSS.SIGNATURE_MOTHER
, CSS.MONTH_DAY_COMPLETED
, CSS.YEAR_COMPLETED
, CSS.AGE_LINE_2
, CSS.AGE_LINE_3
, CSS.AGE_LINE_4
, CSS.AGE_LINE_5
, CSS.AGE_LINE_6
, CSS.AGE_LINE_7
, CSS.AGE_LINE_8
, CSS.A_ONLINE_SIGNATURE
, CSS.QUESTION_1_NUMBER
, CSS.QUESTION_1_SIZE
, CSS.QUESTION_1_ANSWER
, CSS.QUESTION_2_NUMBER
, CSS.QUESTION_2_SIZE
, CSS.QUESTION_2_ANSWER
, CSS.QUESTION_3_NUMBER
, CSS.QUESTION_3_SIZE
, CSS.QUESTION_3_ANSWER
, CSS.QUESTION_4_NUMBER
, CSS.QUESTION_4_SIZE
, CSS.QUESTION_4_ANSWER
, CSS.QUESTION_5_NUMBER
, CSS.QUESTION_5_SIZE
, CSS.QUESTION_5_ANSWER
, CSS.QUESTION_6_NUMBER
, CSS.QUESTION_6_SIZE
, CSS.QUESTION_6_ANSWER
, CSS.QUESTION_7_NUMBER
, CSS.QUESTION_7_SIZE
, CSS.QUESTION_7_ANSWER
, CSS.QUESTION_8_NUMBER
, CSS.QUESTION_8_SIZE
, CSS.QUESTION_8_ANSWER
, CSS.QUESTION_9_NUMBER
, CSS.QUESTION_9_SIZE
, CSS.QUESTION_9_ANSWER
, CSS.QUESTION_10_NUMBER
, CSS.QUESTION_10_SIZE
, CSS.QUESTION_10_ANSWER
, CSS.QUESTION_11_NUMBER
, CSS.QUESTION_11_SIZE
, CSS.QUESTION_11_ANSWER
, CSS.QUESTION_12_NUMBER
, CSS.QUESTION_12_SIZE
, CSS.QUESTION_12_ANSWER
, CSS.QUESTION_13_NUMBER
, CSS.QUESTION_13_SIZE
, CSS.QUESTION_13_ANSWER
, CSS.QUESTION_14_NUMBER
, CSS.QUESTION_14_SIZE
, CSS.QUESTION_14_ANSWER
, CSS.QUESTION_15_NUMBER
, CSS.QUESTION_15_SIZE
, CSS.QUESTION_15_ANSWER
, CSS.QUESTION_16_NUMBER
, CSS.QUESTION_16_SIZE
, CSS.QUESTION_16_ANSWER
, CSS.QUESTION_17_NUMBER
, CSS.QUESTION_17_SIZE
, CSS.QUESTION_17_ANSWER
, CSS.QUESTION_18_NUMBER
, CSS.QUESTION_18_SIZE
, CSS.QUESTION_18_ANSWER
, CSS.QUESTION_19_NUMBER
, CSS.QUESTION_19_SIZE
, CSS.QUESTION_19_ANSWER
, CSS.QUESTION_20_NUMBER
, CSS.QUESTION_20_SIZE
, CSS.QUESTION_20_ANSWER
, CSS.QUESTION_21_NUMBER
, CSS.QUESTION_21_SIZE
, CSS.QUESTION_21_ANSWER
, CSS.QUESTION_22_NUMBER
, CSS.QUESTION_22_SIZE
, CSS.QUESTION_22_ANSWER
, CSS.QUESTION_23_NUMBER
, CSS.QUESTION_23_SIZE
, CSS.QUESTION_23_ANSWER
, CSS.QUESTION_24_NUMBER
, CSS.QUESTION_24_SIZE
, CSS.QUESTION_24_ANSWER
, CSS.QUESTION_25_NUMBER
, CSS.QUESTION_25_SIZE
, CSS.QUESTION_25_ANSWER
, CSS.QUESTION_26_NUMBER
, CSS.QUESTION_26_SIZE
, CSS.QUESTION_26_ANSWER
, CSS.QUESTION_27_NUMBER
, CSS.QUESTION_27_SIZE
, CSS.QUESTION_27_ANSWER
, CSS.QUESTION_28_NUMBER
, CSS.QUESTION_28_SIZE
, CSS.QUESTION_28_ANSWER
, CSS.QUESTION_29_NUMBER
, CSS.QUESTION_29_SIZE
, CSS.QUESTION_29_ANSWER
, CSS.QUESTION_30_NUMBER
, CSS.QUESTIONS_30_SIZE
, CSS.QUESTION_30_ANSWER
, CSS.CREATION_DATE
, CSS.CREATED_BY
, CSS.LAST_UPDATE_DATE
, CSS.LAST_UPDATED_BY
, CSS.LAST_UPDATE_LOGIN
, FARV.PROFILE_STATUS
, FARV.PROFILE_STATUS_DATE
, FARV.PROFILE_FC
, FNAR.COMP_CSS_DEPENDENCY_STATUS
, CSS.SYSTEM_RECORD_TYPE
, CSS.LEGACY_RECORD_FLAG
, CSS.COA_DURATION_EFC_AMT
, CSS.COA_DURATION_NUM
, CSS.P_SOC_SEC_BEN_STUDENT_AMT
, CSS.P_TUIT_FEE_DEDUCT_AMT
, CSS.STU_LIVES_WITH_NUM
, CSS.STU_MOST_SUPPORT_FROM_NUM
, CSS.LOCATION_COMPUTER_NUM
FROM IGF_AP_CSS_PROFILE CSS
, IGF_AP_FA_BASE_REC FARV
, IGF_AP_CSS_FNAR FNAR
WHERE CSS.BASE_ID = FARV.BASE_ID
AND CSS.CSSP_ID = FNAR.CSSP_ID