CCMDB.mdb Change Log 2009: Difference between revisions

Line 39:

==== Ensure that date/time formats are explicit ====

Make sure that Access explicitly looks for the format set out in [[Date and Time Format]], rather than using the PC format.

==== Admit-from and discharge-to for ICU can't be current location ====

a. The admit From should never be the same as the Hospital and Location code (ex. FROM = HM, Hosp=HSC, Loc=MICU)

b. The discharge To should never be the same as the Hospital and Location code (ex. Hosp=HSC, Loc=MICU, To = HM) As 8(b)

==== Ensure discharge time = 0:00 can't get through ====

to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working

==== MI Data Integrity Check ====

If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.

====ARF & CRF & ARI Integrity Check====

*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF (Diagnosis)|ARF(350)]] or [[Acute Renal Insufficiency | ARI (364)]] cannot be in admit or complication.

** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)

***Yes, since I have been further reviewing patient profiles in more detail from the problems that SAS has generated, I see renal insufficiency (364)being coded in admit or complication DX slots for patients who have a comorbid condition of chronic renal failure (351).

=== Updates required for Laptops ===

Line 89:

Line 105:

[[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)

*approved, leave blank. [[User:TOstryzniuk|TOstryzniuk]] 05:27, 19 January 2009 (CST)

=====Discussion=====

This can be removed in Access and in the output, but I would suggest leaving it alone on the PDA for now due to HanDBase. Access would no longer check for it. If that is OK, this can be moved to "Checks and Updates".[[User:Ttenbergen|Ttenbergen]] 14:00, 10 February 2009 (CST)

====APACHE II ACTIVE TX-eliminate this====

~~-----~~

~~(I still need to review under here...)~~

===APACHE II ACTIVE TX-eliminate this===

*ACCESS program is affected because it makes this a required field (though my understanding is that many data collectors have set default for boxed to be checked).

*PDA Reader or master database utility programs are not affected if this field is left BLANK

Line 105:

Line 115:

[[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)

*Approved, leave blank. [[User:TOstryzniuk|TOstryzniuk]] 05:25, 19 January 2009 (CST)

=====Discussion=====

* are you saying that ccmdb.mdb will not allow sending a pt with unchecked active tx? [[User:Ttenbergen|Ttenbergen]] 14:25, 11 February 2009 (CST)

~~=== Admit-from and discharge-to for ICU can't be current location ===~~

~~a. The admit From should never be the same as the Hospital and Location code (ex. FROM = HM, Hosp=HSC, Loc=MICU)~~

~~b. The discharge To should never be the same as the Hospital and Location code (ex. Hosp=HSC, Loc=MICU, To = HM) As 8(b)~~

~~=== Ensure discharge time = 0:00 can't get through ===~~

~~to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working~~

~~=== MI Data Integrity Check ===~~

~~If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.~~

~~===ARF & CRF & ARI Integrity Check===~~

*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF (Diagnosis)|ARF(350)]] or [[Acute Renal Insufficiency | ARI (364)]] cannot be in admit or complication.

** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)

***Yes, since I have been further reviewing patient profiles in more detail from the problems that SAS has generated, I see renal insufficiency (364)being coded in admit or complication DX slots for patients who have a comorbid condition of chronic renal failure (351).

===s_Fi02 table in Handibase===

@@ Line 39: / Line 39: @@
 ==== Ensure that date/time formats are explicit ====
 Make sure that Access explicitly looks for the format set out in [[Date and Time Format]], rather than using the PC format.
+==== Admit-from and discharge-to for ICU can't be current location ====
+a.	The admit From should never be the same as the Hospital and Location code (ex.  FROM = HM, Hosp=HSC, Loc=MICU)
+b.	The discharge To should never be the same as the Hospital and Location code (ex. Hosp=HSC, Loc=MICU, To = HM) As 8(b)
+==== Ensure discharge time = 0:00 can't get through ====
+to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working
+==== MI Data Integrity Check ====
+If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.
+====ARF & CRF & ARI Integrity Check====
+*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF (Diagnosis)|ARF(350)]] or [[Acute Renal Insufficiency | ARI (364)]] cannot be in admit or complication.
+** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)
+***Yes, since I have been further reviewing patient profiles in more detail from the problems that SAS has generated, I see renal insufficiency (364)being coded in admit or complication DX slots for patients who have a comorbid condition of chronic renal failure (351).
 === Updates required for Laptops ===
@@ Line 89: / Line 105: @@
 [[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)
 *approved, leave blank. [[User:TOstryzniuk|TOstryzniuk]] 05:27, 19 January 2009 (CST)
+{{Discussion}}
 =====Discussion=====
 This can be removed in Access and in the output, but I would suggest leaving it alone on the PDA for now due to HanDBase. Access would no longer check for it. If that is OK, this can be moved to "Checks and Updates".[[User:Ttenbergen|Ttenbergen]] 14:00, 10 February 2009 (CST)
+====APACHE II ACTIVE TX-eliminate this====
------
-(I still need to review under here...)
-===APACHE II ACTIVE TX-eliminate this===
 *ACCESS program is affected because it makes this a required field (though my understanding is that many data collectors have set default for boxed to be checked).
 *PDA Reader or master database utility programs are not affected if this field is left BLANK
@@ Line 105: / Line 115: @@
 [[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)
 *Approved, leave blank.   [[User:TOstryzniuk|TOstryzniuk]] 05:25, 19 January 2009 (CST)
+{{Discussion}}
+=====Discussion=====
+* are you saying that ccmdb.mdb will not allow sending a pt with unchecked active tx? [[User:Ttenbergen|Ttenbergen]] 14:25, 11 February 2009 (CST)
-=== Admit-from and discharge-to for ICU can't be current location ===
-a.	The admit From should never be the same as the Hospital and Location code (ex.  FROM = HM, Hosp=HSC, Loc=MICU)
-b.	The discharge To should never be the same as the Hospital and Location code (ex. Hosp=HSC, Loc=MICU, To = HM) As 8(b)
-=== Ensure discharge time = 0:00 can't get through ===
-to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working
-=== MI Data Integrity Check ===
-If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.
-===ARF & CRF & ARI Integrity Check===
-*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF (Diagnosis)|ARF(350)]] or [[Acute Renal Insufficiency | ARI (364)]] cannot be in admit or complication.
-** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)
-***Yes, since I have been further reviewing patient profiles in more detail from the problems that SAS has generated, I see renal insufficiency (364)being coded in admit or complication DX slots for patients who have a comorbid condition of chronic renal failure (351).
 ===s_Fi02 table in Handibase===