MDW - Discover Metadata Catalogue

MDW Discover  > North West London Integrated Care Record (NWL ICR) @ 1535

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

This dataset is a merged dataset of the existing datasets already published. This dataset contains all the columns made available within the individual datasets but as one large amalgamated dataset. This provides a longitudinal linked dataset of NWL patients to support pathway analysis, population health analysis and research analytics that requires data from various care settings.

HDR UK

NHS NWL ICS;,;London SDE

Long Term Conditions Electronic Frailty Index Q-Admissions Patient Segments Risk Segments

This can be linked to: Accident and Emergency Outpatient Care High Cost drugs Patient level data Primary care events Primary care prescriptions  Adult

.. important:: This field has been made **obsolete** because it was never populated in OP and EM extracts and is no longer required in SUS+ for APC. Tariff Financial Adjustment National is a part of Best Practice and in SUS+ this will be indicated in an item that shows the tariff applied. :Obsolete as of: ``v1.0#20170101``

TariffFinancialAdjustmentNational

The core HRG derived by SUS - as a result of HRG grouping - and used for tariff application.

CoreHRG

.. important:: This field has been made **obsolete** as it is not used by SUS and will not be used by SUS+ :Obsolete as of: ``v1.0#20170101``

TarrifInitialAmountLocal

A code that indicates the ethnicity of the patient, this is a value that the patients themselves specify. This field will be populated with an alphabetic value from A to Z; consult the NHS data dictionary link below for further details.

EthnicCategoryCode

This is the code of the organisation that assigned the Patient Pathway Identifier. Patient Pathway Identifiers are not necessarily unique across hospitals, the addition of the organisation code ensures uniqueness.

OrganisationCodePatientPathwayIdentifier

The count of AE Treatment codes submitted to the grouper. Each code found in the submission counts one, ie multiple instances of the same code count multiple times.

NumberAAndETreatments

The second or subsequent recorded A&E investigation. For further details on how to populate this column, please refer to the NHS Data Dictionary link below.

AAndEInvestigationSecond8

Signifies whether relevant clinical codes in the record have been cleaned before submission to grouping. For APC that should mean whether any procedure codes (OPCS) or any diagnosis codes (ICD) have been cleaned on the episode record. For OP that should mean whether any procedure codes (OPCS) have been cleaned. For EM that should mean whether any investigation codes or treatment codes have been cleaned.

CodeCleaning

This field will be populated with a string that details which of the possible tariffs has been applied as PbR Final Tariff. It also deals with identifying Best Practice tariffs.

FinalTariffApplied

One of a set of defined codes that indicates this treatment's position within a referral to treatment period or the fact that this treatment is not part of a referral to treatment measured pathway.

RTTStatus

The marital status of the patient, the Data Protection Registrar has recommended this should only be recorded for patients in psychiatric specialties. This field must be populated with an alphanumeric code; consult the NHS Data Dictionary link below for more details.

MaritalStatus

The timestamp for when the record was added to the database Presented as CCYYMMDDHHMMSSmmm, for example 20170518101226415

SUSVersion

A locally determined code used to identify the professional principally responsible for the care of a patient during an Accident and Emergency Attendance.

AAndEStaffMemberCode

An indication of whether Carer support is available to the patient at their normal residence. This does not include any paid support or support from a voluntary organisation, unless the patient is normally resident in a Care Home and care is provided by a Care Worker. The field can be populated with either: - 01 = Yes, carer support is available, or - 02 = No, carer support is not available

CarerSupportIndicator

The first recorded A&E treatment. For further details on how to populate this column, please refer to the NHS Data Dictionary link below.

AAndETreatmentFirst

The age in years of the patient derived by the sender as at the relevant CDS activity date of the CDS type.

AgeAtCDSActivityDate

The second or subsequent recorded A&E diagnosis. For further details on how to populate this column, please refer to the NHS Data Dictionary link below.

AAndEDiagnosisSecond6

