wearmanagementtests EntityType

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.

 

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

Articles in this section

prev next

Related sections