Table 46. Preventive Maintenance Engine Parameters
|
|
|
Mode |
SQL, Id, TempTbl |
Specifies how the engine locates the entities to process. In a user request, specify only SQL or ID. Client applications use TempTbl for submitting requests. This parameter is required. NOTE: Do not run component jobs in TempTbl mode to call the Preventive Maintenance Engine. This mode is reserved for interactive engine jobs sent directly from a client application.
|
Sub-mode |
Assets, Plans, Assets&Plans, Agreements |
Identifies the specified entities. A Sub-mode of Assets implies all PM plans, and a Sub-mode of Plans implies all assets. This parameter is required. |
End Date |
Date in YYYY-MM-DD format |
Specifies the last date that the engine generates PM actions. Currently, only time-based triggers can occur for a future date. This parameter is required. |
Asset ID |
Row ID of an asset |
Specifies an asset. This parameter is required when the Mode is ID and the Sub-mode is Assets or Assets&Plans. |
Plan ID |
Row ID of a PM plan |
Specifies a PM plan. This parameter is required when the Mode is ID and the Sub-mode is Plans or Assets&Plans. |
Agreement ID |
Row ID of an agreement |
Specifies an agreement. This parameter is required when the Mode is ID and the Sub-mode is Agreements. |
DefOrgID |
Row ID of an organization |
Specifies an organization. This parameter applies to a generated service request when the asset for the service request does not have a specified account. If the asset has a specified owner account, then the BU_ID for the account is used. |
DefActOwnerID |
Row ID of an employee |
Specifies an employee. This parameter applies when you create activities from a template that does not define the activity owner (employee). |
Asset SQL |
Where clause for the GET_SQL_ASSETS template. The where clause uses the following form: [BusComp Field Name] = 'Value' |
Specifies a search specification for assets. This parameter is required when the Mode is SQL and the Sub-mode is Assets or Assets&Plans. The SQL template for retrieving assets follows: GET_SQL_ASSETS = SELECT asset.ROW_ID FROM &Table_Owner.S_ASSET asset WHERE $SEARCH_SPEC$ The value for the Asset SQL parameter is substituted for '$SEARCH_SPEC$.' Any specification that completes this template with valid values is allowed for the parameter. |
Plan SQL |
Where clause for the GET_SQL_PM_PLANS template. The where clause uses the following form: [BusComp Field Name] = 'Value' |
Specifies a search specification for PM plans. This parameter is required when the Mode is SQL and the Sub-mode is Plans or Assets&Plans. The SQL template for retrieving PM plans follows: GET_SQL_PM_PLANS = SELECT pln.ROW_ID FROM &Table_Owner.S_PM_PLNITM pln WHERE pln.ACTIVE_FLG = 'Y' AND $SEARCH_SPEC$ The value for the Plan SQL parameter is substituted for '$SEARCH_SPEC$.' Any specification that completes this template with valid values is allowed for the parameter. |
Agreement SQL |
Where clause for the GET_SQL_AGREEMENT_IDS template. The where clause uses the following form: [BusComp Field Name] = 'Value' |
Specifies a search specification for agreements. This parameter is required when the Mode is SQL and the Sub-mode is Agreements. The SQL template for retrieving PM agreements follows: GET_SQL_AGREEMENT_IDS = SELECT agrmnt.ROW_ID FROM &Table_Owner.S_DOC_AGREE agrmt WHERE agrmnt.VALID_FLG = 'Y' AND $SEARCH_SPEC$ The value for the Agreement SQL parameter is substituted for '$SEARCH_SPEC$.' Any specification that completes this template with valid values is allowed for the parameter. |