staging_curate_log
- Last UpdatedNov 27, 2024
- 2 minute read
The staging_curate_log table contains curated events from the MES database to be pushed to CONNECT data services when the system is configured to use staging records. Otherwise, this table will not contain any data except for delete transactions.
Each record in this table is for a single type of data, but may contain multiple records for that data type. For example, based on the frequency to curate data from the staging_type_config table, the MES curator service will package all new records for the type since the last time curation was completed. Therefore, curation for MESMaterialProducedActual events will have a single record for all MES item_prod records recorded in the time period. If a type is flagged for paging and the number of records exceed the page size, then additional rows will be created.
Data in this table that is more than 5 days old is automatically deleted by the MES Curator host every hour.
|
Field |
Data type |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
created_at_utc |
tdatetime |
Y |
N |
Identifies the time when this event was created in this table. |
|
staging_type_id |
string80 |
Y |
N |
Identifies the type of curated event. For example, MESMaterialProducedActual (ItemProd), Asset (Ent), MESMaterialClass (ItemClass), etc. |
|
type_action |
string40 |
Y |
N |
Identifies the action of this event performed on the MES database. For example, create (insert or update), delete. |
|
curated_data |
varbinary |
N |
N |
Contains MES event data that was curated from the MES database information in JSON format. It consists of one or more rows in JSON format. |
|
mes_polled_at_utc |
tdatetime |
N |
N |
Identifies the time when this data was read from MES database before written in this table. |
|
last_edit_comment |
string2000_null |
N |
Y |
Contains any additional information about this curated data. |
|
last_edit_by |
string80 |
N |
Y |
Identifies the user who last created this data. |
|
row_id |
bigint64 |
N |
N |
Unique row identifier. This field is maintained for audit purposes. |