National Clinical Audit Of Psychosis Data For EIP Spotlight Audit Report 2018/19

CREATE TABLE national_clinical_audit_of_psychosis_for_eip_spotlight_6be13989 (
  "organisation_id" VARCHAR,
  "trust_name" VARCHAR,
  "start_period" VARCHAR  -- Start Period*,
  "end_period" TIMESTAMP,
  "number_of_cases_requested" DOUBLE,
  "number_of_cases_submitted" DOUBLE,
  "final_sample_after_data_cleaning" DOUBLE,
  "started_treatment_in_0_2_weeks" VARCHAR  -- Started Treatment In >0-2 Weeks,
  "started_treatment_in_2_weeks" VARCHAR  -- Started Treatment In >2 Weeks,
  "proportion_of_people_with_fep_who_took_up_cbtp" VARCHAR,
  "proportion_of_people_with_fep_who_did_not_take_up_cbtp" VARCHAR,
  "proportion_of_people_with_fep_and_their_families_who_t_60b39595" VARCHAR  -- Proportion Of People With FEP And Their Families Who Took Up Family Interventions,
  "proportion_of_people_with_fep_and_their_families_who_d_a946815e" VARCHAR  -- Proportion Of People With FEP And Their Families Who Did Not Take Up Family Interventions,
  "proportion_of_people_with_fep_who_were_offered_clozapi_ee89b3e1" VARCHAR  -- Proportion Of People With FEP Who Were Offered Clozapine After Not Responding Adequately To Or Tolerating At Least Two Other Antipsychotic Drugs,
  "proportion_of_people_with_fep_who_were_not_offered_clo_ea9adf58" VARCHAR  -- Proportion Of People With FEP Who Were Not Offered Clozapine After Not Responding Adequately To Or Tolerating At Least Two Other Antipsychotic Drugs,
  "proportion_of_people_with_fep_who_were_not_in_work_who_e885c14c" VARCHAR  -- Proportion Of People With FEP Who Were Not In Work, Who Had Taken Up Supported Employment And Education Programmes,
  "proportion_of_people_with_fep_who_were_not_in_work_who_c7cd2ac9" VARCHAR  -- Proportion Of People With FEP Who Were Not In Work, Who Had Not Taken Up Supported Employment And Education Programmes,
  "proportion_of_people_with_fep_who_have_taken_up_suppor_54ab5761" VARCHAR  -- Proportion Of People With FEP Who Have Taken Up Supported Employment And Education Programmes Based On The Entire National Sample,
  "proportion_of_people_with_fep_who_have_not_taken_up_su_637ed834" VARCHAR  -- Proportion Of People With FEP Who Have Not Taken Up Supported Employment And Education Programmes Based On The Entire National Sample,
  "proportion_of_people_with_fep_who_were_screened_on_all_9ad27bb8" VARCHAR  -- Proportion Of People With FEP Who Were Screened On All Seven Physical Health Measures In The Past 12 Months,
  "proportion_of_people_with_fep_who_were_screened_on_les_ad99aae2" VARCHAR  -- Proportion Of People With FEP Who Were Screened On Less Than Seven Physical Health Measures In The Past 12 Months,
  "monitoring_of_cigarette_smoking_screening_status_resul_6dac5bd4" VARCHAR  -- Monitoring Of Cigarette Smoking: Screening Status/results Recorded,
  "monitoring_of_cigarette_smoking_screening_refused" VARCHAR  -- Monitoring Of Cigarette Smoking: Screening Refused,
  "monitoring_of_cigarette_smoking_not_recorded" VARCHAR  -- Monitoring Of Cigarette Smoking: Not Recorded,
  "monitoring_of_alcohol_consumption_screening_status_res_aad85b4e" VARCHAR  -- Monitoring Of Alcohol Consumption: Screening Status/results Recorded,
  "monitoring_of_alcohol_consumption_screening_refused" VARCHAR  -- Monitoring Of Alcohol Consumption: Screening Refused,
  "monitoring_of_alcohol_consumption_not_recorded" VARCHAR  -- Monitoring Of Alcohol Consumption: Not Recorded,
  "monitoring_of_substance_misuse_screening_status_result_60f82a18" VARCHAR  -- Monitoring Of Substance Misuse: Screening Status/results Recorded,
  "monitoring_of_substance_misuse_screening_refused" VARCHAR  -- Monitoring Of Substance Misuse: Screening Refused,
  "monitoring_of_substance_misuse_not_recorded" VARCHAR  -- Monitoring Of Substance Misuse: Not Recorded,
  "monitoring_of_bmi_screening_status_results_recorded" VARCHAR  -- Monitoring Of BMI: Screening Status/results Recorded,
  "monitoring_of_bmi_screening_refused_patient_was_pregnant" VARCHAR  -- Monitoring Of BMI: Screening Refused/patient Was Pregnant,
  "monitoring_of_bmi_not_recorded" VARCHAR  -- Monitoring Of BMI: Not Recorded,
  "monitoring_of_blood_pressure_screening_status_results_recorded" VARCHAR  -- Monitoring Of Blood Pressure: Screening Status/results Recorded,
  "monitoring_of_blood_pressure_screening_refused" VARCHAR  -- Monitoring Of Blood Pressure: Screening Refused,
  "monitoring_of_blood_pressure_not_recorded" VARCHAR  -- Monitoring Of Blood Pressure: Not Recorded,
  "monitoring_of_blood_glucose_control_screening_status_r_c55f4fea" VARCHAR  -- Monitoring Of Blood Glucose Control: Screening Status/results Recorded,
  "monitoring_of_blood_glucose_control_screening_refused__e41780ee" VARCHAR  -- Monitoring Of Blood Glucose Control: Screening Refused/patient Was Pregnant,
  "monitoring_of_blood_glucose_control_not_recorded" VARCHAR  -- Monitoring Of Blood Glucose Control: Not Recorded,
  "monitoring_of_blood_lipids_screening_status_results_recorded" VARCHAR  -- Monitoring Of Blood Lipids: Screening Status/results Recorded,
  "monitoring_of_blood_lipids_screening_refused" VARCHAR  -- Monitoring Of Blood Lipids: Screening Refused,
  "monitoring_of_blood_lipids_not_recorded" VARCHAR  -- Monitoring Of Blood Lipids: Not Recorded,
  "all_seven_physical_health_screenings_and_relevant_inte_77bdd72e" VARCHAR  -- All Seven Physical Health Screenings And Relevant Interventions Offered In The Past 12 Months,
  "not_all_seven_physical_health_screenings_and_relevant__01313566" VARCHAR  -- Not All Seven Physical Health Screenings And Relevant Interventions Offered In The Past 12 Months,
  "intervention_for_cigarette_smoking_offered_an_interven_d38f6907" VARCHAR  -- Intervention For Cigarette Smoking: Offered An Intervention And Accepted,
  "intervention_for_cigarette_smoking_offered_an_interven_9c98f79a" VARCHAR  -- Intervention For Cigarette Smoking: Offered An Intervention But Refused,
  "intervention_for_cigarette_smoking_not_offered_an_intervention" VARCHAR  -- Intervention For Cigarette Smoking: Not Offered An Intervention,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_o_660d0b9a" VARCHAR  -- Intervention For Harmful Or Hazardous Use Of Alcohol: Offered An Intervention And Accepted,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_o_d77d945b" VARCHAR  -- Intervention For Harmful Or Hazardous Use Of Alcohol: Offered An Intervention But Refused,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_n_35a6ccea" VARCHAR  -- Intervention For Harmful Or Hazardous Use Of Alcohol: Not Offered An Intervention,
  "intervention_for_substance_misuse_offered_an_intervent_4aca0c4b" VARCHAR  -- Intervention For Substance Misuse: Offered An Intervention And Accepted,
  "intervention_for_substance_misuse_offered_an_intervent_e810367f" VARCHAR  -- Intervention For Substance Misuse: Offered An Intervention But Refused,
  "intervention_for_substance_misuse_not_offered_an_intervention" VARCHAR  -- Intervention For Substance Misuse: Not Offered An Intervention,
  "intervention_for_elevated_bmi_offered_an_intervention__b70fc51d" VARCHAR  -- Intervention For Elevated BMI: Offered An Intervention And Accepted,
  "intervention_for_elevated_bmi_offered_an_intervention__8f6d73b6" VARCHAR  -- Intervention For Elevated BMI: Offered An Intervention But Refused,
  "intervention_for_elevated_bmi_not_offered_an_intervention" VARCHAR  -- Intervention For Elevated BMI: Not Offered An Intervention,
  "intervention_for_elevated_blood_pressure_offered_an_in_a54cf254" VARCHAR  -- Intervention For Elevated Blood Pressure: Offered An Intervention And Accepted,
  "intervention_for_elevated_blood_pressure_offered_an_in_5b80d264" VARCHAR  -- Intervention For Elevated Blood Pressure: Offered An Intervention But Refused,
  "intervention_for_elevated_blood_pressure_intervention__a1db500c" VARCHAR  -- Intervention For Elevated Blood Pressure: Intervention Not Needed As Repeat Test Normal,
  "intervention_for_elevated_blood_pressure_not_offered_a_35c4dbd1" VARCHAR  -- Intervention For Elevated Blood Pressure: Not Offered An Intervention,
  "intervention_for_abnormal_glucose_control_offered_an_i_37cdc58e" VARCHAR  -- Intervention For Abnormal Glucose Control: Offered An Intervention And Accepted,
  "intervention_for_abnormal_glucose_control_offered_an_i_d3fc786d" VARCHAR  -- Intervention For Abnormal Glucose Control: Offered An Intervention But Refused,
  "intervention_for_abnormal_glucose_control_not_offered__83ea3eba" VARCHAR  -- Intervention For Abnormal Glucose Control: Not Offered An Intervention,
  "proportion_of_people_with_fep_whose_carers_took_up_or__42ae2f21" VARCHAR  -- Proportion Of People With FEP Whose Carers Took Up Or Were Referred To Carer-focused Education And Support Programmes,
  "proportion_of_people_with_fep_whose_carers_did_not_tak_c3f3b712" VARCHAR  -- Proportion Of People With FEP Whose Carers Did Not Take Up Or Were Not Referred To Carer-focused Education And Support Programmes,
  "proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR  -- Proportion Of People With FEP With Clinical Outcome Measurement Data (two Or More Outcome Measures) Recorded At Least Twice,
  "proportion_of_people_with_fep_not_with_clinical_outcom_ff005257" VARCHAR  -- Proportion Of People With FEP Not With Clinical Outcome Measurement Data (two Or More Outcome Measures) Recorded At Least Twice
);