The Lab Range Manager is used to setup lab sites and their corresponding ranges based on the various dependencies that may exist in the study.
It can be found under the Study menu:
Once open, use the form highlighted below to populate the table above it with the various lab sites that will apply across the entire study. Lab sites will be associated with study sites in the next step. There is no limit to the number of lab sites you can create.
Now its time to create the various lab ranges for each lab site by selecting the link highlighted below:
This is where you will map each column from the source file (must be csv format) to the system.
First, add the number of columns that exist in the source file in sequential order. The only rules of inclusion are that the lab name must be the first column, and two of the columns should be effective start and stop dates. It is important to include ALL columns of the source file - even if they will not be used. In such cases, the column type will simply be labeled as "Filler (Ignore)".
After adding the number of rows needed, its time to map each row to a column in the source file.
To do this, select the Edit link on each row, provide a name (does not need to match source file), and select what its function is based on the list of options shown below. At minimum, required items will be:
- Lab Test Name
- Protocol min and max
- Lab Unit Code
Note: Currently the Lab min/max options are not functional in the system. Please use only the Protocol min/max to map the lab ranges.
Notice in the list of options under Column Type, any external variables/lab range stratifications are at the bottom of the list. If you need one that is not listed, create an external variable first.
The images below show both an example source file and how each of the items from the column type apply to each one.
The column names you enter for each item do not need to match the column name in the source file. The order is how the system determines the columns.
Any range dependencies, like the gender and age shown above, must be set as external variables in the study.
Notice the Age is two columns in the source file, but only accounted for in row 3 of the mapping. This is because for any number/value dependencies like age or weight or BMI, for example, the system assumes it must be a range where the low range column is first and the high range column is second.
The gender can use "M" or "F" for Male and Female respectively. The system assumes "B" is for Both, but Both does not need to be an actual choice in the study.
Any columns that need to be skipped in the source file should be set as "Fillers".
The most important items to be sure are mapped are:
- Lab Test Name - Must match the lab names used in the study CRF
- Protocol Min Value
- Protocol Max Value
- Lab Unit Code
All dependencies (e.g. Age, Race, Weight, etc) or the effective start/end dates of the ranges are optional. Currently the Lab min/max values are not functional, but will be coming soon for added capability.
When all items are mapped, select the link on the right side of the page that is highlighted in the image above.
Next, return to the Lab Manager page to import the source file. If the mapping saved correctly, there will be an option to Import File:
Now upload the CSV file and ensure it is read successfully. The table will display on the page if the file is read successfully.
After one lab site is setup with mapping, if all other lab sites follow the same source file format, the mapping can easily be copied to the next site:
Next, read about how to associate the study sites with appropriate lab sites.