staging_write_status
- Last UpdatedDec 05, 2024
- 1 minute read
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.
|
Field |
Data type |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
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), or delete. |
|
last_mes_polled_at_utc |
tdatetime |
N |
N |
Identifies the date and time the MES Curator Host last polled this data from MES database (UTC). |
|
last_edit_comment |
string2000_null |
N |
Y |
Identifies additional information about this data. |
|
last_edit_by |
string80 |
N |
Y |
Identifies the user who last modified this data. |
|
last_written_at_utc |
tdatetime |
N |
N |
Identifies the date and time the polled data is written in the staging tables (UTC). |
|
row_id |
int32 |
N |
N |
The unique row identifier. This field is maintained for audit purposes. |
FK from staging_type_id to staging_type_config. (Cascade delete)