procedure

One row per recorded procedure, from claims and clinical sources, with source and normalized codes plus modifiers. Use procedure_family and procedure_name for grouped analysis and the modifier columns when billing detail matters.

At a glance

Schema	dax_core
Table	procedure
Layer	Core Data Model
Object type	table
Columns	23
Grain	procedure_id
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
procedure_id	varchar	PK	—	not null	Dax identifier for the procedure record.
person_id	varchar		—	not null	The individual who received the procedure.
member_id	varchar		—	—	—
patient_id	varchar		—	—	—
encounter_id	varchar		—	—	Encounter during which the procedure was performed, where known.
claim_id	varchar		—	—	—
procedure_date	date		—	—	Date the procedure was performed.
practitioner_id	varchar		Provider	—	Practitioner who performed the procedure.
code_system	varchar		Code type	—	Coding system of source_code.
source_code	varchar		ICD-10-PCS	—	Procedure code exactly as it arrived from the source.
source_description	varchar		—	—	—
normalized_code	varchar		ICD-10-PCS	—	Procedure code after terminology normalization.
normalized_description	varchar		HCPCS level 2	—	—
procedure_family	varchar		—	—	Broad grouping of the normalized procedure.
procedure_name	varchar		—	—	Human-readable name of the normalized procedure.
modifier_1	varchar		HCPCS level 2	—	—
modifier_2	varchar		HCPCS level 2	—	—
modifier_3	varchar		HCPCS level 2	—	—
modifier_4	varchar		HCPCS level 2	—	—
modifier_5	varchar		HCPCS level 2	—	—
ingest_datetime	timestamp		—	—	—
dax_last_run	timestamp		—	—	Timestamp of the warehouse build that produced this row.
data_source	varchar		—	not null	Label for the contributing system.

Querying

select *
from dax_core.procedure
limit 100;