This page provides a sample Eligibility Report generated using
gsm.kri package. Expand the “Setup” section below to see
the code used to generate the report. Or scroll down for the standard
report output.
# Load libraries
library(dplyr)
library(purrr)
library(gsm.core)
library(gsm.kri)
library(gsm.mapping)
library(gsm.qtl)
# Prepare example data
dfResults <- gsm.core::reportingResults_study %>%
filter(MetricID %in% "Analysis_qtl0001") %>%
mutate(MetricID = "study_eligibility")
dfMetrics <- gsm.core::reportingMetrics_study %>%
filter(MetricID %in% "Analysis_qtl0001") %>%
mutate(MetricID = "study_eligibility")
dfGroups <- gsm.core::reportingGroups_study
mappings_wf <- gsm.core::MakeWorkflowList(
strNames = c("IE", "EXCLUSION", "ENROLL", "PD"),
strPath = "workflow/1_mappings",
strPackage = "gsm.mapping"
)
mappings_spec <- gsm.mapping::CombineSpecs(mappings_wf)
lRaw <- map_depth(
list(gsm.core::lSource),
1,
gsm.mapping::Ingest,
mappings_spec
)
## ℹ Ingesting data for ENROLL.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 1000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for IE.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for PD.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 3000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for IE.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for ENROLL.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 1000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for PD.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 3000 rows returned.
## Disconnected from temporary DuckDB connection.
mapped <- map_depth(lRaw, 1, ~ gsm.core::RunWorkflows(mappings_wf, .x))
##
## ── Running 4 Workflows ─────────────────────────────────────────────────────────
##
## ── Initializing `Mapped_ENROLL` Workflow ───────────────────────────────────────
##
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_ENROLL
## → All specified columns in Raw_ENROLL are in the expected format
## → All 7 specified column(s) in the spec are present in the data: Raw_ENROLL$studyid, Raw_ENROLL$invid, Raw_ENROLL$country, Raw_ENROLL$subjid, Raw_ENROLL$subjectid, Raw_ENROLL$enrollyn, Raw_ENROLL$enroll_dt
##
## ── Workflow Step 1 of 1: `=` ──
##
## ── Evaluating 2 parameter(s) for `=`
## ℹ lhs = Mapped_ENROLL: No matching data found. Passing 'Mapped_ENROLL' as a string.
## ✔ rhs = Raw_ENROLL: Passing lData$Raw_ENROLL.
##
## ── Calling `=`
##
## ── 1000x7 data.frame saved as `lData$Mapped_ENROLL`.
##
## ── Returning results from final step: 1000x7 data.frame`. ──
##
## ── Completed `Mapped_ENROLL` Workflow ──────────────────────────────────────────
##
## ── Initializing `Mapped_IE` Workflow ───────────────────────────────────────────
##
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_IE
## → All specified columns in Raw_IE are in the expected format
## → All 7 specified column(s) in the spec are present in the data: Raw_IE$studyid, Raw_IE$subjid, Raw_IE$tiver, Raw_IE$ietest, Raw_IE$ietestcd, Raw_IE$ieorres, Raw_IE$iecat
##
## ── Workflow Step 1 of 3: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Raw_IE: Passing lData$Raw_IE.
## ℹ strQuery = SELECT *, CASE WHEN ietestcd ILIKE '%EXC%' THEN 'EX' WHEN ietestcd ILIKE '%INC%' THEN 'IN' END as iecat_custom FROM df: No matching data found. Passing 'SELECT *, CASE WHEN ietestcd ILIKE '%EXC%' THEN 'EX' WHEN ietestcd ILIKE '%INC%' THEN 'IN' END as iecat_custom FROM df' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 255x8 data.frame saved as `lData$iecat_custom`.
##
## ── Workflow Step 2 of 3: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = iecat_custom: Passing lData$iecat_custom.
## ℹ strQuery = SELECT * , CASE WHEN iecat_custom = 'EX' AND ieorres = 'Yes' then 'Y' WHEN iecat_custom = 'IN' AND ieorres = 'No' then 'Y' END as ie_violation FROM df: No matching data found. Passing 'SELECT * , CASE WHEN iecat_custom = 'EX' AND ieorres = 'Yes' then 'Y' WHEN iecat_custom = 'IN' AND ieorres = 'No' then 'Y' END as ie_violation FROM df' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 255x9 data.frame saved as `lData$ie_violation`.
##
## ── Workflow Step 3 of 3: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = ie_violation: Passing lData$ie_violation.
## ℹ strQuery = SELECT * FROM df WHERE subjid IS NOT NULL AND ie_violation = 'Y': No matching data found. Passing 'SELECT * FROM df WHERE subjid IS NOT NULL AND ie_violation = 'Y'' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 122 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 122x9 data.frame saved as `lData$Mapped_IE`.
##
## ── Returning results from final step: 122x9 data.frame`. ──
##
## ── Completed `Mapped_IE` Workflow ──────────────────────────────────────────────
##
## ── Initializing `Mapped_PD` Workflow ───────────────────────────────────────────
##
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_PD
## → All specified columns in Raw_PD are in the expected format
## → All 6 specified column(s) in the spec are present in the data: Raw_PD$studyid, Raw_PD$subjid, Raw_PD$deemedimportant, Raw_PD$dvdecod, Raw_PD$dvterm, Raw_PD$dvdtm
##
## ── Workflow Step 1 of 1: `=` ──
##
## ── Evaluating 2 parameter(s) for `=`
## ℹ lhs = Mapped_PD: No matching data found. Passing 'Mapped_PD' as a string.
## ✔ rhs = Raw_PD: Passing lData$Raw_PD.
##
## ── Calling `=`
##
## ── 3000x6 data.frame saved as `lData$Mapped_PD`.
##
## ── Returning results from final step: 3000x6 data.frame`. ──
##
## ── Completed `Mapped_PD` Workflow ──────────────────────────────────────────────
##
## ── Initializing `Mapped_EXCLUSION` Workflow ────────────────────────────────────
##
## ── Checking data against spec
## → All 3 data.frame(s) in the spec are present in the data: Mapped_IE, Mapped_ENROLL, Mapped_PD
## → All specified columns in Mapped_IE are in the expected format
## → All specified columns in Mapped_ENROLL are in the expected format
## → All specified columns in Mapped_PD are in the expected format
## → All 20 specified column(s) in the spec are present in the data: Mapped_IE$studyid, Mapped_IE$subjid, Mapped_IE$tiver, Mapped_IE$ietest, Mapped_IE$ietestcd, Mapped_IE$ieorres, Mapped_IE$iecat_custom, Mapped_IE$ie_violation, Mapped_ENROLL$studyid, Mapped_ENROLL$subjectid, Mapped_ENROLL$subjid, Mapped_ENROLL$invid, Mapped_ENROLL$enrollyn, Mapped_ENROLL$country, Mapped_PD$studyid, Mapped_PD$subjid, Mapped_PD$dvterm, Mapped_PD$dvdecod, Mapped_PD$deemedimportant, Mapped_PD$dvdtm
##
## ── Workflow Step 1 of 5: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Mapped_IE: Passing lData$Mapped_IE.
## ℹ strQuery = SELECT subjid, studyid, array_to_string(array_agg(ietestcd), ',') AS ietestcd_concat, ie_violation FROM df GROUP BY studyid, subjid, ie_violation: No matching data found. Passing 'SELECT subjid, studyid, array_to_string(array_agg(ietestcd), ',') AS ietestcd_concat, ie_violation FROM df GROUP BY studyid, subjid, ie_violation' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 122 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 122x4 data.frame saved as `lData$pivot_ie`.
##
## ── Workflow Step 2 of 5: `dplyr::left_join` ──
##
## ── Evaluating 3 parameter(s) for `dplyr::left_join`
## ✔ x = Mapped_ENROLL: Passing lData$Mapped_ENROLL.
## ✔ y = pivot_ie: Passing lData$pivot_ie.
## ℹ by is of length 2: Parameter is a vector. Passing as is.
##
## ── Calling `dplyr::left_join`
##
## ── 1000x9 data.frame saved as `lData$add_ie`.
##
## ── Workflow Step 3 of 5: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Mapped_PD: Passing lData$Mapped_PD.
## ℹ strQuery = SELECT studyid, subjid, array_to_string(array_agg(dvdtm), ';;;') AS dvdtm, array_to_string(array_agg(dvterm), ';;;') AS eligibility_criteria FROM df WHERE dvdecod IN ('Exclusion Criteria', 'Inclusion Criteria') GROUP BY studyid, subjid: No matching data found. Passing 'SELECT studyid, subjid, array_to_string(array_agg(dvdtm), ';;;') AS dvdtm, array_to_string(array_agg(dvterm), ';;;') AS eligibility_criteria FROM df WHERE dvdecod IN ('Exclusion Criteria', 'Inclusion Criteria') GROUP BY studyid, subjid' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 270 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 270x4 data.frame saved as `lData$pivot_pd`.
##
## ── Workflow Step 4 of 5: `dplyr::left_join` ──
##
## ── Evaluating 3 parameter(s) for `dplyr::left_join`
## ✔ x = add_ie: Passing lData$add_ie.
## ✔ y = pivot_pd: Passing lData$pivot_pd.
## ℹ by is of length 2: Parameter is a vector. Passing as is.
##
## ── Calling `dplyr::left_join`
##
## ── 1000x11 data.frame saved as `lData$premapped`.
##
## ── Workflow Step 5 of 5: `gsm.core::RunQuery` ──
##
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = premapped: Passing lData$premapped.
## ℹ strQuery = SELECT *, CASE WHEN ie_violation = 'Y' AND eligibility_criteria IS NULL THEN 'EDC I/E only' WHEN ie_violation IS NULL AND eligibility_criteria IS NOT NULL THEN 'Eligibility IPD only' WHEN ie_violation = 'Y' AND eligibility_criteria IS NOT NULL THEN 'Ineligible, Both Criteria' ELSE 'Neither' END AS Source FROM df WHERE enrollyn = 'Y': No matching data found. Passing 'SELECT *, CASE WHEN ie_violation = 'Y' AND eligibility_criteria IS NULL THEN 'EDC I/E only' WHEN ie_violation IS NULL AND eligibility_criteria IS NOT NULL THEN 'Eligibility IPD only' WHEN ie_violation = 'Y' AND eligibility_criteria IS NOT NULL THEN 'Ineligible, Both Criteria' ELSE 'Neither' END AS Source FROM df WHERE enrollyn = 'Y'' as a string.
##
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 769 rows returned.
## Disconnected from temporary DuckDB connection.
##
## ── 769x12 data.frame saved as `lData$Mapped_EXCLUSION`.
##
## ── Returning results from final step: 769x12 data.frame`. ──
##
## ── Completed `Mapped_EXCLUSION` Workflow ───────────────────────────────────────
lListings <- list(
IE = mapped[[1]]$Mapped_EXCLUSION
)
| Param | Value |
|---|---|
| StudyID | AA-AA-000-0000 |
| Ineligible Participants | 303 |
| Total Enrolled | 769 |
| Current Ineligible Enrolled Rate | 39.4% |
| Site | Country | Subject ID | Source | Which I/E | PD Date1 | PD Date2 | PD Date3 | PD Term1 | PD Term2 | PD Term3 |
|---|---|---|---|---|---|---|---|---|---|---|
| 0X1750 | US | S29898 | EDC I/E only | NA | NA | NA | ||||
| 0X4323 | US | S35058 | EDC I/E only | NA | NA | NA | ||||
| 0X213 | UK | S22366 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X5384 | UK | S61242 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X9360 | Japan | S6700 | EDC I/E only | NA | NA | NA | ||||
| 0X2170 | Japan | S95738 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X6603 | UK | S99475 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X958 | UK | S43843 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | ||||
| 0X759 | US | S89142 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8633 | Japan | S6557 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X5895 | Japan | S42745 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X9142 | Japan | S13713 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X958 | UK | S56659 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X9142 | Japan | S9242 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4485 | US | S84022 | EDC I/E only | NA | NA | NA | ||||
| 0X9346 | UK | S41703 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4323 | US | S92817 | Ineligible, Both Criteria | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X4485 | US | S80827 | Ineligible, Both Criteria | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X4590 | US | S42441 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | 2012-03-01 | ||||
| 0X9580 | UK | S19156 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X6405 | US | S52428 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | ||||
| 0X3909 | Japan | S62190 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X4590 | US | S13289 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X7011 | US | S90711 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X8351 | UK | S61706 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9737 | Japan | S28543 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8764 | Japan | S81402 | EDC I/E only | NA | NA | NA | ||||
| 0X8351 | UK | S52552 | EDC I/E only | NA | NA | NA | ||||
| 0X8517 | UK | S46976 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X9346 | UK | S10169 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X7809 | Japan | S34327 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X4590 | US | S64268 | EDC I/E only | NA | NA | NA | ||||
| 0X2532 | US | S47175 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X9346 | UK | S61441 | EDC I/E only | NA | NA | NA | ||||
| 0X2170 | Japan | S34157 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X8517 | UK | S66721 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | ||||
| 0X5895 | Japan | S2143 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X9142 | Japan | S3285 | EDC I/E only | NA | NA | NA | ||||
| 0X213 | UK | S40145 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | ||||
| 0X958 | UK | S52979 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X759 | US | S76424 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | ||||
| 0X213 | UK | S73715 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | ||||
| 0X3289 | US | S35204 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X4323 | US | S44278 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | 2012-01-01 | ||||
| 0X6405 | US | S6022 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8799 | UK | S71069 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X9737 | Japan | S20971 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | ||||
| 0X2192 | UK | S36177 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X4323 | US | S15734 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | ||||
| 0X9142 | Japan | S61670 | EDC I/E only | NA | NA | NA | ||||
| 0X9142 | Japan | S2969 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X4629 | Japan | S50664 | EDC I/E only | NA | NA | NA | ||||
| 0X3909 | Japan | S21491 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X6603 | UK | S32854 | EDC I/E only | NA | NA | NA | ||||
| 0X213 | UK | S67498 | EDC I/E only | NA | NA | NA | ||||
| 0X101 | UK | S96757 | Ineligible, Both Criteria | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X4264 | US | S47665 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X1750 | US | S56565 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8625 | US | S83058 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X5384 | UK | S95900 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8625 | US | S72389 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X8354 | Japan | S3492 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X7011 | US | S58315 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X2532 | US | S17064 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X5033 | US | S69485 | EDC I/E only | NA | NA | NA | ||||
| 0X3289 | US | S42358 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X7983 | US | S75468 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X2323 | Japan | S23519 | EDC I/E only | NA | NA | NA | ||||
| 0X5895 | Japan | S50779 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4959 | US | S40424 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X8091 | UK | S89271 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X2901 | US | S10582 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8091 | UK | S61099 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | ||||
| 0X4485 | US | S40868 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X4485 | US | S52444 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | ||||
| 0X8788 | Japan | S85481 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X2192 | UK | S99639 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | ||||
| 0X8633 | Japan | S98371 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X1910 | US | S60126 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X213 | UK | S58498 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X2170 | Japan | S7173 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X2192 | UK | S30541 | EDC I/E only | NA | NA | NA | ||||
| 0X4874 | Japan | S47824 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X7011 | US | S32805 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | ||||
| 0X9360 | Japan | S36762 | Eligibility IPD only | 2012-01-01 | NA | NA | ||||
| 0X4323 | US | S52192 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3508 | UK | S8366 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | 2012-03-01 | ||||
| 0X5733 | Japan | S24175 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7983 | US | S24430 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X1982 | US | S34322 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4415 | Japan | S54155 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8713 | US | S47209 | EDC I/E only | NA | NA | NA | ||||
| 0X6767 | Japan | S81619 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | ||||
| 0X4019 | US | S4221 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3289 | US | S27209 | EDC I/E only | NA | NA | NA | ||||
| 0X9043 | US | S78985 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4384 | US | S60876 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1417 | US | S19541 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9043 | US | S71362 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X6405 | US | S60674 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X6603 | UK | S58273 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3411 | UK | S44132 | EDC I/E only | NA | NA | NA | ||||
| 0X2192 | UK | S98673 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8559 | Japan | S10093 | EDC I/E only | NA | NA | NA | ||||
| 0X5458 | UK | S70775 | EDC I/E only | NA | NA | NA | ||||
| 0X1910 | US | S71223 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4629 | Japan | S37633 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8354 | Japan | S95215 | EDC I/E only | NA | NA | NA | ||||
| 0X7244 | US | S74143 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1910 | US | S76127 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X5895 | Japan | S78898 | EDC I/E only | NA | NA | NA | ||||
| 0X9119 | US | S97150 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X958 | UK | S37784 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3289 | US | S3483 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3694 | Japan | S12625 | EDC I/E only | NA | NA | NA | ||||
| 0X2323 | Japan | S17819 | EDC I/E only | NA | NA | NA | ||||
| 0X4415 | Japan | S14271 | EDC I/E only | NA | NA | NA | ||||
| 0X9691 | Japan | S51362 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X213 | UK | S12703 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X3411 | UK | S24201 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X301 | US | S072 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X5348 | Japan | S57432 | EDC I/E only | NA | NA | NA | ||||
| 0X759 | US | S23540 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X3909 | Japan | S2797 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4323 | US | S50998 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4323 | US | S85079 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6603 | UK | S68891 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X6900 | Japan | S51418 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X1417 | US | S18274 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X5733 | Japan | S51378 | EDC I/E only | NA | NA | NA | ||||
| 0X5384 | UK | S3741 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1635 | US | S16413 | EDC I/E only | NA | NA | NA | ||||
| 0X1750 | US | S49717 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X7753 | US | S54277 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8713 | US | S28406 | EDC I/E only | NA | NA | NA | ||||
| 0X1257 | Japan | S37510 | EDC I/E only | NA | NA | NA | ||||
| 0X8559 | Japan | S35142 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3090 | US | S63308 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8786 | US | S84785 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X9691 | Japan | S19535 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3508 | UK | S6303 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3989 | US | S9194 | EDC I/E only | NA | NA | NA | ||||
| 0X7011 | US | S78456 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X2170 | Japan | S16728 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X9346 | UK | S63832 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X213 | UK | S63030 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X4571 | UK | S63176 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X2170 | Japan | S39113 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7289 | US | S2661 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | ||||
| 0X5967 | UK | S92964 | EDC I/E only | NA | NA | NA | ||||
| 0X7244 | US | S24630 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4485 | US | S40667 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | ||||
| 0X8786 | US | S4133 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6900 | Japan | S38118 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X9580 | UK | S51805 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8633 | Japan | S7154 | EDC I/E only | NA | NA | NA | ||||
| 0X8625 | US | S62473 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X9858 | UK | S78928 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6603 | UK | S52258 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3289 | US | S68230 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X6767 | Japan | S86567 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1982 | US | S84760 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7244 | US | S37167 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9360 | Japan | S74393 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X6403 | Japan | S24077 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X1337 | Japan | S40833 | EDC I/E only | NA | NA | NA | ||||
| 0X6405 | US | S19075 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | ||||
| 0X3560 | US | S6539 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X3090 | US | S53155 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X9346 | UK | S85234 | EDC I/E only | NA | NA | NA | ||||
| 0X6403 | Japan | S56238 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9691 | Japan | S25650 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | ||||
| 0X3989 | US | S7687 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4959 | US | S75201 | EDC I/E only | NA | NA | NA | ||||
| 0X7753 | US | S93033 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X301 | US | S5056 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X2170 | Japan | S9976 | EDC I/E only | NA | NA | NA | ||||
| 0X7011 | US | S47832 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8790 | Japan | S4885 | Ineligible, Both Criteria | 2012-02-01 | 2012-03-01 | NA | ||||
| 0X7809 | Japan | S15139 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X6405 | US | S66335 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X8827 | Japan | S94088 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | ||||
| 0X4044 | UK | S54585 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X4465 | Japan | S81198 | EDC I/E only | NA | NA | NA | ||||
| 0X4044 | UK | S90822 | EDC I/E only | NA | NA | NA | ||||
| 0X101 | UK | S50189 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3144 | US | S23536 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6603 | UK | S3453 | EDC I/E only | NA | NA | NA | ||||
| 0X826 | Japan | S87484 | Eligibility IPD only | 2012-02-01 | NA | NA | ||||
| 0X9277 | Japan | S48926 | EDC I/E only | NA | NA | NA | ||||
| 0X8713 | US | S34454 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4485 | US | S38678 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9556 | Japan | S75553 | EDC I/E only | NA | NA | NA | ||||
| 0X2018 | US | S15062 | EDC I/E only | NA | NA | NA | ||||
| 0X9401 | Japan | S2794 | EDC I/E only | NA | NA | NA | ||||
| 0X7809 | Japan | S18586 | EDC I/E only | NA | NA | NA | ||||
| 0X4699 | Japan | S9465 | EDC I/E only | NA | NA | NA | ||||
| 0X2262 | Japan | S10703 | EDC I/E only | NA | NA | NA | ||||
| 0X1333 | US | S42047 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4798 | US | S31693 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X2192 | UK | S81429 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9556 | Japan | S19923 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X8788 | Japan | S8141 | EDC I/E only | NA | NA | NA | ||||
| 0X1417 | US | S65760 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9556 | Japan | S57990 | EDC I/E only | NA | NA | NA | ||||
| 0X9126 | UK | S65660 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8517 | UK | S59632 | EDC I/E only | NA | NA | NA | ||||
| 0X4465 | Japan | S84613 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9832 | US | S15606 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X301 | US | S54523 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X326 | Japan | S89999 | EDC I/E only | NA | NA | NA | ||||
| 0X8625 | US | S79298 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9691 | Japan | S71716 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X2285 | Japan | S72804 | EDC I/E only | NA | NA | NA | ||||
| 0X3989 | US | S58307 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | ||||
| 0X5967 | UK | S2104 | EDC I/E only | NA | NA | NA | ||||
| 0X9529 | US | S47053 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1982 | US | S86258 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X4231 | UK | S73285 | EDC I/E only | NA | NA | NA | ||||
| 0X4328 | Japan | S47497 | EDC I/E only | NA | NA | NA | ||||
| 0X288 | UK | S43623 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1910 | US | S60381 | EDC I/E only | NA | NA | NA | ||||
| 0X7983 | US | S33260 | EDC I/E only | NA | NA | NA | ||||
| 0X9360 | Japan | S37311 | EDC I/E only | NA | NA | NA | ||||
| 0X1767 | Japan | S7442 | EDC I/E only | NA | NA | NA | ||||
| 0X5967 | UK | S71658 | EDC I/E only | NA | NA | NA | ||||
| 0X1996 | US | S35412 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4629 | Japan | S88390 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X2323 | Japan | S29019 | EDC I/E only | NA | NA | NA | ||||
| 0X6603 | UK | S85665 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6712 | Japan | S45003 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1865 | Japan | S88499 | EDC I/E only | NA | NA | NA | ||||
| 0X1419 | UK | S94236 | EDC I/E only | NA | NA | NA | ||||
| 0X4384 | US | S39303 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6954 | Japan | S4504 | EDC I/E only | NA | NA | NA | ||||
| 0X9126 | UK | S841 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X5967 | UK | S57756 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X9574 | US | S58861 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X5702 | US | S36274 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6405 | US | S9226 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7590 | US | S8303 | EDC I/E only | NA | NA | NA | ||||
| 0X9529 | US | S78357 | EDC I/E only | NA | NA | NA | ||||
| 0X3090 | US | S3034 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8633 | Japan | S63190 | EDC I/E only | NA | NA | NA | ||||
| 0X088 | UK | S63643 | EDC I/E only | NA | NA | NA | ||||
| 0X6601 | UK | S84246 | EDC I/E only | NA | NA | NA | ||||
| 0X9165 | UK | S70330 | EDC I/E only | NA | NA | NA | ||||
| 0X9580 | UK | S97826 | EDC I/E only | NA | NA | NA | ||||
| 0X9529 | US | S60167 | EDC I/E only | NA | NA | NA | ||||
| 0X5733 | Japan | S68494 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6252 | US | S60689 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8788 | Japan | S82305 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | ||||
| 0X8513 | Japan | S44765 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8091 | UK | S84404 | EDC I/E only | NA | NA | NA | ||||
| 0X5047 | Japan | S36490 | EDC I/E only | NA | NA | NA | ||||
| 0X3508 | UK | S69904 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7106 | Japan | S66288 | EDC I/E only | NA | NA | NA | ||||
| 0X180 | UK | S14672 | EDC I/E only | NA | NA | NA | ||||
| 0X1996 | US | S59860 | EDC I/E only | NA | NA | NA | ||||
| 0X9165 | UK | S23627 | EDC I/E only | NA | NA | NA | ||||
| 0X7106 | Japan | S75421 | EDC I/E only | NA | NA | NA | ||||
| 0X3606 | Japan | S4725 | EDC I/E only | NA | NA | NA | ||||
| 0X9165 | UK | S9273 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X2901 | US | S77451 | EDC I/E only | NA | NA | NA | ||||
| 0X3090 | US | S59091 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1996 | US | S95540 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6884 | Japan | S90997 | EDC I/E only | NA | NA | NA | ||||
| 0X2285 | Japan | S98483 | EDC I/E only | NA | NA | NA | ||||
| 0X5089 | Japan | S38735 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7587 | Japan | S4299 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4571 | UK | S99968 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4798 | US | S62953 | EDC I/E only | NA | NA | NA | ||||
| 0X2018 | US | S18250 | EDC I/E only | NA | NA | NA | ||||
| 0X2788 | UK | S54411 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | ||||
| 0X2901 | US | S25454 | EDC I/E only | NA | NA | NA | ||||
| 0X4034 | US | S85100 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4019 | US | S35357 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1337 | Japan | S42067 | EDC I/E only | NA | NA | NA | ||||
| 0X4231 | UK | S19364 | EDC I/E only | NA | NA | NA | ||||
| 0X3289 | US | S95477 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7289 | US | S85026 | EDC I/E only | NA | NA | NA | ||||
| 0X8625 | US | S4848 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X354 | UK | S70307 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6601 | UK | S19468 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X354 | UK | S47969 | EDC I/E only | NA | NA | NA | ||||
| 0X1616 | US | S59092 | EDC I/E only | NA | NA | NA | ||||
| 0X9556 | Japan | S51038 | EDC I/E only | NA | NA | NA | ||||
| 0X7250 | Japan | S19514 | EDC I/E only | NA | NA | NA | ||||
| 0X8764 | Japan | S20805 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X3694 | Japan | S74010 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4019 | US | S12851 | EDC I/E only | NA | NA | NA | ||||
| 0X8713 | US | S55641 | EDC I/E only | NA | NA | NA | ||||
| 0X3989 | US | S11217 | EDC I/E only | NA | NA | NA | ||||
| 0X8799 | UK | S82918 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1169 | UK | S63151 | EDC I/E only | NA | NA | NA | ||||
| 0X958 | UK | S93719 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X1910 | US | S27200 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X7590 | US | S9936 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X4044 | UK | S61093 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X2757 | Japan | S87835 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X2006 | US | S29904 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X8774 | UK | S15288 | Eligibility IPD only | 2012-03-01 | NA | NA | ||||
| 0X6403 | Japan | S65333 | Eligibility IPD only | 2012-03-01 | NA | NA |