From raw data to a certified, interactive data product — six governed steps, no code required.
Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.
Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.
Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.
The AI produces a validated SELECT query tailored to the use case. The query is tested against live data before proceeding — only SELECT statements are permitted.
Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.
The AI recommends the best visualization type and generates the raw program code required for an interactive rendering. Each refinement is a natural language instruction — no code editing required. Every iteration is stored and reusable.
| Column | Definition | Domain | Examples | Synonyms |
|---|---|---|---|---|
| approved_count | The number of healthcare claims that have been reviewed and approved for payment during the reporting month. These claims have met all coverage requirements and policy criteria for reimbursement. | Operations | 1,089, 1,145, 967, 1,234, 1,098 | approved_claims, paid_claims, accepted_count, processed_approvals, authorized_claims |
| avg_processing_days | The average number of calendar days between when healthcare claims were submitted and when they received a final processing decision (approved or denied). This metric measures the efficiency of the claims review workflow. | Operations | 12.3, 14.7, 11.8, 13.2, 15.1 | turnaround_time, processing_time, cycle_time, review_duration, decision_time |
| denial_rate_pct | The percentage of submitted healthcare claims that were denied during the month, calculated by dividing denied claims by total claims. This metric indicates claims quality and adherence to coverage policies. | Operations | 7.0%, 8.9%, 13.5%, 6.9%, 10.3% | rejection_rate, decline_rate, denial_percentage, refusal_rate, disapproval_rate |
| denied_count | The number of healthcare claims that have been rejected and will not be paid during the reporting month. These claims failed to meet coverage requirements, policy criteria, or contained errors requiring correction. | Operations | 87, 123, 156, 98, 134 | rejected_claims, declined_count, denied_claims, rejected_count, disapproved_claims |
| mom_volume_change_pct | The month-over-month percentage change in total claim volume compared to the previous month. Positive values indicate increased claim submissions while negative values show decreased activity, helping identify trends and seasonality patterns. | Operations | 11.4%, -16.8%, 23.1%, -8.8%, 5.7% | volume_growth, monthly_variance, claim_trend, volume_change, submission_growth |
| month | The calendar month and year when healthcare services were provided to patients, used as the primary grouping period for analyzing claims performance trends. This represents the service date month rather than when the claim was submitted or processed. | Operations | 2024-01, 2024-02, 2024-03, 2024-04, 2024-05 | service_month, reporting_period, analysis_period, service_date_month, performance_month |
| payment_ratio_pct | The percentage representing how much of the total requested claim amount was actually paid out. Calculated by dividing total paid amount by total claim amount, this metric indicates payment efficiency and cost management effectiveness. | Finance | 86.9%, 90.8%, 88.1%, 87.2%, 87.1% | payout_ratio, payment_rate, reimbursement_ratio, pay_through_rate, settlement_ratio |
| pending_count | The number of healthcare claims that are still under review and have not yet received a final approval or denial decision by the end of the reporting month. These claims are in various stages of the review process. | Operations | 71, 121, 33, 91, 66 | under_review, in_process, pending_review, outstanding_claims, unresolved_claims |
| total_claim_amount | The sum of all dollar amounts requested across all healthcare claims submitted during the month. This represents the total value of medical services for which reimbursement was requested, before any payment decisions were made. | Finance | $2,456,789, $2,187,432, $2,789,123, $2,634,567, $2,398,234 | billed_amount, requested_amount, claim_value, submitted_amount, gross_claim_value |
| total_claims | The complete count of all healthcare claims received during a specific month, regardless of their current processing status. This includes all claims whether they have been approved, denied, or are still pending review. | Operations | 1,247, 1,389, 1,156, 1,423, 1,298 | claim_count, total_submissions, claim_volume, monthly_claims, submitted_claims |
| total_paid_amount | The sum of all dollar amounts actually paid out for approved healthcare claims during the month. This represents the total financial liability incurred by the health plan for covered medical services. | Finance | $2,134,567, $1,987,234, $2,456,890, $2,298,123, $2,089,456 | reimbursed_amount, paid_out, settlement_amount, disbursed_amount, actual_payments |