Message-ID: <1495191149.8680.1711721578246.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8679_1881829342.1711721578245" ------=_Part_8679_1881829342.1711721578245 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Use Case 3_ PATIENT_NUM in mapping table but with a different da= te

Use Case 3_ PATIENT_NUM in mapping table but with a different date<= /h1>

If the <patient_id> value already exists in the mapping ta= ble then compare the UPDATE_DATE to the existing record's update date. If t= he new record has a more recent date, then update the current patient recor= d with this data.
Example:
<patient update_date =3D"2008-05-0418:13:51.00">
<= patient_map_id source=3D"HIVE">100</patient_map_id>
<patient_map_id source=3D"BWH">
777</patient_map_id>
</pati= ent>

The rows in the PATIENT= _MAPPING table before the update:

=20
=20 =20 =20 = =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

PATIENT_IDE

PATIENT_IDE_SOURCE

PATIENT_NUM

PATIENT_IDE_STATUS

UPDATE_DATE

100

HIVE

100

A

2006-12-03 00:00:00

=20



The = rows in the PATIENT_MAPPING table after the update:

=20
=20 =20 =20 = =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

PATIENT_IDE

PATIENT_IDE_SOURCE

PATIENT_NUM

PATIENT_IDE_STATUS

UPDATE_DATE

100

HIVE

100

A

2008-05-04 18:13:51

=20



------=_Part_8679_1881829342.1711721578245--