MDW - Discover Metadata Catalogue

MDW Discover  > National Waiting List @ 1367

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://standards.nhs.uk/published-standards/national-waiting-list-weekly-minimum-data-set

Total number of distinct patients combined in from all datasets

Highest number of referrals (clock starts) for Treatment function 110: Trauma and Orthopaedic Service based on the last 12 months

HDR UK

Provider Submitted: The treatment function under which the patient is treated. It may be the same as the main specialty code or a different treatment function which will be the care professional&#039;s treatment interest.

ACTIVITY_TREATMENT_FUNCTION_CODE

AGEM Derived: Derived age based on Date_of_Birth and the activity&#039;s corresponding week, ending on Sunday

Der_Age_WeekEndingDate

AGEM Derived: Clinical Commissioning Group covering the area in which the patient?s postcode falls.

Der_CCG_Flag

AGEM Derived: Derived by pseudonymising NHS number and  applying pseudonymisation algorithm.

Der_Gem_Pseudo_Nhsnumber_5

AGEM Derived: The Date the record was loaded

Der_Load_Date

AGEM Derived: The type of location for an activity where patients are seen, services are provided or from which requests for services are sent.

Der_Location

AGEM Derived: Interal processing field to identify dissemination

Der_Mega_DME_RLS

AGEM Derived: This is the Clinical Commissioning Group (CCG) code found in Organisation Data Service (ODS) reference data associated with the practice code for the patient

Der_Nhais_Ccg_Of_Registration

AGEM Derived: The organisation code according to the patient&#039;s postcode of usual address, where they reside within the boundary of a Clinical Commissioning Group (CCG). 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.

Der_Nhais_Ccg_Of_Residence

AGEM Derived: Derived LSOA (lower layer super output area) code based upon the Patient_Postcode field. 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.

Der_Nhais_Postcode_LSOA

AGEM Derived: The deciles are calculated by ranking the 32,844 LSOAs in England from most deprived to least deprived and dividing them into 10 equal groups. LSOAs in decile 1 fall within the most deprived 10% of LSOAs nationally and LSOAs in decile 10 fall within the least deprived 10% of LSOAs nationally.

Der_Nhais_Postcode_LSOA_IMD_Decile

AGEM Derived: IMD measures relative deprivation in small areas in England, with decile 1 representing the most deprived areas, and decile 10 representing least deprived

Der_Nhais_Postcode_LSOA_IMD_Rank

AGEM Derived: The Index of Multiple Deprivation ranks every lower-layer super output areas (LSOA), in England from 1 (most deprived area) to 32,844 (least deprived area).

Der_Nhais_Postcode_LSOA_IMD_Score

AGEM Derived: 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.

Der_Nhais_Practice_Code

AGEM Derived: The Organisation Code of the Organisation commissioning health care as issued by the Organisation Data Service (ODS) and validated against reference data

Der_Provider_Lead_Commissioner

AGEM Derived: An identifier to distinguish between the files during the load process.

derFileName

AGEM Derived: flag to identify most recent record for this provider as of the reporting week.

derIsLatestFiletypeProviderWeekending

AGEM Derived: In most cases, shortens the Provider Code to 3 digits (excluding site code). Where Provider Code is an independent sector healthcare provider, the 5 character code is retained. If a provider submits provider codes such as RJE00, RJE01, RJE02 etc. in the Provider_Code field, this field will store the value as RJE.

derProviderCode

AGEM Derived: A unique ID applied to distinguish between the files

derSubmissionId

AGEM Derived: derived using the activity date and the date the activity corrsponds to ending on Sunday

derWeekEnding

Provider Submitted: Date of the last trust validation. This might be entered directly into PAS, into a bespoke validation management application, or onto a stand alone spreadsheet.

Last_PAS_Validation_Date

Provider Submitted: ORGANISATION CODE (CODE OF COMMISSIONER) is the ORGANISATION CODE  of the ORGANISATION  commissioning health care.

ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER

Provider Submitted: ORGANISATION IDENTIFIER (CODE OF PROVIDER) is the ORGANISATION IDENTIFIER of the ORGANISATION acting as a Health Care Provider.

ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER

