wearmanagementresults EntityType

Purpose

Returns a list of calculated wear test results 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.
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.
x int * Displays the X coordinate for the corresponding wear test result.
y int * Displays the Y coordinate for the corresponding wear test result.
ref nvarchar(10) * Displays the Ref coordinate for the corresponding wear test result.
result decimal(18, 2) Displays the corresponding wear test result.
resultIsInvalid int  Returns a value indicating if a result is invalid or not.

Default Options:
0 : False
1 : True
resultDifference decimal(18, 2) Returns a calculated value being the difference between the previous result recorded at the same X & Y or Ref and the current result at the same coordinates (Result Current - Result Previous)
averageResultDifference decimal(18, 2)  Returns a calculated value being the average of all the result difference values for the entire wear test.
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