Mappings to new MES version 6​.0 stored procedures

Pre-6.0 Stored Procedure

Replacement 6.0 Stored Procedure

Comments

sp_D_Job_Util_Log_Link

sp_D_Job_History

When deleting a record in the previous schema, a portion of job duration was deleted. In the current schema, the duration of the entire job runtime is deleted.

sp_D_Tpm_Stat

sp_D_Job_Hour_History

In the current schema, Job_Start_Utc is required to identify a unique row.

sp_D_Util_Log

sp_D_Util_History

In the current schema, Ent Id + EventTimeUtc is required, in place of log_id that used in the previous schema.

sp_D_Util_Log_DelUtilEvent

sp_D_Util_History

sp_I_Job_Util_Log_Link

sp_I_Job_History

A portion of job duration was added in the previous schema. In the current schema, a history record represents an entire job runtime (duration).

sp_I_Tpm_Stat

sp_I_Job_Hour_History

In the current schema, Job_Start_Utc is required to identify a unique row.

sp_I_Util_Log

sp_I_Util_History

In the current schema, Ent Id + EventTimeUtc is required, in place of log_id that used in the previous schema.

sp_I_Util_Log_AddUtil

sp_U_Util_History_
AddEvent

sp_I_Util_Log_AddUtilEvent

sp_U_Util_History_
AddEvent

sp_S_Job_Util_Log_Link

sp_S_Job_History

A portion of job duration was returned in the previous schema. In the current schema, the entire job duration is returned.

sp_S_Tpm_Stat

sp_S_Job_Hour_History

In the current schema, Job_Start_Utc is required to identify a unique row.

sp_S_Util_Log

sp_S_Util_History

In the current schema, Ent Id + EventTimeUtc is required, in place of log_id that used in the previous schema

sp_SA_Job_Util_Log_Link

sp_SA_Job_History

A portion of job duration was returned in the previous schema. In the current schema, the entire job duration is returned.

sp_SA_Tpm_Stat

sp_SA_Job_Hour_History

In the current schema, Job_Start_Utc is required to identify a unique row.

sp_SA_Util_Log

sp_SA_Util_History

sp_U_Job_Exec_
AdjustJobDur

N/A

In the current schema, times are calculated on demand, so these procedures are obsolete.

sp_U_Job_Exec_
CloseCurrEvents

sp_U_Job_Util_Log_Link

sp_U_Job_History

A portion of job duration was updated in the previous schema. In the current schema, the duration of the entire job runtime is affected.

sp_U_Job_Util_Log_Link_
Join

sp_U_JULL_AdjustJobUtil

sp_U_Oee_Exec_
SetCurrentOEE

N/A

This is an internal stored procedure and should not have been used by the extensibility hooks.

sp_U_Tpm_Stat

sp_U_Job_Hour_History

In the current schema, Job_Start_Utc is required to identify a unique row.

sp_U_TPM_Stat_NewEvent

N/A

These are internal stored procedures and should not have been used by the extensibility hooks.

sp_U_TPM_Stat_NewJob

sp_U_TPM_Stat_NewShift

sp_U_TPM_Stat_RefreshCurrVals

sp_U_TPM_Stat_
UpdateDurations

sp_U_TPM_Stat_UpdDur

sp_U_TPM_Stat_UpdQtys

sp_U_UL_
UpdateDurationByName

N/A

In the current schema, times are calculated on demand, so this procedure is obsolete.

sp_U_Util_Exec_NewEvent

N/A

These are internal stored procedures and should not have been used by the extensibility hooks.

sp_U_Util_Exec_NewJob

sp_U_Util_Exec_
NewJobEvent

sp_U_Util_Exec_NewShift

sp_U_Util_Exec_
SetCurrentUtil

sp_U_Util_Log

sp_U_Util_History

In the current schema, Ent Id + EventTimeUtc is required, in place of log_id that used in the previous schema.

sp_U_Util_Log_
AdjustDuration

sp_U_Util_Log_AdjustEvents

sp_U_Util_Log_MergeLogs

N/A

This is an internal stored procedure and should not have been used by the extensibility hooks.

sp_U_Util_Log_SplitLogs

N/A

To split or merge events, use sp_U_Util_History_AddEvent or sp_U_Util_History_UpdateEvent.

sp_U_Util_Log_
UpdAllDurations

N/A

In the current schema, times are calculated on demand, so these procedures are obsolete.

sp_U_Util_Log_
UpdateDuration

sp_U_Util_Log_UpdateUtil

sp_U_Util_History_UpdateEvent

In the current schema, Ent Id + EventTimeUtc is required, in place of log_id that used in the previous schema. However, the sp_U_Util_History_UpdateEvent is backward compatible to use with the local times and log_id.