Tables [dbo].[NoteInstance]
Quippe Note Instance XML
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_NoteInstance_ID: IDIDbigint8NOT NULLKey to the NoteInstance table
Indexes NIX_NoteInstance_PatientIDPatientIDbigint8NOT NULLPatient. Link to Touchworks Person.ID
Indexes NIX_NoteInstance_EncounterIDEncounterIDbigint8NULL allowedEncounter. Link to Touchworks Encounter.ID
ProviderIDbigint8NULL allowedProvider. Link to Touchworks Provider.ID
Indexes NIX_NoteInstance_ExternalIDExternalIDbigint8NULL allowedExternalID (From TW Document table)
Foreign Keys FK_NoteInstance_ContentLibraryItems_TemplateID: [dbo].[ContentLibraryItems].TemplateIDTemplateIDint4NOT NULLTemplate Item. Link to ContentLIbraryItems.ItemID
NoteDataXMLvarchar(max)maxNULL allowedXML content of the note. Will be compressed via webcode beforehand
CreateDTTMdatetime8NOT NULLDate note was created
LastUpdateDTTMdatetime8NULL allowedDate note was last updated
IsFinalbit1NOT NULL0 = No, 1 = Yes
PreviousVersionIDbigint8NOT NULLPoints to previous NoteInstance.ID (0 when its first version)
NextVersionIDbigint8NOT NULLPoints to next NoteInstance.ID (0 when its latest version)
Indexes NIX_NoteInstance_OriginatingIDOriginatingIDbigint8NOT NULLContains the ID of the first version of the note
Transcriptvarchar(max)maxNULL allowedContains text of the ambient listening
IsInactiveFlagbit1NOT NULL((0))0 = inactive, 1 = active