Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ID | bigint | 8 | NOT NULL | | Key to the NoteInstance table |
 | PatientID | bigint | 8 | NOT NULL | | Patient. Link to Touchworks Person.ID |
 | EncounterID | bigint | 8 | NULL allowed | | Encounter. Link to Touchworks Encounter.ID |
| ProviderID | bigint | 8 | NULL allowed | | Provider. Link to Touchworks Provider.ID |
 | ExternalID | bigint | 8 | NULL allowed | | ExternalID (From TW Document table) |
![Foreign Keys FK_NoteInstance_ContentLibraryItems_TemplateID: [dbo].[ContentLibraryItems].TemplateID Foreign Keys FK_NoteInstance_ContentLibraryItems_TemplateID: [dbo].[ContentLibraryItems].TemplateID](../../../../Images/fk.png) | TemplateID | int | 4 | NOT NULL | | Template Item. Link to ContentLIbraryItems.ItemID |
| NoteDataXML | varchar(max) | max | NULL allowed | | XML content of the note. Will be compressed via webcode beforehand |
| CreateDTTM | datetime | 8 | NOT NULL | | Date note was created |
| LastUpdateDTTM | datetime | 8 | NULL allowed | | Date note was last updated |
| IsFinal | bit | 1 | NOT NULL | | 0 = No, 1 = Yes |
| PreviousVersionID | bigint | 8 | NOT NULL | | Points to previous NoteInstance.ID (0 when its first version) |
| NextVersionID | bigint | 8 | NOT NULL | | Points to next NoteInstance.ID (0 when its latest version) |
 | OriginatingID | bigint | 8 | NOT NULL | | Contains the ID of the first version of the note |
| Transcript | varchar(max) | max | NULL allowed | | Contains text of the ambient listening |
| IsInactiveFlag | bit | 1 | NOT NULL | ((0)) | 0 = inactive, 1 = active |