Provider Submitted: This locally produced code, in combination with the Organisation Code (Code of Provider), is used to uniquely identify a referral

Referral_Identifier

Provider Submitted: The date the REFERRAL REQUEST was received by the Health Care Provider .

REFERRAL_REQUEST_RECEIVED_DATE

Provider Submitted: The activity&#039;s corresponding week, ending on Sunday

Week_Ending_Date

NW_DME.National_Waiting_List.AsiCasRas

AGEM Derived: The date and time that the file was created prior to its submission. This timestamp will be used to ascertain the latest version of the submission.

DATE_AND_TIME_DATA_SET_CREATED

AGEM Derived: Derived age based on Date_of_Birth and the date the referal request was received by the Health Care Provider

Der_Age_at_Referral_To_Treatment_Period_Start_Date

AGEM Derived: The age banding at the date the REFERRAL REQUEST was received that falls into one of the following categories
0 - 15
16 - 18
19+

Der_Ageband_at_Referral_To_Treatment_Period_Start_Date

AGEM Derived: The age banding at the activit corresponing week that falls into one of the following categories
0 - 15
16 - 18
19+

Der_Ageband_WeekEndingDate

AGEM Derived: Date when the file was processed

Der_Processing_date

AGEM Derived: An identifier to distinguish between the row of the file

derRowId

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

ETHNIC_CATEGORY

Provider Submitted: A number used to identify a PATIENT uniquely within a Health Care Provider .

LOCAL_PATIENT_IDENTIFIER

Provider Submitted: ORGANISATION CODE (PATIENT PATHWAY IDENTIFIER ISSUER) is the ORGANISATION CODE of the ORGANISATION  issuing the PATIENT PATHWAY IDENTIFIER.

ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER

Provider Submitted: This is a specific type of the attribute ACTIVITY IDENTIFIER .
An identifier, which together with the ORGANISATION CODE  / ORGANISATION IDENTIFIER  of the issuer, uniquely identifies a PATIENT PATHWAY

PATIENT_PATHWAY_IDENTIFIER

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. Please note that some of the reference data uses descriptions rather than codes.

PERSON_STATED_GENDER_CODE

Provider Submitted: The priority of a SERVICE REQUEST .
1 - Routine
2 - Urgent
3 - Two Week Wait

PRIORITY_TYPE_CODE

REFERRAL_TO_TREATMENT_PERIOD_START_DATE

Provider Submitted: The status of an ACTIVITY (or anticipated ACTIVITY ) for the  REFERRAL TO TREATMENT PERIOD decided by the lead CARE PROFESSIONAL

REFERRAL_TO_TREATMENT_PERIOD_STATUS

Provider Submitted: The source of referral of each Consultant Out-Patient Episode

SOURCE_OF_REFERRAL

AGEM Derived: The activity&#039;s corresponding week, ending on Sunday

NW_DME.National_Waiting_List.ClockStarts

Provider Submitted: The method of admission to a Hospital Provider Spell .

ADMISSION_METHOD_CODE_HOSPITAL_PROVIDER_SPELL

Provider Submitted: The date of the last APPOINTMENT which the PATIENT cancelled on or before their APPOINTMENT DATE.

Cancellation_Date

Provider Submitted: Field no longer in specification, field retained for historic reporting

Completed_Type

Provider Submitted: A code uniquely identifying a CONSULTANT.

CONSULTANT_CODE

Provider Submitted: The date of the last attended appointment

Date_Last_Attended

Provider Submitted: The date on which the priority was last reviewed. Please populate accurately with the recent date that the patient was reviewed and a priority assigned/changed/retained.

Please leave NULL where no applicable date and utilise 01/01/1900 if there is, but it is unknown

Date_Of_Last_Priority_Review

Provider Submitted: The date a decision to admit was made.

DECISION_TO_ADMIT_DATE

Provider Submitted: The date on which a Decision To Treat is made.

DECISION_TO_TREAT_DATE

Der_Ccg_Flag

Der_GEM_Pseudo_Nhsnumber_5

AGEM Derived: AGEM Derived: Interal processing field to identify dissemination

Diagnostic_Priority_Code

