GLOBALCHANGERECORDCOUNT

Stores information about a specific global change run.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
NUMBERADDED int Default = 0 Number of records added to the system during the global change run.
NUMBEREDITED int Default = 0 Number of records edited in the system during the global change run.
NUMBERDELETED int Default = 0 Number of records deleted from the system during the global change run.

Foreign Keys

Foreign Key Field Type Null Notes Description
ID uniqueidentifier BUSINESSPROCESSSTATUS.ID Primary Key.

Indexes

Index Name Fields Unique Primary Clustered
PK_GLOBALCHANGERECORDCOUNT ID yes yes yes