GENERATESTEPUPDATEBATCHPROCESS (4.0SP20)

ID

uniqueidentifier

IDSETREGISTERID

uniqueidentifier

false

A foreign key to the ID set used to filter the records included in the generate step batch process.

BATCHTEMPLATEID

uniqueidentifier

false

A foreign key to the batch template used to generate the batch.

APPUSERID

uniqueidentifier

true

A foreign key to the owner of the batch.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NAME

nvarchar(100)

false

The name of the parameter set.

BATCHNUMBER

nvarchar(100)

false

The unique number of the batch.

OVERRIDEBATCHNUMBER

bit

false

Indicates whether or not to use the default numbering scheme for the batch.

DESCRIPTION

nvarchar(1000)

false

The description of the batch.

AUTOSAVEONROWCHANGE

bit

false

Indicates whether or not the batch should auto save on each row change.

ISACTIVE

bit

false

Indicates that this process is active.

FIELDSTOUPDATE

xml

true

Contains the fields and their values to be updated by the generate process.

OFFSET

int

false

MOVECODE

tinyint

false

0=Move target dates forward by, 1=Move target dates backward by

MOVE

nvarchar(29) (Computed)

true

Provides a translation for the 'MOVECODE' field.

DATEVALUEUNITCODE

tinyint

false

Stores the span of date value used to move dates.

DATEVALUEUNIT

nvarchar(6) (Computed)

true

Provides a translation for the 'DATEVALUEUNITCODE' field.

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_GENERATESTEPUPDATEBATCHPROCESS_DATEADDED

False

False

True

IX_GENERATESTEPUPDATEBATCHPROCESS_DATECHANGED

False

False

False

PK_GENERATESTEPUPDATEBATCHPROCESS

True

True

False

UC_GENERATESTEPUPDATEBATCHPROCESS_NAME

True

False

False

TR_GENERATESTEPUPDATEBATCHPROCESS_AUDIT_UPDATE

TR_GENERATESTEPUPDATEBATCHPROCESS_AUDIT_DELETE

GENERATESTEPUPDATEBATCHPROCESSSTATUS

PARAMETERSETID