Labs - Legacy Article: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 7: Line 7:
== Data Structure ==
== Data Structure ==
The data is now stored in the [[L_Labs]] tables on the PDA and in the [[CCMDB.mdb]]. There are '''two separate tables''' for labs.  One is for HSC ICU's only the other lab table is for all other ICU's in the city.  The reason for this is that HSC downloads lab from the Hospital computer system and at other sites this is not done.......yet.
The data is now stored in the [[L_Labs]] tables on the PDA and in the [[CCMDB.mdb]]. There are '''two separate tables''' for labs.  One is for HSC ICU's only the other lab table is for all other ICU's in the city.  The reason for this is that HSC downloads lab from the Hospital computer system and at other sites this is not done.......yet.
=== Possible change in collecting Labs ===
See: [[S_AllLabs]]


== Legacy Info ==
== Legacy Info ==
=== Possible change in collecting Labs ===
*ICU Lab tests that are being manually collected and downloaded are currently being reviewed by the ICU database Task team.  Updates will be posted here when available.--[[User:TOstryzniuk|TOstryzniuk]] 17:38, 3 February 2009 (CST)


=== Lab form ===
=== Lab form ===

Revision as of 01:19, 2009 November 20

Lab collection process - tallying lab tests. For more information see Lab Collection Process.

The Critical Care program collects a count of a list (S_AllLabs) of labs performed.

At HSC labs (for Critical Care and Medicine) are downloaded. For more info see Lab downloading at HSC.

Data Structure

The data is now stored in the L_Labs tables on the PDA and in the CCMDB.mdb. There are two separate tables for labs. One is for HSC ICU's only the other lab table is for all other ICU's in the city. The reason for this is that HSC downloads lab from the Hospital computer system and at other sites this is not done.......yet.

Possible change in collecting Labs

See: S_AllLabs

Legacy Info

Lab form

Some time ago, the count was done on the Lab_Collection_Form.