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 1
2026-11-02 23:39
Status
Completed with exceptions
Mapping specification v1.0
Source records
651,043
Legacy EMR
Loaded to target
650,994
99.99% of source
Exceptions
49
0 open across cycles
Record count reconciliation, Mock load 1
| Domain | Source table | Source | Target | Rejected | Unexplained variance | Result |
|---|---|---|---|---|---|---|
| Patients | dbo.patient | 2,500 | 2,488 | 12 | 0 | Open |
| Encounters | dbo.encounter | 80,785 | 80,785 | 0 | 0 | Reconciled |
| Diagnoses | dbo.diagnosis | 116,151 | 116,114 | 37 | 0 | Open |
| 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 |
First full extract through the conversion framework. 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 1 (49)
| Domain | Record | Rule | Detail | Owner | Status | Resolution |
|---|---|---|---|---|---|---|
| Diagnoses | diagnosis_id 2638 (MRN RP1002850) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-02 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 02 MALIGNANT NEOPLASM OF UPPER LOBE, RIGHT BRONCHUS OR LUNG | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 3633 (MRN RP1003189) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-17 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 17 MALIGNANT NEOPLASM OF PROSTATE | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 7147 (MRN RP1004122) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-10 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 10 MALIGNANT NEOPLASM OF UNSPECIFIED SITE OF LEFT FEMALE BREAST | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 8935 (MRN RP1004654) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-14 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 14 MALIGNANT NEOPLASM OF PROSTATE | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 13151 (MRN RP1005770) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-15 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 15 MALIGNANT MELANOMA OF SKIN, UNSPECIFIED | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 19817 (MRN RP1007577) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-01 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 01 MALIGNANT NEOPLASM OF UPPER LOBE, LEFT BRONCHUS OR LUNG | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 19891 (MRN RP1007606) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-13 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 13 ACUTE MYELOBLASTIC LEUKEMIA, NOT HAVING ACHIEVED REMISSION | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 20200 (MRN RP1007724) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-02 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 02 MALIGNANT NEOPLASM OF UNSPECIFIED SITE OF RIGHT FEMALE BREAS | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 20449 (MRN RP1007790) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-04 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 04 MALIGNANT NEOPLASM OF UPPER LOBE, LEFT BRONCHUS OR LUNG | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 20971 (MRN RP1007943) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-01 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 01 MALIGNANT NEOPLASM OF HEAD OF PANCREAS | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 22565 (MRN RP1008372) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-12 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 12 MALIGNANT NEOPLASM OF HEAD OF PANCREAS | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 22566 (MRN RP1008372) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-02 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 02 MALIGNANT NEOPLASM OF HEAD OF PANCREAS | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 25553 (MRN RP1009217) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-16 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 16 MALIGNANT NEOPLASM OF UNSPECIFIED PART OF UNSPECIFIED BRONCH | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
| Diagnoses | diagnosis_id 26790 (MRN RP1009588) | DX-04 ICD-10-CM code required | Legacy problem list code L-ONC-01 has no ICD-10-CM crosswalk entry: LEGACY ONC CODE 01 MALIGNANT NEOPLASM OF UPPER LOBE, LEFT BRONCHUS OR LUNG | HIM Coding, A. Brennan | Resolved | Crosswalk entry approved by HIM Coding and applied in mapping specification v1.1 |
Showing 14 of 49 exceptions.