Server (Cells) Design
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Wiki Markup
\\
_(<pid> not found, generate \[max+1\])_
\\
If the <patient_id> source / value pair has not been added to the mapping table, a new PATIENT_NUM with value max(patient_num)+1 should be generated and all the PATIENT_NUMs for this patient will receive this value. The new patient number must also be added to the PATIENT_DIMENSION table.
\\
*_+Example{+}:_*
New <patient_id> source / value pair = 'EMPI' / 1000000
Select max(patient_num) from patient_mapping = 527
New patient_num = max(patient_num) + 1 = 528
\\
<span style="color: #0000ff">&lt;</span><span style="color: #a31515">pid</span><span style="color: #0000ff">&gt;</span>
 <span style="color: #0000ff">&lt;</span><span style="color: #a31515">patient_id</span> <span style="color: #ff0000">source</span>="<span style="color: #0000ff">EMPI</span>"<span style="color: #0000ff">&gt;</span>1000000<span style="color: #0000ff">&lt;/</span><span style="color: #a31515">patient_id</span><span style="color: #0000ff">&gt;</span>
 <span style="color: #0000ff">&lt;</span><span style="color: #a31515">patient_map_id</span> <span style="color: #ff0000">source</span>="<span style="color: #0000ff">MGH</span>"<span style="color: #0000ff">&gt;</span>123<span style="color: #0000ff">&lt;/</span><span style="color: #a31515">patient_map_id</span><span style="color: #0000ff">&gt;</span>
 <span style="color: #0000ff">&lt;</span><span style="color: #a31515">patient_map_id</span> <span style="color: #ff0000">source</span>="<span style="color: #0000ff">BWH</span>"<span style="color: #0000ff">&gt;</span>777<span style="color: #0000ff">&lt;/</span><span style="color: #a31515">patient_map_id</span><span style="color: #0000ff">&gt;</span>
<span style="color: #0000ff">&lt;/</span><span style="color: #a31515">pid</span><span style="color: #0000ff">&gt;</span>
\\
\\
The rows in the PATIENT_MAPPING table will appear as follows:
\\

PATIENT_IDE

PATIENT_IDE_SOURCE

PATIENT_NUM

PATIENT_IDE_STATUS

1000000

EMPI

528

A

123

MGH

528

A

777

BWH

528

A

528

HIVE

528

A