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 2: Line 2:


*See [[Manitoba_Health_"Conditioner"]] which is an ACCESS program that automates the data crosschecking process when data is returned from MB Health.
*See [[Manitoba_Health_"Conditioner"]] which is an ACCESS program that automates the data crosschecking process when data is returned from MB Health.
 
*also see [[Crosschecking_data_with_Manitoba_Health]].
**NOTE: these 3 articles need to be reworked and somehow consolidated so that the process is easier to follow and find on the WIKI.[[User:TOstryzniuk|TOstryzniuk]] 19:00, 26 January 2009 (CST)


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>

Revision as of 19:00, 26 January 2009

  • this is the decision guide that the data processor must follow when crosschecked data has been returned from Manitoba Health and correction are to be made in our database.
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]]