Spares Analysis: General

Any numeric Entity Key that corresponds to an existing Asset.

This parameter is required and refers to the Spare. Without the Spare Entity Key, the URL will not be supported.

Displays the Spare workspace.

This parameter is required and refers to the Spare Application. Without the Spare Application Entity Key, the URL will not be supported.

Displays the Applications section.

reliability/dashboard/0

reliability/spares/2841956/spareapploverview/2841957/2841959

reliability/system/3352307/summary

reliability/system/3352307/scenario/3352304

Logical

An option that lets you send an alert to the person responsible for implementing the recommendation.

If this field is selected, the GE Digital APM system will send an alert to the person in the Assigned to Name field on the date defined in the Target Completion Date field.

This field is labeled Alert Responsible Party When Due? and is available on the Alert tab on the datasheet.

Analysis ID

Character

The ID of the analysis associated with the recommendation.

This field is populated automatically with the Record ID of the analysis to which the Reliability Recommendation record will be linked when it is saved.

Asset ID

Character

The ID for the Equipment associated with the recommendation.

You can define this field by selecting <insert ellipsis icon> and searching for the required Equipment. You can then selecting the Equipment, then select OK to link it to the Recommendation.

This field is labeled Equipment ID and is available on the General Information tab on the datasheet.

Assigned to Name

Character

The name of the person responsible for ensuring the recommendation is implemented.

This field contains a list of all Security Users in the database, presented in the following format:

<last name>, <first name>, <user ID>

This field is optional. You can select a user from the list.

This field is available on the General Information tab on the datasheet.

Author Name

Character

The name of the person proposing the recommendation.

You can select a team member from a list of current human resources.

This field is available on the General Information tab on the datasheet.

Business Impact

Character

The impact to the manufacturing process during the recommendation implementation.

You can choose this value from a list of the following options:

• Safety

• Environmental

• Production

• Economic

This field is available on the General Information tab on the datasheet.

Completed

Logical

Indicates that the recommendation is complete.

You can set this value to True to indicate that this recommendation is complete.

Completion Comments

Text

Details about the completed recommendation.

This field is required if the value in the Status field is Rejected, Cancelled,or Superseded.

This field is labeled Close-Out Comments and is available on the General Information tab on the datasheet.

Creation Date

Date

The date the recommendation was created.

This field is disabled and populated automatically with the date on which the RA Recommendation was created.

This field is available on the General Information tab on the datasheet.

Date Reviewed

Date

The date the recommendation status was changed to Reviewed.

This field is populated automatically with the current date when the Status field is updated to Reviewed.

Days before Due Date to be Notified

Number

The numbers of days prior to the target date that the email message should be sent.

This field is enabled only when the Alert Responsible Part When Due? field is set to True, in which case this field is required.

This field is labeled Days before Due Date to be Alerted and is available on the Alert tab on the datasheet.

Equipment Technical Number

Character

The technical number of the piece of equipment for which the recommendation is being made.

When you select a value in the Equipment ID field, this field is populated automatically with the value in the Equipment Technical Number field of the associated Equipment.

This field is labeled Technical Number and is available on the General Information tab on the datasheet.

Final Action Taken

Text

The actions taken to implement the recommendation.

You can define this field manually by typing a description of final actions in this field.

Final Approver Name

Character

The name of the person responsible for approving the recommendation and the associated cost.

This field contains a list of all Security Users in the database, presented in the following format:

<last name>, <first name>, <user ID>

You can select a user from the list.

This field is available on the General Information tab on the datasheet.

Frequency of Alert After Due Date

Character

The frequency after the target date that the alert will be resent.

This field is enabled only when the value in the Alert Responsible Part When Due? field is True, in which case this field is required, and you can choose a value from the list of following values:

• Never

• Daily

• Weekly

• Monthly

• Yearly

This field is available on the Alert tab on the datasheet.

Functional Location ID

Character

The ID of the Functional Location that is either linked to the Equipment that appears in the Equipment ID field or linked separately to the RA Recommendation.

This value is populated automatically if a Functional Location exists and is linked to the Equipment that appears in the Equipment ID field. You can also select <insert ellipsis icon> to search for the desired Functional Location, select it. When you select OK, the Functional Location is linked to the RA Recommendation.