Provider Submitted: Clinically agreed due date for any planned activity. Where no due date is recorded, leave blank (do not populate with booked date or breach date). Patients awaiting planned admission that are clinically ready for their care to commence but are not booked to come in by their due date should be transferred to an active RTT waiting list.

Due_Date

Provider Submitted: The date of first activity that happened on the RTT period

FIRST_ACTIVITY_DATE

Provider Submitted: The type of first activity that happened on the RTT period, which was either:

FIRST_ACTIVITY_TYPE

Provider Submitted: Patient included in Cancer PTL return (Yes / No)

Inclusion_On_Cancer_Ptl

Provider Submitted: A Last Patient Did Not Attend Date is the date of the last APPOINTMENT which the PATIENT did not attend without advance warning.

Last_Dna_Date

Provider Submitted: The person who performed the last PAS validation

Last_Pas_Validation_Date

Provider Submitted: Records the action resulting from the attendance such as making another appointment or ending the series of consultations by discharging the patient. It does not record clinical outcome.

Local_Outcome_Of_Attendance

Local_Rtt_Status_Code

Provider Submitted: The main specialty in which the consultant is contracted or recognised. Main specialty classifies clinical work divisions more precisely for a limited number of specialties.

MAIN_SPECIALTY_CODE

Provider Submitted: The code of the procedure

OPCS_Code

Provider Submitted: a?code which identifies an ORGANISATION SITE uniquely.

ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT

Provider Submitted: This records the outcome of an Out-Patient Attendance Consultant .

OUTCOME_OF_ATTENDANCE_CODE

Provider Submitted: This is the date the appointment took place or will take place if it is in the future. It is the CDS Originating Date used as the CDS ACTIVITY DATE for Outpatient Appointment CDS Types 020 and 021.

Outpatient_Appointment_Date

Provider Submitted: This is the date the appointment will take place. It is the CDS Originating Date used as the CDS ACTIVITY DATE for Outpatient Appointment CDS Types 020 and 021.

Outpatient_Future_Appointment_Date

Outpatient_Priority_Code

Provider Submitted: P2-P4 Code - IRTT Pathways. Note that P1s should not be elective. P5 is no longer valid. P6 redacted as of 31/01/2023. C codes redacted as of 01/12/2024

Procedure_Priority_Code

Referral_Request_Received_Date

Provider Submitted: This should indicate the end date of a referral to treatment clock calculation; it may be when the first definite treatment started or when another relevant stopping event occurred.

REFERRAL_TO_TREATMENT_PERIOD_END_DATE

Provider Submitted: The source of referral of each Consultant Out-Patient Episode.

SOURCE_OF_REFERRAL_FOR_OUTPATIENTS

Provider Submitted: Patient To Come In date or admission date ( on the completed pathway period)

Tci_Date

AGEM Derived: Date when the patient was provided with a TCI date

TCI_Date_Provided

Provider Submitted: ORTT - RTT Non-admitted Clock Stop
IRTT - RTT Admitted Clock Stop

This should be the waiting list type upon completion of RTT pathway. Only RTT Clock Stops should be submitted in this schema.

Waiting_List_Type

NW_DME.National_Waiting_List.ClockStops

Provider Submitted: The diagnostic waiting time clock starts when the request for a diagnostic test or procedure is made

Diagnostic_Clock_Start_Date

Provider Submitted: Modality description from DM01

Diagnostic_Modality

Provider Submitted: D1-D6 Code - Diagnostic Priority

Provider Submitted: Planned or surveillance diagnostic due date

Planned_Diagnostic_Due_Date

Provider Submitted: OPCS-4 Code for procedure patient is currently waiting for

Proposed_Procedure_Opcs_Code

Provider Submitted: PLN - Planned for future due date
RTT - Current RTT open pathway
UNK - Unknown Waiting List Type
DAS - Direct access service
WLP - Waiting list (Passed Planned date)
WLD - Waiting list diagnosticGPDA - GP Direct Access
OTHR - Other not captured above

NW_DME.National_Waiting_List.Diagnostics

Provider Submitted: Actions for specialised (non ? universal) health optimisation taken following the preliminary screening and risk assessment

Action_Following_Preliminary_Screening_And_Risk_Assessment

