Configurable platform. The schema below reflects one engagement configuration. Verdict Consulting Group tailors entities, joins, and reference tables to each matter — payer underpayment, FCA defense, qui tam, or commercial disputes.
Entity Relationships
Configured for current engagement
Primary key Foreign key
Claims
- claim_idvarchar
- patient_iduuid
- provider_iduuid
- payer_iduuid
- service_datedate
- billedmoney
- paidmoney
- statusenum
Patients
- patient_iduuid
- last_namevarchar
- first_namevarchar
- dobdate
- member_novarchar
Service Lines
- line_iduuid
- claim_idvarchar
- procedure_codevarchar
- revenue_codevarchar
- billedmoney
- allowedmoney
- paidmoney
Payments
- payment_iduuid
- claim_idvarchar
- paidmoney
- pat_respmoney
- remit_datedate
Disputes
- dispute_iduuid
- claim_idvarchar
- typeenum
- filed_attimestamp
- outcomeenum
Providers
- provider_iduuid
- namevarchar
- tinvarchar
- specialtyvarchar
Payers
- payer_iduuid
- namevarchar
- einvarchar
- plan_typeenum
Reference Tables
Versioned reference data joined into the analysis pipeline
Benchmarks Master 2024
54,802 rows
Population-level expected payment reference
Procedure Code Master
11,240 rows
Procedure and supply code dictionary
Payer Crosswalk
248 rows
Carrier-to-plan mapping
Demo engagement • Configurable per matter