Version: Canary - 2.4 🚧

v2_4_0

Generated: 2026-02-03 21:32:40

Overview

This analysis examines the accuracy of canonical rates by analyzing scoring patterns and identifying potential outliers based on Medicare rate comparisons.

1. Outlier Score Analysis

Error retrieving outlier score statistics: Execution failed on sql: SELECT COUNT(*) as outlier_score_count FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all WHERE canonical_rate_score = 1

TrinoUserError(type=USER_ERROR, name=TABLE_NOT_FOUND, message="line 3:18: Table 'tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all' does not exist", query_id=20260204_023241_33949_tzdjd) unable to rollback

2. cbsa Medicare Rate Outliers

No cbsa Medicare rate outliers found.

Error: Execution failed on sql: SELECT provider_type, bill_type, COUNT(*) as count, COUNT(CASE WHEN canonical_rate < 0.8 * cbsa_avg_medicare_rate THEN 1 END) as below_80pct_count, COUNT(CASE WHEN canonical_rate > 15 * cbsa_avg_medicare_rate THEN 1 END) as above_15x_count FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all WHERE canonical_rate_score > 1 GROUP BY provider_type, bill_type ORDER BY count DESC

TrinoUserError(type=USER_ERROR, name=TABLE_NOT_FOUND, message="line 8:18: Table 'tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all' does not exist", query_id=20260204_023241_33950_tzdjd) unable to rollback

3. Medicare Rate Outliers

No Medicare rate outliers found.

Error: Execution failed on sql: SELECT provider_type, bill_type, COUNT(*) as count, COUNT(CASE WHEN canonical_rate < 0.8 * medicare_rate THEN 1 END) as below_80pct_count, COUNT(CASE WHEN canonical_rate > 15 * medicare_rate THEN 1 END) as above_15x_count FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all WHERE canonical_rate_score > 1 GROUP BY provider_type, bill_type ORDER BY count DESC

4. Canonical Rate Score Distribution

No score distribution data found.

Error: Execution failed on sql: SELECT canonical_rate_score, COUNT() as record_count, ROUND(1.000 * COUNT() / SUM(COUNT(*)) OVER(), 2) as percentage FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all GROUP BY canonical_rate_score ORDER BY canonical_rate_score

TrinoUserError(type=USER_ERROR, name=TABLE_NOT_FOUND, message="line 6:18: Table 'tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all' does not exist", query_id=20260204_023241_33952_tzdjd) unable to rollback

4.1. Canonical Rate Score Distribution by Provider Type

No score distribution data by provider type found.

Error: Execution failed on sql: SELECT provider_type, canonical_rate_score, COUNT() as record_count, ROUND(1.000 * COUNT() / SUM(COUNT(*)) OVER(PARTITION BY provider_type), 2) as percentage FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all GROUP BY provider_type, canonical_rate_score ORDER BY provider_type, canonical_rate_score

TrinoUserError(type=USER_ERROR, name=TABLE_NOT_FOUND, message="line 7:18: Table 'tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all' does not exist", query_id=20260204_023241_33953_tzdjd) unable to rollback

5. Extreme Rate Ratios by Code Combination

No code combinations with rates < 0.2x Medicare found.

Error: Execution failed on sql: SELECT provider_type, bill_type, billing_code, COUNT() as total_records, COUNT(CASE WHEN canonical_rate < 0.2 * medicare_rate THEN 1 END) as below_20pct_count, ROUND(1.000 * COUNT(CASE WHEN canonical_rate < 0.2 * medicare_rate THEN 1 END) / COUNT(), 2) as below_20pct_percentage FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all WHERE canonical_rate_score > 1 AND medicare_rate IS NOT NULL AND medicare_rate > 0 GROUP BY provider_type, bill_type, billing_code HAVING COUNT(CASE WHEN canonical_rate < 0.2 * medicare_rate THEN 1 END) > 0 ORDER BY below_20pct_count DESC, below_20pct_percentage DESC LIMIT 20

TrinoUserError(type=USER_ERROR, name=TABLE_NOT_FOUND, message="line 9:18: Table 'tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all' does not exist", query_id=20260204_023241_33954_tzdjd) unable to rollback

No code combinations with rates > 10x Medicare found.

Error: Execution failed on sql: SELECT provider_type, bill_type, billing_code, COUNT() as total_records, COUNT(CASE WHEN canonical_rate > 10 * medicare_rate THEN 1 END) as above_10x_count, ROUND(1.000 * COUNT(CASE WHEN canonical_rate > 10 * medicare_rate THEN 1 END) / COUNT(), 2) as above_10x_percentage FROM tq_dev.internal_dev_csong_cld_v2_4_0.prod_combined_all WHERE canonical_rate_score > 1 AND medicare_rate IS NOT NULL AND medicare_rate > 0 GROUP BY provider_type, bill_type, billing_code HAVING COUNT(CASE WHEN canonical_rate > 10 * medicare_rate THEN 1 END) > 0 ORDER BY above_10x_count DESC, above_10x_percentage DESC LIMIT 20

Overview​

1. Outlier Score Analysis​

2. cbsa Medicare Rate Outliers​

3. Medicare Rate Outliers​

4. Canonical Rate Score Distribution​

4.1. Canonical Rate Score Distribution by Provider Type​

5. Extreme Rate Ratios by Code Combination​

On this page: