Total gross A/R at month end divided by average daily gross charges over the trailing 90 days. One certified definition used by every report and by the AI layer.
5 upstream · 0 downstream · Show in the estate graph
Source · Systems of record, untouched
Bronze · Raw landing, append-only
Silver · Cleaned and conformed
Gold · Certified data products
Serve · Reports, research and AI
SG-PBI-RC-VIEWERSAdded to SG-PBI-RC-VIEWERS, recertified every 90 days.
Matches finance close within 0.5 days
Conformance
No gaps in the month series
Completeness
Refreshed within SLA
Timeliness
Pass at 98% or better, warn from 90%. A failing check blocks certification.
| Column | Type | Description | Class |
|---|---|---|---|
| month_end | date | Calendar month end | None |
| gross_ar | decimal(14,2) | Gross A/R at month end | None |
| avg_daily_charges_90d | decimal(14,2) | Trailing 90-day average daily gross charges | None |
| days_in_ar | decimal(6,1) | gross_ar / avg_daily_charges_90d | None |