Data mapping

IBM® Plant Performance Analytics, Private processes two forms of data: Master data and metadata, and Event data also known as measurement data.

Master data and metadata

The Equipment Hierarchy consisting of the enterprise, plant, area, site, line, station and equipment or asset.

Enterprise: The organization or manufacturer.
Site: The location, name and address of the manufacturing plant. Other details that can also be defined are for Site are longitude and latitude.
Area: The area defined for a specific processes such as for example: machine shop, weld assembly shop, paint shop, press shop, and power train assembly.
Line: A manufacturing process where a production item is moved from station to subsequent station where a series of operations are carried out to produce an end product.
Station: A defined location where a specific operation is executed.
Equipment: The resource required for a specific operation, for example: weld robot, paint robot, end attachment.

The measurement types to be defined for each of the data set being loaded to gain insights. For example current, fault & warning, torque, and cycle length.

The data to be processed should adhere to the Data Dictionary as defined by the solution. The data dictionary is a mapping of Field Name, Data Type and Description. For example:

Table 1. The data dictionary
Field name	Data type	Description
Equip_ Name	String	ID of Equipment, for example, WR101, MR102
Equip_Description	String	String Name of Equipment for example, Weld Robot #1, Mat Handling Robot #1
Equip_Location ID	Integer	Work cell ID
Equip_Location	String	Work cell Location for example: Work Station Under Body Weld Assembly, MainBody_Weld Assy, Paint Shop
Equip_Manufacturing Line	String	The name of the line for example: Line1, Line2.
Equip_Area	String	The assembly area, for example: Body Weld Assembly, Paint.
Equip_Site	String	Site location, for example: Site_1, Site_2.

Note: The output of the analytical model is written directly to the PPA Datastore.