One conformed record per patient spanning diagnosis, staging, treatment lines, encounters and outcomes, keyed by enterprise patient ID. Reconciles the current EHR, the legacy EHR and the MariaDB EDW so both eras read as one history.
10 upstream · 2 downstream · Show in the estate graph
Source · Systems of record, untouched
Bronze · Raw landing, append-only
Silver · Cleaned and conformed
Gold · Certified data products
Serve · Reports, research and AI
SG-DP-ONC-LONGITUDINAL-READAdded to SG-DP-ONC-LONGITUDINAL-READ, recertified every 90 days.
enterprise_patient_id not null
Completeness
One row per patient per line
Uniqueness
Stage group in AJCC 8 value set
Validity
Legacy and current counts reconcile
Conformance
Refreshed within SLA
Timeliness
Pass at 98% or better, warn from 90%. A failing check blocks certification.
| Column | Type | Description | Class |
|---|---|---|---|
| enterprise_patient_id | bigint | Enterprise master patient index key | PHI |
| mrn | varchar(12) | Medical record number in the current EHR | PHI |
| primary_site_icdo3 | varchar(5) | ICD-O-3 topography of the primary tumor | None |
| ajcc_stage_group | varchar(6) | AJCC 8th edition stage group at diagnosis | None |
| diagnosis_date | date | Date of first diagnosis | PHI |
| treatment_line | smallint | Line of systemic therapy, 1 = first line | None |
| source_era | varchar(10) | LEGACY or CURRENT EHR, for reconciliation | None |