Changing D IDs

From CCMDB Wiki
Jump to navigation Jump to search

The D ID field links all our data for a single patient ward-stay together. When it needs to be changed, the change needs to be done to several different places to make sure everything stays connected.

Why you might change a D_ID

  • For incorrect location ICU can catch through TISS.
Data processor.svg
  • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
  • SMW


  • Cargo


  • Categories

For Medicine you can catch through linking error checks by the Previous location and Dispo field, but if single admission no way of knowing .

Data processor.svg
  • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
  • SMW


  • Cargo


  • Categories

Instructions

Data processor.svg
  • Which program do you do this in? This may actually need to be different instructions for different scenarios.
  • SMW


  • Cargo


  • Categories

If the D ID field is changed anywhere, it needs to be changed in the other locations as well:

Data processor.svg

How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)

  • SMW


  • Cargo


  • Categories

Related articles

Related articles: