Purpose
Returns a list of all idler failures by functional location (Business, Group, Department and Area) and their associated properties in a simple data set. This is suitable for use with Power Query in Microsoft Excel, Microsoft Power BI, Spotfire and Tableau.
The data returned can be limited using optional parameters and by records updated within a maximum 6 month period.
Properties
Properties represent fields of data stored in the entity. Some properties are nullable.
Primary Key: tagId
Foreign Key: areaId
All nullable fields are represented with an * asterisk in the data type column.
Column Name | Data Type | Details |
businessName | nvarchar(50) | Displays the full Business name. |
businessFunctionalLocation | nvarchar(50) * | Displays the functional location for the corresponding Business. |
businessSortOrder | int | Defines the sort order for the corresponding Business. |
groupName | nvarchar(50) | Displays the full Group name. |
groupFunctionalLocation | nvarchar(50) * | Displays the functional location for the corresponding Group. |
groupSortOrder | int | Defines the sort order for the corresponding Group. |
departmentName | nvarchar(50) | Displays the full Department name. |
departmentFunctionalLocation | nvarchar(50) * | Displays the functional location for the corresponding Department. |
departmentSortOrder | int | Defines the sort order for the corresponding Department. |
areaName | nvarchar(50) | Displays the full Area name. |
areaFunctionalLocation | nvarchar(50) * | Displays the functional location for the corresponding Area. |
areaSortOrder | int | Defines the sort order for the corresponding Area. |
areaType | nvarchar(50) | Displays the area type for the corresponding Area. |
areaId | int | Displays the Foreign Key for the associated Area. |
conveyorType | nvarchar(50) * | Displays the conveyor type for the corresponding Area. |
tagId | int | Displays the Primary Key for the record. |
tagNo | nvarchar(50) * | Displays the tag number entered with the failure. This is often used if a manual tagging system is used. |
frame | int * | Displays the conveyor frame number that the failure relates to on the corresponding Area. |
ct | nvarchar(20) * | (Used primarily for underground mining operations) Displays the cut through number that the frame relates to on the corresponding Area. |
other1 | nvarchar(20) * | |
other2 | nvarchar(20) * | |
idlerPosition | nvarchar(50) | Displays the idler position name the failure relates to. |
idlerType | nvarchar(50) | Displays the idler type name the failure relates to. |
idlerLocation | nvarchar(50) | Displays the idler location name the failure relates to. |
manufacturer | nvarchar(50) * | Displays the idler manufacturer the failure relates to. |
failureType | nvarchar(50) | Displays the idler failure type the failure relates to. |
failurePriority | nvarchar(100) | Displays the failure priority the idler failure type relates to. |
accessIssue | nvarchar(50) * | Displays any access issue that has been associated with the failure. |
maintenanceActivity | nvarchar(50) * | Displays the maintenance activity the failure has been changed within. |
comment | nvarchar(250) * | Displays any user comments that have been added to the failure. |
laidOut | int | Returns a value indicating if a record has been laid out or not. Default Options: 0 : Not Laid Out 1 : Laid Out |
taggedBy | nvarchar(50) | Returns either an email address for the user account or an entered name of the person that tagged the failure. |
taggedByUserGroup | nvarchar(50) * | Returns the user group assigned to the user account that tagged the failure. |
dateTagged | datetime | Returns a date time (in UTC) that the failure was recorded as tagged. |
monthTagged | varchar(7) | Returns a calculated value (based on Date Tagged) for the Month the record was recorded as tagged. |
changedBy | nvarchar(50) * | Returns either an email address for the user account or an entered name of the person that changed the failure. |
changedByUserGroup | nvarchar(50) * | Returns the user group assigned to the user account that changed the failure. |
dateChanged | datetime * | Returns a date time (in UTC) that the failure was recorded as changed. |
monthChanged | varchar(7) * | Returns a calculated value (based on Date Changed) for the Month the record was recorded as changed. |
closedBy | nvarchar(50) * | Returns either an email address for the user account or an entered name of the person that closed the record. |
closedByUserGroup | nvarchar(50) * | Returns the user group assigned to the user account that closed the failure. |
replaced | int | Returns a value indicating if a record has been replaced or not. Default Options: 0 : Not Replaced 1 : Replaced |
deleted | bit | Returns a value indicating if a record has been deleted or not. Default Options: 0 : Not Deleted 1 : Deleted |
daysInFailure | int | Returns a calculated number of days being the difference between when the failure was tagged and changed (Date Changed - Date Tagged). |
partNumber | nvarchar(50) * | Displays the configured part number for the corresponding failure. |
lastSavedBy | nvarchar(50) | Returns an email address for the user account that last updated / saved the record. |
lastSavedByUserGroup | nvarchar(50) | Returns the user group assigned to the user account that last saved the failure record. |
lastSavedDateTime | datetime | Returns a date time in UTC that the record was last updated / saved. |
createdBy | nvarchar(50) | Returns an email address for the user account that created the record. |
createdByUserGroup | nvarchar(50) | Returns the user group assigned to the user account that created the failure record. |
createdDateTime | datetime | Returns a date time in UTC that the record was originally created. |
wonumber | nvarchar(50) * | Displays the replacement work order number that has been recorded against the failure. |