Organisation Code (Residence Responsibility) is the Organisation Code derived from the patient's postcode of usual address, where they reside within the boundary of a: - Primary Care Trust (until 31 March 2013) - Clinical Commissioning Group (from 1st April 2013) - Care Trust - Local Health Board (Wales) - Scottish Health Board - Northern Ireland Local Commissioning Group: Guidance on the use of Northern Ireland codes can be found in Data Set Change Notice 19/2009 - Primary Healthcare Directorate (Isle of Man) - Local Authority.

OrganisationCodePCTOfResidence

AAndEInvestigationSecond12

The sub-total in the price calculation, including all adjustments, to which the Market Forces Factor is applied.

TariffPreMFFAdjustedNational

.. important:: This field has been made **obsolete** as spells will be created as at the point in time specified for the extract query. It was meaningful only when the available views of data were the latest or a frozen version. It previously identified the position of the spell version; reconciliation, post-reconciliation, changes between reconciliation and post-reconciliation or post-post reconciliation. :Obsolete as of: ``v1.0#20170101``

PbRSpellStatusIndicator

The second or subsequent recorded A&E treatment. For further details on how to populate this column, please refer to the NHS Data Dictionary link below.

AAndETreatmentSecond3

AAndETreatmentSecond9

.. important:: This field has been made **obsolete** as spells will be created as at the point in time specified for the extract query. It was meaningful only when the available views of data were the latest or a frozen version. :Obsolete as of: ``v1.0#20170101``

PbRSpellFrozenIndicator

Indicates if Accident and Emergency, ICD10 or Read codes are present in the following block.

DiagnosisSchemeInUse

Also known as Reason For Access (RFA). Shows why an individual user has the right to see a particular record. The organisation codes for the data items shown below will allow access based on a match with an organisation code included in the active role on the user?s smartcard. Users will specify the Reason(s) For Access they wish to use when requesting an extract. The following values are output to represent each RFA. Where more than one RFA is applicable then a concatenated string is output. - PR Prime Recipient Code - CR Copy Recipient Code - P Provider Code - C Commissioner Code (Submitted) - RESP Organisation of Responsibility Code (SUS derived) - RESI(SUS) Organisation of Residence Code (SUS derived) - RESI(INC) Organisation of Residence Code (Submitted) For example, a user from a provider will have their provider code on their smartcard, they will specify ?Provider? as their RFA for an extract and the value P will appear in this column in all records in an extract based on the same Provider Code as that on the user smartcard. Data Item: SEM_060_110_ADDRESSING_GRID. INDICATOR_VALUE

ReasonAccessProvided

Unique Spell ID following SUS Spell creation System generated value spell id, this id is consistent across all records belonging to the same spell.

SpellIdentifier

AAndEInvestigationSecond6

The date of birth of the patient the record refers to.

BirthDate

The generated unique identifier for the episode. Note: This field now contains values of up to 19 numeric characters.

GeneratedRecordID

The date on which the patient arrived in Accident and Emergency.

ArrivalDate

The date (with an associated CDS Applicable Time) of the update event (or the nearest equivalent) that resulted in the need to exchange this Commissioning Data Set.

ApplicableDateandTime

Indicates whether derivation of CCG (formerly PCT) of residence was driven by the postcode found in Personal Demographics Service (PDS) data ('P') against the submitted NHS Number or directly from the postcode value submitted ('S') as no PDS value was found. - P = PDS lookup from submitted NHS Number - S = Lookup from submitted postcode

PatientPostcodeDerivedPCTType

The Organisation Code of the Organisation acting as a Health Care Provider as issued by the Organisation Data Service (ODS). This field represents the organisation receiving payment for the associated activity. The value is the Provider Code reason for access to data held on user smart cards and is used for item 'Reason Access Provided'.

OrganisationCodeCodeOfProvider

Could also be interpreted as Age Band. - "ADU" meaning adult if the Spell Age is in the range 19 - 130 or is 999 - "CHI" meaning child if the Spell Age is in the range 0 - 18. - "ERR" in all other cases Refer to spell level field Spell Age.

PatientType

AAndETreatmentSecond8

.. important:: This field was a placeholder used by SUS against late requirements for extract specifiactions. The use of such 'spares' is being discontinued as new columns can be more easily created as required with appropriate names in SUS+. Therefore this field is being made **obsolete**. :Obsolete as of: ``v1.0#20170101``

TariffAdjustmentFutureUse1National

AAndEDiagnosisSecond2

Field: Spare {number} Convenience class to mark unused 'Spare' columns as obsolete.

Spare3

This is the submitted Site Code of Treatment and is the Organisation Code of the location where the patient was treated, i.e. it should enable the treating Organisation site to be identified. Different sites at the same provider organisation will share the same first three characters. Where activity is carried out by another provider organisation through a sub-contract or other agreement the site code belonging to this other provider should be present to show the actual location where treatment was delivered. For APC from R11 onwards this item is submitted in the Location at End of Episode group.

ProviderSiteCode

This is the date part of the timestamp applied when the interchange was received by SUS+

StagingLoadedDate

The time (HH:MM:SS) at which the patient arrived in A&E.

ArrivalTime

Defines the Start Date (for the date range of the data being exchanged) for the Bulk Replacement Update time period.

ReportPeriodStartDate

.. important:: This field has been made **obsolete** as the use of point in time queries by SUS+ means spell version date and time will be specified by the user at run time. :Obsolete as of: ``v1.0#20170101``

SpellVersionAsAtDateAndTime

TreatmentDateofSubsequentTreatments10

AAndETreatmentSecond7

The type of Accident and Emergency Department according to the activity performed. The values are: - 01 = Emergency departments are a consultant led 24 hour service with full resuscitation facilities and designated accommodation for the reception of accident and emergency patients - 02 = Consultant led mono specialty accident and emergency service (e.g. ophthalmology, dental) with designated accommodation for the reception of patients - 03 = Other type of A&E/minor injury activity with designated accommodation for the reception of accident and emergency patients. The department may be doctor led or nurse led and treats at least minor injuries and illnesses and can be routinely accessed without appointment. A service mainly or entirely appointment based (for example a GP Practice or Out-Patient Clinic) is excluded even though it may treat a number of patients with minor illness or injury. Excludes NHS walk-in centres - 04 NHS walk in centres

AAndEDepartmentType

The time (HH:MM:SS) at which the patient departed A&E.

AAndEDepartureTime

The date (with an associated CDS Extract Time) of the update event (or the nearest equivalent) that resulted in the need to exchange this Commissioning Data Set.

ExtractDate

TariffAdjustmentFutureUse1NonMandatory

AAndEDiagnosisSecond4

The organisation code of the GP Practice that the patient is registered with. The code before testing against reference files. In the event that an organisation code cannot be given, the ODS default codes must be used. The ODS default codes used are: - V81997 Used when a patient is not registered to a GP Practice but is eligible to be registered should they need to. - V81998 Used when the GP Practice code is not applicable, for example, they have only recently entered the country. - V81999 Used when it is known that the patient should be registered to a GP Practice but it is not possible to determine their GP Practice code. It can also be used if it is not known as to whether the patient should be registered to a GP Practice.

GPPracticeCodeOriginalData

TreatmentDateofSubsequentTreatments2

AAndEDiagnosisSecond9

.. important:: This field has been made **obsolete** because this organisation code type no longer exists and is not submitted. This item is no longer populated. :Obsolete as of: ``v1.0#20170101``

GPConsortiumCode

TreatmentDateofSubsequentTreatments8

.. important:: This field is marked as **obsolete** as it was applicable for SUS R7 (09/10) data only. The same information is conveyed by value '03' in 'EM Department Type' submitted as 'A and E Department Type' (It stated if the department was classified as an MIU. Indicator: 1 - MIU or 0 - Else). :Obsolete as of: ``v1.0#20170101``

AAndEDepartmentTypeMIUIndicatorDerived

The Organisation Code of the Organisation commissioning health care as issued by the Organisation Data Service (ODS) and validated against reference data. The value is the Commissioner Code reason for access to data held on user smart cards and is used for item 'Reason Access Provided'. This value is submitted by the provider organisation and is subject to change on a given record as data is updated at source and resubmitted.

CommissionerCodeOriginalData

The postcode of the address nominated by the patient.

PostcodeOfUsualAddress

AAndETreatmentSecond4

This is the primary diagnosis as submitted using ICD 10. Note: As A&E uses its own diagnosis classification it is rarely populated in this CDS and usually in support of specific indicators that are not related to payment.

ICD10PrimaryDiagnosis

AAndETreatmentSecond11

TreatmentDateofSubsequentTreatments3

This is a flag that indicates if the NHS Number of the patient has been traced by the sender against the tracing service e.g. - 01 = present and verified - 04 = trace attempted - No match or multiple match found For further examples of how this field must be populated, please consult the NHS Data Dictionary link below for details.

NHSNumberStatusIndicator

An indication of whether a patient is making first or follow-up attendance at a particular Accident and Emergency Department. The values are: - 1 = First Accident and Emergency Attendance - the first in a series, or the only attendance, in a particular Accident and Emergency Episode - 2 = Follow-up Accident and Emergency Attendance - planned: a subsequent planned attendance at the same department, and for the same incident as the first attendance. - 3 = Follow-up Accident and Emergency Attendance - unplanned: a subsequent unplanned attendance at the same department, and for the same incident as the first attendance.

AAndEAttendanceCategory

.. important:: This field has been made **obsolete** as it is a duplicate of the field GP Code (Original Data). :Obsolete as of: ``v1.0#20170101``

RegisteredGMPCode

TreatmentDateofSubsequentTreatments7

The time (HH:MM:SS) at which the attendance was concluded.

AAndEAttendanceConclusionTime

This represents the current NHS England Region code or Non-English Commissioner organisation. It is found in Organisation Data Service (ODS) data using the Clinical Commissioning Group (CCG) code associated with the patient's GP practice code registered in the Personal Demographic Service (PDS). If no entry is found on PDS then the submitted value for GP Practice is used.

SHACommissioner

This item represents the CDS Schema Version used to submit the interchange the data was carried in.

CDSSchemaVersion

The assigned EDI Address of the physical Organisation or site responsible for sending Commissioning data.

OrganisationCodeSender

.. important:: This field has been made **obsolete** as it is an unused placeholder intended for future SUS development and not required in SUS+ :Obsolete as of: ``v1.0#20170101``

ConfigurableIndicator

TariffTotalPaymentNonMandatory

The Organisation Code of the Organisation commissioning health care as issued by the Organisation Data Service (ODS) and validated against reference data. The value is the Commissioner Code reason for access to data held on user smart cards and is used for item 'Reason Access Provided'. This value is submitted by the provider organisation and is subject to change on a given record as data is updated at source and resubmitted. The code is validated against reference data.

OrganisationCodeCodeOfCommissioner

SourceItemID

AAndEDiagnosisSecond12

AAndEDiagnosisSecond11

AppliedMFFNonMandatory

CoreHRGForInformation

.. important:: This field has been made **obsolete** as it is a duplicate of item Organisation Code (Code of Commissioner) :Obsolete as of: ``v1.0#20170101`` Data Item: ORG_CODE_TYPE_COMMISSIONER

CommissionerSiteCode

AAndEInvestigationSecond2

AAndETreatmentSecond12

AAndEDiagnosisSecond10

Patient_DerivedKey

Signifies whether the record is priced under PbR or not. Normally, a record is excluded from PbR for defined reasons - see the Exclusion Reason field of the record for those reasons. Possible values are as follows: - 0: The complete spell qualifies - 1: The spell qualifies, but some episodes are excluded - 2: The spell does not qualify

SpellInPbRNotInPbR

.. important:: This field has been made **obsolete** as it was removed from the CDS schema in version 6.2. :Obsolete as of: ``v1.0#20170101``

HRGCodeSubmitted

TreatmentDateofFirstTreatment

HRGCodeVersionForInformation

This is derived from the submitted item POSTCODE OF USUAL ADDRESS It is the outward part (or outcode) of the postcode plus the first character of the inward part (or incode)

PostcodeSectorOfUsualAddress

This represents Either the historical parent SHA of Provider or the current LAT (Local Area Team) of provider. It is found in Organisation Data Service (ODS) data using the submitted Provider Code.

SHAProvider

TariffInitialAmountNonMandatory

An optional locally defined identifier that may contain letters, numbers or other keyboard symbols that is used to specify the specific line of a contract or service agreement that the record belongs to.

NHSServiceAgreementLineNumber

The number of primary and secondary procedure codes in the spell (APC), the appointment (OP) or the attendance (EM). This is a total count ? i.e if the same code appears on the record twice, BOTH will form part of the total. NOTE: In APC this is a spell and not an episode level count.

NumberProcedures

AAndEInvestigationSecond4

AAndETreatmentSecond10

The mode by which a patient arrived at an Accident and Emergency Department. The values are: - 1 = Brought in by Emergency Ambulance (including helicopter/Air ambulance) - 2 = Other

AAndEModeOfArrival

A Commissioning Data Set data element providing a unique identity for the life-time of an episode carried in a Commissioning Data Set message.

UniqueCDSIdentifier

AAndETreatmentSecond1

Version_Derived

The count of AE Investigation codes submitted to the grouper. Each code found in the submission counts one, ie multiple instances of the same code count multiple times.

NumberAAndEInvestigations

Accident and Emergency Linked Data

WSIC receives an initial draft version from the hospital called the â€œRecâ€ version, followed by a second version 15 days later called the â€œPostrecâ€ version which is the finalised version. Another version exists in the data called â€œcurrentâ€ which is generated by the CSU. The rec/current/postrec version is recorded in the column â€œVersion_Derivedâ€. Your query should refer to the latest/best received version taking postrec first, current second, rec third. In some cases you will only have the rec version due to the point in time as to when the taken was refreshed.

This is the submitted value of General Medical Practitioner (Specified) which is the PPD (NHS Prescription Services) code for the General Medical Practitioner specified by the patient. It may contain default values: - G9999998 - General Medical Practitioner PPD code not known - G9999981 - General Medical Practitioner PPD code not applicable

GeneralPractitionerCode

An unbundled HRG represents significant treatment that has been delivered in addition to that represented by the Core HRG. Each unbundled HRG may influence the national tariff applied or may be the basis for a locally agreed payment. These are derived at the episode level or attendance level and priced at spell level for admitted patients. These are output by the grouper.

UnbundledHRG5

A code that indicates, for neonatal patients, the level of special or intensive care provided. Values can be: - 0 = Normal care - 1 = Special care - 2 = Level 2 Intensive Care (high dependency) - 3 = Level 1 Intensive Care - 8 = Not applicable, still birth or not a neonate - 9 = Not known

EpisodeNeonatalLevelOfCareDescription

This is the date the primary procedure was carried out.

PrimaryProcedureDate

Organisation where the patient was treated first.

NHSOrgSite_TreatmentSiteName

This is locally defined between the provider and the Commissioner. it is a free text field that may contain letters, numbers or other keyboard symbols for use within a Commissioning Data Set.

ProviderReferenceNo

This is the date each procedure was carried out and is submitted for each separate procedure as treatment may, for example, involve more than one visit to theatre or a staged series of treatments within an episode. Repeating field up to 12 instances - all procedure dates are found in supplementary extract if more than 12 procedures submitted

ProcedureDate1

NHSOrg_GPPracticeOriginalDataName

Signifies whether relevant clinical codes in the record have been cleaned before submission to grouping. For APC that should mean whether any procedure codes (OPCS) or any diagnosis codes (ICD) have been cleaned. For OP that should mean whether any procedure codes (OPCS) have been cleaned. For EM that should mean whether any investigation codes or treatment codes have been cleaned.

Code Cleaning Flag

The International Classification of Diseases (ICD) code used to identify the secondary patient diagnosis.

North West London Integrated Care Record (NWL ICR)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Enrichment and Linkage

Observations

Origin