Model 1055-Schedule Change Model
Schedule Change Model 1055 Description
A schedule change event occurs when additions, updates, or deletions are made to the production plan. These could be manual changes or changes made via an interface from an external scheduling system fed into Plant Applications.
The functionality in this model is available only if you have purchased the Production Management Module.
Schedule Change Model 1055 Properties
The following Model properties are set up using the Plant Applications Administrator:
|
Property |
Description |
|
Maximum Run Time (Seconds) |
optional: Type the number of seconds you want the model to run. The default is 0 (zero), which means the model will not time out. Typically, you will want to limit the run time of the model only if troubleshooting the model (for example, one of the stored procedures is in an infinite loop). |
|
Model Processing Group |
Used for multithreading. See the Multithreading topic for more information. |
|
Local SP Name |
Stored Procedure called when the model is triggered. |
Movement Model 1055 Stored Procedure Parameters
The following parameters are required at the beginning of the Stored Procedure that is called by Model 1055. The parameter variables can be named whatever is desired but the order must be maintained.
|
Variable Name |
Parameter Description |
|
@ReturnStatus int OUTPUT, |
Flag to indicate Success or Failure (1-Success,0-Failure) |
|
@ReturnMessage varchar(255) OUTPUT, |
Error Message to Write to Log File |
|
@EC_ID int, |
Input to the Stored Procedure indicating the EC_Id of the model from the Event_Configuration table. |
|
@TableName varchar(255), |
Input to the Stored Procedure indicating the Table Name that triggered the Model. |
|
@Id |
Input to the Stored Procedure indicating the Id from the record that triggered the Model. |