Difference between revisions of "Data Model Column Descriptions"

From Datonis
Jump to: navigation, search
(Added all column descriptions)
m
 
(8 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique  ID for the Workcenter
 
|Unique  ID for the Workcenter
 
|-
 
|-
Line 18: Line 18:
 
|Unique ID for the account
 
|Unique ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in MInt
 
|Workcenter Name in MInt
 
|-
 
|-
Line 101: Line 101:
 
|gas
 
|gas
 
|Utilities Gas Details
 
|Utilities Gas Details
 +
|-
 +
|workcenter_maintenance_threshold
 +
|The maximum number of hours the machine can run without maintenance
 +
|-
 +
|workcenter_work_done_since_last_maintenance
 +
|The number of hours passed after the last maintenance when the machine was running
 +
|-
 +
|workcenter_last_maintenance_time
 +
|The Date and Time for the last maintenance activity
 +
|-
 +
|workcenter_next_maintenance_time
 +
|The predicted next workcenter maintenance date.
 
|}
 
|}
  
−
=== '''WorkcenterShiftDownTimeReasonsFact''' ===
+
=== WorkcenterShiftDownTimeReasonsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for  the Workcenter
 
|Unique ID for  the Workcenter
 
|-
 
|-
Line 123: Line 135:
 
|Unique  ID for the account
 
|Unique  ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 144: Line 156:
 
|The count of total  idle slots
 
|The count of total  idle slots
 
|-
 
|-
−
|name
+
|reason_name
 
|Downtime Reason Name
 
|Downtime Reason Name
 
|-
 
|-
−
|code
+
|reason_code
 
|Downtime Reason Code
 
|Downtime Reason Code
 
|-
 
|-
−
|category_key
+
|reason_category_key
 
|Unique ID for  Downtime Category
 
|Unique ID for  Downtime Category
 
|-
 
|-
−
|category_code
+
|reason_category_code
 
|Downtime Category  Code
 
|Downtime Category  Code
 
|-
 
|-
−
|category_name
+
|reason_category_name
 
|Downtime Category  Name
 
|Downtime Category  Name
 
|-
 
|-
Line 169: Line 181:
 
|}
 
|}
  
−
=== '''WorkcenterShiftOperatorsFact''' ===
+
=== WorkcenterShiftOperatorsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 183: Line 195:
 
|Day for which the  shifts are planned
 
|Day for which the  shifts are planned
 
|-
 
|-
−
|operator
+
|operators
 
|Operator Name
 
|Operator Name
 
|-
 
|-
Line 189: Line 201:
 
|Unique  ID for the account
 
|Unique  ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 205: Line 217:
 
|}
 
|}
  
−
=== '''WorkcenterShiftRejectionsFact''' ===
+
=== WorkcenterShiftRejectionsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 225: Line 237:
 
|Unique ID for the account
 
|Unique ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 250: Line 262:
 
|}
 
|}
  
−
=== '''WorkcenterShiftP'''roductionParametersFact ===
+
=== WorkcenterShiftProductionParametersFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 270: Line 282:
 
|Unique ID for the account
 
|Unique ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 298: Line 310:
 
|}
 
|}
  
−
=== '''WorkcenterShiftP'''roductivityDownTimeReasonsFact ===
+
=== WorkcenterShiftProductivityDownTimeReasonsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 318: Line 330:
 
|Unique ID for the account
 
|Unique ID for the account
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 360: Line 372:
 
== Part Shift Productivity Data Model ==
 
== Part Shift Productivity Data Model ==
  
−
=== WorkcenterPartRoutingShiftDownTimeReasonsFact ===
+
=== WorkcenterPartOperationShiftDowntimeReasonsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique  ID for the Workcenter
 
|Unique  ID for the Workcenter
 
|-
 
|-
Line 374: Line 386:
 
|Unique  ID for the Part/ SKU
 
|Unique  ID for the Part/ SKU
 
|-
 
|-
−
|routing_key
+
|operation_key
 
|Unique  ID for the Operation
 