Provider Submitted: The method of admission to a hospital provider spell.

Provider Submitted: To be completed for all patients in code 5 of Capacity_Status

ASA_PHYSICAL_STATUS_CLASSIFICATION_SYSTEM_CODE

Provider Submitted: Last Cancelled Date is derived from Offered for Admission Date and Admission Offer Outcome and is needed to meet central requirements. It is recorded when patients who have been offered a date for admission have missed this admission date with or without advance notice.

Provider Submitted: 1 - Treatment Date booked
2 - Capacity for Treatment Date to be booked before 31/03/2023
3 - P6
4 - Too complex to move
5 - Requires Mutual Aid

Capacity_Status

Provider Submitted: Latest clock start for this pathway period. This field should be left blank for RTT pathways but populated for not current RTT pathways. This will ordinarily be the same as the RTT Period End Date however in some PAS this requires a new &quot;referral&quot; to be recorded to commence a non RTT pathway.

Current_Pathway_Period_Start_Date

Provider Submitted: The date which the patient last had an attendance

Provider Submitted: The Care Contact Date that the PATIENT is first seen in the Trust that receives the first referral.

Provider Submitted: Only relevant for first activity along an RTT period/pathway (ORTT and IRTT) Note that only activity that took place should be reported. Where appointments/TCIs were cancelled or DNA&#039;d, these should not be included.

Provider Submitted: This is the intended pattern of Hospital Bed use for a PATIENT , decided when the decision is made to admit.

INTENDED_MANAGEMENT_CODE

Provider Submitted: Last DNA derived from Offered for Admission Date and Admission Offer Outcome and is needed to meet central requirements. It is recorded when patients who have been offered a date for admission have missed this admission date with or without advance notice.

Provider Submitted: Date of the last trust validation. This might be entered directly into PAS, into a bespoke validation management application, or onto a stand alone spreadsheet. Regardless of how it is entered, it should also be stored against the pathway ID in the data warehouse. This should include those on non-admitted and admitted RTT pathways (IRTT &amp; ORTT). This can include technical, administrative (including patient contact and RTT validation) and clinical validation. 

Please leave NULL where no applicable date and utilise 01/01/1900 if there is, but it is unknown

Provider Submitted: To be completed for patients in 1 of Transfer_Status

Mutual_Aid_Accepting_Provider

Provider Submitted: The  ORGANISATION SITE where the PATIENT was treated

Outcome_Of_Patient_Contact

Provider Submitted: Date preliminary screening and preliminary risk assessment completed.

Preliminary_Screening_And_Risk_Assessment_Date

Provider Submitted: Proposed OPCS code to occur upon admission for treatment (should be fully populated for IRTT). Please ensure the most recent OPCS version is used (v4.10).

Provider Submitted: The date the Referral request was received by the Health Care Provider.

Provider Submitted: This is that date of one of a variety of events that starts the referral to treatment clock calculation, for example the initial referral date or the failed to attend clinic date.

Provider Submitted: One of a set of defined codes that indicates this treatment&#039;s position within a referral to treatment period or the fact that this treatment is not part of a referral to treatment measured pathway.

Requires_Alternative_Capacity

Provider Submitted: Patient To Come In date or admission date (on this pathway period). Historical dates would indicate that validation and re-booking is required.

Please leave NULL where no applicable date and utilise 31/12/2999 if there is, but it is unknown

Provider Submitted: Date when the patient was provided with a first TCI date on this pathway. If the date when the first TCI date was provided is unknown, please leave NULL.

Only applicable for inpatient surgeries; where Waiting_List_Type = IRTT and Intended_Management_Code in (1, 3)

Please leave NULL where no applicable date, and utilise 01/01/1900 if there is but it is unknown

Transfer_Status

Provider Submitted: ORTT - Current RTT Non-admitted (incomplete RTT pathway without a decision to admit for treatment)
IRTT - Current RTT Admitted (incomplete RTT pathway with a DTA for treatment)

Note that RTT Pathways should align with National RTT guidance and figures should align with the Monthly RTT Aggregate return

NW_DME.National_Waiting_List.OpenPathways

National Waiting List

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin