Permissions: Users must have RBM, Data Central, and Study Configure privileges to configure a study for RBQM.

RBQM (Risk Based Quality Management) is configured for a study within Data Central Configuration. 

A study must be RBM enabled for RBQM configuration to be available in Data Central Configuration.

Access Data Central Configuration

From a study card on the Data Central landing page, click the red triangle (this displays if the study is not yet configured), or the Configuration icon and select Data Central Configuration.

The Data Central Configuration window for the selected study opens. Click on RBQM in the left navigation to access each configuration item.

Configurations can be copied from another study, imported, or exported. 

Use the RBQM down arrows to expand the Global and Study sections. Upon initial configuration the overview window displays Complete Configuration, however, each section within Global and Study should be configured. 

Global configurations apply to all the RBQM studies within the URL, and the study specific configurations apply to the selected study. 

Important: Any edits, including deletions made at the Global level apply to every study in the URL.

Clicking Global in the left navigation displays the Global configuration overview.

Clicking Study in the left navigation displays the Study configuration overview.

Configure Global Categories

There are a set of standard global categories available by default (Data Quality - Essential Documents - Investigational Product - Issue Management - Safety - Staffing, Facilities and Supplies - Subject Recruitment and Discontinuation). Categories are the first layer in the organization for the indicators.

Categories can be added, edited, or deleted, as appropriate, and are client specific. 

In the left navigation, click Categories under Global.

Add a Global Category

1. Click the Add icon (the plus sign) in the top right corner.
2. Enter the name of the new category in the Name field.
3. Click Save. This adds the category to the global list and will be available to all RBQM studies across the URL.

Edit a Global Category

1. Click on the category Name you want to edit.
2. Edit the Name of the category.
3. Click Save. The updated category displays in the list of Categories.

Delete Global Category(ies)

1. Click in the box at the left of the category(ies) you want to delete.
2. Click the Delete icon (the trashcan) in the top right corner.
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
4. Click Save.

Configure Global Actions

Use Global Actions to configure actions that may be assigned to different indicators at the Study level. A set of default Actions display, however, Actions can be added, edited, deleted, or disabled.

In the left navigation, click Actions under Global.

Add a Global Action

1. Click the Add icon (the plus sign) in the top right corner. A new row is added at the top of the list.
2. Enter the name of the new action in the Name field.
3. Click Save. The new action is added to the end of the list.

Edit a Global Action

1. Click on the Action name you want to edit.
2. Edit the Name of the action.
3. Click Save. The updated action displays in the list of Actions.

Delete Global Action(s)

1. Click in the box at the left of the action(s) you want to delete.
2. Click the Delete icon (the trashcan) in the top right corner.
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
   Global Actions in use cannot be deleted. A warning message displays; click the 'x' to close the message and cancel your actions. 
4. Click Save.

Disable Global Action(s)

Actions marked as disabled are not available in the drop-down when assigning to different indicators at the Study level. Disabled actions stop firing future KRI and QTL issues.

1. Click in the box in the Disabled column of the action(s) you want disabled. To re-enable action(s), uncheck the box(es) in the Disabled column.
2. Click Save.
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).

Configure Global Indicators

Global Indicators identify the Category, Name, and Description of a possible Key Risk Indicator. Indicators are used to determine how risky an activity is; they provide an early signal of increasing risk exposures in the various categories. Global Indicators can be added here and will be available across the URL for all RBQM studies.

In the left navigation, click Indicators under Global.

Add a Global Indicator

1. Click the Add icon (the plus sign) in the top right corner. A new row is added at the top of the list.
2. Select the Category from the Category drop-down.
3. Enter the name of the new indicator in the Name field.
4. Click Save. The new indicator is added to the end of the list.

Edit a Global Indicator

1. Click on the Indicator name you want to edit.
2. Edit the Category, Name, or Description of the Indicator.
3. Click Save. The updated indicator displays in the list of Indicators.

Delete Global Indicator(s)

1. Click in the box at the left of the indicator(s) you want to delete.
2. Click the Delete icon (the trashcan) in the top right corner.
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
   Global Indicators in use cannot be deleted. A warning message displays; click the 'x' to close the message and cancel your actions. 
4. Click Save.

Configure Study QTLs

QTLs, or Quality Tolerance Limits, are used to measure the health of a study. They can be imported from the Global Library or added manually for each study. Configured QTLs can be promoted to the Global Library to be used across studies. For details on using the Global Library for QTLs and KRIs, see the section within this article Use the Global Library to Promote or Import QTLs and KRIs.

In the left navigation, click QTLs under Study. QTLs that have been added display in the list of Tolerance Limits. Columns include Name, Description, Category, and Active. 

Add and Define a Study-Level QTL

1. From the Tolerance Limits list, click the Add icon (the plus sign) in the top right corner. The New QTL window opens, displaying the General window.
   
   
   

   General

2. Enter the name of the QTL in the Name field.
3. Select the Category from the drop-down.
4. Enter the Description. The entered description will display when a user hovers over a QTL gauge.
5. Active or Inactive: By default, QTL is Inactive is selected. Click QTL is Active to activate the QTL so that it will run when new data are refreshed.
6. By default, Show current threshold is selected (the threshold line will be a straight line based on the current threshold). Select Show dynamic threshold for the threshold line to update when a change to the threshold is made. 
   

   
   Study Scoring 
   

7. Click on Study Scoring in the left navigation.
   
8. Enter the Study Query, the SQL statement.
9. Click the Validate button to validate the query. Modify query as needed.
   
   

   Risk Levels / Actions

10. Click on Risk Levels / Actions in the left navigation.
    
    Tolerance Limits
    Set ranges. The Risk Direction up column allows you to enter the values for when the higher the numbers, the higher the risk. The Risk Direction down column allows you to enter the values for when the lower the number, the higher the risk. For example, you are looking for lower scores below the Tolerance Limit that are a concern.
    
11. Enter the Tolerance Limits in the ascending or descending Direction field for Approaching Limit and Tolerance Exceeded. The value in In Limits will be automatically populated based on your entry in Approaching Limit. 
12. Edit checks are in place to identify if overlapping values are entered. When Save is clicked, an error message may display, click the 'x' to close the message and update the values.
13. As values are entered, the Gauge Preview on the right will update so you can see what the configured gauge will look like. Update the Sample Score by using the slider.
    
    

    Study Risk Actions: In Limits / Approaching Limit / Tolerance Exceeded
    Apply actions if a QTL falls within a certain risk level.

14. Click on one of the Tolerance Limits to create a Study Risk Action for that limit.
15. Click the Add icon (the plus sign).
16. Click in the Name field and select the action from the drop-down (as configured in Global Actions).
17. Enter the number of days in the Due in Days field in which this action should be completed once the QTL enters the risk level.
18. Click in the Trigger field and select from the drop-down: Always (i.e. when the score exceeds a threshold a system generated issue will always be generated), When Changed From Previous (i.e. when you want the action to display only when there is a change in the score; the change could be a higher or lower risk), or When Riskier Than Previous (i.e., when you want the action to display only if the score results in a higher risk level).
19. Click in the Assign To field and select from the drop-down: Data Central role Site Monitor (default) or select from the list.
20. Continue adding Study Risk Actions for each Tolerance Limit (In Limits, Approaching Limit, Tolerance Exceeded) as needed.
    
    

    Supporting Data

21. Click on Supporting Data in the left navigation.
    Supporting data can be defined by adding to the Domains section. Domains added as supporting data in configuration are available in the QTL dashboard.
    
    
    