This field is available on the General Information tab on the datasheet.

Implemented Date

Date

The date the recommendation was implemented.

This field is populated automatically when the RA Recommendation is implemented. When this occurs, the field becomes disabled.

This field is available on the General Information tab on the datasheet.

Implementation Alert Text

Text

Text the user can add that will be sent in the body of the alert to the assignee to remind them the recommendation must be met by the target date.

You can type the text you wish to appear in the Alert email.

This field is available on the Alert tab on the datasheet.

Mandatory Date

Date

The date by which the recommendation must be implemented.

You can select a date using the Calendar tool.

This field is available on the General Information tab on the datasheet.

Recommendation Basis

Character

Background information about why the recommendation is being made.

The reason the recommended action is needed.

You can type any necessary background information in this field.

This field is available on the General Information tab on the datasheet.

Recommendation Closure Date

Date

The date the recommendation status is changed to Implemented, Rejected, or Superseded.

This field is populated automatically with the current date when the value in the status field is changed to Implemented, Rejected, or Superseded.

Recommendation Description

Text

A detailed description of the recommendation. 

You can type a description of the recommendation in this field.

This field is available on the General Information tab on the datasheet.

Recommendation Headline

Character

A brief summary of the recommendation. 

You can type a brief summary of the recommendation in this field.

This field is available on the General Information tab on the datasheet.

Recommendation ID

Character

The ID for the RA Recommendation.

This field is populated automatically with a unique name (e.g., REC_888) when the recommendation is created. You can change this value if desired.

This field is available on the General Information tab on the datasheet.  

Recommendation Priority

Character

A value that represents the priority or criticality level of the recommendation for implementation.

You can chose from a list of the following values:

• High

• Medium

• Low

This field is available on the General Information tab on the datasheet.

Reevaluate?

Logical

Indicates whether team members should evaluate the recommendation again.

If this check box is selected, an alert will be sent to users specified in the Reevaluation Notification List field.

This field is available on the Alert tab on the datasheet.

Reevaluation Alert Body Text

Text

The message text in the body of the reevaluation alert, which will be sent to users in the reevaluation notification list.

This field is enabled only when the Reevaluate? field check box is selected. Then the field is required.

This field is available on the Alert tab on the datasheet.

Reevaluation Notification List

Character

Individuals that will be sent to the reevaluation alert.

This field is enabled only when the Reevaluate? field is set to True. Then the field is required. You can select from a list of names with Human Resources.

This field is labeled Reevaluation Alert List and is available on the Alert tab on the datasheet.

Reevaluation Date

Date

The date on which an alert is sent out to tell the alert recipient to re-evaluate the recommendation.

This field is enabled only when the Reevaluate? field is set to True. Then the field is required. You can select a date using the Calendar tool.

This field is available on the Alert tab on the datasheet.

Required Equipment Status

Character

The operating status the piece of equipment must be under, in order for the recommendation to be implemented.

You can choose from a list of the following values:

• On-line

• Off-line

• Not Applicable

This field is available on the General Information tab on the datasheet.

Reviewer Name

Character

The first and last name of the person who should review the information in the Recommendation before the recommended action is performed.

This field contains a list of all Security Users in the database, presented in the following format:

<last name>, <first name>, <user ID>

You can select a user from a list of security users in the database.

This field is available on the General Information tab on the datasheet.

Status

Character

The status of the recommendation.

You can choose from a list of the following values:

• Approved

• Created

• Pending Review

• Reviewed

• Rejected

• Canceled

• Superseded

• In Progress

• Implemented

When the is created, the field is set to Created, but can be modified if needed. This field is required.

You can send an alert only if the Status field is set to Approved or In Progress value.

This field is available on the General Information tab on the datasheet.

Status Changed By

Character

The ID of the user who last changed value in the Status field.

This field is populated automatically when the Status field is updated.

This value does not appear on the datasheet by Work default.

Status Changed by Name

Character

The name of the person who last changed the Status field.

This field is populated automatically when the Status field is updated.

This value does not appear on the datasheet by default.

Status Date

Date

The date the Status field was most recently changed.

This field is populated automatically with the current date when the Status field is updated.

This value does not appear on the datasheet by default.

Target Completion Date

Date

