`input_layer__procedure`

Procedures as received, in the source's own coding system.

At a glance


Schema	`dax_input_layer`
Table	`input_layer__procedure`
Layer	Input Layer
Object type	view
Columns	16
Grain	`source_procedure_id`, `data_source`
Tags	`input_layer`

Column	Type	Key	Constraints	Description
`source_procedure_id`	`varchar`	PK	—	—
`person_id`	`varchar`		—	—
`patient_id`	`varchar`		—	—
`encounter_id`	`varchar`		—	—
`procedure_date`	`date`		—	—
`code_system`	`varchar`		—	—
`source_code`	`varchar`		—	—
`source_description`	`varchar`		—	—
`modifier_1`	`varchar`		—	—
`modifier_2`	`varchar`		—	—
`modifier_3`	`varchar`		—	—
`modifier_4`	`varchar`		—	—
`modifier_5`	`varchar`		—	—
`practitioner_id`	`varchar`		—	—
`ingest_datetime`	`timestamp`		—	—
`data_source`	`varchar`	PK	—	—

select *
from dax_input_layer.input_layer__procedure
limit 100;