22. Click the Get From Query icon in the Domains area to add a domain from the Study Query (in Study Scoring). If no Study Query is entered, an error message displays. Click the 'x' to close the message.
23. Click the Add Domain icon in the Domains area to add from the drop-down list of available domains. Use the scrollbar to access all domains.
24. Continue adding as needed.
25. Click the Preview Domain icon (the magnifying glass) next to a domain to view the domain listing in the Preview window.
26. To remove a domain, click the Delete icon next to a domain.
    
    

    Save QTL Configuration

27. Click Save at the bottom right. The new QTL is added to the end of the list.
    
    

    Important: If items are not configured correctly, an error message will display with details. Read the message carefully, click the 'x' to close the message and update the appropriate item(s).

Edit a Study-Level QTL

1. Click in the row of the QTL you want to edit.
2. Click the Edit icon. The Edit QTL window opens.
3. Make changes as needed.
4. Click Save. 

Delete a Study-Level QTL

1. Click in the row of the QTL you want to delete.
2. Click the Delete icon (the trashcan). 
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
4. Click Save. 

Note: QTLs used as part of a Risk Action Plan in RACT cannot be deleted. A message displays stating it cannot be deleted. 

Configure Study KRIs

In the left navigation, click KRIs under Study. KRIs that have been added display in the list of Indicators. Columns include Name, Description, Category, Country (is checked if a Countries query exists), Site (is checked if a Sites query exists), Weight, Uses CSM (is checked if a CSM calculation is applied), Is Active, and Global (is checked if the KRI was an assigned Global KRI). 

When first accessing Study > KRIs, the Indicators list is empty. Global Indicators can be assigned to your study using the pre-defined Category, Name, and Description; they can be imported from the Global Library or added manually for each study. Configured KRIs can be promoted to the Global Library to be used across studies. For details on using the Global Library for QTLs and KRIs, see the section within this article Use the Global Library to Promote or Import QTLs and KRIs.

Add and Define a Study-Level Indicator

When adding an indicator at the study level, the indicator is available only for the selected study, and does not display at the global level.

1. From the Indicators list, click the Add icon (the plus sign) in the top right corner. The New Indicator window opens.
   
   General
2. Enter the name of the KRI in the Name field.
3. Select the Category from the drop-down.
4. Enter the Description.
5. Update the Active or Inactive radio button. By default KRI is Inactive is selected. Click KRI is Active to activate the indicator so that it will run when new data are refreshed.
6. Update the Critical Vs. Not Critical radio button. By default, KRI is Not Critical is selected. Click KRI is Critical to mark the KRI as critical. If a site exceeds the threshold for a KRI defined as critical, the entire site will be flagged as yellow / red, regardless of the overall site score.
7. Update the Weight if needed (1 is default).
   
   Scoring
   Optionally, use CSM or Z Score for scoring.
   
8. Click on Site Scoring in the left navigation.
   
9. Optionally, check Use CSM (Central Statistical Monitoring). CSM is a method to identify sites statistically different from the 'central' site. (In RBQM, the 'central' site is defined as an aggregate of all sites.) If checked, additional fields display.
   
   
   1. Select the CSM Type from the drop-down: Continuous, Discrete, or Proportion.
   2. Select the CSM Alpha Value from the drop-down: .1, 0.05, 0.01, 0.001, 0.0001, 0.00001, or 0.000001.
   3. Optionally, add the CSM Measurement Label.
   4. Enter the Sites Query.
   5. Click the Validate button to validate the query. Modify query as needed.
   6. Continue to Risk Levels, Step 13.
10. Optionally, check the is Z Score box, if there is a Z Score calculation required for this indicator.
    In order to use a Z-Score for a given Key Risk Indicator (KRI), the KRI should not be categorical, such as a yes / no variable or 1=mild, 2=moderate, 3=severe. Further, the values of the KRI should not be skewed, meaning the majority of the values should not sit at the high end or the low end within a narrow range with data trailing off to the opposite side. As an example, think of a study where few adverse events are found in subjects. If most of the subjects have 0 events, with a handful having anywhere from 1-10 events, this is not ideal for a z-score. Lastly, there should be at least thirty observations associated with the KRI in order to get meaningful results with a Z-Score.
