input_layer__appointment
Scheduled appointments as received, including cancellations and no-shows.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__appointment |
| Layer | Input Layer |
| Object type | view |
| Columns | 15 |
| Grain | appointment_id, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
appointment_id | varchar | PK | — | — |
person_id | varchar | — | — | |
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 | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__appointment
limit 100;