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.

<img src="/mes_wiki/images/thumb/e/eb/SQC_Manage_HPU_Baselines_1.jpg/715px-SQC_Manage_HPU_Baselines_1.jpg" _fck_mw_filename="SQC Manage HPU Baselines 1.jpg" _fck_mw_width="715" _fck_mw_height="160" alt="SQC Manage HPU Baselines 1.jpg" />

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

<img src="/mes_wiki/images/thumb/b/b4/SQC_Manage_HPU_Baselines_2.jpg/716px-SQC_Manage_HPU_Baselines_2.jpg" _fck_mw_filename="SQC Manage HPU Baselines 2.jpg" _fck_mw_width="716" _fck_mw_height="152" alt="SQC Manage HPU Baselines 2.jpg" />

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:

<img src="/mes_wiki/images/thumb/d/d9/SQC_Add_HPU_Baseline_1.jpg/450px-SQC_Add_HPU_Baseline_1.jpg" _fck_mw_filename="SQC Add HPU Baseline 1.jpg" _fck_mw_width="450" _fck_mw_height="234" alt="SQC Add HPU Baseline 1.jpg" />

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.

<img src="/mes_wiki/images/5/54/SQC_Add_HPU_Success_Message.jpg" _fck_mw_filename="SQC Add HPU Success Message.jpg" alt="" />

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.

<img src="/mes_wiki/images/thumb/e/ec/SQC_Edit_HPU_Baseline.jpg/560px-SQC_Edit_HPU_Baseline.jpg" _fck_mw_filename="SQC Edit HPU Baseline.jpg" _fck_mw_width="560" _fck_mw_height="269" alt="SQC Edit HPU Baseline.jpg" />
  
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.

<img src="/mes_wiki/images/thumb/d/dd/Delete_HPU_Baseline.jpg/560px-Delete_HPU_Baseline.jpg" _fck_mw_filename="Delete HPU Baseline.jpg" _fck_mw_width="560" _fck_mw_height="269" alt="Delete HPU Baseline.jpg" />

Importing HPU Lines

The user can import HPU data directly form this screen by clicking on Import HPU Baselines in the Task Panel.

Manage HPU Baseline

<img src="/mes_wiki/images/0/06/Image010.png" _fck_mw_filename="Image010.png" alt="" />

.CSV File Model

<img src="/mes_wiki/images/thumb/7/79/Image011.png/800px-Image011.png" _fck_mw_filename="Image011.png" _fck_mw_width="800" alt="Image011.png" />

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

 Import HPU Baselines

<img src="/mes_wiki/images/thumb/9/91/Import_HPU_Baseline.jpg/499px-Import_HPU_Baseline.jpg" _fck_mw_filename="Import HPU Baseline.jpg" _fck_mw_width="500" _fck_mw_height="210" alt="Import HPU Baseline.jpg" />

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

• SFDC ID
• .CSV

3) Click on Search and select the .CSV file and click on OK.

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

Report Result

<img src="/mes_wiki/images/9/9e/Image013.png" _fck_mw_filename="Image013.png" alt="" />

To see the message details, click Details.

Import Details

<img src="/mes_wiki/images/1/1d/Image014.png" _fck_mw_filename="Image014.png" alt="" />

All part numbers are listed as "successfully imported" and all the HPU Baselines are displayed in the Baseline list with 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

<img src="/mes_wiki/images/5/5b/Image015.png" _fck_mw_filename="Image015.png" alt="" />

A report is generated:

Figure 16: Generated Report

<img src="/mes_wiki/images/thumb/b/ba/Image016.png/800px-Image016.png" _fck_mw_filename="Image016.png" _fck_mw_width="800" alt="Image016.png" />

Export Target Parameters

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

Figure 18: Export Target Parameter

<img src="/mes_wiki/images/d/d3/Image018.png" _fck_mw_filename="Image018.png" alt="" />

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

<img src="/mes_wiki/images/thumb/9/9f/Load_target_parameters_with_popup.jpg/600px-Load_target_parameters_with_popup.jpg" _fck_mw_filename="Load target parameters with popup.jpg" _fck_mw_width="600" _fck_mw_height="336" alt="Load target parameters with popup.jpg" />

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.