traceability system
TRANSCRIPT
05/02/23 Process Traceability 1
Process TraceabilityTo Have the ability to Trace, Identify and Validate Several stages on the Process.
05/02/23 Process Traceability 2
Process Traceability Production Lines
System LayoutEach Station Collect data for Verification,Validation and Record on SQL Data Baseand on Others Data Base for Sharing Information
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 3
Process Traceability Production Lines
Panel StationVerification and Validation of Aluminumcross check with Panel Plus ProductionData and Reports SQL
Data Base
Panel PCB Aging Adjustment Final Assy. Packing
Other Data Base
05/02/23 Process Traceability 4
Process Traceability Production Lines
PCB Station Travel Tag and Panel cross check,Master Data for TV Set, Other ItemsBecome slave data
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 5
Process Traceability Production Lines
Aging Station Verification, Validation and crosscheck of Main Board, Power BoardAnd Other with Travel Tag
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 6
Process Traceability Production Lines
Repair Station Change Status of TV set to Repair and All Components, Fill Up Repair DataBefore Introduce Again to Line
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 7
Process Traceability Production Lines
Packing Station Verification, Validation and crosscheck of Pedestal, Packing Boxwith Travel Tag
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 8
Process Traceability Others Benefits
Panel Control : Track Panel Input, Output and Defects By Serial Number Process Balance : Review Input, Output and WIP of Production Set’s,
plus balance of Input Against Output and Process Time of Each Set, Plus Missing Set’s
Repair Control : Tag Production Set’s Plus All Components to trace changeable partsInside the Set and Follow up repair data
Add Components : Ready for Adding Components as soon as they came with Barcode or other form of ID
Dual Backup : Information will be duplicated in 2 Servers (SQL and Other) Linked to Backend and SMT : Information will be Share Between Servers for Analysis and Quick Action in case of Problems Panel PCB Aging AdjustmentFinal Assy. Packing
05/02/23 Process Traceability 9
Process Traceability Production Lines
First Phase Aging Station will Collect : Travel Tag, Panel Serial Number and Main Board Packing Station will Collect : Travel TagAnd Panel Serial Number for ValidationWith Previous Data
SQLData Base
Panel PCB Aging Adjustment Final Assy. Packing
OtherData Base
05/02/23 Process Traceability 10
Process Traceability Others Issues
Biometric Log In : All Application Require Employee to Register on Training
GO - NO GO : Application are “Go - No Go” Stile, Good and Bad Process are Recorded for Log’s but only Good Can Continue and Validated on Next Process
Repair Control : Tag Production Set’s Plus All Components to trace changeable
parts Inside the Set and Follow up repair data Add Components : Ready for Adding Components as soon as they came
with Barcode or other form of ID
Dual Backup : Information will be duplicated in 2 Servers (PAVCA and Other) Linked to Backend and SMT: Information will be Share Between Servers for Analysis and Quick Action in case of Problems
Panel PCB Aging AdjustmentFinal Assy. Packing
05/02/23 Process Traceability 11
Process Traceability Others Issues
Laboratory Equipment : This System will Replace Lab Equipment of Panel, Travel Tag, Pedestal and Packing Box Reading
Data : Data will be on a Different Server and Data Base from Lab DataWill have same Information Plus Additional Information and Validation’s
Reports : Reports can be Generated form SQL but Mainly we will use Other DB andWeb Base Page and custom Made Reports
Custom Request : All are customize, base on Line configuration and Company size
Time for Full Implementation : 6 to 8 MonthsPanel PCB Aging AdjustmentFinal Assy. Packing
05/02/23 Process Traceability 12
Process Traceability System Screens
Panel PCB Aging AdjustmentFinal Assy. Packing
05/02/23 Process Traceability 13
Process Traceability Production Lines
SQLData Base
OtherData BaseTV Set
Panel Tuner Block Pedestal Packing Box
Main Board
Others
Model Name, Serial Number, Input Date, Status, Output Date, In/Out Person, Unique ID
New Item New ItemPart Number Verification, Input Date, In Person, Unique ID
Part Number, Serial Number, Input Date, In Person, Unique ID
N-Item’s can be AddedPart Number, Serial Number or Only Verification, Input Date, In Person, Unique ID
Material, Machine, Shift’s, Operator, LineSMT
Back
Front
05/02/23 Process Traceability 14
Process Traceability Production to SMT
Frontend
Backend
SMT
05/02/23 Process Traceability 15
Process Traceability Production Lines
SQLData Base
OtherData Base
Data can be Filter or Search base on Custom Request as :From Date to Date, By Model by Date, By Serial Number of any of the Components, Etc.
05/02/23 Process Traceability 16
Process Traceability Backend Lines
SQLData Base
OtherData Base
Data can be Filter or Search base on Custom Request as :From Date to Date, By Model by Date, By Serial Number of any of the Components, Etc.
05/02/23 Process Traceability 17
Process Traceability SMT Lines
SQLData Base
OtherData Base
Data can be Filter or Search base on Custom Request as :From Date to Date, By Model by Date, By Serial Number of any of the Components, Etc.