Wednesday, January 17, 2007
Duplicate Provider Queries
Find duplicate provider queries in the Jurisdictional Registry Administrator's Guide.doc
Seven Duplicate Provider Queries
This table shows the seven queries PRS
runs to identify duplicate providers.
style='margin-left:23.4pt;border-collapse:collapse;border:none'>
Duplicate Provider Queries | ||||||||
# | Field | A | B | C | D | E | F | G |
lang=EN-CA>1. | Surname | E | E | E | E | E |
| E |
lang=EN-CA>2. | First 3 characters of Surname |
|
|
|
|
|
|
|
lang=EN-CA>3. | First name | E | E | R5 |
|
| E |
|
lang=EN-CA>4. | First name initial |
|
|
| E | E |
| E |
lang=EN-CA>5. | Second name |
|
| R3 |
|
|
|
|
lang=EN-CA>6. | Date of birth (day, month and year) | E | E | E | E | E | E | E |
lang=EN-CA>7. | Month of birth (month and year) |
|
|
|
|
|
|
|
lang=EN-CA>8. | Gender | E | E | E | E |
| E | E |
lang=EN-CA>9. | Credential & year credential issued | E | E |
| E | E |
|
|
lang=EN-CA>10. | Expertise type |
|
|
|
|
|
|
|
lang=EN-CA>11. | City | E | E |
| E |
| E |
|
lang=EN-CA>12. | Provider role type |
|
|
|
|
|
| <>E |
E = exact match
R = reversed with other data elements