The date the recommendation is intended to be implemented.

You can select a date using the Calendar tool.  This field is required.

This field is available on the General Information tab on the datasheet.

Work Order Number

Character

The ID of the work order arising from the work request.

This field is populated automatically after a notification has been created in SAP.

This value does not appear on the datasheet by default.

Work Request Equipment

Character

The ID of the Equipment in SAP that is associated with the SAP Notification that was created.

This field is populated automatically after a notification has been created in SAP.

This field is available on the General Information tab on the datasheet.

Work Request Functional Location

Character

The ID of the Functional Location in SAP that is associated with the SAP Notification that was created.  

This field is populated automatically after a notification has been created in SAP.

This field is available on the General Information tab on the datasheet.

Work Request Reference

Character

The ID of the SAP Notification.

This field is populated automatically after a notification has been created in SAP.

This field is available on the General Information tab on the datasheet.

You can enter symbols and text in the Currency box. For example, you can enter the symbol for U.S. currency, $, or you can enter text for U.S. currency, US Dollars. Any data that you enter in the Cost boxes throughout the analysis must be appropriate for the type of currency that you enter in the Currency box.

A text field that stores any additional information about the Spares Analysis.

When you create a new Spares Analysis, the Number of Iterations is set to 1000 by default. You can enter a different number of iterations. If the number of iterations is large, it will take longer for the simulation results to run and will result in more accurate Monte Carlo results.

An Event Log is created for each holding level for every Spare for each iteration in a Spares Analysis. If you enable Event Logs for a Spares Analysis with a large number of iterations, a large number of Event Logs will be created, and the simulation will take longer to complete. When you enable Event Logs, you should change the number of iterations to a small number (i.e., one) so a small number of Event Log files will be created and the simulation will run in the shortest amount of time.

This is a required field. The name of each Spare Application must be unique to the root record.

The minimum holding level must be less than or equal to the maximum holding level. If you enter a value in the Minimum Holding Level box that is greater than the value in the Maximum Holding Level box, the Maximum Holding Level box will be updated automatically with the value in the Minimum Holding Level box.

For example, if the Maximum Holding Level box contains the value 3 and you enter 4 in the Minimum Holding Level box, the value in the Maximum Holding Level box will be set automatically to 4.

If you enter a value in the Normal Cost ($) box that is greater than the value in the Expedited Cost ($) box, the Expedited Cost ($) box will be updated automatically with the value in the Normal Cost ($) box.

For example, if the Expedited Cost ($) box contains the value 1000 and you enter 1500 in the Normal Cost ($) box, the value in the Expedited Cost ($) box will be set automatically to 1500.

For Failure Distribution information that you want to define manually, a list appears in which you can select the desired value. The value is set to Exponential by default, but you can select any of the following additional distribution types:

• Weibull
• Normal
• Lognormal

For Failure Distribution information that you have imported, this column displays the read-only distribution type of the analysis from which you have imported failure distribution information.

This is a required field. The name of each Failure Distribution must be unique to the root Spare Application record. This field is labeled Distribution Name on the datasheet.

• For Failure Distribution information that you want to define manually, you can enter a name in the Distribution Name field.
• For Failure Distribution information that you have imported, the Distribution Name field displays the hyperlinked value that is stored in the Analysis ID field in the Reliability Distribution or Reliability Growth record with which you associated failure distribution information. You can select the hyperlink to open the analysis.

Displays one of the following parameters, depending on the distribution type:

• For a Weibull distribution, displays the Beta value.
• For an Exponential distribution, displays the Mean Time Between Failures value.
• For a Normal distribution, displays the Mean value.
• For a Lognormal distribution, displays the Mu value.

By default, values up to four decimal places are displayed in the <Parameter 1> column. If you select a cell in the <Parameter 1> column for a parameter that can be modified, all decimal places for the value will be displayed.

Displays one of the following parameters, depending on the distribution type:

• For a Weibull distribution, displays the Eta value.
• For an Exponential distribution, nothing is displayed. The Mean Time Between Failures value that is displayed in the <Parameter 1> column is the only parameter in an Exponential distribution.
• For a Normal distribution, displays the Standard Deviation value.
• For a Lognormal distribution, displays the Sigma value.

By default, values up to four decimal places are displayed in the <Parameter 2> column. If you select a cell in the <Parameter 2> column for a parameter that can be modified, all decimal places for the value will be displayed.

Displays one of the following parameters, depending on the distribution type:

• For a Weibull distribution, displays the Gamma value.
• For an Exponential distribution, nothing is displayed. The Mean Time Between Failures value displayed in the <Parameter 1> column is the only parameter in an Exponential distribution.
• For a Normal distribution, nothing is displayed. The Mean and Standard Deviation values that are displayed in the <Parameter 1> and <Parameter 2> columns are the only parameters in a Normal distribution.
• For a Lognormal distribution, displays the Gamma value.

By default, values up to four decimal places are displayed in the <Parameter 3> column. If you select a cell in the <Parameter 3> column for a parameter that can be modified, all decimal places for the value will be displayed.

For Failure Distribution information that you want to define manually, a list appears in which you can select the desired value. The value is set to Days by default, but you can select any of the following additional units of measure:

• Hours
• Weeks
• Months
• Years

For Failure Distribution information that you have imported, this column displays the read-only unit of measure used in the analysis from which you have imported Failure Distribution information.

Returns the list of Spares Analyses used in the Spares Analyses list on the RA Overview page.

Displays the subreport for Asset Data in the Reliability Distribution Analysis Report.

Displays the subreport for Asset Data in the Reliability Growth Analysis Report.

Displays the SSRS Report for Distribution Analysis in the Reliability Distribution Analysis Report.

Returns data for Exponential Distributions in the Probability Distribution Report.

Displays the subreport for Failure data in the Reliability Growth Analysis Report.

Displays data in the main and subreports in the Reliability Growth Analysis Report.

Displays the main report of the SSRS Reliability Growth Analysis Report.

Returns data for Lognormal Distributions of failure data in the Probability Distribution Report.

Returns data for Normal Distributions in the Probability Distribution Report.

Returns data for the Probability Distribution Report.

Displays the SSRS Probability Distribution Report for Probability Distribution Analysis.

This is the main query that returns data for the Production Analysis Report.

Returns the Lines data for the Production Analysis Report.

Returns Regions data for the Production Analysis Report.

Displays the SSRS Production Analysis Report.

Returns data for the Reliability Distribution Report, including TTF data.

Returns TTR data for the Weibull Distribution in the Reliability Distribution Analysis Report.

Displays the Spare information for a Spares Analysis in the Spares Analysis Report.

This is a subreport to the Spares Analysis report, named SparesApplication.

Returns application information corresponding to a particular Spare in a Spares Analysis.

Returns chart data tied to a particular Spares Analysis.

Returns a list of charts for a particular Spares Analysis.

Displays information and graphs for a Spares Analysis.

This report also uses the SparesChart and Spares subreports.

Displays the Recommendation Summary chart on the RA Overview page.

Displays the top 10 Functional Locations based on costs from Work Histories in the Top 10 Bad Actors chart on the RA Overview page.

Displays the top 10 Equipment linked by the Reliability family in the Top 10 Bad Actors chart on the RA Overview page.

Displays the top 10 Functional Locations linked by the Reliability family in the Top 10 Bad Actors chart on the RA Overview page.

Displays the LPO from PLA by Equipment in the Top 10 Bad Actors chart on the RA Overview page.

Displays the production costs from PLA by Equipment in the Top 10 Bad Actors chart on the RA Overview page.

Displays the top 10 assets or Functional Locations that are costing you the most with PLA in the Top 10 Bad Actors chart on the RA Overview page.

Displays the top 10 assets or Functional Locations that are costing you the most without PLA in the Top 10 Bad Actors chart on the RA Overview page.

Displays the costs from work history in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays the sum of maintenance costs and production costs of a Functional Location in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays the equipment with FE recommendations implemented in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays the equipment with FE recommendations implemented for all years in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays the results of the last 5 years in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays maintenance costs in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays the total cost from work history in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays total cost from work history and PLA in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays results with PLA in the Track Results By recommendation Implementation Year chart on the RA Overview page.

Displays results without PLA in the Track Results By recommendation Implementation Year chart on the RA Overview page.

This query is used to create a Production Analysis from PLA Production Data.