SOP-MES0023 SQC Configuration

Introduction

Using SQC-Line List, users can use a shop floor ID to Manage HPU Baselines, Export Target Parameters, Load Target Parameters, and Import HPU Baselines.

SQC – Line List Functionalities

Managing HPU Baselines

The Managing HPU Baselines function allows the user to Add, Import, Edit, and Delete HPU Baselines. The user can access the Managing HPU Baselines function by entering an SFDC ID into the respective field, selecting the line from the results list by checking the box to the left of the line, and clicking Manage HPU Baselines.

Click on Manage HPU Baselines icon in the list. The HPU manage screen is displayed.

There is a general filter by Part Number or Process Name. To execute the filter, enter Part Number or Process Name and click Filter.

Adding HPU Baselines

To add an HPU Baseline, follow the steps below:

1) Click on "Manage HPU Baselines" icon and click on "Add HPU Baseline" on the tasks panel.

A pop up to Add HPU Baselines is displayed:

The following fields are displayed:

• SFDC ID:
• Part Number:
  
• Process
  
• Process HPU
  
• Unattended Time
  
• Oracle HPU
  

The Part Number and the Process Name fields begin to automatically generate results once the user begins typing in the fields.

Click Save after entering the mandatory fields to complete the step.

The created HPU Baseline is displayed on the List screen.

Editing HPU Baselines

To Edit an HPU baseline, the user must select an existing HPU line from the list and click onEdit icon. The HPU Baseline window displays, which appears identical to the Add HPU Baseline window. However, the user cannot change the SFDC ID or Part Number.

  
After making the appropriate changes, click Save button to complete the step. A message will appear saying the edit was successful.

Deleting HPU Baselines

To delete a baseline, simply check the box of the item(s) to be deleted and click on Delete HPU Baseline. This will generate a popup confirming the deletion. Click Yes.

Importing HPU Lines

Go toSQC Configuration Maintenance. The user can import HPU data directly form this screen by clicking on Import HPU Baselines in the Task Panel or click on "Manage HPU Baselines" icon.

Figure 10: Manage HPU Baseline

Figure 11: .CSV File Model

The .CSV file layout must be: Part Number, Process Name, Process HPU, Unattended Time and Oracle HPU.

Figure 12: Import HPU Baselines

2) Click on "Import HPU Baselines" on the task on panel. The screen to import Baselines for Line is displayed with the following fields:

* Line (Combo Box disabled)

*.CSV File (Open Browser button displayed beside this field to select the path where the file is located in).

3) Click on "Open Browser" icon and select the .CSV file and click on "OK".

The "Report Results" screen is displayed with the following message: "All HPU Baselines have been imported to the line successfully. See Details"

Figure 13: Report Result

To see the message details, click on "Details" button.

Figure 14: Import Details

All part numbers are listed as "Successfully Imported" and all the HPU Baselines are displayed in the Baseline's list with exactly the same data from the .CSV file.

Printing HPU Lines

To print HPU Lines, go to MDS Client > SQC Configuration Maintenance and click on "Manage HPU Baselines" icon for the line.

1) Click on "Import HPU Baselines" on the task panel and click on "Open Browser" icon and select the .CSV file. Click "OK".

2) Click on "Print" button.

Figure 15: Print HPU Baselines

A report is generated:

Figure 16: Generated Report

Export Target Parameters

The Export Target Parameters will export the previous loaded .CSV file containing the project parameters.

Figure 18: Export Target Parameter

These parameters are loaded to MDS Client and will be handled in the MESR.

To export target parameters, click on Export Target Parameters in the Tasks panel, select the .CSV file and the path to save the file, and click Save.

Load Target Parameters

To Load Target Parameters, go to MDS Client > SQC Configuration Maintenance and click on "Load Target Parameter" in the Tasks panel.

Figure 17: Load Target Parameters

To load target Parameters, download the CSV template file "Get .CSV Template" in the "Load Target Parameters" pop up.

Select how to load the data from the following two options:

• Incremental: adds the new target tables and updates the values.
• Update: deletes the current data and loads the target data as-is on the CSV file.

The .CSV template parameters are as follows:

Part Number,Family,Process,Process

Group,TargetYield,TargetTPhr,TargetDPMO,TargetCycleTime,TargetHPU,ResourceHr

STRING(50)x,STRING(50)x,STRING(30)x,STRING(50)x,DECIMAL(999.99)+,INTEGER(2147483647)+,DECIMAL(99999.99)+,

DECIMAL(99999.99)+,DECIMAL(99999.99)+,DECIMALDECIMAL(99999.999999)+

• First line: field name
• Second line: field type ("x" means at least one must be filled out by line - the key, "+" means one or more fields must be filled out - the targets)
• Third to last line: target values - consumed from the higher level to deeper, ex:

                     *If a target is set only for a Mfg Line, only the "key" column Mfg Line must be filled out and the target values

                     *If a targets is set for a Process on a specific Mfg Line only the key columns Mfg Line and Process must be filled out and the target values

If there are more than one target configurations for a specific key, the data will be loaded but the reports can use both; please avoid this by using a well-organized CSV file.

The Import task does not validate if the data is correct on the CSV file, i.e., if the Part Numbers or Mfg Line exists on the MDS tables. Please make sure all data set is already configured on MDS tables.