RPT-06 · Deal Pipeline & Aging

Certified report viewer — audience: Sales & Executive. Definition owner: Rashid Al Farsi (Sales Manager). Deals, stages, offers and value with full stage history and a governed probability basis · refresh ≤ 15 minutes.

RPT-06

Report header — ownership, dataset & refresh state (§9.2) Operational · ≤ 15 min Certified daily 06:00

Report owner: Rashid Al Farsi — Sales Manager (definition owner)
Metric owners: Pipeline value & aging — Rashid Al Farsi · Forecast roll-up — Fatima Rashid (feeds RPT-01)
Authoritative dataset: dwh.certified.deal_pipeline_v2 — deal grain with immutable stage history (AED · Asia/Dubai GST)
Refresh cadence: Incremental every 15 min · certified daily build 06:00 GST
Last refresh: 17 Jul 2026 14:15:09 GST Fresh · cycle 14:15
Last certified build: 17 Jul 2026 06:03:44 GST Reconciled to deal master
Certification state: Certified daily · Operational intraday deltas · forecast Provisional until P07 close
Definition version: DEF-RPT-06 v2.2 — approved 05 Jun 2026 (change CR-2026-119)
Governing policy versions: STAGE-PROB v3 (probability basis) · DEAL-STAGE-DEF v5 · AUTH-MATRIX v9 · EXPORT-POL v4

Report control (Table 15) — stage history and probability basis Weighted values use the governed probability basis STAGE-PROB v3 (stage defaults: Qualified 25% · Viewing 40% · Offer 65% · Contract 80% · Handover 95%). Manager overrides of a deal's probability require a recorded reason and appear as Override with the original basis retained; the full stage history behind every aging figure is immutable and drillable. Exports are watermarked, exclude customer contact PII, and are logged to the Audit Explorer.

Open deals

Dubai HQ 39 · Abu Dhabi 8

Open value (gross)

AED 96.4M

▲ 4.1% vs 01 Jul

Weighted pipeline

AED 41.2M

STAGE-PROB v3 · 3 overrides active

Median stage age

Target ≤ 14d per stage

Stalled > 30d

▼ AED 11.9M at risk — review scheduled

Open value by stage — gross AED mGoverned stage dimension

Stage	Deals	Gross AED	Default prob.	Weighted AED	Median age
Qualified	14	36,800,000.00	25%	9,200,000.00	6d
Viewing	11	18,500,000.00	40%	7,400,000.00	8d
Offer	12	18,200,000.00	65%	11,830,000.00	11d
Contract	9	15,800,000.00	80%	12,640,000.00	13d
Handover	1	7,100,000.00	95%	130,000.00 *	4d
Total open	47	96,400,000.00	—	41,200,000.00	9d

* Handover weighted value nets out the amount already invoiced — basis note in DEF-RPT-06 v2.2. Overrides change deal-level weighting only.

Aging distribution — days in current stage6 stalled

Bucket	Deals	Gross AED	Action
0–7 days	19	38,400,000.00	Healthy
8–14 days	13	26,900,000.00	Healthy
15–30 days	9	19,200,000.00	Watch
31–60 days	4	8,100,000.00	Stalled — review 20 Jul
60+ days	2	3,800,000.00	Escalated to Rashid Al Farsi
Total	47	96,400,000.00	—

Deal detail — open pipeline (10 of 47) Refreshed 14:15

Deal / customer	Unit(s)	Stage	Gross AED	Probability (basis)	Weighted AED	Days in stage	Aging
DL-2026-0142 · Amina Noor Agent: Omar Haddad · lead LD-2026-04512	PR-A-1103	Offer	1,850,000.00	65% — stage default	1,202,500.00	3	0–7d
DL-2026-0138 · Falcon Trading FZ-LLC Agent: Layla Hassan · corporate · UBO checks cleared	4 units · Building B	Contract	8,900,000.00	85% — override (Rashid Al Farsi: “board approval received”)	7,565,000.00	9	8–14d
DL-2026-0129 · Hessa Al Marri Agent: Layla Hassan · offer OF-2026-0281 pending approval	PR-B-3204	Offer	2,340,000.00	65% — stage default	1,521,000.00	8	8–14d
DL-2026-0117 · Dmitri Volkov Agent: Omar Haddad · viewing outcome overdue	PR-A-2201	Viewing	3,560,000.00	40% — stage default	1,424,000.00	12	8–14d
DL-2026-0104 · Ravi Patel Agent: Omar Haddad · co-broke Prime Link Realty 50/50	PR-B-1902	Qualified	3,420,000.00	25% — stage default	855,000.00	18	15–30d
DL-2026-0096 · Sara Lim Agent: Layla Hassan · financing pre-approval awaited	PR-A-0904	Offer	1,720,000.00	50% — override (financing risk, reason recorded)	860,000.00	21	15–30d
DL-2026-0088 · Noor Al Hashimi Agent: Saeed Al Ameri · Abu Dhabi Branch	AD unit — external	Viewing	1,980,000.00	40% — stage default	792,000.00	26	15–30d
DL-2026-0071 · Marcus Webb Agent: Omar Haddad · renegotiation after price change	PR-A-1408	Offer	2,150,000.00	65% — stage default	1,397,500.00	38	31–60d — stalled
DL-2026-0064 · Masked — EXEC scope Agent: Nadia Boulos · customer name requires DEAL-SENSITIVE	PR-●-●●●●	Contract	2,750,000.00	80% — stage default	2,200,000.00	44	31–60d — legal review
DL-2026-0042 · Falcon Trading FZ-LLC (phase 1) Agent: Layla Hassan · awaiting developer NOC since 09 May	PR-B-2106	Contract	2,290,000.00	80% — stage default	1,832,000.00	69	60+d — escalated
Total open (all 47 deals)			96,400,000.00	3 overrides active	41,200,000.00	Reconciliation: 47 open deals = deal master open count 14:15 · weighted total matches RPT-01 pipeline tile · difference AED 0.00

Lineage — source → transformation → report (§9.2)Evidence linked

crm.deals · crm.stage_history · prop.offers → stg.pipeline_15m (incremental) → sem.deal_pipeline v2 (probability basis applied) → Certify 06:00: count & value = deal master → RPT-06 viewer → feeds RPT-01

Source	Extracted	Rows	Status
`crm.deals` (open + 90d closed)	14:15:06	214	Checksum OK
`crm.stage_history` (immutable)	14:15:07	1,236	Checksum OK
`prop.offers`	14:15:08	61	Checksum OK
`cfg.stage_prob` = STAGE-PROB v3	06:00:02	5	Policy snapshot pinned
Probability overrides join from `crm.deal_overrides` with reason + approver · evidence retained 7 years

Definition of done (§9.2) — RPT-06Published

Checklist item	Status
Named owner, business definition, authoritative dataset, lineage	Met — DEF-RPT-06 v2.2
Filters, dimensions, currency/time-zone (AED · GST), refresh & certification state	Met
Permission-aware drill-down; masked sensitive deals; watermarked export	Met — EXPORT-POL v4
Reconciliation to deal master and RPT-01 pipeline tile, zero tolerance	Met — diff 0.00
Accessible table/chart alternatives; approved EN/AR labels	Met — AR label set v2

Related screens: Deal workspace · Offer builder · CRM analytics · RPT-07 Commission statement.

Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 §9.1 Table 15, §9.2 · Covers: RPT-06.