1 / 45

CDISC Integration in OC/RDC for Real-time SDTM Datasets

Learn how to generate real-time SDTM datasets and metadata using a generic SDTM converter mechanism in OC/RDC. CDASH/SDTM standards integration details. Presented by Peter Van Reusel, CRO Services Business Unit Director.

carlahead
Download Presentation

CDISC Integration in OC/RDC for Real-time SDTM Datasets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CDISC (CDASH/SDTM) integration into OC/RDC Generation of real-time SDTM datasets and metadata through a generic SDTM converter mechanism Peter Van Reusel Business Unit Director CRO Services Business & Decision Life Sciences Tel +32 2 774 11 00 Fax +32 2 774 11 99 Mobile +32 476 54 59 17 peter.vanreusel@businessdecision.com Sint-Lambertusstraat141 Rue Saint-Lambert 1200 Brussels www.businessdecision-lifesciences.com

  2. Agenda 1 Introduction 2 CDASH/SDTM in OC/RDC 3 SDTM Converter Mechanism 4 Conclusion

  3. Agenda 1 Introduction 2 CDASH/SDTM in OC/RDC 3 SDTM Converter Mechanism 4 Conclusion

  4. CDISC organization Clinical Data Interchange Standards Consortium CDISC started in 1999 Is a non-profit organization Data models are created by industry volunteers Mission: to develop & support global, platform-independent data standards that enable information system interoperability to improve medical research & related areas of healthcare http://www.cdisc.org

  5. CDISC models CDASH B R I D G / HL7 SDTM ADaM Define.xml CRT-DDS

  6. Near Term Approach: Legacy Data Conversion

  7. Longer Term Approach: Global CDISC Integration

  8. Agenda 1 Introduction 2 CDASH/SDTM in OC/RDC 3 SDTM Converter Mechanism 4 Conclusion

  9. CDISC integration objectives To integrate global CDISC standards in OC/RDC Use CDISC nomenclature across the CDM system Ensure metadata consistency Use of CDISC controlled terminology Avoid additional data conversion steps Generate SDTM data as of study start Production of real-time SDTM deliverables Facilitate generation of ADaM datasets based on SDTM Allow CDISC consistency checking early in the process

  10. CDISC data model

  11. OC/RDC system set-up Metadata definition: Create metadata specifications OC level: Define DCM, DCI and DCI books External data upload RDC level: Patient data entry OC level: OC extract creation and output

  12. Additional CDISC integration set-up Metadata definition: Create metadata specifications OC level: Use CDASH/SDTM variables Define DCM, DCI and DCI books External data upload RDC level: Patient data entry OC level: OC extract creation and output SDTM converter level: CDISC (CDASH/SDTM) standards library and business rules SDTM converter mechanism Generation of SDTM datasets, metadata and reports/warnings

  13. OC level: Use CDASH/SDTM variables Define in Global Library: DVGs (SDTM controlled terminology/SAS formats) Questions (CDASH/SDTM variables) Questions groups (SAS datasets)

  14. OC level: Define DCM, DCI & DCI books Define at the study level: DCM (collection of QGs) DCI (collection of DCMs) DCI books Create default view definitions (O*C extracts)

  15. OC level: set-up rules & naming conventions Kept to a minimum Use CDASH/SDTM variables ONLY except – Rename &DOMAIN.TESTCD  &DOMAIN.TSTC Rename &DOMAIN.ORRES  &DOMAIN.ORES Use of extended attribute DVG_LONG_VALUE in &DOMAIN.TSTC (Testcode) to populate TEST All Non CDASH/Non SDTM variables populate SUPP datasets Potential use of extended attributes for numeric values (to produce SDTM+)

  16. Data flow for e.g. Demography

  17. Data flow for e.g. Demography

  18. Agenda 1 Introduction 2 CDASH/SDTM in OC/RDC 3 SDTM Converter Mechanism 4 Conclusion

  19. SDTM Conversion – High Level Perspective

  20. Data flow for Demography

  21. Data flow for Adverse Experiences

  22. SDTM converter input: CDISC standards library Used by SDTM converter to interpret standard source or system variables i.e., SDTM or CDASH or OC system Metadata SDTM variables Metadata CDASH variables Metadata OC system variables

  23. SDTM converter input: CDISC standards library Used by SDTM converter to interpret standard source or system variables i.e., SDTM, CDASH or OC system

  24. SDTM converter input: Short list of business rules Defines generic SDTM conversion choices:

  25. SDTM converter input: Parameter database Define project paths in a Central Parameter Table

  26. SDTM converter input: Short list of default values A default (and editable) value table is used by the SDTM converter

  27. SDTM conversion – high level perspective

  28. SDTM converter mechanism What is it? A mechanism based on Base SAS code (DI Studio) Functionalities: ISO 8601 data transformation Automatic transpose for findings Global transformations Domain specific transformations Generate SEQ variable Extract TEST from DVG for TESTCD Create Supplementary Datasets Create Comment Dataset Create SDTM Dataset …

  29. ISO 8601 date transformation Rule - Converts variables ending with DAT & TIM in ISO 8601 date format

  30. Automatic transpose for findings Rule - Transposes finding variables TESTCD and corresponding results. Puts records of variables ending with the same number together

  31. Global transformations Rule - Compute values based on rules in business rule sheet

  32. Domain specific transformations Rule - Populate variables with values specified in default value sheet DCM Name QG Domain Variable Default Value EX1EX1 EX1 EX EXTRT “DRUG A” EX1EX1 EX1 EX EXDOSE 20 EX2EX2 EX2 EX EXTRT “DRUG B” EX2EX2 EX2 EX EXDOSE 40

  33. Generate SEQ variable Rule – Generate SEQ variable based on Keys specified in Table Level Metadata in the CDISC Standards Library • Rule - For custom domains use the following: • Event: --TERM, -- STDTC • Intervention: --TRT, --STDTC • Finding: --TESTCD, VISITNUM, TPTNUM, --DTC

  34. Extract TEST from DVG for TESTCD Rule - Populates TEST by extracting DVG long value of TESTCD Vertical structure: • Horizontal structure:

  35. Create Supplementary Datasets Rule - Non-CDASH/Non-SDTM/Non-OC System variables to populate supplementary datasets

  36. Create Comment Dataset Rule - Collect comments in OC in &DOMAIN._COVAL variable

  37. Create SDTM Dataset Rule – Use variable level attributes from the CDISC standards library

  38. SDTM conversion – high level perspective

  39. SDTM converter output: Reports and Warnings Data profile reports of the SDTM generated datasets.

  40. SDTM converter output: Reports and Warnings Warning reports: includes basic checks for conformance with the CDISC domain models: Including all required and expected variables as columns in a domain Using CDISC-specified standard variable names Using CDISC-specified data types for all variables Etc. These conformance checks are a subset of the complete set of CDISC SDTM compliance checks

  41. SDTM converter output: Metadata Table Metadata Variable Metadata Controlled Terminology Value Level Metadata Computational Algorithms

  42. Agenda 1 Introduction 2 CDASH/SDTM in OC/RDC 3 SDTM Converter Mechanism 4 Conclusion

  43. Conclusion Maximize use of CDASH and SDTM variables Use CDISC controlled terminology Through smart set-up in OC, automate SDTM generation through a generic SDTM converter mechanism No SDTM conversion required in OC/RDC; occurs outside OC/RDC No additional programming is required within OC Real-time SDTM datasets and metadata, ready for analysis

  44. Thank you for your attention Peter Van Reusel Business Unit Director CRO Services Business & Decision Life Sciences Tel +32 2 774 11 00 Fax +32 2 774 11 99 Mobile +32 476 54 59 17 peter.vanreusel@businessdecision.com Sint-Lambertusstraat141 Rue Saint-Lambert 1200 Brussels www.businessdecision-lifesciences.com

More Related