Conversion and reconciliation
Each conversion cycle extracts the legacy EMR, applies the versioned mapping specification, loads the target and reconciles record counts per domain. Rejected records become exceptions with an owner, a rule and a resolution.
Cycle
Mock load 2
2026-11-02 23:39
Status
Reconciled
Mapping specification v1.1 (17 crosswalk entries added)
Source records
651,043
Legacy EMR
Loaded to target
651,043
100.00% of source
Exceptions
0
0 open across cycles
Record count reconciliation, Mock load 2
| Domain | Source table | Source | Target | Rejected | Unexplained variance | Result |
|---|---|---|---|---|---|---|
| Patients | dbo.patient | 2,500 | 2,500 | 0 | 0 | Reconciled |
| Encounters | dbo.encounter | 80,785 | 80,785 | 0 | 0 | Reconciled |
| Diagnoses | dbo.diagnosis | 116,151 | 116,151 | 0 | 0 | Reconciled |
| Procedures | dbo.procedure_event | 131,467 | 131,467 | 0 | 0 | Reconciled |
| Medications | dbo.medication_order | 57,484 | 57,484 | 0 | 0 | Reconciled |
| Lab results | dbo.lab_result | 259,234 | 259,234 | 0 | 0 | Reconciled |
| Pathology reports | dbo.pathology_report | 3,422 | 3,422 | 0 | 0 | Reconciled |
Rerun after crosswalk fix; all domains reconcile. Source counts are read live from the legacy EMR through the federated query engine; target counts from the lakehouse silver layer.
Cycle history
| Cycle | Run | Status |
|---|---|---|
| Mock load 1 | 2026-11-02 23:39 | Completed with exceptions |
| Mock load 2 | 2026-11-02 23:39 | Reconciled |
Crosswalk entries added
| Legacy code | ICD-10-CM | Approved by |
|---|---|---|
L-ONC-01 | C34.12 | HIM Coding, A. Brennan |
L-ONC-02 | C34.11 | HIM Coding, A. Brennan |
L-ONC-03 | C50.911 | HIM Coding, A. Brennan |
L-ONC-04 | C34.12 | HIM Coding, A. Brennan |
L-ONC-05 | C34.12 | HIM Coding, A. Brennan |
L-ONC-06 | C50.912 | HIM Coding, A. Brennan |
L-ONC-07 | C34.11 | HIM Coding, A. Brennan |
L-ONC-08 | C43.9 | HIM Coding, A. Brennan |
L-ONC-09 | C50.912 | HIM Coding, A. Brennan |
L-ONC-10 | C50.912 | HIM Coding, A. Brennan |
L-ONC-11 | C50.912 | HIM Coding, A. Brennan |
L-ONC-12 | C25.0 | HIM Coding, A. Brennan |
L-ONC-13 | C92.00 | HIM Coding, A. Brennan |
L-ONC-14 | C61 | HIM Coding, A. Brennan |
L-ONC-15 | C43.9 | HIM Coding, A. Brennan |
L-ONC-16 | C34.90 | HIM Coding, A. Brennan |
L-ONC-17 | C61 | HIM Coding, A. Brennan |
Exceptions queue, Mock load 2 (0)
No exceptions in this cycle. Every domain reconciles to the source.