One of the challenges of maintaining standard libraries in Rave Architect is that it is not possible to add any kind of notes or extended metadata on library objects. For example, a standard form might have the following information associated with it:
- A unique version number
- A description of the form and its intended usage
- Copyright holder and licensing information (e.g. for copyrighted scales)
- SDTM domain associated with the Form
- Rules regarding changes which are allowed to be made to the Form and still be standards compliant
Since Architect can't store this information it has to be maintained in some separate system. That might be a Metadata Repository (MDR), a set of modified Architect Loader Spreadsheets or in Word documents. However it is managed or presented, that metadata isn't available in Rave Architect where the study builder is doing their work.
So how does TrialGrid help?
Additional Properties for Forms and Fields
First of all, TrialGrid allows you to add additional metadata properties to Forms and to Fields.
Here we add a property "Field Set" to all fields:
And we do the same for the other properties we want:
- SDTM identifier for fields
- Instructions, Copyright, Version and SDTM Domain for Forms
Note that Version and SDTM Domain properties for Forms and Field Set properties for Field are marked as "show in lists". This tells the system to include this value in the Field and Form lists respectively.
Now that we have added these additional metadata properties we can now update these in our Form designer:
Now our Form listing contains the Version and SDTM Domain for that form:
We can also complete some property settings for Fields:
Note that for the Collection date we have entered a field set of COLLECTION_PLUS_AGE. In this form we should either be using COLLECTION_DATE and AGE fields or the Date of Birth Field. Later we'll use this custom property to display different sets of fields in different colors in our annotates.
Exporting and Importing Custom Properties
So far we've added custom properties to our Forms and Fields. This provides useful additional information to Study Builders inside the TrialGrid Form Editor. That's great if you're only using TrialGrid to manage your standards and to build studies - what if you want to load those custom properties into TrialGrid from an MDR export or want to feed the information captured in TrialGrid to other downstream processes?
TrialGrid provides this data as part of the Architect Loader Spreadsheet and can import and export this data:
It's simply added as an extra sheet in the ALS which Rave Architect will ignore.
Including Custom Properties in Annotate output
Part of the reason we add additional metadata to Forms and to Fields is so that we can communicate this additional information to other team members who may not be study builders. Including this metadata in an annotate is one good example, so lets do that.
Annotates are a new feature of TrialGrid, they allow you to define a template which can be used to generate a Microsoft Word document. We start with a simple annotate that just shows the basics about our Demographics form:
So far it contains none of the additional metadata which we just added. We'll need to edit the annotate template to do that. At the moment only TrialGrid employees can modify templates but I'm showing how it is done here because we expect that users will have the option to modify their own templates in future.
The format of annotate templates are very similar to HTML. Here we add a level 4 heading, grab the "Instructions" custom property and if it is defined (it may not have been set for all Forms) we insert the value into a paragraph before the layout:
We can add the Form version and Copyright properties to the table of standard Form properties using markup like this to add a row to a table:
that generates an annotate like:
Next we want to add the SDTM annotations. Typically these are done in color. We could choose any color for the background of these sections of text but lets go with aqua. Here we show how we add that text in that color to the field:
And we do something similar to the top of the form to add the SDTM domain there:
Lastly we want to highlight the rows of different Field groups to show those that should not be used together. The logic for this is reasonably complex but can be done within the template system in 8 lines. We need to look at every field and determine if it has a "Field Set" property set. For each unique "Field Set" value we assign a unique color from a list of colors we provide.
The result is:
The colors used here make it clear which groups of fields belong together. Note that this isn't a feature of TrialGrid, it's something we created ourselves with custom properties and some modification of our annotate generator - if you have a different system or different metadata you want to capture and show in annotates this can easily be achieved!
In this post we showed how..
- Custom metadata (properties) can be defined in TrialGrid for Forms and Fields.
- Properties can be edited in the Form editor
- Property values appear in system listings such as the Form list
- Properties can be imported and exported into/from the TrialGrid system using the Architect Loader Spreadsheet
- Properties can be included in the new Annotate Templates system to document standards, usage instructions and key metadata such as SDTM annotations.
We're barely scratching the surface of what you can do with the annotate template system. Essentially it's a report writing engine that has access to all the data in an Architect Study Draft. That includes all the extra information that TrialGrid captures and that we haven't yet mentioned here - user comments on design objects, the audit trail of changes to objects, the standards compliance workflow state of an object, custom labels (such as workflow state) applied to an item and a whole lot more.
Contact us if you have particular needs for annotates or Draft reports. We can help!