BATCHESCOMMITPROCESS (4.0SP20)

ID

uniqueidentifier

SELECTIONID

uniqueidentifier

true

A foreign key to the ID set used to filter the records included in the batches commit process.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NAME

nvarchar(200)

false

DESCRIPTION

nvarchar(1000)

false

CREATEOUTPUTSELECTION

bit

false

Designates whether or not an ID set should be created for each batch committed during the commit batches process.

CREATEEXCEPTIONBATCHES

bit

false

Indicates whether batches should be created for exceptions during the commit batches process.

PURGEBATCHES

bit

false

Indicates whether or not to delete the data and mark the batches as deleted after the commit batches process.

CREATEBATCHCONTROLREPORTS

bit

false

Indicates whether or not to generate control reports for batches being committed by this process.

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.

IX_BATCHESCOMMITPROCESS_DATEADDED

False

False

True

IX_BATCHESCOMMITPROCESS_DATECHANGED

False

False

False

PK_BATCHESCOMMITPROCESS

True

True

False

UC_BATCHESCOMMITPROCESS_NAME

True

False

False

TR_BATCHESCOMMITPROCESS_AUDIT_UPDATE

TR_BATCHESCOMMITPROCESS_AUDIT_DELETE

BATCHESCOMMITPROCESSSTATUS

PARAMETERSETID