Connected MES tables

The following tables are added to the MES database when MES Cloud Integration is included during the MES install or added later:

staging_curate_log table added

The staging_curate_log table contains curated events from the MES database to be pushed to CONNECT data services. For detailed information, see staging_curate_log.

staging_curator_status table added

The staging_curator_status table holds the configuration information and information about which host last ran. For detailed information, see staging_curator_status.

staging_db_deleted_log table added

The staging_db_deleted_log table contains information about deleted records that were previously sent to CONNECT. For detailed information, see staging_db_deleted_log.

staging_error_log table added

The staging_error_log table contains curated events from the MES database that failed to be pushed to CONNECT data services. For detailed information, see staging_error_log.

staging_metadata table added

The staging_metadata table contains the metadata structure associated with different data types for CONNECT data services. For detailed information, see staging_metadata.

staging_type_config table added

The staging_type_config table contains the definitions associated with different data types for CONNECT data services. For detailed information, see staging_type_config.

staging_write_status table added

The staging_write_status table provides the last status on an event type and action regarding when the data was last written from MES. The primary purpose of this table is to maintain when the data was last curated from the MES database. For detailed information, see staging_write_status.