Tables [dbo].[DOC_HEADER]
Stores images on the patients chart. Works in conjunction with doc_detail where we store page information.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_DOC_HEADER: DocumentIDIndexes IX_DOC_HEADER_4, IX_DOC_HEADER_2, IX_DOC_HEADER_1, IX_DOC_HEADER_3(4)DocumentIDint4NOT NULLKey to Doc_Header table. For an image we show in Touchworks, Works.dbo.Document.accessionnumber will be "AIC" + impact.dbo.doc_header.documentid.
Indexes IX_DOC_HEADER_PATIENTID, IX_DOC_HEADER_4, IX_DOC_HEADER_2, IX_DOC_HEADER_1, IX_DOC_HEADER_3(5)PatientIDint4NOT NULLPatientID
Indexes IX_DOC_HEADER_FOLDERID, IX_DOC_HEADER_4, IX_DOC_HEADER_2, IX_DOC_HEADER_1, IX_DOC_HEADER_3(5)Foreign Keys FK_DOC_HEADER_FolderID: [dbo].[FOLDER_TEMPLATE].FolderIDFolderIDvarchar(10)10NOT NULLLink to to Folder_Template.FolderID
Indexes IX_DOC_HEADER_DOCUMENETNAME, IX_DOC_HEADER_1, IX_DOC_HEADER_3(3)DocumentNamevarchar(50)50NULL allowedName of Document. The default Document Name comes from the folder it is in. Can be renamed in application.
Indexes IX_DOC_HEADER_DATE, IX_DOC_HEADER_1, IX_DOC_HEADER_3(3)Datesmalldatetime4NULL allowedDate of Document. Matches AcquireDate only this shows with no timestamp
Indexes IX_DOC_HEADER_1, IX_DOC_HEADER_3(2)FileTypeint4NOT NULLID of filetype. (1 = .tif, 501 = .pdf, 505 = .tiff etc)
Indexes IX_DOC_HEADER_1, IX_DOC_HEADER_3(2)Editablebit1NOT NULLIndicates if a document can be edited
Indexes IX_DOC_HEADER_ACQUIREDATE, IX_DOC_HEADER_1, IX_DOC_HEADER_3(3)AcquireDatesmalldatetime4NOT NULLDate Image was acquired
Indexes IX_DOC_HEADER_1LastAccesssmalldatetime4NOT NULLDate Image was last viewed
Indexes IX_DOC_HEADER_1LastChangesmalldatetime4NOT NULLLast Edit Date
Indexes IX_DOC_HEADER_1ArchiveDatesmalldatetime4NULL allowedNOT USED - NULL for all entries
Indexes IX_DOC_HEADER_1Archivetinyint1NOT NULL((0))NOT USED - 0 for all entries
Indexes IX_DOC_HEADER_1Volumevarchar(20)20NULL allowedNOT USED - NULL for all entries
Indexes IX_DOC_HEADER_1, IX_DOC_HEADER_3(2)PageCountsmallint2NOT NULL((0))Number of Pages
Indexes IX_DOC_HEADER_1InMailBaskettinyint1NOT NULL((0))Is the Document in the Mail Basket
Indexes IX_DOC_HEADER_1, IX_DOC_HEADER_3(2)SignedOfftinyint1NOT NULL((0))0 = not signed off, 1 = signed off. Once an Image is signed it becomes locked and cannot be edited after.
Indexes IX_DOC_HEADER_1SignedOffByint4NOT NULL((0))Usercode of who signed off document
Indexes IX_DOC_HEADER_1SignOffDatesmalldatetime4NULL allowedDate signed off
Indexes IX_DOC_HEADER_1FilterIDint4NOT NULL((0))Filter ID of the document
Indexes IX_DOC_HEADER_1RemoteScantinyint1NOT NULL((0))Presence/use of remote Scan
Indexes IX_DOC_HEADER_FORMID, IX_DOC_HEADER_1, IX_DOC_HEADER_3(3)FormIDint4NOT NULL((0))ID of Admin Form documents
Indexes IX_DOC_HEADER_ALTERNATEID, IX_DOC_HEADER_1(2)AlternateIDvarchar(100)100NULL allowedAlternative ID of the document
Indexes IX_DOC_HEADER_1Statusint4NOT NULL((0))Curent status of the document
Indexes IX_DOC_HEADER_1, IX_DOC_HEADER_3(2)AnnFileLockedint4NOT NULL((0))Are annotations Locked? 0 = not locked, 1 = locked. If locked new annotation can not be created as well.
Indexes IX_DOC_HEADER_1AnnFileLockedByint4NOT NULL((0))usercode of user who locked annotations
Indexes IX_DOC_HEADER_1AnnFileLockedDatedatetime8NULL allowedDate annotations were locked
Indexes IX_DOC_HEADER_1WordCounttinyint1NOT NULL((0))Word count in documents related to OCR capability