Longitudinal Oncology Record Certified
One row per patient per clinical event: encounters, diagnoses, procedures, medications, labs and pathology from the legacy EMR and future EHR, keyed on the enterprise patient identifier.
Product card
Version
1.3.0
Domain
Clinical
Owner
Clinical Informatics
Steward
Dr. Anna Kowalczyk
Sensitivity
PHI, restricted
Refresh
Daily 05:00
Rows
689,071
SQL endpoint
lakehouse.gold.dp_longitudinal_oncology_recordREST endpoint
/api/data-products/longitudinal-oncology-record/rowsLineage inputs
silver.encounter, silver.diagnosis, silver.procedure, silver.medication, silver.lab, silver.pathology_report, silver.patientConsumers
| Consumer type | Consumer |
|---|---|
| Power BI semantic model | Oncology Operations (Direct Lake) |
| Research | Cohort discovery platform, OMOP build |
| AI | Clinical summary agent (approved fields only) |
| Application | Tumor board viewer |
Quality checks
| Check | Result | Status |
|---|---|---|
| Row count greater than zero | 689,071 rows | Passed |
| enterprise_patient_id is never null | 0 null | Passed |
| Every row links to an enterprise patient | 0 orphans | Passed |
Schema (7 columns)
| Column | Type | Nullable | Classification |
|---|---|---|---|
enterprise_patient_id | uuid | YES | Identifier |
event_type | text | YES | |
event_dt | date | YES | |
code | text | YES | |
description | text | YES | |
source_system | text | YES | |
encounter_id | integer | YES |
Sample (8 rows)
| enterprise_patient_id | event_type | event_dt | code | description | source_system | encounter_id |
|---|---|---|---|---|---|---|
| a327e8b3-dc29-6460-bcc1-5de03520a3dd | Procedure | 2023-02-21 | 99442 | Telephone evaluation and management service, 11 to 20 minutes | Legacy EMR | 103,033 |
| b0092624-5d79-8b80-1c3e-af162a581f37 | Encounter | 2022-03-17 | telehealth | Thoracic Oncology | Legacy EMR | 108,292 |
| 9da02374-aaa3-3da8-1d4b-58c808873b4e | Procedure | 2023-05-16 | 99214 | Office or other outpatient visit, established patient, moderate complexity | Legacy EMR | 123,273 |
| 1bbee17f-24e2-d223-70f3-f2b48c3a4c5c | Procedure | 2023-07-30 | 99214 | Office or other outpatient visit, established patient, moderate complexity | Legacy EMR | 109,057 |
| 128e9ad2-0a78-57b6-1453-fd424419cab1 | Lab result | 2014-06-28 | 6690-2 | Leukocytes [#/volume] in Blood by Automated count: 2.930 10*3/uL | Legacy EMR | 110,998 |
| 0cba01f9-a0c3-9f5f-e759-6e261f76bd4b | Claim | 2020-11-05 | Independent Health | Medical Oncology, billed 470.60, denied | MariaDB EDW | 136,282 |
| f999e048-1eac-2ecf-a273-267c1f41e756 | Claim | 2022-03-22 | Excellus BCBS | Medical Oncology, billed 488.70, denied | MariaDB EDW | 145,845 |
| 647132a9-67e6-1c95-c568-2fad6b294447 | Lab result | 2018-07-24 | 2160-0 | Creatinine [Mass/volume] in Serum or Plasma: 0.954 mg/dL | Legacy EMR | 105,148 |