Validation Checks

This table provides a complete list of all CDISC CRT-DDS 1.0 validation checks.
Validation Checks
checkid
checktype
tablescope
columnscope
messagetext
CRT0100
Structural
_ALL_
No two values for the source column can be equivalent within the same source data set.
CRT0101
Content
_ALL_
Data is required for this field.
CRT0105
Structural
FormDefItemGroupRefs
OrderNumber
Duplicate (nonmissing) OrderNumber element found.
CRT0105
Structural
ItemGroupDefItemRefs
OrderNumber
Duplicate (nonmissing) OrderNumber element found.
CRT0105
Structural
ProtocolEventRefs
OrderNumber
Duplicate (nonmissing) OrderNumber element found.
CRT0105
Structural
StudyEventFormRefs
OrderNumber
Duplicate (nonmissing) OrderNumber element found.
CRT0105
Structural
ValueListItemRefs
OrderNumber
Duplicate (nonmissing) OrderNumber element found.
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
MUtranslatedText
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] [MDVLeafTitles]
[MDVLeaf.ID] [MDVLeafTitles.FK_MDVLeaf]
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] [MetaDataVersion]
[ValueLists.FK_MetaDataVersion] [MetaDataVersion.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.
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
[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
ItemGroupDefItemRefs
[ItemOID] [FK_ItemGroupDefs]
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.
CRT0114
Content
_ALL_
Coded value is either incorrect, missing, or wrong case.
Copyright © SAS Institute Inc. All rights reserved.