Difference between revisions of "Data Model Column Descriptions"
From Datonis
m (Tag: Visual edit) |
m (→PolicySchedule) (Tag: Visual edit) |
||
| Line 1,187: | Line 1,187: | ||
|- | |- | ||
|policy_schedule_key | |policy_schedule_key | ||
| − | | | + | |Unique ID for the policy booking schedule |
|- | |- | ||
|policy_from | |policy_from | ||
| − | | | + | |Start date of policy booking schedule |
|- | |- | ||
|policy_to | |policy_to | ||
| − | | | + | |End date of policy booking schedule |
|- | |- | ||
|working_day | |working_day | ||
| − | | | + | |Day for which the shifts are planned |
|- | |- | ||
|timestamp | |timestamp | ||
| − | | | + | |The time at which the policy is booked |
|- | |- | ||
|day_of_week | |day_of_week | ||
| Line 1,238: | Line 1,238: | ||
|- | |- | ||
|policy_booking_key | |policy_booking_key | ||
| − | | | + | |Unique ID for the policy booking schedule |
|- | |- | ||
|booking_timestamp | |booking_timestamp | ||
| − | | | + | |The time at which the policy is booked |
|- | |- | ||
|booking_working_day | |booking_working_day | ||
| − | | | + | |The day at which the policy is booked |
|- | |- | ||
|workcenter_key | |workcenter_key | ||
| − | | | + | |Unique ID for the Workcenter |
|- | |- | ||
|workcenter_name | |workcenter_name | ||
| − | | | + | |Name of the workcenter |
|- | |- | ||
|part_key | |part_key | ||
| − | | | + | |Unique ID for the Part |
|- | |- | ||
|part_name | |part_name | ||
| − | | | + | |Name of the Part |
|- | |- | ||
|operation_key | |operation_key | ||
| − | | | + | |Unique ID for the Operation |
|- | |- | ||
|operation_name | |operation_name | ||
| − | | | + | |Name of the Part |
|- | |- | ||
|approved_by | |approved_by | ||
| − | | | + | |The Email ID of the person who approved the policy |
|- | |- | ||
|approved_on | |approved_on | ||
| − | | | + | |Policy Approval date and time |
|- | |- | ||
|booked_by | |booked_by | ||
| − | | | + | |The Email ID of the person who has booked the policy |
|- | |- | ||
|is_approved | |is_approved | ||
| Line 1,277: | Line 1,277: | ||
|- | |- | ||
|inspection_sample_key | |inspection_sample_key | ||
| − | | | + | |Unique ID for the Sample |
|- | |- | ||
|parameter_key | |parameter_key | ||
| − | | | + | |Unique ID for the Parameter |
|- | |- | ||
|parameter_name | |parameter_name | ||
| − | | | + | |Name of the Parameter |
|- | |- | ||
|parameter_value_number | |parameter_value_number | ||
| − | | | + | |If the parameter is of a Numeric/ Boolean (e.g. 23.45, 1,0) type, the information will be displayed in this column |
|- | |- | ||
|parameter_value_string | |parameter_value_string | ||
| − | | | + | |If the parameter is of a String/Dropdown (e.g. OK, NOT OK, Yes, No) type, the information will be displayed in this column |
|- | |- | ||
|parameter_category | |parameter_category | ||
| Line 1,295: | Line 1,295: | ||
|- | |- | ||
|ucl | |ucl | ||
| − | | | + | |Upper control limit for the policy parameter (only in case of numeric parameters) |
|- | |- | ||
|lcl | |lcl | ||
| − | | | + | |Lower control limit for the policy parameter (only in case of numeric parameters) |
|- | |- | ||
|uwl | |uwl | ||
| − | | | + | |Upper Warning limit for the policy parameter (only in case of numeric parameters) |
|- | |- | ||
|lwl | |lwl | ||
| − | | | + | |Lower Warning limit for the policy parameter (only in case of numeric parameters) |
|- | |- | ||
|expected_value | |expected_value | ||
| − | | | + | |Expected value for the policy parameter (only in case of numeric parameters) |
|- | |- | ||
|instrument | |instrument | ||
| − | | | + | |The instrument used for the measurement |
|} | |} | ||
Revision as of 09:01, 24 July 2020
Contents
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 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 | |
| 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 | |
| time_offset | |
| timezone |
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 | |
| 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 | |
| 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/ Boolean (e.g. 23.45, 1,0) type, the information will be displayed in this column |
| parameter_value_string | If the parameter is of a String/Dropdown (e.g. OK, NOT OK, Yes, No) type, the information will be displayed in this column |
| parameter_category | |
| 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 |
