Healthcare Referral Tracking Spreadsheets: Use case and AI Confidentiality
An allied health clinic tracks incoming referrals in a spreadsheet so that no patient waits unseen: who referred them, how urgent it is, whether they have been seen and how many days they have waited. Someone then uploads the sheet to ChatGPT or Claude to summarise waiting times or to build a chart for a meeting. Initials look anonymous, but next to an age, a referral type and a referrer they point to one person in a small clinic. This page marks what a routine referral tracking sheet exposes under the Privacy Act, and shows how the same sheet is worked on Ermos inside the practice.
The referral tracking spreadsheet
Kept by the allied health coordinator to see who has been referred and seen, to prioritise urgent referrals and to report waiting times at the monthly team meeting. It is often shared by email, which is how it reaches an AI tool.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Received | Patient | Referral | Referrer | Urgency | Status | Seen on | Days waiting |
| 2 | 06/10/20265 | D.P. (44)1 | Physiotherapy, lumbar, further block2 | Dr H. Voss3 | Routine4 | Seen5 | 13/10/20265 | 7 |
| 3 | 12/10/20265 | T.M. (41)1 | OT, functional capacity assessment (NDIS)2 | Support coordinator3 | Routine4 | Seen5 | 23/10/20265 | 11 |
| 4 | 19/10/20265 | J.W. (29)1 | Psychology, GP mental health plan2 | Dr H. Voss3 | Routine4 | Seen5 | 29/10/20265 | 10 |
| 5 | 28/10/20265 | D.P. (78)1 | Physiotherapy, wrist after fracture2 | Hospital fracture clinic3 | Routine4 | Booked 17/115 | 14 | |
| 6 | 29/10/20265 | G.A. (81)1 | OT, home falls assessment2 | Dr H. Voss3 | Urgent4 | Seen5 | 05/11/20265 | 7 |
| 7 | 02/11/20265 | M.S. (52)1 | Physiotherapy, shoulder2 | Dr C. Eze3 | Routine4 | Waiting5 | 9 | |
| 8 | 03/11/20265 | E.K. (72)1 | Podiatry, diabetic foot check2 | Dr H. Voss3 | Routine4 | Waiting5 | 8 | |
| 9 | 05/11/20265 | H.B. (8)1 | OT, handwriting and school form2 | Dr C. Eze3 | Routine4 | Waiting5 | 6 | |
| 10 | 06/11/20265 | O.M. (64)1 | Wound care nursing, after excision2 | Dr C. Eze3 | Urgent4 | Seen5 | 09/11/20265 | 3 |
| 11 | Total referrals | =COUNTA(B2:B10) | 96 | |||||
| 12 | Not yet seen | =COUNTIF(F2:F10,"<>Seen") | 46 | |||||
| 13 | Average days waiting | =ROUND(AVERAGE(H2:H10),1) | 8.36 |
An invented spreadsheet as at 11 November 2026. All patients are fictional and shown by initials and age. Days waiting is the number of days from the received date to the date seen, or to 11 November 2026 if not yet seen. Hover or tap any highlighted item for the analysis; the full list is below.
Referral waiting list tracker
An Agent+ that keeps the referral tracking spreadsheet current from the referrals and booking lists the practice supplies. It adds new rows, updates status, and prepares a short waiting time summary for the monthly team meeting. Urgent referrals and entries without a booking are flagged.
What it does
- Reads new referrals and the latest booking lists
- Updates each row's status in the practice's sheet
- Flags urgent referrals and entries without a booking
What stays with your people. The allied health coordinator checks the sheet and sets priorities. Clinicians decide urgency; the agent only organises what is on file.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the practice
- 1Initials and ages
Initials with an age look anonymous, but in a small clinic they point to one person, and personal information includes information about an individual who is reasonably identifiable (Privacy Act s 6(1)). Next to a referral type the row is health information (s 6FA). Privacy Act guide.
Frontier Models (ChatGPT, Claude) Initials and ages that identify people in a small clinic transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 2The referral types
What each person was referred for, from a lumbar problem to a mental health plan and an NDIS functional capacity assessment. The last two reveal a mental health condition and that a person is an NDIS participant. Health information is sensitive information (s 6(1)). Patient data guide.
Frontier Models (ChatGPT, Claude) Sensitive health information transmitted; on consumer tiers it can train future models Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 3The referrers
Which doctor or service referred each person, and a support coordinator for an NDIS participant. It shows the patient’s care network and who holds the referral.
Frontier Models (ChatGPT, Claude) Referrers and a support coordinator transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 4Urgency ratings
A triage judgement against each patient. The clinical weight of urgent or routine is the clinic’s own judgement, and it shows who the clinic put first.
Frontier Models (ChatGPT, Claude) A triage judgement against each patient; a person must still own the ranking Ermos Edge Stays on your instance; a person still decides who is urgent Ermos Dominion Stays on the unit; a person still decides who is urgent Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 5Dates, status and bookings
When each person was referred, seen or booked. Information about a health service provided or to be provided is health information (s 6FA(a)(iii)), and the dates show a treatment timeline. Patient data guide.
Frontier Models (ChatGPT, Claude) A treatment timeline transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 6The totals and the average
A count of referrals, a count not yet seen and an average wait. Aggregate figures with no name in them, although they come from rows that have names.
Frontier Models (ChatGPT, Claude) Aggregate figures with no name in them Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 7The days-waiting formula
A date calculation fixed at 11 November 2026 so the figures do not change when the sheet is opened later. It holds no patient information. The same formula can be shared safely, and the sheet it sits in cannot.
Frontier Models (ChatGPT, Claude) A date formula with no patient data in it Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case - 8Other tabs, hidden columns and file properties
A spreadsheet file generally carries more than the visible tab: other sheets, hidden columns, cell comments and properties such as the author. Uploading the file sends all of it, including what is off screen.
Frontier Models (ChatGPT, Claude) Every tab, hidden column and comment travels with the file Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Referral waiting list tracker. Builds and updates the referral tracking sheet from incoming referrals and booking records, and flags urgent referrals and long waits for the coordinator. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the practice no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the patient record. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in healthcare practices. See how this works in practice: Referral letters on Ermos.
Common questions
Do ChatGPT and Claude use the information in a referral tracking spreadsheet?
Is it safe to upload a referral tracking spreadsheet to ChatGPT or Claude if it only has initials?
Can I upload a referral tracking spreadsheet to ChatGPT or Claude instead of pasting the figures?
How can an allied health clinic use AI for a referral tracking spreadsheet without sending it to ChatGPT or Claude?
Are patient initials and an age still personal information?
Does a waiting-list spreadsheet count as health information?
Is an average waiting time safe to share outside the practice?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo