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: 254 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: 254 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: 254 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 254x8 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: 254 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 254x9 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: 116 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 116x9 data.frame saved as `lData$Mapped_IE`.## ## ── Returning results from final step: 116x9 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: 116 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 116x4 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: 231 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 231x4 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 PD 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 PD 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: 760 rows returned.## Disconnected from temporary DuckDB connection.## ## ── 760x12 data.frame saved as `lData$Mapped_EXCLUSION`.## ## ── Returning results from final step: 760x12 data.frame`. ──## ## ── Completed `Mapped_EXCLUSION` Workflow ───────────────────────────────────────lListings <- list(
IE_num = mapped[[1]]$Mapped_EXCLUSION %>% dplyr::filter(Source != "Neither"),
IE_denom = mapped[[1]]$Mapped_EXCLUSION
)| Param | Value |
|---|---|
| StudyID | AA-AA-000-0000 |
| Ineligible Participants | 259 |
| Total Enrolled | 760 |
| Current Ineligible Enrolled Rate | 34.1% |
| Country | Site | Participant ID | Source | Which I/E | PD Date1 | PD Date2 | PD Date3 | PD Date4 | PD Date5 | PD Term1 | PD Term2 | PD Term3 | PD Term4 | PD Term5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| US | 0X022 | S85405 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X022 | S97280 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X101 | S96757 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | NA | NA | ||||||
| UK | 0X1102 | S33371 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X1233 | S36814 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X1233 | S44509 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X1257 | S33779 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X1273 | S26710 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X1544 | S60601 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X1727 | S11585 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X1727 | S42591 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X1727 | S44700 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X1727 | S78806 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X1748 | S46204 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X1748 | S4781 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X1748 | S85597 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X1748 | S92734 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X1750 | S29898 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X1750 | S52968 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X1786 | S42753 | Eligibility PD only | 2012-02-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X1786 | S69474 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X180 | S18875 | Eligibility PD only | 2012-01-01 | 2012-02-01 | NA | NA | NA | ||||||
| Japan | 0X1841 | S5553 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X1910 | S13100 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X1934 | S99905 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X1935 | S63755 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X213 | S58498 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X213 | S80098 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X216 | S34410 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X2170 | S34157 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X2170 | S45386 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X2170 | S5842 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X2170 | S7173 | Eligibility PD only | 2012-02-01 | 2012-02-01 | NA | NA | NA | ||||||
| Japan | 0X2170 | S82487 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X2192 | S25117 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X2192 | S30541 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X2192 | S36177 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X2192 | S98653 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X2323 | S23519 | Ineligible, Both Criteria | 2012-01-01 | 2012-02-01 | NA | NA | NA | ||||||
| Japan | 0X2323 | S5140 | Eligibility PD only | 2012-01-01 | 2012-01-01 | 2012-02-01 | NA | NA | ||||||
| UK | 0X2373 | S11205 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X2532 | S17064 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X2532 | S49825 | Eligibility PD only | 2012-01-01 | 2012-01-01 | NA | NA | NA | ||||||
| US | 0X2532 | S61154 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X2883 | S52102 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X2883 | S74797 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X2894 | S25574 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X2901 | S10582 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X2901 | S19752 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X2923 | S25947 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X2986 | S7201 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X3068 | S27013 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X3077 | S16950 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X3077 | S20392 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X3077 | S28082 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3081 | S15149 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3081 | S28722 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3081 | S41688 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X3081 | S7775 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X3090 | S25289 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3090 | S62745 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X3289 | S35204 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X3289 | S38694 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3289 | S42358 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3319 | S19776 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X3319 | S80969 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X3353 | S28822 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X3353 | S52377 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X3353 | S68220 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3415 | S57691 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3719 | S12402 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3719 | S54447 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X3754 | S67292 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3754 | S71929 | Eligibility PD only | 2012-02-01 | 2012-03-01 | 2012-03-01 | NA | NA | ||||||
| UK | 0X3839 | S88305 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X3839 | S92443 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X3909 | S21491 | Eligibility PD only | 2012-01-01 | 2012-01-01 | NA | NA | NA | ||||||
| Japan | 0X3909 | S68284 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3938 | S90436 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X3938 | S97620 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X3989 | S18151 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X3989 | S81289 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X3989 | S82706 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X4072 | S31340 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X4155 | S20468 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4260 | S26943 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4260 | S79443 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4260 | S98343 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X4264 | S47665 | Ineligible, Both Criteria | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X4264 | S78130 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4264 | S98201 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X4314 | S4064 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X4314 | S71809 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X4314 | S8459 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4323 | S15734 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4323 | S44278 | Eligibility PD only | 2012-01-01 | 2012-01-01 | 2012-02-01 | 2012-03-01 | 2012-03-01 | ||||||
| US | 0X4323 | S69684 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X4485 | S6032 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4485 | S6528 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4485 | S70885 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4485 | S80827 | Eligibility PD only | 2012-01-01 | 2012-02-01 | NA | NA | NA | ||||||
| US | 0X4485 | S84022 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X4543 | S10678 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X4543 | S31987 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4590 | S42441 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X4590 | S64268 | Eligibility PD only | 2012-01-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X4629 | S50664 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X4629 | S65083 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X4671 | S30394 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X4703 | S30564 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X4874 | S12836 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X4874 | S24389 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X4959 | S40424 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X4959 | S63470 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4959 | S72738 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X4959 | S76017 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X4959 | S98650 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X5033 | S43487 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X5033 | S69130 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X5033 | S69485 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X5033 | S74728 | Eligibility PD only | 2012-01-01 | 2012-01-01 | 2012-02-01 | NA | NA | ||||||
| US | 0X5062 | S2243 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X5185 | S46151 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X5384 | S2856 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X5384 | S37519 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X5384 | S61242 | Eligibility PD only | 2012-01-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X5384 | S95900 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| UK | 0X5425 | S8126 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X5895 | S24661 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X5895 | S28134 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X5895 | S41126 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X5895 | S42745 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X5895 | S50779 | Eligibility PD only | 2012-02-01 | 2012-02-01 | 2012-03-01 | NA | NA | ||||||
| Japan | 0X5895 | S88386 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X6123 | S30183 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X6123 | S95245 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6155 | S83923 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6184 | S19812 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6184 | S86180 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6384 | S38745 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6384 | S98076 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X6405 | S52428 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X6405 | S6022 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X6405 | S64117 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X6572 | S47134 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X6603 | S38814 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X6603 | S99475 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X6900 | S33412 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X6900 | S91185 | Eligibility PD only | 2012-02-01 | 2012-02-01 | NA | NA | NA | ||||||
| Japan | 0X6900 | S93954 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X6991 | S9356 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7004 | S22616 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7004 | S29917 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X7004 | S55728 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X7004 | S82873 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7004 | S89722 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X7011 | S23553 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7011 | S51380 | Ineligible, Both Criteria | 2012-02-01 | 2012-03-01 | NA | NA | NA | ||||||
| US | 0X7011 | S58315 | Eligibility PD only | 2012-01-01 | 2012-02-01 | NA | NA | NA | ||||||
| US | 0X7011 | S73552 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7011 | S90711 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| UK | 0X7096 | S3179 | Eligibility PD only | 2012-02-01 | 2012-02-01 | NA | NA | NA | ||||||
| UK | 0X7096 | S51371 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7184 | S13810 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X7184 | S3548 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7184 | S71689 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7184 | S78360 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7208 | S30329 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7208 | S58347 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X7246 | S70927 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X7543 | S85267 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X759 | S55631 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X759 | S56847 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7604 | S5685 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7734 | S31824 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X7809 | S59956 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X7809 | S73010 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X7838 | S38629 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7983 | S26837 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X7983 | S61175 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X7983 | S63928 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X8084 | S2826 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X8091 | S61099 | Eligibility PD only | 2012-01-01 | 2012-01-01 | NA | NA | NA | ||||||
| UK | 0X8091 | S89271 | Eligibility PD only | 2012-01-01 | 2012-02-01 | NA | NA | NA | ||||||
| US | 0X8210 | S78571 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X8351 | S61706 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X8351 | S74519 | Eligibility PD only | 2012-01-01 | 2012-01-01 | 2012-03-01 | 2012-03-01 | NA | ||||||
| UK | 0X8351 | S82537 | Eligibility PD only | 2012-03-01 | 2012-03-01 | 2012-03-01 | NA | NA | ||||||
| Japan | 0X8354 | S41890 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8354 | S78168 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X8420 | S26836 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X8517 | S83589 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X8517 | S95593 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X8616 | S23054 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X8625 | S23661 | Eligibility PD only | 2012-01-01 | 2012-01-01 | 2012-01-01 | NA | NA | ||||||
| US | 0X8625 | S43474 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X8625 | S72389 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X8625 | S72515 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| US | 0X8625 | S83058 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X8625 | S87145 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X8627 | S97281 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X8633 | S6557 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8633 | S98267 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8633 | S98371 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8764 | S36886 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8764 | S81402 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X8768 | S10259 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X8768 | S13775 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X8786 | S543 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X8786 | S59912 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X8786 | S78935 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8788 | S32336 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X8799 | S17055 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X8799 | S49125 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X8799 | S78836 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X8799 | S85279 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| US | 0X8835 | S50953 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8997 | S49686 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X8997 | S902 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| US | 0X9082 | S13636 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9142 | S3285 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9142 | S35834 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9142 | S61670 | Eligibility PD only | 2012-01-01 | 2012-03-01 | NA | NA | NA | ||||||
| Japan | 0X9142 | S9242 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9142 | S98820 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X9147 | S54437 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S10169 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S15030 | Eligibility PD only | 2012-02-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X9346 | S41608 | Eligibility PD only | 2012-02-01 | 2012-02-01 | NA | NA | NA | ||||||
| UK | 0X9346 | S41703 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S61441 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S69605 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S75690 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9346 | S93299 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X9360 | S36762 | Eligibility PD only | 2012-01-01 | 2012-01-01 | NA | NA | NA | ||||||
| Japan | 0X9360 | S6700 | Eligibility PD only | 2012-01-01 | 2012-02-01 | 2012-03-01 | NA | NA | ||||||
| Japan | 0X9360 | S75534 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9360 | S7833 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| US | 0X9395 | S82738 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X9414 | S24778 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X9414 | S24790 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9414 | S48329 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9418 | S19368 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X9516 | S58480 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X9516 | S69884 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X958 | S43843 | Eligibility PD only | 2012-01-01 | NA | NA | NA | NA | ||||||
| UK | 0X958 | S52438 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X958 | S56659 | Eligibility PD only | 2012-01-01 | 2012-01-01 | NA | NA | NA | ||||||
| UK | 0X958 | S66158 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X958 | S7395 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X958 | S98839 | Eligibility PD only | 2012-02-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X9580 | S10308 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| UK | 0X9580 | S58783 | Ineligible, Both Criteria | 2012-03-01 | NA | NA | NA | NA | ||||||
| UK | 0X9604 | S24457 | Ineligible, Both Criteria | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X9604 | S63767 | Eligibility PD only | 2012-03-01 | 2012-03-01 | NA | NA | NA | ||||||
| UK | 0X9661 | S46920 | Eligibility PD only | 2012-03-01 | NA | NA | NA | NA | ||||||
| Japan | 0X9737 | S20971 | EDC I/E only | NA | NA | NA | NA | NA | ||||||
| Japan | 0X9737 | S88083 | Eligibility PD only | 2012-02-01 | NA | NA | NA | NA | ||||||
| UK | 0X9858 | S60652 | EDC I/E only | NA | NA | NA | NA | NA |