CFE Inline Integrity Checks

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?

	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)

Related articles:

CFE Inline Integrity Checks

When and how would these checks run?

What sort of checks do we actually want?

Related articles