Avoiding data queries
Reduce your query workload and achieve better data quality.
Data quality is important on the BSRBR-RA - better research stems from better data. Queries help us fill in any gaps we find in the data, and are a key part to us acheiving high quality research.
However, it's always best to solve the problem at the source, so we've built this page to help you reduce the number of queries being generated, and also improve communication when dealing with data queries.
Sections on this page
Click the links to jump to the relevant section.
- Radio buttons
- Registering new patients
- Using the Preview Queries section
- Responding to queries
Many database pages have radio buttons which require one of several selections. These are often missed altogether - please check back over your selections to make sure you've not missed any. If you can't make a selection due to data unavailability, write us a comment in the Feedback section.
Here are some common examples of radio buttons being missed which almost always generate a query:
- These buttons are used to denote changes to database pages - where you see a question such as "Have there been any changes to the patient's therapy in this period?" - we require "Yes" or "No" to be selected. This includes treatments stopping as well as starting.
- On the 'Additional Info' page at baseline, there are lots of radio buttons used to determine the answer to a number of questions; it can be easy to miss one.
It's important that you have all of the relevant details to hand when registering a new patient. It's even more important that the patient is eligible for the BSRBR-RA - please consult our Eligibility page to check. If you're not sure, it's best to ask us before registering them, as we may have to make their record on the database invalid if they're later found to be ineligible, and your time would be wasted.
An especially important point to note is that we cannot accept registrations of patients before their treatment has started. Even if there is a planned start date, until this date comes, the patient may not actually commence treatment - in which case they'd be ineligible. Remember that if the patient is new to the study, they must be registered with us within 6 months of the treatment commencing.
Please note, if we do not receive vital details when a new patient is registered, such as drug details and a DAS-28 score, we may set a deadline before the patient will be made invalid. Invalid patients cannot be seen on the database, and their queries are also hidden, so if you think this has happened in error and you have the details we require, please contact us.
This section has been designed to reduce your queries to almost zero. By using this section, you can see exactly what the BSRBR-RA admin staff will see when checking the record. If there are suggestions in the Preview Queries section, before closing the edit window you can go back and fill in anything left out by mistake, or acknowledge missing data using the Feedback section.
- Please note, we may have to raise other queries not listed in the Preview Queries section, such as adverse event queries, or when we run ad hoc data cleaning.
It may seem simple, but a patchy response to a query means we'll have to ask again, and it can slow the querying process heavily. See below for some helpful guidelines when responding to queries:
- Consider whether the BSRBR-RA needs the date alongside the missing information you're providing (e.g. lab values - without dates they are meaningless).
- The more detail the better - it's quicker for us to sift through one big message than us having to repeatedly ask for more information.
- Double-check your message before you send it to make sure the information is correct, especially date and adverse event information as typos here can be confusing.