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.
Duplicate Provider Queries
#
Field
A
B
C
D
E
F
G
Surname
E
E
E
E
E
E
First 3 characters of Surname
First name
E
E
R5
E
First name initial
E
E
E
Second name
R3
Date of birth (day, month and year)
E
E
E
E
E
E
E
Month of birth (month and year)
Gender
E
E
E
E
E
E
Credential & year credential issued
E
E
E
E
Expertise type
City
E
E
E
E
Provider role type
<>E
E = exact match
R = reversed with other data elements
