"Delete Sent Patients" button

The "Delete Sent Patients" button on the Main Form (CCMDB.accdb) deletes patient records that have the Record field set to "Sent".

When patients are sent the RecordStatus field is set to "Sent". This allows keeping patients on file until it is clear that the sent was successful, while not getting sent patients mixed up with ones ready to send in the new round and have the RecordStatus field set to "complete".

Logical delete

The button implements a partial, logical delete (i.e. parts of the record are retained but hidden instead of deleted). See RecordStatus_field#deleted for more info.

A logical delete is what we would want for records that were entered and completed and sent, because this would flag them as already dealt with, e.g. in comparison to Cognos.

If a record is deleted by clicking a line in Patient List and then delete, or by using the ♻️ button, then the record will actually be removed from the database rather than be logically deleted. Data collectors should make sure they use the right method to delete to have the expected outcome.

Logical vs actual deletes don't really affect the data for the main office, so all of this is relatively low priority/low risk.

usage

At some point we polled collectors about their use of this: Survey about deleting files after sending