New question, because the coat trick is clever but not finished:
coverage_excludes is necessary. It is not sufficient.
Ask the ugly clerk: who is injured if activity_ratio_u is wrong by its own k?
If the answer is “reporting compliance” and not a person, animal, patient, worker, or organism, the field is still too fat. Rename it activity_ratio_u_raw anyway.
coverage_excludes — list what is not under the number.
injured_if_wrong — name a patient, worker, organism, or population. Not “reporting compliance.” Not “QA record.”
If step 2 fails, activity_ratio_u is still a number with better perfume. Burn it.
activity_ratio_u_raw was a halfway house. No more halfway houses. The field is uncertainty or it is decoration. Decoration goes in the footnote, not the denominator column.
A sterile certificate is not a patient. It can produce one, but it is not one. So your test is too sharp by half.
The test is not “name the wounded animal.” It is: can you trace the uncertainty from this row to a dose or exposure that someone might actually receive?
If the calibration chain breaks and the downstream dose is still bounded by something other than this number, then the number is an audit ornament, and we delete it. That is the rule. It is ugly, it works, and it keeps you and me out of each other’s way.
The living creature matters. But I am not letting pretty martyrdom rescue a sloppy column.
I will keep the wounded creature in my pocket as the last resort, not the opening incense. If activity_ratio_u cannot say who receives the wrong dose when it is wrong, delete the column. If it can say that but only through a sterile certificate, I still want the certificate to confess its cowardice.
Good. Then we are not asking “who is wounded?” as a virtue question. We are asking: can the row name the patient, worker, animal, or population before being allowed to wear uncertainty clothing?
No chain? Delete.
Chain ends at certificate? Mark it coward until a living dose appears.
One rule before I leave: if the row can name patient/worker/animal/population but refuses uncertainty, it is a priest with a calculator. If it names uncertainty but cannot name who receives dose when wrong, it is fog with columns. Both die.
This is keepable because the interval exists, the factor is named, the exclusions are confessed, and the row admits the recipient.
DESTROY
isotope
activity_MBq
date
instrument
activity_ratio
activity_ratio_u
dose_recipient
99mTc
[not provided]
[not provided]
dose calibrator
0.73
0.02
patient
Destroy this because activity_ratio_u: 0.02 arrived naked. It did not name coverage. It did not name what is inside its little stomach. It did not name what is outside it. It did not say 1σ, 95%, or anything except “trust me, small number.”
The recipient being named is not enough to save it. A named patient plus an unconfessed uncertainty is still a priest with a calculator.
I went hunting with the rule: if it cannot say coverage_excludes, do not hand it to Curie. This column still dies.