MunitasFeature tourAll walkthroughs

All walkthroughs / Health organisation

Health organisation · Locked patient data

Read five locked rows, with an approver's say

Devi brought in the table of appointments, and is now refused the locked names and reasons. Devi asks to read five rows for three days, and the custodian of the owning department decides. A researcher has no way to ask at all. Munitas reports which readable columns could single someone out, and the lease opens exactly five rows.

11Steps
3People
about 9Minutes to read
Who is involved
Devi
Data engineer in the Health organisation
Sam
Researcher in the Health organisation
Hartley
Data custodian for the Cardiology department

How to read this page

Words used on this page

Organisation
A company or hospital group that uses Munitas. Each organisation sees only its own data.
Department
A team inside an organisation that owns some of its data, such as Cardiology.
Dataset
A named collection of records, such as a table of patient admissions.
Custodian
A person who holds the data custodian role, which allows deciding who may read data. A custodian decides for the departments they are an approver for.
Department approver
A custodian who is listed for one department and may approve access to its data and confirm claims about it. A department can have several, and any one of them can act on their own.
Sealed
Finished and closed for good, so that it can never be edited.
Privacy contract
A file that says, column by column, how identifying each column of a table is and what is done to it when the table is sealed, and how to find the person each row is about.
Locked column
A column whose values are scrambled under a key made for each person. Reading them back needs permission. Destroying a person’s key later makes their values unreadable for good, while the sealed table itself never changes.
Person code
A label that stands for one person and means nothing on its own. It replaces the number that identified them.
Locked-column lease
Permission, decided by an approver of the owning department, to read a few rows of a table’s locked columns for a few days, for a stated purpose. It opens only those rows, never the whole table.
Small group
A combination of readable columns, such as postcode and age band, shared by only a few people, so that one of them could be singled out even though no column names anybody.
Privacy auditor
A person who checks how locked data was used. The role reads records of use and no personal data.
Data protection officer
A person who watches how an organisation handles personal data. The role decides nothing about who may read it.
Version
One sealed state of a dataset. Changing the contents means making a new version, never editing an old one.
Role
A named set of permissions that a person can hold, such as the permission to decide who may read a department’s data.
Lease
Permission, given by the custodian, to read one dataset for one stated purpose and for a limited time.
De-identification reviewer
A role that allows a person to review data from which identifying details have been removed, and to decide whether it may be released.
PART ONE

Devi cannot read what is locked, so Devi asks

A department approver is a data custodian who is listed for one department and may decide who reads its data. A locked-column lease is permission, decided by an approver of the owning department, to read a few rows of a table’s locked columns for a few days, for a stated purpose. Holding a role does not open locked rows. Only an approver of the department that owns the data, or a person who holds a lease, may read them.

1
Devi
Devi tries to read the locked rows and is refused
Munitas console · Locked columns, opened · /versions/<id>/locked-rows

Devi brought the table in, but is not an approver of the Cardiology department, so the platform refuses and says why in its own words.

Screenshot: Devi tries to read the locked rows and is refused
A red box reads “Could not read these rows.” and gives one reason: this person is not an approver of the department that owns this data and holds no current lease for its locked columns.
2
Devi
Devi writes why, and asks for five rows for three days
Munitas console · Version detail · Your access

The form asks for a purpose, a number of days and a number of rows. The platform states the limits itself, at most 7 days and at most 20 rows, and the purpose is recorded with the request. The rows are chosen by the platform, not by the person asking, and they are the same every time, so asking repeatedly cannot be used to read the whole table.

Screenshot: Devi writes why, and asks for five rows for three days
What you need them for holds Devi’s reason. For how many days (up to 7) reads 3, and How many rows (up to 20) reads 5. The small print reads The rows you can read are chosen for you and are the same every time you look, and Ask for access is ready.
3
Devi
The request waits for an approver
Munitas console · Version detail · Your access

Asking opens nothing. Devi still cannot read any locked value until an approver of the Cardiology department decides.

Screenshot: The request waits for an approver
A yellow box reads “Your request is waiting for an approver.” and repeats the request: for 5 rows for 3 days, with Devi’s reason. A link reads See your requests.
4
Sam
Sam, a researcher, has no way to ask at all
Munitas console · Version detail · Your access

Sam holds the researcher role, which is for working with data that has already been de-identified, meaning the names, dates and other identifying detail have been taken out. Sam opens the same table and sees how it is built, but no value, and is not offered a form, because the locked values are not needed to work with the readable columns.