11. Enter the Sites Query, the SQL statement to call the max risk value for each site for the selected indicator. This is a required entry.
12. Click the Validate button to validate the query. A table displays the Site ID, Site Score, and Z-Score (if is Z Score is selected). Modify query as needed. 
    

    
    Site Risk Levels / Actions
    Set ranges. The Risk Direction up column allows you to enter the values for when the higher the numbers, the higher the risk. The Risk Direction down column allows you to enter the values for when the lower the number, the higher the risk. For example, when looking at enrollment numbers, the lower the number, the higher the risk. Or you may have an AE rate that is too high or too low (e.g., there is a good band in between).
    

13. Click on Risk Levels / Actions under Site Scoring in the left navigation.
    
14. Enter the Site Risk Levels in the ascending or descending Direction field for Medium and High. The Low will be automatically populated based on the entry in Medium.
15. Edit checks are in place to identify if overlapping values are entered. When Save is clicked, an error message will display, click the 'x' to close the message and update the values.
16. As values are entered, the Gauge Preview on the right will update so you can see what the configured gauge will look like. Update the Sample Score by using the slider.
    
    Site Risk Actions: Low/ Medium / High
    Apply actions if an indicator falls within a certain risk level.
    
17. Click on one of the Site Risk Actions, i.e., Low, Medium, or High.
18. Click the Add icon (the plus sign).
19. Click in the Name field and select the action from the drop-down (as configured in Global Actions).
20. Enter the number of days in the Due in Days field in which this action should be completed once the indicator enters the risk level.
21. Click in the Trigger field and select from the drop-down: Always (i.e. when the score exceeds a threshold a system generated issue will always be generated), When Changed From Previous (i.e. when you want the action to display only when there is a change in the score; the change could a higher or lower risk), or When Riskier Than Previous (i.e. when you want the action to display only if the score results in a higher risk level).
22. Click in the Assign To field and select from the drop-down: Data Central role Site Monitor (default), or select from the list.
23. Continue adding Site Risk Actions for each Indicator as needed.
    
    Supporting Data
24. Click on Supporting Data under Site Scoring.
    Supporting data can be defined by adding to the Domains section. Domains added as supporting data in configuration are available in the KRI dashboard.
    
    
    
25. Click the Get From Query icon in the Domains area to add a domain from the Sites Query (in Site Scoring). If no Sites Query is entered, an error message displays. Click the 'x' to close the message.
26. Click the Add Domain icon in the Domains area to add from the drop-down list of available domains. Use the scrollbar to access all domains.
27. Continue adding as needed.
28. Click the Preview Domain icon (the magnifying glass) next to a domain to view the domain listing in the Preview window.
29. To remove a domain, click the Delete icon next to a domain.
    
    
    
30. Click on Country Scoring in the left navigation.
    
31. Enter the Countries Query, the SQL statement to call the max risk value for each country for the selected indicator. This is a required entry.
32. Click the Validate button to validate the query. Modify query as needed.
    
    Country Risk Levels / Actions
    Set ranges. The Risk Direction up column allows you to enter the values for when the higher the numbers, the higher the risk. The Risk Direction down column allows you to enter the values for when the lower the number, the higher the risk. For example, when looking at enrollment numbers, the lower the number, the higher the risk. Or you may have an AE rate that is too high or too low (e.g., there is a good band in between).
    
33. Click on Risk Levels / Actions under Country Scoring in the left navigation.
    
34. Enter the Country Risk Levels in the ascending or descending Direction field for Medium and High. The Low will be automatically populated based on the entry in Medium.
35. Edit checks are in place to identify if overlapping values are entered. When Save is clicked, an error message will display, click the 'x' to close the message and update the values.
36. As values are entered, the Gauge Preview on the right will update so you can see what the configured gauge will look like. Update the Sample Score by using the slider.
    
    Country Risk Actions: Low/ Medium / High
    Apply actions if an indicator falls within a certain risk level.
    
