MES views

data_log_16

Returns data_log records for value1 to value16 where data_log_grp.max_value is 16 to match what was available in previous releases of MES for which this was a table.

data_log_48

Returns data_log records for value1 to value48 where data_log_grp.max_value is 48 to match what was available in previous releases of MES for which this was a table.

job_util_log_link

Joins the util_history and job_history tables to return the same columns as were available in previous releases of MES for which this was a table.

shift_sched

Returns shift_schedule records linked to shift_patterns and shift_pattern_ent_link to match what was available in previous releases of MES for which this was a table. With the changes in the table design, the data in this view is only guaranteed after migration and might not match in new configurations.

tpm_stat

Joins job_hour_history with various additional tables to return the same columns as were available in previous releases of MES for which this was a table.

util_log

Joins the util_history and shift_history tables to return the same columns as were available in previous releases of MES for which this was a table. This view does not split a util_history record that spans multiple shifts.

vw_certification_data

Joins cert_audit_log with job, job_step, and item_prod plus config tables ent and user_name to return transactions related to certification.

vw_consumption_data

Joins item_cons with job_route and job plus multiple configuration tables to return consumption transaction data.

vw_data_log_data

Joins data_log, including value1 to value64 columns, with data_log_grp, job_step, item_prod, item, shift, and entity tables to return data log records.

vw_data_log_groupdesc

MES Client-generated view where groupdesc is the description of the data log group from which the view is generated, with any spaces in the description string removed. The view returns records from the data_log table with column names that match the names of the data log values within the group. The columns are cast to the data type defined for the data log values. Any additional columns are returned as valuen as a string.

If the casting fails on a valuen column, then that column value is returned with a null value for that row.

vw_downtime_data

Joins util_history (through the util_log view) with job_history, job, and multiple configuration tables to return downtime event data. It does not include Idle or Runtime events. Use vw_utilization_data for all utilization event data.

vw_ebr_summary_data

Joins item_prod with job, item, ent, and UOM tables to return the sum of good production counts.

vw_efficiency_data

Joins job_hour_history (through the tpm_stat view) with ent, shift, item, and wo tables to return summarized equipment efficiency data for the calculation of OEE KPIs. This view returns calculated columns.

vw_genealogy_data

Joins item_prod with job and item_cons plus multiple configuration tables to return genealogy data based on the item_prod.lot_no = item_cons.fg_lot_no.

vw_genealogy_NoFGLot

This view is similar to vw_genealogy_data but builds genealogy information from job information between item consumption and item production instead of by produced lot number.

vw_group_production_data

Joins item_prod with job, ent, and ent_link tables to return production data, including the parent entity name.

vw_inventory_level_data

Joins item_inv with multiple configuration tables to return inventory data.

vw_inventory_transfer_data

Joins item_transfer with multiple configuration tables to return inventory transfer transactions.

vw_job_data

Joins job with multiple configuration tables to return existing job data.

vw_labor_data

Joins labor_usage with job and multiple configuration tables to return labor transactions for jobs.

vw_oee_data

Joins job_hour_history (through the tpm_stat view) with job, item, ent, shift, and uom tables to return equipment efficiency data. This differs from the vw_efficiency_data view in that this view does not do any calculations in the returned columns.

vw_prod_events

Joins util_history (through the util_log view) with job_history and multiple configuration tables to return utilization events with a calculated LossType column to indicate Availability Loss, Performance Loss, or Idle.

vw_production_data

Joins item_prod with job and multiple configuration tables to return production data.

vw_reject_data

Joins item_prod with job and multiple configuration tables to return only production data for bad/reject production.

vw_specification_data

Joins job_spec with job and item_prod plus multiple configuration tables to return specification data.

vw_step_status_data

Joins job_step_data with job and multiple configuration tables to return job step data.

vw_traceability_data

Joins item_prod with job, job_step, job_step_data and multiple configuration tables to return user transaction data.

vw_usage_data

Joins item_cons with job and various configuration tables to return item consumption data.

vw_util_history

Calculation from util_history table to get duration for current event plus all other events.

vw_util_log_by_shift

Joins util_history and shift_history tables to return the same columns as util_log, including extra records for breaking the utilization events by shift.

vw_util_shift_link

Calculation from util_shift_link table to get current utilization event records.

vw_utilization_data

Joins util_history (through the util_log view) with job_history, job, and multiple configuration tables to return utilization event data.

vw_waste_data

Joins item_cons with job and multiple configuration tables to return only scrap transactions (which are recorded as a consumption transaction).

vw_wip_status_data

Joins storage_exec with item_inv, ent, and multiple configuration tables to return inventory information about storage entities.

vw_yield_data

Joins job_bom with job, item_prod, item_cons, wo, ent, item, and uom tables to return good and bad production and consumption counts.