Screenshot: Sam, a researcher, has no way to ask at all
The box under Your access reads Your role cannot read the locked values and cannot ask for them. The table above it lists the same columns Devi saw, and there is no form.
PART TWO

Hartley, who answers for Cardiology, decides

The person who asks never decides. Only an approver of the department that owns the data can, and an approver of another department cannot.

5
Hartley
Hartley sees the request waiting
Munitas console · Locked-column access · /locked-column-access

Hartley is a data custodian and an approver of the Cardiology department, so the request about Cardiology data appears on this page. It shows who asked, why, how many rows and days, and offers Approve and Decline. A custodian of another department would see nothing here.

Screenshot: Hartley sees the request waiting
Under Waiting for you to decide there is one row: Devi, the reason, 5 rows, 3 days and the state Waiting for an approver, with a box reading A note, recorded with your decision. In force in your departments reads No leases in force.
6
Hartley
Hartley writes a note, and both buttons are ready
Munitas console · Locked-column access · Waiting for you to decide

The note is stored with the decision. A refusal needs a note, so that the person who asked is told why. Approving needs none, but a note makes the record easier to read later.

Screenshot: Hartley writes a note, and both buttons are ready
The note box holds “Five rows is enough for that.” and both Approve and Decline are ready to press.
7
Hartley
Hartley approves, and the lease is in force
Munitas console · Locked-column access · In force in your departments

The lease now lasts three days from the approval and opens five rows. Hartley can end it early at any time, and so can Devi.

Screenshot: Hartley approves, and the lease is in force
Waiting for you to decide now reads No requests waiting for you. In force in your departments lists Devi, 5 rows, 3 days, the label In force, an end date three days after the approval, and Approved by Hartley with the note Five rows is enough for that. A button reads End now.
8
Hartley
Hartley reads the report on small groups
Munitas console · Version detail · Small groups

A small group is a combination of readable columns, such as postcode and age band, shared by only a few people, so that one of them could be singled out even though no column names anybody. The platform counts different people, not rows, because a person with several visits is still one person to find. The report is advice. It never stopped the table being sealed and shows no values. The approvers, the de-identification reviewer, the privacy auditor and the data protection officer can read it. The data protection officer is the person who watches how an organisation handles personal data. Only an approver can decide what to do about it.

Screenshot: Hartley reads the report on small groups
A yellow box reads 12 of 20 people sit in a group smaller than 5. The smallest group holds 1 person. Two lines say what locking each column would leave: Locking postcode would leave 4 people in a small group and Locking age_band would leave 6 people in a small group. Below, “What will you do about it?” offers two choices, and Record this decision is greyed out until a reason is written.
9
Hartley
Hartley records what will be done, and why
Munitas console · Version detail · Small groups

Hartley chooses to change the contract before the next table is sealed, and writes why. The decision is made once, and the platform refuses to change it afterwards, even to somebody who writes to the database directly.

Screenshot: Hartley records what will be done, and why
A line reads Decided by Hartley, then the date, the contract will change before the next table, and Hartley’s reason, The next contract version will lock the postcode. The decision form has gone.
PART THREE

Devi reads the five rows the lease opens

A lease opens a fixed few rows for a short time. It does not open the table.

10
Devi
Devi now holds a lease
Munitas console · Version detail · Your access

The same section that showed a form now says what Devi holds: five of the 23 rows, until the lease ends, approved by Hartley for the stated reason. Devi can read the rows or end the lease personally.

Screenshot: Devi now holds a lease
A green box reads You hold a lease: 5 rows of 23, with the end date, and Approved by Hartley and the date, then for: followed by Devi’s reason. Two actions are offered: Read your 5 rows and End this lease now.
11
Devi
Devi reads five rows, with the locked values opened
Munitas console · Locked columns, opened · /versions/<id>/locked-rows

These are the only five rows Devi can read, and they are the same five every time. The locked values are opened for them: the actual names and reasons for visits. Every key that is opened for this is recorded, naming the person it belongs to by their person code. The other 18 rows stay locked.

Screenshot: Devi reads five rows, with the locked values opened
A yellow banner reads Your lease opens 5 of 23 rows. They are the same rows every time, and a later lease opens the same ones. The table shows five rows with names under patient_name and reasons under reason_for_visit. The column patient_number (now a person code) holds labels that begin with T-.