Changing D IDs: Difference between revisions

(7 intermediate revisions by 2 users not shown)

Line 1:

[[~~D_ID~~]]~~s might need~~ to be changed .~~..when?~~

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.

**Incorrect D_ID ~~that already sent can crossed checks through Tiss. For Med. you can catch through linking error checks by the Previous location and Dispo field~~, but ~~if single admission no way of knowing it that~~ is ~~incorrect serial number unless the collector notify me~~.

== 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 ==

*To fix it go to L_Log change ~~it to "D_ID" then to~~ the ~~Pat_ID.~~

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

*~~Then you have to go to~~ L_PHI ~~and change to D_ID.~~

* [[L_Log table]] in [[Centralized_data.accdb]] (this will automatically change the related [[L-tables]]

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

* [[L_PHI table]] in [[PHI.mdb]]

~~{{Discuss | who=Pagasa | question =~~

For older records, the following would also need to be changed:

* Are they ever changed once originally entered? If so, ~~what are~~ the ~~steps~~ to ~~make sure that nothing in e.g.~~ [[~~TISS~~]] or [[~~DSM data~~]] ~~is left behind?~~

* [[L_TISS_Form table]]

** Yes there are errors with location and sometimes serial number after collectors sent that I catch when I am cleaning.[[~~User:PTorres|PTorres~~]]

* [[L_TISS_Item table]]

*** Then we need the steps here, since it has to be done in many places so that DSM and TISS and PHI (and more?) don't get disconnected. Ttenbergen 16:47, 2018 May 31 (CDT) }}

* [[L_Labs_DSM table]]

== 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]]

@@ Line 1: / Line 1: @@
-[[D_ID]]s might need to be changed ...when?
+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.
-**Incorrect D_ID that already sent can crossed checks through Tiss.  For Med. you can catch through linking error checks by the Previous location and Dispo field, but if single admission no way of knowing it that is incorrect serial number unless the collector notify me.
+== 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 ==
-*To fix it go to L_Log change it to "D_ID" then to the Pat_ID.
+If the [[D ID field]] is changed anywhere, it needs to be changed in the other locations as well:
-*Then you have to go to L_PHI and change to D_ID.
+* [[L_Log table]] in [[Centralized_data.accdb]] (this will automatically change the related [[L-tables]]
-**For incorrect location ICU can catch through Tiss. For Med. you can catch through linking error checks by the Previous location and Dispo field, but if single admission no way of knowing .
+* [[L_PHI table]] in [[PHI.mdb]]
-{{Discuss | who=Pagasa | question =
+For older records, the following would also need to be changed:
-* Are they ever changed once originally entered? If so, what are the steps to make sure that nothing in e.g. [[TISS]] or [[DSM data]] is left behind?
+*  [[L_TISS_Form table]]
-** Yes there are errors with location and sometimes serial number after collectors sent that I catch when I am cleaning.[[User:PTorres|PTorres]]
+*  [[L_TISS_Item table]]
-*** Then we need the steps here, since it has to be done in many places so that DSM and TISS and PHI (and more?) don't get disconnected. Ttenbergen 16:47, 2018 May 31 (CDT) }}
+*  [[L_Labs_DSM table]]
 == 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]]