Edit Data Integrity Check: Query s tmp Boarding Loc ER delay reasonable

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	query ''s_tmp_Boarding_Loc_ER_delay_reasonable''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

This query validates the [[ER Delay]]. It is one source of many [[Duplicate error messages]]. == Log == * 2024-04-24 - There are many false positives due to ICU delays shorter than 30 mins. Lisa confirmed that we should keep the thresholds, collectors are not happy about how many times the soft check prompts them, at least 3 when checking off the box, and then a couple more when we complete the file. This is a matter of [[Duplicate error messages]]. * 2023-11-26 - confirmed that this query derives program in a way that should still work after [[Change to having each collector collect both programs on the same laptop]] * 2022-04-27 - further increased threshold for Med to 144 because we were still seeing to many false positives * 2022-04-21 - updated the threshold to new mean+3sd as provided by Julie: 73hrs for Med and 67hrs for CC * 2022-04-14 Implemented == Related articles == {{Related Articles}} [[Category:Tmp check]] [[Category:Registry checks]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel