CDISC ODM 1.3.0

Purpose

(Source: CDISC Web site http://www.cdisc.org/odm)
The CDISC ODM standard facilitates the archival and interchange of the metadata and data for clinical research. ODM is a vendor-neutral, platform-independent format for the interchange and archival of clinical study data. ODM includes the clinical data and its associated metadata, administrative data, reference data, and audit information. All of the information that needs to be shared during setup, operation, analysis, and submission, as well as for long-term retention as part of an archive, is included in ODM.

Release Date

CDISC ODM, Version 1.3.0, December 15, 2006

CDISC ODM 1.3.0 Reference Standard

SAS Clinical Standards Toolkit 1.3 provides only partial support of CDISC ODM 1.3.0. The current release of SAS Clinical Standards Toolkit supports reading an odm.xml file, and translating the metadata (<Study>) and clinical data (<ClinicalData>) sections of the odm.xml file into a SAS representation. The domain and column metadata that constitute the SAS representation of CDISC ODM 1.3.0 are derived from the global standards library in these formats:
  • as empty data sets (using the utility macro cst_createTablesForDataStandard)
  • as table metadata for 52 data sets (reference_tables in the standard metadata folder (see the example in the following table))
  • as column metadata for 241 columns in the 52 data sets (reference_columns in the standard metadata folder (see the example in Sample Reference_Columns Record (CDISC ODM 1.3.0)))
Sample Reference_Tables Record (CDISC ODM 1.3.0)
Column Name
Column Value
sasref
REFDATA
table
ItemGroupData
label
Item group-level data information
keys
OID
standard
CDISC-ODM
standardversion
1.3.0
standardref
comment
xmlelementname
ItemGroupData
class
ItemGroupData
Sample Reference_Columns Record (CDISC ODM 1.3.0)
Column Name
Column Value
sasref
REFDATA
table
SubjectData
column
SubjectKey
label
Uniquely identifies a subject in a study
order
2
type
C
length
2000
displayformat
$2000.
standard
CDISC-ODM
standardversion
1.3.0
standardref
comment
core
Req
xmlcodelist
qualifier
As a general rule, the SAS representation of the CDISC ODM standard is patterned to match the XML element (data set) and attribute (column) structure of odm.xml. For example, consider the following XML extract:
<ClinicalData StudyOID="P2006-101" MetadataVersionOID="101.01">
 <SubjectData SubjectKey="1000" TransactionType="Insert">
  <StudyEventData StudyEventOID="101.Screen">
   <FormData FormOID="101.DEMOG">
    <ItemGroupData ItemGroupOID="101.DM">
     <ItemDataString ItemOID="101.USUBJID">101-01-01</ItemDataString>
     <ItemDataString ItemOID="101.SEX">F</ItemDataString>
    </ItemGroupData>
   </FormData>
  </StudyEventData>
 </SubjectData>
</ClinicalData>
The following table describes how the XML element and attribute information maps to the SAS representation.
Sample Mapping of odm.xml File to SAS Representation
XML Element or Attribute
SAS Data Set
SAS Column
SAS Column Value
<ClinicalData StudyOID="P2006-101" MetadataVersionOID="101.01">
ClinicalData
StudyOID
MetaDataVersionOID
"P2006-101"
"101.01"
<SubjectData SubjectKey="1000" TransactionType="Insert">
SubjectData
SubjectKey
TransactionType
"1000"
"Insert"
<StudyEventData StudyEventOID="101.Screen">
StudyEventData
StudyEventOID
"101.Screen"
<FormData FormOID="101.DEMOG">
FormData
FormOID
"101.DEMOG"
<ItemGroupData ItemGroupOID="101.DM">
ItemGroupData
ItemGroupOID
"101.DM"
<ItemDataString ItemOID="101.USUBJID">101-01-01</ItemDataString>
ItemData
ItemOID
ItemDataType
Value
"101.USUBJID"
"ItemDataString"
"101-01-01"
<ItemDataString ItemOID="101.SEX">F</ItemDataString>
ItemData
ItemOID
ItemDataType
Value
"101.SEX"
"ItemDataString"
"F"
The following table lists the complete set of 52 tables that form the SAS Clinical Standards Toolkit SAS representation of the CDISC ODM 1.3.0 standard.
Data Sets in the SAS Representation of the CDISC ODM 1.3.0 Standard
Table
Table
Annotations
ItemMURefs
AuditRecords
ItemQuestionExternal
CLItemDecodeTranslatedText
ItemQuestionTranslatedText
ClinicalData
ItemRCFormalExpression
CodeListItems
ItemRangeCheckValues
CodeLists
ItemRangeChecks
ConditionDefFormalExpression
ItemRole
ConditionDefTranslatedText
MUTranslatedText
ConditionDefs
MeasurementUnits
EnumeratedItems
MetaDataVersion
ExternalCodeLists
MethodDefFormalExpression
FormData
MethodDefTranslatedText
FormDefArchLayouts
MethodDefs
FormDefItemGroupRefs
ODM
FormDefTranslatedText
Presentation
FormDefs
ProtocolEventRefs
ImputationMethods
ProtocolTranslatedText
ItemAliases
RCErrorTranslatedText
ItemData
ReferenceData
ItemDefTranslatedText
SignatureDefs
ItemDefs
Signatures
ItemGroupAliases
Study
ItemGroupData
StudyEventData
ItemGroupDefItemRefs
StudyEventDefs
ItemGroupDefTranslatedText
StudyEventFormRefs
ItemGroupDefs
SubjectData
The highly structured nature of CDISC ODM data requires that any mapping to a relational format include a large number of data sets, with foreign key relationships to help preserve the intended non-relational object structure. In the SAS Clinical Standards Toolkit, foreign key relationships are enforced when validating the CDISC ODM data sets.
Field lengths in the CDISC ODM data sets are consistent by core data type. CDISC has not specified any limit to the length of most character fields. Arbitrary lengths have been chosen by data type. These lengths are listed in the following table. In the table, standard data types are distilled into core data types. To be safe, larger lengths have been chosen to ensure that no data loss occurs in the SAS Clinical Standards Toolkit pre-installed data sets. Production tables might be compressed using SAS mechanisms to preserve disk space.
CDISC ODM Default Lengths by Data Type
Type Name
Length
Description
oid
128
A unique object identifier or a reference
text
2000
A character field that can accommodate a large number of characters
name
128
A descriptive identifier
value
512
An item of collected or reference data
path
512
An absolute or relative file system path or URL
The table metadata for the 52 data sets and the column metadata for the 241 columns in those data sets that comprise the SAS representation of the CDISC ODM 1.3.0 standard are in the following folder:
<global standards library directory>/standards/cdisc-odm-1.3.0-1.3/metadata.
Table metadata is in reference_tables.sas7bdat, and column metadata is in reference_columns.sas7bdat.
In the future, the CDISC ODM reference standard will support reading and representing in SAS a complete odm.xml file, building an odm.xml file, and validating the structure and content of the SAS representation of an odm.xml file. In addition, it will validate the structural integrity of the odm.xml file. To support this functionality, supplemental files include the following global standards library files:
  • The Messages data set in the messages folder provides error messaging for all Validation Master checks.
  • SAS code in the macros folder provides CDISC ODM-specific code that augments code that is provided in the primary SAS Clinical Standards Toolkit autocall library (!sasroot/cstframework/sasmacro).
It is this set of files, in whole or in part, that defines the CDISC ODM reference standard.