CKD_features.xlsx

	A	B	C	D	E	F	G
1	VARIABLE	DESCRIPTION	TYPE	UNIT	CRITERIA	EXAMPLE VALUE	REMARK
2	Hashed HN	Hashed Hospital Number	string
3	Visit	visit number	continuous
4	VisitDate	visit date	datetime				Data format: 'YYYYMMDD'
5	Gender	sex	nominal			M = male, F = female
6	Age	age	continuous	year
7	Nationality	nationality	nominal			THA = Thai
8	Ethnic	ethnic	nominal			THA = Thai
9	Province	province	nominal			กรุงเทพ, นครราชสีมา
10	Occupation	occupation	nominal			ข้าราชการ, แม่บ้าน
11	MartialStatus	martial_status	nominal			สมรส, หย่า, โสด
12	Residence	residence	nominal			Thai = Thai
13	Insurance_Scheme	Insurance scheme	nominal			AEMU = พนักงานมหาวิทยาลัยมหิดลประเภทเงินอุดหนุน, AOL = พระราชบัญญัติประกันภัยรถยนต์, AR = ผ่อนชำระ, BOT = พนักงานธนาคารแห่งประเทศไทย, EMU1 = พนักงานมหาวิทยาลัยมหิดลประเภท1, EMU2 = พนักงานมหาวิทยาลัยมหิดลประเภท2, EMU3 = ลูกจ้างรพ.รามา, EMU4 = พนักงานมหาวิทยาลัยมหิดลส่วนงาน, GG = ข้าราชการ(กทม), GGO = ข้าราชการ, HCI = ลูกหนี้ประกันชีวิต, IEMU = พนักงานมหาวิทยาลัยมหิดลประเภทเงินรายได้, INHSI = ประกันสุขภาพในเขต, ISSI = ประกันสังคมในเขต, LGO = ข้าราชการ อปท., ONHSI = ประกันสุขภาพนอกเขต, OSSI = ประกันสังคมนอกเขต, PAY = เรียกเก็บผู้ป่วย, PRI = พนักงานบริษัทเอกชน, PUB = พนักงานหน่วยงานของรัฐ, SCB = พนักงานธนาคารไทยพาณิชย์, SCG = พนักงานบริษัทปูนซีเมนต์, SEP = พนักงานรัฐวิสาหกิจ, SMU = นักศึกษามหาวิทยาลัยมหิดล, UNK = เงินสด, WAIT = ค้างชำระ, WCF = กองทุนทดแทน
14	EncType	Type of encounter	nominal			AMB (ambulance) : EMER (emergency) : SS (short stay) : IMP (inpatient)
15	VitalDate	date for measuring vita sign data	datetime				Data format: 'YYYYMMDD'
16	BW	body weight	continuous	kilogram
17	Height	Height	continuous	centimeter
18	BMI	body mass index	continuous
19	DBP	Diastolic Blood Pressure	continuous	mmHg
20	SBP	Systolic Blood Pressure	continuous	mmHg
21	HR	heart rate	continuous	beats per minute
22	RESP	respiratory rate	continuous	breaths per minute
23	SPO2	Oxygen saturation	continuous	%
24	TEMP	temperature	continuous	celsius
25	DiagDate	diagnosis date	datetime				Data format: 'YYYYMMDD'
26	ICD	ICD codes	list of ICD codes			['I10', 'J069', 'E789']
27	CKD	Chronic Kidney Disease	binary		egfr >= 60 or ICD codes or glomerulonephritis	0 = no : 1 = yes
28	CKD_1st_date	1st date of CKD	datetime				Data format: 'YYYYMMDD'
29	CKD_stage_code	CKD stage	ordinal			1 = stage1: 2 = stage2: 3 = stage3, 3.1 = stage3a, 3.2 = stage3b, 4 = stage4, 5 = stage5, 0.5 = glomerulonephritis, 0 = unspecified stage
30	CKD_max_stage_code	most severe CKD stage for patient	ordinal			1 = stage1: 2 = stage2: 3 = stage3, 3.1 = stage3a, 3.2 = stage3b, 4 = stage4, 5 = stage5, 0.5 = glomerulonephritis, 0 = unspecified stage
31	ESRD	end stage renal failure	binary			0 = no : 1 = yes
32	PD	peritoneal dialysis	binary			0 = no : 1 = yes
33	HD	hemodialysis	binary			0 = no : 1 = yes
34	KT	kidney transplant	binary			0 = no : 1 = yes
35	PRCA	Pure red cell aplasia	binary		1) Investigate for possible antibody-mediated PRCA when a patient receiving ESA therapy for more than 8 weeks develops the following (Not Graded): - Hb and blood transfusion - decrease Hb for 0.5 to 1.0 g/dl per week * ['CBC_Hb'] OR - blood transfusions 1 to 2 per week * [bld_transfuse'] AND - Lab test - normal platelet - Male: (135,000 to 317,000/uL) —> mayo clinic 135 x 10^3/ul - 317 x 10^3/ul - Female: (157,000 to 371,000/uL) —> mayo clinic 157 x 10^3/ul - 371 x 10^3/ul * ['CBC_Plt'] * ['gender'] AND - normal white cell counts - 3,400 to 9,600 cells/uL —> mayo clinic 3.4 - 9.6 x 10^3/ul * ['CBC_WBC'] AND - absolute reticulocyte count **ไม่มี - less than 10,000/ul ARC = (reti% / 100) * RBC count[10^6uL] / 1000 --> ml unit https://www.mayoclinic.org/tests-procedures/complete-blood-count/about/pac-20384919 OR 2) ICD-10 code D61.01 for Constitutional (pure) red blood cell aplasia	0 = no : 1 = yes
36	PRCAdate	PRCA date	datetime				Data format: 'YYYYMMDD'
37	T2DM	type 2 diabetes	binary		from T2D data warehouse	0 = no : 1 = yes
38	HT	hypertension	binary		from HT data warehouse	0 = no : 1 = yes
39	Stroke	stroke	binary		ICD codes for Hemorrhagic stroke / Ischemic stroke / TIA	0 = no : 1 = yes
40	DLP	dyslipidemia	binary		ICD codes for DLP	0 = no : 1 = yes
41	Obese	obesity	binary		ICD codes of E66	0 = no : 1 = yes
42	CVD	cardiovascular disease	binary		ICD codes for CVD	0 = no : 1 = yes
43	PVD	peripheral vascular disease	binary		ICD codes for PVD	0 = no : 1 = yes
44	Liverdis	Liver disease (cirhosis, chronic hepB, hepC)	binary		ICD codes for cirhosis, chronic hepB, hepC [B15-B19, K70-K77]	0 = no : 1 = yes
45	Pulmodis	Chronic pulmonary disease	binary		ICD codes for Chronic pulmonary disease [J44 - J44.9 , J45 - J46]	0 = no : 1 = yes
46	Cancer	cancer	binary		ICD codes for CA [C00 - C99]	0 = no : 1 = yes
47	AIDS	AIDS	binary		ICD codes for AIDS [B20 - B24]	0 = no : 1 = yes
48	SLE	SLD	binary		ICD codes for SLD [M32]	0 = no : 1 = yes
49	Gout	Gout	binary		M10	0 = no : 1 = yes
50	Stone	Stone	binary		N20 - N23	0 = no : 1 = yes
51	Dementia	Dementia	binary		F00 - F03	0 = no : 1 = yes
52	Fracture	Fracture	binary		S12, S22, S32, S42, S52, S62, S72, S82, S92	0 = no : 1 = yes
53	Handicap	Handicap	binary		G80 - G83	0 = no : 1 = yes
54	Pregnancy	Pregnancy	binary		O00 - O99, Z33	0 = no : 1 = yes
55	Sleepdis	Sleep disorder	binary		G47, F51	0 = no : 1 = yes
56	Gumdis	Periodontal disorder	binary		K04 - K05	0 = no : 1 = yes
57	DN	Diabetic nephropathy	binary		(E10 - E14.9) + N08.3	0 = no : 1 = yes
58	Hypertensive_Nephropathy	Hypertensive nephropathy	binary		I12	0 = no : 1 = yes
59	ON	Obstructive nephropathy	binary		N13	0 = no : 1 = yes
60	CUN	Chronic urate nephropathy	binary		N20.0, N28.9	0 = no : 1 = yes
61	LN	Lupus nephritis	binary		M32.1 + N08.5	0 = no : 1 = yes
62	PKD	Polycystic kidney disease	binary		Q61.1 - Q61.3 , N28.1	0 = no : 1 = yes
63	AN	Analgesic nephropathy	binary		N28.9 + รหัสยาแก้ปวด, N14.0	0 = no : 1 = yes
64	CPN	Chronic pyelonephritis	binary		N11	0 = no : 1 = yes
65	MM	Multiple myeloma	binary		C90.0	0 = no : 1 = yes
66	PE	Preeclampsia	binary		O13 - O15	0 = no : 1 = yes
67	TraumaNeph	Traumatic nephrectomy	binary		Z90.5, ICD-9 (code 55.4, 55.5, 55.54)	0 = no : 1 = yes
68	TBKUB	TB of KUB system	binary		TB kidney = A18.1 + N29.1, TB bladder = A18.1 + N33.0	0 = no : 1 = yes
69	IschNeph	Ischemic nephropathy	binary		N28.0	0 = no : 1 = yes
70	IGAN	IgA nephropathy	binary		N02.8	0 = no : 1 = yes
71	FSGS	FSGS (Focal segmental glomerulosclerosis)	binary		N00.1, N01.1, N02.1, N03.1, N04.1, N05.1, N06.1, N07.1	0 = no : 1 = yes
72	CresGN	Crescentic GN	binary		N00.7, N01.7, N02.7, N03.7, N04.7, N05.7, N06.7, N07.7	0 = no : 1 = yes
73	RPGN	RPGN (Rapid Progressive GN)	binary		N01	0 = no : 1 = yes
74	Glomdis	Glomerular disease (unspecify)	binary		N05	0 = no : 1 = yes
75	HIVAN	HIVAN = HIV-associated nephropathy	binary		B23.8 + N39.1 + N17.9	0 = no : 1 = yes
76	Unknown	unknown	binary		R69	0 = no : 1 = yes
77	AdmitDate	date at admission	datetime				Data format: 'YYYYMMDD'
78	DiscDate	date at discharge	datetime				Data format: 'YYYYMMDD'
79	Los	length of stay	continuous
80	Death	Death	binary			0 = no : 1 = yes
81	DeathDate	dead date	datetime				Data format: 'YYYYMMDD'
82	DeathCause	causes of dead	list of ICD codes		[C845, A419, D65, N179]
83	MainDeathCause	primary cause of dead	list of ICD codes		[C845]
84	BillDate	date for billing	datetime				Data format: 'YYYYMMDD'
85	Blood_Transfusion	blood transfusion	binary			0 = no : 1 = yes
86	DrugDate	date for drug	datetime				Data format: 'YYYYMMDD'
87	ANTI_ARRHYTHMIC	antiarrhythmic drug	binary
88	ANTI_COAG	major group of anticoagulation drug	binary
89	ANTI_DM	major group of antidiabetic drug	binary
90	ANTI_HT	major group of antihypertensive drug	binary
91	ANTI_LIPID	major group of antilipid drug	binary
92	ANTI_PL	major group of antiplatelet drug	binary
93	ANTI_PTH	major group of antiparathyroid drug	binary
94	ANTI_URIC	antiuric drug	binary
95	BONE	major group of bone and vitamin D drug	binary
96	ESA	major group of ESA drug	binary
97	IRON	major group of iron drug	binary
98	Ketosteril	Ketosteril	binary
99	NSAIDS	major group of NSAIDS drug	binary
100	PHOS_BINDER	major group of phosphate binders drug	binary