Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0 Identifies in what sequence the Prospect Segmentation section should be sorted by.
 LABEL nvarchar(20)   Default = '' Label of the Prospect Segmentation section.
 LABEL2 nvarchar(20)   Default = '' Second label of the Prospect Segmentation section.
 RANGELOW int   Default = -1 Low range value for an applicable rating to segment on.
 RANGEHIGH int   Default = -1 High range value for an applicable rating to segment on.
 RANGE2LOW int   Default = -1 Second low range value for an applicable rating to segment on.
 RANGE2HIGH int   Default = -1 Second high range value for an applicable rating to segment on.
 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
 VARIABLEID uniqueidentifier   PROSPECTSEGMENTATIONVARIABLE.ID Foreign Key to the Prospect Segmentation variable.
 ESTIMATEDWEALTHLOWID uniqueidentifier ESTIMATEDWEALTH.ID Index of the low Estimated Wealth range to segement on.
 ESTIMATEDWEALTHHIGHID uniqueidentifier ESTIMATEDWEALTH.ID Index of the high Estimated Wealth range to segement on.
 MAJORGIVINGCAPACITYLOWID uniqueidentifier MAJORGIVINGCAPACITY.ID Index of the low Major Giving Capacity range to segement on.
 MAJORGIVINGCAPACITYHIGHID uniqueidentifier MAJORGIVINGCAPACITY.ID Index of the high Major Giving Capacity range to segement on.
 TARGETGIFTRANGELOWID uniqueidentifier TARGETGIFTRANGE.ID Index of the low Target Gift Range to segement on.
 TARGETGIFTRANGEHIGHID uniqueidentifier TARGETGIFTRANGE.ID Index of the high Target Gift Range to segement on.
 WEALTHESTIMATORRATINGLOWID uniqueidentifier WEALTHESTIMATORRATING.ID Index of the low Wealth Estimator Rating range to segement on.
 WEALTHESTIMATORRATINGHIGHID uniqueidentifier WEALTHESTIMATORRATING.ID Index of the high Wealth Estimator Rating range to segement on.
 ESTIMATEDWEALTH2LOWID uniqueidentifier ESTIMATEDWEALTH.ID Index of the second low Estimated Wealth range to segement on.
 ESTIMATEDWEALTH2HIGHID uniqueidentifier ESTIMATEDWEALTH.ID Index of the second high Estimated Wealth range to segement on.
 MAJORGIVINGCAPACITY2LOWID uniqueidentifier MAJORGIVINGCAPACITY.ID Index of the second low Major Giving Capacity range to segement on.
 MAJORGIVINGCAPACITY2HIGHID uniqueidentifier MAJORGIVINGCAPACITY.ID Index of the second high Major Giving Capacity range to segement on.
 TARGETGIFTRANGE2LOWID uniqueidentifier TARGETGIFTRANGE.ID Index of the second low Target Gift Range to segement on.
 TARGETGIFTRANGE2HIGHID uniqueidentifier TARGETGIFTRANGE.ID Index of the second high Target Gift Range to segement on.
 WEALTHESTIMATORRATING2LOWID uniqueidentifier WEALTHESTIMATORRATING.ID Index of the second low Wealth Estimator Rating range to segement on.
 WEALTHESTIMATORRATING2HIGHID uniqueidentifier WEALTHESTIMATORRATING.ID Index of the second high Wealth Estimator Rating range to segement on.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PROSPECTSEGMENTATIONSECTION_DATEADDED DATEADDED    
 IX_PROSPECTSEGMENTATIONSECTION_DATECHANGED DATECHANGED      
 IX_PROSPECTSEGMENTATIONSECTION_ID_VARIABLEID ID, VARIABLEID      
 IX_PROSPECTSEGMENTATIONSECTION_VARIABLEID_RANGE2LOW_RANGE2HIGH VARIABLEID, RANGE2LOW, RANGE2HIGH      
 IX_PROSPECTSEGMENTATIONSECTION_VARIABLEID_RANGELOW_RANGEHIGH VARIABLEID, RANGELOW, RANGEHIGH      
 PK_PROSPECTSEGMENTATIONSECTION ID  
 UIX_PROSPECTSEGMENTATIONSECTION_VARIABLEID_SEQUENCE VARIABLEID, SEQUENCE    

Trigger Name Description
 TR_PROSPECTSEGMENTATIONSECTION_AUDIT_UPDATE
 TR_PROSPECTSEGMENTATIONSECTION_AUDIT_DELETE

Referenced by Field
 PROSPECTSEGMENTATIONPROSPECT PRIMARYSECTIONID
 PROSPECTSEGMENTATIONPROSPECT SECONDARYSECTIONID

Entity-Relationship diagram of this table