|Unique  ID for the Operation
 
|-
 
|-
Line 383: Line 395:
 
|Unique  ID for the Downtime Reason
 
|Unique  ID for the Downtime Reason
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 401: Line 413:
 
|Part  Name
 
|Part  Name
 
|-
 
|-
−
|routing_name
+
|operation_name
 
|Operation  Name
 
|Operation  Name
 
|-
 
|-
−
|duration
+
|downtime_duration
 
|Machine Downtime  duration in seconds
 
|Machine Downtime  duration in seconds
 
|-
 
|-
Line 410: Line 422:
 
|The count of total  idle slots
 
|The count of total  idle slots
 
|-
 
|-
−
|name
+
|reason_name
 
|Downtime Reason Name
 
|Downtime Reason Name
 
|-
 
|-
−
|code
+
|reason_code
 
|Downtime Reason Code
 
|Downtime Reason Code
 
|-
 
|-
Line 432: Line 444:
 
|}
 
|}
  
−
=== WorkcenterPartRoutingShiftFact ===
+
=== WorkcenterPartOperationShiftFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 446: Line 458:
 
|Unique  ID for the Part/ SKU
 
|Unique  ID for the Part/ SKU
 
|-
 
|-
−
|routing_key
+
|operation_key
 
|Unique  ID for the Operation
 
|Unique  ID for the Operation
 
|-
 
|-
Line 452: Line 464:
 
|Day  for which the shifts are planned
 
|Day  for which the shifts are planned
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 470: Line 482:
 
|Part  Name
 
|Part  Name
 
|-
 
|-
−
|routing_name
+
|operation_name
 
|Operation  Name
 
|Operation  Name
 
|-
 
|-
Line 536: Line 548:
 
|Utilities  Gas Details
 
|Utilities  Gas Details
 
|-
 
|-
−
|is_last_routing
+
|is_last_operation
 
|If an operation is  the last in that particular routing, this flag will be True.
 
|If an operation is  the last in that particular routing, this flag will be True.
 
|-
 
|-
Line 543: Line 555:
 
|}
 
|}
  
−
=== WorkcenterPartRoutingShiftRejectionsFact ===
+
=== WorkcenterPartOperationShiftRejectionsFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 557: Line 569:
 
|Unique ID for the  Part
 
|Unique ID for the  Part
 
|-
 
|-
−
|routing_key
+
|operation_key
 
|Unique ID for the  Operation
 
|Unique ID for the  Operation
 
|-
 
|-
Line 566: Line 578:
 
|Unique ID for the Rejection Code
 
|Unique ID for the Rejection Code
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in MInt
 
|Workcenter Name in MInt
 
|-
 
|-
Line 584: Line 596:
 
|Part Name
 
|Part Name
 
|-
 
|-
−
|routing_name
+
|operation_name
 
|Operation Name
 
|Operation Name
 
|-
 
|-
−
|quantity
+
|rejection_quantity
 
|Rejection Quantity
 
|Rejection Quantity
 
|-
 
|-
−
|name
+
|rejection_name
 
|Rejection Name
 
|Rejection Name
 
|-
 
|-
−
|code
+
|rejection_code
 
|Rejection Code
 
|Rejection Code
 
|}
 
|}
Line 602: Line 614:
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 617: Line 629:
 
|Unique ID for the  Parameter
 
|Unique ID for the  Parameter
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter Name in  MInt
 
|Workcenter Name in  MInt
 
|-
 
|-
Line 650: Line 662:
 
== Hourly Data Model ==
 
== Hourly Data Model ==
  
−
=== WorkcenteHourlyFact ===
+
=== WorkcenterHourlyFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique  ID for the Workcenter
 
|Unique  ID for the Workcenter
 
|-
 
|-
Line 661: Line 673:
 
|Unique  ID for the Shift
 
|Unique  ID for the Shift
 
|-
 
|-
−
|pph_from
+
|hour_start
 
|Hour  Start Time
 
|Hour  Start Time
 
