HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

HP Storage Essentials SRM 6.0 User Guide 483
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 89 MVC_ASSETSUMMARY (continued)
Column Name Type Description