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
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 source=3D"BWH">777</patient_map_id=
span>>
</pati=
ent>
The rows in the PATIENT=
_MAPPING table before=
span> the update:
PATIENT_IDE | =20
PATIENT_IDE_SOURCE | =
=20
PATIENT_NUM | =20
PATIENT_IDE_STATUS | =
=20
UPDATE_DATE | =20
100 | =20
HIVE | =20
100 | =20
A | =20
2006-12-03 00:00:00 | =20
The =
rows in the PATIENT_MAPPING table after the update:
PATIENT_IDE | =20
PATIENT_IDE_SOURCE | =
=20
PATIENT_NUM | =20
PATIENT_IDE_STATUS | =
=20
UPDATE_DATE | =20
100 | =20
HIVE | =20
100 | =20
A | =20
2008-05-04 18:13:51 | =20