Tables [CDS].[DispositionReason]
Available types of reasons when supressing/ignoring a recommendation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PKDispositionReason: DispositionReasonIDDispositionReasonIDint4NOT NULL1 - 1Key to the DispositionReason table
Descriptionvarchar(200)200NOT NULLdescription of disposition reason
Foreign Keys FKDispositionReasonParentDispositionReason: [CDS].[DispositionReason].ParentDispositionReasonIDParentDispositionReasonIDint4NULL allowedparent id (parent is another disposition reason)
Foreign Keys FKDispositionReasonStatus: [CDS].[Status].StatusIDCheck Constraints CKDispositionReasonStatusIDValid : ([StatusID]='IGN' OR [StatusID]='ADD')StatusIDvarchar(3)3NULL allowedStatus. Link to Status.ID. disposition type to associate, always IGN
Sortvarchar(10)10NULL allowedused to group the dispostions reasons