Changing D IDs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[ | 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 == | == 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 [[ | * [[L_Log table]] in [[Centralized_data.accdb]] (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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category: Multiple Encounter]] | [[Category:Multiple Encounter]] | ||
[[Category: Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||
Latest revision as of 10:32, 30 July 2025
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.accdb (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: |