MDW - Discover Metadata Catalogue

MDW Discover  > Alcohol dependence @ 1357

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-collections/alcohol-dependence

Number of distinct individuals in the dataset

Total number of events/records in the dataset

HDR UK

Provider Submitted: The date on which the patient was referred to the ACT

ACT_REFERRAL_DATE

Provider Submitted: Source of the referral to the ACT

ACT_REFERRAL_SOURCE

Provider Submitted: The date and time of the activity for the current episode of care (i.e. the one which lead to the patients inclusion in this submission)

ACTIVITY_DATETIME

Provider Submitted: Whether the patient was assessed for alcohol risk using a validated tool: such as AUDIT/AUDIT-C  FAST

ALCOHOL_RISKASSESSMENT

AGEM Derived: Internal field to identify individual loads.

AuditId

Provider Submitted: Whether the patient was formally referred to continue treatment in community alcohol services

CAS_REFERRAL_INDICATOR

Provider Submitted: For patients formally referred to continue treatment in community alcohol services  whether this was their first referral and if not if they are already on the caseload

CAS_REFERRAL_STATUS

NHSE Derived: Clinical Commissioning Group covering the area in which the patient&rsquo;s GP Practice falls. ODS code format.

CCG_OF_REGISTRATION

NHSE Derived: Clinical Commissioning Group covering the area in which the patient&rsquo;s postcode falls. ODS code format.

CCG_OF_RESIDENCE

AGEM Derived: Derived age based on BIRTHDATE. Calculated using the patient&#039;s date of birth and the ACTIVITY_DATETIME

Der_Age_at_CDS_Activity_date

AGEM Derived: Derived age in weeks based on BIRTHDATE. Calculated using the patient&#039;s date of birth and the ACTIVITY_DATETIME

Der_AgeWks_at_CDS_Activity_date

AGEM Derived: The code of the CCG where the patient&#039;s postcode of usual address is based  unless the given postcode is ZZ99 3VZ (no fixed abode)  ZZ99 3WZ (address not known) or ZZ99 3CZ (England UK - not specified)  in which case NULL is given. Uses POSTCODE OF USUAL ADDRESS

Der_Postcode_CCG_Code

AGEM Derived: The code of the constituency where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_Constituency_Code

AGEM Derived: The code of the district unitary authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_Dist_Unitary_Auth

AGEM Derived: The code of the electoral Ward where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_Electoral_Ward

AGEM Derived: The code of the local authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_Local_Auth

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2001 census. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_LSOA_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2001 census. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_MSOA_Code

AGEM Derived: The code of the primary care trust (PCT) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of PCT geographies as of closure date (31st March 2013). Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_PCT_Code

AGEM Derived: Derived postcode sector based upon the patient&#039;s postcode. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_Sector

AGEM Derived: The code of the CCG where the patient&#039;s postcode of usual address is based  unless the given postcode is ZZ99 3VZ (no fixed abode)  ZZ99 3WZ (address not known) or ZZ99 3CZ (England UK - not specified)  in which case NULL is given. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_CCG_Code

AGEM Derived: The code of the constituency where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_Constituency_Code

AGEM Derived: The code of the district unitary authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_Dist_Unitary_Auth

AGEM Derived: The code of the electoral Ward where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_Electoral_Ward

AGEM Derived: The code of the local authority where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_Local_Auth

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2001 census. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_LSOA_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2001 census. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_MSOA_Code

AGEM Derived: The code of the primary care trust (PCT) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of PCT geographies as of closure date (31st March 2013). Uses POSTCODE_TRACED derived by NHSE. ADDRESS.

Der_PostCode_Traced_PCT_Code

AGEM Derived: Derived postcode sector based upon the patient&#039;s postcode. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_Sector

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2011 census. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_yr2011_LSOA

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2011 census. Uses POSTCODE_TRACED derived by NHSE.

Der_PostCode_Traced_yr2011_MSOA

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2011 census. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_yr2011_LSOA

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based  derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2011 census. Uses POSTCODE OF USUAL ADDRESS.

Der_Postcode_yr2011_MSOA

AGEM Derived: Internal processing data item used to allocate / disseminate activity to clients.

DerCustomerAll

DerRfaRecipientAll

Provider Submitted: The unique identifier for the Emergency Care Patient Attendance at which an alcohol dependence assessment took place

EC_ATTENDANCE_ID

Provider Submitted: The ethnic identity of a person as reported by them

ETHNICITY

Provider Submitted: The date on which the first contact was made with the ACT. Format CCYY-MM-DD

FIRSTCONTACT_DATE

Provider Submitted: The gender of a person as reported by them

GENDER

NHSE Derived: From MPS  the GP Practice that the patient is registered at. ODS code format.

GP_PRACTICE_CODE_TRACED

