Governance & data
28Master Spreadsheet & ICB Reporting
- Owner
- Zak, weekly. Review outcomes recorded every 6 weeks.
- Trigger
- Continuous. Reviewed weekly and every 6 weeks.
Purpose
Holding the position of every patient on ADHD titration, so the service can answer the ICB at any point.
Procedure
- Every patient on ADHD titration for medication is held on the master spreadsheet, on the tab for their funding stream: CAMHS, Right to Choose, Greater Manchester adult, or Private. Discharged patients stay on the sheet with their reason for discharge.
- When the ICB asks how many patients the service holds, the answer is read directly off the sheet.
- Where the ICB asks how many are non-engaging, filter on non-engagement.
- At morning meeting, record the outcome of each patient's appointment and the plan arising from it in the annual review column - still in titration, did not attend, or moved to shared care. Where they have moved to shared care, enter next year's review due date.
- Patients who have moved onto shared care are pulled from this sheet onto the contact sheet for their annual review (23).
- Record the morning meeting date as the patient's Last updated date. Zak works the sheet A–Z weekly and pulls out anyone whose date has not moved in 6 weeks, to check whether they have fallen through the net and whether they need a reminder, a letter, or the Daily Brief.
Fields recorded
Per funding stream tab. Includes: patient identifiers · funding stream · engagement status · annual review outcome · shared care status · last updated
Notes
- The master spreadsheet and the contact spreadsheet are maintained separately and are not linked.
- Current state: the two sheets hold overlapping patient data with no reconciliation between them. Target state under Medicus: one patient record, with reporting as a view over it rather than a second hand-maintained sheet.
Open points
- Whether the columns are identical across all four funding tabs.
- What happens when a patient moves between funding streams, such as CAMHS to Greater Manchester adult at 18.
Flowchart
Open points
37 items still to confirm.
- C3 Contact Ladder & RAG Prioritisation - Full RAG criteria to be inserted. Referral source appears to be one factor - confirm the complete list.
- C5 Discharge - Whether anomaly discharges take a different ICB outcome code from standard discharges.
- C5 Discharge - Whether removal from active trackers is manually cross-checked, and by whom.
- 01 Referral Receipt & Triage - Full RAG criteria.
- 04 48-Hour Confirmation Calls - Whether a cancellation on this call automatically triggers the cancellation list, or admin picks it up separately.
- 05 Cancellation List - Whether ad-hoc follow-ups (06) take priority over cancellation-list patients when a slot opens.
- 06 Ad-Hoc Bookings & Follow-Ups - How admin is told a patient only attended part of an assessment - whether the clinician adds them directly or an outcome code triggers it.
- 07 DNA Management - Whether a DNA is billable to the ICB.
- 08 Questionnaires - How questionnaires are originally sent out.
- 09 ADHD Assessment Report - Whether the SLA metrics are a formal contractual return or internal tracking only.
- 11 Full Psychiatric Assessment Report - How consent is captured and where it is recorded.
- 12 Post-Diagnostic - Whether resources sent differ for patients not given a diagnosis.
- 13 Autism 6-Week Follow-Up - What happens if the offer letter expires with no response - whether the patient is chased or moves straight to the 12-week stage.
- 13 Autism 6-Week Follow-Up - Whether the follow-up must be with the diagnosing practitioner.
- 14 Report Amendments - Whether the time-to-action metric measures admin processing time or total turnaround including clinician review.
- 15 Titration & Episodes - Whether an episode that ends in DNA or non-engagement is still billable.
- 16 Observations - How patients submit their obs - digital form or read out during a booked call.
- 17 Blood Pressure Machines - What happens if tracking shows the machine was not delivered or is lost.
- 19 ECG & Investigation Chasing - What puts a patient onto the ECG tab in the first place.
- 19 ECG & Investigation Chasing - Who performs the ECG - in-house, GP or external provider.
- 19 ECG & Investigation Chasing - Who chases the report when the ECG is done but the report has not arrived.
- 20 Pregnancy Pathway - Which leaflets and information make up the pregnancy pack.
- 20 Pregnancy Pathway - Whether the pause stops waiting-list clocks for ICB reporting purposes.
- 21 Shared Care Agreement & GP Liaison - Whether an explicit or implied rejection triggers a funding review with the ICB.
- 22 Shared Care Prescribing & 6-Month Review - Whether gap-filling prescriptions carry a different billing code.
- 23 Annual Review - Whether the review due date is calculated from the referral date, the first appointment or the last review.
- 23 Annual Review - What happens to non-shared-care patients past a year.
- 24 Clinical Task List - Whether tasks carry due dates and named assignees.
- 24 Clinical Task List - Where the list currently lives.
- 25 Admin Task List - How chase frequency is set - standard interval or specified by the requester.
- 25 Admin Task List - Whether a formal template exists for instructing a GP to stop prescribing.
- 26 ICB Coding & Activity Recording - The full outcome code set. Codes 7 and 3 are confirmed; the codes for attended-with-diagnosis, attended-without-diagnosis and attended-needs-treatment are not yet written down.
- 26 ICB Coding & Activity Recording - Whether the ICB code set is documented anywhere that can be attached to this SOP.
- 26 ICB Coding & Activity Recording - How Care Act ID and Care Contact ID are generated.
- 27 Invoicing - Whether an episode ending in DNA or non-engagement is billable.
- 28 Master Spreadsheet & ICB Reporting - Whether the columns are identical across all four funding tabs.
- 28 Master Spreadsheet & ICB Reporting - What happens when a patient moves between funding streams, such as CAMHS to Greater Manchester adult at 18.
