Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ISPRIMARY bit   Default = 1 Indicates that the variable is the primary one for the report and can not have two types associated with it.
 TYPECODE tinyint   Default = 0 Enumeration of the different possible types of Prospect Segmentation variables for the variable.
 TYPE2CODE tinyint   Default = 0 Enumeration of the different possible types of Prospect Segmentation variables for the optional, second variable.
 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.
 TYPE nvarchar(27) (Computed) CASE [TYPECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Annual giving likelihood' WHEN 2 THEN N'Annuity likelihood' WHEN 3 THEN N'Bequest likelihood' WHEN 4 THEN N'CRT likelihood' WHEN 5 THEN N'Major giving likelihood' WHEN 6 THEN N'Membership likelihood' WHEN 7 THEN N'Online giving likelihood' WHEN 8 THEN N'Patient response likelihood' WHEN 9 THEN N'Planned giving likelihood' WHEN 10 THEN N'Estimated wealth' WHEN 11 THEN N'Major giving capacity' WHEN 12 THEN N'Target gift range' WHEN 13 THEN N'Wealth estimator rating' END Provides a translation for the 'TYPECODE' field.
 TYPE2 nvarchar(27) (Computed) CASE [TYPE2CODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Annual giving likelihood' WHEN 2 THEN N'Annuity likelihood' WHEN 3 THEN N'Bequest likelihood' WHEN 4 THEN N'CRT likelihood' WHEN 5 THEN N'Major giving likelihood' WHEN 6 THEN N'Membership likelihood' WHEN 7 THEN N'Online giving likelihood' WHEN 8 THEN N'Patient response likelihood' WHEN 9 THEN N'Planned giving likelihood' WHEN 10 THEN N'Estimated wealth' WHEN 11 THEN N'Major giving capacity' WHEN 12 THEN N'Target gift range' WHEN 13 THEN N'Wealth estimator rating' END Provides a translation for the 'TYPE2CODE' field.

Foreign Key Field Type Null Notes Description
 PROSPECTSEGMENTATIONID uniqueidentifier   PROSPECTSEGMENTATION.ID FK to PROSPECTSEGMENTATION
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PROSPECTSEGMENTATIONVARIABLE_DATEADDED DATEADDED    
 IX_PROSPECTSEGMENTATIONVARIABLE_DATECHANGED DATECHANGED      
 IX_PROSPECTSEGMENTATIONVARIABLE_ID_PROSPECTSEGMENTATIONID ID, PROSPECTSEGMENTATIONID      
 IX_PROSPECTSEGMENTATIONVARIABLE_ID_TYPE2CODE ID, TYPE2CODE      
 IX_PROSPECTSEGMENTATIONVARIABLE_ID_TYPECODE ID, TYPECODE      
 IX_PROSPECTSEGMENTATIONVARIABLE_PROSPECTSEGMENTATIONID_ISPRIMARY PROSPECTSEGMENTATIONID, ISPRIMARY      
 PK_PROSPECTSEGMENTATIONVARIABLE ID  

Trigger Name Description
 TR_PROSPECTSEGMENTATIONVARIABLE_AUDIT_UPDATE
 TR_PROSPECTSEGMENTATIONVARIABLE_AUDIT_DELETE

Referenced by Field
 PROSPECTSEGMENTATIONSECTION VARIABLEID

Entity-Relationship diagram of this table