Manitoba Health Match Indicator Guideline: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 1: Line 1:
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
|- style="background-color:#FFFF99;font-size:9pt"
|- style="background-color:#FFFF99;font-size:9pt"
| width="37" height="36" align="center" valign="bottom" | Match indicator value
| width="39" height="39" align="center" valign="bottom" | Match indicator value
| width="106"  valign="bottom" | Match Indicator referance
| width="106"  valign="bottom" | Match Indicator referance
| width="67"  valign="bottom" | element
| width="68"  valign="bottom" | element
| width="25"  valign="bottom" | Num.
| width="25"  valign="bottom" | Num.
| width="151"  valign="bottom" | Inconsistencies with CCM database
| width="163"  valign="bottom" | Inconsistencies with CCM database
| width="100"  valign="bottom" | Action with database
| width="109"  valign="bottom" | Action with database


|-  
|-  
|style="background-color:#CCFFFF;font-weight:bold" height="15" align="center" valign="bottom" | 1
|style="background-color:#CCFFFF;font-weight:bold" height="14" align="center" valign="bottom" | 1
|style="font-size:11pt" valign="bottom" | match using PHIN
|  valign="bottom" | match using PHIN
|style="color:#0000FF"  valign="bottom" | LastName
|style="font-weight:bold;color:#0000FF"  valign="bottom" | LastName
|  valign="top" | 1
|  valign="top" | 1
|style="font-size:11pt" valign="bottom" | mispelled
|  valign="bottom" | mispelled
|style="font-size:11pt" valign="bottom" | chane
|  valign="bottom" | chane


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 2
|  valign="top" | 2
|style="font-size:11pt" valign="bottom" | missing space, dot, hyphen
|  valign="bottom" | missing space, dot, hyphen
|style="font-size:11pt" valign="bottom" | change
|  valign="bottom" | change


|-  
|-  
|style="font-size:11pt" height="15" align="center" valign="bottom" | &nbsp;
| height="14" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 3
|  valign="top" | 3
|style="font-size:11pt" valign="bottom" | change in marital status
|  valign="bottom" | change in marital status
|style="font-size:11pt" valign="bottom" | keep
|  valign="bottom" | keep


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="color:#0000FF"  valign="bottom" | FirstName
|style="font-weight:bold;color:#0000FF"  valign="bottom" | FirstName
|  valign="top" | 1
|  valign="top" | 1
|style="font-size:11pt" valign="bottom" | mispelled
|  valign="bottom" | mispelled
|style="font-size:11pt" valign="bottom" | change
|  valign="bottom" | change


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 2
|  valign="top" | 2
|style="font-size:11pt" valign="bottom" | missing space, dot, hyphen
|  valign="bottom" | missing space, dot, hyphen
|style="font-size:11pt" valign="bottom" | case to case
|  valign="bottom" | case to case


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 3
|  valign="top" | 3
|style="font-size:11pt" valign="bottom" | nickname
|  valign="bottom" | nickname
|style="font-size:11pt" valign="bottom" | case to case
|  valign="bottom" | case to case


|-  
|-  
|style="font-size:11pt" height="15" align="center" valign="bottom" | &nbsp;
| height="14" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 4
|  valign="top" | 4
|style="font-size:11pt" valign="bottom" | two names
|  valign="bottom" | two names
|style="font-size:11pt" valign="bottom" | keep one name only
|  valign="bottom" | keep one name only


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="color:#0000FF"  valign="bottom" | DOB
|style="font-weight:bold;color:#0000FF"  valign="bottom" | DOB
|  valign="top" | 1
|  valign="top" | 1
|style="font-size:11pt" valign="bottom" | diff day
|  valign="bottom" | diff day
|style="font-size:11pt" valign="bottom" | keep day if not '01'
|  valign="bottom" | keep day if not '01'


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 2
|  valign="top" | 2
|style="font-size:11pt" valign="bottom" | diff month
|  valign="bottom" | diff month
|style="font-size:11pt" valign="bottom" | change month
|  valign="bottom" | change month


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 3
|  valign="top" | 3
|style="font-size:11pt" valign="bottom" | diff year
|  valign="bottom" | diff year
|style="font-size:11pt" valign="bottom" | change year
|  valign="bottom" | change year


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 4
|  valign="top" | 4
|style="font-size:11pt" valign="bottom" | diff year & month
|  valign="bottom" | diff year & month
|style="font-size:11pt" valign="bottom" | change year & month
|  valign="bottom" | change year & month


|-  
|-  
|style="font-size:11pt" height="14" align="center" valign="bottom" | &nbsp;
| height="13" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 5
|  valign="top" | 5
|style="font-size:11pt" valign="bottom" | diff year, month & day
|  valign="bottom" | diff year, month & day
|style="font-size:11pt" valign="bottom" | case to case
|  valign="bottom" | case to case


|-  
|-  
|style="font-size:11pt" height="15" align="center" valign="bottom" | &nbsp;
| height="14" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 6
|  valign="top" | 6
|style="font-size:11pt" valign="bottom" | month and day interchanged
|  valign="bottom" | month and day interchanged
|style="font-size:11pt" valign="bottom" | change month & day
|  valign="bottom" | change month & day


|-  
|-  
|style="font-size:11pt" height="15" align="center" valign="bottom" | &nbsp;
| height="14" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="color:#0000FF"  valign="bottom" | SEX
|style="font-weight:bold;color:#0000FF"  valign="bottom" | SEX
|  valign="top" | 1
|  valign="top" | 1
|style="font-size:11pt" valign="bottom" | diff sex
|  valign="bottom" | diff sex
|style="font-size:11pt" valign="bottom" | change
|  valign="bottom" | change


|-  
|-  
|style="font-size:11pt" height="15" align="center" valign="bottom" | &nbsp;
| height="14" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="color:#0000FF"  valign="bottom" | PROVINCE
|style="font-weight:bold;color:#0000FF"  valign="bottom" | PROVINCE
|  valign="top" | 1
|  valign="top" | 1
|style="font-size:11pt" valign="bottom" | different province
|  valign="bottom" | different province
|style="font-size:11pt" valign="bottom" | change
|  valign="bottom" | change


|-  
|-  
|style="background-color:#CCFFFF;font-weight:bold" height="15" align="center" valign="bottom" | 2
|style="background-color:#CCFFFF;font-weight:bold" height="14" align="center" valign="bottom" | 2
|style="font-size:11pt" valign="bottom" | match NOT using PHIN
|  valign="bottom" | match NOT using PHIN
|style="color:#0000FF"  valign="bottom" | Pseudo PHIN
|style="font-weight:bold;color:#0000FF"  valign="bottom" | Pseudo PHIN
|  valign="top" | 1
|  valign="top" | 1
|  valign="bottom" | ●SAME last & first name & DOB
|  valign="bottom" | ●SAME last & first name & DOB
|style="font-size:11pt" valign="bottom" | change PHIN
|  valign="bottom" | change PHIN


|-  
|-  
|style="font-size:11pt" height="29" align="center" valign="bottom" | &nbsp;
| height="26" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 2
|  valign="top" | 2
|  valign="bottom" | ●SAME last & first name  ●DIFFERENT DOB
|  valign="bottom" | ●SAME last & first name  ●DIFFERENT DOB
|style="font-size:11pt" valign="bottom" | keep pseudo PHIN
|  valign="bottom" | keep pseudo PHIN


|-  
|-  
|style="font-size:11pt" height="30" align="center" valign="bottom" | &nbsp;
| height="26" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 3
|  valign="top" | 3
|  valign="bottom" | ●DIFFERENT last or first name ●SAME DOB
|  valign="bottom" | ●DIFFERENT last or first name ●SAME DOB
|style="font-size:11pt" valign="bottom" | case to case
|  valign="bottom" | case to case


|-  
|-  
|style="font-size:11pt" height="45" align="center" valign="bottom" | &nbsp;
| height="40" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="color:#0000FF"  valign="bottom" | 9 digit PHIN
|style="font-weight:bold;color:#0000FF"  valign="bottom" | 9 digit PHIN
|  valign="top" | 1
|  valign="top" | 1
|  valign="bottom" | ●SAME last & first name & DOB ●DIFFERENCE in 1 or 2 digits of PHIN
|  valign="bottom" | ●SAME last & first name & DOB ●DIFFERENCE in 1 or 2 digits of PHIN
|style="font-size:11pt" valign="bottom" | change PHIN
|  valign="bottom" | change PHIN


|-  
|-  
|style="font-size:11pt" height="45" align="center" valign="bottom" | &nbsp;
| height="40" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 2
|  valign="top" | 2
|  valign="bottom" | ●DIFFERENT last or first name, ●SAME DOB  ●DIFFERENCE in 1 or 2 digits of PHIN
|  valign="bottom" | ●DIFFERENT last or first name, ●SAME DOB  ●DIFFERENCE in 1 or 2 digits of PHIN
|style="font-size:11pt" valign="bottom" | case to case
|  valign="bottom" | case to case


|-  
|-  
|style="font-size:11pt" height="34" align="center" valign="bottom" | &nbsp;
| height="31" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 3
|  valign="top" | 3
|  valign="bottom" | ●SAME last  & first name & DOB ●DIFFERENT PHIN (all digits)
|  valign="bottom" | ●SAME last  & first name & DOB ●DIFFERENT PHIN (all digits)
|style="font-size:11pt" valign="bottom" | keep PHIN
|  valign="bottom" | keep PHIN


|-  
|-  
|style="font-size:11pt" height="44" align="center" valign="bottom" | &nbsp;
| height="40" align="center" valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="top" | 4
|  valign="top" | 4
|  valign="bottom" | ●DIFFERENT last or first name ●SAME DOB  ●DIFFERENT PHIN (all digits)
|  valign="bottom" | ●DIFFERENT last or first name ●SAME DOB  ●DIFFERENT PHIN (all digits)
|style="font-size:11pt" valign="bottom" | keep PHIN
|  valign="bottom" | keep PHIN


|-  
|-  
|style="background-color:#CCFFFF;font-weight:bold" height="15" align="center" valign="bottom" | 0
|style="background-color:#CCFFFF;font-weight:bold" height="14" align="center" valign="bottom" | 0
|style="font-size:11pt"  valign="bottom" | No match
|  valign="bottom" | No match
|style="font-weight:bold"  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-weight:bold"  valign="bottom" | &nbsp;
|  valign="bottom" | keep
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt" valign="bottom" | keep


|}
|}

Revision as of 18:52, 26 January 2009

Match indicator value Match Indicator referance element Num. Inconsistencies with CCM database Action with database
1 match using PHIN LastName 1 mispelled chane
      2 missing space, dot, hyphen change
      3 change in marital status keep
    FirstName 1 mispelled change
      2 missing space, dot, hyphen case to case
      3 nickname case to case
      4 two names keep one name only
    DOB 1 diff day keep day if not '01'
      2 diff month change month
      3 diff year change year
      4 diff year & month change year & month
      5 diff year, month & day case to case
      6 month and day interchanged change month & day
    SEX 1 diff sex change
    PROVINCE 1 different province change
2 match NOT using PHIN Pseudo PHIN 1 ●SAME last & first name & DOB change PHIN
      2 ●SAME last & first name ●DIFFERENT DOB keep pseudo PHIN
      3 ●DIFFERENT last or first name ●SAME DOB case to case
    9 digit PHIN 1 ●SAME last & first name & DOB ●DIFFERENCE in 1 or 2 digits of PHIN change PHIN
      2 ●DIFFERENT last or first name, ●SAME DOB ●DIFFERENCE in 1 or 2 digits of PHIN case to case
      3 ●SAME last & first name & DOB ●DIFFERENT PHIN (all digits) keep PHIN
      4 ●DIFFERENT last or first name ●SAME DOB ●DIFFERENT PHIN (all digits) keep PHIN
0 No match       keep


TOstryzniuk 17:49, 26 January 2009 (CST)

{{stub]]