CCMDB Data Structure

This article explains how our tables interlink.

Structure

actual data

• L Log table links to the following on D_ID
  • L_PHI table table
  • L Como table
  • L Dxs table
  • L_Labs_Flowsheet table table table
  • L_Pharm_Flowsheet table table
  • L TISS Item table
  • L TmpV2 table

support tables

L_Log table

Some fields in L Log table draw from support tables as follows:

field	field name	position	s_table
Province field	R_Province	16	S Provinces table
Pre-admit Inpatient Institution field	Pre_admit_Inpatient_Institution	36	S pre acute living situation table
Previous Location field	Previous_Location	37	S dispo table
Previous Service field	Previous_Service	38	S_previous_service table
Service/Location field	Service_Location	40	S dispo table
Dispo field	dispo	41	S dispo table
RecordStatus field	RecordStatus	80	S RecordStatus
ADL Bathing	ADL_Bathing	49	S ADLOptions table
ADL Dressing	ADL_Dressing	50	S ADLOptions table
ADL Toiletting	ADL_Toiletting	51	S ADLOptions table
ADL Transfering	ADL_Transfering	52	S ADLOptions table
ADL Continence	ADL_Continence	53	S ADLOptions table
ADL Feeding	ADL_Feeding	54	S ADLOptions table
Admit Type for APACHE II	Ap_AdmitType	55	S AP AdmitType
Chronic Health APACHE	Ap_Chronic	56	S AP Chronic
FiO2	Ap_FIO2	67	S FIO2 table
AP Eye field	AP_Eye	63	S GCS
AP Motor field	AP_Motor	63	S GCS
AP Verbal field	AP_Verbal	63	S GCS

L_TmpV2 table

The L_TmpV2 table links on both of the following two fields together with the S Tmp table:

• L_TmpV2.project = s_Tmp.Study
• L_TmpV2.Item = S_tmp.Value

L_Como table

L_Como table links to S AllDiagnoses table as

• L_Como.ComorbidCode = S AllDiagnoses.DiagnosisCode

L_Dxs table table

L_Como table links to S AllDiagnoses table as

• L_Dxs table.DiagnosisCode = S AllDiagnoses.DiagnosisCode

Legacy Data

• L Pharmacy pre 2012 table
• L TISS76 table
• L Labs pre 2014 Aug table

Created/Derived Data

• Created variables common table
• Created variables CC table