Check pre acute consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = consistency of Pre acute living situation;  Dispo;  [[Postal Code]] and [[Previous Location]]
|DIC_summary=consistency of Pre acute living situation;  Dispo;  [[Postal Code]] and [[Previous Location]]
| DIC_related_concepts = Pre acute living situation;  Dispo;  Postal Code; Previous Location
|DIC_related_concepts=Pre acute living situation;  Dispo;  Postal Code; Previous Location
| DIC_firmness = soft check  
|DIC_firmness=soft check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.mdb
|DIC_coding=query '''check pre acute consistent'''
| DIC_coding = query '''check pre acute consistent'''  
|DIC_status=declined
| DIC_status = needs review
|DIC_app=CCMDB.accdb
| DIC_implementation_date =  
|DIC_backlogged=No
}}
}}
 
Discussed with Julie; she used to use this as part of Overstay, but that project is no longer so we don't need this.  
The collector will receive an escapable warning if:
* {{Discuss | who = Julie | question = what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.}}
 
== Remaining questions ==
{{Discuss | who = all | question =  There was a previous attempt to address some of this in [[Care levels in the community]]; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages. }}
 
{{Discuss | who = all | question =  How does [[Chronic Health Facility]] fit into this? Or [[Imprisonment/incarceration]] and other info in [[Prison / Jail / Correctional Institution]]?}}
 
{{Discuss | who = all | question =  There was talk about comparing [[Postal Code]]s to known PCH Postal Codes. Since these might Include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here. }}
 
=== Background ===
Julie found cases where the [[pre acute living situation]] for direct admits are not consistent with [[Previous Location]] and/or [[Dispo]].  We want the DC to be aware that the [[pre acute living situation]] has a relationship with the [[Previous Location]] or [[Dispo]]specifically for [[PCH]] cases. 
 
Examples:
* [[pre acute living situation]] = assisted living;    [[Previous Location]] = Winnipeg PCH
* [[pre acute living situation]] = supportive home;  [[Previous Location]] = St Amant
 
I rely on the combination of pre acute living situation;  Previous Location;  [[Postal Code]] and [[Dispo]] fields '''to identified new or already PCH residents''' prior to admission. Data collectors must understand that '''[[Assisted Living]] and [[Supportive Housing]] are not [[PCH]] and must be entered as simply HOME''' as confirmed by Dr Roberts.
 
As per email from Julie:
<pre>
I have asked Pagasa to audit some records where the postal code matches with the PCH Facility.  In most of these cases, Pagasa found that EPR addresses (no and street) match with the PCH facility’s addresses but the Pre-acute living situation =’Apartment’  instead of ‘Personal Care Home’ .  this is possible because the address has the same format  ‘Suite# - No and Street Name’ . 
 
PCH resident data prior to admission is not only being used in Medicine but also needed  in Critical Care.
 
Tina, is it possible to ask at entry level,  say, – the postal code matches with a PCH facility (show the PCH address) but the pre-living situation entered is not ‘Personal Care Home’ , is this correct?    I suppose DCs are getting the postal code from EPR where the exact address is also visible.
</pre>
 
=== [[Pre acute living situation field]] and Direct Admits in [[Previous Location field]] ===
* Patients  whose residence includes Apartment, [[Assisted Living]],[[Supportive Housing]],[[Prison / Jail / Correctional Institution]] or House and who were admitted directly from any of these residences must enter ''''Home'''' in [[Previous Location field]]
* Patients whose residence is [[Personal Care Home]] and who were admitted directly from PCH must enter the corresponding PCH names in [[Previous Location field]].  Within Winnipeg RHA, there are 39 Personal Care Homes with their addresses and postal code specified.
* Patients from [[Chronic Health Facility]] and who were admitted directly from CHF must enter the appropriate CHF name in [[Previous Location field]] .
 
 
 
{{Discuss | who = Julie | question =
* from a data perspective, what do you mean by "admitted directly"? If I were to build a check, where would I find that? OR maybe I don't need to know, but then I need to have a definition of what combination of data would be an error.
Integrity check
* if [[Previous Location field]] ='Home' then [[Pre acute living situation field]] is either Apartment, [[Assisted Living]],[[Supportive Housing]],[[Prison / Jail / Correctional Institution]] or House; otherwise Error.
 
* if [[Previous Location field]] = 'Deer Lodge' or 'Riverview' or 'St Amant' then [[Pre acute living situation field]] = [[Chronic Health Facility]]; otherwise Error.
 
* if [[Previous Location field]] = 'any PCH location' then [[Pre acute living situation field]] = [[Personal Care Home]]; otherwise Error.
 
}}
 
=== [[Pre acute living situation field]],  and [[Dispo field]] ===
* Patients who are already a PCH resident when discharge out of hospital must enter in the [[Dispo field]] the same PCH location as in the [[Previous Location field]]. 
* Patients from [[Chronic Health Facility]] when discharge out of hospital must enter in the [[Dispo field]]  the same CHF location as in [[Previous Location field]] unless there is a changes in the level of care and needs to go to a PCH.
 
{{Discuss | who = Julie | question =
* ... unless they are discharged somewhere else entirely, like another ward. So what do we really mean with this? That they can't come from one PCH and go to another or maybe "home" after all?
** I realize this maybe hard to do. what I mean here is that if one is already a PCH resident, when leaving the hospital, the dispo location must be a PCH location too. or is a patient is already in CHF, the destination when leaving the hospital must either be a CHF or another PCH. 
}}
 
=== [[Pre acute living situation field]],  and [[Postal Code field]] ===
 
M:\PostalCode|PCH.xlsx shows the 39 PCH within WRHA region (http://www.wrha.mb.ca/ltc/pch/index.php). The excel file contains the facility name, the postal code, address - no and street, the number of PCH beds and other programs like Supportive Housing, Rehab, Palliative, Respite care, Adult Day programs. I added a column indicating the facility which is solely a PCH .
Is it possible to use this table to crosscheck the [[Postal Code field]] if matching the postal code of 100% PCH facility and then crosscheck the [[Pre acute living situation field]] if entry = [[Personal Care Home]].
example of message - the Postal Code matches with a PCH facility postal code with address = no & street, is this correct? if address is exactly the same, then enter [[Personal Care Home]] into the [[Pre acute living situation field]].   
 
'''All the above crosschecks primary aim to determine those who are already PCH residents and therefore should not overstay in the unit when already discharge ready.'''
 
{{Discuss | who=Julie |
* The listed  postal codes are correlated to the items ‘PCH’  and ‘Chronic Health facility’  of the Pre-Acute Living Situation.  Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the  Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered  or  ‘other ways’  to link the two fields and make them  consistent.    Info about PCH is now getting  more attention/request. Tina, Will this be hard to do?  Any suggestions?
**I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size  (when adding a new column containing text where most of the records will only be blanks).  It is better to have it in separate table since this pertains to Winnipeg area only.  I have added the exact address of these PCH facilities  -  link to table in email sent on Jan 12.18 at 1224 hrs from [[p:Julie Mojica]]
*** Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)}}


== Related articles ==
== Related articles ==

Latest revision as of 09:48, 2022 April 14

Data Integrity Checks
Summary: consistency of Pre acute living situation; Dispo; Postal Code and Previous Location
Related: Pre acute living situation, Dispo, Postal Code, Previous Location
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: query check pre acute consistent
Uses L Problem table: not relevant for this app
Status: declined
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

Discussed with Julie; she used to use this as part of Overstay, but that project is no longer so we don't need this.

Related articles

Related articles: