|Data Element (edit)|
|CCMDB tab:||Top Row|
|Table:||L_Log table, L_PHI table|
|Program:||Med and CC|
The patient's PHIN .
Legacy implementation right in the table
The PHIN (Personal Health Information number) is a unique nine-digit numeric identifier assigned by Manitoba Health to every person registered for health insurance in Manitoba. For patients who are not registered with Manitoba Health we assign a Pseudo PHIN.
MB Health PHINs only
Manitoba Health PHIN numbers only.
If patient permanently resides outside of the province of Manitoba the Province field should not be MB and the PHIN field should be left blank.
Please make every effort to obtain this information and call medical records to help.
Possibility of adding other Province's PHINs
|old discussion, result: not at this time|
Location Manitoba and no PHIN
There are scenarios where a PHIN will not be available for a Manitoba patient, including but not limited to
- immigrants and international students on visas
- some prison inmates
Profiles of international students may or may not have a PHIN. At some point, students have at times been covered, then been required to get a specific U of M insurance, and as of 2021-07 appear to have some choice of how they insure, although insurance is mandatory archive.
Location Outside Manitoba and no PHIN
PHIN must be entered by data collector as blank. A Pseudo PHIN will be entered by the data processor after file is appended to master database.
Canadian Forces patients
Since the PHIN is used as a unique identifier for patients to detect repeat and continuous visits, a "pseudoPHIN" is assigned for patients who don't have a PHIN. At this point, pseudoPHINS are assigned by Pagasa, see see Generating PseudoPHINs.
Use started in 1999 and starts in '1' and as of Mar 18, 2013 our last Pseudo number was 7043.
We observed that there was a drop in the number of PseudoPHINs during the part of COVID. We confirmed that fewer out-of-province patients would have been accepted during this time, so that change is legitimate.
Multiple PHINs or PHIN changes over time
People may change PHINs over time or have multiple PHINs. This can occur in 3 main ways:
- moving from OOP to MB,
- moving from MB to OOP, and
- a single individual having multiple PHINs (usually somethign went wrong in registration with MB Health)
For the purpose of identifying "same person", and uniformity, we will enter the current/most PHIN or PseudoPHIN into the PHIN field of all encounters of that patient in our database. Earlier PHINs or PseudoPHINs will be retained in Alias ID collection. This may mean that we change an existing PHIN to a PseudoPHIN. This may trigger some errors in our cross checks; if so, appropriate records will be added to the L_Problem table so the error goes away.
Minimal Data Set
This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.
L_PHI vs L_Log
Data Integrity Checks (automatic list)
|Check duplicate patient||CCMDB.accdb||implemented|
|Query check minimal data set incomplete||CCMDB.accdb||implemented|
|Function Validate PHIN||CCMDB.accdb||implemented|
|Function PHIN same as Chart||CCMDB.accdb||implemented|
|Function Validate Chart||CCMDB.accdb||implemented|
|Function Validate Province||CCMDB.accdb||implemented|
|Link suspect dead then alive query||Centralized data front end.accdb||implemented|
|Link suspect mismatch from ours incomplete query||Centralized data front end.accdb||implemented|
|Link suspect mismatch to ours incomplete query||Centralized data front end.accdb||implemented|
|Link suspect negative transit time query||Centralized data front end.accdb||implemented|
|PL SamePHIN Site Diff chart||Centralized data front end.accdb||implemented|
|PL SameCHART Site Diff PHIN||Centralized data front end.accdb||implemented|
|PL Diff Phin SameLN FN DOB||Centralized data front end.accdb||implemented|
|PL 2Phin Fake or Blank||Centralized data front end.accdb||implemented|
|PL SamePhin Diff DOB Sex||Centralized data front end.accdb||implemented|