Risk-Based Monitoring - External Standard - Version 2
The supplemental data set is used to enter any data (external to the database or otherwise) used by the RBM system. It is modeled after a CDISC event domain, and uses the two-letter prefix RB.
Variables in Supplemental Data Sets
Required Variables: The supplemental RB data set must contain the variables listed in the following table:
Variable Names |
Variable Labels |
Type |
Notes |
Required |
STUDYID |
Study Identifier |
Character |
Study ID. Likely not used directly in the code. |
|
USUBJID |
Unique Subject Identifier |
Character |
Used to match subject-level summary data derived from this data set to the CDISC data used in JMPC (minimum DM and DS) for analysis. |
Yes |
SITEID |
Study Site Identifier |
Character |
To provide site-level data for analysis. In these cases, USUBJID would be missing. |
Yes |
VARIABLE |
Variable |
Character |
Short code that is used as variable name within SAS code, for example, "QUERY". Special codes: QUERY, CRFPAGE. |
Yes |
RBDECOD |
Standardized Term |
Character |
Standardized term for analysis. This is used as label for variable specified within VARIABLE, "Query", for example. Within the same analysis, subject and site-level variables cannot share the same values for VARIABLE and RBDECOD. In other words, variable names and labels must be distinct. Subjects without an instance of a particular VARIABLE and RBDECOD are assumed of have 0 instances |
Yes |
RBTERM |
Reported Term |
Character |
Term that can provide more specific detail. Not used directly by system, for example, “inconsistency with gender and pregnancy findings”. |
|
RBCAT |
Category |
Character |
One of Enrollment, Disposition, Safety or Supplemental. This determines the group of variables the variable resides with in the analysis table, and has implications on which subcategory overall indicator it contributes toward. May allow for more general categories in a future version |
Yes |
RBSTDTC |
Start Date/Time |
Character, ISO 8601 |
Start date of event. This determines where events are presented for time trends. |
Yes |
RBENDTC |
End Date/Time |
Character, ISO 8601 |
End date of event. This is to determine responsiveness to completing tasks (such as queries), or if missing, if an item is considered OVERDUE |
If missing, RBENDTC assumed to equal RBSTDTC. |
RBFREQ |
Frequency |
Numeric |
The frequency the current record should be weighted for analysis. |
If not used or value missing, the row is assumed to occur a single instance. |
Safety and Supplemental Variables: Manually Entered group variables are now called Supplemental Variables. These can include any one of Enrollment, Disposition, Safety, or Supplemental that contribute to the appropriate OVERALL flags. Adverse Events are now called Safety variables and include AEs, SAEs, deaths, and hospitalizations.
Existing supplemental data sets or risk threshold data sets having the old categories are now recoded to change Adverse Events to Safety, and Manually Entered to Supplemental. This recoding occurs when new thresholds are created from old versions, and are done on the fly for thresholds and supplemental data in the RBM report.
Site Level Variables: Risk-Based Monitoring (RBM) supports site-level variables in the supplemental data set. These are identified by having USUBJID missing. Study Site Identifier (SITEID) is now a required variable for this format. Because dates can be provided, site-level variables should be summarized in time trend analyses. Within the same analysis, subject and site-level variables cannot share the same values for VARIABLE and RBDECOD.
Example 1: Protocol deviations computed by SAS programs entered into system
USUBJID |
Variable |
RBDECOD |
RBTERM |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
10101 |
PROTDEV |
Protocol Deviation |
Long Text |
Disposition |
2004-12-1 |
2004-12-1 |
1 |
10101 |
PROTDEV |
Protocol Deviation |
Long Text |
Disposition |
2004-12-4 |
2004-12-4 |
1 |
10104 |
PROTDEV |
Protocol Deviation |
Long Text |
Disposition |
2004-12-4 |
2004-12-4 |
2 |
... |
|
|
|
|
|
|
|
Subject 10104 had 2 protocol deviations on December 4th. In site level table, PROTDEV is the sum of all protocol deviations for a site. PROTDEV is the country-level sum of deviations for each country. If subjects, sites or countries are not represented, they have a value of 0. RBMTERM can be used to distinguish between specific events. To count different types of deviations, this would require multiple sets of codes. For example, if you want a count of all and clinically-relevant deviations, the clinically-relevant deviations would need additional rows in the table with a new code and label (for example, CPROTDEV). These frequency variables have additional variables created for total averaged by # randomized subjects (AVPROTDEV) and by # patientweeks (PWPROTDEV).
Computed Eligibility Violations would work in the same way (if a SAS program calculated these, for example). Alternatively, specific hospitalization of interest (that would ultimately end up in the HO domain) could be collected in this manner.
Example 2:QUERY
USUBJID |
Variable |
RBDECOD |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
10101 |
QUERY |
QUERY |
Supplemental |
2004-12-1 |
2004-12-1 |
1 |
10101 |
QUERY |
QUERY |
Supplemental |
2004-12-4 |
|
1 |
10104 |
QUERY |
QUERY |
Supplemental |
2004-12-4 |
2004-12-4 |
2 |
... |
|
|
|
|
|
|
Subject 10104 had 2 queries on December 4th that were resolved the same day. In site level table, QUERY is the sum of all queries for a site. QUERY is country-level sum of queries for each country. If subjects, sites or countries are not represented, they have a value of 0. Frequency variables have additional variables created for total averaged by # randomized subjects (AVQUERY) and by # patientweeks (PWQUERY). The special term QUERY also calculates OQUERY as the count of queries with missing RBENDTC. The word "Overdue" is added to QUERY label listed in RBDECOD (here, resulting in RBEDCOD value of Overdue Query). Similar averages are computed for # randomized subjects and patient weeks. The special term QUERY also calculates RQUERY, which is the average query response time (# days between RBSTDTC and RBENDTC) for all queries for a subject, site, or country, taking into consideration RBFREQ.
Example 3: CRFPAGE
It would be possible to include records for each CRF page a subject is expected to enter. Alternatively, the total completed pages or incomplete pages could be tracked. Here, RBSTDTC represents the date on which the visit occurred, while RBENDTC represents the date on which the page (paper or electronic) was completed.
USUBJID |
SITEID |
Variable |
RBDECOD |
RBTERM |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
10101 |
10 |
CRFPAGE |
CRF Page |
Page 1 |
Supplemental |
2004-12-1 |
2004-12-1 |
1 |
10101 |
10 |
CRFPAGE |
CRF Page |
Page 2 |
Supplemental |
2004-12-4 |
|
1 |
10104 |
10 |
CRFPAGE |
CRF Page |
Page 1 |
Supplemental |
2004-12-4 |
2004-12-4 |
2 |
... |
|
|
|
|
|
|
|
|
In site level table, CRFPAGE is the sum of all pages for a site. CRFPAGE is the country-level sum of pages for each country. If subjects, sites or countries are not represented, they have a value of 0. Frequency variables have additional variables created for total averaged by # randomized subjects (AVCRFPAGE) and by # patientweeks (PW CRFPAGE). The special term CRFPAGE also calculates OCRFPAGE as the count of incomplete CRF Pages with missing RBENDTC. The word "Overdue" added to CRFPAGE label listed in RBDECOD (here, resulting in RBEDCOD value of Overdue CRF Pages). Similar averages are computed for # randomized subjects and patient weeks. The special term CRFPAGE also calculates RCRFPAGE, which is the average CRF entry time (# days between RBSTDTC and RBENDTC) for all CRF pages for a subject, site, or country, taking into consideration RBFREQ. Above is one row per page. Alternatively,
USUBJID |
SITEID |
Variable |
RBDECOD |
RBTERM |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
10101 |
10 |
CRFPAGE |
CRF Page |
Visit 1 |
Supplemental |
2004-12-1 |
2004-12-3 |
20 |
10101 |
10 |
CRFPAGE |
CRF Page |
Visit 2 |
Supplemental |
2004-12-1 |
|
5 |
... |
|
|
|
|
|
|
|
|
Here, subject 10101 had 20 pages completed for Visit 1 (Visit 1 occurred December 1, but these pages were entered on December 3), though 5 are missing. Duration would be computed as 3 days for the 20 pages. If only below is provided, the CRFPAGE and OCRFPAGE results should be similar, though RCRFPAGE is not be computed.
USUBJID |
SITEID |
Variable |
RBDECOD |
RBTERM |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
10101 |
10 |
CRFPAGE |
CRF Page |
Visit 2 |
Supplemental |
2004-12-1 |
|
5 |
... |
|
|
|
|
|
|
|
|
Example 4: SITEDEV
A site-level deviation variable could be added to distinguish between protocol deviations perpetrated by the site and by the subject (PROTDEV above). Here, USUBJID is blank to tell JMP Clinical that this is a site-level variable.
USUBJID |
SITEID |
Variable |
RBDECOD |
RBTERM |
RBCAT |
RBSTDTC |
RBENDTC |
RBFREQ |
|
10 |
SITEDEV |
Site Deviation |
|
Supplemental |
2004-12-1 |
2004-12-1 |
1 |
|
10 |
SITEDEV |
Site Deviation |
|
Supplemental |
2004-12-4 |
2004-12-4 |
1 |
|
10 |
SITEDEV |
Site Deviation |
|
Supplemental |
2004-12-4 |
2004-12-4 |
1 |
... |
|
|
|
|
|
|
|
|