I am conducting analysis on the usage of medicines in secondary care and kindly request your help.
I would be grateful if you could send me two datasets from your Trust, to inform this analysis:
(1) SACT Cancer report
An extract from the chemotherapy ePMA system showing patients treated by drug and diagnosis, as specified in table 1 (below).
(2) Drug Patient Level Contract Monitoring (DrPLCM) report
Data fields from the DrPLCM report, as specified in table 2 (below). Please do not send patient IDs or cost data, as I appreciate this would compromise data privacy and commercial sensitivity.
Please email your response by reply with the data in .csv format and feel welcome to contact me if you have any questions about this request.
Appendices – specifications
Please include the data fields specified within table 1 and table 2:
1. SACT Cancer report
An extract of records from the chemotherapy ePMA system dated between 1st October 2023 and 30th June 2024, or to the latest date for which data is available, for all solid tumour and haematology malignancies (ICD-10 primary diagnosis codes C* and D*)
Source: NHS Digital, NHS Data Model and Dictionary, Systemic Anti-cancer Therapy Data Set https://www.datadictionary.nhs.uk/data_sets/clinical_data_sets/systemic_anti-cancer_therapy_data_set.html
|
Organisation code (code of provider)
|
|
Organisation identifier (of SACT administration)
|
|
Primary diagnosis (ICD-10 3rd or 4th digit)
|
|
Morphology (ICD-O)
|
|
Adjunctive therapy type
|
|
Regimen treatment intent
|
|
Drug Regimen
|
|
Clinical trial indicator
|
|
Drug name
|
|
Actual dose
|
|
Unit of measure
|
|
Route of administration
|
|
Cycle number
|
|
SACT administration date
|
2. Drug Patient Level Contract Monitoring (DrPLCM) report
An extract of records from this report for all hospitals in the Trust dated between 1st November 2023 and 30th June 2024
|
Sourced from NHS Digital, DrPLCM Technical Specification V2.6 document
https://digital.nhs.uk/data-and-information/information-standards/information-standards-and-data-collections-including-extractions/publications-and-notifications/standards-and-collections/contract-monitoring
|
|
Field number
|
Data Element
|
|
1
|
FINANCIAL MONTH
|
|
2
|
FINANCIAL YEAR
|
|
5
|
ORGANISATION IDENTIFIER (CODE OF PROVIDER)
|
|
6
|
ORGANISATION SITE IDENTIFIER (OF TREATMENT)
|
|
9
|
ORGANISATION IDENTIFIER (CODE OF COMMISSIONER)
|
|
19
|
ACTIVITY TREATMENT FUNCTION CODE
|
|
22
|
CLINICAL INTERVENTION DATE (DRUG DISPENSED)
|
|
23
|
THERAPEUTIC INDICATION CODE (SNOMED CT)
|
|
26
|
DRUG NAME (HIGH COST TARIFF EXCLUDED DRUG)
|
|
27
|
ROUTE OF ADMINISTRATION (SNOMED CT DM+D)
|
|
28
|
DRUG STRENGTH (HIGH COST TARIFF EXCLUDED DRUG)
|
|
29
|
DRUG VOLUME (HIGH COST TARIFF EXCLUDED DRUG)
|
|
30
|
DRUG PACK SIZE (HIGH COST TARIFF EXCLUDED DRUG)
|
|
31
|
DRUG QUANTITY OR WEIGHT PROPORTION (HIGH COST TARIFF EXCLUDED DRUG)
|
|
32
|
UNIT OF MEASUREMENT (SNOMED CT DM+D)
|
|
33
|
DISPENSING ROUTE (HIGH COST TARIFF EXCLUDED DRUG)
|
|
34
|
PROVIDER REFERENCE NUMBER
|
|
35
|
COMMISSIONED SERVICE CATEGORY CODE
|
|
36
|
SERVICE CODE
|
|
37
|
NATIONAL CANCER DRUGS FUND FORM CODE
|
|
44
|
LOCAL CONTRACT MONITORING CODE
|
|
45
|
LOCAL CONTRACT MONITORING DESCRIPTION
|
|
46
|
CONTRACT MONITORING ADDITIONAL DETAIL (FIRST)
|
|
47
|
CONTRACT MONITORING ADDITIONAL DESCRIPTION (FIRST)
|
|
51
|
VALUE ADDED TAX CHARGED INDICATOR (CONTRACT MONITORING)
|
