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,
  "sample_after_cleaning" BIGINT,
  "depressive_episode" BIGINT,
  "recurrent_depressive_disorder_persistent_mood_disorder_cca827ad" BIGINT,
  "phobic_anxiety_disorders_other_anxiety_disorders_obses_7b39fd8d" BIGINT,
  "reaction_to_severe_stress_and_adjustment_disorders" BIGINT,
  "n__admitted_to_hospital_within_1_day_of_notification" DOUBLE,
  "median_wait_from_notification_to_admission_hours" DOUBLE,
  "voluntary_admission" DOUBLE,
  "admission_under_mental_health_act" DOUBLE,
  "planned_admission" DOUBLE,
  "transfer_from_acute_hospital" DOUBLE,
  "transfer_from_another_inpatient_mh_service" DOUBLE,
  "emergency_via_crisis_resolution_home_treatment_team" DOUBLE,
  "emergency_via_community_camhs_or_community_mental_health" DOUBLE,
  "emergency_via_emergency_department" DOUBLE,
  "admitted_via_section_136_135_from_a_health_based_place_24284e4b" DOUBLE,
  "police_custody" DOUBLE,
  "other_type_of_admission" DOUBLE,
  "admission_type_unknown_not_documented" DOUBLE,
  "date_and_time_of_the_notification_of_the_need_for_a_be_98da2ccd" BIGINT,
  "time_of_admission_unknown_not_documented" BIGINT,
  "assessment_included_history_of_trauma" BIGINT,
  "assessment_included_past_response_to_treatment" BIGINT,
  "assessment_included_details_of_employment_education" BIGINT,
  "assessment_included_difficulties_relating_to_financial_121bcd32" BIGINT,
  "assessment_included_information_about_dependents" BIGINT,
  "assessment_included_difficulties_relating_to_social_situation" BIGINT,
  "bmi_screened" BIGINT,
  "percentage_requiring_a_weight_intervention_and_offered_one" BIGINT,
  "smoking_status_screened" BIGINT,
  "percentage_requiring_a_smoking_intervention_and_offered_one" BIGINT,
  "alcohol_consumption_screened" BIGINT,
  "percentage_requiring_an_alcohol_intervention_and_offered_one" BIGINT,
  "substance_misuse_screened" BIGINT,
  "percentage_requiring_an_substance_misuse_intervention__42a61dbf" BIGINT,
  "percentage_where_identified_family_member_friend_or_ca_5b4de7c2" BIGINT,
  "identified_carer_was_offered_information_and_or_support" BIGINT,
  "identified_carer_was_offered_a_carer_s_assessment" BIGINT,
  "service_user_had_a_care_plan" BIGINT,
  "care_plan_was_jointly_developed" BIGINT,
  "service_user_given_a_copy_of_care_plan" BIGINT,
  "care_plan_included_a_documented_review_date" BIGINT,
  "percentage_prescribed_at_least_one_psychotropic_medication" BIGINT,
  "service_user_given_verbal_and_or_written_information_a_5c454cb9" BIGINT,
  "medication_was_reviewed_prior_to_discharge" BIGINT,
  "medication_review_included_response_to_medication" BIGINT,
  "medication_review_included_side_effects" BIGINT,
  "percentage_referred_to_psychological_therapy" BIGINT,
  "percentage_out_of_those_eligible_referred_to_a_nice_re_66341922" VARCHAR,
  "referred_to_nhs_secondary_care" BIGINT,
  "referred_to_iapt" BIGINT,
  "referred_to_third_sector" BIGINT,
  "referred_to_private_sector" BIGINT,
  "referred_to_other" BIGINT,
  "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_chose_not_t_51e209e1" VARCHAR,
  "reason_for_not_starting_individual_therapy_not_able_to_bc22f5e9" VARCHAR,
  "reason_for_not_starting_individual_therapy_referral_no_499fef3f" VARCHAR,
  "reason_for_not_starting_individual_therapy_unknown_not_4e435ec3" VARCHAR,
  "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_chose_not_to_participate" VARCHAR,
  "reason_for_not_starting_group_therapy_not_able_to_participate" VARCHAR,
  "reason_for_not_starting_group_therapy_referral_not_app_87d16226" VARCHAR,
  "reason_for_not_starting_group_therapy_unknown_not_documented" VARCHAR,
  "discharge_letter_sent_to_gp_when_gp_recorded" BIGINT,
  "percentage_of_discharge_letters_sent_to_the_gp_within__d9d915b8" BIGINT,
  "discharge_letter_contained_contact_details_for_the_tea_fd197ea0" BIGINT,
  "discharge_letter_contained_medications_including_dosag_fd0638e6" BIGINT,
  "discharge_letters_contained_details_of_risk_to_and_fro_5295f0f6" BIGINT,
  "percentage_of_service_users_given_24_hours_notice_of_discharge" BIGINT,
  "percentage_of_carer_s_given_24_hours_notice_of_discharge" BIGINT,
  "percentage_of_service_users_who_received_a_follow_up" BIGINT,
  "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_young_people_assessed_using_the_children_8bbe2095" VARCHAR,
  "percentage_of_adults_assessed_using_the_health_of_the__a6b15f75" BIGINT
);