Tables [dbo].[Act_Annotation]
Activity level annotation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Indexes NIX_Act_Annotation_ID, TWstat_Act_Annotation_AnnotatedByUserID_ActivityHeaderID_ID, TWstat_Act_Annotation_AnnotatedForProviderID_ActivityHeaderID_ID, TWstat_Act_Annotation_RecordedDTTM_ActivityHeaderID_ID(4)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Act_Annotation table
Cluster Key CIX_ActHdrID_ActType: ActivityHeaderID\ActivityTypeIndexes TWstat_Act_Annotation_AnnotatedByUserID_ActivityHeaderID_ID, TWstat_Act_Annotation_AnnotatedForProviderID_ActivityHeaderID_ID, TWstat_Act_Annotation_RecordedDTTM_ActivityHeaderID_ID(3)ActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header Identifier. Link to ID in Activity Header table (Act_Hdr_Result, Act_Hdr_Allergy, etc.)
ActivityTextvarchar(max)maxNOT NULLAnnotation text
Indexes TWstat_Act_Annotation_AnnotatedForProviderID_ActivityHeaderID_IDAnnotatedForProviderID[dbo].[uniqueid]9NOT NULLProvider annotated for. Link to Provider.ID
Indexes TWstat_Act_Annotation_AnnotatedByUserID_ActivityHeaderID_IDForeign Keys FK_Act_Annotation_AnnotatedByUserID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByUserIDAnnotatedByUserID[dbo].[uniqueid]9NOT NULLUser who entered. Link to IDX_User.ID
Indexes TWstat_Act_Annotation_PerformedDTTMPerformedDTTMdatetime8NOT NULLPerformed Date and Time
Indexes NIX_Act_Annotation_RecordedDTTM, TWstat_Act_Annotation_RecordedDTTM_ActivityHeaderID_ID(2)RecordedDTTMdatetime8NOT NULLRecorded Date and Time
Cluster Key CIX_ActHdrID_ActType: ActivityHeaderID\ActivityTypeIndexes NIX_Act_Annotation_ID, TWstat_Act_Annotation_ActivityType(2)ActivityTypevarchar(10)10NOT NULL('Unknown')Activity Type (RS, AL, etc.)