person_id_crosswalk

Maps every source identifier onto the person_id used throughout the core layer. Consult this table when you need to trace a warehouse person back to the member or patient identifiers a source system knows them by, or to understand how records from different systems were merged.

At a glance

Schema	dax_core
Table	person_id_crosswalk
Layer	Core Data Model
Object type	table
Columns	7
Grain	person_id, patient_id, member_id, payer, plan, data_source
Tags	core

Columns

Column	Type	Key	Constraints	Description
person_id	varchar	PK	—	Dax identifier for the individual.
patient_id	varchar	PK	—	Patient identifier as issued by a clinical source system.
member_id	varchar	PK	—	Member identifier as issued by a payer.
payer	varchar	PK	—	Payer that issued the member identifier.
plan	varchar	PK	—	Plan associated with the member identifier.
dax_last_run	timestamp		—	Timestamp of the warehouse build that produced this row.
data_source	varchar	PK	—	Label for the contributing system.

Querying

select *
from dax_core.person_id_crosswalk
limit 100;