한국어 번역 완료

방문 및 진료 접촉

이 모듈에는 ColumnsToIgnore가 적용됩니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix 참고).관련 문서: Configuration
incrementalUpdateConfig를 적용할 수 있습니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update 참고).관련 문서: ColumnsToIgnore apply for this module ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix )

기존 OpenMRS 테이블관련 문서: Existing OpenMRS tables

평면화된 Mart 테이블관련 문서: Flattened Mart Tables

Mart 뷰관련 문서: Mart Views

특정 Mart 테이블에 대해 증분 구성을 활성화하거나 비활성화하는 방법은 이 섹션을 확인하십시오.관련 문서: this

a) 방문

i) patient_visit_details_default

Column Name	Description
visit_id	Id reference for a visit
patient_id	Id reference for a patient
visit_type_id	Id reference for visit type
visit_type_name	Name of visit [ IPD/ OPD/ Special OPD / Emergency etc]
visit_type_description	Description of visit type
visit_start_date	Start date of visit
visit_end_date	End date of visit
indication_concept_id	indication_concept_id from visit table in openmrs
location_id	Id reference for location
location_name	Name of location [general ward / Registration Desk, Labor ward etc]

ii) visit_attribute_details_default

Column Name	Description
visit_id	Id reference for a visit
visit_attribute_id	Id reference for a visit attribute
value_reference	Value for the attribute [OPD / IPD]
visit_attribute_type_id	Id reference for a visit attribute type
visit_attribute_type_name	Visit type [ Visit status / Admission status]
visit_attribute_type_description	visit attribute type description from visit_attribute_type openmrs table
visit_attribute_type_datatype	visit_attribute_type_datatype from visit_attribute_type openmrs table
visit_attribute_type_datatype_config	visit_attribute_type_datatype_config from visit_attribute_type openmrs table
visit_attribute_type_preferred_handler	visit_attribute_type_preferred_handler from  visit_attribute_type openmrs table
visit_attribute_type_handler_config	visit_attribute_type_handler_config from visit_attribute_type openmrs table
visit_attribute_type_min_occurs	visit_attribute_type_min_occurs from visit_attribute_type openmrs table
visit_attribute_type_max_occurs	visit_attribute_type_min_occurs visit_attribute_type openmrs table

iii) visit_attributes

Column Name	Description
visit_id	Id reference for a visit
Visit_Status	Status of visit [OPD / IPD ]
Admission_Status	Status of admission [Admitted / Discharged etc]

b) 진료 접촉

i) patient_encounter_details_default

Column Name	Description
patient_id	Id reference for a patient
visit_id	Id reference for a visit
episode_id	Id reference for a episode
encounter_id	Id reference for a encounter
encounter_type_id	Id reference for a encounter type
encounter_type_name	Type of encounter [Consultation / REG etc]
encounter_type_description	Description of encounter [ Consultation encounter/Registration encounter etc]
edit_privilege	edit_privilege from encounter_type table in openmrs
view_privilege	view_privilege from encounter_type table in openmrs
location_name	Name of location [ Labour ward/ General ward]
form_id	form_id from encounter table in openmrs
encounter_datetime	Date and time of encounter
encounter_role_id	Id reference for encounter role from encounter_role table in openmrs
encounter_role_name	name of encounter role encounter_role in openmrs
provider_id	Id reference of provider from encounter_provider table in openmrs
provider_name	provider name from provider table in openmrs
encounter_role_description	description of encounter role from encounter_role description table.

a) Patient_visits_encounters_view

이 뷰에서는 환자 상세 데이터와 모든 방문 및 방문 세부 정보를 함께 볼 수 있습니다. 각 진료 접촉 위치에서 발생한 모든 진료 접촉의 세부 정보도 포함합니다. 환자 한 명에게 여러 방문이 있을 수 있으므로 같은 환자 데이터가 여러 행에 나타날 수 있습니다.

원문 정보

Bahmni Wiki · CC BY-SA 4.0