Business meaning
Forward-looking forecast of recoverable cash, risk, and expected collections.
Grain: One row per forecast date and payer or department segment
Governance asset
Inspect the governed asset behind the KPI story, including contract shape, lineage proof, freshness, tests, and downstream impact.
Revenue Cycle Management
analytics.fct_cash_forecast
Forward-looking forecast of recoverable cash, risk, and expected collections.
Grain: One row per forecast date and payer or department segment
Revenue Operations Analytics
Steward: CFO Analytics Lead | Contact path not yet instrumented
| Column | Type | Class | Workspace |
|---|---|---|---|
forecast_date | date | internal | Exposed |
expected_cash | numeric | internal | Exposed |
recoverable_cash | numeric | internal | Exposed |
cash_at_risk | numeric | internal | Exposed |
confidence_score | numeric | internal | Exposed |
Traceability
Freshness
Operational SLAs with live elapsed-time tracking against the source landing zone.
Change Management
If a source changes, this shows the downstream models and product surfaces that need revalidation.
Quality
dbt tests are surfaced alongside the live data product so every metric carries visible validation coverage.
Compliance
PII tagging, retention, masking posture, and audit expectations brought into the same product surface as the live metrics.
Critical models: 0 hours
Analytics models: 0 hours
Reference data: 0 hours
Status: Some sources need attention
All data access logged with 0-day retention.
PII access requires authentication and an audit entry.
Last audit query: unknown.