Tables [dbo].[TB_MAIN]
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_TB_MAIN: RecIDRecIDint4NOT NULL1 - 1Key to the TB_Main table
Cluster Key IX_TB_MAIN_TOUSERCODE_C: ToUserCodeIndexes IX_TB_MAIN_1, IX_TB_MAIN_2(2)ToUserCodeint4NULL allowedWhich user (or technically shared task basket) this task is being sent to. Link to TB_Baskets.TaskBasketCode.
FromUserCodeint4NULL allowedUserCode of who sent the task
Indexes IX_TB_MAIN_DOCUMENTIDDocumentIDint4NULL allowedIf task is regarding a document this will be the DocumentID. Or its 0 if its not linked to a Document.
TableNumberint4NULL allowed-2 if task is not concerning a document, -1 if task is for image in a batch, 0 if task is for image on a patients chart, >=1 for batch in a file cabinet. The ID will be the file cabinet number.
SignedOffPendingtinyint1NOT NULL((0))Indicates if the document has been signed via scan
DateSentdatetime8NULL allowedDate task was sent
Commentvarchar(50)50NULL allowedSubject field of the task
Indexes IX_TB_MAIN_2Statusvarchar(10)10NULL allowedUrgent, Normal, Low
MessagetextmaxNULL allowedThis is an optional free text field to send along with the task
Indexes IX_TB_MAIN_1, IX_TB_MAIN_2(2)IsReadtinyint1NOT NULL((0))0 = not read, 1 = read
TBFoldervarchar(20)20NULL allowedID of the task basket folder the item is in
Indexes IX_TB_MAIN_1, IX_TB_MAIN_2(2)CategoryCodeint4NOT NULL((0))Link to TB_Category.CategoryCode
WorkflowReferenceint4NOT NULL((0))Reference to workflow
SignOffRequiredtinyint1NOT NULL((0))0 = No, 1 = Yes - Does the document the task is about require a signoff?
ReturnStatustinyint1NOT NULL((0))1 = yes, 0 = no - Receive a task back when your original task is read by the recipient.
Indexes IX_TB_MAIN_CALLBACKCallBacktinyint1NOT NULL((0))1 = yes, 0 = no. If you create a task for someone that requires a callback, you will get a message back if the task goes unworked.
CallBackDatedatetime8NULL allowedA date that indicates when the task should be worked. If it is not worked, a callback happens to the sender of the task to let them know it was not done.
CallBackSenttinyint1NOT NULL((0))0 = no, 1 = yes. Indicates a callback has been sent to indicate the task has been worked.
ReplyToint4NOT NULL((0))Usercode of who task will reply to if recipient clicks "Reply" button