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

...