📊
ACUITY Training Documentation
  • ACUITY
    • Introduction
    • Background
    • System Components
    • Why is it useful?
    • Where can you use it?
    • User group
  • Granting access
    • VA Security Overview
    • User access
      • Adding new users
      • User roles and access
      • Granting access to drug programmes and datasets
      • Controlling views in VA HUB
        • Views available for REACT Packages
  • Data Loading
    • Data Loading Overview
      • ADMIN UI overview
        • ADMIN UI user guide
      • General overview
  • Creating a study
    • Configuring a drug programme
    • Configuring a dataset
  • Creating a dataset
    • Mapping mandatory data files
    • Loading mandatory data files
    • Reviewing data load success in ADMIN UI
      • Checking mandatory data load
      • Access to data load report
      • Data load statuses
      • Data load error classifications
      • Data load reports
    • Reviewing data quality in VA HUB
  • Data Loading Exercise
  • Loading Specific Data Types
    • Adverse Events
      • Adverse Events data
      • Mandatory data mappings
      • Mandatory data load
      • Reviewing mandatory data load in ADMIN UI
      • Reviewing mandatory data quality in VA HUB
      • Non-mandatory data mappings
      • Non-mandatory data load & reviewing load success in ADMIN UI
      • Reviewing non-mandatory data quality in VA HUB
      • Adverse events loading exercise
    • Labs
      • Labs data
      • Mapping Labs data
      • Loading Labs data and reviewing success in ADMIN UI
      • Reviewing Labs data quality in VA HUB
      • Labs loading exercise
    • Dosing & Exposure (PK)
      • PK data
      • PK concentration data
      • Specimen collection data
      • Stacked PK results data
      • Reviewing PK data quality in VA HUB
      • Dosing & Exposure (PK) loading exercise
    • Tumour Response (RECIST)
      • Tumour response data
      • Recist target lesion assessments (recist1) data
      • Recist non-target lesion assessments (recist1) data
      • Recist assessment summarised (recist2)
      • Recist data loading and review in ADMIN UI
      • Recist 1 & 2 data mapping, loading and reviewing
      • Reviewing tumour response (RECIST) data quality in VA HUB
      • Tumour Response (RECIST) loading exercise
        • Recist 1 and Recist 2 loading exercise
Powered by GitBook
On this page
  • 1. Source data file requirement
  • 2. Minimum data required to load study data
  • 3. Steps to map and load data
  • 4. Reviewing data load success in ADMIN UI
  • 5. Reviewing data quality in VA HUB
  1. Data Loading
  2. Data Loading Overview

General overview

This general overview introduces the requirements and steps involved in loading specific datasets to ADMIN UI.

PreviousADMIN UI user guideNextCreating a study

Last updated 3 years ago

Prior to loading data into ADMIN UI, a drug programme and dataset need to be configured for the particular study as described in the ADMIN UI overview section (see sections: configuring a drug programme and configuring a dataset for details).

The overview describes:

  1. Source data file requirement

  2. Minimum data required to load study data - mandatory patient information

  3. Steps to map and load data

  4. Reviewing data load success in ADMIN UI

  5. Reviewing data quality in VA HUB

1. Source data file requirement

ADMIN UI supports CSV and SAS data file formats

2. Minimum data required to load study data

Mandatory patient information is required as a minimum to map and load data to be visualised in the visualisation component of REACT, VA HUB. The mandatory patient information consists of demography, patient visit schedule and dose information, these 3 mandatory files must be mapped and loaded in ADMIN UI first to then allow other data types to be loaded.

3. Steps to map and load data

Clinical study set up menu - navigating to where to map data

TRAINING VIDEO: Learn where to map data in ADMIN UI

Create mappings to source data

This training material introduces the first step in accessing the mapping tables available for the data types which can be loaded into REACT and describes the data mappings summary table for a dataset. The summary table shows a list of all the specific data types which have been mapped and loaded for the specific dataset.

TRAINING VIDEO: This training video describes the data mappings summary table

New data mappings

TRAINING VIDEO: Here you will learn how to access the specific mappings table for which you want to start mapping a source data file

Mapping a specific data type

Data to be loaded into ADMIN UI needs to be mapped to the specific mapping table for that data type. Each field in the mapping table needs to be mapped to the specific column in the specific source data file.

A specific mapping table contains mandatory and non-mandatory fields to map against the source data. Mandatory fields must be mapped to create the basic visualisation in VA HUB.

There are also rules known as ‘Aggregation Functions’ which may need to be set up and ‘Decoding’ files may be required if the source data file has been coded.

TRAINING VIDEO: In this training video you will learn more about a specific mapping table.

Aggregation Functions

These are rules that may be required to be set up in a specific data type mapping table

Decoding Files

If a source data file contains any coding values in any fields, then a decoding file is required to be mapped and loaded into ADMIN UI. This allows the data type file to be decoded so that the visualisations in REACT presented correctly and are meaningful.

TRAINING VIDEO: This training video gives information on when a decoding file may be required

Loading data

Once your mapping file has been created and saved successfully the data will need to be loaded. This is done by selecting review the dataset setup in the clinical study set up menu and following the instructions presented.

TRAINING VIDEO: This video shows where and how to load data

4. Reviewing data load success in ADMIN UI

The data load success can be accessed to determine if your data has loaded successfully through the data load report.

This can be accessed by clicking on the view data load report in the clinical study datasets section on the ADMIN UI homepage.

There are four data load statuses completed, completed with warnings, no changes or failed.

5. Reviewing data quality in VA HUB

When data has been loaded and data load checked in ADMIN UI it is useful to check the visualisation in VA HUB to ensure the data is represented correctly.

Before a data loader can perform this step of the process access permissions to either the drug programme or the specific dataset they are loading will need to be granted to VA HUB.

When studies and datasets have been created and loaded into ADMIN UI users need to be granted access permissions before they can access VA HUB to visualise the data, see section for details.

Granting Access
Create Mappings to Source Data
Clinical Study Set Up Menu
New Data Mappings
LogoACUITY_docs/Example source data file.csv at main · digital-ECMT/ACUITY_docsGitHub
Example Source Data File
Mapping a Specific Data Type
LogoACUITY_docs/Aggregation Functions_v1.0.docx at main · digital-ECMT/ACUITY_docsGitHub
Aggregation Functions Table
Loading Data
Decoding File Requirement