BATCHSTEWARDSHIPPLANSTEPUPDATE (4.0)

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
BATCHID	uniqueidentifier	false	BATCH.ID
PRIMARYRECORDID	uniqueidentifier	true	STEWARDSHIPPLANSTEP.ID
CATEGORYCODEID	uniqueidentifier	true	STEWARDSHIPSTEPCATEGORYCODE.ID
CONTACTMETHODCODEID	uniqueidentifier	true	INTERACTIONTYPECODE.ID
CONTACTPERSONID	uniqueidentifier	true	CONSTITUENT.ID
CONSTITUENTID	uniqueidentifier	true	CONSTITUENT.ID
EVENTID	uniqueidentifier	true	EVENT.ID
MAILINGID	uniqueidentifier	true	MKTSEGMENTATION.ID
BENEFITID	uniqueidentifier	true	BENEFIT.ID
TIMEZONEENTRYID	uniqueidentifier	true	TIMEZONEENTRY.ID
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID

Fields
Field	Field Type	Null	Notes
SEQUENCE	int	false	0
STEPOWNERID	uniqueidentifier	false
STEWARDSHIPPLANID	uniqueidentifier	true
OBJECTIVE	nvarchar(100)	false	''
TARGETDATE	date	false
DATELOCKED	bit	false	0
ACTUALDATE	date	true
STARTDATE	date	true
ENDDATE	date	true
RECURSCODE	smallint	false	((0))
STATUSCODE	smallint	false	((0))
NEXTTARGETDATE	date	true
TARGETSTARTTIME	UDT_HOURMINUTE	false	''
TARGETENDTIME	UDT_HOURMINUTE	false	''
ACTUALSTARTTIME	UDT_HOURMINUTE	false	''
ACTUALENDTIME	UDT_HOURMINUTE	false	''
ISALLDAYEVENT	bit	false	1
DATEADDED	datetime	false	getdate()
DATECHANGED	datetime	false	getdate()
TS	timestamp	false
TSLONG	bigint (Computed)	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_BATCHID	BATCHID	False	False	False
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_DATEADDED	DATEADDED	False	False	True
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_DATECHANGED	DATECHANGED	False	False	False
IX_BATCHSTEWARDSHIPPLANSTEPUPDATE_PRIMARYRECORDID_CONTACTPERSONID_CONSTITUENTID	PRIMARYRECORDID CONTACTPERSONID CONSTITUENTID	False	False	False
PK_BATCHSTEWARDSHIPPLANSTEPUPDATE	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHSTEWARDSHIPPLANSTEPUPDATE_AUDIT_UPDATE
TR_BATCHSTEWARDSHIPPLANSTEPUPDATE_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN	BATCHSTEWARDSHIPPLANSTEPUPDATEID
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES	BATCHSTEWARDSHIPPLANSTEPUPDATEID
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE	ID
BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT	BATCHSTEWARDSHIPPLANSTEPUPDATEID