Accommodation Tables
Accommodation Overview
The Accommodation tables contain recent information on patient housing and accommodation.
Common Fields
Each table has the following fields:
| fieldname | description |
|---|---|
| label | descriptive label of the table contents. eg 'diabetes' |
| area_id | area id for GP Practice |
| ods_code | ODS (Organisation Data Service) identifier for the GP Practice. |
| person_id | identifier of person |
| patient_id | identifier of patient at a practice |
Information format:
table name (relationship)
Measure (full title and synonyms)
The business rules syntax used to create the table with (CLUSTER ID)s and date ranges.
Table of fieldnames + description specific to the table
Additional information
status_household
Household assignment data calculated using the ASSIGN algorithm.
| Field name | Description |
|---|---|
match_status_id |
Internal ID for ASSIGN processing outcome |
match_status |
ASSIGN outcome for household residency status. One of:1 = Residency2 = Non-Residential Property3 = Imprecise Match4 = Multiple Address5 = No Match Data6 = Improbable |
property_id |
Internal database ID for property matched by ASSIGN |
patient_count |
Count of patients found at the property_id |
See Analysis: Household for more details.
Backlinks:
Household
The status_household table contains the residency for patients on 01/04/2024, as calculated using the ASSIGN algorithm developed by CEG in collaboration with the Endeavour Health charity. ASSIGN is a quality-assured and validated address-matching algorithm with a 98.6% match rate (based on a population of 1.8 million adults registered with a GP in northeast London) and a high sensitivity and positive predictive value [1]. For any provided address, ASSIGN allocates a UPRN from the Ordnance Survey Great Britain property gazetteer database AddressBase Premium. This UPRN is first pseudonymised and then converted into a property_id which is unique solely within the database. The