Measures
This table shows the service rental equipment calendar measures:
Measure | Mapping | Note |
---|---|---|
Available Equipment Hours | tscfg262.dura when tscfg262.orig = 'tscfg.corg.cal.avail' OR tscfg262.orig = 'tscfg.corg.cal.unavail' AND tscfg262.avyn = 'tscfg.clav.available' | |
Manual Reservation Equipment Hours | tscfg262.dura when tscfg262.orig = 'tscfg.corg.cal.avail' OR tscfg262.orig = 'tscfg.corg.cal.unavail' AND tscfg262.avyn = 'tscfg.clav.available' AND tscfg262.boty = 'tsmdm.origin.notapp' AND tscfg262.bobj IS NOT NULL | |
Non Rented Ratio | Ratio of serialized items with tscfg200.rnyn = yes for which rental agreements are not active / total rental fleet | |
Rental Agreement Equipment Hours | tscfg262.dura when tscfg262.orig = 'tscfg.corg.cal.avail' OR tscfg262.orig = 'tscfg.corg.cal.unavail' | |
Rental Fleet Age | The age of serialized items for which tscfg200.rnyn = yes = todays date minus tscfg200.optm in years | |
Rental Hours | Rental Agreement Equipment Hours + Manual Reservation Equipment Hours + Under Maintenance Equipment Hours | |
Rental Ratio | Ratio of serialized items with tscfg200.rnyn = yes for which rental agreements are active / total rental fleet | |
Service Order Activity Count Distinct | Rented Service Order Activity count for the rentable serialized items on it | |
Service Rental Equipment Calendar Count | Count of Rentable Equipment Calendar | |
Service Serialized Item Count Distinct | Rentable Serialized Items count | |
Time Utilization | Days during which serialized item is in a rental agreement (tscfg262.dura) / total no. of days for which the rental calendar for serialized item is available | |
Total Rental Fleet | Count the serialized items in tscfg262 with tscfg200.rnyn = yes | |
Under Maintenance Equipment Hours | tscfg262.dura of linked internal service orders for the rentable serialized items
+ tscfg262.dura of linked work orders without the maintenance sales orders for the rental serialized items + tscfg262.dura of linked rentable service orders with non-rentable service order activities. |
|
Under Maintenance Ratio | Ratio (count of internal service orders for the rentable serialized items
+ count of work orders without the maintenance sales orders for the rentable serialized items + count of rentable service orders with non-rental service order activities) / total equipment fleet. |
|
deleted | 1 if deleted in LN, else 0 |