CFE Inline Integrity Checks: Difference between revisions

Revision as of 16:24, 2022 August 9

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.

Best to not do this inline after all.

We'll want to add some "post processing checks" that Pagasa would run after all edits for a day. To be done between Quality Assurance queries in CFE and actually setting records to "vetted".

	This would best be based on things Pagasa is likely to check and change, and I think she most likely changes the following: Service tmp entry and Boarding Loc and Transfer Ready DtTm tmp entry and Dispo DtTms So checks I can think of would be: 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? Would running these queries just before vetting work for Pagasa? Ttenbergen 16:24, 2022 August 9 (CDT)

@@ Line 8: / Line 8: @@
 ===What sort of checks do we actually want? ===
-{{Todo
+{{Discuss |
- | who = Tina
+* This would best be based on things Pagasa is likely to check and change, and I think she most likely changes the following:
- | todo_added = 2021-07-27
+** [[Service tmp entry]] and [[Boarding Loc]] and [[Transfer Ready DtTm tmp entry]] and [[Dispo DtTm]]s
- | todo_action = 2022-08-09
+* So checks I can think of would be:
- | question =
-* * This would best be based on things Pagasa is likely to check and change
-** [[Service tmp entry]] and [[Boarding Loc]] and [[Transfer Ready DtTm tmp entry]] and [[Dispo DtTm]]s that are not chronological are most likely culprits.
 ** All S, B, T have to be before D
-** any T has to be after its B
+** any T has to be after the B it's linked to
-** All CCI and ICD10 have to be after first S/B and before Dispo
+** 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? Would running these queries just before vetting work for Pagasa? [[User:Ttenbergen|Ttenbergen]] 16:24, 2022 August 9 (CDT)
 }}

Related articles: