Part of Central Transformation Principles
ASCOF 2E
The proportion of people who receive long-term support who live in their home or with family.
Set period of interest using data from the latest local authority submission for that reporting period
Events beginning on or before 31/03/2024 AND ending on or after 1/04/2023 (or still open)
Import date is equal to the Import Date found in the latest submission see summary for further details.
Date of death on or after 1/04/2023 OR no date of death.
⇩
Set cohort of interest
Client type is a service user
Event type is service
Service type is one of long term support: nursing care, residential care or community
Derive age at period of interest end date see summary
⇩
Give all clients a new identifier using firstly the NHS Number when available, followed by the local authority identifier to fill any gaps wherever possible to allocate a unique ID to each client in the cohort. See summary for further details.
⇩
De-duplicate
Where clients have multiple conflicting Accommodation Status’ within the period of interest, de-duplicate based on following principles in order:
- Status on event with latest Event Start Date
- Any ‘Known’ Status selected over ‘Unknown’
- Status on event with latest Import Date
- If still conflicting Status, record as ‘Unknown’
⇩
Denominator
Count distinct number of clients in the cohort.
Count based on count of the new unique ID field.
⇩
Numerator
Of those in the denominator, count distinct number of clients in the cohort where Accommodation Status is an entry classified as being ‘Settled Accommodation’ (as per SALT definitions see summary).
Count based on count of the new unique ID field.
If client has multiple potentially conflicting accommodation status’, the status will be taken from the Event with the latest start date in the time period.
Known limitations
For 2023/24 ASCOF, this metric will be calculated from SALT and as such, will be based on the original definition, focusing on those with a Learning Disability PSR only.
From 2024/25 onwards, the indicator extends beyond Learning Disability PSR, to all clients, however it is recognised that accommodation status coverage may be limited in the initial submissions. Some local authorities have also referenced differences between reported accommodation status and support setting. Setting could be used to mitigate this however then we could lose visibility of certain groups of clients, especially those in unsettled accommodation such as hostels, refuges or rough sleeping.
Potential conflicting accommodation status/employment status for duplicate records with same event start date means status would be over-written in the analytical processing as ‘Unknown’ (please note, the source data remains unchanged, as submitted).
As with all measures, the process is reliant on LAs accurately capturing fields as per the relevant specification defined lists. Any fields necessary for the derivation that are invalid as per the CLD specification are removed from the analysis – source data will not be corrected and invalid field entries cannot be mapped to the specification. All invalid field entries are flagged and captured in the data quality reports received by LAs to highlight areas to be corrected in future submissions.
For the purposes of replicating SALT-derived ASCOF measures, which involve an age breakdown, where a client has missing age information, they would not be included as they cannot be mapped to an age band.
NHS Number is used as a unique identifier for each Client wherever possible. Where NHS number is not populated the local authority unique ID is used instead, if this can be done without compromising accuracy. In instances where no ID can be attributed to an event row without introducing the risk of either double-counting or incorrect allocation of identifiers to individuals, these event rows will be removed from the headcount (see summary of key concepts for further information).
Accommodation Status is recorded for purposes of the measure as the last Accommodation Status within the period of interest. In cases where Accommodation Status has been back-filled to all historical records at source, this may not reflect Accommodation Status as at time of activity.
Last edited: 5 June 2024 3:51 pm