예약 일정 관리 모듈
설정
이 모듈에는 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 테이블은 customSql 작업 유형으로 생성됩니다.
증분 구성:
특정 Mart 테이블의 증분 구성을 활성화하거나 비활성화하는 방법은 이 절을 확인하십시오.
a) patient_appointment_default
| Column Name | Description |
|---|---|
| patient_id | Patient identification number. |
| appointment_id | Id reference for an appointment |
| appointment_location | Location where the appointment is created |
| appointment_provider | Creator of the appointment |
| appointment_service | Service of the appointment |
| appointment_service_duration | Service duration of the appointment |
| appointment_service_type | Service type of the appointment |
| appointment_service_type_duration | Service type duration of the appointment |
| appointment_speciality | Speciality of the appointment |
| appointment_start_time | Start_time of the appointment |
| appointment_status | Status of the appointment |
| appointment_end_time | End time of the appointment |
| appointment_kind | Refers whether it is WalkIn or Scheduled appt. |
| comments | Comments given during appointment creation |
b) appointment_service_default
| Column Name | Description |
|---|---|
| appointment_service_id | Id of appointment service |
| location_name | Location of the appointment |
| service_description | Description of the service |
| service_duration | Duration of the service |
| service_starttime | Start time of the service |
| service_endtime | End time of the service |
| service_max_load | Max load of the service |
| service_name | Name of the service |
| service_type | Type of the service |
| service_type_duration | Duration of service type |
| speciality | Speciality of the service |
c) appointment_speciality_default
| Column Name | Description |
|---|---|
| speciality_id | Id of speciality |
| speciality | Appointment speciality |
d) service_availability_default
| Column Name | Description |
|---|---|
| appointment_service_id | Id of appointment_service |
| availability_start_time | Start time of the availability |
| availability_end_time | End time of the availability |
| availability_day_of_week | Day on which service is available |
| availability_max_load | Max load of the availability |
| service_location | Location of the service |
| service_name | Name of the service |
Mart 뷰a) patient_appointment_view
이 뷰는 person_details_default, person_attributes 및 patient_appointment_default 테이블을 결합합니다. 여기에 age_during_appointment(patient_appointment_startdate와 birthdate의 날짜 차이) 및 해당 연령 그룹을 추가합니다.
b) appointment_admin_panel_view
이 뷰는 appointment_service_default와 service_availability_default를 결합합니다.
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0