staging_curator_status

staging_version

string40

N

N

Identifies the version of the staging tables.

Staging version is composed of 4 parts. The first and second parts represents the staging schema version. The third and forth parts identify the production database version.

Example:

If the MES Cloud Integration is version 8.00 and the production database version is 23.01, the staging_version is 8.00.23.01.

unique_dbname_staging

string40

N

N

Contains a unique name representing this MES database that is used when curating data for CONNECT data services.

This unique name is prepended to reference and event IDs as well as sent as the parent Asset.

service_last_ran_utc

tdatetime

N

Y

Identifies the last time (UTC) the curator host service polled the MES database.

curator_service_host_pref

string254

N

Y

In a multi-node environment, identifies the curator host, using the fully qualified domain name (FQDN) of the machine that is preferentially polling the MES database.

Set in the post-install Configurator when configuring the MES Cloud Integration component.

curator_service_host

string254

N

Y

Identifies the host, using the FQDN of the machine that is polling the MES database.

curate_reference_data

logical

N

N

When true, all reference data (as defined in the staging_type_config table) will be curated in next few minutes from the time this flag is turned on.

The purpose of this flag is to force the reference data curation on demand, when there is a change in master data instead of waiting for the curation cycle to elapse.

After all the reference data is curated, this flag is automatically set back to false.

type_config_changed_utc

tdatetime

N

N

Identifies the last time the staging type configuration was updated.

wait_time_before_takeover

int32

N

N

When the current curator host stops polling the database, the amount of time to wait (in minutes) before switching to another host.

install_date_utc

tdatetime

N

N

The installation date and time (UTC) of the database.

service_last_start_utc

tdatetime

N

Y

Identifies the last time (UTC) the curator host service started.

spare1

string1700

N

Y

Spare field.

spare2

string1700

N

Y

Spare field.

spare3

string1700

N

Y

Spare field.

spare4

string1700

N

Y

Spare field.

row_id

int32

Y

N

The unique row identifier. This field is maintained for audit purposes.