How to define PatientMatching to consider only the pat_id to identify a patient

[Cedric Simon]

Hello community,

I am running dcm4chee for a couple of month, and know enabled the worklist, but have issues due to non unique patient id.

I left the PatientMatching in storeScp to its default. I am using dcm4chee-mysql-2.17.2 with dcm4chee-web-3.

I notice that in the patient table I have lots of duplicates. Also issuer is always null. Maybe the null value i the problem (compare anything (even ull) to null is usually returning false), maybe not. Sample patient data is shown below.

I would like to make the pat_id really unique. I can probably fix existing data, but I need to avoid new duplicates.

Lets assume the patient ID is mandatory field on all equipments, and is coming from a central system.

I need DCM4CHEE to reuse existing patient based on the patient id only, no matter what the issuer or names are. I know this could lead to incorrect data in the case they put the wrong id, but I can live with it.

1) How should I define the PatientMatching in storeScp?
2) Should I update the PatientMatching in some other service configuration?
3) Is there a way to avoid the issuer to be null?
4) Is there a way to tell HL7 used by the worklist to take the 1st patient matching pat_id (disabling duplicated patient check)?
5) Anything else I missed?

I already searched on the forum and internet, but I could not find my answers, although I am pretty sure it's already documented somewhere :S

If you need any additional info, let me know.

Many thanks in advance for your help,

Cedric Simon

pat_id    pat_id_issuer    pat_name    pat_birthdate    pat_sex
0001586        URBINA^JOSE VALENTIN^^^        M
0001586        URBINA^JOSE VALENTIN^^^        M
0001060        CUAREZMA FUENTES^RUTH ELI^^^    19640924    F
0001060        CUAREZMA FUENTES^RUTH ELI^^^    19640924    F
0001623        QUINANA MILLON^SERGIO^^^       
0001623        QUINANA MILLON^SERGIO^^^       
0001633        GUTIERREZ CUAREZMA^ALBA LUZ^^^        F
0001633        GUTIERREZ CUAREZMA^ALBA LUZ^^^        F
0001660        LOVO CASCO^ARABELA^^^    19520304   
0001660        LOVO CASCO^ARABELA^^^    19520304   
0001669        JOHANA^PAOLA^OBANDO^^BALDIZON    19860213    F
0001690        SANDINO MUÑOZ^KAREN VIOLETA^^^    19821001    F
0001690        SANDINO MUÑOZ^KAREN VIOLETA^^^    19821001    F
0000016        ESPINOZA LARGAESPADA^TANIA CONSUELO^^^    19840404    F
0001718        LOPEZ SAAVEDRA^BRIANA ALEXANDRA^^^    20140410    F
0001724        GALLARDO VEGA^NELSON GUILLERMO^^^    19520802    M
0001716        BONILLA SANCHEZ^BAYARDO^^^    19560123    M
0001716        BONILLA SANCHEZ^BAYARDO^^^    19560123    M
0001726        ARAGON CIESAR^MARIA DEL CARMEN^^^    19320715    F
0001720        GARCIA MOYA^MARLON ALEJANDRO^^^    19771111    M
0001714        SANDINO^MARIA JOSE^^^    19730829    F
0001718        LOPEZ SAAVEDRA^BRIANA ALEXANDRA^^^    20140410    F
0001720        GARCIA MOYA^MARLON ALEJANDRO^^^    19771111    M
0000016        ESPINOZA LARGAESPADA^TANIA CONSUELO^^^    19840404    F
0001724        GALLARDO VEGA^NELSON GUILLERMO^^^    19520802    M
0001714        SANDINO^MARIA JOSE^^^    19730829    F
0001726        ARAGON CIESAR^MARIA DEL CARMEN^^^    19320715    F
0001732        ROMERO CALERO^MARIA AUXILIADORA^^^    19670429    F
0001729        RUGAMA^ADELA DEL CARMEN^^^    19681026    F
0001729        RUGAMA^ADELA DEL CARMEN^^^    19681026    F
0001732        ROMERO CALERO^MARIA AUXILIADORA^^^    19670429    F
0001732        ROMERO CALERO^MARIA AUXILIADORA^^^    19670429    F

[Funky Koval]

hi,
You should avoid nulls in issuer of PID.
patient matching is configured in storeSCP and HL7Service=ORM, and issuer is obligatory
first try to add issuer in incoming ORM (or in common.xsl)
then set default issuer in ae management for all devices that can't manage issuer of PID tag (0010,0021)

[Cedric Simon]

Thank you for your answer.

I'll review if issuer can be mentioned at the equipment level since I can't bypass it.