Table 5 Tables in the YCDL database and number of variables

	Table Category		Table Name	Table Description	Common	Breast	Colorectal	Lung	Gastric	Liver	Melanoma	Kidney	Prostate	Thyroid	Prostate	Bile duct	Total
1	PT	Patient	PT_BASIC	Patient Basic Information	20												20
2	PT	Patient	PT_PHIS	Past History	39	9	12						1	2			63
3	PT	Patient	PT_SHIS	Smoking History	29												29
4	PT	Patient	PT_DRNK	Drinking History	33												33
5	PT	Patient	PT_FMHS	Family History	41												41
6	PT	Patient	PT_BDMS	Body Measurement	27												27
7	DG	Diagnosis	DG_INFO	Visit Information	27												27
8	DG	Diagnosis	DG_ECHI	Copayment Policy	27												27
9	DG	Diagnosis	DG_CNCR	Cancer Diagnosis	37												37
10	DG	Diagnosis	DG_CONS	Consultant	28												28
11	EM	Examination	EM_LAB	Laboratory Test	30												30
12	EM	Examination	EM_IMEX	Imaging Test	28			2		2					2	2	36
13	EM	Examination	EM_GENE	Genetic Test	28												28
14	EM	Examination	EM_FCLT	Function Test	28	6		5		2				6	2	2	51
15	PH	Pathology	PH_BPSY	Biopsy	29	7	13	4	13	5	5	3	7	3	4	4	97
16	PH	Pathology	PH_SRGC	Histopathology	32	29	36	20	19	34	23	24	16	25	20	33	311
17	PH	Pathology	PH_IMML	Immuno-histology	29	13	17	9	10	10	17	15	8	15	12	12	167
18	OP	Operation	OP_INFO	Operation Information	28												28
19	OP	Operation	OP_OPNN	Operation opinion	38	27	31	13	19	46	6	5	6	12	4	14	221
20	OP	Operation	OP_COMP	Operation Complication	25												25
21	TX	Treatment	TX_CHTH	Chemotherapy	36												36
22	TX	Treatment	TX_RTH	Radiotherapy	41												41
23	TX	Treatment	TX_PRSC	Drug	29												29
24	TX	Treatment	TX_MOPR	Procedure	33												33
25	TE	Follow-Up	TE_MTST	Follow-Up Metastasis	27												27
26	TE	Follow-Up	TE_RCRN	Follow-Up Relapse	23												23
27	TE	Follow-Up	TE_DEAD	Dead	25												25

Quick links

Search