CCMDB Data cleaner.mdb general information: Difference between revisions

TOstryzniuk (talk | contribs)
TOstryzniuk (talk | contribs)
Line 29: Line 29:
* [[LOS]] -length of stay.  admit date/time & discharge date time.   
* [[LOS]] -length of stay.  admit date/time & discharge date time.   


* '''Enc''' - Encounter - currently not used.  A sorting utility program that use to tally the number of encounter to the database. Sorting was done using, FN, LN, DOB and PHIN?  We had suspending using it when we found many data errors in DOB or name spelling, PHIN.  SInce we have worked on fixing this problem we have not continue to use it.  
* '''Enc''' - Encounter - currently not used.  A sorting utility program that use to tally the number of encounter to the database. Sorting was done using, FN, LN, DOB and PHIN?  We had suspending using it when we found many data errors in DOB or name spelling, PHIN.  Since we have worked on fixing this problem we have not continue to use it.  
**see: [[Identification Numbers]]
**see: [[Identification Numbers]]


Line 42: Line 42:
* '''agepts''' - as per [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/APACHE_Scoring_table#Age_Points Age Points]
* '''agepts''' - as per [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/APACHE_Scoring_table#Age_Points Age Points]


* '''chempts''' - [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/APACHE_Scoring_table#Chronic_Health_Diagnosis_for_APACHE_II  Chronic Health Points] (0 , 2 or 5)
* '''chempts''' - as per [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/APACHE_Scoring_table#Chronic_Health_Diagnosis_for_APACHE_II  Chronic Health Points] (0 , 2 or 5)


* '''totApache''' (how is this different from "Apache" above?)- see story under Apache above.   
* '''totApache''' (how is this different from "Apache" above?)- see story under Apache above.