Activities:
Near match across tables
Near match, different parent
|
Annotations:
3 click for the text
in Unified Annotations: show where it applies
|
Cells:
Common
Prediabetes only
Main Schedule (24 columns)
| Activity | In | Table 1 | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Visit1 [visit] L1 | 1 | 2 | 32 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 993 | ED4 | 8015 | |
| Week of Treatment [week] L2 | -2 | -1 | 0 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48 | 52 | 56 | 60 | 64 | 68 | 72 | 72 | 4 wks Post TxP | ||
| Allowable Deviation (days)6 [window] | ±3 | ±3 | ±3 | +7 | ±3 | +7 | ±3 | ±3 | ±3 | ±3 | +7 | ±3 | ±3 | ±3 | ±3 | ±3 | ±3 | ±3 | ±3 | ±7 | ±7 | ±3 | |||
| Fasting Visit1 [visit_attribute] | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||
| Telephone Visit [modality] | X | X | X | X | X | X | X | X | |||||||||||||||||
| Informed consent | T1 | X | |||||||||||||||||||||||
| Randomization | T1 | X | |||||||||||||||||||||||
| Register study visit in IWRS | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Clinical Assessments | T1,T2 | ||||||||||||||||||||||||
| Medical history7 | T1 | X | |||||||||||||||||||||||
| Physical examination | T1 | X | |||||||||||||||||||||||
| Height | T1 | X | |||||||||||||||||||||||
| Weight8 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||
| Waist circumference | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||
| Electrocardiogram9 | T1,T2 | X | X | X | X | X | X | X | X | ||||||||||||||||
| Vital signs (3 sitting BP and HR)10 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||
| Adverse events and product complaints | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Concomitant medications | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Participant Education and Assessment | T1,T2 | ||||||||||||||||||||||||
| Hand out diary, instruct in use11 | T1,T2 | X | X | X | X | X | X | X | |||||||||||||||||
| Review study participant diary, including study-drug compliance12 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||
| Lifestyle Program instructions13 | T1,T2 | X | X | X | X | X | X | X | X | X | X | ||||||||||||||
| Review diet and exercise goals14 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||
| Injection training with autoinjector demonstration device15 | T1 | X | |||||||||||||||||||||||
| Dispense study drug | T1,T2 | X | X | X | X | X | X | X | X | X | X | X16 | |||||||||||||
| Observe participant administer study drug17 | T1 | X | |||||||||||||||||||||||
| Participant returns study drugs and injection supplies | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||
| Laboratory Tests | T1,T2 | ||||||||||||||||||||||||
| Serum pregnancy test18 | T1 | X | |||||||||||||||||||||||
| Urine pregnancy test19 | T1,T2 | X | X | X | X | X | X | X | X | X | |||||||||||||||
| Follicle-stimulating hormone test20 | T1 | X | |||||||||||||||||||||||
| 2-hour oral glucose tolerance test (includes glucose, insulin, c-peptide at each timepoint)21 | T1,T2 | X | X | X | |||||||||||||||||||||
| Chemistry panel (include Cr for eGFR calculation and glucose)23 | T1,T2 | X | X | X | X | X | X | X | X | X | X | ||||||||||||||
| Lipid panel | T1,T2 | X | X | X | X | X | X | ||||||||||||||||||
| Fasting insulin | T1 | X | X | X | X | X | X | X | X | ||||||||||||||||
| C-peptide | T1 | X | X | X | X | X | X | X | X | ||||||||||||||||
| Free fatty acids | T1,T2 | X | X | X | X | X | X | ||||||||||||||||||
| Urinary albumin/creatinine | T1,T2 | X22 | X | X | X | X | |||||||||||||||||||
| Cystatin-c | T1,T2 | X22 | X | X | X | X | |||||||||||||||||||
| Calcitonin | T1,T2 | X22 | X | X | X | X | X | ||||||||||||||||||
| Hematology | T1,T2 | X22 | X | X | X | X | X | ||||||||||||||||||
| HbA1c | T1,T2 | X | X | X | X | X | X | X | X | X | X | ||||||||||||||
| Pancreatic amylase, lipase | T1,T2 | X | X | X | X | X | X | X | |||||||||||||||||
| Thyroid-stimulating hormone | T1 | X22 | |||||||||||||||||||||||
| Immunogenicity (includes PK sample)24 | T1,T2 | X | X | X | X | X | X | X | X | ||||||||||||||||
| TZP PK25 | T1 | X | X | X | |||||||||||||||||||||
| Pharmacogenetic stored sample | T1 | X | |||||||||||||||||||||||
| Nonpharmacogenetic stored sample | T1,T2 | X | X | X | X | X | X | X | |||||||||||||||||
| Mental Health Questionnaires | T1,T2 | ||||||||||||||||||||||||
| PHQ-926 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||
| C-SSRS (Baseline/Screening) Version)26 | T1 | X | |||||||||||||||||||||||
| C-SSRS (Since Last Visit Version)26 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| Self-Harm Supplement Form26 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Self-Harm Follow-up Form27 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Patient Reported Outcomes | T1 | ||||||||||||||||||||||||
| PGIS | T1,T2 | X | X | X | |||||||||||||||||||||
| SF-36, version 2, acute form | T1,T2 | X | X | X | |||||||||||||||||||||
| IWQOL-Lite CT | T1,T2 | X | X | X | |||||||||||||||||||||
| EQ-5D-5L | T1,T2 | X | X | X | |||||||||||||||||||||
| PROs | T2 | ||||||||||||||||||||||||
Track Timelines: Prediabetes (19 columns)
| Activity | In | Table 2 | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | Prediabetes | ||
| Visit1 [visit] L1 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 1993 | ED4 | 8025 | |
| Week of Treatment [week] L2 | 78 | 85 | 91 | 98 | 104 | 111 | 117 | 124 | 130 | 137 | 143 | 150 | 156 | 163 | 169 | 176 | 176 | 17 wks Post TxP | ||
| Telephone Visit [modality] | X | X | X | X | X | X | X | X | ||||||||||||
| Fasting Visit1 [visit_attribute] | X | X | X | X | X | X | X | X | X | X | X | |||||||||
| Allowable Deviation (days)6 [window] | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±7 | ±3 | ||
| Register study visit in IWRS | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Clinical Assessments | T1,T2 | |||||||||||||||||||
| Weight8 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | ||||||||
| Waist circumference | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | ||||||||
| Electrocardiogram9 | T1,T2 | X | X | X | X | |||||||||||||||
| Vital signs (3 sitting BP and HR)10 | T1,T2 | X | X | X | X | X | X | X | X | X | X | |||||||||
| Adverse events and product complaints | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Concomitant medications | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Participant Education and Assessment | T1,T2 | |||||||||||||||||||
| Hand out diary, instruct in use11 | T1,T2 | X | X | X | X | X | X | X | ||||||||||||
| Review study participant diary, including study-drug compliance12 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||
| Lifestyle Program instructions13 | T1,T2 | X | X | X | X | X | X | X | X | X | ||||||||||
| Review diet and exercise goals14 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||
| Dispense study drug | T1,T2 | X | X | X | X | X | X | X | ||||||||||||
| Participant returns study drugs and injection supplies | T1,T2 | X | X | X | X | X | X | X | X | X | ||||||||||
| Laboratory Tests | T1,T2 | |||||||||||||||||||
| Urine pregnancy test19 | T1,T2 | X | X | X | X | X | X | X | X | X | ||||||||||
| 2-hour oral glucose tolerance test (includes glucose, insulin, c-peptide at each timepoint)21 | T1,T2 | X | X | X | X | X | ||||||||||||||
| Chemistry panel (include Cr for eGFR calculation and glucose)23 | T1,T2 | X | X | X | X | X | X | X | X | X | X | |||||||||
| Lipid panel | T1,T2 | X | X | X | X | |||||||||||||||
| Free fatty acids | T1,T2 | X | X | X | X | |||||||||||||||
| Urinary albumin/creatinine | T1,T2 | X | X | X | X | |||||||||||||||
| Cystatin-c | T1,T2 | X | X | X | X | |||||||||||||||
| Calcitonin | T1,T2 | X | X | X | X | |||||||||||||||
| Hematology | T1,T2 | X | X | X | X | |||||||||||||||
| HbA1c | T1,T2 | X | X | X | X | X | X | X | X | X | X | |||||||||
| Pancreatic amylase, lipase | T1,T2 | X | X | X | X | |||||||||||||||
| Immunogenicity (includes PK sample)24 | T1,T2 | X | X | X | X | X | X | |||||||||||||
| Nonpharmacogenetic stored sample | T1,T2 | X | X | X | X | |||||||||||||||
| Mental Health Questionnaires | T1,T2 | |||||||||||||||||||
| PHQ-926 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | ||||||||
| C-SSRS (Since Last Visit Version)26 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Self-Harm Supplement Form26 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Self-Harm Follow-up Form27 | T1,T2 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Patient Reported Outcomes | T1 | |||||||||||||||||||
| PGIS | T1,T2 | X | X | X | ||||||||||||||||
| SF-36, version 2, acute form | T1,T2 | X | X | X | ||||||||||||||||
| IWQOL-Lite CT | T1,T2 | X | X | X | ||||||||||||||||
| EQ-5D-5L | T1,T2 | X | X | X | ||||||||||||||||
| PROs | T2 | |||||||||||||||||||
Matches across tables
all 7 decided
Rows that consolidation merged on name similarity, or kept separate from a near match. Whether two rows are the same activity is the reviewer's call: choosing drafts an entry for
NCT04184622_consolidation_corrections.json below; nothing is saved from here. Rows merged on an identical name are not listed. Words that only one of the two names prints are marked; the score ignores case, hyphens, slashes, text in parentheses and plural endings.| state | row | consolidation | other row | activity | decision |
|---|---|---|---|---|---|
| decided · ccorr-001 keep | T2 act-007 Adverse events/Product Complaints | merged with 0.92 | T1 act-012 Adverse events and product complaints | xact-012 | '/' for 'and'; same row. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-002 keep | T2 act-011 Review study participant diary, including study drug compliance | merged with 1.00 | T1 act-016 Review study participant diary, including study-drug compliance | xact-016 | Hyphen only; the same note n12 on both rows. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-003 keep | T2 act-018 2 hour oral glucose tolerance test (includes glucose, insulin, c-peptide) | merged with 1.00 | T1 act-027 2-hour oral glucose tolerance test (includes glucose, insulin, c-peptide at each timepoint) | xact-027 | Same test; the same note n21 on both rows. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-004 keep | T2 act-019 Chemistry panel (includes Cr for eGFR calculation and glucose) | merged with 1.00 | T1 act-028 Chemistry panel (include Cr for eGFR calculation and glucose) | xact-028 | 'includes' for 'include'; the same note n23 on both rows. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-005 keep | T2 act-022 Urinary albumin/creatinine ratio | merged with 0.90 | T1 act-033 Urinary albumin/creatinine | xact-033 | Same row; Table 2 adds the word 'ratio'. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-006 keep | T2 act-037 SF-36, version 2 acute | merged with 0.90 | T1 act-052 SF-36, version 2, acute form | xact-052 | Same instrument; the parent 'PROs' is 'Patient Reported Outcomes' abbreviated. Kerstin Forsberg, 2026-10-04T08:20:00Z |
| decided · ccorr-007 keep | T2 act-038 IWQOL-Lite -CT | merged with 1.00 | T1 act-053 IWQOL-Lite CT | xact-053 | Hyphen only; the parent 'PROs' is 'Patient Reported Outcomes' abbreviated. Kerstin Forsberg, 2026-10-04T08:20:00Z |
Draft — entries to append to
consolidated/NCT04184622_consolidation_corrections.json; replace each <why>, then re-run consolidation.
Consolidation Metadata
Process information
| consolidated_at | 2026-10-04T08:21:20.242337+00:00 |
| source_activity_count | 93 |
| unified_activity_count | 55 |
| compression_percent | 41 |
| match_stats | exact: 31, fuzzy_auto: 5, fuzzy_cross_parent: 2, new: 55 |
Source Tables
2 tables
| table | type | track | title / purpose | acts | cols | props |
|---|---|---|---|---|---|---|
| T1 | main_soa | Schedule of Activities covering visits to primary study endpoint Main 72-week treatment schedule (screening, treatment to primary endpoint at Week 72, Visit 99, early discontinuation and safety follow-up Visit 801) for all participants. |
54 | 24 | 5 | |
| T2 | track | Prediabetes | Schedule of Activities for additional 2-year treatment period for participants with prediabetes at randomization Additional 2-year treatment period (Weeks 78-176, Visits 101-116, 199, ED, 802) for participants with prediabetes at randomization only. |
39 | 19 | 5 |
Unified Activities
55 activities
| xact_id | activity_name (variations) | parent | match | # | tables | row kind |
|---|---|---|---|---|---|---|
| xact-001 | Informed consent | one table | 1 | T1 | ||
| xact-002 | Randomization | one table | 1 | T1 | ||
| xact-003 | Register study visit in IWRS | same name | 2 | T1, T2 | ||
| xact-004 | Clinical Assessments | same name | 2 | T1, T2 | section | |
| xact-005 | Medical history | Clinical Assessments | one table | 1 | T1 | |
| xact-006 | Physical examination | Clinical Assessments | one table | 1 | T1 | |
| xact-007 | Height | Clinical Assessments | one table | 1 | T1 | |
| xact-008 | Weight | Clinical Assessments | same name | 2 | T1, T2 | |
| xact-009 | Waist circumference | Clinical Assessments | same name | 2 | T1, T2 | |
| xact-010 | Electrocardiogram | Clinical Assessments | same name | 2 | T1, T2 | |
| xact-011 | Vital signs (3 sitting BP and HR) | Clinical Assessments | same name | 2 | T1, T2 | |
| xact-012 | Adverse events and product complaints ≈ Adverse events/Product Complaints |
Clinical Assessments | near match, accepted | 2 | T1, T2 | |
| xact-013 | Concomitant medications | Clinical Assessments | same name | 2 | T1, T2 | |
| xact-014 | Participant Education and Assessment | same name | 2 | T1, T2 | section | |
| xact-015 | Hand out diary, instruct in use | Participant Education and Assessment | same name | 2 | T1, T2 | |
| xact-016 | Review study participant diary, including study-drug compliance ≈ Review study participant diary, including study drug compliance |
Participant Education and Assessment | near match, accepted | 2 | T1, T2 | |
| xact-017 | Lifestyle Program instructions | Participant Education and Assessment | same name | 2 | T1, T2 | |
| xact-018 | Review diet and exercise goals | Participant Education and Assessment | same name | 2 | T1, T2 | |
| xact-019 | Injection training with autoinjector demonstration device | Participant Education and Assessment | one table | 1 | T1 | |
| xact-020 | Dispense study drug | Participant Education and Assessment | same name | 2 | T1, T2 | |
| xact-021 | Observe participant administer study drug | Participant Education and Assessment | one table | 1 | T1 | |
| xact-022 | Participant returns study drugs and injection supplies | Participant Education and Assessment | same name | 2 | T1, T2 | |
| xact-023 | Laboratory Tests | same name | 2 | T1, T2 | section | |
| xact-024 | Serum pregnancy test | Laboratory Tests | one table | 1 | T1 | |
| xact-025 | Urine pregnancy test | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-026 | Follicle-stimulating hormone test | Laboratory Tests | one table | 1 | T1 | |
| xact-027 | 2-hour oral glucose tolerance test (includes glucose, insulin, c-peptide at each timepoint) ≈ 2 hour oral glucose tolerance test (includes glucose, insulin, c-peptide) |
Laboratory Tests | near match, accepted | 2 | T1, T2 | |
| xact-028 | Chemistry panel (include Cr for eGFR calculation and glucose) ≈ Chemistry panel (includes Cr for eGFR calculation and glucose) |
Laboratory Tests | near match, accepted | 2 | T1, T2 | |
| xact-029 | Lipid panel | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-030 | Fasting insulin | Laboratory Tests | one table | 1 | T1 | |
| xact-031 | C-peptide | Laboratory Tests | one table | 1 | T1 | |
| xact-032 | Free fatty acids | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-033 | Urinary albumin/creatinine ≈ Urinary albumin/creatinine ratio |
Laboratory Tests | near match, accepted | 2 | T1, T2 | |
| xact-034 | Cystatin-c | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-035 | Calcitonin | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-036 | Hematology | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-037 | HbA1c | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-038 | Pancreatic amylase, lipase | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-039 | Thyroid-stimulating hormone | Laboratory Tests | one table | 1 | T1 | |
| xact-040 | Immunogenicity (includes PK sample) | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-041 | TZP PK | Laboratory Tests | one table | 1 | T1 | |
| xact-042 | Pharmacogenetic stored sample | Laboratory Tests | one table | 1 | T1 | |
| xact-043 | Nonpharmacogenetic stored sample | Laboratory Tests | same name | 2 | T1, T2 | |
| xact-044 | Mental Health Questionnaires | same name | 2 | T1, T2 | section | |
| xact-045 | PHQ-9 | Mental Health Questionnaires | same name | 2 | T1, T2 | |
| xact-046 | C-SSRS (Baseline/Screening) Version) | Mental Health Questionnaires | one table | 1 | T1 | |
| xact-047 | C-SSRS (Since Last Visit Version) | Mental Health Questionnaires | same name | 2 | T1, T2 | |
| xact-048 | Self-Harm Supplement Form | Mental Health Questionnaires | same name | 2 | T1, T2 | |
| xact-049 | Self-Harm Follow-up Form | Mental Health Questionnaires | same name | 2 | T1, T2 | |
| xact-050 | Patient Reported Outcomes | one table | 1 | T1 | section | |
| xact-051 | PGIS | Patient Reported Outcomes | same name | 2 | T1, T2 | |
| xact-052 | SF-36, version 2, acute form ≈ SF-36, version 2 acute |
Patient Reported Outcomes / PROs | near match, different parent | 2 | T1, T2 | |
| xact-053 | IWQOL-Lite CT ≈ IWQOL-Lite -CT |
Patient Reported Outcomes / PROs | near match, different parent | 2 | T1, T2 | |
| xact-054 | EQ-5D-5L | Patient Reported Outcomes | same name | 2 | T1, T2 | |
| xact-055 | PROs | one table | 1 | T2 | section |
Unified Annotations
27 annotations (40% dedup from 45)
Footnote (27)