Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | RecID | int | 4 | NOT NULL | 1 - 1 | | Key to the TB_Main table |
 (2) | ToUserCode | int | 4 | NULL allowed | | | Which user (or technically shared task basket) this task is being sent to. Link to TB_Baskets.TaskBasketCode. |
| FromUserCode | int | 4 | NULL allowed | | | UserCode of who sent the task |
 | DocumentID | int | 4 | NULL allowed | | | If task is regarding a document this will be the DocumentID. Or its 0 if its not linked to a Document. |
| TableNumber | int | 4 | NULL 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. |
| SignedOffPending | tinyint | 1 | NOT NULL | | ((0)) | Indicates if the document has been signed via scan |
| DateSent | datetime | 8 | NULL allowed | | | Date task was sent |
| Comment | varchar(50) | 50 | NULL allowed | | | Subject field of the task |
 | Status | varchar(10) | 10 | NULL allowed | | | Urgent, Normal, Low |
| Message | text | max | NULL allowed | | | This is an optional free text field to send along with the task |
(2) | IsRead | tinyint | 1 | NOT NULL | | ((0)) | 0 = not read, 1 = read |
| TBFolder | varchar(20) | 20 | NULL allowed | | | ID of the task basket folder the item is in |
(2) | CategoryCode | int | 4 | NOT NULL | | ((0)) | Link to TB_Category.CategoryCode |
| WorkflowReference | int | 4 | NOT NULL | | ((0)) | Reference to workflow |
| SignOffRequired | tinyint | 1 | NOT NULL | | ((0)) | 0 = No, 1 = Yes - Does the document the task is about require a signoff? |
| ReturnStatus | tinyint | 1 | NOT NULL | | ((0)) | 1 = yes, 0 = no - Receive a task back when your original task is read by the recipient. |
 | CallBack | tinyint | 1 | NOT 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. |
| CallBackDate | datetime | 8 | NULL allowed | | | A 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. |
| CallBackSent | tinyint | 1 | NOT NULL | | ((0)) | 0 = no, 1 = yes. Indicates a callback has been sent to indicate the task has been worked. |
| ReplyTo | int | 4 | NOT NULL | | ((0)) | Usercode of who task will reply to if recipient clicks "Reply" button |