Definition
Overview
Section titled “Overview”mart_mds_emar contains item-level records of electronic medicines administration history for patients managed under the Monitored Dosage System in nursing homes. Each row represents a unique combination of an administration history entry and a dispensed item, linked to a pharmacy, nursing home, and patient.
Key Data Fields
Section titled “Key Data Fields”| Field | Description |
|---|---|
| emar_history_id | Identifier for the electronic medicines administration history record. |
| emar_history_item_id | Identifier for the dispensed item within the administration history record. |
| date_added | Date and time the administration history record was created. |
| date_sent | Date and time the administration record was sent to the system. |
| product_name | Name of the medicinal product associated with the administration item. |
| nursing_home_name | Nursing home the patient is associated with. |
| emar_status_id | Status identifier for the administration history record. |
| MDS_inactive | Date and time from which the patient became inactive on the Monitored Dosage System. |
Source
Section titled “Source”Electronic medicines administration history data is sourced via stg_emar_history and stg_emar_history_item in the staging layer. Patient, nursing home, pharmacy, and product information is joined from stg_pharmacy_patient, stg_nursing_home, stg_nursing_home_type, active_pharmacy, and dim_product_pack in the control layer. The full lineage is: stg_emar_history + stg_emar_history_item → mds_emar → mart_mds_emar.
This model is incremental and updates when new data is ingested in stg_emar_history or stg_emar_history_item.