Add Open Data Numerical Field
An Open Data Numerical Field is one of the building blocks you might build in Master Data when preparing to set up Monitoring Programmes. Open Data Numerical Fields are entered by using numerical values only in the Monitoring and Receiving Modules.
The Numerical Field is commonly used for inputting numbers into the Monitoring Record, such as Batch Numbers or UPC Codes.
The 'Open Data - Numerical Field' cannot be used in the Receiving module.
Adding an 'Open Data - Numerical Field'
To add an 'Open Data - Numerical Field', navigate to the Tests module via 'Master Data>Tests', then click on 'Add Open Data>Numerical Field'.
Image: Adding an 'Open Data - Numerical Field'
Image: Blank 'Open Data - Numerical Field'
Enter 'Open Data - Numerical Field' Details
Image: Completed 'Open Data - Numerical Field' Details
1. Name: Enter the name of the Test. This name will appear in the 'Open Data' folder when building Monitoring Programmes.
2. Folder: It is good practice to organise your Numerical Fields into folders to help you keep them in logical, tidy groups. This will help you to source your Numerical Fields more easily when you are building your Programmes. Adding Numerical Fields to folders with clear naming conventions will help you speed up your Programme Building Process.
3. Description: This is an open text field. Provide a brief description of the Numerical Field - this will appear in the Monitoring Programmes when building them, helping you identify your Numerical Fields more easily if some are built with similar names. The description will also appear in the Monitoring Records when you hover over the name of the Test.
Image: 'Numerical Field' Descriptions as they Appear in the Monitoring Programme Building Stage
Image: 'Numerical Field' Descriptions as they Appear in the Monitoring Records After Hovering on the Test Name
It may be difficult to tell the different Open Data fields apart when they are being built, or when you are selecting them in the Monitoring or Receiving Programmes. There are three main ways to distinguish the Open Data fields so that they are more easily distinguishable in the system.
Option 1: Include an indicator in the Name of the Open Data. This would be useful in the case when selecting Open Data in Monitoring or Receiving Programmes, but they may look a little heavy in Records, especially if a large amount of Open Data and Tests are used within the Programmes.
Option 2: Ensure you create a strong Folder structure which will be displayed in the Open Data tab in the main Tests module page, and will allow you to search for your Open Data by navigating the folder structures when building your Programmes.
Option 3: Add the type of Open Data Field in the Description of the Open Data Fields. This will not affect your naming conventions and your folder structure, and you will still be able to differentiate between them when building Programmes, as the descriptions will appear when the Open Data is selected in a Programme.
Image: Open Data Tab in Main Tests Module Page
4. Procedures: If a related Procedure is required, you can select the supporting Document previously uploaded to Master Data here. When completing a Record, you will be able to click on the name of the Test (which will appear as a blue clickable hyperlink) and view or download the Document while in the Record.
To select a Procedure, click on the dropdown arrow and your Documents folder will be displayed. From there, navigate to your required folder, select your file until a grey background appears, and click 'Select' to add it to the Test. To remove a procedure, click the 'X' button.
Image: Select a Procedure Document
Image: Blank 'Open Data - Numerical Field' in a Record, with an Attached Procedure - Blue Hyperlink
5. Decimal Places: If applicable, select the decimal places for the numbers that will be added to the Test in the Monitoring Record. For example, selecting 2 decimal places will allow you to enter figures such as 100.56, 98.65, etc.
To select the required number of decimal places, click on the dropdown arrow and choose one of the numbers (from 0 to 5).
Image: Decimal Places Dropdown Options
6. Save: Click the 'Save' button to save the Open Data Numerical Field and move it to the 'Open Data' column in the main Tests module page.
7. Cancel: Click the 'Cancel' button to cancel your progress and return to the main Tests module page. If you choose to cancel, you will lose your progress without the possibility of recovery.
Completing 'Open Data - Numerical Field' in a Record
To complete an 'Open Data - Numerical Field', click into the box under the Test name and enter your numerical values. Depending on the decimal places selected, the figures may be rounded up or down to the next logical number.
Image: Completed 'Open Data- Numerical Field' with Two Decimal Places
For this example, if you enter a value between 10.250 and 10.254, the value displayed will be 10.25. If you enter a value between 10.255 and 10.259 the value displayed will be 10.26. The same rounding up and rounding down logic will be used for calculations for all of the decimal point selections.








