National Clinical Audit Of Anxiety And Depression Core Audit

CREATE TABLE national_clinical_audit_of_anxiety_and_depression_core_audit (
  "trust_code" VARCHAR,
  "trust_name" VARCHAR,
  "expected_sample" BIGINT,
  "final_case_submission" BIGINT,
  "completion_rate" BIGINT  -- Completion Rate (%),
  "sample_after_cleaning" BIGINT,
  "depressive_episode" BIGINT  -- Depressive Episode (%),
  "recurrent_depressive_disorder_persistent_mood_disorder_cca827ad" BIGINT  -- Recurrent Depressive Disorder; Persistent Mood Disorders; Other Mood Disorders (%),
  "phobic_anxiety_disorders_other_anxiety_disorders_obses_7b39fd8d" BIGINT  -- Phobic Anxiety Disorders; Other Anxiety Disorders; Obsessive Compulsive Disorders (%),
  "reaction_to_severe_stress_and_adjustment_disorders" BIGINT  -- Reaction To Severe Stress And Adjustment Disorders (%),
  "n__admitted_to_hospital_within_1_day_of_notification" DOUBLE  -- % Admitted To Hospital Within 1 Day Of Notification,
  "median_wait_from_notification_to_admission_hours" DOUBLE  -- Median Wait From Notification To Admission (hours),
  "voluntary_admission" DOUBLE  -- Voluntary Admission (%),
  "admission_under_mental_health_act" DOUBLE  -- Admission Under Mental Health Act (%),
  "planned_admission" DOUBLE  -- Planned Admission (%),
  "transfer_from_acute_hospital" DOUBLE  -- Transfer From Acute Hospital (%),
  "transfer_from_another_inpatient_mh_service" DOUBLE  -- Transfer From Another Inpatient MH Service (%),
  "emergency_via_crisis_resolution_home_treatment_team" DOUBLE  -- Emergency Via Crisis Resolution/home Treatment Team (%),
  "emergency_via_community_camhs_or_community_mental_health" DOUBLE  -- Emergency Via Community CAMHS Or Community Mental Health (%),
  "emergency_via_emergency_department" DOUBLE  -- Emergency Via Emergency Department (%),
  "admitted_via_section_136_135_from_a_health_based_place_24284e4b" DOUBLE  -- Admitted Via Section 136/135 From A Health Based Place Of Safety (%),
  "police_custody" DOUBLE  -- Police Custody (%),
  "other_type_of_admission" DOUBLE  -- Other Type Of Admission (%),
  "admission_type_unknown_not_documented" DOUBLE  -- Admission Type Unknown/not Documented (%),
  "date_and_time_of_the_notification_of_the_need_for_a_be_98da2ccd" BIGINT  -- Date And Time Of The Notification Of The Need For A Bed Unknown/not Documented (%),
  "time_of_admission_unknown_not_documented" BIGINT  -- Time Of Admission Unknown/not Documented (%),
  "assessment_included_history_of_trauma" BIGINT  -- Assessment Included History Of Trauma (%),
  "assessment_included_past_response_to_treatment" BIGINT  -- Assessment Included Past Response To Treatment (%),
  "assessment_included_details_of_employment_education" BIGINT  -- Assessment Included Details Of Employment/education (%),
  "assessment_included_difficulties_relating_to_financial_121bcd32" BIGINT  -- Assessment Included Difficulties Relating To Financial Situation (%),
  "assessment_included_information_about_dependents" BIGINT  -- Assessment Included Information About Dependents (%),
  "assessment_included_difficulties_relating_to_social_situation" BIGINT  -- Assessment Included Difficulties Relating To Social Situation (%),
  "bmi_screened" BIGINT  -- BMI Screened (%),
  "percentage_requiring_a_weight_intervention_and_offered_one" BIGINT  -- Percentage Requiring A Weight Intervention And Offered One (%),
  "smoking_status_screened" BIGINT  -- Smoking Status Screened (%),
  "percentage_requiring_a_smoking_intervention_and_offered_one" BIGINT,
  "alcohol_consumption_screened" BIGINT  -- Alcohol Consumption Screened (%),
  "percentage_requiring_an_alcohol_intervention_and_offered_one" BIGINT,
  "substance_misuse_screened" BIGINT  -- Substance Misuse Screened (%),
  "percentage_requiring_an_substance_misuse_intervention__42a61dbf" BIGINT  -- Percentage Requiring An Substance Misuse Intervention And Offered One,
  "percentage_where_identified_family_member_friend_or_ca_5b4de7c2" BIGINT  -- Percentage Where Identified Family Member, Friend Or Carer Was Recorded As Main Source Of Support,
  "identified_carer_was_offered_information_and_or_support" BIGINT  -- Identified Carer Was Offered Information And/or Support (%),
  "identified_carer_was_offered_a_carer_s_assessment" BIGINT  -- Identified Carer Was Offered A Carer's Assessment (%),
  "service_user_had_a_care_plan" BIGINT  -- Service User Had A Care Plan (%),
  "care_plan_was_jointly_developed" BIGINT  -- Care Plan Was Jointly Developed (%),
  "service_user_given_a_copy_of_care_plan" BIGINT  -- Service User Given A Copy Of Care Plan (%),
  "care_plan_included_a_documented_review_date" BIGINT  -- Care Plan Included A Documented Review Date (%),
  "percentage_prescribed_at_least_one_psychotropic_medication" BIGINT,
  "service_user_given_verbal_and_or_written_information_a_5c454cb9" BIGINT  -- Service User Given Verbal And/or Written Information About Their Medication (%),
  "medication_was_reviewed_prior_to_discharge" BIGINT  -- Medication Was Reviewed Prior To Discharge (%),
  "medication_review_included_response_to_medication" BIGINT  -- Medication Review Included Response To Medication (%),
  "medication_review_included_side_effects" BIGINT  -- Medication Review Included Side Effects (%),
  "percentage_referred_to_psychological_therapy" BIGINT,
  "percentage_out_of_those_eligible_referred_to_a_nice_re_66341922" VARCHAR  -- Percentage (out Of Those Eligible) Referred To A NICE Recommended Therapy For Their Condition,
  "referred_to_nhs_secondary_care" BIGINT  -- Referred To NHS Secondary Care (%),
  "referred_to_iapt" BIGINT  -- Referred To IAPT (%),
  "referred_to_third_sector" BIGINT  -- Referred To Third Sector (%),
  "referred_to_private_sector" BIGINT  -- Referred To Private Sector (%),
  "referred_to_other" BIGINT  -- Referred To Other (%),
  "percentage_started_individual_therapy" BIGINT,
  "percentage_not_started_individual_therapy" BIGINT,
  "percentage_unknown_if_started_individual_therapy" BIGINT,
  "reason_for_not_starting_individual_therapy_on_waiting_list" VARCHAR  -- Reason For Not Starting Individual Therapy - On Waiting List (%),
  "reason_for_not_starting_individual_therapy_chose_not_t_51e209e1" VARCHAR  -- Reason For Not Starting Individual Therapy - Chose Not To Participate (%),
  "reason_for_not_starting_individual_therapy_not_able_to_bc22f5e9" VARCHAR  -- Reason For Not Starting Individual Therapy - Not Able To Participate (%),
  "reason_for_not_starting_individual_therapy_referral_no_499fef3f" VARCHAR  -- Reason For Not Starting Individual Therapy - Referral Not Appropriate/Other (%),
  "reason_for_not_starting_individual_therapy_unknown_not_4e435ec3" VARCHAR  -- Reason For Not Starting Individual Therapy - Unknown/not Documented (%),
  "percentage_started_group_therapy" VARCHAR,
  "percentage_not_started_group_therapy" VARCHAR,
  "percentage_unknown_if_started_group_therapy" VARCHAR,
  "reason_for_not_starting_group_therapy_on_waiting_list" VARCHAR  -- Reason For Not Starting Group Therapy - On Waiting List (%),
  "reason_for_not_starting_group_therapy_chose_not_to_participate" VARCHAR  -- Reason For Not Starting Group Therapy - Chose Not To Participate (%),
  "reason_for_not_starting_group_therapy_not_able_to_participate" VARCHAR  -- Reason For Not Starting Group Therapy - Not Able To Participate (%),
  "reason_for_not_starting_group_therapy_referral_not_app_87d16226" VARCHAR  -- Reason For Not Starting Group Therapy - Referral Not Appropriate/Other (%),
  "reason_for_not_starting_group_therapy_unknown_not_documented" VARCHAR  -- Reason For Not Starting Group Therapy - Unknown/not Documented (%),
  "discharge_letter_sent_to_gp_when_gp_recorded" BIGINT  -- Discharge Letter Sent To GP When GP Recorded (%),
  "percentage_of_discharge_letters_sent_to_the_gp_within__d9d915b8" BIGINT  -- Percentage Of Discharge Letters Sent To The GP Within 24 Hours, When Known,
  "discharge_letter_contained_contact_details_for_the_tea_fd197ea0" BIGINT  -- Discharge Letter Contained Contact Details For The Team/service Responsible For The Service User’s Care (%),
  "discharge_letter_contained_medications_including_dosag_fd0638e6" BIGINT  -- Discharge Letter Contained Medications Including Dosage And Frequency (%),
  "discharge_letters_contained_details_of_risk_to_and_fro_5295f0f6" BIGINT  -- Discharge Letters Contained Details Of Risk To And From Self And/or Others (%),
  "percentage_of_service_users_given_24_hours_notice_of_discharge" BIGINT  -- Percentage Of Service Users Given 24 Hours’ Notice Of Discharge,
  "percentage_of_carer_s_given_24_hours_notice_of_discharge" BIGINT  -- Percentage Of Carer’s Given 24 Hours’ Notice Of Discharge,
  "percentage_of_service_users_who_received_a_follow_up" BIGINT  -- Percentage Of Service Users Who Received A Follow Up*,
  "percentage_face_to_face_follow_ups" BIGINT,
  "percentage_of_telephone_follow_ups" BIGINT,
  "percentage_of_service_users_followed_up_within_48_hours" BIGINT,
  "percentage_of_service_users_who_had_a_crisis_plan_at_discharge" BIGINT,
  "percentage_of_service_users_assessed_using_some_kind_o_bf16747b" BIGINT  -- Percentage Of Service Users Assessed Using Some Kind Of Standardised Assessment Measure,
  "percentage_of_young_people_assessed_using_the_children_8bbe2095" VARCHAR  -- Percentage Of Young People Assessed Using The Children’s Global Assessment Scale,
  "percentage_of_adults_assessed_using_the_health_of_the__a6b15f75" BIGINT  -- Percentage Of Adults Assessed Using The Health Of The Nation Outcome Scale (HoNOS)
);