REDCap: Randomization Table Corrections

Modifying a Randomization Table in Production

Randomization tables should be developed and tested while a project is in Development status.  All users should be encouraged to test and confirm their table allocations prior to their project being moved into Production. 

In the case that a mistake was made and a project needs to upload an entirely new randomization table to their project, the steps below can be used to delete and create a new randomization table in a Production project. 

NOTE:  Make a backup copy of the project's data and XML file prior to modifying the Randomization set up.


Removing Current Randomization Table

Navigate to Set up Randomization Module in Project Settings.  Under this tab, you will see the options under STEP 1 for general randomization settings.  

  1. Document any stratification currently set up and which field/event it is set under.
  2. Document any randomization by group/site.
  3. Make a note of which field is currently being used to randomize records in the project.

Erasing the randomization model will delete all settings related to randomization from the project.  This includes the previous randomization table in the project.  If you would like to keep an copy of the original randomization table, you will need to download the current randomization table from Randomization STEP 3 before erasing the randomization model. 

Once these items are documented, select "Erase randomization model"

Erase Old Randomization
Randomization Configuration Options


Adding New Randomization Field

If a project wishes to keep the values from their old randomization set up, then a new field must be created to take the place of the initial field. 

Create New Randomization Field
Copy of Randomization Field to New Field


This copied field should match the options of the first randomization OR can be changed to match the new randomization table if options need to change.  The first randomization field can be set to @HIDDEN or @READONLY to prevent former values from being altered.  Adding branching logic to check if the original randomization field has a value can help show the randomization for old records that were randomized under the old randomization, but hide the field from new records that will use the new randomization. 


Adding New Randomization Table

After adding a new field to use for Randomization, navigate back to the Randomization Set Up and re-enter the values from the original Randomization.  For Part C, instead of using the original randomization field you will need to assign the new field as the randomization variable.  Once this is complete, select "Save randomization model" and navigate to STEP 3. 

Re-enter Randomization
Re-enter and Save New Randomization Settings

Find the new randomization allocation table needed for the project.  Make sure that the header for the first column (randomization field name) matches the new field created). 

In STEP 3, select "Upload more allocations (Administrators only)".  The current allocation table will be empty from removing the Randomization settings earlier, adding in new allocations will now start the new table at the beginning.  

Upload New Allocations
Upload New Allocations

If the upload was successful you will be able to confirm the changes and see a green check mark indicating the table was uploaded. 

Upload new table complete
Upload New Table Complete Status

Navigate to the Randomization Dashboard and you should see a fresh randomization table with no allocations currently being used that will be the distribution of the current randomization schema. 

Randomization Dashboard
Randomization Dashboard of New Allocations




KeywordsREDCap, randomization, table, restructure, reset, redo, edit, production, correction, modify   Doc ID122205
OwnerAmanda Y.GroupSMPH Research Informatics
Created2022-10-31 12:02:14Updated2024-03-20 09:59:05
SitesSMPH Research Informatics , SMPH Research Informatics TEST
Feedback  0   0