Query check CCI TISS NrDays GT LOS: Difference between revisions

Revision as of 23:06, 20 January 2021 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,377 edits Created page with "{{Data Integrity Check \| DIC_summary = There has to be a TISS entry in CCI Picklist with a Px_Date for each date between Accept DtTm and Dispo DtTm \| DIC_relat..."		Revision as of 23:11, 20 January 2021 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,377 edits mNo edit summary Newer edit →
Line 12:		Line 12:
	Will replace [[Query TISS Errors missing days]]; [[Query TISS Errors NrTISSDays NE LOS]]		Will replace [[Query TISS Errors missing days]]; [[Query TISS Errors NrTISSDays NE LOS]]

			Likely implementation: Count the datevalue(px_dates) for the Pat_ID. There have to be at least as many PX dates as there are days between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range.