CFE Inline Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(moved here from Change Priorities)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
===CFE editing - need integrity checks in place to catch editing errors===
Pagasa edits in CFE, and right now there are no checks in place for typos in these edits.
*Admit transfer discharge range as from CCMDB


{{Todo
== When and how would these checks run? ==
| who = Tina
Cross-checks in CCMDB are triggered by collectors checking the various "complete" boxes, but there is no equivalent to this in CFE, especially since Pagasa can legitimately edit tables directly or via query, so these checks would likely need to be triggered manually, likely between [[Quality Assurance queries in CFE]] and actually setting records to "vetted".
| todo_added = 2021-07-27
| todo_action =  
| question =  
* What sort of checks do we actually want here?


* What would trigger the checks? We don't have "complete" to trigger a check, so what would trigger it? on_change has problems when used on comparison of multiple fields.
== What sort of checks do we actually want? ==
{{Discuss | who = Pagasa |
* This would best be based on things Pagasa is likely to check and change. Pagasa, so you agree that would most likely changes the following? Are there other checkable things you edit a lot? 
** [[Service tmp entry]] and [[Boarding Loc]] and [[Transfer Ready DtTm tmp entry]] and [[Dispo DtTm]]s
}}
 
{{Discuss |
* Possible checks:
** All S, B, T have to be before D
** any T has to be after the B it's linked to
** any S/B has to be before any CCI and ICD10, and D has to be after these
* Pagasa, Julie, can you think of other things to check?
}}
 
{{Discuss | who = Pagasa |
* Would running these queries just before vetting work for Pagasa? [[User:Ttenbergen|Ttenbergen]] 16:24, 2022 August 9 (CDT)
}}
}}


Line 17: Line 27:


[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
[[Category:Data Processing]]
[[Category:Data Integrity Checks]]

Revision as of 16:31, 2022 August 9

Pagasa edits in CFE, and right now there are no checks in place for typos in these edits.

When and how would these checks run?

Cross-checks in CCMDB are triggered by collectors checking the various "complete" boxes, but there is no equivalent to this in CFE, especially since Pagasa can legitimately edit tables directly or via query, so these checks would likely need to be triggered manually, likely between Quality Assurance queries in CFE and actually setting records to "vetted".

What sort of checks do we actually want?

  • SMW


  • Cargo


  • Categories
  • Possible checks:
    • All S, B, T have to be before D
    • any T has to be after the B it's linked to
    • any S/B has to be before any CCI and ICD10, and D has to be after these
  • Pagasa, Julie, can you think of other things to check?
  • SMW


  • Cargo


  • Categories
  • Would running these queries just before vetting work for Pagasa? Ttenbergen 16:24, 2022 August 9 (CDT)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: