Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Note_Template_Version
Touchworks 25.2
[dbo].[Note_Template_Version]
MS_Description
v2 Note template definitions
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
NoteTypeDE
[dbo].[dict_id]
5
NOT NULL
Link to Note_Type_DE.ID
TemplateVersion
smallint
2
NOT NULL
The version number of this template.
Description
varchar(50)
50
NOT NULL
Textual description of the template
VersionStatus
char(8)
8
NOT NULL
Status of the version: 'Live', 'Deleted', or 'Test'
WhoDidItID
[dbo].[uniqueid]
9
NOT NULL
Link to IDX_User.ID
CreatedDTTM
datetime
8
NOT NULL
When the row was inserted
LastUpdateDTTM
datetime
8
NOT NULL
When the row was last modified