Prostate_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			EEEIUYO
3	Gender	sex	nominal			M	M = male, F = female
4	Age	age	continuous	year	compute from date of birth (dob)	50
5	Nationality	nationality	nominal			THA	THA = Thai (Mapping table: Country) *Convert text in 'H4L1KEY' and 'Mnemonic' to uppercase before mapping Mapping table: Country Key: Mnemonic
6	Ethnic	ethnic	nominal			THA	THA = Thai (Mapping table: Country) *Convert text in 'H4L1KEY' and 'Mnemonic' to uppercase before mapping Mapping table: Country Key: Mnemonic
7	Province	province	nominal			กรุงเทพ
8	Occupation	occupation	nominal			ข้าราชการ
9	MartialStatus	martial_status	nominal			สมรส	สมรส, หม้าย, หย่า, โสด, แยกกันอยู่
10	Residence	residence	nominal			Thai	Thai, Non-Thai
11	Insurance_Scheme	health insuance	nominal			INHSI	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 = กองทุนทดแทน
12	EncType	type of service	nominal			AMB	AMB = ผู้ป่วยนอก, EMER = ฉุกเฉิน, IMP = ผู้ป่วยใน, OTH = ไม่พบแพทย์, SS = Short Stay
13	group	prostate cancer group	nominal		Definite cases = cases were identified by pathology report confirmed as prostate cancer or having ICD10 (C61 or D40) or ICD9 and receiving any treatments related to prostate cancer. Probable cases = cases were identified by having only ICD10 (C61 or D40). Possible cases = cases were identified by having ICD9 related to prostate cancer and receiving medications or radiotherapies.	1	1 = Definite cases, 2 = Probable cases, 3 = Possible cases
14	VisitDate	visit date	datetime			2010-04-19	Data format: 'YYYYMMDD'
15	AdmitDate	date of admission	datetime			2010-04-19	Data format: 'YYYYMMDD'
16	DiscDate	date of discharge from hospital	datetime			2010-04-19	Data format: 'YYYYMMDD'
17	los	length of stay	continuous	day	number of days between date of admission and date of discharge	5
18	DiagDate	date of diagnosis and operation	datetime			2010-04-19	Data format: 'YYYYMMDD'
19	ICD	ICD10 and ICD9-CM	list of ICD codes			['I10']
20	VitalDate	date of recording vital sign	datetime			2010-04-19	Data format: 'YYYYMMDD'
21	BW	body weight	continuous	kilogram		60
22	Height	high	continuous	centimeter		150
23	BMI	body mass index	continuous	kg/m2		20
24	DBP	diastolic blood pressure	continuous	mmHg		80
25	SBP	systolic blood pressure	continuous	mmHg		120
26	HR	heart rate	continuous	beats per minute		66
27	RESP	respiratory rate	continuous	breaths per minute		22
28	SPO2	oxygen saturation	continuous	%		99
29	TEMP	temperature	continuous	celsius		37.5
30	MAP	mean arterial pressue	continuous	mmHg		98
31	AVPU	Alert, Responsive to Voice, Responsive to Pain, Unresponsive	nominal			A	A = Alert, V = Responsive to Voice, P = Responsive to Pain, U= Unresponsive
32	REWS	Ramathibodi Early Warning Scoring System	nominal			2
33	ACT	การปฏิบัติเมื่อค่าสัญญาณชีพผิดปกติ	nominal			0
34	drug_date	date of recreving medication	datetime			2010-04-19	Data format: 'YYYYMMDD'
35	Abiraterone, drug	drug name	binary			abiraterone	drug name or na
36	Abiraterone, dose, mg	dose of medication	continuous	mg	dose X DOSE_NEW or Defined daily dose (DDD)	1000
37	Abiraterone, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
38	Enzalutamide, drug	drug name	binary			enzalutamide	drug name or na
39	Enzalutamide, dose, mg	dose of medication	continuous	mg	dose X DOSE_NEW or Defined daily dose (DDD)	160
40	Enzalutamide, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
41	Flutamide, drug	drug name	binary			flutamide	drug name or na
42	Flutamide, dose, mg	dose of medication	continuous	mg	dose X DOSE_NEW or Defined daily dose (DDD)	750
43	Flutamide, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
44	Bicalutamide, drug	drug name	binary			bicalutamide	drug name or na
45	Bicalutamide, dose, mg	dose of medication	continuous	mg	dose X DOSE_NEW or Defined daily dose (DDD)	50
46	Bicalutamide, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
47	Goserelin, drug	drug name	binary			goserelin	drug name or na
48	Goserelin, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	10.8
49	Goserelin, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
50	Leuprorelin, drug	drug name	binary			leuprorelin	drug name or na
51	Leuprorelin, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	7.5
52	Leuprorelin, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
53	Triptorelin, drug	drug name	binary			triptorelin	drug name or na
54	Triptorelin, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	11.25
55	Triptorelin, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
56	Degarelix, drug	drug name	binary			degarelix	drug name or na
57	Degarelix, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	80
58	Degarelix, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
59	Docetaxel, drug	drug name	binary			docetaxel	drug name or na
60	Docetaxel, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	70
61	Docetaxel, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
62	Cabazitaxel, drug	drug name	binary			cabazitaxel	drug name or na
63	Cabazitaxel, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	35
64	Cabazitaxel, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
65	Mitoxantrone, drug	drug name	binary			mitoxantrone	drug name or na
66	Mitoxantrone, dose, mg	dose of medication	continuous	mg	dose, DOSE_NEW, UNIT, FREQ_NEW, PORP_HELP	20
67	Mitoxantrone, duration	patient takes medication at that visit or not	binary			1	1 = yes, 2 = no
68	lab_date	date of observation	datetime			2010-04-19	Data format: 'YYYYMMDD'
69	CBC_Absolute_basophil	Absolute basophil	continuous	x 10\S\3/cumm		0.05
70	CBC_Absolute_eosinophil	Absolute eosinophil	continuous	x 10\S\3/cumm		0.2
71	CBC_Absolute_lymphocyte	Absolute lymphocyte	continuous	x 10\S\3/cumm		2
72	CBC_Absolute_monocyte	Absolute monocyte	continuous	x 10\S\3/cumm		0.5
73	CBC_Absolute_neutrophil	Absolute neutrophil	continuous	x 10\S\3/cumm		3
74	CBC_Acanthocyte	Acanthocyte	ordinal			1+	few, 0, 1+,2+, 3+
75	CBC_Anisocytosis	Anisocytosis	ordinal			1+	few, 0, 1+, 2+, 3+
76	CBC_Atypical_lymphocyte	Atypical lymphocyte	continuous	%		4
77	CBC_Auto_agglutination	Auto agglutination	ordinal			1+	few, 0, 1+, 2+, 3+, 4+
78	CBC_Band_form	Band form	continuous	%		8
79	CBC_Basophil	Basophil	continuous	%		1
80	CBC_Basophilic_stippling	Basophilic stippling	ordinal			1-3	negative, found, 0-1, 1-2, 1-3
81	CBC_Blast	Blast	continuous	%		3
82	CBC_Burr_cells	Burr cells	ordinal			1+	few, 0, 1+
83	CBC_Comment	Comment	nominal			seen	seen
84	CBC_Crenated_RBC	Crenated RBC	ordinal			seen	few, seen,1+,2+,3+,4+,5+
85	CBC_Echinocyte	Echinocyte	ordinal			few	few, 0, 1+, 2+
86	CBC_Eosinophils	Eosinophils	continuous	%		20
87	CBC_Giant_platelet	Giant platelet	ordinal			few	few, found, many, moderate, seen, 0-1, 0-2, 0-3
88	CBC_Hb	Hct	continuous	%	CBC_Hct / 3	12
89	CBC_Hct	Hb	continuous	g/dL		40
90	CBC_Howell_Jolly_body	Howell Jolly body	ordinal			few	few, 0, 0-1
91	CBC_Hypersegmented_of_PM	Hypersegmented of PM	continuous	%		11
92	CBC_Hypochromia	Hypochromia	ordinal			few	few, positive, 1+, 2+, 3+, 10
93	CBC_IG	IG	continuous	%		0.5
94	CBC_Immature_cell_undif	Immature cell undif	continuous	%		1
95	CBC_Immature_lymphoid_cell	Immature lymphoid cell	continuous	%		3
96	CBC_LUC	LUC	continuous	%			no data available
97	CBC_Lymphoblast	Lymphoblast	continuous	%			no data available
98	CBC_Lymphocyte	Lymphocyte	continuous	%		5
99	CBC_Lymphoma_cell	Lymphoma cell	continuous	%		72
100	CBC_Macrocyte	Macrocyte	ordinal			few	few, negative, positive, 1+, 2+, 3+