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 Use Case 1_ Replace old facts with new facts

Use Case 1_ Replace old facts with new facts

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>
<patient_id
source=3D= "HIVE">100</patie= nt_id>
<>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>
<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:

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

ENCOUNTER_NUM

PATIENT_NUM

CONCEPT_CD

NVAL_NUM

UPDATE_DATE

100

100

FC30.00620

10.9

2008-05-04 18:13:51

100

100

FC30.00621

20.2

2008-05-04 18:13:51

100

100

FC30.00622

6.0

2008-05-04 18:13:51

=20



The = rows in the OBSERVATION_FACT table after the update:

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

ENCOUNTER_NUM

PATIENT_NUM

CONCEPT_CD

NVAL_NUM

UPDATE_DATE

100

100

LCSI2B2:pulweight

100.9

2008-05-04 18:13:51

100

100

LCSI2B2:pulheight

6.0

2008-05-04 18:13:51

100

100

LCSI2B2:pulfev1pred

76

2008-05-04 18:13:51

=20



------=_Part_8013_1800411228.1711658324195--