Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

In this case the old set of facts is replaced with a new set of facts for the matching encounter.
Example:
<observation update_date="2008-05-04T18:13:51.498-04:00" sourcesystem_cd="PFT">
<event_id source="HIVE">100</event_id>
<patient_id source="HIVE">100</patient_id>
<concept_cd>LCS-I2B2:pulweight</concept_cd>
<nval_num>100.9</nval_num>
</observation>
<observation update_date="2008-05-04T18:13:51.498-04:00" sourcesystem_cd="PFT">
<event_id source="HIVE">100</event_id>
<patient_id source="HIVE">100</patient_id>
<concept_cd>LCS-I2B2:pulheight</concept_cd>
<nval_num>6.0</nval_num>
</observation>
<observation update_date="2008-05-04T18:13:51.498-04:00" sourcesystem_cd="PFT">
<event_id source="HIVE">100</event_id>
<patient_id source="HIVE">100</patient_id>
<concept_cd>LCS-I2B2:pulfev1pred</concept_cd>
<nval_num>76</nval_num>
</observation>

The rows in the OBSERVATION_FACT table before the update:

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



The rows in the OBSERVATION_FACT table after the update:

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



  • No labels