Novell Sentinel Rapid Deployment 6.1, Reference Manual, Page: 69 / 136

Sentinel 6.1 Rapid Deployment Database Views for PostgreSQL 69
no
vd
ocx
(e
n)
13
Ma
y 20
09
6.1.23 ASSET_RPT_V
View references ASSET table that stores information about the physical and soft assets.
6.1.24 ASSET_VALUE_RPT_V
View references ASSET_VAL_LKUP table that stores information about the asset value.
ADDRESS_LINE_2 character varying(255) Address line 2
CITY character varying(100) City
STATE character varying(100) State
COUNTRY character varying(100) Country
ZIP_CODE character varying(50) Zip code
DATE_CREATED timestamp with time zone Date the entry was created
DATE_MODIFIED timestamp with time zone Date the entry was modified
CREATED_BY integer User who created object
MODIFIED_BY integer User who last modified object
Column Name Datatype Comment
ASSET_ID uuid Asset identifier
CUST_ID bigint Customer identifier
ASSET_NAME character varying(255) Asset name
PHYSICAL_ASSET_ID uuid Physical asset identifier
PRODUCT_ID bigint Product identifier
ASSET_CATEGORY_ID bigint Asset category identifier
ENVIRONMENT_IDENTITY_CD bigint Environment identify code
PHYSICAL_ASSET_IND boolean Physical asset indicator
ASSET_VALUE_CODE bigint Asset value code
CRITICALITY_ID bigint Asset criticality code
SENSITIVITY_ID bigint Asset sensitivity code
DATE_CREATED timestamp with time
zone Date the entry was created
DATE_MODIFIED timestamp with time
zone Date the entry was modified
CREATED_BY integer User who created object
MODIFIED_BY integer User who last modified object
Column Name Datatype Comment