Skip to main content
This release adds two tables: health_maintenance for preventive care item completions, and payer for the payers a practice bills through Elation Billing enriched with the Claim.MD payer directory.

​
New Tables

​
Release Highlights

health_maintenance Each row records when a clinician marked a preventive care item as done, including the measure name (e.g., Cervical Cancer Screening), the date of completion, any free-text note entered at the time, and the result flags (normal_result, abnormal_result) defined by the measure rule. measure_code carries the clinical quality measure identifier (CMS or Elation-specific) for practices reporting on quality measures such as HEDIS or CQM. physician_id, firstname, and lastname identify the clinician who recorded the item. Rows with a non-null deleted_date have been removed from the patient’s chart and should generally be excluded from reporting. See the Health Maintenance article for example queries. payer One row per payer saved on an Elation Billing account, per practice. Each row pairs the payer as your account named it with the matching entry from the Claim.MD payer directory:
  • custom_payer_name is the name your billing account gave the payer, which may differ from Claim.MD’s.
  • claimmd_payer_name is Claim.MD’s canonical name for the same payer.
  • payer_id is the Claim.MD-issued payer identifier. It is an external clearinghouse reference, not a Hosted Database key.
  • payer_type is Claim.MD’s category for the payer - commercial, medicaid, medicare, bcbs, champus, or workerscomp.
  • payer_alt_names and payer_alt_ids list the other names and ids Claim.MD knows the payer by, where there are any.
The capability columns describe what Claim.MD supports for the payer: institutional_claims, professional_claims, dental_claims, era, eligibility, workers_compensation, secondary, auto_insurance, and electronic_attachment. Each is yes, no, or enrollment - enrollment meaning the payer supports it once your practice completes enrollment with them. Some payers have no value recorded. avg_era_enroll_days carries Claim.MD’s average number of days for ERA enrollment to complete with that payer. practice_id joins to practice and account_id joins to elation_billing_account. To list the payers set up for your practices that support electronic eligibility checks:
The payer table is present only for practices on the Elation Billing product. If your practice is not on Elation Billing, it is not created in your Hosted Database.
If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>