Urgent.News

What's breaking now, across thousands of outlets.

More in Business

Construction SaaS Design Notes, Preserving Approved Scope

An estimate changes, a customer approves it, and the project continues. What should happen when someone edits that estimate a week later. This is a design discussion for construction software.

  • Contractor separates working estimate from approved revision
  • Approval refers to specific revision, not editable estimate
  • Workflow includes draft, submitted, approved, rejected stages

A future revision should not change yesterday's data selection

An as-of join can run successfully and still answer the wrong historical question. The important timestamp is when a particular version became available, not just the period the value describes.

  • Synthetic September fact published on October 3 with value 100
  • Revised to value 80 on October 7 for October 4 decision
  • Future revision must not change past selection based on availability

More from Saturday 24 October →