Data Integrity Workbench

Filter & View

Universe

Fiscal period 4-4-5 · same week calendar as Demand & Spend

Loading fiscal weeks…

Site

From date (optional)

To date (optional)

Flags

Show

Refine

Bill ID

Staff

Load a site to choose staff.

Channel

Validity

Changed

Discount

Numbers

Covers

Payment (£)

Service (£)

Open minutes

Discount amt (£)

Open Bulk actions below to save staged bills or download a backup.

Bulk actions

Save writes every staged bill (from this panel or Save this bill in the drawer). Run integrity_save_server.py first. Rebuild Demand & Spend for refreshed charts.

Bulk override Tick fields, set values, Apply to selected to stage.

Validity

Validity records the review decision. Invalid bills will be excluded from reporting in a later pipeline update.

Channel

Open minutes

Effective covers

Reviewer

Note

Data view

	Site	Date	Bill	Staff	Covers	Payment	Service	Discount	Discount amt	Gross ASPH	Net ASPH	VAT (est.)	Open min	Channel	Validity	Change	Flag #	Flags

Group	Transactions	Total covers	Total payment	Total service	Discount amount	Avg gross ASPH	Avg net ASPH	Flagged for review (export) — count	Flagged for review (export) — %

By site and category

Bills = bills from the current filtered list at that site. Each category cell = bills at that site with at least one active rule in that category (same rules and thresholds as the table). Reporting scope is not a flag category and is not included here.

By rule

Hits = number of times each rule matches a bill in the filtered set (a bill can add more than one hit if several rules apply). Uses current filters and current threshold / capacity settings.

Flag category	Rule	Code	Hits

Flag rules & settings

Flag rules

Thresholds & capacity

Values apply in this browser only and are saved automatically. Per-site capacity overrides occ_seat_count from the export (capacity policy) when set; leave blank to use each site’s capacity from the loaded file. Used only for covers-vs-seats flag rules (not dashboards).

Covers — high band (% of seat count)

Covers — medium band (% of seat count)

Net sales per head floor (£)

Payment per cover floor (£)

Payment high alert (£)

Open minutes — long sit (minutes)

Discount amount high (£)

Discount vs payment (% of payment)

Service vs payment — high (%)

Service vs payment — low, dine-in (%)

Capacity (seats) by site

Used only for flag calculations (does not affect dashboards)

Site	Capacity (seats)
Load manifest to list sites.

Bill

Export snapshot

Review

Validity

Validity records the review decision. Invalid bills will be excluded from reporting in a later pipeline update.

Channel

Effective covers

Effective open minutes

Notes

Flags

Changes vs export

Saves overrides on this machine. Rebuild Demand & Spend when you want refreshed exports.