|
|
| Line 1: |
Line 1: |
| − | == SQC – Line List Functionalities ==
| |
| | | | |
| − | There is just one available action to be executed from the Line List screen: Manage HPU Lines. See the next topics for further information.
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | === Managing HPU Lines ===
| |
| − |
| |
| − | '''Figure 3: SQC Line List '''
| |
| − |
| |
| − | [[Image:Image03.png|800px|Image03.png]]
| |
| − |
| |
| − | <br> Click on '''Manage HPU Baselines''' icon in the list. The HPU manage screen is displayed.
| |
| − |
| |
| − | <br> '''Figure 4: HPU Baselines Manage Screen'''
| |
| − |
| |
| − | [[Image:Image04.png|800px|Image04.png]]
| |
| − |
| |
| − | <br> This screen allows the user to:
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | #'''Add HPU Baselines;'''
| |
| − | #'''Import HPU Baselines;'''
| |
| − | #'''Edit HPU Baselines;'''
| |
| − | #'''Delete HPU Baselines;'''
| |
| − |
| |
| − | There is a general filter by Part Number or Process Name. To execute the filter, enter the data and click on '''Filter'''.
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | ==== Adding HPU Baselines ====
| |
| − |
| |
| − | To add an HPU Baseline, follow the steps below:
| |
| − |
| |
| − | <br> 1) Click on "'''Manage HPU Baselines'''" icon and click on "'''Add HPU Baseline'''" on the tasks panel.
| |
| − |
| |
| − | <br> '''Figure 5: Add HPU - Task Panel'''
| |
| − |
| |
| − | [[Image:Image05.png|800px|Image05.png]]
| |
| − |
| |
| − | <br> A pop up to Add HPU Baselines is displayed:
| |
| − |
| |
| − | <br> '''Figure 6: Add HPU Baseline'''
| |
| − |
| |
| − | [[Image:Image06.png]]
| |
| − |
| |
| − | <br> The following fields are displayed and the user must enter data for the mandatory fields in blue:
| |
| − |
| |
| − | <br> <nowiki>* </nowiki>'''Line''' (Combo Box disabled) automatically selected, due to is the same line selected in the list.
| |
| − |
| |
| − | <nowiki>* </nowiki>'''Part Number''' (Combo Box)
| |
| − |
| |
| − | <nowiki>* </nowiki>'''Process Name''' (Combo Box)
| |
| − |
| |
| − | <nowiki>* </nowiki>'''Process HPU '''(Text Field)
| |
| − |
| |
| − | <nowiki>* </nowiki>'''Unattended Time '''(Text Field)
| |
| − |
| |
| − | <nowiki>* </nowiki>'''Oracle HPU''' (Text Field)
| |
| − |
| |
| − | <br> The'''Part Number''' and the '''Process Name''' are displayed in the drop down list from database.
| |
| − |
| |
| − | Click on "'''OK'''" button after enter the mandatory fields to conclude.
| |
| − |
| |
| − | <br> The application displays the following message:
| |
| − |
| |
| − | <br> '''Figure 7: Successful Message'''
| |
| − |
| |
| − | [[Image:Image07.png]]
| |
| − |
| |
| − | <br> 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 on'''Edit '''icon.
| |
| − |
| |
| − | <br> The HPU Baseline window displays with the Baseline information. The process to edit is the same as to add baselines.
| |
| − |
| |
| − | <br> '''Figure 8: Edit HPU Baseline'''
| |
| − |
| |
| − | [[Image:Image08.png|800px|Image08.png]]
| |
| − |
| |
| − | <br> Note: The'''Line''' and '''Part Number''' fields can not be updated:
| |
| − |
| |
| − | <br> Click on "'''OK'''" button to conclude.
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | ==== Deleting HPU Baselines ====
| |
| − |
| |
| − | 1) On the Baseline List, select an existing HPU Baseline and click on '''Delete''' Icon
| |
| − |
| |
| − | <br> '''Figure 9: Deleting HPU'''
| |
| − |
| |
| − | [[Image:Image09.png|800px|Image09.png]]
| |
| − |
| |
| − | <br> Click on "'''OK'''" button;
| |
| − |
| |
| − | A confirmation message displays. Click on '''Yes''' to conclude.
| |
| − |
| |
| − | === Importing HPU Lines ===
| |
| − |
| |
| − | Go to'''SQC 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.
| |
| − |
| |
| − | <br> '''Figure 10: Manage HPU Baseline'''
| |
| − |
| |
| − | [[Image:Image010.png]]
| |
| − |
| |
| − | <br> '''Figure 11: .CSV File Model'''
| |
| − |
| |
| − | [[Image:Image011.png|800px|Image011.png]]
| |
| − |
| |
| − | <br> The .CSV file layout must be: Part Number, Process Name, Process HPU, Unattended Time and Oracle HPU.
| |
| − |
| |
| − | <br> '''Figure 12: Import HPU Baselines'''
| |
| − |
| |
| − | [[Image:Image012.png|800px|Image012.png]]
| |
| − |
| |
| − | <br> 2) Click on "'''Import HPU Baselines'''" on the task on panel. The screen to import Baselines for Line is displayed with the following fields:
| |
| − |
| |
| − | <br> <nowiki>* Line (Combo Box disabled)</nowiki>
| |
| − |
| |
| − | <nowiki>*.CSV File (Open Browser button displayed beside this field to select the path where the file is located in).</nowiki>
| |
| − |
| |
| − | <br> 3) Click on "'''Open Browser'''" icon and select the .CSV file and click on "'''OK'''".
| |
| − |
| |
| − | <br> The "Report Results" screen is displayed with the following message: "All HPU Baselines have been imported to the line successfully. See Details"
| |
| − |
| |
| − | <br> '''Figure 13: Report Result'''
| |
| − |
| |
| − | [[Image:Image013.png]]
| |
| − |
| |
| − | <br> To see the message details, click on "'''Details'''" button.
| |
| − |
| |
| − | <br> '''Figure 14: Import Details'''
| |
| − |
| |
| − | [[Image:Image014.png]]
| |
| − |
| |
| − | <br> 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.
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | === Printing HPU Lines ===
| |
| − |
| |
| − | To print HPU Lines, go to MDS Client > SQC Configuration Maintenance and click on "'''Manage HPU Baselines'''" icon for the line.
| |
| − |
| |
| − | <br> 1) Click on "'''Import HPU Baselines'''" on the task panel and click on "'''Open Browser'''" icon and select the .CSV file. Click "'''OK'''".
| |
| − |
| |
| − | <br> 2) Click on "'''Print'''" button.
| |
| − |
| |
| − | <br> '''Figure 15: Print HPU Baselines'''
| |
| − |
| |
| − | [[Image:Image015.png]]
| |
| − |
| |
| − | <br> A report is generated:
| |
| − |
| |
| − | <br> '''Figure 16: Generated Report'''
| |
| − |
| |
| − | [[Image:Image016.png|800px|Image016.png]]
| |
| − |
| |
| − | === Load Target Parameters ===
| |
| − |
| |
| − | To Load Target Parameters, go to MDS Client > SQC Configuration Maintenance and click on "'''Load Target Parameter'''" in the Tasks panel.
| |
| − |
| |
| − | <br> '''Figure 17: Load Target Parameters'''
| |
| − |
| |
| − | [[Image:Image017.png]]
| |
| − |
| |
| − | <br> To load target Parameters, the CSV template file can be download at '''"Get .CSV Template"''' in the "Load Target Parameters" pop up.
| |
| − |
| |
| − | <br> The Import process can run on the following ways:
| |
| − |
| |
| − | *Incremental: will only add the new target tables and update the values.
| |
| − | *Update: will delete the current data and load the target data as is on the CSV file.
| |
| − |
| |
| − | Following the .CSV file template:
| |
| − |
| |
| − | <br> '''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)+
| |
| − |
| |
| − | <br> '''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:
| |
| − |
| |
| − | <br> 1) If a target is set only for a Mfg Line, only the "key" column Mfg Line must be filled out and the target values
| |
| − |
| |
| − | <br> 2) 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
| |
| − |
| |
| − | <br> If there are more than one target configuration for a specific "key" the data will be loaded but the reports can use both - please avoid that with a good organization on the CSV file.
| |
| − |
| |
| − | <br> 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.
| |
| − |
| |
| − | <br>
| |
| − |
| |
| − | === Export Target Parameters ===
| |
| − |
| |
| − | The Export Target Parameters will export the previous loaded .CSV file tha contain the project parameters. This file is generated fro Nagios system.
| |
| − |
| |
| − | <br> '''Figure 18: Export Target Parameter'''
| |
| − |
| |
| − | [[Image:Image018.png]]
| |
| − |
| |
| − | <br> These parameters are loaded to MDS Client and will be handled in the MESR.
| |
| − |
| |
| − | <br> To export target parameters, click on '''Export Target Parameters''' in the Tasks panel, select the .CSV file and the path to save de file and click on '''Save'''.
| |
