input_layer__medication
Medication orders and administrations as received from clinical source systems. Distinct from input_layer__pharmacy_claim, which carries dispensed fills.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__medication |
| Layer | Input Layer |
| Object type | view |
| Columns | 20 |
| Grain | medication_id, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
medication_id | varchar | PK | — | — |
person_id | varchar | — | — | |
patient_id | varchar | — | — | |
encounter_id | varchar | — | — | |
dispensing_date | date | — | — | |
prescribing_date | date | — | — | |
source_code_type | varchar | — | — | |
source_code | varchar | — | — | |
source_description | varchar | — | — | |
ndc_code | varchar | — | — | |
rxnorm_code | varchar | — | — | |
atc_code | varchar | — | — | |
route | varchar | — | — | |
strength | varchar | — | — | |
quantity | number | — | — | |
quantity_unit | varchar | — | — | |
days_supply | number | — | — | |
practitioner_id | varchar | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__medication
limit 100;