wearmanagementsummaries EntityType

Purpose

Returns a list of calculated wear test summaries for any asset with the corresponding wear test information by functional location (Business, Group, Department and Area) 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: testId

Foreign Key: equipmentId, 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.
equipmentId int Displays the Foreign Key for the associated equipment / asset.
equipmentType nvarchar(50) Displays the equipment type for the associated equipment / asset.
equipmentDescription nvarchar(250) Displays the equipment description (a combination of attribute information) for the associated equipment / asset.
installed int Returns a value indicating if an asset is installed or not.

Default Options:
0 : Removed / Not Installed
1 : Installed
testDate datetime Returns a date time (in UTC) that the wear test was conducted.
summaryValue decimal(18,2) Displays the minimum wear test result recorded against the corresponding partition.
summaryType nvarchar(50) Displays the result type corresponding to the wear test.

Default Options:
MIN
MAX
x int * Displays the X coordinate for the minimum wear test result recorded against in the corresponding partition.
y int * Displays the Y coordinate for the minimum wear test result recorded against in the corresponding partition.
ref nvarchar(10) * Displays the Ref coordinate for the minimum wear test result recorded against in the corresponding partition.
wearSurface nvarchar(50) Displays the wear surface selected for the wear test.
wearMeasurementType nvarchar(50) Displays the wear measurement type selected for the wear test.
partition nvarchar(50) * Displays the wear surface partition for calculated minimum wear test result.
lastSavedBy nvarchar(50) Returns an email address for the user account that last updated / saved the record.
lastSavedDateTime datetime Returns a date time in UTC that the record was last updated / saved.
testId int Displays the Primary Key for the record.

 

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

Articles in this section

prev next

Related sections