iCommunicate


Description

Internal communication messages managing internal messaging and communication between healthcare system users. This table stores communication messages including subjects, content, priorities, categories, and audit tracking to support internal messaging workflows, team communication, and information sharing for healthcare staff coordination and organizational communication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkCommunicateID int identity 4 √ null
iCommunicateInDocuments.fkCommunicateID FK_iCommunicateInDocuments_iCommunicate R
iCommunicateProperties.fkCommunicateID FK_iCommunicatePropertiesID_iCommunicate R

Primary key - Unique identifier for each communication message
fkCommunicateID int 4 √ null

Parent communication reference - Links to parent message for threaded conversations
InsertedDate datetime 16,3 √ null

Creation date - Date when the communication message was created
fkInsertedby int 4 √ null

Created by user - UserID of the person who created the message
fkupdatedby int 4 √ null

Updated by user - UserID of the person who last updated the message
updateddate datetime 16,3 √ null

Last update date - Date when the message was last modified
fkSource int 4 √ null

Source reference - Links to the source or origin of the communication
Subject varchar 1000 √ null

Message subject - Subject line or title of the communication message
fkPriority int 4 √ null

Priority reference - Links to priority level for the message
fkCategory int 4 √ null

Category reference - Links to category for organizing messages
Body ntext 1073741823 √ null

Message body - Main content and text of the communication message
fkFlexFormID int 4 √ null

Flex form reference - Links to FlexForm if the message is associated with a form
fkReplyFlexFormID int 4 √ null

Reply form reference - Links to FlexForm used for replying to this message
MessageTypeId int 4 √ null

Message type reference - Links to message type classification
ScheduledSendDateTime datetime 16,3 √ null

Scheduled send time - Date and time when the message is scheduled to be sent

Indexes

Constraint Name Type Sort Column(s)
iCommunicate_PK Primary key Asc pkCommunicateID

Relationships

Close relationships within degrees of separation