Processes around changing a PatientFollow assignment: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 11: | Line 11: | ||
== Process for the collector who will now be collecting the chart number ending == | == Process for the collector who will now be collecting the chart number ending == | ||
* copy the most recent backup of the "donating" [[CCMDB_data.mdb]] (from [[Regional Server]]/data, pick the one without a number) to your desktop | |||
* copy the most recent backup of the "donating" [[CCMDB_data.mdb]] (from [[Regional Server]]/data, pick the one without a number) | |||
* open that file with your usual password | * open that file with your usual password | ||
* delete the records you don't need to copy: | * delete the records you don't need to copy: | ||
| Line 28: | Line 27: | ||
* run that query and delete the profiles that are not in your new number range | * run that query and delete the profiles that are not in your new number range | ||
* re-sort the query and also delete the profiles that have a [[Dispo DtTm]] before today}} | * re-sort the query and also delete the profiles that have a [[Dispo DtTm]] before today}} | ||
* change the [[Pat_ID]]s to be their negative counterpart so they will not conflict with records already in [[CCMDB.accdb]] or in [[Centralized data.mdb]] | |||
** create and run the following query: <code>UPDATE L_Log SET L_Log.Pat_ID = [Pat_ID]*-1;</code> | |||
* copy-paste the remaining records to your home [[CCMDB.accdb]] | * copy-paste the remaining records to your home [[CCMDB.accdb]] | ||
** open your usual [[CCMDB.accdb]] | ** open your usual [[CCMDB.accdb]] | ||
| Line 36: | Line 37: | ||
** open the each table that starts with an "L_" on both laptops and copy-paste their content as well | ** open the each table that starts with an "L_" on both laptops and copy-paste their content as well | ||
* check that all records sent by the original collector are now on your laptop | * check that all records sent by the original collector are now on your laptop | ||
* [[Send]] to test that your [[Pat_ID]]s don't cause problems. | |||
** it could be that a number you just set up is already present in CFE. If so, sending will generate an error "At least one of the patients you are sending already exists in the Centralized_data as a complete patient." In that case change the offending [[Pat_ID]]s. | |||
== Process for [[CCMDB.mdb]] to change assignments == | == Process for [[CCMDB.mdb]] to change assignments == | ||