Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (28) | DocumentID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Document table |
(2) | EXTDocumentID | varchar(255) | 255 | NULL allowed | | External document ID originating from an interface. Shadowed in table DocumentIDGenerator, and sometimes in column AccessionNumber |
(2) | EXTSequenceID | varchar(255) | 255 | NULL allowed | | External sequence, although typically zero. |
(34) | PatientID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the patient that this document belongs to. |
(4) | AuthorID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the author of this document. |
(3) | IDXDocumentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Points to IDX_Document_Type_DE. Major type (Notes, Results, Correspondence, Encounter Form) |
(6) | DocumentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Points to Document_Type_DE. Useful for grouping various kinds of documents |
(8) | PhysicalManifestationDE | [dbo].[dict_id] | 5 | NOT NULL | | Points to PhysicalManifestation_DE. Describes the file type of the document body, or the module used (e.g. v11 note, PDF, TIF, RTF) |
 | NextAmendmentNumber | int | 4 | NOT NULL | (1) | A sequence to indicate a subsequent amendment. |
| EditableChunk | varchar(max) | max | NULL allowed | | obsolete (see EditableChunkCompressed) |
| UneditableChunk | varchar(max) | max | NULL allowed | | obsolete (see UnEditableChunkCompressed) |
(7) | RecordedDTTM | datetime | 8 | NOT NULL | | The system time when the row was inserted (not the clinical "recorded" time) |
(4) | LastEditDTTM | datetime | 8 | NULL allowed | | The time when the document was last edited. |
 | LastEditID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the user who last edited the document. |
 | VerifiedDTTM | datetime | 8 | NULL allowed | | The time when the document was verified. |
(3) | VerifiedID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the user who verified the document. |
 | EIEDTTM | datetime | 8 | NULL allowed | | The time when the document was invalidated. (01/01/1900 means NULL) |
(6) | EIEID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the user who invalidated the document. |
 | PreviousVersionID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Points to the previous version of the document. When zero, this is the start of the version chain. |
(7) | NextVersionID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Points to the next version of the document. When zero, this is the end of the version chain. |
(4) | AccessionNumber | varchar(255) | 255 | NULL allowed | | For scanned images, starts with "AIC" and the subsequent digits point to column DocumentID in table Impact..Doc_Header |
(7) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | Points to the Encounter that this document is associated with. |
 | Transcriptionist | varchar(255) | 255 | NULL allowed | | Who transcribed this document |
 | TranscribedDTTM | datetime | 8 | NULL allowed | | When the transcribing occurred. |
 | DictatedDTTM | datetime | 8 | NULL allowed | | When the dictation occurred. |
 ![Check Constraints CK_Document_VerificationRequiredFLAG_Yes_Or_No : ([VerificationRequiredFLAG]='N' OR [VerificationRequiredFLAG]='Y') Check Constraints CK_Document_VerificationRequiredFLAG_Yes_Or_No : ([VerificationRequiredFLAG]='N' OR [VerificationRequiredFLAG]='Y')](../../../../Images/c-constraint.png) | VerificationRequiredFLAG | [dbo].[BOOL] | 1 | NULL allowed | | Is verification of the document required? (typically when author is not a provider) |
| BinaryChunk | varbinary(max) | max | NULL allowed | | Image |
(8) | Status | varchar(50) | 50 | NULL allowed | ('Unsigned') | Textual status term; may be a compound (e.g. "Amended, Signed") |
 ![Foreign Keys FK_Document_Chart_Location_DE: [dbo].[Chart_Location_DE].ChartLocationDE Foreign Keys FK_Document_Chart_Location_DE: [dbo].[Chart_Location_DE].ChartLocationDE](../../../../Images/fk.png) | ChartLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Key to the Chart_Location_DE table. |
(5) | OwnerID | [dbo].[uniqueid] | 9 | NULL allowed | | Points to the provider who is assigned as the owner. |
 | DictationSystemJobNo | varchar(255) | 255 | NULL allowed | | Dictation system job number |
 | Priority | [dbo].[uniqueid] | 9 | NULL allowed | | The priority of this document |
 | TransactionDTTM | datetime | 8 | NULL allowed | | Time of the transaction |
 | ServiceDTTM | datetime | 8 | NULL allowed | | Date-of-service date/time |
 | AuthoredDTTM | datetime | 8 | NULL allowed | | When the document was authored, in contrast to RecordedDTTM. |
 | InterfaceID | int | 4 | NULL allowed | | Interface source ID |
(4)![Foreign Keys FK_Document_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDE Foreign Keys FK_Document_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDE](../../../../Images/fk.png) | SiteDE | [dbo].[dict_id] | 5 | NULL allowed | | Key to the Site_DE table. |
(7) | OriginatingDocumentID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Points to the start of the version chain. |
| EditableChunkCompressed | varbinary(max) | max | NULL allowed | | Compressed content (body) of the document (varies by Manifestation) |
| UnEditableChunkCompressed | varbinary(max) | max | NULL allowed | | Compressed content (body) of the document (varies by Manifestation) |
 | IsArchived | bit | 1 | NULL allowed | | Is BLOB data moved to Archive Database(0/1)? |
| TextTemplateID | [dbo].[uniqueid] | 9 | NULL allowed | | Text Template used to create the document |
| IsMUNonClinicalSetting | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y = Non-Clinical Document N= Clinical Document |
| ClientTimeZone | varchar(5) | 5 | NULL allowed | | Windows TimeZone Abbreviation of the client machine where document creation was initiated |