Tables

List of source tables referenced by the CareQuery API

• AFFILIATION_TABLE
  • This table takes the monthly updates to the CMS NPPES database, cleans, normalizes and orients their output into a concise feature set built for consumption.
• ALLOWED_AVGS_TABLE
  • This table gives users the ability to visualize the statistical shape of allowed amounts for procedure-specific claims across the US.
• DIAG_TABLE
  • This table provides helpful context and categories around ICD-10 diagnosis codes.
• DRG_TABLE
  • This table provides helpful context and categories around Diagnosis Related Groups (DRGs) for inpatient medical billing.
• EXEC_OUTREACH_TABLE
  • This table provides methods of outreach for hospital and health system executives, including email, LinkedIn and role context.
• GEO_TABLE
  • This table provides a comprehensive view of every geographic area in the US, providing population and growth statistics from zip and county to geographic US regions.
• JOURNEY_TABLE
  • This table offers comprehensive detail of longitudinal patient journeys, with line-item encounter detail, insight into payor, provider, procedure, revenue code, charges and SmartAllowedAmount®.
• MIPS_TABLE
  • This table takes the monthly updates to the CMS MIPS database, cleans, normalizes and orients their output into a concise feature set built for consumption.
• NPPES_TABLE
  • This table takes the monthly updates to the CMS NPPES database, cleans, normalizes and orients their output into a concise feature set built for consumption.
• PROC_TABLE
  • This table provides helpful context and categorical mapping around CPT/HCPCS procedure codes.
• PROVIDER_OUTREACH_TABLE
  • This table provides methods of outreach for individual healthcare providers, including emails, and primary locations.
• SCRIPT_TABLE
  • This table provides prescription claim with comprehensive drug and provider details, across entire longitudinal journeys.
• SCRIPT_DETAIL_TABLE
  • This table provides ingredient, company, and categorical detail for all FDA National Drug Codes (NDCs).
• SPECIALTY_TABLE
  • This table provides helpful context and categories around taxonomy codes and specialty mappings.