Purpose
Returns a list of all wear tests 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. |
testedBy | nvarchar(50) * | Returns either an email address for the user account or an entered name of the person that recorded the wear test. |
testValid | int | Returns a value indicating if the test is valid or not. Default Options: 0 : False 1 : True |
testPosition | nvarchar(50) * | Returns the test position recorded against the wear test. |
instrumentVelocity | decimal(18, 1) * | Returns the instrument velocity recorded against the wear test. |
calibrationThickness | decimal(18, 1) * | Returns the calibration thickness recorded against the wear test. |
surfaceTemperature | decimal(18, 1) * | Returns the surface temperature recorded against the wear test. |
workOrderNo | nvarchar(50) * | Returns the work order number recorded against the wear test. |
testComments | nvarchar(500) * | Returns the test comments recorded against the 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. |