Quick Reference

Menu map, demo-data codes and statuses

Group Models
Sampling & Field Work Sampling Program, Sampling Plan, Sampling Event, Sample, Sample Task Interval, Sampling Method, Sampling Equipment, Equipment Calibration
Custody & Laboratory Chain Of Custody, Chain Of Custody Sample, Laboratory Result
Exposure Assessment Exposure Assessment, Statistical Exposure Assessment, Exposure Standard
Exceedance & Response Exposure Exceedance, Hygiene Investigation, Corrective Action, Control Verification, Complaint Observation
Exposure Groups & Risk Similar Exposure Group, Seg Member, Seg Task, Hygiene Risk Assessment, Control, Risk Assessment Control
Hazards & Sources Hazardous Substance, Material Product, Product Constituent, Exposure Source, Exposure Source Substance
Respiratory Protection Respiratory Protection Program, Respirator Type, Fit Test
Worker Health & Training Worker Notification, Health Surveillance Referral, Training Requirement, Training Completion
People & Organisation Person, Person Role Assignment, Work Role, Organisation, Site, Operating Area
Reference & Evidence Authority, Source Document, Document Evidence

The Demo Scenario

Wandoo Ridge Mine (WRM) samples its crusher crew on 12 May 2026 during a liner-change shutdown. One result changes the rest of the data set.

Code What it is
SEG-01 Crusher & Screening Operators — the SEG at the centre of the story
RA-2026-0001 Quantitative RCS risk assessment for SEG-01. Residual HIGH, credits spray bars + control room + PAPR
EV-2026-0007 The 12 May sampling event — crusher shutdown, seven samples including a blank and a duplicate
S-2026-0071 Tom Nyari's personal RCS sample. 0.062 mg/m³ — worn in a P2 disposable, not the credited PAPR
S-2026-0072 Lena Vogt, same shift, same area, PAPR worn. 0.013 mg/m³. The comparison is the point
S-2026-0077 Supervisor sample, QUALIFIED — 6.2% flow drift, excluded from the statistics
S-2026-0041 March sample, INVALID — 12.4% flow drift. Kept for audit, excluded from every decision
COC-2026-0031 Chain of custody to Terrafide Analytical Laboratories, reconciled and closed
EA-2026-0141 The assessment: 248% of the shift-adjusted limit (124% unadjusted). EXCEEDANCE
EA-2026-0139 The same sample assessed against the superseded 2019 limit — SUPERSEDED, kept for traceability
EXC-2026-0011 The exceedance. Severity HIGH, regulator notified, work stopped, CLOSED 6 July
INV-2026-0002 Investigation: two blocked spray nozzles and a procedure that permitted the wrong respirator
CA-2026-0181 Replace nozzles + fit a header pressure alarm — the action that fixed the engineering control
CA-2026-0183 Align the task procedure with the risk assessment on RPE — the action that fixed the paperwork
STAT-2026-0001 SEG-01 group decision over the year: POORLY_CONTROLLED, exceedance probability 0.18
EXC-2026-0012 Underground DPM exceedance — deliberately left at ACTIONING, investigation still in ANALYSIS
EXC-2026-0013 Post-blast CO peak of 210 ppm — CONTAINED, re-entry held, nobody exposed
CA-2026-0191 Workshop LEV repair — BLOCKED on a 10-week impeller lead time. Interim PAPR hoods issued
HSR-2026-0088 Silica health-surveillance referral for the affected operator. Outcome NO_RESTRICTION, nothing clinical stored

The thread worth following: S-2026-0071 → COC-2026-0031 → CERT-TAL-26-3391 → EA-2026-0141 → EXC-2026-0011 → INV-2026-0002 → CA-2026-0181 → control verification EFFECTIVE → exceedance CLOSED. That is the core chain end to end, with a real control failure in the middle.

The comparison worth making: open S-2026-0071 and S-2026-0072 side by side. Same shift, same area, same task at 15:30. The difference is the respirator, and the results differ by a factor of five.

Status Vocabularies (the important ones)

Sample: COLLECTED → DISPATCHED → RECEIVED → ANALYSED → ASSESSED → CLOSED Sample validity: PENDING · VALID · QUALIFIED · INVALID — qualified above 5% flow drift, invalid above 10%

Sampling event: PLANNED → IN_PROGRESS → SUBMITTED → COMPLETE, plus INVALIDATED

Chain of custody: PREPARED → DISPATCHED → RECEIVED → RECONCILED → CLOSED Condition on receipt: ACCEPTABLE · DAMAGED · TEMPERATURE_ISSUE · MISSING · OTHER

Exposure assessment: DRAFT → PEER_REVIEW → APPROVED → SUPERSEDED Classification: ACCEPTABLE (<50% of limit) · ACTION_LEVEL (50–100%) · EXCEEDANCE (>100%) · INDETERMINATE (no usable result)

Statistical decision: CONTROLLED · UNCERTAIN · POORLY_CONTROLLED · INSUFFICIENT_DATA — INSUFFICIENT_DATA is a decision, not a blank

Exceedance: OPEN → CONTAINED → INVESTIGATING → ACTIONING → VERIFICATION → CLOSED Severity: LOW · MODERATE · HIGH · CRITICAL

Investigation: OPEN → EVIDENCE_COLLECTION → ANALYSIS → REVIEW → APPROVED → CLOSED

Corrective action: PROPOSED → APPROVED → IN_PROGRESS → BLOCKED → COMPLETED → VERIFICATION → CLOSED, plus CANCELLED

Control: PROPOSED · ACTIVE · DEGRADED · UNAVAILABLE · RETIRED — DEGRADED is a real operating state, and the demo has one Verification result: EFFECTIVE · PARTIALLY_EFFECTIVE · INEFFECTIVE · NOT_VERIFIED

Risk rating: LOW · MODERATE · HIGH · EXTREME Control hierarchy: ELIMINATION · SUBSTITUTION · ENGINEERING · ADMINISTRATIVE · PPE (with hierarchy_rank 1–5)

Notification: PREPARED → DELIVERED → ACKNOWLEDGED, plus UNABLE_TO_CONTACT Referral: REFERRED → BOOKED → COMPLETED → FOLLOW_UP → CLOSED Fitness outcome: NO_RESTRICTION · TEMPORARY_RESTRICTION · PERMANENT_RESTRICTION · FURTHER_REVIEW · NOT_PROVIDED

Privacy: STANDARD · RESTRICTED · HIGHLY_RESTRICTED — health-surveillance referrals are always the third

Rules of Thumb

  • A percentage is meaningless without its limit. Always read percentage_of_limit next to limit_value_applied and adjustment_factor. A 12-hour shift halves the limit under Brief & Scala, so 0.062 mg/m³ is 124% of the raw standard and 248% of the one that actually applies.
  • Invalid ≠ deleted. Sort samples by validity_status to see what the statistics legitimately excluded. If an invalid sample is missing from the register entirely, something has gone wrong upstream.
  • A control with no ControlVerification row is a control nobody has checked. That is a different problem from one that failed, and the register shows both.
  • rpe_adjusted_value is information, never a compliance decision. It only means anything if the wearer had a current fit test on that exact respirator type — check FitTest before quoting it.
  • Blanks and duplicates (sample_type BLANK / DUPLICATE) carry no exposure assessment by design. They are quality evidence, not exposure evidence.
  • An exceedance sitting at VERIFICATION is waiting on a measurement, not on an email. Look for the ControlVerification row.
  • SegMember and PersonRoleAssignment both have end dates. Someone who left site still has exposure history, and still has a notification obligation — the demo's undelivered group-result letter is that case.