Skip to content

WIPHistory DataSet#

Source: DWH

Fields#

The WIPHistory Data Set has the following fields:

Field Description DataType Field Type Order
WIPDateTime DateTime Timestamp 1
Enterprise_Name String Dimension 2
Enterprise_DisplayOrder Integer Metric 3
Site_Name String Dimension 4
Site_DisplayOrder Integer Metric 5
Facility_Name String Dimension 6
Facility_DisplayOrder Integer Metric 7
Area_Name String Dimension 8
Area_Type String Dimension 9
Area_DisplayOrder Integer Metric 10
Step_Name String Dimension 11
Step_Type String Dimension 12
Step_DisplayOrder Integer Metric 13
Calendar_Name String Dimension 14
Shift_Name String Dimension 15
CalendarDay_FY Integer Metric 16
CalendarDay_FQ Integer Metric 17
CalendarDay_FM Integer Metric 18
CalendarDay_FW Integer Metric 19
CalendarDay Date Timestamp 20
Product_Name String Dimension 21
Product_Type String Dimension 22
Material_Type String Dimension 23
Material_Form String Dimension 24
Material_PrimaryUnits String Dimension 25
ProductionOrder_Name String Dimension 26
ProductGroup_Name String Dimension 27
ProductGroup_Type String Dimension 28
Flow_Name String Dimension 29
Queued_PrimaryQty Decimal Metric 30
Dispatched_PrimaryQty Decimal Metric 31
InProcess_PrimaryQty Decimal Metric 32
Processed_PrimaryQty Decimal Metric 33
InTransit_PrimaryQty Decimal Metric 34
Queued_Hold_PrimaryQty Decimal Metric 35
Dispatched_Hold_PrimaryQty Decimal Metric 36
InProcess_Hold_PrimaryQty Decimal Metric 37
Processed_Hold_PrimaryQty Decimal Metric 38
InTransit_Hold_PrimaryQty Decimal Metric 39
Queued_Rework_PrimaryQty Decimal Metric 40
Dispatched_Rework_PrimaryQty Decimal Metric 41
InProcess_Rework_PrimaryQty Decimal Metric 42
Processed_Rework_PrimaryQty Decimal Metric 43
InTransit_Rework_PrimaryQty Decimal Metric 44
VolumeIn Decimal Metric 45
VolumeOut Decimal Metric 46
Queued_Lag Integer Metric 47
Dispatched_Lag Integer Metric 48
InProcess_Lag Integer Metric 49
Processed_Lag Integer Metric 50
_created_at DateTime Timestamp 51

Table: WIPHistory fields