Location
configurationincrementalUpdateConfig is applicable ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update )Existing OpenMRS tables
{
"name": "Location",
"type": "location",
"chunkSizeToRead": "500"
}Flattened Mart Tables
a) location_default - This table provides the location and all the details of locations.
Openmrs tables used: location
| Column Name | Description |
|---|---|
| location_id | Unique column id from location table from openmrs |
| name | Name of the location |
| description | Description for that particular location |
| address1 - address15 | Represents different fields in address (Configurable) |
| city_village | City/Village of the patient |
| state_province | State/Province of the patient |
| postal_code | Postal code of the patient’s residential area |
| country | Country of patient’s residence |
| county_district | District of the patient’s residence |
| latitude | Latitude of the area of residence |
| longitude | Longitude of the area of residence |
| start_date | Date when the patient started living in that area |
| end_date | Date when the patient stopped being in that area |
| parent_location | parent locations id |
b) location_tag_map_default - This table provides the location tag map details
Openmrs Tables used :- location, location_tag_name, location_tag_map
| Column Name | Description |
|---|---|
| location_id | Unique column id from location table in openmrs |
| location_tag_id | Unique column id from location_tag table in openmrs |
| location_tag_name | Name of location from location_tag table in openmrs |
| location_tag_description | Location Tag description from location_tag table in openmrs |
c) location_attribute_details_default -
Openmrs Tables used :- location, location_attribute , location_attribute_type
| Column Name | Description |
|---|---|
| location_attribute_id | Unique column id from location_attribute table in openmrs |
| attribute_type_id | location attribute type id from location_attribute table in openmrs |
| value_reference | value_reference from location_attribute table in openmrs |
| location_attribute_type_name | value_reference from location_attribute table in openmrs |
| location_attribute_type_description | location_attribute_type description from location_attribute table in openmrs |
| location_attribute_type_datatype | location_attribute_type_datatype from location_attribute table in openmrs |
| location_attribute_type_datatype_config | location_attribute_type_datatype_config from location_attribute table in openmrs |
| location_attribute_type_preferred_handler | location_attribute_type_preferred_handler from location_attribute table in openmrs |
| location_attribute_type_handler_config | location_attribute_type_handler_config from location_attribute table in openmrs |
| location_attribute_type_min_occurs | location_attribute_type_min_occurs from location_attribute table in openmrs |
| location_attribute_type_min_occurs | location_attribute_type_min_occurs from location_attribute table in openmrs |
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0