Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | int | 4 | NOT NULL | 1 - 1 | | Key to the RuleDisposition table |
 | PatientID | varchar(40) | 40 | NULL allowed | | | patient identification |
 | ProviderID | varchar(40) | 40 | NULL allowed | | | provider id if to only apply for a participant |
 | UserID | varchar(40) | 40 | NULL allowed | | | user id if to apply only to a particular user |
![Check Constraints CKRuleDispositionSinceValid : ([Since]=CONVERT([datetime],floor(CONVERT([float],[Since],(0))),(0))) Check Constraints CKRuleDispositionSinceValid : ([Since]=CONVERT([datetime],floor(CONVERT([float],[Since],(0))),(0)))](../../../../Images/c-constraint.png) | Since | datetime | 8 | NOT NULL | | (CONVERT([datetime],floor(CONVERT([float],getdate(),(0))),(0))) | date added |
| Until | datetime | 8 | NULL allowed | | | active until date |
 | RuleID | varchar(40) | 40 | NOT NULL | | | rule id disposition associated |
 ![Foreign Keys FKRuleDispositionSeverity: [CDS].[Severity].SeverityID Foreign Keys FKRuleDispositionSeverity: [CDS].[Severity].SeverityID](../../../../Images/fk.png) | SeverityID | varchar(3) | 3 | NULL allowed | | | NA. Link to Severity.ID |
 | EncounterID | varchar(40) | 40 | NULL allowed | | | encounter id if to only apply for an encounter |
![Foreign Keys FKRuleDispositionStatus: [CDS].[Status].StatusID Foreign Keys FKRuleDispositionStatus: [CDS].[Status].StatusID](../../../../Images/fk.png) | StatusID | varchar(3) | 3 | NOT NULL | | | disposition status to apply to rule Link to Status.ID |
![Foreign Keys FKRuleDispositionReason: [CDS].[DispositionReason].DispositionReasonID Foreign Keys FKRuleDispositionReason: [CDS].[DispositionReason].DispositionReasonID](../../../../Images/fk.png) | DispositionReasonID | int | 4 | NULL allowed | | | Disposition Reason. Link to DispositionReason.ID |
| ReasonDescription | varchar(200) | 200 | NULL allowed | | | Disposition Reason |
| Comment | varchar(max) | max | NULL allowed | | | optional comment to be added |