structurefailures EntityType

Purpose

Returns a list of all structure 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.

Display 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) *  
structureType nvarchar(50) Displays the structure type name the failure relates to.
failureType nvarchar(50) Displays the structure failure type the failure relates to.
failurePriority  nvarchar(100) Displays the failure priority the structure 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
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 updated / saved 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 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.

 

prev next
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

prev next

Related sections