Reconnect check missing L Tables content query: Difference between revisions

(19 intermediate revisions by 2 users not shown)

Line 8:

|DIC_firmness=hard check

|DIC_timing=complete

|DIC_coding=~~query~~ ''~~NDC_missing_L_Tables_content~~''

|DIC_coding=''Reconnect_check_missing_L Tables_content'' query

|DIC_implementation_date=2016-01-21

|DIC_status=~~ready to implement~~

|DIC_status=implemented

|DIC_LProblem=No

|DIC_app=Centralized data front end.accdb

|DIC_backlogged=No

}}

~~{{DT | dev_CFE~~

* Confirm this only deals with complete records

* Needs to check not listing missing Dispo, Previous Location - email Pagasa when fixed. }}

~~'''~~This query ~~must be~~ run ~~daily by [[Data Processor]]. This is one RED flag to data processor, that there was a problem with the~~ [[~~sending~~]]. ~~'''~~

This query is automatically run as part of [[Reconnect CFE and initial error checks]].

==Investigation Process==

Line 27:

Line 25:

== Log errors ==

There are checks in place in [[CCMDB.accdb]] that should prevent sending of these. So, if any get through then either those checks are not working, or the problem arises during [[Sending]] and not at the source.

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

== Log ==

* Pagasa, ~~could you please~~ log ~~here when~~ this query ~~lists errors~~, and ~~what was found~~ to be the problem ~~(ie whether there~~ was ~~data~~ in [[~~CCMDB.accdb~~]] ~~that didn't make it~~, or no ~~data~~ in ~~first place~~. }}

=== 2021 -11-04 ===

''There may be some problems, or missing items, in this log entry. Sending with a previously sent file still on the laptop would not usually cause this problem, so something else was going on in addition. Discovered the inconsistency in the write-up only 4 months after the issue, so impossible to track down now what went wrong, so just leaving this note instead of trying to correct. ''

* Problem found that no ICD10 code in [[Reconnect_check_missing_L Tables_content query]] from S5 laptop, problem fixed. [[User:PTorres|PTorres]] 16:55, 2021 November 24 (CST)

* Started when Pam cannot send with [[Error "Invalid SQL statment..." when sending]]

* Then found out that there are records with [[RecordStatus]] "Complete" after I clicked the Reconnect button it saying Complete Record Status.

* We trouble shoot S5 laptop, found out that she still have some Record Status "Sent" but sent with older send date in CFE but not deleted yet on the laptop.

* Because of those old Sent but not deleted on the laptop, CFE Record Status Vetted became Sent again even though it was Vetted before.

* Before if we have Record Status Complete means sending did not go through completely the sending, and need to be re send, but with this problem not true data sent completely the problem is in the Record Status in CFE already Vetted it became Sent again because their was Sent in the laptop which is not deleted.[[User:PTorres|PTorres]] 16:16, 2021 November 29 (CST)

=== 2021-08-04 ===

* updated query [[Reconnect_check_missing_L Tables_content query]] to no longer look at old [[L Labs Flowsheet table]]

=== 2021-07-15 ===

* updated to integrate parts that were in another query, and to always only look at the last 90 days, rather than starting at a set dttm.

~~== Log ==~~

===2019-08-22===

* HSC_SICd-2547 - Found out missing all the L Table's (ICD10,CCI,APACHE,LAB TMP and PHARM). Noticed that the [[RecordStatus]] is '''Blank'''.

Line 45:

Line 55:

** STB_E6a-1056 Sent 2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )

*** [[User:PTorres|PTorres]] 15:38, 2019 August 22 (CDT)

~~{{Discuss |Have there been more since? }}~~

===2019-03-27===

@@ Line 8: / Line 8: @@
 |DIC_firmness=hard check
 |DIC_timing=complete
-|DIC_coding=query ''NDC_missing_L_Tables_content''
+|DIC_coding=''Reconnect_check_missing_L Tables_content'' query
 |DIC_implementation_date=2016-01-21
-|DIC_status=ready to implement
+|DIC_status=implemented
 |DIC_LProblem=No
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
-{{DT | dev_CFE
-* Confirm this only deals with complete records
-* Needs to check not listing missing Dispo, Previous Location  - email Pagasa when fixed. }}
-'''This query must be run daily by [[Data Processor]]. This is one RED flag to data processor, that there was a problem with the [[sending]]. '''
+This query is automatically run as part of [[Reconnect CFE and initial error checks]].
 ==Investigation Process==
@@ Line 27: / Line 25: @@
 == Log errors ==
 There are checks in place in [[CCMDB.accdb]] that should prevent sending of these. So, if any get through then either those checks are not working, or the problem arises during [[Sending]] and not at the source.
-{{Discuss | who = Pagasa | question =
+== Log ==
-* Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in [[CCMDB.accdb]] that didn't make it, or no data in first place. }}
+=== 2021 -11-04 ===
+''There may be some problems, or missing items, in this log entry. Sending with a previously sent file still on the laptop would not usually cause this problem, so something else was going on in addition. Discovered the inconsistency in the write-up only 4 months after the issue, so impossible to track down now what went wrong, so just leaving this note instead of trying to correct. ''
+* Problem found that  no ICD10 code in [[Reconnect_check_missing_L Tables_content query]] from S5 laptop, problem fixed. [[User:PTorres|PTorres]] 16:55, 2021 November 24 (CST)
+* Started when Pam cannot send  with [[Error "Invalid SQL statment..." when sending]]
+* Then found out that there are records with [[RecordStatus]] "Complete" after I clicked the Reconnect button it saying Complete Record Status.
+* We trouble shoot S5 laptop, found out that she still have some Record Status "Sent" but sent with older send date in CFE but not deleted yet on the laptop.
+* Because of those old Sent but not deleted on the laptop, CFE  Record Status Vetted became Sent again even though it was Vetted before.
+* Before if we have Record Status Complete means sending did not go through completely the sending, and need to be re send, but with this problem not true data sent completely the problem is in the Record Status in CFE already Vetted it became Sent again because their was Sent in the laptop which is not deleted.[[User:PTorres|PTorres]] 16:16, 2021 November 29 (CST)
+=== 2021-08-04 ===
+* updated query [[Reconnect_check_missing_L Tables_content query]] to no longer look at old [[L Labs Flowsheet table]]
+=== 2021-07-15 ===
+* updated to integrate parts that were in another query, and to always only look at the last 90 days, rather than starting at a set dttm.
-== Log ==
 ===2019-08-22===
 * HSC_SICd-2547 - Found out missing all the L Table's (ICD10,CCI,APACHE,LAB TMP and PHARM).  Noticed that the [[RecordStatus]] is '''Blank'''.
@@ Line 45: / Line 55: @@
 ** STB_E6a-1056		Sent	2019/Aug/15 15:15 - Complete - (ICD10,CCI,APACHE,and TMP )
 *** [[User:PTorres|PTorres]] 15:38, 2019 August 22 (CDT)
-{{Discuss |Have there been more since? }}
 ===2019-03-27===