Message-ID: <1698155334.8014.1711658324198.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8013_1800411228.1711658324195" ------=_Part_8013_1800411228.1711658324195 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
In this case the old set of facts is replaced with a new set of =
facts for the matching encounter.
Example:
=
<observation update_date=3D"2008-05-04T18:13=
:51.498-04:00" sourcesystem_cd<=
/span>=3D"PFT">=
<event_id sourc=
e=3D"HIVE">100</event_id>=
<patient_id source=3D"HIVE">100</patient_id>
<concept_c=
d>LCS-I2B2:pulweight<=
span style=3D"color: rgb(0,0,255);"></concept_cd>
=
<nval_num>100.9</nval_num>=
</observation&g=
t;
<observation update_date=3D"=
2008-05-04T18:13:51.498-04:00" =
sourcesystem_cd=3D"PFT"&=
gt;
<event_id source=3D"HIVE">100</event_id>
<
<concept_cd>LCS-I2B2=
:pulheight</concept_cd>
<nval_num>6.0</nval_num>
</observation>
<observation update_date=3D"2008-05-04T18:13:51.498-04:00" sourcesystem_cd=3D=
"PFT">
<=
event_id source=3D"HIVE">100&=
lt;/event_id>
<patient_id source=3D"HIVE">1=
00</patient_id>=
span>
<concept_cd>LCS-I2B2:pulfev1pred</<=
/span>concept_cd>
<nval_num>76</nval_num
</observation<=
/span>>
The rows in the OBSERVATION=
_FACT table before the update:
ENCOUNTER_NUM | =20
PATIENT_NUM | =20
CONCEPT_CD | =20
NVAL_NUM | =20
UPDATE_DATE | =20
100 | =20
100 | =20
FC30.00620 | =20
10.9 | =20
2008-05-04 18:13:51 | =20
100 | =20
100 | =20
FC30.00621 | =20
20.2 | =20
2008-05-04 18:13:51 | =20
100 | =20
100 | =20
FC30.00622 | =20
6.0 | =20
2008-05-04 18:13:51 | =20
The =
rows in the OBSERVATION_FACT table after the update:
ENCOUNTER_NUM | =20
PATIENT_NUM | =20
CONCEPT_CD | =20
NVAL_NUM | =20
UPDATE_DATE | =20
100 | =20
100 | =20
LCSI2B2:pulweight | =20
100.9 | =20
2008-05-04 18:13:51 | =20
100 | =20
100 | =20
LCSI2B2:pulheight | =20
6.0 | =20
2008-05-04 18:13:51 | =20
100 | =20
100 | =20
LCSI2B2:pulfev1pred | =20
76 | =20
2008-05-04 18:13:51 | =20