staging_type_config

staging_type_id

string80

Y

N

Identifies the type.

For example, MESMaterialProducedActual (ItemProd), Asset (Ent), MESMaterialClass (ItemClass), etc.

mes_table_name

string40

N

Y

The MES table that is mapped to this type ID.

type_description

string254

N

N

The description of the data type.

curate_frequency

int32

N

N

The amount of time (in minutes) to wait between subsequent data curation for this type.

The fastest frequency for the curator host is 5 minutes; therefore, values less than 5 will curate every 5 minutes.

A value of 0 indicates this data type is curated on demand and not recorded in the staging_curate_log table.

is_reference_type

logical

N

N

Indicates whether this type is of reference type (true) or an event type (false).

is_global

logical

N

N

Indicates whether to prepend the unique site ID (false) or not (true).

Note: This field is currently not used.

is_enabled

logical

N

N

Indicates whether the data type is curated and sent to CONNECT (true) or not (false).

processing_order

int32

N

N

The order in which the data will be curated.

last_edit_comment

string254

N

Y

Indicates why this record was changed.

last_edit_by

string80

N

Y

Identifies the user who last created this data.

last_edit_at

tdatetime

N

N

Identifies the date and time the record was last changed.

row_id

int32

N

N

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