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. 

• 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.