Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | RecID | int | 4 | NOT NULL | 1 - 1 | | Key to the DOCNotes table |
 | DocumentID | int | 4 | NULL allowed | | | Document. Can point to DocumentID in a batch, on the patients chart, or in a file cabinet. |
| TableNumber | int | 4 | NULL allowed | | | -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. |
| CreatedDate | datetime | 8 | NULL allowed | | | Date Note was created |
| CreatedBy | int | 4 | NULL allowed | | | Usercode of who created it |
| ModifyDate | datetime | 8 | NULL allowed | | | Last edit date. |
| ModifyBy | int | 4 | NULL allowed | | | Last modified Usercode |
| SignedOff | tinyint | 1 | NULL allowed | | | For "Task Notes" this indicates if the has been signed off. |
| SignOffID | int | 4 | NULL allowed | | | Usercode of who signed off on the image. |
| Notes | text | max | NULL allowed | | | For "Doc Notes" this is the free text added. For "Task Notes" it combines the TO, SUBJECT, and Messagebody of the tasks into free text. (ie "To: Doe, John Subject: Review Document in TW -------------------- No Hurry. Thanks") |
| Page | int | 4 | NOT NULL | | ((0)) | UNUSED. |
 | ImageID | varchar(50) | 50 | NULL allowed | | | Image, Can link to doc_detail.imageid, batch_detail.imageid, or file cabinet (ie FCD0000001.imageid) |
| RecType | int | 4 | NOT NULL | | ((0)) | 0 = Doc Notes, 1 = Task Notes |
| ReadOnly | int | 4 | NOT NULL | | ((0)) | 0 = NO, 1 = YES - For RecType 0 (Doc Notes), when something is read only you cannot delete or edit the note. Does not apply to Task Notes. You cannot edit or delete Task Totes. |