Skip to main content
Version: 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

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_33951_tzdjd) unable to rollback

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

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_33955_tzdjd) unable to rollback

On this page: