S AllLabs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 1: Line 1:
The '''S_AllLabs''' table contains the possible values for the [[L_Labs]] table on the PDA and in the [[CCMDB.mdb]].
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]].
*NOTE: S_Labs is a rogue file. For more information, click here...[[S_Labs]].



Revision as of 11:51, 7 August 2008

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.
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

New item

  • Lab item 142 Voluven - added July 25.08

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

  • explain data structure


Template:Stub