MDW - Discover Metadata Catalogue

MDW Discover  > NHS Continuing Health Care (CHC) @ 1354

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-sets/continuing-health-care-data-set

Number of distinct individuals in the dataset

Average age at the start of care package users, for the last 12 months

HDR UK

AGEM Derived: Internal field to identify individual data loads.

CHC_Load_ID

NHSE Derived: A unique ID per table. This continues across reporting periods and across providers. This uniquely identifies a row of data within a table.

CHC000UniqID

Provider Submitted: Date/time this upload file was created

DateTimeDatSetCreate

AGEM Derived: Internal processing field to identify source file name.

Der_FileName

AGEM Derived: Internal processing field to identify date file was loaded.

Der_LoadDate

NHSE Derived: The date and time the file was received by the Submission Solution.

Effective_From

NHSE Derived: This is the ICB ODS CODE of the ORGANISATION taken directly from MESH file submission.

ICB_ODS_Code

Provider Submitted: This is the ORGANISATION IDENTIFIER of the ORGANISATION commissioning health care.

OrgIDComm

Provider Submitted: This is?the ORGANISATION IDENTIFIER of the ORGANISATION acting as the physical sender of a Data Set submission. This Identifier provides an audit trail where a different organisation is undertaking the submission on behalf of the provider organisation.

OrgIDSubmit

Provider Submitted: The name of the Primary Data Collection System in use by the Health Care Provider.

PrimSystemInUse

Provider Submitted: The reporting period end date to which this file refers

RPEndDate

Provider Submitted: The reporting period start date to which this file refers

RPStartDate

NHSE Derived: This is the SUB ICB LOCATION ODS CODE of the ORGANISATION taken directly from MESH file submission.

Sub_ICB_Location_ODS_Code

NHSE Derived: This is the ORGANISATION IDENTIFIER (CODE OF COMMISSIONER) of metadata from submission method

Sub_OrgIDComm

NHSE Derived: This is the ORGANISATION IDENTIFIER (CODE OF SUBMITTING ORGANISATION) and MESH inbox id of metadata from submission method

Sub_OrgIDSubmit

NHSE Derived: A total cumulative count of included records in this table following CHC post-deadline processing for use within Post deadline extracts.

Total_CHC001

Total_CHC101

Total_CHC102

Total_CHC103

NHSE Derived: Total count of rows for all included records across all the CHC extract tables that relate to this Header.

TotalRecords

NHSE Derived: A unique ID applied when original data file was uploaded to the Submission Solution.

UniqSubmissionID

NHSE Derived: An incremental month number  with month 0001 being April 1900.

Unique_MonthID

NHSE Derived: Date and time original data file was uploaded to the Submission Solution

UploadDateTime

Provider Submitted: The version number of a Data Set.

Version

NW_DME.CHC.000_Header

NHSE Derived: Age  in years  at time of death.

AgeDeathYears

NHSE Derived: Age  in years  at Reporting Period End Date.

AgeRepPeriodEndYears

NHSE Derived: Age  in years  at Reporting Period Start Date.

AgeRepPeriodStartYears

CHC001UniqID

NHSE Derived: County of patient  derived from POSTCODE OF USUAL ADDRESS and Gridall.

County

AGEM Derived: Internal processing field to identify customers.

CustomerAll

AGEM Derived: The code of the CCG (now SUB ICB) where the patient&#039;s postcode of usual address is based. Derived by linking POSTCODE OF USUAL ADDRESS to ODS reference data sourced from UKHD. POSTCODE OF USUAL ADDRESS is removed from outputs before dissemination.

Der_Postcode_CCG_Code

AGEM Derived: Derived postcode sector from the submitted postcode comprised of all characters to the left of the space in a full 8 character postcode and first character to the right of the space. Derived by linking POSTCODE OF USUAL ADDRESS to ODS reference data sourced from UKHD. POSTCODE OF USUAL ADDRESS is removed from outputs before dissemination.

Der_Postcode_Sector

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.

Der_Pseudo_NHS_Number

AGEM Derived: Internal processing field to identify recipients.

DerRfaRecipientAll

NHSE Derived: The date and time the file was received by the Submission solution.

NHSE Derived: Electoral Ward of patient  derived from POSTCODE OF USUAL ADDRESS and Gridall.

ElectoralWard

Provider Submitted: The ethnicity of a PERSON  as specified by the PERSON.

EthnicCategory

