Dataset and model directory

Source families, folders and representative outputs. Use this directory to find candidates, then read each model's description, SQL and tests.

The data lesson explains the source families and identifiers. Finding models explains how to judge whether a candidate fits your question. Names below are examples, not a complete or automatically updated catalogue.

Common outputs

What the project creates	Models to recognise	What they provide
Person spines and descriptive dimensions	`dim_person_demographics`, `dim_person_demographics_historical`, `dim_person_pseudo`	Current and historical OLIDS demographics, registration, geography, and the bridge used where cross-dataset linkage is available
Clinical populations	`fct_person_*_register`	Reusable definitions of diabetes, asthma, COPD, CKD and other clinical registers, with the evidence behind membership
Condition histories	`fct_person_condition_episodes`	Diagnosis-based episodes with start and end dates, including repeated cycles where a condition can resolve and recur
Latest clinical states	`int_*_latest`	One selected HbA1c, blood pressure, eGFR, smoking status or other qualifying result per person
Activity facts	`fct_person_sus_*_recent`, `fct_person_gp_recent`	Recent urgent care, admitted care, outpatient and GP activity at a documented person grain
Waiting-list facts and summaries	`int_wl_current`, `fct_person_wl_current_count_*`, `fct_provider_wl_current_count_total`	The current open-pathway population and supported counts by person, provider and treatment function
Wide analytical marts	`person_month_analysis_base`, `obt_person_activity`, `fct_person_resource_index`	Person-month population-health history and other related reporting facts composed at convenient analytical grains
Data-quality outputs	`dq_*`	Records that fail a documented quality expectation and need investigation rather than ordinary analysis
Products for named uses	`models/published/`	Tables and views composed for specific dashboards, reports, extracts and operational processes

OLIDS model folders

Folder	What it holds	Example
`modelling/olids/observations`	Clinical measurements as `_all`/`_latest` pairs	`int_hba1c_latest`
`modelling/olids/medications`	Drug-class order histories and polypharmacy	`int_statin_medications_all`
`modelling/olids/diagnoses`	Diagnosis and resolution evidence per condition	`int_diabetes_diagnoses_all`
`modelling/olids/person_attributes`	Ethnicity, smoking, housebound, registrations	`int_ethnicity_all`
`modelling/olids/risk_stratification`	Frailty and case-management scores	`int_efi2_scores`
`modelling/olids/programme/*`	Programme logic composing the shared blocks (including immunisations, screening, LTC case-finding, SMI…)	`programme/flu`
`reporting/olids/person_demographics`	The person spine, current and historical	`dim_person_demographics`
`reporting/olids/person_status`	Care home, housebound, carer, opt-out and other statuses	`dim_person_care_home`
`reporting/olids/disease_registers`	QOF registers, each with a `pit_` point-in-time twin, further registers, condition episodes	`fct_person_diabetes_register`
`reporting/olids/measures`	Care-process and control measures	`fct_person_bp_control`
`reporting/olids/data_quality`	Records failing a documented quality expectation	`dq_hba1c_issues`
`reporting/olids/person_analytics`	The person-month analysis mart	`person_month_analysis_base`

OLIDS search patterns

What you need	Search for	Example
Every recorded value of a measurement	`int_*_all`	`int_hba1c_all`
The latest qualifying value per person	`int_*_latest`	`int_egfr_latest`
Medication orders for a drug class	`int_*_medications_all`	`int_sglt2_medications_all`
Diagnosis evidence for a condition	`int_*_diagnoses_all`	`int_ckd_diagnoses_all`
Current register membership	`fct_person_*_register`	`fct_person_diabetes_register`
A register as at a reference date	`pit_*_register`	`pit_diabetes_register`
A person attribute or status	`dim_person_*`	`dim_person_care_home`
Records failing a quality expectation	`dq_*`	`dq_hba1c_issues`

Commissioning source folders

Folder	What we use it for	Examples downstream
`sus`	Admitted care, outpatients and urgent and emergency care	`fct_person_sus_apc_recent`, `fct_person_sus_op_recent`, `fct_person_sus_uec_recent`
`wl`	Referral-to-treatment waiting-list snapshots	`int_wl_current`, `fct_provider_wl_current_count_total`
`epd`	Primary-care prescribing in the English Prescribing Dataset	Practice- and organisation-level prescribing analysis
`csds`	Community services referrals, contacts and activity	Community-service pathway and activity models
`mhsds`	Mental-health referrals, contacts, spells and ward stays	Mental-health pathway and activity models
`slam`	Provider contract-monitoring activity and actual costs from cumulative submissions	`int_cost_index_slam_activity_monthly`, `fct_person_resource_index`
`ers`	NHS e-Referral Service referrals and actions	Referral models linked through UBRN and person keys
`asc_cld`	Adult social care client-level records	Adult social care analysis

Commissioning model folders

Folder	What it holds	Examples
`modelling/commissioning/encounters`	SUS, CSDS and MHSDS activity standardised into encounters and spells — including merging and imputing admitted-patient spells	`int_sus_apc_merged_spells` `int_csds_encounters` `int_mhsds_spell_encounters`
`modelling/commissioning/demographics`	A person view assembled from PDS and other national datasets	`int_person_pmi_combined` `int_person_pds_demographics`
`modelling/commissioning/activities`	Named activity groupings defined once	`int_comm_ambulatory_sensitive_nel` `int_comm_cancer` `int_comm_maternity`
`modelling/commissioning/cost_index`	Monthly costed activity per person across the activity feeds	`int_person_cost_index_actual_monthly` `int_cost_index_csds_activity_monthly` `int_cost_index_mhsds_activity_monthly`
`reporting/commissioning/person_level`	Person-grain recent-activity facts and current waiting-list counts	`fct_person_sus_apc_recent` `fct_person_gp_recent` `fct_person_wl_current_count_total`
`reporting/commissioning/events`	Event-grain wide tables for admitted, outpatient and emergency care	`obt_encounter_apc` `obt_encounter_uec` `obt_appointment_op`
`reporting/commissioning/person_history`	Monthly person-level activity history	`fct_person_activity_by_month`
`reporting/commissioning/resource_index`	Actual versus expected resource use, with area, deprivation and borough breakdowns	`fct_person_resource_index` `fct_resource_index_by_area` `fct_resource_index_by_imd_quintile`