wearmanagementbelts EntityType

Purpose

Returns a list of belt sections for any conveyor asset including calculated information on replacement dates for the belt section 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. Any belt section installed outside this time frame will not be returned.

Properties

Properties represent fields of data stored in the entity. Some properties are nullable.

Primary Key: None returned. equipmentId is unique to each belt section.

Foreign Key: equipmentId, areaId, testId

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.
hash int This is the belt section order.
equipmentType   nvarchar(50) Displays the equipment type for the associated equipment / asset.
fullSpecification nvarchar(50) Displays the belt specification and also includes width, cover thicknesses and grade of the belt section.
specification nvarchar(50) Displays just the belt specification of the belt section.

width

int Displays the belt width of the belt section.

skirtWidth

int Displays the skirt width of the belt section.

topCover

decimal(18, 1) Displays the top cover thickness of the belt section when installed.

bottomCover

decimal(18, 1) Displays the bottom cover thickness of the belt section when installed.

grade

nvarchar(50) * Displays the grade of the belt section.

length

int * Displays the length of the belt section.

breakerFabric

int * Returns a value indicating if the belt section has breaker fabric.

Default Options:
0 : False
1 : True

sealedEdge

int * Returns a value indicating if the belt section has a sealed edge.

Default Options:
0 : False
1 : True

rollNumber

int * Displays the roll number of the belt section.

stationMarkers

nvarchar(50) * Displays the station markers printed on the belt section.

manufactureDate

datetime * Displays the date of manufacture of the belt section.

manufacturer

nvarchar(50) * Displays manufacturer of the belt section.

partNumber

nvarchar(50) * Displays the part number assigned to the belt section.

leadTime

int *

Displays the number of days between when the order for a new belt is placed to delivery of that order.

replacementInterval

int Displays the number of days that have been entered for the estimated life of the belt. 

installed

int Returns a value indicating if the belt section is currently installed.

Default Options:
0 : False
1 : True

installDate

datetime  Returns a date time in UTC that the belt section was installed.

originalDate

datetime Being reviewed.

scheduledCOutDate

datetime * Returns a date time in UTC for the scheduled (nominated) change out date of the belt section.

scheduledShut

 

nvarchar(50) * Returns the nominated scheduled shut value.

removalDate

datetime Returns a date time in UTC that the belt section was removed. Should only be populated if installed is false.

wearSurface

nvarchar(50) Returns the wear surface that was tested. Will be either Top or Bottom.

wearMeasurementType

nvarchar(50) Returns the type of wear measurement being recorded. Will be either Thickness or Hardness.

partition

nvarchar(50) Returns the partition the test on which the minimum result was recorded.

lastTestMinimum

decimal(18, 1) Returns the minimum result for the last test from this partition.

lastTestDate

datetime Returns the date time in UTC of the last test.

testId

int Displays the Foreign Key for the associated test.

equipmentId

int Displays the Foreign Key for the associated equipment / asset.
areaId int Displays the Foreign Key for the associated Area.
testedBy nvarchar(50) * Returns either an email address for the user account or an entered name of the person that recorded the wear test.
workOrderNo nvarchar(50) * Returns the work order number recorded against the wear test.
testComments nvarchar(50) * Returns the test comments recorded against the wear test.
currentLifeDailyWearRate decimal(18, 1) Returns the current calculated daily wear rate for this partition.
currentLifeCriticalChangeout datetime Returns the current calculated lifetime critical changeout date for this partition.
daysToLifeCriticalChangeout int Returns the current calculated number of days to the critical lifetime changeout date for this partition.
previousLifeDailyWearRate decimal(18, 1) Returns the previous calculated daily wear rate for this partition.
previousLifeCriticalChangeout datetime Returns the previously calculated lifetime critical changeout date for this partition.
daysToPreviousCriticalChangeout int Returns the previously calculated number of days to the previous critical lifetime changeout date for this partition.
criticalAlarm int Displays the critical alarm setting for the belt section.
severeAlarm int Displays the severe alarm setting for the belt section.
testsInTrend int Returns the number of test being used in the calculations.
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.

 

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

Articles in this section

prev next

Related sections