|-
 
|-
−
|pph_to
+
|hour_end
 
|Hour  End Time
 
|Hour  End Time
 
|-
 
|-
Line 686: Line 698:
 
|-
 
|-
 
|planned_downtime
 
|planned_downtime
−
|Time  during which the machine had a Planned downtime booking
+
|Time  during which the machine had a Planned downtime reason booking
 
|-
 
|-
 
|unplanned_downtime
 
|unplanned_downtime
Line 694: Line 706:
 
|Shift  Name in MInt
 
|Shift  Name in MInt
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 740: Line 752:
 
|}
 
|}
  
−
=== WorkcenteHourlyRoutingEnergyFact ===
+
=== WorkcenterHourlyOperationEnergyFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|pph_from
+
|hour_start
 
|Hour Start Time
 
|Hour Start Time
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
−
|routing_key
+
|operation_key
 
|Unique  ID for the Operation
 
|Unique  ID for the Operation
 
|-
 
|-
Line 757: Line 769:
 
|Unique  ID for the Part/ SKU
 
|Unique  ID for the Part/ SKU
 
|-
 
|-
−
|pph_to
+
|hour_end
 
|Hour  End Time
 
|Hour  End Time
 
|-
 
|-
Line 775: Line 787:
 
|Shift  Name in MInt
 
|Shift  Name in MInt
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 803: Line 815:
 
|}
 
|}
  
−
=== WorkcenteHourlyProcessRoutingFact ===
+
=== WorkcenterHourlyProcessOperationFact ===
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column Name
 
!Column Name
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for  the Workcenter
 
|Unique ID for  the Workcenter
 
|-
 
|-
Line 823: Line 835:
 
|Unique ID for the  Parameter
 
|Unique ID for the  Parameter
 
|-
 
|-
−
|routing_key
+
|operation_key
 
|Unique  ID for the Operation
 
|Unique  ID for the Operation
 
|-
 
|-
Line 835: Line 847:
 
|Shift Name in MInt
 
|Shift Name in MInt
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 934: Line 946:
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for the  Workcenter
 
|Unique ID for the  Workcenter
 
|-
 
|-
Line 943: Line 955:
 
|Day for which the  shifts are planned
 
|Day for which the  shifts are planned
 
|-
 
|-
−
|pph_from
+
|hour_start
 
|Hour  Start Time
 
|Hour  Start Time
 
|-
 
|-
Line 949: Line 961:
 
|Unique ID for the  Parameter
 
|Unique ID for the  Parameter
 
|-
 
|-
−
|pph_to
+
|hour_end
 
|Hour  End Time
 
|Hour  End Time
 
|-
 
|-
Line 955: Line 967:
 
|Shift Name in MInt
 
|Shift Name in MInt
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 1,039: Line 1,051:
 
!Description
 
!Description
 
|-
 
|-
−
|machine_key
+
|workcenter_key
 
|Unique ID for  the Workcenter
 
|Unique ID for  the Workcenter
 
|-
 
|-
Line 1,045: Line 1,057:
 
|Unique ID for the  Shift
 
|Unique ID for the  Shift
 
|-
 
|-
−
|pph_from
+
|hour_start
 
|Hour  Start Time
 
|Hour  Start Time
 
|-
 
|-
Line 1,054: Line 1,066:
 
|Unique ID for the  Parameter
 
|Unique ID for the  Parameter
 
|-
 
|-
−
|pph_to
+
|hour_end
 
|Hour  End Time
 
|Hour  End Time
 
|-
 
|-
Line 1,126: Line 1,138:
 
|Shift Name in MInt
 
|Shift Name in MInt
 
|-
 
|-
−
|machine_name
+
|workcenter_name
 
|Workcenter  Name in MInt
 
|Workcenter  Name in MInt
 
|-
 
|-
Line 1,139: Line 1,151:
 
|-
 
|-
 
|_created_at
 
|_created_at
−
|Internal metric, not to be used by User
+
|Internal metric, not to be used by User
 
|-
 
|-
 
|_updated_at
 
|_updated_at
−
|Internal  metric, not to be used by User
+
|Internal metric, not to be used by User
 +
|}
 +
 
 +
=== PolicySchedule ===
 +
{| class="wikitable"
 +
!Column Name
 +
!Description
 +
|-
 +
|policy_key
 +
|Unique ID for the policy
 +
|-
 +
|policy_name
 +
|Name of the policy
 +
|-
 +
|license_key
 +
|Unique ID for the account license
 +
|-
 +
|cell_line_key
 +
|Unique ID for the Cell/ Line
 +
|-
 +
|cell_line_name
 +
|Name of the Cell/ Line
 +
|-
 +
|samples
 +
|Number of samples to test for a given policy
 +
|-
 +
|type
 +
|Type of policy
 +
|-
 +
|approvers
 +
|The email ID of the user who can approve the filled policy
 +
|-
 +
|policy_schedule_key
 +
|Unique ID for the policy booking schedule
 +
|-
 +
|policy_from
 +
|Start date of policy booking schedule
 +
|-
 +
|policy_to
 +
|End date of policy booking schedule
 +
|-
 +
|working_day
 +
|Day for which the shifts are planned
 +
|-
 +
|timestamp
 +
|The time at which the policy is booked
 +
|-
 +
|day_of_week
 +
|Day of the week/ Alternate Days/ All Days (depends on the user selection)
 +
|-
 +
|time_offset
 +
|Internal metric, not to be used by User
 +
|-
 +
|timezone
 +
|Internal metric, not to be used by User
 +
|}
 +
 
 +
=== PolicyBooking ===
 +
{| class="wikitable"
 +
!Column Name
 +
!Description
 +
|-
 +
|policy_key
 +
|Unique ID for the policy
 +
|-
 +
|policy_name
 +
|Name of the policy
 +
|-
 +
|license_key
 +
|Unique ID for the account license
 +
|-
 +
|cell_line_key
 +
|Unique ID for the Cell/ Line
 +
|-
 +
|cell_line_name
 +
|Name of the Cell/ Line
 +
|-
 +
|type
 +
|Type of policy
 +
|-
 +
|approvers
 +
|The email ID of the user who can approve the filled policy
 +
|-
 +
|policy_booking_key
 +
|Unique ID for the policy booking schedule
 +
|-
 +
|booking_timestamp
 +
|The time at which the policy is booked
 +
|-
 +
|booking_working_day
 +
|The day at which the policy is booked
 +
|-
 +
|workcenter_key
 +
|Unique ID for the Workcenter
 +
|-
 +
|workcenter_name
 +
|Name of the workcenter
 +
|-
 +
|part_key
 +
|Unique ID for the Part
 +
|-
 +
|part_name
 +
|Name of the Part
 +
|-
 +
|operation_key
 +
|Unique ID for the Operation
 +
|-
 +
|operation_name
 +
|Name of the Part
 +
|-
 +
|approved_by
 +
|The Email ID of the person who approved the policy
 +
|-
 +
|approved_on
 +
|Policy Approval date and time
 +
|-
 +
|booked_by
 +
|The Email ID of the person who has booked the policy
 +
|-
 +
|is_approved
 +
|Boolean value showing whether policy booking has been approved or not (True/ False)
 +
|-
 +
|inspection_sample_key
 +
|Unique ID for the Sample
 +
|-
 +
|parameter_key
 +
|Unique ID for the Parameter
 +
|-
 +
|parameter_name
 +
|Name of the Parameter
 +
|-
 +
|parameter_value_number
 +
|If the parameter is of a Numeric/ Dropdown (Numeric type)(e.g. 23.45, 974) type, the information will be displayed in this column
 +
|-
 +
|parameter_value_string
 +
|If the parameter is of a String/Dropdown (String Type)/ Boolean (e.g. OK, NOT OK, Low, High) type, the information will be displayed in this column
 +
|-
 +
|parameter_category
 +
|0- String Value, 1- Numeric Value, 2- Boolean, 3- Dropdown
 +
|-
 +
|ucl
 +
|Upper control limit for the policy parameter (only in case of numeric parameters)
 +
|-
 +
|lcl
 +
|Lower control limit for the policy parameter (only in case of numeric parameters)
 +
|-
 +
|uwl
 +
|Upper Warning limit for the policy parameter (only in case of numeric parameters)
 +
|-
 +
|lwl
 +
|Lower Warning limit for the policy parameter (only in case of numeric parameters)
 +
|-
 +
|expected_value
 +
|Expected value for the policy parameter (only in case of numeric parameters)
 +
|-
 +
|instrument
 +
|The instrument used for the measurement
 
|}
 
|}

Latest revision as of 09:47, 24 July 2020

Workcenter Shift Productivity Data Model

WorkcenterShiftFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
is_primary -
shift_name Shift Name in MInt
cycles Number of strokes of the machine
production_quantity Cycles * Parts per cycle
actual_production_time The time required to produce X parts in given time T
available_time Maximum time available for production
downtime Total time for which the machine was idle
unplanned_downtime Time during which the machine had an Unplanned downtime reason booking
planned_downtime Time during which the machine had a Planned downtime booking
expected_production_time Standard/ Target Time required to produce X parts in given time T
idle_slot_count The count of total idle slots
major_stoppages The count of downtimes for major stoppages (threshold defined in MInt Workcenter Configuration)
minor_stoppages The count of downtimes for minor stoppages (threshold defined in MInt Workcenter Configuration)
rejection_quantity Total Rejected Part Quantity
availability Availability metric for OEE Calculation
performance Performance metric for OEE Calculation
quality Quality metric for OEE Calculation
capacity_utilization The metric to identify planned downtimes
oee Overall Equipment Effectiveness (A * P * Q)
teep Total Effective Equipment Performance (OEE * CU)
compressed_air Utilities Air Compression Details
electricity Utilities Electricity Details
steam Utilities Steam Details
gas Utilities Gas Details
workcenter_maintenance_threshold The maximum number of hours the machine can run without maintenance
workcenter_work_done_since_last_maintenance The number of hours passed after the last maintenance when the machine was running
workcenter_last_maintenance_time The Date and Time for the last maintenance activity
workcenter_next_maintenance_time The predicted next workcenter maintenance date.

WorkcenterShiftDownTimeReasonsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
reason_key Unique ID for the downtime reason
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
duration Machine Downtime duration in seconds
idle_slot_count The count of total idle slots
reason_name Downtime Reason Name
reason_code Downtime Reason Code
reason_category_key Unique ID for Downtime Category
reason_category_code Downtime Category Code
reason_category_name Downtime Category Name
is_reason If Downtime Reason is a reason
is_planned If Downtime Reason is a Planned reason
key Unique ID for Downtime Reason

WorkcenterShiftOperatorsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
operators Operator Name
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
Shift_name Shift Name in MInt

WorkcenterShiftRejectionsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
rejection_key Unique ID for the Rejection Code
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
rejection_name Rejection Name
rejection_code Rejection Code
rejection_quantity Rejection Quantity

WorkcenterShiftProductionParametersFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
parameter_key Unique ID for the Parameter
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
parameter_name Parameter Name on MInt
parameter_count Count of Parameters
metric_name Datonis Metric Name
unit Unit of measure of the parameter

WorkcenterShiftProductivityDownTimeReasonsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
reason_key Unique ID for Downtime Reasons
license_key Unique ID for the account
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
duration Machine Downtime duration in mins
loss_slot_count The count of slots which are idle
name Downtime Reason Name
code Downtime Reason Code
category_key Unique ID for Downtime Category
category_code Downtime Category Code
category_name Downtime Category Name
is_reason If Downtime Reason is a reason

Part Shift Productivity Data Model

