Query TISS Errors D ID not in CFE: Difference between revisions

(7 intermediate revisions by 2 users not shown)

Line 1:

{{LegacyContent

|explanation=no more [[TISS28 Form Scanning]] or TISS forms, so nothing to check

|content=

{{Data Integrity Check

|DIC_summary=The D_ID on a TISS28 form does not exist in [[CFE]]

Line 4:

Line 8:

|DIC_firmness=hard check

|DIC_coding=query ''TISS_Errors_D_ID_not_in_CFE''

|DIC_status=~~implemented~~

|DIC_status=retired

|DIC_app=TISS28.~~mdb~~

|DIC_app=TISS28.accdb

}}

No longer relevant now that TISS info is entered directly and stored in CCI

== Causes and solutions ==

~~Could have~~ to ~~do with~~

# look up the [[PHIN]] number on the scanned form image

* record not yet in [[CFE]], ~~because we~~ use [[~~Frozen~~]] ~~version during scanning,~~ if so, ~~leave for now~~

# go to [[CFE]], look up the patient with that [[PHIN]] and use the [[Cat button]] to find related records

* wrong unit was scanned on TISS, in ~~which case, correct~~ the ~~D_IDs in tables L_TISS_Form and L_TISS_Item~~

# check if the to and from fields tell you that this was a '''wrong location''', confirm via [[Finding a patient in EPR]] what the location should be

~~{DT | link~~ to ~~location correcting info }}~~

# check the serial number part of [[D_ID]] to see if one is ''similar'' to the one on the TISS form; if so, follow [[Fixing a D ID in TISS28.accdb]] and change the TISS D_ID to the one from [[CFE]]

== Log ==

* 2019-02-11 - changed to ckeck last 90 days now that Pagasa has explained that TISS collection might be far behind.

== Related articles ==

[[Category: TISS28 ~~checks~~]]

[[Category:Legacy TISS28 check]]

[[Category: ~~Data Processing~~]]

[[Category:TISS28 Scanning Process]]

@@ Line 1: / Line 1: @@
+{{LegacyContent
+|explanation=no more [[TISS28 Form Scanning]] or TISS forms, so nothing to check
+|content=
 {{Data Integrity Check
 |DIC_summary=The D_ID on a TISS28 form does not exist in [[CFE]]
@@ Line 4: / Line 8: @@
 |DIC_firmness=hard check
 |DIC_coding=query ''TISS_Errors_D_ID_not_in_CFE''
-|DIC_status=implemented
+|DIC_status=retired
-|DIC_app=TISS28.mdb
+|DIC_app=TISS28.accdb
 }}
+No longer relevant now that TISS info is entered directly and stored in CCI
 == Causes and solutions ==
-Could have to do with
+# look up the [[PHIN]] number on the scanned form image
-* record not yet in [[CFE]], because we use [[Frozen]] version during scanning, if so, leave for now
+# go to [[CFE]], look up the patient with that [[PHIN]] and use the [[Cat button]] to find related records
-* wrong unit was scanned on TISS, in which case, correct the D_IDs in tables L_TISS_Form and L_TISS_Item
+# check if the to and from fields tell you that this was a '''wrong location''', confirm via [[Finding a patient in EPR]] what the location should be
-{DT | link to location correcting info }}
+# check the serial number part of [[D_ID]] to see if one is ''similar'' to the one on the TISS form; if so, follow [[Fixing a D ID in TISS28.accdb]] and change the TISS D_ID to the one from [[CFE]]
 == Log ==
+* 2019-02-11 - changed to ckeck last 90 days now that Pagasa has explained that TISS collection might be far behind.
 == Related articles ==
 {{Related Articles}}
-[[Category: TISS28 checks]]
+[[Category:Legacy TISS28 check]]
-[[Category: Data Processing]]
+[[Category:TISS28 Scanning Process]]