Provider Submitted: The gender of a PERSON. PERSON STATED GENDER CODE is self declared or inferred by observation for those unable to declare their PERSON STATED GENDER.

Gender

NHSE Derived: Return the IMD Quartile based on the LOWER SUPER OUTPUT AREA (RESIDENCE) 2011 (C001D18)  LSOA2011 . IMD is based on the latest available ONS IMD data.

IMDQuart

NHSE Derived: Local Authority District/Unitary Authority of patient  derived from POSTCODE OF USUAL ADDRESS and Gridall.

LADistrictAuth

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

LARegistration

Provider Submitted: This is a number used to identify a PATIENT uniquely within a Health Care Provider. It may be different from the PATIENTs casenote number and may be assigned automatically by the computer system.

LocalPatientId

NHSE Derived: 2011 Census Lower Layer Super Output Area of the GP Practice where the patient is registered  derived from POSTCODE OF REGISTERED GP PRACTICE and Gridall.

LSOARegistration2011

NHSE Derived: 2011 Census Lower Layer Super Output Area of patient  derived from POSTCODE OF USUAL ADDRESS and Gridall.

LSOAResidence2011

NHSDEthnicity

Provider Submitted: The NHS NUMBER STATUS INDICATOR of the PATIENT

NHSNumberStatus

NHSE Derived: The CCG of the patients registered GP Practice  as derived from REGISTERED GP PRACTICE ? CURRENT.

OrgIDCCGGP

NHSE Derived: The CCG of the patients residence  as derived from data item POST CODE OF USUAL ADDRESS.

OrgIDCCGRes

NHSE Derived: This is the ORGANISATION IDENTIFIER of the ORGANISATION commissioning health care.

NHSE Derived: The ICB of the patients registered GP Practice  as derived from REGISTERED GP PRACTICE ? CURRENT.

OrgIDICBGP

NHSE Derived: The ICB of the patients residence  as derived from data item POST CODE OF USUAL ADDRESS.

OrgIDICBRes

Provider Submitted: The ORGANISATION IDENTIFIER of the organisation that assigned the LOCAL PATIENT IDENTIFIER (EXTENDED).

OrgIDLocalPatientId

NHSE Derived: The Sub ICB Location of the patients registered GP Practice  as derived from REGISTERED GP PRACTICE ? CURRENT.

OrgIDSubICBLocGP

NHSE Derived: The Sub ICB Location of the patients residence  as derived from data item POST CODE OF USUAL ADDRESS.

OrgIDSubICBLocRes

NHSE Derived: Most recent record for the patient  within the CHC001MPI table  within the reporting period

PatMRecInRP

AGEM Derived: Flag to indicate leaky PCD / PID data was found in record.

PCD_Indicator

Provider Submitted: The date on which a person died or is officially deemed to have died  as recorded on the death certificate.

PersonDeathDate

NHSE Derived: Postcode District of patient derived from POSTCODE OF USUAL ADDRESS and Gridall.

PostcodeDistrict

NHSE Derived: The POSTCODE OF REGISTERED GP PRACTICE derived from REGISTERED GP PRACTICE ? CURRENT and Gridall.

PostcodeGP

NHSE Derived: Where this field is populated  it indicates the date at which the record ceased to be most recent version. The Record End Date is the Record Start Date of the successor record minus one day. The successor record will be the next submitted record in CHC001 with the same ORGANISATION IDENTIFIER (CODE OF COMMISSIONER) and PERSON ID.

RecordEndDate

NHSE Derived: This is a unique ID  which identifies each flowed patient record. The rows in the CHC001MPI and associated episode and event tables within a submission are linked via the Record Number.

RecordNumber

NHSE Derived: The first day of the month in which the record first appears.

RecordStartDate

NHSE Derived: CURRENT REGISTERED GP PRACTICE traced via PDS using NHS Number  Person Birth Date  Postcode of Usual Address

Reg_GP_Current

Provider Submitted: The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION of a PERSON  as specified by a PERSON.

ReligionCHC

Provider Submitted: The PERSON STATED SEXUAL ORIENTATION of a PERSON.

SexualOrientation

NHSE Derived: A nationally unique pseudonymised ID for the patient generated by the Master Person Service (MPS).

Token_Person_ID

NHSE Derived: A unique ID applied when original data file was uploaded to the Submission solution.

NHSE Derived: This is a flag to identify a valid NHS Number within a submission.

ValidNHSNumber_Flag

NHSE Derived: This is a flag to identify a valid Postcode within a submission.

