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: 248 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: 248 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: 248 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 248x8 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: 248 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 248x9 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: 130 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 130x9 data.frame saved as `lData$Mapped_IE`.## ## ── Returning results from final step: 130x9 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: 130 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 130x4 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: 258 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 258x4 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: 764 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 764x12 data.frame saved as `lData$Mapped_EXCLUSION`.## ## ── Returning results from final step: 764x12 data.frame`. ──## ## ── Completed `Mapped_EXCLUSION` Workflow ───────────────────────────────────────lListings <- list(
IE = mapped[[1]]$Mapped_EXCLUSION
)| Param | Value |
|---|---|
| StudyID | AA-AA-000-0000 |
| Ineligible Participants | 296 |
| Total Enrolled | 764 |
| Current Ineligible Enrolled Rate | 38.7% |
| Site | Country | Subject ID | Source | Which I/E | PD Date1 | PD Date2 | PD Date3 | PD Date4 | PD Term1 | PD Term2 | PD Term3 | PD Term4 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0X2170 | Japan | S7173 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X4264 | US | S28631 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8091 | UK | S61099 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X1750 | US | S29898 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | |||||
| 0X8633 | Japan | S98267 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X213 | UK | S22366 | Ineligible, Both Criteria | 2012-01-01 | 2012-01-01 | 2012-02-01 | NA | |||||
| 0X213 | UK | S43101 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X759 | US | S56847 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8351 | UK | S26237 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X6603 | UK | S66618 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X7983 | US | S90150 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8625 | US | S23661 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8799 | UK | S47153 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X5384 | UK | S61242 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8517 | UK | S85511 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | NA | |||||
| 0X6603 | UK | S99475 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X759 | US | S89142 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1910 | US | S7193 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X3090 | US | S59284 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8633 | Japan | S6557 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X9360 | Japan | S94352 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S13713 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5384 | UK | S37519 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S9242 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4485 | US | S84022 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X9346 | UK | S41703 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X4323 | US | S92817 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X5895 | Japan | S24661 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8625 | US | S69434 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X4629 | Japan | S14454 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X4323 | US | S88436 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4590 | US | S42441 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X9737 | Japan | S28543 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X4323 | US | S15734 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X2192 | UK | S53524 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X7011 | US | S90711 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | NA | |||||
| 0X4485 | US | S40868 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8351 | UK | S61706 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9580 | UK | S27507 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X9346 | UK | S61441 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X8764 | Japan | S81402 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X2192 | UK | S82502 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7809 | Japan | S1663 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | NA | |||||
| 0X9346 | UK | S10169 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7809 | Japan | S34327 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | 2012-01-01 | NA | |||||
| 0X2532 | US | S47175 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | NA | |||||
| 0X1257 | Japan | S5199 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6405 | US | S6022 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X3989 | US | S81289 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | NA | |||||
| 0X8351 | UK | S52552 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X2323 | Japan | S46390 | Ineligible, Both Criteria | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X4874 | Japan | S47824 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X213 | UK | S83282 | Ineligible, Both Criteria | 2012-01-01 | 2012-01-01 | 2012-03-01 | NA | |||||
| 0X8633 | Japan | S35306 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X213 | UK | S67498 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X4590 | US | S13289 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X2532 | US | S49825 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | 2012-03-01 | NA | |||||
| 0X9346 | UK | S15030 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | NA | NA | |||||
| 0X2192 | UK | S98653 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X9142 | Japan | S35834 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S3285 | Ineligible, Both Criteria | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X958 | UK | S7395 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | NA | |||||
| 0X8788 | Japan | S32336 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S98820 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8786 | US | S33697 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X213 | UK | S80098 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X8786 | US | S59912 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X6405 | US | S79778 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8633 | Japan | S98371 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X2192 | UK | S30541 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X8625 | US | S72389 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8354 | Japan | S3492 | Eligibility IPD only | 2012-01-01 | 2012-02-01 | NA | NA | |||||
| 0X7011 | US | S58315 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X5033 | US | S69485 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8625 | US | S83058 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4959 | US | S40424 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X2170 | Japan | S34157 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | NA | |||||
| 0X1910 | US | S60126 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X4323 | US | S35058 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8517 | UK | S66721 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X2901 | US | S10582 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7983 | US | S75468 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X4629 | Japan | S50664 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1982 | US | S18113 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | NA | |||||
| 0X9360 | Japan | S36762 | Eligibility IPD only | 2012-01-01 | 2012-03-01 | NA | NA | |||||
| 0X2192 | UK | S99639 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8799 | UK | S85279 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X213 | UK | S58498 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9142 | Japan | S2969 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8799 | UK | S79328 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S61670 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X2532 | US | S17064 | Eligibility IPD only | 2012-01-01 | NA | NA | NA | |||||
| 0X7011 | US | S32805 | Eligibility IPD only | 2012-01-01 | 2012-01-01 | 2012-03-01 | NA | |||||
| 0X5895 | Japan | S50779 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X1910 | US | S61442 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X1268 | UK | S27391 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X2970 | Japan | S64182 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X3090 | US | S63544 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | 2012-02-01 | 2012-02-01 | |||||
| 0X4959 | US | S74063 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8786 | US | S5935 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X7815 | US | S89904 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X240 | UK | S19778 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7619 | UK | S98596 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7983 | US | S30656 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5033 | US | S68200 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4590 | US | S34357 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X180 | UK | S29164 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X180 | UK | S2385 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X2170 | Japan | S28987 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X3090 | US | S81358 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X7514 | UK | S22504 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X187 | UK | S99102 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8788 | Japan | S15400 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4028 | UK | S26149 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6304 | US | S83379 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X4535 | US | S57504 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X4541 | US | S33257 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X6369 | UK | S33905 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X3289 | US | S5908 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X5384 | UK | S5118 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X6665 | UK | S21699 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5033 | US | S76758 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X2532 | US | S95756 | Ineligible, Both Criteria | 2012-03-01 | 2012-03-01 | 2012-03-01 | NA | |||||
| 0X9142 | Japan | S66136 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X6665 | UK | S38889 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4323 | US | S78500 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X6502 | Japan | S79933 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2192 | UK | S75801 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4028 | UK | S15441 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8633 | Japan | S55141 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8788 | Japan | S6296 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4353 | US | S35213 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9346 | UK | S62967 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8633 | Japan | S45475 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | |||||
| 0X3289 | US | S90605 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | |||||
| 0X4272 | Japan | S83705 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3848 | Japan | S5128 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X240 | UK | S84205 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6665 | UK | S84371 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6369 | UK | S11984 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | |||||
| 0X2370 | US | S31865 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3989 | US | S5103 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7011 | US | S56387 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7011 | US | S68095 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4485 | US | S35019 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2970 | Japan | S77763 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X6227 | US | S77374 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7155 | Japan | S95979 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X6900 | Japan | S88335 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4541 | US | S56410 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X1910 | US | S72956 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4629 | Japan | S17995 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X759 | US | S39742 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X4323 | US | S39420 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9568 | UK | S81651 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8786 | US | S80475 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X213 | UK | S96183 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X7680 | UK | S66554 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4323 | US | S16781 | Ineligible, Both Criteria | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X6605 | UK | S95362 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4056 | US | S21114 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X6605 | UK | S24827 | Eligibility IPD only | 2012-02-01 | 2012-03-01 | NA | NA | |||||
| 0X3848 | Japan | S51874 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X3848 | Japan | S53494 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7680 | UK | S82232 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9858 | UK | S10717 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X6502 | Japan | S11261 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X724 | US | S62719 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1321 | UK | S76305 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X6304 | US | S11195 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8517 | UK | S24862 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4440 | UK | S28100 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X4629 | Japan | S18388 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4486 | Japan | S83715 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | |||||
| 0X4535 | US | S65691 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1982 | US | S22191 | Eligibility IPD only | 2012-02-01 | NA | NA | NA | |||||
| 0X8799 | UK | S22037 | Eligibility IPD only | 2012-02-01 | 2012-02-01 | NA | NA | |||||
| 0X8517 | UK | S34946 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9346 | UK | S48676 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9569 | UK | S38655 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9871 | US | S61110 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X2170 | Japan | S74482 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8513 | US | S43750 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1881 | UK | S13987 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8387 | Japan | S68866 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8091 | UK | S63239 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8631 | US | S42064 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9360 | Japan | S11750 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X2970 | Japan | S60848 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4587 | UK | S73495 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X101 | UK | S57671 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3989 | US | S48322 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3090 | US | S80508 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X6637 | UK | S15658 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4338 | US | S15946 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X2532 | US | S75106 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9580 | UK | S81030 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9346 | UK | S39397 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7514 | UK | S2472 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X503 | Japan | S35444 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2787 | UK | S56504 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6405 | US | S71455 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9569 | UK | S90585 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4323 | US | S33963 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X8753 | UK | S14892 | Ineligible, Both Criteria | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X9580 | UK | S95019 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X3601 | US | S948 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X7680 | UK | S23296 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X5899 | US | S32421 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7011 | US | S36754 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X6829 | Japan | S78160 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4959 | US | S3256 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S35184 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X2070 | US | S65670 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4486 | Japan | S47771 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7883 | Japan | S80202 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1321 | UK | S68434 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X1856 | Japan | S16870 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X6248 | US | S34979 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3973 | Japan | S94411 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4937 | US | S15332 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X8788 | Japan | S43292 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6637 | UK | S69517 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9569 | UK | S86258 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7983 | US | S24541 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X785 | UK | S55893 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X2005 | Japan | S89089 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3636 | UK | S39296 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X9871 | US | S79204 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X8633 | Japan | S53623 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X187 | UK | S74659 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3289 | US | S61652 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8513 | US | S35316 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1881 | UK | S2355 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4535 | US | S43221 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X187 | UK | S91402 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3989 | US | S55202 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X3292 | UK | S22260 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5384 | UK | S71195 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1856 | Japan | S10475 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X8953 | Japan | S48579 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7523 | Japan | S59659 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1750 | US | S20012 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X5606 | Japan | S28823 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1856 | Japan | S54808 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1982 | US | S31305 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4323 | US | S3257 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X4264 | US | S81026 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X187 | UK | S13650 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4338 | US | S44463 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X3989 | US | S92224 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4264 | US | S82870 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2005 | Japan | S42195 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4440 | UK | S56553 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4264 | US | S41694 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8387 | Japan | S8363 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5115 | UK | S4856 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2005 | Japan | S55522 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2558 | Japan | S67848 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2970 | Japan | S54891 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8633 | Japan | S80218 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3601 | US | S25785 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3909 | Japan | S37461 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X2005 | Japan | S61528 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X3601 | US | S21584 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X7619 | UK | S45804 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4056 | US | S88331 | Ineligible, Both Criteria | 2012-03-01 | 2012-03-01 | NA | NA | |||||
| 0X3289 | US | S64718 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X6829 | Japan | S90494 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X2970 | Japan | S95084 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7523 | Japan | S12285 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4541 | US | S43546 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1750 | US | S57272 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8633 | Japan | S99972 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7589 | US | S86384 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8631 | US | S55687 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X7269 | Japan | S77430 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X6304 | US | S1780 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X4486 | Japan | S3673 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9432 | UK | S19589 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X8753 | UK | S99167 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X787 | US | S23139 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9142 | Japan | S69277 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | |||||
| 0X4937 | US | S98040 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X787 | US | S53337 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X9580 | UK | S95234 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5895 | Japan | S62232 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1881 | UK | S29393 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X4959 | US | S9765 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X8753 | UK | S30431 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X1982 | US | S26989 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | 2012-03-01 | NA | |||||
| 0X787 | US | S56584 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X5384 | UK | S36137 | Eligibility IPD only | 2012-03-01 | NA | NA | NA | |||||
| 0X9871 | US | S86460 | Eligibility IPD only | 2012-03-01 | 2012-03-01 | 2012-03-01 | NA | |||||
| 0X8953 | Japan | S47051 | EDC I/E only | NA | NA | NA | NA | |||||
| 0X1321 | UK | S83553 | EDC I/E only | NA | NA | NA | NA |