HP Storage Essentials NAS Manager Software User Manual
Page 566
Running Reports
534
STORAGETIERCOSTPERGB
NUMBER(36,2)
Asset storage Tier cost
DEPARTMENTNO
VARCHAR2(255)
Asset department no
DEPARTMENTNAME
VARCHAR2(255)
Asset department Name
PERCENTAGEOWNED
NUMBER(5, 2)
Percentage owned by Department
ADMINISTRATOR VARCHAR2(255)
Asset
maintained
by
STAFFNAME
VARCHAR2(255)
Staff Name
STAFFPHONENUMBER VARCHAR2(255)
Staff
PH#
STAFFDEPARTMENT
VARCHAR2(255)
Staff Department
STAFFEMAIL
VARCHAR2(255)
Staff E-mail
RACKNUMBER
VARCHAR2(100)
FLOOR
VARCHAR2(100)
DATACENTER
VARCHAR2(100)
CITY
VARCHAR2(100)
REGION
VARCHAR2(100)
COUNTRY
VARCHAR2(50)
CONTINENT
VARCHAR2(20)
ADDRESS
VARCHAR2(1024)
ZIPCODE
VARCHAR2(16)
LICENSE
VARCHAR2(4000)
PURCHASEORDERNUMBER
VARCHAR2(255)
Asset Purchase Order no
DATEPURCHASED
DATE
Asset Date purchased
COST
NUMBER(36,2)
Asset cost
VALUE
NUMBER(36,2)
SALVAGECOST
NUMBER(36,2)
Asset Deprecated Salvage Cost
DEPRECITIONPERIOD
NUMBER(18)
Asset Deprecation Period
DEPRECITIONMETHOD
NUMBER(16)
Asset Deprecation Method ('Straight line',
'Fixed declining', 'Double declining')
DEPRECITEDVALUE
NUMBER(36,2)
Asset Depreciated Value
Table 107
MVC_ASSETSUMMARY (continued)
Column Name
Type
Description