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.

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

Lab Items Collected

Different itesm are collected at HSC compared to all other sites. The S_AllLabs list has different views for these locations. To view only the items collected at your site, set the view as per below.

• HSC - Collect at HSC
• All other sites (STB, VIC, GRA, OAK, CON)- Collect at others

If we update the contents of the S_Drugs table a new one will be loaded onto your PDA at sync time. When this happens you will have to set your view again.

Contents of S_AllLabs Table

LabCode	LabName	manual HSCCollect	manual-ALL Other SitesCollect	Legacy Data Info
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	started 25 Jul 2008

Data Structure

• Labcode - integer number we use to identify the lab in the database, i.e what is actually stored in L_Labs
• LabName - text string with the "friendly name" that will be displayed on the PDA and in Access
• HSCCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at HSC
• OtherCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at locations other than HSC

HSCCollect and OtherCollect are used to generate the location specific listings/views.

Bug Note

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. Also see S_Labs

to do before de-stubbing

• Is there Legacy Data Info beyond when Voluven was added? Are there old labs we no longer collect?--Ttenbergen 09:58, 12 August 2008 (CDT)

• From the wikipedia article sounds like Pentaspan and Voluven are interventions rather than labs. If so, we need an explanation why they are tracked under Labs rather than Pharm. --Ttenbergen 09:58, 12 August 2008 (CDT)