Database Definitions
This section contains information regarding database views used for reporting in WebTMA
- vrpt_JobLibraryToolList
- vrpt_JobLibraryTrainingList
- vrpt_KeyAccess
- vrpt_keyAccessLockLocation
- vrpt_KeyCabinetInventory
- vrpt_KeyHolderHistory
- vrpt_KeyHolderKeys
- vrpt_KeyIssued
- vrpt_KeyRingItem
- vrpt_LastPMWorkOrder
- vrpt_Lease
- vrpt_Location
- vrpt_MaintenanceDetailByTech
- vrpt_MakeModelRisk
- vrpt_MasterCheckResult
- vrpt_MeterHistory
- vrpt_MeterLastReading
- vrpt_Modifier
- vrpt_MonitoredConditionReadingListForArea
- vrpt_MonitoredConditionReadingListForAsset
- vrpt_MonitoredConditionReadingListForBiomedEquipment
- vrpt_MonitoredConditionReadingListForEntity
- vrpt_MonitoredConditionReadingListForEquipment
- vrpt_MonitoredConditionReadingListForTools
- vrpt_MonitoredConditionReadingListForVehicles
- vrpt_MostExpensiveArea
- vrpt_MostExpensiveAsset
- vrpt_MostExpensiveBiomed
- vrpt_MostExpensiveEntity
- vrpt_MostExpensiveEquipment