ValidPostcode_Flag

NW_DME.CHC.001_MPI

Provider Submitted: The type of ACTIVITY for NHS Continuing Healthcare.

ActivityTypeCHC

NHSE Derived: Age  in years  at Service Referral Received Date

AgeServReferRecDateYears

Provider Submitted: This will indicate the staff group of the appropriate clinician that completed the Fast Track tool.

ApprClinicalStaffGroupFastTrack

CHC101UniqID

Provider Submitted: The date the Fast Track tool was completed by an appropriate clinician.

CHCFastTrackToolCompletionDate

Provider Submitted: Date on which the Checklist was completed.

CHCStandardChecklistCompletionDate

Provider Submitted: The date the Commissioner reached an eligibility decision for NHS Standard Continuing HealthCare.

CommEligibilityDecisionDateStandardCHC

Provider Submitted: The eligibility decision agreed by the Commissioner for NHS Standard Continuing HealthCare.

CommEligibilityDecisionOutcomeStandardCHC

Provider Submitted: The date the Commissioner eligibility decision outcome was communicated in writing to the patient for NHS Standard Continuing HealthCare.

CommEligibilityDecisionSentToPatientDateStandardCHC

Provider Submitted: This is the eligibility decision agreed by the Commissioner following the request for review.

CommReviewOutcome

Provider Submitted: This is the date NHS CHC eligibility begins for a person found eligible for NHS CHC following an independent review process.

DateEligibilityBeginsLocalResolution

Provider Submitted: The date on which the Multidisciplinary Team met with the patient to complete the Decision Support Tool for NHS Standard Continuing HealthCare.

DecSupportToolCompletionDateStandardCHC

Provider Submitted: This is the date the eligibility decision outcome following the request for PUPoC review was communicated in writing to the individual that made the request.

EligiablityDecisionSentDatePUPOC

Provider Submitted: Last date on which the individuals care was funded.

EndDateFunding

Provider Submitted: This is the end date of the period for which the individual has been found eligible.

EndDateLocalResolution

Provider Submitted: The end date of a Previously Unassessed Period of Care (PUPoC) which PUPoC request has been found eligible.

EndDatePUPOCAgreedPeriod

Provider Submitted: The end date of the PUPoC period which the Commissioner has been requested to review.

EndDatePUPOCReqPeriod

Provider Submitted: This is the date the ELIGIBILITY DECISION OUTCOME following the REQUEST FOR REVIEW was communicated in writing to the patient.

LocalResolutionDecisionSentToPatientDate

Provider Submitted: The date on which the Formal Local Resolution Meeting took place.

LocalResolutionMeetingDateFormal

Provider Submitted: The date on which the Informal Local Resolution Meeting took place.

LocalResolutionMeetingDateInformal

Provider Submitted: The recommendation of the Multidisciplinary Team once the Decision Support Tool has been completed for NHS Standard Continuing HealthCare.

MDTRecommendationStandardCHC

Provider Submitted: Setting in which the Checklist was carried out.

PatientLocationCHCChecklist

Provider Submitted: The setting of the patient at the time the Decision Support Tool was completed by the Multidisciplinary Team for NHS Standard Continuing HealthCare.

PatientSettingDecisionSupportToolStandardCHC

Provider Submitted: The date the outcome of the request for a Previously Unassessed Period of Care (PUPoC)  review was made by the CCG.

PupocDecisionMadeDate

Provider Submitted: This is the eligibility decision agreed by the CCG following the request for PUPoC review

PupocDecisionOutcome

NHSE Derived: Where this field is populated  it indicates the date at which the record ceased to be most recent version. The Record End Date is the Record Start Date of the successor record minus one day. The successor record will be the next submitted record in CHC001 with the same UNIQUE SERVICE REQUEST IDENTIFIER.

Provider Submitted: The date the Commissioner accepted the Fast Track referral.

RefAcceptedDateFastTrack

Provider Submitted: The date the referral request for NHS Standard Continuing HealthCare was discounted by the Commissioner.

RefDiscountedDateStandardCHC

Provider Submitted: The reason the referral request for NHS Standard Continuing HealthCare and Fast Track was discounted by the Commissioner.

RefDiscountReasonCHC

Provider Submitted: The date the REFERRAL REQUEST or NOTIFICATION was received by the organisation carrying out the assessment.

ReferralRequestReceivedDateCHC

NW_DME.CHC.101_Referral_Assessment_Outcome

NHS Continuing Health Care (CHC)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin