Re: [Gnumed-devel] Schema question about dem.lnk_identity2ext_id

[Karsten Hilbert]

> And accordingly, if in British Columbia CA the most common and  
> practical automatch criteria would involve patients' "Personal Health  
> Number", for this we would want to match
> 
>       "external_id" in dem.lnk_identity2ext_id
> 
> where
> 
>       "issuer" in dem.enum_ext_id_types is "BC"

I would be more specific that "BC", say, "British Columbia Health
Council" or whatever is appropriate. It'll one day down the road be
helpful to be able to exactly know what this stands for. Or rather,
*if* we chose NOT to be precise that day *will* come.

>       "name" in dem.enum_ext_id_types is "Personal Health Number"
If that's unique enough to describe it, yes.

There's a view aggregating this per patient, BTW.

> and (as a precaution, including against stolen numbers which happens  
> in BC)
> 
>       one of (dob matches OR lastnames match)
If it is provided, yes.

> BTW is it important, in building the SQL, to shorten names, for  
> example should the Personal Health Number in GNUmed be entered  
> shorter as "PHN"?
Clearly no, IMO, due to the above considerations. It may be OK to
shorten to PHN but then one would want to be extra careful about
the issuer. Eventually, however, it all depends on local customs.

Karsten
-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger