Changing D IDs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
No edit summary |
||
| Line 2: | Line 2: | ||
== Why you might change a D_ID == | == Why you might change a D_ID == | ||
This used to be a common occurrence following certain patterns, but is only done ad-hoc in rare and unique scenarios now. | |||
== Instructions == | == Instructions == | ||
If the [[D ID field]] is changed anywhere, it needs to be changed in the other locations as well: | 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_Log table]] in [[Centralized data.mdb]] (this will automatically change the related [[L-tables]] | ||
* [[L_PHI table]] in [[PHI.mdb]] | * [[L_PHI table]] in [[PHI.mdb]] | ||
For older records, the following would also need to be changed: | |||
* [[L_TISS_Form table]] | |||
* [[L_TISS_Item table]] | |||
* [[L_Labs_DSM table]] | |||
== Related articles == | == Related articles == | ||
Revision as of 13:55, 17 March 2022
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
This used to be a common occurrence following certain patterns, but is only done ad-hoc in rare and unique scenarios now.
Instructions
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
For older records, the following would also need to be changed:
Related articles
| Related articles: |