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