Query check CCI TISS NrDays LT LOS: Difference between revisions

TOstryzniuk (talk | contribs)
mNo edit summary
No edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = There are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] and [[Dispo DtTm]]
|DIC_summary=There are more TISS Item [[Px_Date]]s than there are days between the first [[Service tmp entry]] and [[Dispo DtTm]]
| DIC_related_concepts = CCI Picklist; Service tmp entry; Dispo DtTm
|DIC_related_concepts=CCI Picklist; Service tmp entry; Dispo DtTm
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.accdb
|DIC_coding=query ''check_CCI_TISS_NrDays_LT_LOS''
| DIC_coding = query ''check_CCI_TISS_NrDays_LT_LOS''
|DIC_implementation_date=2021-01-21
| DIC_status = implemented
|DIC_status=implemented
| DIC_implementation_date =  
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
This check can only be done on '''complete''' records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing.
This check can only be done on '''complete''' records because collectors may not have had a chance to be up-to-date on incomplete records, so TISS days might be missing.