Person Job
- configurationColumnsToIgnore 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 )
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 )
Existing OpenMRS tables
Flattened Mart Tables
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
Bahmni Wiki · CC BY-SA 4.0