Preparation — calculations & data changes
Every derivation the workflow performed on the ingested data
- 1
Normalise hauler ticketsdata changed
Ticket dedupe on (ticket no, well, date); unit conversion to bbl
in · 412 ticket rows · 3 duplicates removed
out · 409 tickets · 38,400 bbl
- 2$172,800
Rate application
Contract rate $4.50/bbl (effective 2026-04-01) by disposal facility
in · 38,400 bbl
out · $172,800 gross hauling cost
- 3$54,400
Less amounts already invoiced
Match booked AP by well + service month
in · $118,400 booked in AP
out · $54,400 to accrue
- 4$54,400
Well allocation
Allocate accrual on metered disposal volume by well
in · 9 producing wells with June disposal
out · WEL-1204 $31,900 · WEL-0455 $14,100 · others $8,400
Preparer & reviewer thread
Async comments — work carries on without a handoff meeting
Workflow engine · system · Aug 05 06:42
All three required sources received. Run promoted to Ready to prepare.
Workflow audit trail
Detection, preparation and approval events
Aug 05 05:02 · Workflow engine
Detected SCADA water volumes
Aug 05 06:41 · Workflow engine
Detected hauler ticket email
Aug 05 06:42 · Workflow engine
Marked ready to prepare