Skip to end of metadata
Go to start of metadata

According Lelei, after the March 2012 Presidential Election, the Kenya address hierarchy should be:

Country > County > District > Division > Location > Sublocation > Town/Village > Estate/Nearest Centre > Section/Homestead > Address 1

In other words, Province will no longer be used while County will be introduced.

It has been consistently difficult for Data managers at AMPATH to trace which field address value corresponds to which attribute on the Open AMRS person_address_table. This has made the FCT team to come up with a Table reflecting what should be referenced and what each field/columns holds for the different person address fields collected when a patient is registered. The following table provides a guideline when extracting data on person_address fields.

For latest person_address mapping in 1.8, please see svn in openmrs.

Field/Column Name in AMRS.

Field/Column Name in MySql D-base.

Locating the Attribute from openmrs person address table.

Postal Address

Address1

person_address.address1

Section/Homestead

Address2

person_address.address2

Estate/Nearest Centre (Landmark)

Address3

person_address.address3

Town/Village

City_Village

person_address.city_village

Sub location

Address5

person_address.address5

Location

Address6

person_address.address6

Division

Address4

person_address.address4

District

County_district

person_address.county_district

Province

State_province

person_address.state_province

County* person_address.state_county
Sub-County* person_address.district_subcounty

Postal Code

Postal_code

person_address.postal_code

Latitude

latitude

person_address.latitude

Longitude

longitude

person_address.longitude

Country

country

person_address.country

*See  FCT-261 - Getting issue details... STATUS

  • No labels

5 Comments

  1. FYI, Address1 has been mapped to "postal address"

  2. Noted,,thanks LS...!!

  3. Per the discussion regarding the transition from collecting Province to County address fields, Burke Mamlin provided the following advice (in December 2012): 

    The only overlapped province/county name is “Nairobi”.  If you worry about the mix up, one of the suggestions is that you can have the current province of “Nairobi” updated to “Nairobi-Province” before all the counties get stored into the same field.  This way, you can still distinguish them.  Also, another suggestion is “clean up” the current values stored in that field since it has more than 1500 different values stored in that field while it should be 8. 

  4. Petronillah Seurey is this information updated to reflect the country's organizational changes that happened with the introduction of county system?

  5. Mhawila Mhawila this is the hierachy

    Country > County > sub-county > Location > Sublocation > Town/Village > Estate/Nearest Centre > Section/Homestead