One row per (related_test, category). related_test is the exact-matchable test name — a canonical test family or one of the raw mdt_test_methods.test_name variants (is_canonical=0 alias). canonical_test is the normalized family. unit_rate_minor is the per-unit rate in GBP integer pence; category splits labour / setup / materials. Synthetic reference data (build_rate_card.py); a few families are anchored to observed proposal pricing, the rest are seed-derived within a plausible band. BI + commercial personas only.
- highExposing the rate card to AI personas
unit_rate_minor is confidential-commercial. This mart grants no ai_readonly access and the row-detail is restricted to commercial personas. Do not add ai_readonly to accessible_to.
- mediumReading unit_rate_minor as pounds
unit_rate_minor is integer PENCE (420000 = £4,200). Divide by 100 for pounds. This is a deliberate departure from the repo's major-unit Decimal money convention.
- mediumDouble-counting canonical + alias rows
A physical test appears as one canonical row (is_canonical=1) plus raw-name alias rows (is_canonical=0) carrying the same rate. Dedupe on canonical_test; prefer canonical rows.
- “What's the labour rate for vacuum decay CCIT testing?”
- “What are the most expensive tests on the rate card?”