Enterprise Patient Certified
Current enterprise patient record with the enterprise patient identifier and the source system MRNs it links. Stable across the EHR transition.
Product card
Version
1.0.2
Domain
Master data
Owner
Enterprise Data Management
Steward
Kevin Tran
Sensitivity
PHI, restricted
Refresh
Hourly
Rows
2,500
SQL endpoint
lakehouse.gold.dp_enterprise_patientREST endpoint
/api/data-products/enterprise-patient/rowsLineage inputs
silver.patientConsumers
| Consumer type | Consumer |
|---|---|
| Research | Honest broker linkage service |
| Application | Patient matching API |
| Power BI semantic model | Patient Access |
Quality checks
| Check | Result | Status |
|---|---|---|
| Row count greater than zero | 2,500 rows | Passed |
| enterprise_patient_id is never null | 0 null | Passed |
| enterprise_patient_id is unique | 0 duplicates | Passed |
Schema (12 columns)
| Column | Type | Nullable | Classification |
|---|---|---|---|
enterprise_patient_id | uuid | YES | Identifier |
source_mrns | text | YES | |
sex | text | YES | |
birth_year | integer | YES | |
zip3 | text | YES | |
primary_cancer_site | text | YES | |
first_cancer_dx_date | date | YES | |
first_encounter_dt | date | YES | |
last_encounter_dt | date | YES | |
encounter_count | bigint | YES | |
deceased_flag | boolean | YES | |
is_current | boolean | YES |
Sample (8 rows)
| enterprise_patient_id | source_mrns | sex | birth_year | zip3 | primary_cancer_site | first_cancer_dx_date | first_encounter_dt | last_encounter_dt | encounter_count | deceased_flag | is_current |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 63804313-7a72-0e8d-593e-3e8a0d27d6c7 | legacy_emr:RP1025284; edw:RP1025284 | M | 1,935 | 142 | Colon | 2017-05-24 | 2017-05-24 | 2026-06-21 | 35 | False | True |
| ccff79a8-a981-abc9-fa52-4b55ce595289 | legacy_emr:RP1021295; edw:RP1021295 | M | 1,985 | 142 | Melanoma | 2021-05-07 | 2021-05-07 | 2026-06-16 | 27 | False | True |
| 2565f33d-60fc-41b3-63a3-e21c01c1110b | legacy_emr:RP1030331; edw:RP1030331 | F | 1,959 | 140 | Breast | 2021-06-28 | 2021-06-28 | 2026-05-28 | 24 | False | True |
| 03baa766-2b17-eddc-89fd-5219675dd2ba | legacy_emr:RP1029538; edw:RP1029538 | M | 1,952 | 147 | Melanoma | 2011-11-08 | 2011-11-08 | 2026-09-25 | 50 | False | True |
| 2a97d502-e331-840c-060a-a485f5e213e7 | legacy_emr:RP1011967; edw:RP1011967 | M | 1,931 | 140 | Colon | 2023-04-30 | 2023-04-30 | 2026-08-12 | 21 | False | True |
| 38de9cd7-9574-32ff-21ed-7c5fffeab835 | legacy_emr:RP1020525; edw:RP1020525 | F | 1,956 | 142 | Colon | 2022-09-04 | 2022-09-04 | 2026-06-17 | 20 | False | True |
| 5780151b-f0b5-5122-3b0e-1ed2ca462138 | legacy_emr:RP1015221; edw:RP1015221 | F | 1,956 | 140 | Pancreas | 2017-04-21 | 2017-04-21 | 2018-02-22 | 10 | True | True |
| 062aa53a-dbc6-8758-a723-6d98026e44ca | legacy_emr:RP1015110; edw:RP1015110 | F | 1,947 | 141 | Breast | 2021-01-28 | 2021-01-28 | 2026-09-20 | 29 | False | True |