수술실 모듈
설정
incrementalUpdateConfig를 적용할 수 있습니다(참조: https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update).
기존 OpenMRS 테이블
평면화된 Mart 테이블
증분 구성:
특정 Mart 테이블의 증분 구성을 활성화하거나 비활성화하는 방법은 관련 섹션을 확인하십시오.
a) surgical_block_default
| Column Name | Description |
|---|---|
| surgical_block_id | Identifier for the table |
| primary_provider_name | Name of the Surgeon performing the surgery |
| creator_name | Name of creator for surgical block |
| location_name | Location of the operation theatre |
| block_starttime | Start time for surgery block |
| block_endtime | End time for surgery block |
| date_created | Date of creation for surgical block |
| date_changed | Changed date if modified |
| changed_by | Name of person who changed the surgical block |
b) surgical_appointment_default
| Column Name | Description |
|---|---|
| surgical_appointment_id | Table Identifier |
| surgical_block_id | Identifier for surgical block related to this surgery |
| patient_id | Identifier for the patient undergoing surgery |
| sort_weight | Weight will be used to order the appointment |
| status | Status of the surgery |
| actual_start_datetime | Actual Surgery start time |
| actual_end_datetime | Actual time at which surgery ended |
| notes | Notes added after surgery |
| date_created | Date when the surgery appointment was created |
| date_changed | If modified the date of modification of the surgery appointment |
| creator_name | Name of the person who created the surgery appointment |
| changed_by | Name of the person who modified the surgery appointment |
c) surgical_appointment_attributes
| Column Name | Description |
|---|---|
| surgical_appointment_id | Identifier for the surgical appointment |
| procedure | Name of the surgical procedure |
| estTimeHours | Estimated time for surgery in hours |
| estTimeMinutes | Estimated time for surgery in minutes extra to the above hours |
| cleaningTime | Time for cleaning after the surgery |
| otherSurgeon | Name of additional surgeon |
| surgicalAssistant | Name of assistant |
| anaesthetist | Name of the doctor who performs anesthesia |
| scrubNurse | Name of scrub nurse for the surgery |
| circulatingNurse | Name of circulating nurse ( nurse from other location ) |
| notes | Notes added after surgery is done |
d) surgical_appointment_attribute_type_details_default
| Column Name | Description |
|---|---|
| name | Name of the attributes used in the surgical appointment table |
| description | Description of the attributes used |
Mart 뷰
a) patient_operation_theater_view
이 뷰는 생성 날짜, 예약된 수술, 블록 위치, 배정된 외과의사, 수행할 시술 등 수술실 블록의 세부정보를 종합적으로 제공합니다. 한 환자가 서로 다른 시간에 여러 수술을 예약할 수 있으므로 같은 환자에 대해 데이터가 다른 여러 행이 존재할 수 있습니다. 환자 상세정보에는 age_at_surgery(수술 당시 환자 나이)와 age_group_at_surgery(수술 당시 연령대)가 포함됩니다. 수술 블록 날짜는 그날 해당 블록에 계획된 모든 수술에 대응합니다. 수술이 연기되면 블록 날짜에는 실제로 다시 예약된 수술 시간이 표시됩니다.
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0