WorkcenterPartOperationShiftDowntimeReasonsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
part_key Unique ID for the Part/ SKU
operation_key Unique ID for the Operation
working_day Day for which the shifts are planned
reason_key Unique ID for the Downtime Reason
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
part_name Part Name
operation_name Operation Name
downtime_duration Machine Downtime duration in seconds
idle_slot_count The count of total idle slots
reason_name Downtime Reason Name
reason_code Downtime Reason Code
category_key Unique ID for Downtime Reason Code
category_code Downtime Category Code
category_name Downtime Category Name
is_reason If Downtime Reason is a reason
is_planned If Downtime Reason is a Planned reason

WorkcenterPartOperationShiftFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
part_key Unique ID for the Part/ SKU
operation_key Unique ID for the Operation
working_day Day for which the shifts are planned
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
part_name Part Name
operation_name Operation Name
parts_per_cycle The quantity of parts produced in one cycle of the machine
cycles Number of strokes of the machine
production_quantity Cycles * Parts per cycle
acutal_production_time The time required to produce X parts in given time T
available_time Maximum time available for production
downtime Total time for which the machine was idle
unplanned_downtime Time during which the machine had an Unplanned downtime reason booking
planned_downtime Time during which the machine had a Planned downtime booking
expected_production_time Standard/ Target Time required to produce X parts in given time T
standard_cycle_time The standard time required to produce one Part (only machine working time)
standard_loading_time The standard time required to load one Part
standard_unloading_time The standard time required to unload one Part
standard_autocycle_time This is the addition of Standard Cycle Time, Standard Loading Time and Standard Unloading Time.
actual_cycle_time The actual time required to produce one Part (only machine working time)
actual_loading_time The standard time required to load one Part
actual_unloading_time The standard time required to unload one Part
actual_autocycle_time This is the addition of Actual Cycle Time, Actual Loading Time and Actual Unloading Time.
compressed_air Utilities Air Compression Details
electricity Utilities Electricity Details
steam Utilities Steam Details
gas Utilities Gas Details
is_last_operation If an operation is the last in that particular routing, this flag will be True.
rejection_count Count of Quality Rejections

WorkcenterPartOperationShiftRejectionsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
part_key Unique ID for the Part
operation_key Unique ID for the Operation
working_day Day for which the shifts are planned
rejection_key Unique ID for the Rejection Code
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
part_name Part Name
operation_name Operation Name
rejection_quantity Rejection Quantity
rejection_name Rejection Name
rejection_code Rejection Code

WorkcenterPartShiftProductionParametersFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
part_key Unique ID for the Part
parameter_key Unique ID for the Parameter
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
shift_name Shift Name in MInt
part_name Part Name
parameter_name Parameter Name on MInt
parameter_count Count of Parameters
metric_name Datonis Metric Name
unit Unit of measure of the parameter

Hourly Data Model

WorkcenterHourlyFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
hour_start Hour Start Time
hour_end Hour End Time
idle_slot_count The count of total idle slots
working_day Day for which the shifts are planned
job_count Number of strokes of the machine
actual_qty Cycles * Parts per cycle
actual_production_time The time required to produce X parts in given time T
downtime Total time for which the machine was idle
planned_downtime Time during which the machine had a Planned downtime reason booking
unplanned_downtime Time during which the machine had an Unplanned downtime reason booking
shift_name Shift Name in MInt
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
rejection_count Rejection Quantity
scrap_count Scrap Quantity (Custom metric if Scrap is monitored for that Customer)
operators Operator Name (List of operator working in that hour)
part_names Part Name (List of Parts produced in that hour)
part_keys Unique IDs for the Parts
electricity Utilities Electricity Details
gas Utilities Gas Details
steam Utilities Steam Details
compressed_air Utilities Air Compression Details
_created_at Internal metric, not to be used by User
_updated_at Internal metric, not to be used by User

WorkcenterHourlyOperationEnergyFact

