Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATATYPE smallint   Default = ((0)) The data type for this attribute.
 CODETABLEVALUE uniqueidentifier The code table that is disqualified for Gift Aid.
 CURRENCYVALUE money   Default = 0 The currency amount that is disqualified for Gift Aid.
 DATEVALUE datetime The date that is disqualified for Gift Aid.
 FUZZYDATEVALUE UDT_FUZZYDATE   Default = '00000000' The fuzzy date that is disqualified for Gift Aid.
 MEMOVALUE nvarchar(max)   Default = '' The memo value that is disqualified for Gift Aid.
 NUMBERVALUE int   Default = 0 The number that is disqualifed from Gift Aid.
 TEXTVALUE nvarchar(255)   Default = '' The text value that is disqualified for Gift Aid.
 HOURMINUTEVALUE UDT_HOURMINUTE   Default = '' The hour minute that is disqualified for Gift Aid.
 BOOLEANVALUE bit   Default = 0 The boolean value that is disqualified for Gift Aid.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ATTRIBUTECATEGORYID uniqueidentifier   ATTRIBUTECATEGORY.ID The attribute category for this attribute.
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID The constituent id that is disqualified for Gift Aid.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_GIFTAIDDISQUALIFIEDBYATTRIBUTE_CONSTITUENTID CONSTITUENTID      
 IX_GIFTAIDDISQUALIFIEDBYATTRIBUTE_DATEADDED DATEADDED    
 IX_GIFTAIDDISQUALIFIEDBYATTRIBUTE_DATECHANGED DATECHANGED      
 PK_GIFTAIDDISQUALIFIEDBYATTRIBUTE ID  

Trigger Name Description
 TR_GIFTAIDDISQUALIFIEDBYATTRIBUTE_AUDIT_UPDATE
 TR_GIFTAIDDISQUALIFIEDBYATTRIBUTE_AUDIT_DELETE

Entity-Relationship diagram of this table