appointment

One row per scheduled appointment, including appointments that were cancelled or not attended. Appointments link to an encounter only when the appointment resulted in a visit, so use this table for scheduling and access measures such as no-show rates rather than for utilization.

At a glance

Schema	dax_core
Table	appointment
Layer	Core Data Model
Object type	table
Columns	16
Grain	appointment_id, data_source
Tags	core

Columns

Column	Type	Key	Constraints	Description
appointment_id	varchar	PK	not null	—
person_id	varchar		not null	—
patient_id	varchar		—	—
encounter_id	varchar		—	—
start_datetime	timestamp		—	—
end_datetime	timestamp		—	—
duration	integer		—	—
location_id	varchar		—	—
practitioner_id	varchar		—	—
type	varchar		—	—
status	varchar		—	—
reason	varchar		—	—
cancellation_reason	varchar		—	—
ingest_datetime	timestamp		—	—
dax_last_run	timestamp		—	—
data_source	varchar	PK	not null	—

Querying

select *
from dax_core.appointment
limit 100;