Column Name Description
hour_start Hour Start Time
workcenter_key Unique ID for the Workcenter
operation_key Unique ID for the Operation
part_key Unique ID for the Part/ SKU
hour_end Hour End Time
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
part_name Part Name
part_code Part Code
shift_name Shift Name in MInt
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
utility_name Utility Name
metric_name Metric Name in Datonis
consumption_value Consumption Value
_created_at Internal metric, not to be used by User
_updated_at Internal metric, not to be used by User

WorkcenterHourlyProcessOperationFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
pph_from Hour Start Time
parameter_key Unique ID for the Parameter
operation_key Unique ID for the Operation
parent_part_key Unique ID for the Part/ SKU
pph_to Hour End Time
shift_name Shift Name in MInt
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
dept_name Department Name in MInt
plant_name Plant Name in MInt
parameter_name Parameter Name
metric_name Metric Name in Datonis
status 1 being Good (points inside warning limits), 2 being Warning (points outside warning limits and below control limits) and 3 being Problem (points outside control limits)
points_between_lcl_lwl Count of Points Between Lower Control Limit and Lower Warning Limit
lwl Lower Warning Limit for the selected parameter/s
max Max value for the selected parameter/s
points_below_lcl Count of Points Below Lower Control Limits
cpk Process Capability Index (CpK)
uwl Upper Warning Limit for the selected parameter/s
lcl Lower Control Limit for the selected parameter/s
ucl Upper Control Limit for the selected parameter/s
cp Process Capability (Cp)
count Count for the selected parameter/s
avg Average value for the selected parameter/s
points_between_uwl_ucl Count of Points Between Upper Warning Limit and Upper Control Limit
min Minumum value for the selected parameter/s
sum Addition for the selected parameter/s
median Median value for the selected parameter/s
expected_value Expected/ Target value for the selected parameter/s
stddev Standard Deviation for the selected parameter/s
points_above_ucl Count of Points above the Upper Control Limit
points_out_of_warning_limit Count of Points out of Warning Limits
operators Operator Name (List of operator working in that hour)
part_names Part Name (List of Parts produced in that hour)
part_keys Unique IDs for the Parts
_created_at Internal metric, not to be used by User
_updated_at Internal metric, not to be used by User

WorkcenteHourlyProcessParamsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
working_day Day for which the shifts are planned
hour_start Hour Start Time
parameter_key Unique ID for the Parameter
hour_end Hour End Time
shift_name Shift Name in MInt
workcenter_name Workcenter Name in MInt
cell_line_name Cell/ Line Name in MInt
plant_name Plant Name in MInt
dept_name Department Name in MInt
parameter_name Parameter Name on MInt
metric_name Metric Name in Datonis
status 1 being Good (points inside warning limits), 2 being Warning (points outside warning limits and below control limits) and 3 being Problem (points outside control limits)
points_between_lcl_lwl Count of Points Between Lower Control Limit and Lower Warning Limit
max Max value for the selected parameter/s
points_below_lcl Count of Points Below Lower Control Limits
cpk Process Capability Index (CpK)
cp Process Capability (Cp)
count Count for the selected parameter/s
avg Average value for the selected parameter/s
points_between_uwl_ucl Count of Points Between Upper Warning Limit and Upper Control Limit
min Minumum value for the selected parameter/s
sum Addition for the selected parameter/s
median Median value for the selected parameter/s
stddev Standard Deviation for the selected parameter/s
points_above_ucl Count of Points above the Upper Control Limit
points_out_of_warning_limit Count of Points out of Warning Limits
part_keys Unique IDs for the Parts
part_names Part Name (List of Parts produced in that hour)
operators Operator Name (List of operator working in that hour)
_created_at Internal metric, not to be used by User
_updated_at Internal metric, not to be used by User

WorkcenteHourlyCbmParamsFact

