Query check minimal data set incomplete: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "cross check " to "cross check " |
||
| (One intermediate revision by the same user not shown) | |||
| Line 31: | Line 31: | ||
== Log == | == Log == | ||
* 2022-05-31 - update to catch an empty [[Service/Location]] scenario not previously accounted for, ie the blank entry from s_dispo | |||
* 2022-04-21 - removed any checks based on Accept and Arrived DtTm and old Transfer Ready DtTm field | * 2022-04-21 - removed any checks based on Accept and Arrived DtTm and old Transfer Ready DtTm field | ||
* 2022-03-24 - updated to flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank - use what Cognos gives you and update it later if needed | * 2022-03-24 - updated to flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank - use what Cognos gives you and update it later if needed | ||
* 2021-07-22 - added back and then removed again a cross check for ''Arrive DtTm'' - minimal can't check for this since pt might still be in ER and not have one; this should become resolved with [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]] | * 2021-07-22 - added back and then removed again a [[cross check]] for ''Arrive DtTm'' - minimal can't check for this since pt might still be in ER and not have one; this should become resolved with [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]] | ||
* 2021-06-17 - updated to include check for first [[Boarding Loc]] and first [[Service tmp entry]] | * 2021-06-17 - updated to include check for first [[Boarding Loc]] and first [[Service tmp entry]] | ||
* 2021-01-28 - wasn't checking for [[DOB]], fixed | * 2021-01-28 - wasn't checking for [[DOB]], fixed | ||