Implementation of workflow engine technology to deliver basic clinical decision support functionality

Table 1 Event schema example

EV_TIME (ev_time)	EVENT TYPE (evtype_desc)	SUBTYPE (evsbtype_desc)	OBSERVATION (obs_desc)	CODED VALUE (cd_val_desc)	FLAG (flg_desc)	VAL_NUM (val_num)	TERM2_CD (term2_cd)	TERM2_DESC (term2_desc)
1990-01-01 00:00:00.0	Birth event
2046-04-23 00:00:00.0	Length of Stay					3
2046-04-23 00:00:00.0	ICD-9-CM Diseases						72610	ROTATOR CUFF SYND NOS
2046-04-23 00:00:00.0	ICD-9-CM Procedures						8363	ROTATOR CUFF REPAIR
2046-04-23 00:00:00.0	CPT-4					2	J3010	Inj, fentanyl citrate
2046-04-23 00:00:00.0	CPT-4						29999	ARTHROSCOPY OF JOINT
2046-04-23 15:01:00.0	Clinical Text Data			Operative Report
2046-04-23 15:23:00.0	Standard Lab Data	Lipid Profile	Cholesterol, Plasma Quant.		Higher Than Normal	327
2046-04-23 15:21:00.0	Standard Lab Data	Urine Mi-croscopics	Epithelial Cells, Urine	Occasional
2046-05-11 13:21:50.0	Problem Event	Diagnosis		Hyperlipidemia
2046-08-12 11:12:13.0	Patient Order	Pharmacy order		Meperidine Hcl, 50 Mg/Ml, Ampul
2047-01-18 10:55:01.0	Nurse Note						203.1.10.3.1.10.1.0	PURPOSEFUL MOVEMENT
2047-01-18 15:23:30.0	Inpatient Drug						3513816	ELECTROLYTES (NUTRILYTE) 42.9 ML, VIAL
2047-01-19 11:02:02.0	Discharged						43	ICU

Only selected sample events are shown. Dates are fictional and only textual meanings of codes are shown. The "ev_time" column shows the event time, the next four columns contain the basic four attributes (type, subtype, exam, coded value), followed by the flag and numeric value columns. Corresponding columns in the HealthFlow database schema (see figure 6) are shown in brackets in column headings. Only the event time and type attributes are required for all events. The last two "Term2" columns are used for storing external terminology original codes.

ISSN: 1471-2288