Overview #
A variety of case migration selection options are available. These may be helpful for testing different case subsets, or re-migrating specific cases.
For most migration needs, the Case Status feature, shown below, will be used to migrate cases.
Case Numbers #
The Case Numbers filter is designed to allow a variety of case selections for testing. The goal is to pull all cases, a select range or list of cases, or even a randomized set.
IMPORTANT:
Prior to switching to toxiCALL® 5, we require all clients to perform migration testing to ensure your data is migrated as expected. Our support team will work with you on your migrated data. We are very interested in feedback of SPIList accounts and data captured in a non-confirming way. E.g. Date of Birth (DOB), Medical Record Number (EMR/MRN), etc. Our goal is to try and update the migration routine to allow the proper migration of these data.
All Cases #
Migrate all cases without any filters on case numbers. All case numbers will be off by default.
Range #
Migrate a specific range of case numbers.
List #
Enter a comma separated list of case numbers to be migrated from the list of case numbers.
X Random #
Migrate a random number of cases across the entire source database. This allows for random sampling across all cases for testing.
X Random Per Month #
Migrate a random number of cases across all available months. This allows for random sampling across each time period for a good distribution of case samples during testing.
Date Range #
The Date Range filter allows you to choose a specific timeframe from which to migrate cases. This can be helpful during testing or migrating data in smaller subsections.
By default, the entire date range is selected.
Case Status #
Choose which case status types are migrated using the Case Status filter. Generally we recommend migrating All Case Status types.
First, enable the Case Status Option. Then, choose a start date for the Closed status. In this example, we entered January 1, 2023. This will ensure that all non-closed cases are migrated, but only closed cases from January 1, 2023, and newer will be migrated.
Center Code #
If your database contains data from multiple poison centers, you can limit which poison center data you wish to migrate using the Center Code filter.
Year Code #
The Year Code filter allows you to choose specific years to migrate.
