Changing D IDs

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

• patient was sent with wrong Service/Location

• For incorrect location ICU can catch through TISS.

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 .

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

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:

• L_Log table in Centralized data.mdb (this will automatically change the related L-tables
• L_PHI table in PHI.mdb

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