Changing D IDs: Difference between revisions

Revision as of 22:23, 6 February 2019

D_IDs might need to be changed ...when?

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

	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.

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.

	Which program do you do this in? This may actually need to be different instructions for different scenarios.

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

	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)

@@ Line 3: / Line 3: @@
 == Why you might change a D_ID ==
-*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 .
+*For incorrect location ICU can catch through TISS.
+{{Discuss | who=Pagasa | question =
+* 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. }}
+For Medicine you can catch through linking error checks by the Previous location and Dispo field, but if single admission no way of knowing .
+{{Discuss | who=Pagasa | question =
+* 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. }}
 == Instructions ==
@@ Line 12: / Line 18: @@
 * [[L_Log table]] in [[Centralized data.mdb]] (this will automatically change the related [[L-tables]]
 * [[L_PHI table]] in [[PHI.mdb]]
-{{Discuss | who=Pagasa | question = How about TISS and DSM? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)}}
+{{Discuss | who=Pagasa | question = 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)}}
 == Related articles ==