Location

{
      "name": "Location",
      "type": "location",
      "chunkSizeToRead": "500"
}

Existing OpenMRS tables

location
location_tag_name
location_tag_map
location_attribute
location_attribute_type

location_default
location_tag_map_default
location_attribute_details_default

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