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. |