Tables [CDS].[RuleDisposition]
tracks dispositions that are associated to a rule
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PKRuleDisposition: IDIDint4NOT NULL1 - 1Key to the RuleDisposition table
Indexes UIDX_RuleDispositionPatientIDvarchar(40)40NULL allowedpatient identification
Indexes UIDX_RuleDispositionProviderIDvarchar(40)40NULL allowedprovider id if to only apply for a participant
Indexes UIDX_RuleDispositionUserIDvarchar(40)40NULL alloweduser id if to apply only to a particular user
Check Constraints CKRuleDispositionSinceValid : ([Since]=CONVERT([datetime],floor(CONVERT([float],[Since],(0))),(0)))Sincedatetime8NOT NULL(CONVERT([datetime],floor(CONVERT([float],getdate(),(0))),(0)))date added
Untildatetime8NULL allowedactive until date
Indexes UIDX_RuleDispositionRuleIDvarchar(40)40NOT NULLrule id disposition associated
Indexes UIDX_RuleDispositionForeign Keys FKRuleDispositionSeverity: [CDS].[Severity].SeverityIDSeverityIDvarchar(3)3NULL allowedNA. Link to Severity.ID
Indexes UIDX_RuleDispositionEncounterIDvarchar(40)40NULL allowedencounter id if to only apply for an encounter
Foreign Keys FKRuleDispositionStatus: [CDS].[Status].StatusIDStatusIDvarchar(3)3NOT NULLdisposition status to apply to rule Link to Status.ID
Foreign Keys FKRuleDispositionReason: [CDS].[DispositionReason].DispositionReasonIDDispositionReasonIDint4NULL allowedDisposition Reason. Link to DispositionReason.ID
ReasonDescriptionvarchar(200)200NULL allowedDisposition Reason
Commentvarchar(max)maxNULL allowedoptional comment to be added