Query send check centralized is owner

Data Integrity Checks
Summary:	* Run automatically at the beginning of sending to ensure that no records that are already vetted or sent can be re-sent
Related:	[[D_ID, Pat_ID, Service/Location field]]
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:	Query send_check_centralized_is_owner
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-01-01
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 "D_ID]], Pat_ID, [[Service/Location field" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Approximate implementation date

Log

2019-03-13 - tweaked query to only use relevant fields of O_L_Log, since it turns out that Access has a maximum record set size of 1GB; hopefully this will fix System resource exceeded 2019-03 Around this time the STB_MedB laptop had >200 records on it and was getting System resource exceeded errors. The errors were happening when this query was run.