Managing Lab Locations, Normal Ranges, & Reports Mass Updates

In the Lab Settings section of the Labs tab, you can view approved and pending Lab Locations, add new Lab Locations, import Lab Locations, add Normal Ranges, and Import Normal Ranges. You can also run lab-specific jobs.

Viewing Lab Locations & Normal Ranges

In the Lab Locations & Normal Ranges tab, Vault displays tables of all approved and pending Lab Locations (statuses split into two subtabs) with Lab IDs, Status, and whether the location is In Use. The Pending Locations subtab label includes the number of Lab Locations that are in the Pending status and lists Lab Locations that aren’t approved yet.

To view the Normal Ranges associated with a Lab Location, click the Lab ID in the location table. From the Normal Ranges page, you can add new Normal Ranges, edit existing Normal Ranges, export the ranges for that locations, or view the audit history for the location.

To add or remove columns in your Lab Locations and Normal Ranges tables:

1. Navigate to Labs > Lab Locations & Normal Ranges.
2. If you want to edit columns in the Normal Ranges table, click the Lab ID of a Location to open the Normal Ranges table for that location. To edit columns for the Lab Locations table, remain on this page.
3. From the Actions menu, select Edit Columns.
4. Use the shuttle menu to move columns from Available Columns to Selected Columns. The columns under Selected Columns display in the table.
5. Click Save.

Lab Locations

You can add Lab Locations one-by-one, or you can import Lab Locations in bulk using a CSV file.

Add Individual Lab Locations

To add a new Lab location:

1. Navigate to Labs > Lab Locations & Normal Ranges.
2. Click + New Lab.
3. Fill all required and relevant fields.
   • Initiated By Study: This field shows which Study the Lab Location was initiated for. The dropdown list will only show studies that you have permission to access and that have Labs enabled.
   • Initiated By Site: This field shows which Site initiated the Lab Location. The dropdown list will only show sites that you have permission to access.
4. Click Save.

Select the gear icon next to the Lab ID for more options.

Import Lab Locations

You can import Lab Locations using this template:

  Download the Lab Location Template

To import Lab Locations:

1. Navigate to Lab Tools > Lab Locations & Normal Ranges.
2. Click Import Lab Locations.
3. Drag and drop your completed template to upload, or click in the upload area to browse for the file.
4. Click Import.

Required Columns

The following columns are required in your import file:

Column	Details
Lab ID	Enter the Lab ID(s) associated with your lab location(s).
Lab Name	Enter the name of the lab location.
Lab Address	Enter the address of the lab location.
Country	Enter the country where the lab location is located.

Any columns not mentioned above are not required for import.

Validation Errors

The table below lists possible validation errors and their resolutions:

Error	Explanation	Steps to Resolve
Field is required or field must not be empty	This field is required.	Provide a value for this field.

Pending Lab Locations

If a Site enters a Lab Location in the Data Entry tab, that location will be given a Pending status, meaning that it must be approved by a data manager or lab managers. Lab Locations that are entered in the Labs module are automatically approved.

Lab Locations

Normal Ranges

You can manually add, upload, or edit local lab Normal Ranges for analytes collected in EDC in Lab Settings > Lab Locations & Normal Ranges. Normal Ranges only need to be entered once and can be leveraged elsewhere in your study once entered. When testing methods are being changed, you can update effective Begin dates in this section. You can configure queries to automatically generate for abnormal ranges in the Study General Settings tab of the Labs module.

You can import Normal Ranges using this template:

  Download the Lab Normal Ranges Template

To import Normal Ranges:

1. Navigate to Lab Tools > Lab Locations & Normal Ranges.
2. Click Import Normal Ranges.
3. Drag and drop your completed template to upload, or click in the upload area to browse for the file.
4. Click Import.

Required Columns

The following columns are required in your import file:

Column	Details
Lab ID	Enter the Lab ID(s) associated with your normals.
Analyte	Enter the Analyte(s) associated with your normals.
Age Unit	Enter the Age Unit. This column is only required if an age was entered.
Lower Normal	Enter the Normal Range low. This column is required when adding measurement units or a number data type.
Upper Normal	Enter the Normal Range high. This column is required when adding measurement units or a number data type.
Measurement Unit	Enter the measurement unit associated with your normals. This column is required when an analyte is associated with a measurement unit date type. The data in this column must match the Unit Name of the associated measurement unit.
Codelist Normal	Enter the Codelist Normal. This column is required when an analyte is associated with a Codelist data type. The data in this column must match the codelist name of the associated codelist.
Text Normal	Enter the Text Normal. This column is required when an analyte is associated with a Text data type.
Effective Begin Date	Enter the effective start date of your normals. (MM/DD/YYYY hh:mm AM/PM Timezone) Note that the Effective End Date must be after the Effective Begin Date. You cannot use the same date for both.

Any columns not mentioned above are not required for import.

Validation Errors

