Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
SEQUENCE | int | Default = 0 | ||
LOOKUP_ID | nvarchar(100) | Default = '' | ||
KEYNAME | nvarchar(100) | Default = '' | ||
FIRSTNAME | nvarchar(50) | Default = '' | ||
ANNUALGIFTLIKELIHOOD | smallint | Default = ((0)) | ||
ANNUITYLIKELIHOOD | smallint | Default = ((0)) | ||
BEQUESTLIKELIHOOD | smallint | Default = ((0)) | ||
CRTLIKELIHOOD | smallint | Default = ((0)) | ||
MAJORGIVINGLIKELIHOOD | smallint | Default = ((0)) | ||
MEMBERSHIPLIKELIHOOD | smallint | Default = ((0)) | ||
ONLINEGIVINGLIKELIHOOD | smallint | Default = ((0)) | ||
PATIENTRESPONSELIKELIHOOD | smallint | Default = ((0)) | ||
PLANNEDGIFTLIKELIHOOD | smallint | Default = ((0)) | ||
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 |
---|---|---|---|---|
BATCHID | uniqueidentifier | BATCH.ID | FK to BATCH | |
PRIMARYRECORDID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
SUGGESTEDMEMBERSHIPLEVELID | uniqueidentifier | SUGGESTEDMEMBERSHIPLEVEL.ID | FK to SUGGESTEDMEMBERSHIPLEVEL | |
SUGGESTEDMEMBERSHIPLEVELSCOREID | uniqueidentifier | SUGGESTEDMEMBERSHIPLEVEL.ID | FK to SUGGESTEDMEMBERSHIPLEVEL | |
TARGETGIFTRANGEID | uniqueidentifier | TARGETGIFTRANGE.ID | FK to TARGETGIFTRANGE | |
TARGETGIFTRANGESCOREID | uniqueidentifier | TARGETGIFTRANGE.ID | FK to TARGETGIFTRANGE | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
ANALYTICSPROJECTID | uniqueidentifier | ANALYTICSPROJECT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_BATCHMODELINGANDPROPENSITYUPDATE_BATCHID | BATCHID | |||
IX_BATCHMODELINGANDPROPENSITYUPDATE_DATEADDED | DATEADDED | |||
IX_BATCHMODELINGANDPROPENSITYUPDATE_DATECHANGED | DATECHANGED | |||
IX_BATCHMODELINGANDPROPENSITYUPDATE_PRIMARYRECORDID | PRIMARYRECORDID | |||
PK_BATCHMODELINGANDPROPENSITYUPDATE | ID |
Trigger Name | Description |
---|---|
TR_BATCHMODELINGANDPROPENSITYUPDATE_AUDIT_UPDATE | |
TR_BATCHMODELINGANDPROPENSITYUPDATE_AUDIT_DELETE |
Referenced by | Field |
---|---|
BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGES | BATCHMODELINGANDPROPENSITYUPDATEID |
BATCHMODELINGANDPROPENSITYUPDATEBATCHUSERMESSAGE | ID |