Tables [CDS].[AppliedRecommendationDisposition]
Audit of the disposition returned for a recommendation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PKAppliedRecommendationDisposition: IDIDint4NOT NULL1 - 1Identity column
Indexes UIDX_AppliedRecommendationDisposition_RecommendationForeign Keys FKAppliedRecommendationDispositionRecommendation: [CDS].[Recommendation].RecommendationIDRecommendationIDvarchar(40)40NOT NULLRecommendation. Link to Recommendation.ID
Indexes UIDX_AppliedRecommendationDisposition_RecommendationAppliedProviderIDvarchar(40)40NULL allowedparticipant id of applied disposition
Indexes UIDX_AppliedRecommendationDisposition_RecommendationAppliedUserIDvarchar(40)40NULL alloweduser id of applied disposition
Indexes IDX_AppliedRecommendationDisposition_DispositionForeign Keys FKAppliedRecommendationDispositionType: [CDS].[DispositionType].DispositionTypeIDDispositionTypeIDvarchar(3)3NOT NULLfrom disposition type used to identity what type of disp was applied. Link to DispositionType.ID
Indexes IDX_AppliedRecommendationDisposition_DispositionDispositionIDint4NOT NULLrecommendation disposition. Link to recommendationdisposition.ID
Foreign Keys FKAppliedRecommendationDispositionSource: [CDS].[DispositionSource].SourceIDSourceIDvarchar(3)3NOT NULLreason dispon applied, Link to DispositionSource.ID
Indexes IDX_AppliedRecommendationDisposition_PatientIDPatientIDvarchar(40)40NULL allowedif disposition was setup on patient id, patient id of the associated disposition configuration
ProviderIDvarchar(40)40NULL allowedif disposition was setup on provider id, provider id of the associated disposition configuration
UserIDvarchar(40)40NULL allowedif disposition was setup on user id, user id of the associated disposition configuration
EncounterIDvarchar(40)40NULL allowedif disposition was setup on encounter id, encounter id of the associated disposition configuration
Sincedatetime8NOT NULLdate disposition was configured
Untildatetime8NULL alloweddate  disposition will expire
Foreign Keys FKAppliedRecommendationDispositionStatus: [CDS].[Status].StatusIDStatusIDvarchar(3)3NOT NULLdisposition status. Link to Status.ID
Foreign Keys FKAppliedRecommendationDispositionReason: [CDS].[DispositionReason].DispositionReasonIDDispositionReasonIDint4NULL alloweddisposition reason. Link to DispositionReason.ID
ReasonDescriptionvarchar(200)200NULL alloweddescription of disposition reason
Commentvarchar(max)maxNULL allowedcomment associated to disposition