Medication Job
- ConfigurationColumnsToIgnore apply for this module ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix )
- incrementalUpdateConfig is applicable ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update )
The medicines ordered for the patients will be flattened into one table namely medication_data.
Configuration
ColumnsToIgnore apply for this module ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix )
incrementalUpdateConfig is applicable ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update )
Existing OpenMRS tables
Flattened mart tables
Incremental Config:
Please check this section on how to enable/disable incremental config for specific mart tables.
a) medication_data_default
| Column Name | Description |
|---|---|
| patient_id | Patient id |
| program_id | Program Id of the patient for which he is enrolled to. |
| patient_program_id | Patient program id |
| patient_program_name | Patient program nameEg: Reconstructive Surgery |
| order_id | Drug order id |
| coded_drug_name | Drug coded nameEg: FERROUS sulphate 256mg (=80 mg iron) |
| non_coded_drug_name | Drug non-coded nameEg: Candesartan |
| dose | Dose of the drugEg: 1, 500 |
| dose_units | Dosage unitsEg: Tablets(s), mg |
| frequency | Drug consumption frequencyEg: Twice a day |
| route | Drug consumption routeEg: Oral, Intravenous |
| start_date | Medication start date |
| calculated_end_date | Medication end date |
| date_stopped | Medication stopped date |
| stop_reason | Medication stopped reason |
| duration | Medication duration(in quantity_units) |
| duration_units | Duration unitsEg: Week(s), Day(s) |
| quantity | Drugs quantity for whole duration(in quntity_units)Eg: 14, 4800 |
| quantity_units | Drugs quantity in unitsEg: Tablet(s), mg |
| additional_instructions | Any other instructions given on medication |
| dispense | Whether drugs dispensed or notEg: Yes |
| encounter_id | Id reference to encounter from encounter table in openmrs |
| orderer_id | Id reference to orderer from orders table in openmrs |
| orderer_name | name of orderer from order_type table in openmrs |
| visit_id | Id reference to the visit from visit table in openmrs |
| visit_type | Type of visit from visit_type table in openmrs |
| encounter_type_id | Id reference to encounter type from encounter_type table in openmrs |
| encounter_type_name | name of encounter type from encounter_type table in openmrs |
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0