Patients residing in Manitoba with ambiguous MH Health coverage

We collect some data with rules around entering data that might more about MB Health coverage than address or where they live. This page provides information to decide how to collect those. Also see Canadian Forces patients, John or Jane Doe patient.

JALT The page name isn't quite right, this concept is still evolving in documentation. Some of these may be better off broken out as their own pages or templates and only indexed from here.

• SMW

• Cargo

• Categories

• Postal Code field N/A

• PHIN_field#Location Manitoba and no PHIN

Critical Care and Medicine Database Core Curriculum

• Province field - "Province in which the patient is registered with health care. If the patient is not eligible for health care, it records the province that they reside in. " - we might want to tweak that to, what, health care in Manitoba? Public health care in Canada?
• MB Health info on eligibility

Data Processing

PHIN_field#Multiple PHINs or PHIN changes over time

• Function Validate_PHIN() will ensure coherent Province and PHIN at sending
  • future PHIN_field#Multiple PHINs or PHIN changes over time can break that coherence; no further cross-checks for those entries
  • Province field does not include instructions to change Province when PHIN changes

Reporting / Data User Portal for the Manitoba Critical Care and Medicine Databases

• We sometimes consider a patient's "from" by e.g. the last hospital vs their home

• Province vs Postal Code/Postal Code Master table Province vs (Pre-admit Inpatient Institution/Previous Location) MB_RHA
  • postal code = permanently resides
  • province = registered for healthcare, or resides
  • MB_RHA may have nothing to do with where patient lives

• Manitoba RHAs - Various reports care about which RHA a patient resides in, or which sent a patient, eg for re-patriation; we don't collect this directly, in stead it is derived, sometimes from Previous Location via s_dispo table.MB_RHA and at other times from Postal Code via Postal_Code_Master table
  • Manitoba RHAs is not currently considered under Data Dependencies, a blind spot we should probably fix