Please enable JavaScript to view this site.

Navigation: Catalog: ExactOnlineDataDictionary > Schemas

IncrementalLoadStatistics: Exact Online Incremental Loading Statistics

Status of incremental loading statistics.

Catalog: ExactOnlineDataDictionary

Schema: DataDictionary

Label: Incremental Loading Statistics

The data in this table is partitioned per value of the Division column.

This is a read-only table. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.

Field Selection Method: Required

Table Columns

The columns of the table IncrementalLoadStatistics are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CreatedUtc

datetime

Created (UTC)

 

DeletedRowCount

int64

 

 

DeletedRowIDs

string

 

 

DeletedRowsFoundCountTotal

int64

 

 

DownloadDurationDeletedRowsLastTicks

int64

 

 

DownloadDurationDeletedRowsTotalTicks

int64

 

 

DownloadDurationModifiedRowsLastTicks

int64

 

 

DownloadDurationModifiedRowsTotalTicks

int64

 

 

DownloadDurationPreviousRowsLastTicks

int64

 

 

DownloadDurationPreviousRowsTotalTicks

int64

 

 

MaxSeenTimestampCurrent

int64

 

 

MaxSeenTimestampCurrentDateTime

datetime

 

 

NewRowsCount

int64

 

 

OldRowsDeletedCount

int64

 

 

OldRowsIncludedModifiedCount

int64

 

 

OldRowsIncludedUnchangedCount

int64

 

 

PartitionCompanyName

string

Partition Company Name

 

RowCount

int64

Rows

 

ServiceUrlRequested

string

 

 

StatusAlgorithmVersion

int32

Status Algorithm Version

 

StatusCreatedUtc

datetime

Status Created (UTC)

 

StatusDeletedRowsFoundCountLast

int64

 

 

StatusDeletedRowsFoundCountTotal

int64

 

 

StatusDownloadDurationDeletedRowsLastTicks

int64

 

 

StatusDownloadDurationDeletedRowsTotalTicks

int64

 

 

StatusDownloadDurationModifiedRowsLastTicks

int64

 

 

StatusDownloadDurationModifiedRowsTotalTicks

int64

 

 

StatusDownloadDurationPreviousRowsLastTicks

int64

 

 

StatusDownloadDurationPreviousRowsTotalTicks

int64

 

 

StatusEventLogEntriesCount

int32

 

 

StatusMaxSeenTimestampCurrent

int64

 

 

StatusMaxSeenTimestampCurrentDateTime

datetime

 

 

StatusMaxSeenTimestampPrevious

int64

 

 

StatusMaxSeenTimestampPreviousDateTime

datetime

 

 

StatusPartitionCode

string

 

 

StatusPartitionCompanyCity

string

 

 

StatusPartitionCompanyCountry

string

 

 

StatusPartitionCompanyEmailAddress

string

 

 

StatusPartitionCompanyName

string

 

 

StatusPartitionCompanyPhone

string

 

 

StatusPartitionCreatedUtc

datetime

 

 

StatusPartitionName

string

 

 

StatusPartitionOwnerCompanyName

string

 

 

StatusRowCount

int64

 

 

StatusRowCountPrevious

int64

 

 

StatusServiceUrlRequested

string

Status Service URL Requested

 

StatusStatisticsCount

int32

 

 

StatusTableNameRequested

string

Status Table Name Requested

 

StatusTimestampEnvironment

string

Status Timestamp Environment

 

StatusUid

guid

Status UID

 

StatusVersion

int32

Status Version

 

TableNameRequested

string

 

 

TimestampEnvironment

string

 

 

Uid

guid

 

 

Version

int32

Version

 

 

15-06-2022 19:32 Version 22.0.232-PROD+3445