Skip to main content

Data Model Overview

Provisional schema

Reconstructed from application binaries (DataWindow bindings and embedded SQL), not from Oracle DDL. Column types are the application's declared types; constraints, indexes, triggers and exact server types are unknown until an Oracle DDL export is reconciled.

The application operates on 456 tables (reconstructed; includes some views/temp tables). Tables are grouped into subject areas below. Relationship links were inferred from join usage in 620 distinct equijoin pairs found in application SQL.

Subject areaTables
Claims67
Members, Enrollment & Eligibility16
Groups, Clients & Benefit Plans31
Billing, Funding & Payments37
COBRA14
Drug Plans11
Utilization & Case Management42
Stop-Loss10
Providers & Repricing27
EDI & Interfaces18
System, Security & Reference27
Other / Unclassified156