The table below lists possible validation errors and their solutions:

Error	Explanation	Steps to Resolve
Field is required or field must not be empty.	This field is required.	Provide a value for this field.
Lower Normal can't be greater than Upper Normal.	The lower normal must have a lower number than the upper normal.	Enter a lower number in the lower range and a higher number in the upper range.
Upper Range must be greater than Lower Range.	The lower range must have a lower number than the upper range.	Enter a lower number in the lower range and a higher number in the upper range.
Age Unit is required if Age is defined.	An Age Unit is required if a number is entered into the lower or upper age.	Enter an Age Unit.
Age Ranges must not overlap for the same Effective Date.	There are conflicting normal ranges for the Age Range and Effective Date fields.	Update the Effective Date or change the Age Range.
A record already exists with those parameters.	The analyte normal ranges and related parameters already exist.	Change the normal range parameters.
Cannot import Normal Range that references an archived analyte.	The normal range you’re trying to import references an analyte that has been archived.	Import a normal range that doesn’t reference an archived analyte.

View an example template of a completed Lab Normal Import file below:

  Download a completed example template

Adding Normal Ranges

You can manually add Normal Ranges in addition to or instead of uploading them via the template above.

To manually add Normal Ranges:

1. Navigate to Labs > Lab Locations & Normal Ranges.
2. From the Lab Locations table, click the Lab ID for which you’d like to upload or edit ranges.
3. To add a new range, click + New Normal Range.
4. From this point, you can begin filling in the table with your data. You can edit which columns you’d like to include by clicking the gear icon in the right-hand corner of the table and selecting Edit Columns. When finished entering data, click Done to save your changes.

Note that the Test Code field is an open text field where you can enter related blood work.

Deactivate a Normal Range

Vault doesn’t allow you to delete Normal Ranges for existing Lab Locations. However, you can change the Status of a Normal Range to _Inactive.

To deactivate a Normal Range:

1. Navigate to Labs > Lab Locations & Normal Ranges.
2. Locate the Lab Location containing the Normal Range that you want to deactivate.
3. Click the Lab ID to open Normal Ranges for that _Lab Location.
4. Click Edit Normal Ranges.
5. Locate the row for the Normal Range you want to deactivate.
6. In that row, select Inactive for Status.
7. Click Done.

If a Normal Range is missing the Measurement Unit, Vault automatically assigns that range the Incomplete status.

Approving Normal Ranges

If approval is enabled in System General Settings > General Settings, Normal Ranges must have the Active status to be used in a Lab form. Refer to the table below for more information about Normal Range statuses.

Status	Description
Pending Approval	Normal range is waiting for approval. Normals won't load in the eCRF until they've been approved.
Incomplete	Normal range is missing units.
Active	Normal range is approved.

Normal Ranges

Last Updated: 23R1

This video provides instructions on how load Normal Ranges in the Labs Module.

Reports Mass Updates

You can perform jobs specific to the Labs module from Labs > Reports Mass Updates. For more information on the types of jobs available in this tab, refer to the table below.

To run a job:

1. Navigate to Labs > Reports Mass Updates.
2. Click New Job.

3. Select a Type for the job.

4. Select the Study that you want to run the job in.
5. Click Run Job. Vault begins the job. When finished, Vault sends you an email notification with a link to download the job log and any relevant output files.

Job	Description
Preview New/Merge Lab Locations	This job allows you to preview the updates that will go into effect if the Update New/Merge Lab Locations job is run.
Update New/Merge Lab Locations	This job updates any Lab forms that reference a merged Lab Location to reference the approved Lab Location. Lab normals will also be updated to the normals in the approved Lab Location. Note that Locked and Frozen items will not be updated. You should run this job after merging Lab Locations into an approved Lab Location.
Lab Location Not Found	This job shows a listing of every time a Site has marked a Lab Location as Lab Location Not Found.
Preview Outdated Lab Normals	This job allows you to preview the updates that will go into effect if the Update Outdated Lab Normals job is run.
Update Outdated Lab Normals	This job updates a study's outdated normal values. Errors will appear for any unsuccessful updates. The Item Audit trail will show updates of Lab Normals. Note that Frozen and Locked Items will not be updated. You should run this job after editing Lab Normals for a Lab Location that is in use.
Site Override Lab Normals Report	This report gives Data Managers the opportunity to review Override normals entered by Sites and update the Normal Ranges library if necessary.
Preview Translated Values	This job allows you to preview the updates that will go into effect if the Updated Translated Values job is run. The output of this job includes a row if the Value Translated is different from the Expected Value Translated or if the Lab Unit Value Translated is different from the Expected Lab Unit Value Translated. This job only applies to Labs Forms in studies that have Global Labs enabled.
Update Translated Values	This job updates the saved Value Translated and Lab Unit Value Translated values on items according to the updated unit conversions and default units that are saved in the Labs module. This job only applies to Labs Forms in studies that have Global Labs enabled.