37. Click on one of the Country Risk Actions, i.e., Low, Medium, or High.
38. Click the Add icon (the plus sign).
39. Click in the Name field and select the action from the drop-down (as configured in Global Actions).
40. Enter the number of days in the Due in Days field in which this action should be completed once the indicator enters the risk level.
41. Click in the Trigger field and select from the drop-down: Always, When Changed From Previous (i.e. when you want the action to display only when there is a change in the score; the change could a higher or lower risk), or When Riskier Than Previous (i.e. when you want the action to display only if the score results in a higher risk level).
42. Click in the Assign To field and select from the drop-down: Data Central role Site Monitor (default), or select from the list.
43. Continue adding Country Risk Actions for each Indicator as needed.
    
    Supporting Data
44. Click on Supporting Data under Country Scoring.
    Supporting data can be defined by adding to the Domains section. Domains added as supporting data in configuration are available in the KRI dashboard.
45. Click the Get From Query icon in the Domains area to add a domain from the Countries Query (in Country Scoring). If no Countries Query is entered, an error message displays. Click the 'x' to close the message.
46. Click the Add Domain icon in the Domains area to add from the drop-down list of available domains. Use the scrollbar to access all domains.
47. Continue adding as needed.
48. Click the Preview Domain icon (the magnifying glass) next to a domain to view the domain listing in the Preview window.
49. To remove a domain, click the Delete icon next to a domain.

    
    Save KRI Configuration

50. Click Save. The new Indicator is added to the end of the list. Notice that Global is not checked. If a global indicator was brought into the study the global column will be checked.

Edit a Study-Level KRI

1. Click in the row of the Indicator you want to edit.
2. Click the Edit icon. The Edit Indicator window opens.
3. Make changes as needed.
4. Click Save. 

Delete a Study-Level KRI

1. Click in the row of the Indicator you want to delete.
2. Click the Delete icon (the trashcan). 
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
4. Click Save. This is just removing the Indicator from this study; it is not deleting a Global Indicator.

Note: KRIs used as part of a Risk Action Plan in RACT cannot be deleted. A message displays stating it cannot be deleted. 

Assign a Global Indicator to the Study

1. From the Indicators list, click the Assign icon in the toolbar. The Assign Indicator window opens. The Global Indicators are grouped by the Global Categories.
2. Check any of the Global Indicators to be assigned to the study.
3. The Indicator displays in the list and Global is checked.

Configure Study Sites

For site level monitoring, the sites table must be loaded; configuration cannot continue until this has taken place. The example below shows Sites as it should be completed.

In the left navigation, click Sites under Study. The SQL Query for Sites window displays.

1. In the empty field, enter the SQL statement that identifies from where the Sites table should be pulled. This statement includes the study, staging area, and then the table name. It must also have the country code for every site in order to enable country functionality with RBQM.
   

   Tip: Notice there is an underscore between the study name and the staging area, and a period between the staging area and the table name. For example: Select SiteName Name,SiteNumber as SiteId, NULL Address , City,State,null as Zip,Country From ALXN1210_aHUS_311_CTOA.[Sites] where sitename is not null
   
   

2. Click the Preview button. The bottom section of the window populates with the Sites table. If this does not display as expected, modify the SQL statement.

3. Click Save when the preview of the Sites table is as expected.

Sites SQL Statement

SQL Portion	Required SQL	Location
Study Name	Schema Prefix	From the ETL tab when study is in Edit mode:
Staging Area	Schema Suffix	Administration > Configuration > Staging Areas (click to edit the staging area):
Table Name	Table Name	At the study level, click on Exporter and select the Staging Area with the table to see the name: Note: To ensure you are seeing the correct name, be sure your My Profile is set to Names.

If the site information is not available from the Operational data, import an .xlsx or .txt file with the site information into elluminate, typically into the Operational staging area. The table should include the Site ID and Location (city, state, zip, country). See below for an example:

