Person Job

configuration

ColumnsToIgnore apply for this module ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329875787/Appendix )

incrementalUpdateConfig is applicable ( Refer https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update )

{
      "name": "Person",
      "type": "person",
      "chunkSizeToRead": "500",
      "groupedJobConfigs": [
        {
          "tableName": "person_details_default",
          "columnsToIgnore": []
        }
        ]
}

Existing OpenMRS tables

person
person_name
Patient_identifier
person_address
person_attribute_type
address_hierarchy_level

Flattened Mart Tables

person_details_default
person_address_default
person_attribute_info_default
address_hierarchy_level_default

Incremental Config:

Please check this section on how to enable/disable incremental config for specific mart tables.

a) person_details_default - This table provides all the person related information.

openmrs tables used:- person, person_name

Column Name	Description
person_id	Id reference to the person, from person table in openmrs
person_name_id	Name of person from person_name table in openmrs
preferred	Preferred from person_name table in openmrs
gender	gender of person from person table in openmrs
birthyear	year of person birth
birthtime	Time of person birth
birthdate_estimated	provided date of birth is estimated or accurate, is indicated with birth_estimated ( true/false )
age	age of person from person table
age_group	Under which age range the patient belongs
dead	death status from person table ( true of false )
death_date	death date in case
deathdate_estimated	if death date is not accurate then this field indicates the same ( boolean value true/false )
cause_of_death	cause of death from person table

b) person_address_default - This table provides all the address information of persons.

openmrs tables used:- person_address

Column Name	Description
person_id	Patient identifier
preferred	Preferred address of the patients if they have multiple addresses
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

c) person_attribute_info_default - This table provides all the information related person attributes

openmrs table used:- person_attribute_type

Column Name	Description
person_attribute_type_id	Id reference to the person attribute, from person_attribute_type table in openmrs
name	name of the person attribute type
description	description of the person attribute type

d) address_hierarchy_level_default- This table provides us the address hierarchy level information.

openmrs table used:- address_hierarchy_level

Column Name	Description
address_hierarchy_level_id	Id reference to the address, from address_hierarchy_level table in openmrs
name	name of the address field
parent_level_id	parent_level_id of address field
address_filed	To which address filed the data is filled in.

e) person_attributes : This table contains all the patient attributes that where used in the registration page. Columns will be generated dynamically based on the attributes that were used as a part of that specific implementation.

Eg : givenName, familyName, isCaretakerRequired, caretakerGender