Provider Submitted: The unique identifier for the Hospital Provider Spell within which an alcohol dependence assessment took place

HOSPITAL_SPELL_ID

NHSE Derived: Integrated Care System covering the area in which the patient&rsquo;s GP Practice falls. ODS code format. This will be null until at least April 2022 when ICS organisations are rolled out.

ICS_OF_REGISTRATION

NHSE Derived: Integrated Care System covering the area in which the patient&rsquo;s postcode falls. ODS code format. This will be null until at least April 2022 when ICS organisations are rolled out.

ICS_OF_RESIDENCE

Provider Submitted: The number of interactions (or times seen) that the patient has had with the ACT within the current episode with the ACT

INTERACTION_COUNT

Provider Submitted: Whether the ACT intervention has been deemed to have prevented an inpatient emergency admission for the patient

IP_EMERGENCYADMISSIONPREVENTED

NHSE Derived: Local Authority covering the area in which the patient&rsquo;s GP Practice falls. ODS code format.

LA_OF_REGISTRATION

NHSE Derived: Local Authority covering the area in which the patient&rsquo;s postcode falls. ODS code format.

LA_OF_RESIDENCE

NHSE Derived: Lower Super Output Area (lowest level without being disclosive) covering the area in which the patient&rsquo;s GP Practice falls.. ODS code format.

LSOA_OF_REGISTRATION

NHSE Derived: Lower Super Output Area (lowest level without being disclosive) covering the area in which the patient&rsquo;s postcode falls. ODS code format.

LSOA_OF_RESIDENCE

Provider Submitted: Whether the patient required Medically Assisted Withdrawal (MAW)

MAW_INDICATOR

Provider Submitted: Whether the patient completed Medically Assisted Withdrawal (MAW)  in which setting and whether it was under the supervision of the ACT

MAW_SETTING_AND_STATUS

Provider Submitted: Whether the patient is new to the ACT team

NEWTOSERVICE

Provider Submitted: ODS code for the provider submitting the data

ODS_CODE

Provider Submitted: ODS name of the provider submitting the data

ODS_NAME

Provider Submitted: The unique identifier for the outpatient attendance  at which an alcohol dependence assessment took place

OP_ATTENDANCE_ID

AGEM Derived: This is the customer specific pseudo NHS Number. This can be named slightly different depending on customer. If no NHS Number is present or the NHS Number is invalid then this data item will be empty.

Pseudo_NHS_Number (or client equivalent)

AGEM Derived: Internal field to create a unique ID key for each record

RecordID

Provider Submitted: The Month that the data is being collected for. Value is formatted as: AlcoholDependence-MM-YYYY

REPORTING_PERIOD

Provider Submitted: The ODS code of the hospital site where the service is being delivered

SITE_CODE

NW_DME.Alcohol.AlcoholDependenceRecord

Provider Submitted: Number of patients not assessed for alcohol dependence when attending Emergency Care

PATIENTSASSESSED_EC_NOTASSESSED

Provider Submitted: Number of patients assessed for alcohol dependence when attending Emergency Care  where a negative dependence was identified

PATIENTSASSESSED_EC_YESNEGATIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending Emergency Care  where a positive dependence was identified

PATIENTSASSESSED_EC_YESPOSITIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending Emergency Care  where a possible dependence was identified

PATIENTSASSESSED_EC_YESPOSSIBLE

Provider Submitted: Number of patients not assessed for alcohol dependence when attending an Inpatient Spell

PATIENTSASSESSED_IP_NOTASSESSED

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Inpatient Spell  where a negative dependence was identified

PATIENTSASSESSED_IP_YESNEGATIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Inpatient Spell  where a positive dependence was identified

PATIENTSASSESSED_IP_YESPOSITIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Inpatient Spell  where a possible dependence was identified

PATIENTSASSESSED_IP_YESPOSSIBLE

Provider Submitted: Number of patients not assessed for alcohol dependence when attending an Outpatient Attendance

PATIENTSASSESSED_OP_NOTASSESSED

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Outpatient Attendance  where a negative dependence was identified

PATIENTSASSESSED_OP_YESNEGATIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Outpatient Attendance  where a positive dependence was identified

PATIENTSASSESSED_OP_YESPOSITIVE

Provider Submitted: Number of patients assessed for alcohol dependence when attending an Outpatient Attendance  where a possible dependence was identified

PATIENTSASSESSED_OP_YESPOSSIBLE

Provider Submitted: The Month that the data is being collected for. Value is text formatted as: AlcoholDependence-MM-YYYY

NW_DME.Alcohol.AlcoholDependenceSummary

The dataset collects patient-level data to monitor the impact of alcohol care teams, particularly their clinical outcomes and reduction of health inequalities. This data is used to demonstrate the NHS&#039;s compliance with commitments outlined in the alcohol Long Term Plan and inform service improvements

Alcohol dependence

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin