Utilization Optimization

Tables related to utilization have been modified and added to improve database and reporting performance.

Diagram of Physical Entity Definition Tables

• Ent table In the Foreign Keys from Other Tables list, tpm_stat was removed and job_hour_history, job_history, and util_history were added.

Tables for OEE

• Oee_Exec table The current_perf, current_qual, and current_oee columns are no longer used. Instead, values for these columns are calculated and returned to the client when requested.

• Tpm_Stat table Removed. For backward compatibility, a tpm_stat view was added. The tpm_stat view includes the same columns as the tpm_stat table had so that legacy queries will not break.

• Job_Hour_History table Added.

Tables for Machine Utilization

• Util_Exec table The current_util column is not updated for each change to the utilization event. Instead, the current utilization is calculated on-demand when requested from a client.

• Util_Log table Removed. For backward compatibility, a util_log view was added. The util_log view includes the same columns as the util_log table had so that legacy queries will not break.

• Job_Util_Log_Link table Removed. For backward compatibility, a job_util_log_link view was added. The job_util_log_link view includes the same columns as the job_util_log_link table had so that legacy queries will not break.

• Util_History table Added.

• Job_History table Added.

• Corr_Action_Log table

  • The log_id column was replaced by the ent_id and event_time_utc columns.

  • FK log_id to util_log was replaced by FK from ent_id, event_time_utc to util_history.

Removed Tables Remain in Database During Migration with "_deprecated" Suffix

During a migration of older database versions, the existing data in the util_log, job_util_log_link, and tpm_stat tables will remain in the database in the tables util_log_deprecated, job_util_log_link_deprecated, and tpm_stat_deprecated. These tables can be dropped if the migration was successful and this data is no longer required.