투약 작업
- 이 모듈에는 ColumnsToIgnore 설정이 적용됩니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix 참조). incrementalUpdateConfig를 적용할 수 있습니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update 참조).
기존 OpenMRS 테이블
평면화된 Mart 테이블
- 증분 구성:
환자에게 처방된 의약품은 medication_data라는 하나의 테이블로 평면화됩니다.
구성
이 모듈에는 ColumnsToIgnore 설정이 적용됩니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix 참조).
incrementalUpdateConfig를 적용할 수 있습니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update 참조).
기존 OpenMRS 테이블
평면화된 Mart 테이블
증분 구성:
특정 Mart 테이블의 증분 구성을 활성화하거나 비활성화하는 방법은 이 절을 확인하십시오.
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