Column Name Description
workcenter_key Unique ID for the Workcenter
shift_key Unique ID for the Shift
hour_start Hour Start Time
working_day Day for which the shifts are planned
parameter_key Unique ID for the Parameter
hour_end Hour End Time
parameter_name Parameter Name on MInt
metric_name Metric Name in Datonis
status 1 being Good (points inside warning limits), 2 being Warning (points outside warning limits and below control limits) and 3 being Problem (points outside control limits)
points_between_lcl_lwl Count of Points Between Lower Control Limit and Lower Warning Limit
lwl Lower Warning Limit for the selected parameter/s
max Max value for the selected parameter/s
points_below_lcl Count of Points Below Lower Control Limits
cpk Process Capability Index (CpK)
uwl Upper Warning Limit for the selected parameter/s
ucl Upper Control Limit for the selected parameter/s
lcl Lower Control Limit for the selected parameter/s
cp Process Capability (Cp)
count Count for the selected parameter/s
avg Average value for the selected parameter/s
points_between_uwl_ucl Count of Points Between Upper Warning Limit and Upper Control Limit
min Minumum value for the selected parameter/s
expected_value Expected/ Target value for the selected parameter/s
sum Addition for the selected parameter/s
median Median value for the selected parameter/s
stddev Standard Deviation for the selected parameter/s
points_above_ucl Count of Points above the Upper Control Limit
points_out_of_warning_limit Count of Points out of Warning Limits
shift_name Shift Name in MInt
workcenter_name Workcenter Name in MInt
dept_name Department Name in MInt
cell_line_name Cell/ Line Name in MInt
plant_name Plant Name in MInt
_created_at Internal metric, not to be used by User
_updated_at Internal metric, not to be used by User

PolicySchedule

Column Name Description
policy_key Unique ID for the policy
policy_name Name of the policy
license_key Unique ID for the account license
cell_line_key Unique ID for the Cell/ Line
cell_line_name Name of the Cell/ Line
samples Number of samples to test for a given policy
type Type of policy
approvers The email ID of the user who can approve the filled policy
policy_schedule_key Unique ID for the policy booking schedule
policy_from Start date of policy booking schedule
policy_to End date of policy booking schedule
working_day Day for which the shifts are planned
timestamp The time at which the policy is booked
day_of_week Day of the week/ Alternate Days/ All Days (depends on the user selection)
time_offset Internal metric, not to be used by User
timezone Internal metric, not to be used by User

PolicyBooking

Column Name Description
policy_key Unique ID for the policy
policy_name Name of the policy
license_key Unique ID for the account license
cell_line_key Unique ID for the Cell/ Line
cell_line_name Name of the Cell/ Line
type Type of policy
approvers The email ID of the user who can approve the filled policy
policy_booking_key Unique ID for the policy booking schedule
booking_timestamp The time at which the policy is booked
booking_working_day The day at which the policy is booked
workcenter_key Unique ID for the Workcenter
workcenter_name Name of the workcenter
part_key Unique ID for the Part
part_name Name of the Part
operation_key Unique ID for the Operation
operation_name Name of the Part
approved_by The Email ID of the person who approved the policy
approved_on Policy Approval date and time
booked_by The Email ID of the person who has booked the policy
is_approved Boolean value showing whether policy booking has been approved or not (True/ False)
inspection_sample_key Unique ID for the Sample
parameter_key Unique ID for the Parameter
parameter_name Name of the Parameter
parameter_value_number If the parameter is of a Numeric/ Dropdown (Numeric type)(e.g. 23.45, 974) type, the information will be displayed in this column
parameter_value_string If the parameter is of a String/Dropdown (String Type)/ Boolean (e.g. OK, NOT OK, Low, High) type, the information will be displayed in this column
parameter_category 0- String Value, 1- Numeric Value, 2- Boolean, 3- Dropdown
ucl Upper control limit for the policy parameter (only in case of numeric parameters)
lcl Lower control limit for the policy parameter (only in case of numeric parameters)
uwl Upper Warning limit for the policy parameter (only in case of numeric parameters)
lwl Lower Warning limit for the policy parameter (only in case of numeric parameters)
expected_value Expected value for the policy parameter (only in case of numeric parameters)
instrument The instrument used for the measurement
Retrieved from "https://docs.datonis.io/mediawiki/index.php?title=Data_Model_Column_Descriptions&oldid=1391"