Centralized data front end.accdb Change Request: Difference between revisions

No edit summary
Line 4: Line 4:




== Import Validation ==
== Data Validation ==
=== Created Variable ===
see
Message 'Undefined function 'ApTotal_Physiological' in expression ' is showing up when clicking Created_Variables query.  [[User:JMojica|JMojica]] 16:55, 2014 February 28 (CST)
* [[Validating Data '''Sending''']]
 
* [[Validating Data '''Importing''']]
=== Pharmacy YES/N0 ===
Records from Jan 2012 have nothing marked in all pharmacy columns at L_LOG 
[[User:JMojica|JMojica]] 16:31, 2014 February 28 (CST)
 
=== APACHE & SAPS DATA VALUES ===
*Medicine - dummy values assigned to APACHE and SAPS elements no longer collected must be changed to NULL (ALL except Heart rate, respiratory rate, WBC, Systolic BP and GCS - EYE, MOTOR, VERBAL). 
*Critical Care - SERUM,FiO2, PO2, CO2, PH = 0 must be changed to NULL.
*Patients having ALL APACHE/SAPS missing should be changed from zero to NULL.  [[User:JMojica|JMojica]] 15:00, 2014 February 28 (CST)
 


== Other change requests ==
== Other change requests ==