Enterprise Metrics Certified

Governed metric definitions with calculation logic, owner and version. Each metric is defined once and reused by semantic models, reports and applications.

Product card

Version

1.4.0

Domain

Governance

Owner

Data Governance Council

Steward

Maria Delgado

Sensitivity

Internal

Refresh

On change

Rows

SQL endpoint

lakehouse.gold.metric_definitions

REST endpoint

/api/data-products/enterprise-metrics/rows

Lineage inputs

gold.dp_revenue_cycle, gold.fact_encounter

Consumers

Consumer type	Consumer
Power BI semantic model	All certified models
Catalog	Glossary terms
AI	Metric definitions for natural-language queries

Quality checks

Check	Result	Status
Row count greater than zero	5 rows	Passed
metric_id is never null	0 null	Passed
metric_id is unique	0 duplicates	Passed

Schema (7 columns)

Column	Type	Nullable
`metric_id`	text	YES
`name`	text	YES
`definition`	text	YES
`sql_expression`	text	YES
`owner`	text	YES
`certified`	boolean	YES
`version`	text	YES

Sample (8 rows)

metric_id	name	definition	sql_expression	owner	certified	version
MET-002	Denial rate	Denied claims as a percent of all submitted claims, by claim month and payer.	avg(case when denied_flag then 1.0 else 0.0 end)	Revenue Cycle	True	1.1
MET-005	Thirty day readmission rate	Inpatient admissions within 30 days of a prior inpatient discharge as a percent of inpatient admissions.	avg(case when readmit_30d_flag then 1.0 else 0.0 end) filter (where encounter_type = 'inpatient')	Quality and Patient Safety	False	0.9
MET-004	New cancer patients per month	Patients whose first primary oncology diagnosis falls in the month, by primary cancer site.	count(distinct enterprise_patient_id) filter (where first_cancer_dx_date between month_start and month_end)	Strategy and Planning	True	1.0
MET-003	Days in accounts receivable	Average days from claim submission to payment for paid claims.	avg(days_to_pay)	Finance	True	1.0
MET-001	Net collection rate	Payments received as a percent of allowed amount, excluding denied claims, by claim month.	sum(paid_amount) / nullif(sum(allowed_amount) filter (where not denied_flag), 0)	Revenue Cycle	True	1.2