Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Signature_Authority_DE
Touchworks 25.2
[dbo].[Signature_Authority_DE]
MS_Description
Signature Authority Dictionary
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(4)
ID
numeric(8,0)
5
NOT NULL
1 - 1
Key to the Signature_Authority_DE table.
EnterpriseEntryID
numeric(16,0)
9
NULL allowed
Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID
numeric(8,0)
5
NULL allowed
Points to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry
numeric(8,0)
5
NOT NULL
Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
EntryCode
char(10)
10
NOT NULL
Entry Code
EntryName
varchar(255)
255
NOT NULL
Entry Name
EntryMnemonic
char(10)
10
NOT NULL
Entry Mnemonic
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry inactive (Y/N)?
IsEnforcedFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
IsCurrentFLAG
[dbo].[BOOL]
1
NOT NULL
Is the entry Current (Y/N)?
EffectiveDT
datetime
8
NULL allowed
Effective Date. This is the last edited date.
HigherIsBetterRanking
int
4
NOT NULL
(0)
Rank