Tables [CDS].[RecommendationTypeDisposition]
tracks dispositions associated to an assertion
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PKRecommendationTypeDisposition: IDIDint4NOT NULL1 - 1Key to the RecommendationTypeDisposition table
Indexes UIDX_RecommendationTypeDispositionPatientIDvarchar(40)40NULL allowedpatient identification
Indexes UIDX_RecommendationTypeDispositionProviderIDvarchar(40)40NULL allowedparticipant to apply disposition
Indexes UIDX_RecommendationTypeDispositionUserIDvarchar(40)40NULL alloweduser to apply disposition
Check Constraints CKRecommendationTypeDispositionSinceValid : ([Since]=CONVERT([datetime],floor(CONVERT([float],[Since],(0))),(0)))Sincedatetime8NOT NULL(CONVERT([datetime],floor(CONVERT([float],getdate(),(0))),(0)))entered date
Check Constraints CKRecommendationTypeDispositionUntilValid : ([Until]>=CONVERT([datetime],floor(CONVERT([float],getdate(),(0))),(0)))Untildatetime8NULL allowedend date
Indexes UIDX_RecommendationTypeDispositionForeign Keys FKRecommendationTypeDispositionRecommendationType: [CDS].[RecommendationType].TypeIDTypeIDvarchar(3)3NOT NULLassertion type. Link to RecommendationType.ID
Indexes UIDX_RecommendationTypeDispositionCodeSetvarchar(50)50NOT NULLassertion code set to apply disposition
Indexes UIDX_RecommendationTypeDispositionCodevarchar(50)50NOT NULLassertion code to apply disposition
Indexes UIDX_RecommendationTypeDispositionForeign Keys FKRecommendationTypeDispositionSeverity: [CDS].[Severity].SeverityIDSeverityIDvarchar(3)3NULL allowedNA. Link to Severity.ID
Indexes UIDX_RecommendationTypeDispositionEncounterIDvarchar(40)40NULL allowedencounter to apply disposition
Foreign Keys FKRecommendationTypeDispositionStatus: [CDS].[Status].StatusIDStatusIDvarchar(3)3NOT NULLdisposition status. link to Status.ID
Foreign Keys FKRecommendationTypeDispositionReason: [CDS].[DispositionReason].DispositionReasonIDDispositionReasonIDint4NULL allowedDisposition Reason. Link to DispositionReason.ID
ReasonDescriptionvarchar(200)200NULL alloweddisposition reason
NegationIndbit1NOT NULL((0))na
Commentvarchar(max)maxNULL allowedoptional user comment