Function Dispo Chronological()

Data Integrity Checks
Summary:	Checks that the registry times are in a sensible chronological order.
Related:	[[Arrive DtTm, Accept DtTm, Transfer Ready DtTm, Dispo DtTm ]]
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
Coding:	Function Dispo Chronological()
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-05-25
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Arrive DtTm]], Accept DtTm, Transfer Ready DtTm, [[Dispo DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

The check will generate an error if:

• Arrive DtTm has to be before or equal to Accept DtTm
• Arrive DtTm has to be before or equal Transfer Ready DtTm
• Arrive DtTm has to be before Dispo DtTm
• Transfer Ready DtTm has to be before Dispo DtTm
• Dispo DtTm has to be before Now() / today

No checks on Visit Admit DtTm field since taken direct from EPR, so it is what it is.

Transfer time rule

Template:Discussion Will want to reconcile Transfer time rule

Related checks

• Check Function Panelling admit transfer same