PrEP DWAPI Data Dictionary -October 2024.xlsx

	A	B	C	D	E	F
1	PREP DEMOGRAPHICS EXTRACT
2	PREP DEMOGRAPHICS EXTRACT
3	This Table contains records for ALL clients who are Registered in PREP Clinic MUST have a behaviour Risk Assessment done ALL PrEP CLIENTS HAVE HTS SERVICES CONDUCTED BEFORE ENROLLMENT
4
5
6
7	Column/Variable Name	DataType	Required	Description	Expected Values

8	PatientPK	INT	Mandatory	EMR Internal System generated Unique Patient Identifier	34
9	PatientPKHash	NVARCHAR		De-identified EMR Internal System generated Unique Patient Identifier	D85906D85317CBA274F67C3AFDE1EAA9D8485B7FAF505C5AE5456FDA6B7E6A67
10	UUID	VARCHAR(38)	Mandatory	It uniquely identifies each row of a patient record	d3b59c02-6606-40a3-98ea-52e696f60821
11	SiteCode	INT	Mandatory	Facility MFLCode	13023
12	PrepNumber			Unique Number assigned to Prep Clients (MFLCode+Year(4digits)+5DigitNum)	13023201900054
13	PrepNumberHash			De-identified Unique Number assigned to Prep Clients (MFLCode+Year(4digits)+5DigitNum)
14	HtsNumber	NVARCHAR		Client Identifier Issued at HTS (System / Provider) issued
15	Emr	NVARCHAR		The EMR used to capture the patient record	IQCare/ KenyaEMR/ OPENMRS/ AMRS
16	Project	NVARCHAR		The Project that Implemented the EMR	HMIS/AMPATH/ EDARP
17	Prep Enrollment Date	DATETIME2		Date Client was enrolled into PREP. DDMMYYYY. For Tis, this is the very first date they were ever enrolled into Prep program	Picked from the Enrollment Form
18	TypeOfPrep	NVARCHAR		The type of PreP initiation	Daily Oral PrEP,CAB-LA,Dapivirine ring,Event Driven"
19	Sex	NVARCHAR		Sex of the Patient (Specified as Male or Female)
20	Date of Birth	DATETIME2		Date of birth of the Client DDMMYYYY	15/12/1990
21	County of Birth	NVARCHAR		County from where client was born (From the 47 Counties)
22	County	NVARCHAR		County where client hails from ( From the 47 Counties)
23	Sub County	NVARCHAR		Sub County where client hails from
24	Location	NVARCHAR		Location where client hails from
25	LandMark	NVARCHAR		Nearest Land Mark
26	Ward	NVARCHAR		Ward where client hails from
27	ClientType	NVARCHAR		Is this a new client or Transfer In or a Restart	New\|Transfer-in \|Re-start
28	Referral Point	NVARCHAR		Service Area where Client was Referred From	HBCT ,VCT, OPD ,MCH, TB Clinic, IPD, CCC, Peer,Outreach, Self Referral,Community, Other (specify)
29	Marital Status	NVARCHAR		Marital Status of the Client	Never Married, Married monogamous , Married Polygamous,Cohabiting,Widowed,Separated, Divorced, Undisclosed.
30	Inschool	NVARCHAR		Whether the child is in school or not (Yes/No)	Yes/No
31	PopulationType	NVARCHAR		Populaton Type	General Population or Key population
32	Key PopulationType	NVARCHAR		Type of Key Pop	Men who have sex with men, Male Sex Worker, Female Sex Worker, People Who Inject Drugs, People Who Use Drugs	*TransGender Values to be dropped
33	Reffered from	NVARCHAR
34	Transfer In	NVARCHAR		Is the Client a transfer In?(Yes/No)	Yes/No
35	TransferInDate	DATETIME2		Date when the patient transferred in	3/2/2012
36	Transfer From Facility	NVARCHAR		The facility which the clients transferred from	Mbagathi Hospital
37	Date first initiated in Prep Care	DATETIME2		The date the client was first initiated on Prep cate at transferring facility	25/06/2017
38	DateStartedPrEPattransferringfacility	DATETIME2		Date when client was initiated on PrEP at the transferring facility	26/07/2017
39	ReasonForPrep	NVARCHAR		What is the reason why the client is starting on Prep	Serodiscordant couples trying to conceive \| Partner +ive \| Sex Partner high risk \| Client has sex with more than one partner \| Ongoing IPV/Violence \|Engaging in transactional sex \|Recent STI \|Recurrent use of Prep \|Injection drugs with shared needles \|Inconsistent condom use\| Other
40	ClientPreviouslyonPrep	NVARCHAR		Was the client ever on Prep Before?	Yes/ No
41	PrevPrepReg	NVARCHAR		Which previous Prep Regimen was client on?	TDF-3TC \| 3TC \| FTC
42	DateLastUsedPrev	DATETIME2		When was the previous regimen last used? DDMMYYYY	23//04/2021
43	DateCreated	DATETIME2		Date a patient's record was created	21/07/2021
44	DateModified	DATETIME2		Date a patient's record was modified	18/07/2021
45	NUPI	NVARCHAR		Client NUPI number	e.g MOH646782
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100