S AllLabs

The S_AllLabs table contains all the possible lab items for the L_Labs table on the PDA and in the CCMDB.mdb.

S_AllLabs Table

This is a master list of lab items that are on every PDA.

• TRUE means item is manually collected at a site
• FALSE means item is NOT manually collected at a site.

LabCode	LabName	manual HSCCollect	manual-ALL Other SitesCollect
38	CBC	NO	YES
39	CBC Diff	NO	YES
40	PT/PTT	NO	YES
58	K	NO	YES
61	Glucose	NO	YES
63	Creatinine	NO	YES
76	MG	NO	YES
77	SGPT	NO	YES
81	CPK	NO	YES
89	Troponin	NO	YES
113	Sputum C+S	NO	YES
114	Blood C+S	NO	YES
120	Urine C+S	NO	YES
135	ABG	NO	YES
99	Skull Xray	YES	NO
100	Sinus Xray	YES	NO
101	C-Spine Xray	YES	NO
102	L-Spine Xray	YES	NO
103	Other Xray	YES	NO
105	Lung Scan	YES	NO
108	Fluroscopy	YES	NO
111	EEG	YES	NO
125	Sputum Mycoplasma	YES	NO
126	Serum Mycoplasma	YES	NO
131	HIV	YES	NO
132	VDRL	YES	NO
133	Viral Titre	YES	NO
134	Hepatitis Screen	YES	NO
48	Group & Match	YES	YES
50	Packed cells	YES	YES
51	FFP	YES	YES
52	SP	YES	YES
53	Platelets	YES	YES
54	Albumin 25 %	YES	YES
55	Albumin 5%	YES	YES
96	EKG	YES	YES
97	CXR	YES	YES
98	ABD Xray	YES	YES
104	CT Scan	YES	YES
106	Angio-Coronary	YES	YES
107	Angio-Other	YES	YES
109	U /S Echo	YES	YES
110	U /S Abd	YES	YES
136	Pentaspan	YES	YES
137	MUGA	YES	YES
138	MRI	YES	YES
142	Voluven	YES	YES

• TOTAL manual collection:
  • HSC - 33 items
  • Other ICU sites - 33 items

Bug Notes

S_AllLabs Update Problems

If you are not getting updates to the s_AllLabs file the sync for it may not be set up correctly, as the automated sync setup had a bug. See Adding S AllLabs to the sync for the fix.

S_Labs rogue file

S_Labs is a rogue file. For more information, click here...S_Labs.

Changes to Lab List

• ICU Task group is finalizing plans. More information will be posted here when it becomes available.--TOstryzniuk 20:05, 19 November 2009 (CST)

• Worksheet stored: X:\CCMDB_ADMIN_DATABASE\Lab Stuff\Lab test Elimination list