Tables [dbo].[DOCNOTES]
Holds "Doc Notes" and "Task Notes" for an image.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_DOCNOTES: RecIDRecIDint4NOT NULL1 - 1Key to the DOCNotes table
Indexes IX_DOCNOTES_DOCUMENTIDDocumentIDint4NULL allowedDocument. Can point to DocumentID in a batch, on the patients chart, or in a file cabinet.
TableNumberint4NULL 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.
CreatedDatedatetime8NULL allowedDate Note was created
CreatedByint4NULL allowedUsercode of who created it
ModifyDatedatetime8NULL allowedLast edit date.
ModifyByint4NULL allowedLast modified Usercode
SignedOfftinyint1NULL allowedFor "Task Notes" this indicates if the has been signed off.
SignOffIDint4NULL allowedUsercode of who signed off on the image.
NotestextmaxNULL allowedFor "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")
Pageint4NOT NULL((0))UNUSED.
Indexes IX_DOCNOTES_IMAGEIDImageIDvarchar(50)50NULL allowedImage, Can link to doc_detail.imageid, batch_detail.imageid, or file cabinet (ie FCD0000001.imageid)
RecTypeint4NOT NULL((0))0 = Doc Notes, 1 = Task Notes
ReadOnlyint4NOT 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.