Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (4) | DocumentID | int | 4 | NOT NULL | | Key to Doc_Header table. For an image we show in Touchworks, Works.dbo.Document.accessionnumber will be "AIC" + impact.dbo.doc_header.documentid. |
(5) | PatientID | int | 4 | NOT NULL | | PatientID |
(5)![Foreign Keys FK_DOC_HEADER_FolderID: [dbo].[FOLDER_TEMPLATE].FolderID Foreign Keys FK_DOC_HEADER_FolderID: [dbo].[FOLDER_TEMPLATE].FolderID](../../../../Images/fk.png) | FolderID | varchar(10) | 10 | NOT NULL | | Link to to Folder_Template.FolderID |
(3) | DocumentName | varchar(50) | 50 | NULL allowed | | Name of Document. The default Document Name comes from the folder it is in. Can be renamed in application. |
(3) | Date | smalldatetime | 4 | NULL allowed | | Date of Document. Matches AcquireDate only this shows with no timestamp |
(2) | FileType | int | 4 | NOT NULL | | ID of filetype. (1 = .tif, 501 = .pdf, 505 = .tiff etc) |
(2) | Editable | bit | 1 | NOT NULL | | Indicates if a document can be edited |
(3) | AcquireDate | smalldatetime | 4 | NOT NULL | | Date Image was acquired |
 | LastAccess | smalldatetime | 4 | NOT NULL | | Date Image was last viewed |
 | LastChange | smalldatetime | 4 | NOT NULL | | Last Edit Date |
 | ArchiveDate | smalldatetime | 4 | NULL allowed | | NOT USED - NULL for all entries |
 | Archive | tinyint | 1 | NOT NULL | ((0)) | NOT USED - 0 for all entries |
 | Volume | varchar(20) | 20 | NULL allowed | | NOT USED - NULL for all entries |
(2) | PageCount | smallint | 2 | NOT NULL | ((0)) | Number of Pages |
 | InMailBasket | tinyint | 1 | NOT NULL | ((0)) | Is the Document in the Mail Basket |
(2) | SignedOff | tinyint | 1 | NOT NULL | ((0)) | 0 = not signed off, 1 = signed off. Once an Image is signed it becomes locked and cannot be edited after. |
 | SignedOffBy | int | 4 | NOT NULL | ((0)) | Usercode of who signed off document |
 | SignOffDate | smalldatetime | 4 | NULL allowed | | Date signed off |
 | FilterID | int | 4 | NOT NULL | ((0)) | Filter ID of the document |
 | RemoteScan | tinyint | 1 | NOT NULL | ((0)) | Presence/use of remote Scan |
(3) | FormID | int | 4 | NOT NULL | ((0)) | ID of Admin Form documents |
(2) | AlternateID | varchar(100) | 100 | NULL allowed | | Alternative ID of the document |
 | Status | int | 4 | NOT NULL | ((0)) | Curent status of the document |
(2) | AnnFileLocked | int | 4 | NOT NULL | ((0)) | Are annotations Locked? 0 = not locked, 1 = locked. If locked new annotation can not be created as well. |
 | AnnFileLockedBy | int | 4 | NOT NULL | ((0)) | usercode of user who locked annotations |
 | AnnFileLockedDate | datetime | 8 | NULL allowed | | Date annotations were locked |
 | WordCount | tinyint | 1 | NOT NULL | ((0)) | Word count in documents related to OCR capability |