Configure Study Actions

Use the Study > Actions to configure study level actions. These pull from the Global Actions. 

In the left navigation, click Actions under Study.

The list of Actions displays in the Low, Medium, and High sections. Actions at the study level can be added and deleted. 

Add a Study-Level Action

1. Click the Add icon (the plus sign) in the top right corner within the section (low, medium, high) where you want to add the action.
2. Click in the Name field and select the action from the drop-down (as configured in Global Actions), or manually enter an Action (it will automatically be entered to Global Actions).
3. Enter the Due in Days field in which this action should be completed once the QTL or KRI enters the risk level.
4. Click in the Trigger field and select from the drop-down: Always, When Changed From Previous (i.e. when you want the action to display only when there is a change in the score; the change could a higher or lower risk), or When Riskier Than Previous (i.e., when you want the action to display only if the score results in a higher risk level).
5. Click Save. 

Note: Actions added at the study level will appear in the global list.

Edit a Study-Level Action 

1. Click on the Action name you want to edit.
2. Edit the Name of the action, Due in Days, and / or Trigger.
3. Click Save. The updated action displays in the list of Actions.

Delete Study-Level Action(s)

1. Click in the box at the left of the action(s) you want to delete.
2. Click the Delete icon (the trashcan) in the top right corner.
3. A confirmation window opens. Click OK (or click Cancel to cancel your action).
4. Click Save.

Use the Global Library to Promote or Import QTLs and KRIs

In addition to creating a study level QTL or KRI (or assigning a Global KRI), it is also possible to utilize the Global Library in elluminate to share configured QTLs and KRIs between studies. The options are to promote a QTL / KRI to the Global Library and import a QTL / KRI from the Global Library. The process is the same for both QTLs and KRIs.

Promote a QTL / KRI

Promoting a QTL or KRI to the Global Library will make it available to other studies in the same URL / environment.

1. From the list of QTLs / KRIs, click on the row to be promoted.
2. Click the Global Library button. The drop-down options are Promote to Global Library and Import From Global Library.
3. Select Promote to Global Library. The Promote to Global Library window opens.
4. Library Title: By default, this is auto-filled with the name of the QTL /KRI.
5. Description: By default, this is auto-filled with the description in the QTL / KRI.
6. Tags: Optionally, enter a comma separated list of tags that can be used to find QTLs / KRIs when importing from the Global Library.
7. Folder: Select the folder where the QTL / KRI will be located. The Home folder is selected by default. Users with the Global Library Configure privilege can also create, modify, or delete folders.
8. Scope: Select the Scope by clicking the down arrows to expand the Therapeutic Areas, Compounds, and Programs sections and checking the box(es) to make your selections. User the scrollbar at the right of each category to see all items listed. The selected Scope defines which studies will have the QTL / KRI available.
9. Click Save.

Import a QTL / KRI from the Global Library

1. From the list of QTLs / KRIs, click the Global Library button. The drop-down options are Promote to Global Library and Import From Global Library.
2. Select Import From Global Library. The Import From Global Library window opens.
3. Enter a New Name.

4. Optionally, use the Filter Library Objects. By default, the filter automatically applies attributes of the current study, so the user sees the most applicable available QTL / KRI objects. The number in the blue badges indicate the number of selected items in each area (TA, Compounds, Programs). Additional filters can be applied, or filters can be removed.

   1. Click on the down arrows to expand the Therapeutic Areas, Compounds, and / or Programs sections. 
   2. Check the items you wish to filter.

   To reset the filter, click Reset.
   The window updates based on your selections. Notice the blue badges update to the number of filtered objects displayed.
   
   

5. Find the QTL / KRI object within the folder structure, or use the Search field to filter the list, to be imported. Use the scrollbar to see all items.
6. Click on the QTL / KRI object to be imported.
7. Click Save.
   
   

   Tip: Once the QTL is imported and available in the list of Tolerance Limits, be sure to update QTL attributes accordingly for the study.