Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.DOCWORKS_Signature
Touchworks 25.2
[dbo].[DOCWORKS_Signature]
MS_Description
Signatures applied to Documents
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Document UniqueID - Links to Document.DocumentiD
SignedByID
[dbo].[uniqueid]
9
NOT NULL
User to whom the signature belongs. Link to IDX_User.ID
SignatureDTTM
datetime
8
NOT NULL
Datetime of the signature
PostSignatureStatus
varchar(255)
255
NOT NULL
Document Status After Signing
PreSignatureStatus
varchar(255)
255
NULL allowed
Document Status Prior to Signing
HigherisBetterRanking
int
4
NOT NULL
Signature Authority Level
ReqHigherisBetterRanking
int
4
NOT NULL
Required Authority Level
signaturetype
varchar(255)
255
NULL allowed
Text Indicating Signature type (ex . Author)
ZoneAbbr
varchar(32)
32
NULL allowed
Timezone abbreviation. No longer used
TimeZoneID
int
4
NULL allowed
Time Zone. Link to Time_Zone.ID