Help with unique identifier in SPA data? [message #804] |
Thu, 03 October 2013 14:21 ![Go to next message Go to next message](/theme/default/images/down.png) |
ltally
Messages: 2 Registered: October 2013
|
Member |
|
|
I am using the Kenya SPA 2010 dataset and am trying to link the modules. I can't seem to find a unique identifier for providers or clients. I am trying to link client-provider observations to individual providers and then to their respective facilities. Does anyone have any experience with this or have any suggestions?
|
|
|
|
Re: Help with unique identifier in SPA data? [message #835 is a reply to message #804] |
Fri, 11 October 2013 10:44 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Liz-DHS
Messages: 1516 Registered: February 2013
|
Senior Member |
|
|
Dear User,
Every Facility ID is repeated in every provider that is at that facility.
Facility/Provider/Client
Every client Id has both the facility ID and the provider Id so they can be connected back to the provider.
In DHS data sets you have an id with Cluster/HH/Woman
In SPA you have an id with Facility/Provider/Client
The lower you go in a file the bigger the id gets.
Variables are:
FACIL
HLINE
CTYPE (alpha, 5 types of clients in Kenya SPA 2010, Sick Child, ANC, Family Planning, STI, Delivery)
CNUMBER
No matter what client you are in use FACIL and HLINE fromt he client file to connect above to the provider (FACIL)
|
|
|