Exposing more columns for HES outpatient appointments data
20 May 2025
We have exposed two more columns on the outpatient appointments table from the HES data: outcome_of_attendance
and referral_request_received_date
. These are examples of data that are held in the backend database, but that had not been exposed via ehrQL. These columns were requested in the past week and are now available.
More details about these columns can be found in the HES data dictionary and the NHS data dictionary (see the spec for outcome of attendance).