Validation Checks

The following table provides a complete list of all CDISC CRT-DDS 1.0 validation checks.
Validation Checks
checkid
checktype
tablescope
columnscope
messagetext
CRT0100
Structural
CodeListItems
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
CodeLists
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ComputationMethods
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
DefineDocument
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
FormDefArchLayouts
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
FormDefs
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ImputationMethods
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ItemDefs
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ItemGroupDefs
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ItemGroupLeaf
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ItemRangeChecks
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
MDVLeaf
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
MeasurementUnits
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
MetadataVersion
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
Presentation
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
Study
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
StudyEventDefs
No two values for the source column can be equivalent within the same source data set.
CRT0100
Structural
ValueLists
No two values for the source column can be equivalent within the same source data set.
CRT0101
Content
AnnotatedCRFs
Data is required for this field.
CRT0101
Content
CLItemDecodeTranslatedText
Data is required for this field.
CRT0101
Content
CodeListItems
Data is required for this field.
CRT0101
Content
CodeLists
Data is required for this field.
CRT0101
Content
ComputationMethods
Data is required for this field.
CRT0101
Content
DefineDocument
Data is required for this field.
CRT0101
Content
ExternalCodeLists
Data is required for this field.
CRT0101
Content
FormDefArchLayouts
Data is required for this field.
CRT0101
Content
FormDefItemGroupRefs
Data is required for this field.
CRT0101
Content
FormDefs
Data is required for this field.
CRT0101
Content
ImputationMethods
Data is required for this field.
CRT0101
Content
ItemAliases
Data is required for this field.
CRT0101
Content
ItemDefs
Data is required for this field.
CRT0101
Content
ItemGroupAliases
Data is required for this field.
CRT0101
Content
ItemGroupDefItemRefs
Data is required for this field.
CRT0101
Content
ItemGroupDefs
Data is required for this field.
CRT0101
Content
ItemGroupLeaf
Data is required for this field.
CRT0101
Content
ItemGroupLeafTitles
Data is required for this field.
CRT0101
Content
ItemMURefs
Data is required for this field.
CRT0101
Content
ItemQuestionExternal
Data is required for this field.
CRT0101
Content
ItemQuestionTranslatedText
Data is required for this field.
CRT0101
Content
ItemRangeCheckValues
Data is required for this field.
CRT0101
Content
ItemRangeChecks
Data is required for this field.
CRT0101
Content
ItemRole
Data is required for this field.
CRT0101
Content
ItemValueListRefs
Data is required for this field.
CRT0101
Content
MDVLeaf
Data is required for this field.
CRT0101
Content
MDVLeafTitles
Data is required for this field.
CRT0101
Content
MUTranslatedText
Data is required for this field.
CRT0101
Content
MeasurementUnits
Data is required for this field.
CRT0101
Content
MetaDataVersion
Data is required for this field.
CRT0101
Content
Presentation
Data is required for this field.
CRT0101
Content
ProtocolEventRefs
Data is required for this field.
CRT0101
Content
RCErrorTranslatedText
Data is required for this field.
CRT0101
Content
Study
Data is required for this field.
CRT0101
Content
StudyEventDefs
Data is required for this field.
CRT0101
Content
StudyEventFormRefs
Data is required for this field.
CRT0101
Content
SupplementalDocs
Data is required for this field.
CRT0101
Content
ValueListItemRefs
Data is required for this field.
CRT0101
Content
ValueLists
Data is required for this field.
CRT0106
Content
CLItemDecodeTranslatedText
lang
The data in the &_cstparm1 field is improperly constructed. Must be in the form [A-Za-z-0-9].
CRT0106
Content
ItemQuestionTranslatedText
lang
The data in the &_cstparm1 field is improperly constructed. Must be in the form [A-Za-z-0-9].
CRT0106
Content
MUTtranslatedText
lang
The data in the &_cstparm1 field is improperly constructed. Must be in the form [A-Za-z-0-9].
CRT0106
Content
Presentation
lang
The data in the &_cstparm1 field is improperly constructed. Must be in the form [A-Za-z-0-9].
CRT0106
Content
RCErrorTranslatedText
lang
The data in the &_cstparm1 field is improperly constructed. Must be in the form [A-Za-z-0-9].
CRT0107
Content
FormDefArchLayouts
PdfFileName
The data in the &_cstparm1 field is an improperly constructed filename. Must be in the form [A-Za-z0-9_.].
CRT0108
Content
ItemDefs
SASFieldName SDSVarName
The data in the &_cstparm1 field is an improperly constructed SAS name. Must be in the form [A-Za-z0-9_].
CRT0108
Content
ItemGroupDefs
SASDatasetName
The data in the &_cstparm1 field is an improperly constructed SAS name. Must be in the form [A-Za-z0-9_].
CRT0109
Content
CodeLists
SASFormatName
The data in the &_cstparm1 field is an improperly constructed SAS format name. Must be in the form [($)A-Za-z0-9_].
CRT0110
Content
[AnnotatedCRFs] [MDVLeaf]
[AnnotatedCRFs.leafID] [MDVLeaf.ID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[AnnotatedCRFs] [MetaDataVersion]
[AnnotatedCRFs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[CLItemDecodeTranslatedText] [CodeListItems]
[CLItemDecodeTranslatedText.FK_CodeListItems] [CodeListItems.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[CodeListItems] [CodeLists]
[CodeListItems.FK_CodeLists] [CodeLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[CodeLists] [MetaDataVersion]
[CodeLists.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ComputationMethods] [MetaDataVersion]
[ComputationMethods.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ExternalCodeLists] [CodeLists]
[ExternalCodeLists.FK_CodeLists] [CodeLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[FormDefArchLayouts] [FormDefs]
[FormDefArchLayouts.FK_FormDefs] [FormDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[FormDefArchLayouts] [Presentation]
[FormDefArchLayouts.PresentationOID] [Presentation.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[FormDefItemGroupRefs] [FormDefs]
[FormDefItemGroupRefs.FK_FormDefs] [FormDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[FormDefItemGroupRefs] [ItemGroupDefs]
[FormDefItemGroupRefs.ItemGroupOID] [ItemGroupDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[FormDefs] [MetaDataVersion]
[FormDefs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1; does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ImputationMethods] [MetaDataVersion]
[ImputationMethods.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemAliases] [ItemDefs]
[ItemAliases.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemDefs] [CodeLists]
[ItemDefs.CodeListRef] [CodeLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemDefs] [ComputationMethods]
[ItemDefs.ComputationMethodOID] [ComputationMethods.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemDefs] [MetaDataVersion]
[ItemDefs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupAliases] [ItemGroupDefs]
[ItemGroupAliases.FK_ItemGroupDefs] [ItemGroupDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupDefItemRefs] [CodeLists]
[ItemGroupDefItemRefs.RoleCodeListOID] [CodeLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupDefItemRefs] [ImputationMethods]
[ItemGroupDefItemRefs.ImputationMethodOID] [ImputationMethods.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupDefItemRefs] [ItemDefs]
[ItemGroupDefItemRefs.ItemOID] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupDefItemRefs] [ItemGroupDefs]
[ItemGroupDefItemRefs.FK_ItemGroupDefs] [ItemGroupDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupDefs] [MetaDataVersion]
[ItemGroupDefs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupLeafTitles] [ItemGroupLeaf]
[ItemGroupLeafTitles.FK_ItemGroupLeaf] [ItemGroupLeaf.ID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemGroupLeaf] [ItemGroupDefs]
[ItemGroupLeaf.FK_ItemGroupDefs] [ItemGroupDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemMURefs] [ItemDefs]
[ItemMURefs.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemMURefs] [MeasurementUnits]
[ItemMURefs.MeasurementUnitOID] [MeasurementUnits.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemQuestionExternal] [ItemDefs]
[ItemQuestionExternal.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemQuestionTranslatedText] [ItemDefs]
[ItemQuestionTranslatedText.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemRangeCheckValues] [ItemRangeChecks]
[ItemRangeCheckValues.FK_ItemRangeChecks] [ItemRangeChecks.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemRangeChecks] [ItemDefs]
[ItemRangeChecks.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemRangeChecks] [MeasurementUnits]
[ItemRangeChecks.MURefOID] [MeasurementUnits.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemRole] [ItemDefs]
[ItemRole.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemValueListRefs] [ItemDefs]
[ItemValueListRefs.FK_ItemDefs] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ItemValueListRefs] [ValueLists]
[ItemValueListRefs.ValueListOID] [ValueLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[MDVLeafTitles] [MDVLeaf]
[MDVLeafTitles.FK_MDVLeaf] [MDVLeaf.ID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[MDVLeaf] [MetaDataVersion]
[MDVLeaf.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[MUTranslatedText] [MeasurementUnits]
[MUTranslatedText.FK_MeasurementUnits] [MeasurementUnits.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[MeasurementUnits] [Study]
[MeasurementUnits.FK_Study] [Study.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[MetaDataVersion] [Study]
[MetaDataVersion.FK_Study] [Study.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[Presentation] [MetaDataVersion]
[Presentation.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ProtocolEventRefs] [MetaDataVersion]
[ProtocolEventRefs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ProtocolEventRefs] [StudyEventDefs]
[ProtocolEventRefs.StudyEventOID] [StudyEventDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[RCErrorTranslatedText] [ItemRangeChecks]
[RCErrorTranslatedText.FK_ItemRangeChecks] [ItemRangeChecks.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[StudyEventDefs] [MetaDataVersion]
[StudyEventDefs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[StudyEventFormRefs] [FormDefs]
[StudyEventFormRefs.FormOID] [FormDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[StudyEventFormRefs] [StudyEventDefs]
[StudyEventFormRefs.FK_StudyEventDefs] [StudyEventDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[Study] [DefineDocument]
[Study.FK_DefineDocument] [DefineDocument.FileOID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[SupplementalDocs] [MDVLeaf]
[SupplementalDocs.leafID] [MDVLeaf.ID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[SupplementalDocs] [MetaDataVersion]
[SupplementalDocs.FK_MetaDataVersion] [MetaDataVersion.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ValueListItemRefs] [CodeLists]
[ValueListItemRefs.RoleCodeListOID] [CodeLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ValueListItemRefs] [ImputationMethods]
[ValueListItemRefs.ImputationMethodOID] [ImputationMethods.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ValueListItemRefs] [ItemDefs]
[ValueListItemRefs.ItemOID] [ItemDefs.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ValueListItemRefs] [ValueLists]
[ValueListItemRefs.FK_ValueLists] [ValueLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0110
Content
[ValueLists] [ValueLists]
[ValueLists.FK_MetaDataVersion] [ValueLists.OID]
The foreign key &_cstparm1 does not have a corresponding value in the target data set &_cstparm2.
CRT0111
Content
[ItemGroupDefs] [ItemGroupDefItemRefs]
[ItemGroupDefs.OID] [ItemGroupDefItemRefs.FK_ItemGroupDefs]
Each distinct value of &_cstparm1 must have a corresponding value in the target data set &_cstparm2.
CRT0111
Content
[ItemRangeChecks] [ItemRangeCheckValues]
[ItemRangeChecks.OID] [ItemRangeCheckValues.FK_ItemRangeChecks]
Each distinct value of &_cstparm1 must have a corresponding value in the target data set &_cstparm2.
CRT0111
Content
[MDVLeaf] [MDVLeafTitles]
[MDVLeaf.ID] [MDVLeafTitles.FK_MDVLeaf]
Each distinct value of &_cstparm1 must have a corresponding value in the target data set &_cstparm2.
CRT0112
Content
[CodeListItems] [ExternalCodeLists]
[CodeListItems.FK_CodeLists] [ExternalCodeLists.FK_CodeLists]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[DefineDocument] [ItemGroupLeaf]
[DefineDocument.ID] [ItemGroupLeaf.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[DefineDocument] [MDVLeaf]
[DefineDocument.ID] [MDVLeaf.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[ExternalCodeLists] [CodeListItems]
[ExternalCodeLists.FK_CodeLists] [CodeListItems.FK_CodeLists]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[ItemGroupLeaf] [DefineDocument]
[ItemGroupLeaf.ID] [DefineDocument.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[ItemGroupLeaf] [MDVLeaf]
[ItemGroupLeaf.ID] [MDVLeaf.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[MDVLeaf] [DefineDocument]
[MDVLeaf.ID] [DefineDocument.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0112
Content
[MDVLeaf] [ItemGroupLeaf]
[MDVLeaf.ID] [ItemGroupLeaf.ID]
No value in &_cstparm1 can be equal to any value in &_cstparm2.
CRT0113
Content
CodeListItems
[CodedValue] [FK_CodeLists]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
FormDefItemGroupRefs
[ItemGroupOID] [FK_FormDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
FormDefItemGroupRefs
[OrderNumber] [FK_FormDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
ItemGroupDefItemRefs
[ItemOID] [FK_ItemGroupDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
ItemGroupDefItemRefs
[OrderNumber] [FK_ItemGroupDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
ProtocolEventRefs
[OrderNumber] [FK_MetaDataVersion]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
ProtocolEventRefs
[StudyEventOID] [FK_MetaDataVersion]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
StudyEventFormRefs
[FormOID] [FK_StudyEventDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0113
Content
StudyEventFormRefs
[OrderNumber] [FK_StudyEventDefs]
Foreign key variables cannot have multiple values in &_cstparm2. They must be unique.
CRT0114
Content
_ALL_
Coded value is either incorrect, missing, or in the wrong case.