MODELINGANDPROPENSITY (4.0SP20)

Contains all default Modeling and Propensity types.

Primary Key
Primary Key Field Type

ID

uniqueidentifier

Foreign Key Fields
Foreign Key Field Type Null Notes Description

SUGGESTEDMEMBERSHIPLEVELID

uniqueidentifier

true

Suggested Membership Level ID

TARGETGIFTRANGEID

uniqueidentifier

true

Target Gift Range ID

WEALTHESTIMATORRATINGID

uniqueidentifier

true

Wealth Estimator Rating ID

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

Fields
Field Field Type Null Notes Description

ANNUALGIFTLIKELIHOOD

int

false

-1

Annual Giving Likelihood

ANNUITYLIKELIHOOD

int

false

-1

Annuity Likelihood

BEQUESTLIKELIHOOD

int

false

-1

Bequest Likelihood

CRTLIKELIHOOD

int

false

-1

CRT Likelihood

MAJORGIVINGLIKELIHOOD

int

false

-1

Major Giving Likelihood

MEMBERSHIPLIKELIHOOD

int

false

-1

Membership Likelihood

ONLINEGIVINGLIKELIHOOD

int

false

-1

Online Giving Likelihood

PATIENTRESPONSELIKELIHOOD

int

false

-1

Patient Response

PLANNEDGIFTLIKELIHOOD

int

false

-1

Planned Giving Likelihood

NCOAMOVEDINDICATOR

bit

false

0

NCOA Moved Indicator

WPSCREENINGINDICATOR

nvarchar(1)

false

''

Wealth Point Screening Indicator

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

Indexes
Index Name Field(s) Unique Primary Clustered

IX_MODELINGANDPROPENSITY_DATEADDED

DATEADDED

False

False

True

IX_MODELINGANDPROPENSITY_DATECHANGED

DATECHANGED

False

False

False

IX_MODELINGANDPROPENSITY_ID_TARGETGIFTRANGEID_WEALTHESTIMATORRATINGID

ID

TARGETGIFTRANGEID

WEALTHESTIMATORRATINGID

False

False

False

PK_MODELINGANDPROPENSITY

ID

True

True

False

Triggers
Trigger Name Description

TR_MODELINGANDPROPENSITY_AUDIT_UPDATE

TR_MODELINGANDPROPENSITY_AUDIT_DELETE

Referenced by
Referenced by Field

MODELINGANDPROPENSITYDELIVERY

MODELINGANDPROPENSITYID