EXCHANGECALENDARITEMBATCH (4.0SP20)

ID

uniqueidentifier

BATCHID

uniqueidentifier

false

FK to BATCH

INTERACTIONID

uniqueidentifier

true

FK to INTERACTION

CONSTITUENTID

uniqueidentifier

false

FK to CONSTITUENT

OWNERID

uniqueidentifier

false

FK to APPUSER

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

STEWARDSHIPSTEPID

uniqueidentifier

true

FK to STEWARDSHIPPLANSTEP

TIMEZONEENTRYID

uniqueidentifier

true

Time zone of meeting time.

OBJECTIVE

nvarchar(256)

false

EXPECTEDDATE

datetime

false

SEQUENCE

int

false

Sequence

PROCESS

bit

false

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

RECORDTYPECODE

tinyint

false

0=Constituent interaction, 1=Prospect plan step, 2=Stewardhip plan step

RECORDTYPE

nvarchar(23) (Computed)

true

Provides a translation for the 'RECORDTYPECODE' field.

EXPECTEDSTARTTIME

UDT_HOURMINUTE

false

Expected starting time of the interaction.

EXPECTEDENDTIME

UDT_HOURMINUTE

false

Expected ending time of the interaction.

ISALLDAYEVENT

int (Computed)

false

IX_EXCHANGECALENDARITEMBATCH_BATCHID

False

False

False

IX_EXCHANGECALENDARITEMBATCH_CONSTITUENTID

False

False

False

IX_EXCHANGECALENDARITEMBATCH_DATEADDED

False

False

True

IX_EXCHANGECALENDARITEMBATCH_DATECHANGED

False

False

False

IX_EXCHANGECALENDARITEMBATCH_OWNERID

False

False

False

PK_EXCHANGECALENDARITEMBATCH

True

True

False

TR_EXCHANGECALENDARITEMBATCH_AUDIT_UPDATE

TR_EXCHANGECALENDARITEMBATCH_AUDIT_DELETE

EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGES

EXCHANGECALENDARITEMBATCHID

EXCHANGECALENDARITEMBATCHBATCHUSERMESSAGE

ID