Check pre acute consistent

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.mdb
Coding:	query check pre acute consistent
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Pre acute living situation]], Dispo, Postal Code, [[Previous Location" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories: 

• form:

The collector will receive an escapable warning if:

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.

• SMW

• Cargo

• Categories

Remaining questions

Template:Discussion 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.

Template:Discussion There are instructions relating to some of the pages in Category:Awaiting/delayed transfer, consistency with this page needs to be confirmed.

Template:Discussion How does Chronic Health Facility fit into this?

Template:Discussion There was talk about compating Postal Codes 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 Dispospecifically 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:

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.