Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
SEQUENCE | int | Default = 0 | ||
STEPOWNERID | uniqueidentifier | |||
STEWARDSHIPPLANID | uniqueidentifier | |||
OBJECTIVE | nvarchar(100) | Default = '' | ||
TARGETDATE | date | |||
DATELOCKED | bit | Default = 0 | ||
ACTUALDATE | date | |||
STARTDATE | date | |||
ENDDATE | date | |||
RECURSCODE | smallint | Default = ((0)) | ||
STATUSCODE | smallint | Default = ((0)) | ||
NEXTTARGETDATE | date | |||
TARGETSTARTTIME | UDT_HOURMINUTE | Default = '' | ||
TARGETENDTIME | UDT_HOURMINUTE | Default = '' | ||
ACTUALSTARTTIME | UDT_HOURMINUTE | Default = '' | ||
ACTUALENDTIME | UDT_HOURMINUTE | Default = '' | ||
ISALLDAYEVENT | bit | Default = 1 | ||
DATEADDED | datetime | Default = getdate() | ||
DATECHANGED | datetime | Default = getdate() | ||
TS | timestamp | |||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
BATCHID | uniqueidentifier | BATCH.ID | ||
PRIMARYRECORDID | uniqueidentifier | STEWARDSHIPPLANSTEP.ID | ||
CATEGORYCODEID | uniqueidentifier | STEWARDSHIPSTEPCATEGORYCODE.ID | ||
CONTACTMETHODCODEID | uniqueidentifier | INTERACTIONTYPECODE.ID | ||
CONTACTPERSONID | uniqueidentifier | CONSTITUENT.LOCALID | ||
CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
EVENTID | uniqueidentifier | EVENT.ID | ||
MAILINGID | uniqueidentifier | MKTSEGMENTATION.ID | ||
BENEFITID | uniqueidentifier | BENEFIT.ID | ||
TIMEZONEENTRYID | uniqueidentifier | TIMEZONEENTRY.ID | ||
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_BATCHID | BATCHID | |||
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_DATEADDED | DATEADDED | |||
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_DATECHANGED | DATECHANGED | |||
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_PRIMARYRECORDID_CONTACTPERSONID_CONSTITUENTID | PRIMARYRECORDID, CONTACTPERSONID, CONSTITUENTID | |||
PK_BATCHSTEWARDSHIPPLANSTEPUPDATE | ID |
Trigger Name | Description |
---|---|
TR_BATCHSTEWARDSHIPPLANSTEPUPDATE_AUDIT_UPDATE | |
TR_BATCHSTEWARDSHIPPLANSTEPUPDATE_AUDIT_DELETE |
Referenced by | Field |
---|---|
BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN | BATCHSTEWARDSHIPPLANSTEPUPDATEID |
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES | BATCHSTEWARDSHIPPLANSTEPUPDATEID |
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE | ID |
BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT | BATCHSTEWARDSHIPPLANSTEPUPDATEID |