Maintenance outage for upgrade on Sunday, September 22

This site, docs.bmc.com, will be inaccessible for two hours starting at 8 AM CDT, Sunday, September 22, for a platform upgrade.

    Page tree
    Skip to end of metadata
    Go to start of metadata

    The Advanced Reporting module produces a number of public views that can be accessed using the CPIT_REP account (the default database user account for generating reports).

    These views let you access relevant TrueSight Capacity Optimization data in a simple and straightforward manner. The following sections describe these views in detail.

    To view example queries developed using, and Chargeback reports based on these Public Views, see Related topics.

    Public views produced by the Advanced Reporting module

    Public views produced by the Advanced Reporting module that can be accessed using the CPIT_REP account are divided into the following categories:

    System-related views

    PV_SYSTEM

    Each System is created by a connector, and it remains in TrueSight Capacity Optimization until either all of its data ages out, or the System and all of its data is explicitly dismissed and deleted by a TrueSight Capacity Optimization user.
    This view contains one row for each system, keyed by its unique entity ID (SYSID).

    Column Name

    Data Type

    Description

    Key column

    SYSID

    NUMBER

    Internal TrueSight Capacity Optimization-assigned unique identifier

    PK

    NAME

    VARCHAR2 (50 Bytes)

    System name assigned by connector or modified by user

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    System description

     

    SYSTYPEID

    NUMBER

    The type of the system, assigned by connector. A constant from the list of System types described in "Entity Types".

     

    SYSTYPE

    VARCHAR2 (50 Bytes)

    Type string that goes with SYSTYPEID

     

    CLUSTERID

    NUMBER

    (deprecated) System cluster ID

     

    CLUSTERNAME

    VARCHAR2 (50 Bytes)

    (deprecated) Cluster name

     

    CLUSTERTYPE

    VARCHAR2 (25 Bytes)

    (deprecated) Cluster type

     

    CLUSTERDESCRIPTION

    VARCHAR2 (250 Bytes)

    (deprecated) Cluster description

     

    STATUSIDNUMBERStatus ID of the system 

    PV_SYS_METRIC

    This view contains information on metric instances belonging to Systems.

    A metric instance contains time-varying data, either as a time series of numbers that can change on a frequent interval, or as a configuration string that changes only occasionally. For more information on metrics and metric instances, see Metric sub-types in Agent.

    A metric instance is created when data for a particular metric for a System is first loaded by a connector. It remains in TrueSight Capacity Optimization until its owning system is either aged out or dismissed and deleted by a user.

    This view does not contain the time series or configuration data itself. Time series data is in the PV_SYS_DATA_DETAIL and similar views. Configuration data is in PV_SYS_CONF_LAST and PV_SYS_CONF_VARIATION views.

    This view contains one row per metric instance, keyed by SYSMETRICID.

    Column Name

    Data Type

    Description

    Key column

    SYSID

    NUMBER

    The identifier of the System that the metric instance belongs to, as in PV_SYSTEM.

    AK1. FK SYSID in PV_SYSTEM

    SYSMETRICID

    NUMBER

    An internal unique TrueSight Capacity Optimization-generated identifier for the metric instance

    PK

    NAME

    VARCHAR2 (50 Bytes)

    System name, as in PV_SYSTEM

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Description string that goes with the System, as in PV_SYSTEM

    SYSTYPEID

    NUMBER

    System type ID, as in PV_SYSTEM

     

    SYSTYPE

    VARCHAR2 (50 Bytes)

    Type of the System, as in PV_SYSTEM

     

    METRIC

    VARCHAR2 (50 Bytes)

    Metric name, uniquely identifying the metric of this metric instance

     

    METRICNAME

    VARCHAR2 (50 Bytes)

    Metric full name

     

    SUBMETRICNAME

    VARCHAR2 (512 Bytes)

    Metric sub-object name, valid only for metrics with sub-objects

    AK1

    LOCATIONID

    NUMBER

    Location ID for the metric instance, if any; default 0

     

    LOCATIONNAME

    VARCHAR2 (50 Bytes)

    Location name that goes with the location ID, if any; default UNKNOWN

     

    VALTYPEID

    NUMBER

    Value type ID for time series metrics (see table of metric value types). For conf series metrics, the VALTYPEID is always 5. See PV_CAT_VAL_TYPE.

     

    VALTYPE

    VARCHAR2 (50 Bytes)

    Value type (count, rate,..) that goes with the Value type ID

     

    The 5-tuple structure of a metric instance listed in Metric sub-types in Agent is a synonym table for the above view, with key series attributes corresponding to the above column names as follows:

    Key series attribute

    Column name

    ENTITY

    SYSID

    ENTCATNM

    Not listed (it is always the constant "SYS")

    OBJECT

    METRIC

    SUBOBJECT

    SUBMETRICNAME

    LOCATION

    LOCATIONID

    This table shows how connector data corresponds to the public view.

    PV_SYS_EVENT

    This view contains information on system events.

    Column Name

    Data Type

    Description

    SYSDESC

    VARCHAR2 (4000 Bytes)

     

    SYSTYPEID

    NUMBER

     

    SYSTYPE

    VARCHAR2 (50 Bytes)

     

    CLUSTERID

    NUMBER

     

    CLUSTERNAME

    VARCHAR2 (50 Bytes)

     

    CLUSTERTYPE

    VARCHAR2 (25 Bytes)

     

    CLUSTERDESCRIPTION

    VARCHAR2 (250 Bytes)

     

    TS

    DATE

    Timestamp

    EVENTTYPEID

    NUMBER

     

    EVENTTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTSUBTYPEID

    NUMBER

     

    EVENTSUBTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTID

    NUMBER

     

    EVENTTS

    DATE

     

    INTERVENTTS

    DATE

     

    RESOLUTIONTS

    DATE

     

    EVENTNAME

    VARCHAR2 (250 Bytes)

     

    EVENTDESC

    VARCHAR2 (4000 Bytes)

     

    NOTE

    VARCHAR2 (4000 Bytes)

     

    COLOR

    VARCHAR2 (50 Bytes)

     

    PERIOD

    NUMBER

     

    PERIODSINCEDATE

    DATE

     

    PERIODTODATE

    DATE

     

    SEVERITY

    VARCHAR2 (50 Bytes)

     

    STATUS

    VARCHAR2 (50 Bytes)

     

    SERVICEUNAVAILABILITY

    NUMBER

     

    PENDINGTIMEMILLIS

    NUMBER

     

    INTERVENTTIMEMILLIS

    NUMBER

     

    RESOLUTIONTIMEMILLIS

    NUMBER

     

    SOURCECLASS

    VARCHAR2 (512 Bytes)

     

    SRCEVENTID

    VARCHAR2 (50 Bytes)

     

    COUNTOCCURRENCE

    NUMBER

     

    SYSID

    NUMBER

     

    SYSNAME

    VARCHAR2 (250 Bytes)

     

    PV_SYS_METRIC_EVENT

    This view contains information on events owned by system metrics.

    Column Name

    Data Type

    Description

    TS

    DATE

    Timestamp

    EVENTTYPEID

    NUMBER

     

    EVENTTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTSUBTYPEID

    NUMBER

     

    EVENTSUBTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTID

    NUMBER

     

    EVENTTS

    DATE

     

    INTERVENTTS

    DATE

     

    RESOLUTIONTS

    DATE)

     

    EVENTNAME

    VARCHAR2 (250 Bytes)

     

    EVENTDESC

    VARCHAR2 (4000 Bytes)

     

    NOTE

    VARCHAR2 (4000 Bytes)

     

    COLOR

    VARCHAR2 (50 Bytes)

     

    PERIOD

    NUMBER

     

    PERIODSINCEDATE

    DATE

     

    PERIODTODATE

    DATE

     

    SEVERITY

    VARCHAR2 (50 Bytes)

     

    STATUS

    VARCHAR2 (50 Bytes)

     

    SERVICEUNAVAILABILITY

    NUMBER

     

    PENDINGTIMEMILLIS

    NUMBER

     

    INTERVENTTIMEMILLIS

    NUMBER)

     

    RESOLUTIONTIMEMILLIS

    NUMBER

     

    SOURCECLASS

    VARCHAR2 (512 Bytes)

     

    SRCEVENTID

    VARCHAR2 (50 Bytes)

     

    COUNTOCCURRENCE

    NUMBER

     

    SYSID

    NUMBER

     

    SYSMETRICID

    NUMBER

     

    SYSNAME

    VARCHAR2 (250 Bytes)

     

    SYSDESC

    VARCHAR2 (4000 Bytes)

     

    SYSTYPEID

    NUMBER (22 Bytes)

     

    SYSTYPE

    VARCHAR2 (50 Bytes)

     

    METRIC

    VARCHAR2 (50 Bytes)

     

    METRICNAME

    VARCHAR2 (250 Bytes)

     

    SUBMETRICNAME

    VARCHAR2 (512 Bytes)

     

    PV_SYS_CONF_VARIATION

    This view describes historical changes in configuration metric instances (CONF). See how CONF metrics are recorded in TrueSight Capacity Optimization, in the page Metric sub-types in Agent.

    This view shows every past value of each configuration metric instance. If you are trying to extract the current values of configuration metric instances, you probably want to use the view PV_SYS_CONF_LAST below. That view contains only the last value of the configuration parameters.

    The key column in this view is SYSMETRICID, which is an internal TrueSight Capacity Optimization-generated unique number assigned to each metric instance.

    Column Name

    Data Type

    Description

    Key column

    SYSMETRICID

    NUMBER

    System metric ID

    PK. FK for SYSMETRICID in PV_SYS_METRIC

    SINCEDATA

    DATE

    Value validity start day

    PK

    TODATE

    DATE

    Value validity end day

     

    VALUE

    VARCHAR2

    Metric value

     

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    Apart from the changes in system configuration metrics values, if you want to check the historical changes in workload configuration metrics you can use PV_BDRV_CONF_VARIATION view.

    PV_SYS_CONF_LAST

    This view reports only the last value of system configuration metric instances.

    See how CONF metrics are recorded in TrueSight Capacity Optimization, in the page Metric sub-types in Agent.

    If you are looking for past values, use the view PV_SYS_CONF_VARIATION above.

    The key column is SYSMETRICID, which is an internal TrueSight Capacity Optimization-generated unique number assigned to each metric instance.

    Column Name

    Data Type

    Description

    Key column

    SYSMETRICID

    NUMBER

    System metric ID

    PK

    SINCEDATE

    DATE

    Value validity start day

     

    TODATE

    DATE

    Value validity end day

     

    VALUE

    VARCHAR2

    Metric value

     

    INSERTTS

    DATE

    Timestamp of insertion of this row. This is when the metric instance was created, or when the metric value was last changed.

     

    UPDATETS

    DATE

    Timestamp of last update on this row. This is when the metric instance value shown in this row was last loaded by a connector.

     

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_NUM'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    Apart from the last value of system configuration metric if you want to check the last value of workload configuration metrics you can use PV_BDRV_CONF_LAST view.

    PV_SYS_DATA_DETAIL

    This view contains system data in its original state. It does not have any default resolution.

    The key column for this view is SYSMETRICID, which is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    Column Name

    Data Type

    Description

    Key column

    SYSMETRICID

    NUMBER

    System metric ID

    PK

    TS

    DATE

    Timestamp

    PK

    DCLASSID

    NUMBER

    The Day class ID refers to the day for which statistics are calculated.

     

    HCLASSID

    NUMBER

    If hour classes are defined, the Hour class ID refers to individual classes for which statistics are calculated.

    For example, you can categorize a day into three classes (in hours) that signify work shifts.

     

    DURATION

    NUMBER

    Interval duration [seconds]

     

    AVGVALUE

    NUMBER

    Average samples value in the interval

     

    MINVALUE

    NUMBER

    Minimum sample value in the interval

     

    MAXVALUE

    NUMBER

    Maximum sample value in the interval

     

    SUMVALUE

    NUMBER

    Sum of samples values in the interval

     

    SUMQUADVALUE

    NUMBER

    Sum of samples square values in the interval

     

    COUNTGOOD

    NUMBER

    Number of samples in the interval with good value

     

    COUNTWARN

    NUMBER

    Number of samples in the interval with warning value

     

    COUNTPOOR

    NUMBER

    Number of samples in the interval with poor value

     

    COUNTERROR

    NUMBER

    Number of erroneous samples in the interval

     

    COUNTVALUE

    NUMBER

    Number of samples in the interval

     

    WEIGHT

    NUMBER

    Weight related to resource value. When no value is specified, the default value is 1.

     

    WAVGVALUE

    NUMBER

    Weighted average value

     

    The recommended aggregation to preserve data semantics in this view is explained in the following code:

     SUM(duration) AS duration,
     DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
     MIN(minvalue) AS minvalue,
     MAX(maxvalue) AS maxvalue,
     SUM(sumvalue) AS sumvalue,
     SUM(sumquadvalue) AS sumquadvalue,
     SUM(countgood) AS countgood,
     SUM(countwarn) AS countwarn,
     SUM(countpoor) AS countpoor,
     SUM(counterror) AS counterror,
     SUM(countvalue) AS countvalue,
     SUM(weight) AS weight,
     DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,
    

    In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:

    decode(countvalue,1,0,
    (sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))
    

    PV_SYS_DATA_DH

    This view contains system data at hourly resolution, So for given date there will be 24 rows for given sysmetricid.This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.

    The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

    Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

    TS is the timestamp of the of the value available for metric instance.

    DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

    PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

    when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
    So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

    ts

    plclass

    value

    duration

    00:00

    normal (pclassid=0)

    10

    3300

    00:00

    outlier

    10000000

    300

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    PV_SYS_DATA_D

    This view contains system data at daily resolution. This view has the same structure of, and uses the same aggregation as present in the PV_SYS_DATA_DETAIL view.

    The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

    Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

    TS is the timestamp of the of the value available for metric instance.

    DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

    PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

    when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
    So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

    ts

    plclass

    value

    duration

    00:00

    normal (pclassid=0)

    10

    3300

    00:00

    outlier

    10000000

    300

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    PV_SYS_DATA_DAY

    Column Name

    Data Type

    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_SYS_DATA_MDCH

    This contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.

    The key columns for this view are SYSMETRICID,TS,DCLASSID,PCLASSID.

    Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

    TS is the timestamp of the of the value available for metric instance.

    DCLASSID: This column is calculated by the DWH starting from the sample ts and using the calendar definition.This can be used for filtering purposes i.e. to consider/exclude set of day classes.

    PCLASSID: A user can manually mark some point in an analysis as regular outlier or relation outlier.

    when a point is marked as outlier its contribution is separated from non oultier samples (pclassid=0) like the MDCH case
    So also at hour level (when the outlier is marked at detail level and the original resolution is less than 1h) you can have two samples for the same hour

    ts

    plclass

    value

    duration

    00:00

    normal (pclassid=0)

    10

    3300

    00:00

    outlier

    10000000

    300

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    PV_SYS_DATA_RAW

    This view contains system data at its original resolution. No time aggregation is performed on this. This view has the structure of, and uses the same aggregation recommended for and present in the PV_SYS_DATA_DETAIL view.

    The key columns for this view are SYSMETRICID and TS.

    Here SYSMETRICID is an internal TrueSight Capacity Optimization generated unique number assigned to each metric instance.

    TS is the timestamp of the of the value available for metric instance.

    To get the value of SYSMETRICID we need to use PV_SYS_METRIC view. We can run select query on PV_SYS_METRIC with inputs of sysid and metric.

    E.g. select * from PV_SYS_METRIC where sysid=2070 and metric ='CPU_MHZ'

    Here sysid can be retrieved from console by mouse over on the required system Or user can query on PV_SYSTEM view to get the sysid.

    PV_SYS_DATA_CUST_STAT

    Column Name

    Data Type

    Description

    SYSOBJID

    NUMBER

     

    STATID

    NUMBER

     

    TS

    DATE

    Timestamp

    VALUE

    NUMBER

     

    COUNTSAMPLE

    NUMBER

     

    STATPRODID

    NUMBER)

     

    STRINGVALUE

    VARCHAR2 (250 Bytes)

     

    NAME

    VARCHAR2 (50 Bytes)

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

     

    VALTYPEID

    NUMBER

    See PV_CAT_VAL_TYPE.

    OWNERSHIP

    NUMBER

     

    PV_SYS_DATA_DETAIL_EXOU

    Column Name

    Data Type

    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_SYS_DATA_DH_EXOU

    Column Name

    Data Type

    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_SYS_DATA_D_EXOU

    Column Name

    Data Type

    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_SYS_DATA_MDCH_EXOU

    Column Name

    Data Type

    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    SLOPENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER
    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER

    PV_SYS_DATA_MONTH

    Column Name

    Data Type

    COUNTERRORNUMBER
    COUNTVALUENUMBER
    SYSMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    SLOPENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER

    PV_SYS_DATA_ROLL

    Column Name

    Data Type

    SYSMETRICIDNUMBER
    ROLLPERIODNUMBER
    TSDATE
    UPDATETSDATE
    DURATIONNUMBER
    COUNTNUMBER
    AVGNUMBER
    STDDEVNUMBER
    MINNUMBER
    MAXNUMBER
    SLOPENUMBER
    INTERCEPTNUMBER
    PCTILE50NUMBER
    PCTILE05NUMBER
    PCTILE95NUMBER
    PCTILE10NUMBER
    PCTILE90NUMBER
    PCTILE25NUMBER
    PCTILE75NUMBER

    PV_SYS_INDICATOR

    Column Name

    Data Type

    Description
    SYSIDNUMBER 
    SYSMETRICIDNUMBER 
    NAMEVARCHAR2(250 CHAR) 
    DESCRIPTIONVARCHAR2(4000 CHAR) 
    SYSTYPEIDNUMBER 
    SYSTYPEVARCHAR2(50 CHAR) 
    METRICVARCHAR2(50 CHAR) 
    METRICNAMEVARCHAR2(250 CHAR) 
    SUBMETRICNAMEVARCHAR2(512 CHAR) 
    LOCATIONIDNUMBER 
    LOCATIONNAMEVARCHAR2(250 CHAR) 
    VALTYPEIDNUMBER 
    VALTYPEVARCHAR2(50 CHAR)See PV_CAT_VAL_TYPE.
    LASTVALUEVARCHAR2(4000) 

    PV_SYS_IND_DATA

    Column Name

    Data Type

    Description
    SYSIDNUMBER 
    SYSMETRICIDNUMBER 
    NAMEVARCHAR2(250 CHAR) 
    DESCRIPTIONVARCHAR2(4000 CHAR) 
    SYSTYPEIDNUMBER 
    SYSTYPEVARCHAR2(50 CHAR) 
    METRICVARCHAR2(50 CHAR) 
    METRICNAMEVARCHAR2(250 CHAR) 
    SUBMETRICNAMEVARCHAR2(512 CHAR) 
    LOCATIONIDNUMBER 
    LOCATIONNAMEVARCHAR2(250 CHAR) 
    VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
    VALTYPEVARCHAR2(50 CHAR) 
    LASTVALUEVARCHAR2(4000) 

    PV_SYS_TAG

    Column Name

    Data Type

    SYSIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    SYSTYPEIDNUMBER
    SYSTYPEVARCHAR2(50 CHAR)
    TAGIDNUMBER
    TAGVARCHAR2(4000 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    INSERTTSDATE
    UPDATETSDATE
    TAGTYPEIDNUMBER
    TAGTYPENAMEVARCHAR2(50 CHAR)
    TAGTYPECOLORVARCHAR2(50 CHAR)

    Category-related views

    PV_CAT_APPL_TYPE

    Column Name

    Data Type

    APPLTYPEIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    ENTTYPENMVARCHAR2(50 CHAR)
    NAMEENVARCHAR2(50 CHAR)
    PACKAGEVARCHAR2(250 CHAR)
    VENDORVARCHAR2(250 CHAR)

    PV_CAT_AUDIT_ACTION

    Column Name

    Data Type

    AUDITACTIONIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    AUDITGROUPIDNUMBER
    GROUPNAMEVARCHAR2(50 CHAR)

    PV_CAT_BDRV_TYPE

    Column Name

    Data Type

    BDRVTYPEIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    ENTTYPENMVARCHAR2(50 CHAR)
    NAMEENVARCHAR2(50 CHAR)
    PACKAGEVARCHAR2(250 CHAR)
    VENDORVARCHAR2(250 CHAR)

    PV_CAT_EVENT_TYPE

    Column Name

    Data Type

    EVENTTYPEIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)

    PV_CAT_PARENTSHIP_TYPE

    Column Name

    Data Type

    PARENTSHIPTYPEIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    NODENAMEVARCHAR2(250 CHAR)
    DIRECTIONNUMBER
    PACKAGEVARCHAR2(250 CHAR)
    VENDORVARCHAR2(250 CHAR)

    PV_CAT_RM_RECOMM_TYPE

    Column Name

    Data Type

    RMALERTTYPEIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    PACKAGEVARCHAR2(250 CHAR)
    VENDORVARCHAR2(250 CHAR)

    PV_CAT_SYS_TYPE

    Column Name

    Data Type

    DESCRIPTIONVARCHAR2(250 CHAR)
    ENTTYPENMVARCHAR2(50 CHAR)
    NAMEENVARCHAR2(50 CHAR)
    PACKAGEVARCHAR2(250 CHAR)
    VENDORVARCHAR2(250 CHAR)
    SYSTYPEIDNUMBER
    NAMEVARCHAR2(50 CHAR)

    PV_CAT_VAL_TYPE

    Column Name

    Data Type

    Description
    VALTYPEIDNUMBER

    Number that indicates the type of value of a metric. For example, an absolute value, a percentage, or a frequency.

    VALTYPEID=5 is used to identify configuration metrics.

    NAMEVARCHAR2(50 CHAR) 
    DESCRIPTIONVARCHAR2(250 CHAR) 
    DEFAULTPLOTCOLVARCHAR2(50 CHAR)Contains the default statistic that is used when a metric is selected with the corresponding VALTYPE in an analysis.

     

     

    Business Driver related views

    PV_BUSINESS_DRIVER

    This view contains information on business drivers.

    Column Name

    Data Type

    Description

    Key Column

    BDRVID

    NUMBER

    Business driver ID

    PK

    NAME

    VARCHAR2 (50 Bytes)

    Business driver name

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Business driver description

     

    BDRVTYPEID

    NUMBER

    Business driver type ID

     

    BDRVTYPE

    VARCHAR2 (50 Bytes)

    Type of the business driver (Generic, ...)

     

    PV_BDRV_METRIC

    This view contains information on business driver metrics.

    Column Name

    Data Type

    Description

    Key Column

    BDRVID

    NUMBER

    Business driver ID

    AK1. FK BDRVID in PV_BUSINESS_DRIVER

    BDRVMETRICID

    NUMBER

    Business driver metric ID

    PK

    NAME

    VARCHAR2 (50 Bytes)

    Business driver name

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Business driver metric description

     

    BDRVTYPEID

    NUMBER

    Business driver type ID

     

    BDRVTYPE

    VARCHAR2 (50 Bytes)

    Type of the business driver (Generic, ...)

     

    METRIC

    VARCHAR2 (50 Bytes)

    Metric

     

    METRICNAME

    VARCHAR2 (50 Bytes)

    Metric full name

     

    SUBMETRICNAME

    VARCHAR2 (512 Bytes)

    Metric sub element name

    AK1

    LOCATIONID

    NUMBER

    Location ID

     

    LOCATIONNAME

    VARCHAR2 (50 Bytes)

    Location name

     

    VALTYPEID

    NUMBER

    Value type ID

    See PV_CAT_VAL_TYPE.

    VALTYPE

    VARCHAR2 (50 Bytes)

    Value type (count, rate, ...)

     

    PV_BDRV_CONF_VARIATION

    This view reports variations of business driver configuration parameters.

    Column Name

    Data Type

    Description

    Key Column

    BDRVMETRICID

    NUMBER

    Business driver metric ID

    PK. FK for BDRVMETRICID in PV_BDRV_METRIC

    SINCEDATA

    DATE

    Value validity start day

    PK

    TODATE

    DATE

    Value validity end day

     

    VALUE

    VARCHAR2 (250 Bytes)

    Metric value

     

    PV_BDRV_CONF_LAST

    This view reports only the last value of business driver configuration parameters.

    Column Name

    Data Type

    Description

    Key Column

    BDRVMETRICID

    NUMBER

    Business driver metric ID

    PK

    SINCEDATE

    DATE

    Value validity start day

     

    TODATE

    DATE

    Value validity end day

     

    VALUE

    VARCHAR2 (4000 Bytes)

    Metric value

     

    INSERTTS

    DATE

    Timestamp of insertion of this row

     

    UPDATETS

    DATE

    Timestamp of last update on this row

     

    PV_BDRV_DATA_DETAIL

    This view contains system data at its original resolution.

    Column Name

    Data Type

    Description

    Key Column

    BDRVMETRICID

    NUMBER

    Business driver metric ID

    PK

    TS

    DATE

    Timestamp

    PK

    DCLASSID

    NUMBER

    Day class ID

     

    HCLASSID

    NUMBER

    Hour class ID

     

    DURATION

    NUMBER

    Interval duration [seconds]

     

    AVGVALUE

    NUMBER

    Average samples value in the interval

     

    MINVALUE

    NUMBER

    Maximum sample value in the interval

     

    MAXVALUE

    NUMBER

    Minimum sample value in the interval

     

    SUMVALUE

    NUMBER

    Sum of samples values in the interval

     

    SUMQUADVALUE

    NUMBER

    Sum of samples square values in the interval

     

    COUNTGOOD

    NUMBER

    Number of samples in the interval with good value

     

    COUNTWARN

    NUMBER

    Number of samples in the interval with warning value

     

    COUNTPOOR

    NUMBER

    Number of samples in the interval with poor value

     

    COUNTERROR

    NUMBER

    Number of erroneous samples in the interval

     

    COUNTVALUE

    NUMBER

    Number of samples in the interval

     

    WEIGHT

    NUMBER

    Weight related to resource value

     

    WAVGVALUE

    NUMBER

    Weighted average value

     

    The recommended aggregation to preserve data semantics is:

    SUM(duration) AS duration,
    DECODE(SUM(duration),0,0,SUM(avgvalue*duration)/SUM(duration)) AS avgvalue,
    MIN(minvalue) AS minvalue,
    MAX(maxvalue) AS maxvalue,
    SUM(sumvalue) AS sumvalue,
    SUM(sumquadvalue) AS sumquadvalue,
    SUM(countgood) AS countgood,
    SUM(countwarn) AS countwarn,
    SUM(countpoor) AS countpoor,
    SUM(counterror) AS counterror,
    SUM(countvalue) AS countvalue,
    SUM(weight) AS weight,
    DECODE(SUM(weight),0,0,SUM(wavgvalue*weight)/SUM(weight)) AS wavgvalue,
    

    In order to compute the variance of data samples, you can apply the following statement to the result of a time aggregation query:

    decode(countvalue,1,0,(sumquadvalue/(countvalue-1)-power(avgvalue,2)*countvalue/(countvalue-1))

    PV_BDRV_DATA_DH

    This view contains system data at hourly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

    PV_BDRV_DATA_D

    This view contains system data at daily resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

    PV_BDRV_DATA_MDCH

    This view contains system data at monthly resolution. This view has the structure of, and uses the same aggregation recommended for and present in the PV_BDRV_DATA_DETAIL view.

    PV_BDRV_DATA_MDCH_EXOU

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    SLOPENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_BDRV_DATA_CUST_STAT

    Column Name

    Data Type

    Description

    NAME

    VARCHAR2 (50 Bytes)

     

    DESCRIPTION

    VARCHAR2 (250 Bytes)

     

    VALTYPEID

    NUMBER

    See PV_CAT_VAL_TYPE.

    OWNERSHIP

    NUMBER

     

    BDRVOBJID

    NUMBER

     

    STATID

    NUMBER

     

    TS

    DATE

    Timestamp

    VALUE

    NUMBER)

     

    COUNTSAMPLE

    NUMBER

     

    STATPRODID

    NUMBER

     

    STRINGVALUE

    VARCHAR2 (250 Bytes)

     

    PV_BDRV_DATA_DETAIL_EXOU

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_BDRV_DATA_DH_EXOU

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_BDRV_DATA_D_EXOU

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_BDRV_DATA_MDCH_EXOU

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    PV_BDRV_DATA_RAW

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSTIMESTAMP(6)
    TZOFFSETNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER

    PV_BDRV_DATA_ROLL

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    ROLLPERIODNUMBER
    TSDATE
    UPDATETSDATE
    DURATIONNUMBER
    COUNTNUMBER
    AVGNUMBER
    STDDEVNUMBER
    MINNUMBER
    MAXNUMBER
    SLOPENUMBER
    INTERCEPTNUMBER
    PCTILE50NUMBER
    PCTILE05NUMBER
    PCTILE95NUMBER
    PCTILE10NUMBER
    PCTILE90NUMBER
    PCTILE25NUMBER
    PCTILE75NUMBER

    PV_BDRV_EVENT

    Column Name

    Data Type

    TSDATE
    EVENTTYPEIDNUMBER
    EVENTTYPENAMEVARCHAR2(50 CHAR)
    EVENTSUBTYPEIDNUMBER
    EVENTSUBTYPENAMEVARCHAR2(50 CHAR)
    EVENTIDNUMBER
    EVENTTSDATE
    INTERVENTTSDATE
    RESOLUTIONTSDATE
    EVENTNAMEVARCHAR2(250 CHAR)
    EVENTDESCVARCHAR2(4000 CHAR)
    NOTEVARCHAR2(4000 CHAR)
    COLORVARCHAR2(50 CHAR)
    PERIODNUMBER
    PERIODSINCEDATEDATE
    PERIODTODATEDATE
    SEVERITYVARCHAR2(50 CHAR)
    STATUSVARCHAR2(50 CHAR)
    SERVICEUNAVAILABILITYNUMBER
    PENDINGTIMEMILLISNUMBER
    INTERVENTTIMEMILLISNUMBER
    RESOLUTIONTIMEMILLISNUMBER
    SOURCECLASSVARCHAR2(512 CHAR)
    SRCEVENTIDVARCHAR2(50 CHAR)
    COUNTOCCURRENCENUMBER
    BDRVIDNUMBER
    BDRVNAMEVARCHAR2(250 CHAR)
    BDRVDESCVARCHAR2(4000 CHAR)
    BDRVTYPEIDNUMBER
    BDRVTYPEVARCHAR2(50 CHAR)

    PV_BDRV_METRIC_EVENT

    Column Name

    Data Type

    Description
    TSDATE 
    EVENTTYPEIDNUMBER 
    EVENTTYPENAMEVARCHAR2(50 CHAR) 
    EVENTSUBTYPEIDNUMBER 
    EVENTSUBTYPENAMEVARCHAR2(50 CHAR) 
    EVENTIDNUMBER 
    EVENTTSDATE 
    INTERVENTTSDATE 
    RESOLUTIONTSDATE 
    EVENTNAMEVARCHAR2(250 CHAR) 
    EVENTDESCVARCHAR2(4000 CHAR) 
    NOTEVARCHAR2(4000 CHAR) 
    COLORVARCHAR2(50 CHAR) 
    PERIODNUMBER 
    PERIODSINCEDATEDATE 
    PERIODTODATEDATE 
    SEVERITYVARCHAR2(50 CHAR) 
    STATUSVARCHAR2(50 CHAR) 
    SERVICEUNAVAILABILITYNUMBER 
    PENDINGTIMEMILLISNUMBER 
    INTERVENTTIMEMILLISNUMBER 
    RESOLUTIONTIMEMILLISNUMBER 
    SOURCECLASSVARCHAR2(512 CHAR) 
    SRCEVENTIDVARCHAR2(50 CHAR) 
    COUNTOCCURRENCENUMBER 
    BDRVIDNUMBER 
    BDRVMETRICIDNUMBER 
    BDRVNAMEVARCHAR2(250 CHAR) 
    BDRVDESCVARCHAR2(4000 CHAR) 
    BDRVTYPEIDNUMBER 
    BDRVTYPEVARCHAR2(50 CHAR) 
    METRICVARCHAR2(50 CHAR) 
    METRICNAMEVARCHAR2(250 CHAR) 
    SUBMETRICNAMEVARCHAR2(512 CHAR) 
    LOCATIONIDNUMBER 
    LOCATIONNAMEVARCHAR2(250 CHAR) 
    VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
    VALTYPEVARCHAR2(50 CHAR) 

    Class ID views

    PV_H_CLASS

    This view provides names and descriptions for hour class IDs.

    Column Name

    Data Type

    Description

    HCLASSID

    NUMBER

    Hour class ID

    NAME

    VARCHAR2 (50 Bytes)

    Hour class NAME

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Hour class description

    PV_D_CLASS

    This view provides names and descriptions for day class IDs.

    Column Name

    Data Type

    Description

    DCLASSID

    NUMBER

    Day class ID

    NAME

    VARCHAR2 (50 Bytes)

    Day class NAME

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Day class description

    Chargeback related views

    PV_CB_COST_OBJECT

    This view contains information on a cost object.

    Column Name

    Data Type

    Description

    COSTOBJID

    NUMBER

    Cost object ID

    NAME

    VARCHAR2 (50 Bytes)

    Cost object name

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Cost object description

    COSTOBJTYPEID

    NUMBER

    Cost object type ID

    COSTOBJTYPE

    VARCHAR2 (50 Bytes)

    Type of the cost object
    (Basic Cost Object, Composite Cost Object)

    COSTOBJKEY

    NUMBER

    Cost object key

    PV_CB_COST_OBJECT_METADATA

    Column Name

    Data Type

    COSTOBJIDNUMBER
    COSTOBJKEYVARCHAR2(250 CHAR)
    COSTOBJSUBKEYVARCHAR2(250 CHAR)
    NAMEVARCHAR2(250 CHAR)
    VALUEVARCHAR2(4000 CHAR)

    PV_CB_COST_OBJECT_SUBKEY

    This view contains information on subkeys of a basic cost object.

    Column Name

    Data Type

    Description

    References

    COSTOBJID

    NUMBER

    Cost object ID

    PV_CB_COST_OBJECT.COSTOBJID

    COSTOBJKEY

    VARCHAR2 (50 Bytes)

    Cost object key

    PV_CB_COST_OBJECT.COSTOBJKEY

    COSTOBJSUBKEY

    VARCHAR2 (50 Bytes)

    Cost object subkey

     

    PROPNAME

    VARCHAR2 (250 Bytes)

    Name of the property (mode, consunit, label)

     

    PROPVALUE

    VARCHAR2 (250 Bytes)

    Value of the property

     

    PV_CB_CO_ALLOC

    This view contains information on an allocation between a composite cost object and a cost object.

    Column Name

    Data Type

    Description

    References

    COSTOBJID

    NUMBER

    Cost object ID

    PV_CB_COST_OBJECT.COSTOBJID

    COSTOBJNAME

    VARCHAR2 (50 Bytes)

    Cost object name

     

    COSTOBJKEY

    VARCHAR2 (50 Bytes)

    Cost object key

    PV_CB_COST_OBJECT.COSTOBJKEY

    COSTOBJIDALLOC

    NUMBER

    Cost object ID allocated

    PV_CB_COST_OBJECT.COSTOBJID

    COSTOBJNAMEALLOC

    VARCHAR2 (50 Bytes)

    Cost object name allocated

     

    COSTOBJKEYALLOC

    NUMBER

    Cost object key allocated

    PV_CB_COST_OBJECT.COSTOBJKEY

    ALLOCATION

    NUMBER

    Percentage of allocation

     

    SINCEDATE

    DATE

    Allocation validity start day

     

    TODATE

    DATE

    Allocation validity end day

     

    PV_CB_TARGET

    This view contains information on a target

    Column Name

    Data Type

    Description

    TARGETID

    NUMBER

    Target ID

    NAME

    VARCHAR2 (50 Bytes)

    Target name

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Target description

    PV_CB_MODEL

    This view contains information on a chargeback model

    Column Name

    Data Type

    Description

    MODELID

    NUMBER

    Model ID

    NAME

    VARCHAR2 (50 Bytes)

    Model name

    DESCRIPTION

    VARCHAR2 (250 Bytes)

    Model description

    TARGETIDPARENT

    NUMBER

    Target root ID

    CURRENCY

    VARCHAR2 (50 Bytes)

    Currency

    PV_CB_MODEL_TARGET

    Column Name

    Data Type

    ACBMDELIDNUMBER
    ACBTARGETIDNUMBER

    PV_CB_TARGET_PARENTSHIP

    This view contains information on a target hierarchy.

    Column Name

    Data Type

    Description

    References

    MODELID

    NUMBER

    Model ID

    PV_CB_MODEL.MODELID

    TARGETIDPARENT

    NUMBER

    Target parent ID

    PV_CB_TARGET.TARGETID

    TARGETIDCHILD

    NUMBER

    Target child ID

    PV_CB_TARGET.TARGETID

    PV_CB_TARGET_METADATA

    Column Name

    Data Type

    TARGETIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    VALUEVARCHAR2(4000 CHAR)

    PV_CB_ALLOCATION

    This view contains information on an allocation between a target and a cost object.

    Column Name

    Data Type

    Description

    References

    MODELID

    NUMBER

    Model ID

    PV_CB_MODEL.MODELID

    TARGETID

    NUMBER

    Target ID

    PV_CB_TARGET.TARGETID

    TARGETNAME

    VARCHAR2 (50 Bytes)

    Target name

     

    COSTOBJID

    NUMBER

    Cost object ID

    PV_CB_COST_OBJECT.COSTOBJID

    COSTOBJNAME

    VARCHAR2 (50 Bytes)

    Cost object name

     

    COSTOBJKEY

    VARCHAR2 (50 Bytes)

    Cost object key

    PV_CB_COST_OBJECT.COSTOBJKEY

    ALLOCATION

    NUMBER

    Percentage of allocation

     

    SINCEDATE

    DATE

    Allocation validity start day

     

    TODATE

    DATE

    Allocation validity end day

     

    PV_CB_ALLOCATION_METADATA

    Column Name

    Data Type

    ALLOCIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    VALUEVARCHAR2(4000 CHAR)

    PV_CB_TARGET_METRIC

    This view contains information on target metrics.

    Column Name

    Data Type

    Description

    References

    TARGETID

    NUMBER

    Target ID

    PV_CB_TARGET.TARGETID

    TARGETNAME

    VARCHAR2 (50 Bytes)

    Target name

     

    TARGETMETRICID

    NUMBER

    Target metric ID

     

    METRIC

    VARCHAR2 (50 Bytes)

    Metric

     

    METRICNAME

    VARCHAR2 (50 Bytes)

    Metric full name

     

    COCOSTOBJKEY4

    VARCHAR2 (50 Bytes)

    Composite cost object key level 4

    PV_CB_COST_OBJECT.COSTOBJKEY

    COCOSTOBJKEY3

    VARCHAR2 (50 Bytes)

    Composite cost object key level 3

    PV_CB_COST_OBJECT.COSTOBJKEY

    COCOSTOBJKEY2

    VARCHAR2 (50 Bytes)

    Composite cost object key level 2

    PV_CB_COST_OBJECT.COSTOBJKEY

    COCOSTOBJKEY1

    VARCHAR2 (50 Bytes)

    Composite cost object key level 1

    PV_CB_COST_OBJECT.COSTOBJKEY

    COSTOBJKEY

    VARCHAR2 (50 Bytes)

    Basic Cost object key

    PV_CB_COST_OBJECT.COSTOBJKEY

    COSTOBJSUBKEY

    VARCHAR2 (50 Bytes)

    Cost object subkey

    PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY

    METADATA

    VARCHAR2 (50 Bytes)

    Metadata

     

    Note

    There can be a maximum of 4 nested composite cost object levels. Levels are labeled as shown in the following figure:

    Cost object nesting

    PV_CB_TARGET_DATA_DAY

    This view contains target data.

    Column Name

    Data Type

    Description

    References

    TARGETMETRICID

    NUMBER

    Target metric

    ID PV_CB_TARGET.TARGETID

    TS

    DATE

    Timestamp

     

    DURATION

    NUMBER

    Duration of the period in which samples were collected

     

    VALUE

    NUMBER

    Sample value

     

    PV_CB_COST_RATE

    This view contains information on a cost rate.

    Column Name

    Data Type

    Description

    References

    MODELID

    NUMBER

    Model ID

    PV_CB_MODEL.MODELID

    COSTOBJID

    NUMBER

    Cost object

    ID PV_CB_COST_OBJECT.COSTOBJID

    COSTOBJNAME

    VARCHAR2 (50 Bytes)

    Cost object name

     

    COSTOBJKEY

    VARCHAR2 (50 Bytes)

    Cost object key

    PV_CB_COST_OBJECT.COSTOBJKEY

    COSTOBJSUBKEY

    VARCHAR2 (50 Bytes)

    Cost object subkey

    PV_CB_COST_OBJECT_SUBKEY.COSTOBJSUBKEY

    METADATA

    VARCHAR2 (250 Bytes)

    Metadata value

     

    COSTRATENAME

    VARCHAR2 (50 Bytes)

    Cost rate name

     

    COSTRATE

    NUMBER

    Cost rate value

     

    CONSUNIT

    VARCHAR2 (50 Bytes)

    Consumption unit

     

    COSTUNIT

    VARCHAR2 (50 Bytes)

    Cost unit

     

    SINCEDATE

    DATE

    Cost rate validity start day

     

    TODATE

    DATE

    Cost rate validity end day

     

    PV_CB_COST_RATE_METADATA

    Column Name

    Data Type

    COSTRATEIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    VALUEVARCHAR2(4000 CHAR)

    Other

    PV_ENT_PARENTSHIP_CURRENT

    This view contains information on relationship between systems, business drivers and domains (hierarchy).

    Column Name

    Data Type

    Description

    Key column

    STRUCTUREIDPARENT

    VARCHAR2 (6 Bytes)

    Structure of father node

    PK. “FK” indicates whether parent is a SYS, BDRV, or APP

    IDPARENT

    NUMBER

    ID of father node

    PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

    STRUCTUREIDCHILD

    VARCHAR2 (6 Bytes)

    Structure of child node

    PK. “FK” indicates whether child is a SYS, BDRV, or APP

    IDCHILD

    NUMBER

    ID of child node

    PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

    SINCEDATE

    DATE

    Value validity start day

     

    TODATE

    DATE

    Value validity end day

     

    PARENTSHIPTYPEID

    NUMBER

    Parentship type ID

     

    PARENTSHIPTYPE

    VARCHAR2 (50 Bytes)

    Parentship type name

     

    PV_ENT_PARENTSHIP_HIST

    This view contains historical information on relationship between systems, business drivers and domains (hierarchy).

    Column Name

    Data Type

    Description

    Key column

    STRUCTUREIDPARENT

    VARCHAR2 (6 Bytes)

    Structure of father node

    PK. “FK” indicates whether parent is a SYS, BDRV, or APP

    IDPARENT

    NUMBER

    ID of father node

    PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

    STRUCTUREIDCHILD

    VARCHAR2 (6 Bytes)

    Structure of child node

    PK. “FK” indicates whether child is a SYS, BDRV, or APP

    IDCHILD

    NUMBER

    ID of child node

    PK. FK SYSID in PV_SYSTEM, or FK APPID in PV_APPLICATION, or FK BDRVID in PV_BDRV

    SINCEDATE

    DATE

    Value validity start day

    PK

    TODATE

    DATE

    Value validity end day

     

    PARENTSHIPTYPEID

    NUMBER

    Parentship type ID

     

    PARENTSHIPTYPE

    VARCHAR2 (50 Bytes)

    Parentship type name

     

    HIERRULEID

    NUMBER

    Hierarchy rule id

     

    HIERRULE

    VARCHAR2 (50 Bytes)

    Hierarchy rule name

     

    PV_ENT_LOOKUP

    Column Name

    Data Type

    SRCIDNUMBER
    SRCIDSHARELOOKUPNUMBER
    LOOKUPFIELDVARCHAR
    LOOKUPVALUEVARCHAR
    STRUCTUREIDVARCHAR
    IDNUMBER
    INSERTTSDATE
    ACTIVITYDATEDATE
    DATASOURCENAMEVARCHAR
    ETLMODIDNUMBER
    ETLMODULEVARCHAR
    OWNERSHIPNUMBER
    COMPONENTIDNUMBER
    COMPONENTNAMEVARCHAR

    PV_TASK

    Column Name

    Data Type

    TASKIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    ENABLEDNUMBER(1)
    TASKTYPEIDNUMBER
    TASKTYPEVARCHAR2(50 CHAR)
    PERIODNUMBER
    SCHEDULERIDNUMBER
    SRCIDNUMBER
    COMPONENTIDNUMBER
    COMPONENT_NAMEVARCHAR2(250 CHAR)
    COMPTYPEIDNUMBER
    COMPTYPEVARCHAR2(50 CHAR)
    STATUSVARCHAR2(250 CHAR)
    EXITCODEVARCHAR2(25 CHAR)
    LASTEXECTSDATE
    NEXTEXECTSDATE
    TASKIDPARENTNUMBER

    PV_TASK_RUN

    Column Name

    Data Type

    TASKRUNIDNUMBER
    TASKIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    TASKIDPARENTNUMBER
    EXECTSDATE
    EXITCODEVARCHAR2(25 CHAR)
    STATUSVARCHAR2(250 CHAR)
    DURATIONNUMBER
    EXTRACTDURATIONNUMBER
    LOADDURATIONNUMBER
    CREATEDENTITIESNUMBER
    CONFDATALOADEDNUMBER
    TSDATALOADEDNUMBER
    OBJRELDATALOADEDNUMBER
    LOADEDENTITIESNUMBER
    TASKEXECREQIDNUMBER
    EXECPCTNUMBER
    ACCOUNTIDNUMBER
    ACCOUNTVARCHAR2(50 CHAR)

    PV_APPL_CONF_VARIATION

    Column Name

    Data Type

    APPMETRICIDNUMBER
    SINCEDATEDATE
    TODATEDATE
    VALUEVARCHAR2(4000 CHAR)
    INSERTTSDATE
    UPDATETSDATE

    PV_APPL_CONF_LAST

    Column Name

    Data Type

    APPMETRICIDNUMBER
    SINCEDATEDATE
    TODATEDATE
    VALUEVARCHAR2(4000 CHAR)
    INSERTTSDATE
    UPDATETSDATE

    PV_ANALYSIS_STAT_PROD

    Column Name

    Data Type

    STATPRODIDNUMBER
    STATPRODKEYVARCHAR2(250 CHAR)
    PLOTIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    TEMPLIDNUMBER
    TEMPLNAMEVARCHAR2(250 CHAR)
    TYPEIDNUMBER
    TYPENAMEVARCHAR2(50 CHAR)
    TIMEFILTERIDVARCHAR2(4000 CHAR)
    TIMEFILTERNAMEVARCHAR2(250 CHAR)
    CUSTOMTIMERANGEVARCHAR2(4000 CHAR)

    PV_AUDIT_MESSAGE

    Column NameData Type
    AUDITGROUPIDNUMBER
    AUDITGROUPNAMEVARCHAR2(50 CHAR)
    AUDITMSGIDNUMBER
    TSDATE
    AUDITACTIONIDNUMBER
    ACTIONNAMEVARCHAR2(50 CHAR)
    ACTIONDESCRVARCHAR2(250 CHAR)
    ACCOUNTIDNUMBER
    ACCOUNTNAMEVARCHAR2(50 CHAR)
    ACCOUNTFULLNAMEVARCHAR2(50 CHAR)
    COMPONENTVARCHAR2(250 CHAR)
    COMPONENTTYPEVARCHAR2(50 CHAR)
    SUBCOMPONENTVARCHAR2(249)
    IDSTRVARCHAR2(250 CHAR)
    MESSAGEVARCHAR2(4000 CHAR)
    ELAPSEDNUMBER
    HOSTIDNUMBER
    HOSTNAMEVARCHAR2(250 CHAR)

    Event-related views

    PV_EVENT

    This view contains information on events.

    Column Name

    Data Type

    Description

    TS

    DATE

    Timestamp

    EVENTTYPEID

    NUMBER

    Event type ID

    EVENTTYPENAME

    VARCHAR2 (50 Bytes)

    Event type name

    EVENTSUBTYPEID

    NUMBER

    Event subtype ID

    EVENTSUBTYPENAME

    VARCHAR2 (50 Bytes)

    Event subtype name

    EVENTID

    NUMBER

    Event ID

    EVENTTS

    DATE

    Event date

    INTERVENTTS

    DATE

     

    RESOLUTIONTS

    DATE

     

    EVENTNAME

    VARCHAR2 (250 Bytes)

     

    EVENTDESC

    VARCHAR2 (4000 Bytes)

     

    NOTE

    VARCHAR2 (4000 Bytes)

     

    COLOR

    VARCHAR2 (50 Bytes)

     

    PERIOD

    NUMBER

     

    PERIODSINCEDATE

    DATE

     

    PERIODTODATE

    DATE)

     

    SEVERITY

    VARCHAR2 (50 Bytes)

     

    STATUS

    VARCHAR2 (50 Bytes)

     

    SERVICEUNAVAILABILITY

    NUMBER

     

    PENDINGTIMEMILLIS

    NUMBER

     

    INTERVENTTIMEMILLIS

    NUMBER

     

    RESOLUTIONTIMEMILLIS

    NUMBER

     

    SOURCECLASS

    VARCHAR2 (512 Bytess)

     

    SRCEVENTID

    VARCHAR2 (50 Bytess)

     

    COUNTOCCURRENCE

    NUMBER

     

    PV_EVENT_OBJECT

    This view contains information on the object related to an event.

    Column Name

    Data Type

    EVENTID

    NUMBER

    OBJNAME

    VARCHAR2 (50 Bytes)

    REFERREDID

    NUMBER

    Domain-related views

    PV_APPLICATION

    This view contains information on domains.

    Column Name

    Data Type

    Description

    Key column

    APPID

    NUMBER

    Domain ID

    PK

    APPLNAME

    VARCHAR2 (50 Bytes)

    Domain name

     

    APPLDESCRIPTION

    VARCHAR2 (250 Bytes)

    Domain description

     

    GROUPID

    NUMBER

    Domain group ID

    FK in PV_APPLICATION

    GROUPNAME

    VARCHAR2 (50 Bytes)

    Domain group name

     

    GROUPDESCRIPTION

    VARCHAR2 (250 Bytes)

    Domain group description

     

    PV_APPL_BDRV

    Use this view to join PV_APPLICATION and PV_BDRV_METRIC, in order to retrieve metrics of all the business drivers owned by a certain domain.

    Column Name

    Data Type

    Description

    BDRVID

    NUMBER

    Business driver ID

    APPID

    NUMBER

    Domain ID

    PV_APPL_EVENT

    Use this view to join PV_APPLICATION and PV_EVENT, in order to retrieve events as per domains.

    Column Name

    Data Type

    Description

    TS

    DATE

    Timestamp

    EVENTTYPEID

    NUMBER

     

    EVENTTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTSUBTYPEID

    NUMBER

     

    EVENTSUBTYPENAME

    VARCHAR2 (50 Bytes)

     

    EVENTID

    NUMBER

     

    EVENTTS

    DATE

     

    INTERVENTTS

    DATE

     

    RESOLUTIONTS

    DATE

     

    EVENTNAME

    VARCHAR2

     

    EVENTDESC

    VARCHAR2

     

    NOTE

    VARCHAR2 (4000 Bytes)

     

    COLOR

    VARCHAR2 (50 Bytes)

     

    PERIOD

    NUMBER

     

    PERIODSINCEDATE

    DATE

     

    PERIODTODATE

    DATE

     

    SEVERITY

    VARCHAR2 (50 Bytes)

     

    STATUS

    VARCHAR2 (50 Bytes)

     

    SERVICEUNAVAILABILITY

    NUMBER

     

    PENDINGTIMEMILLIS

    NUMBER

     

    INTERVENTTIMEMILLIS

    NUMBER

     

    RESOLUTIONTIMEMILLIS

    NUMBER

     

    SOURCECLASS

    VARCHAR2 (512 Bytes)

     

    SRCEVENTID

    VARCHAR2 (50 Bytes)

     

    COUNTOCCURRENCE

    NUMBER

     

    APPID

    NUMBER

     

    APPLNAME

    VARCHAR2 (250 Bytes)

     

    APPLDESCRIPTION

    VARCHAR2 (4000 Bytes)

     

    GROUPID

    NUMBER

     

    GROUPNAME

    VARCHAR2 (250 Bytes)

     

    GROUPDESCRIPTION

    VARCHAR2 (4000 Bytes)

     

    PV_APPL_SYS

    Use this view to join PV_APPLICATION and PV_SYS_METRIC, in order to retrieve the metrics of all the systems owned by a certain domain.

    Column Name

    Data Type

    Description

    Key column

    SYSID

    NUMBER

    System ID

    PK. FK SYSID in PV_SYSTEM

    APPID

    NUMBER

    Domain ID

    PK. FK APPID in PV_APPLICATION

     

    PV_APPL_METRIC

    Use this view to retrieve metric instances owned by a certain domain.

     

    PV_APPL_TAG

    Column NameData Type
    TAGTYPENAMEVARCHAR2(50 CHAR)
    TAGTYPECOLORVARCHAR2(50 CHAR)
    APPIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    APPLTYPEIDNUMBER
    APPLTYPEVARCHAR2(50 CHAR)
    TAGIDNUMBER
    TAGVARCHAR2(4000 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    INSERTTSDATE
    UPDATETSDATE
    TAGTYPEIDNUMBER

    PV_APPL_WKLD

    Column NameData Type

    APPID

    NUMBER
    WKLDIDNUMBER

     

     

    Resource monitor alert views

    PV_RM_ALERT_LOG

     Use the view to join PV_RM and PV_ALERT_LOG, in order to retrieve the metrics of all the systems owned by a certain domain.

    Column NameData TypeDescription
    RMALERTIDNUMBERResource Monitor Alert rule ID
    RMALERTNAMEVARCHARResource Monitor Alert rule name
    TSDATEAlert triggering date
    STRUCTUREIDVARCHARStructure of alerted entity
    IDNUMBERID of alerted entity
    TYPEIDNUMBERAlerted entity type ID
    NAMEVARCHARName of the alerted entity
    STATUSIDNUMBERStatus ID of the alerted entity
    RMALERTSTATUSIDNUMBERAssigned alert status ID
    RMALERTSTATUSNAMEVARCHAR

    Assigned alert status name

    (OK,WARNING, and CRITICAL)
    RMALERTREASONVARCHARAlert reason
    LASTRUNTSDATELast execution date of the rule

    PV_RM_RECOMM

    Column NameData Type
    STRUCTUREIDVARCHAR2(6 CHAR)
    ENTIDNUMBER
    RMALERTIDNUMBER
    RMALERTVARCHAR2(50 CHAR)
    RMALERTTYPEVARCHAR2(250 CHAR)
    CATEGORYVARCHAR2(50)
    SEVERITYVARCHAR2(50 CHAR)
    SEV_INDEXNUMBER
    RMALERTTEMPLIDNUMBER
    RMALERTTEMPLVARCHAR2(250 CHAR)
    PRIORITYNUMBER
    TSDATE
    SMALLDESCRIPTIONVARCHAR2(4000 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    RECOMMENDATIONVARCHAR2(4000 CHAR)
    RESOURCESVARCHAR2(250 CHAR)

    PV_RM_RULE

    Column NameData Type
    RMALERTIDNUMBER
    INSERTTSDATE
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    LASTRUNTSDATE
    RMALERTTEMPLIDNUMBER
    RMALERTTEMPLVARCHAR2(250 CHAR)

    ETL-related views

    PV_ETL

    Column NameData Type
    TASKIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    ENABLEDNUMBER(1)
    TASKTYPEIDNUMBER
    TASKTYPEVARCHAR2(50 CHAR)
    PERIODNUMBER
    SCHEDULERIDNUMBER
    SRCIDNUMBER
    ETLMODIDNUMBER
    COMPONENTIDNUMBER
    COMPONENT_NAMEVARCHAR2(250 CHAR)
    COMPTYPEIDNUMBER
    COMPTYPEVARCHAR2(50 CHAR)
    STATUSVARCHAR2(250 CHAR)
    EXITCODEVARCHAR2(25 CHAR)
    LASTEXECTSDATE
    NEXTEXECTSDATE
    TASKIDPARENTNUMBER
    ETLMODULEVARCHAR2(250 CHAR)
    ETLMODTYPEVARCHAR2(20 CHAR)
    ETLMODPACKAGEVARCHAR2(250 CHAR)
    ETLMODVENDORVARCHAR2(250 CHAR)

    PV_ETL_RUN

    Column NameData Type
    TASKRUNIDNUMBER
    TASKIDNUMBER
    NAMEVARCHAR2(250 CHAR)
    TASKIDPARENTNUMBER
    EXECTSDATE
    EXITCODEVARCHAR2(25 CHAR)
    STATUSVARCHAR2(250 CHAR)
    DURATIONNUMBER
    EXTRACTDURATIONNUMBER
    LOADDURATIONNUMBER
    CREATEDENTITIESNUMBER
    CONFDATALOADEDNUMBER
    TSDATALOADEDNUMBER
    OBJRELDATALOADEDNUMBER
    LOADEDENTITIESNUMBER
    TASKEXECREQIDNUMBER
    EXECPCTNUMBER
    ACCOUNTIDNUMBER
    ACCOUNTVARCHAR2(50 CHAR)

     

    Forecast Model-related views

    PV_FORECAST_MODEL_DETAILS

    Column NameData Type
    TCIDNUMBER
    TIMEFILTERIDVARCHAR2(4000 CHAR)
    TIMEFILTERNAMEVARCHAR2(250 CHAR)
    TIMEBACKVARCHAR2(4000 CHAR)
    TIMEFWDVARCHAR2(4000 CHAR)
    ALGORITHMTYPEVARCHAR2(4000 CHAR)
    ALGORITHMNAMEVARCHAR2(4000 CHAR)
    MANUALTHRESHOLDVARCHAR2(4000 CHAR)

    Model-related views

    PV_MODEL_STAT_PROD

    Column NameData Type
    STATUSIDNUMBER
    STATUSVARCHAR2(50 CHAR)
    STATPRODKEYVARCHAR2(250 CHAR)
    TCIDNUMBER
    MODELIDNUMBER
    NAMEVARCHAR2(503 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    MODELNAMEVARCHAR2(250 CHAR)
    MODELDESCRIPTIONVARCHAR2(4000 CHAR)
    MODELTYPEIDNUMBER
    MODELTYPENAMEVARCHAR2(50)
    TCNAMEVARCHAR2(250 CHAR)
    TCDESCRIPTIONVARCHAR2(4000 CHAR)
    STATPRODIDNUMBER

    Object Map-related views

    PV_OBJ_MAP_DATA_CUST_STAT

    Column NameData TypeDescription
    SERIESIDPRIVARCHAR2(512 CHAR) 
    STRUCTUREIDSECVARCHAR2(6 CHAR) 
    SERIESIDSECVARCHAR2(512 CHAR) 
    STATIDNUMBER 
    TSDATE 
    VALUENUMBER 
    COUNTSAMPLENUMBER 
    STRINGVALUEVARCHAR2(250 CHAR) 
    STATPRODIDNUMBER 
    NAMEVARCHAR2(50 CHAR) 
    DESCRIPTIONVARCHAR2(250 CHAR) 
    VALTYPEIDNUMBERSee PV_CAT_VAL_TYPE.
    OWNERSHIPNUMBER 
    STRUCTUREIDPRIVARCHAR2(6 CHAR) 

    Reservation-related views

    PV_RESERVATION

    This view contains the list of reservations. Resource requirements are the sum of requested capacity of all "reservation components" for a certain reservation.

    Column Name

    Data Type

    Key column

    RSVID

    NUMBERX

    NAME

    VARCHAR 
    EXTERNALIDNUMBER 

    CONTAINERPOOLIDS

    VARCHAR 

    CONTAINERPOOLNAMES

    VARCHAR 

    DESCRIPTION

    VARCHAR 

    INSERTTS

    DATE 

    UPDATETS

    DATE 

    PRIORITY

    NUMBER 

    PRIORITYSTRING

    VARCHAR 
    START_DATEDATE 
    END_DATEDATE 

    STATUSID

    NUMBERMapped to accepted, pending, committed, rejected, expired

    STATUS

    VARCHAR

     

    RSVALERTSTATUS

    VARCHAR

     

    RSVALERTSTATUSIDNUMBER 

    RSVALERTSTATUS_DESCRIPTION

    VARCHAR

     

    OWNER

    VARCHAR

     

    CPUMHZ

    NUMBER

     

    MEMORY

    NUMBER

     

    DISKNUMBER 

    VCPUNUM

    NUMBER

     

    CPUCORES

    NUMBER

     

    CPUMHZCAPACITYNUMBER 
    MEMECAPACITYNUMBER 
    DSKCAPACITYNUMBER 
    LCPUCAPACITYNUMBER 
    CPUENTCCAPACITYNUMBER 

    ALERTEDCONTAINERS

    VARCHAR

     

    TENANTVARCHAR 

    PV_CAPACITY_POOL

    This view contains the list of capacity pools.

    Column Name

    Data Type

    SYSIDNUMBER

    NAME

    VARCHAR
    DESCRIPTIONVARCHAR
    SYSTYPEIDNUMBER
    SYSTYPEVARCHAR
    RESERVATIONAVAILABILITYVARCHAR
    RSVALERTSTATUSIDNUMBER
    RSVALERTSTATUSVARCHAR
    RSVALERTSTATUSDESCRIPTIONVARCHAR
    RSVALERTSTATTSDATE
    PENDINGRSVNUMNUMBER
    COMMITTEDRSVNUMNUMBER
    CONTAINERSNUMNUMBER

    PV_CONTAINER_POOL_RSVCONTAINER

    Column Name

    Data Type

    CONTAINERPOOLIDNUMBER
    RSVCONTAINERIDNUMBER

    PV_RSV_CAPACITY_POOL

    This view contains the list of capacity pools.

    Column Name

    Data Type

    CONTAINERPOOLIDNUMBER

    RSVID

    NUMBER

    PV_RSV_CONTAINER

    This view contains the list of capacity containers.

    Column Name

    Data Type

    Key column

    SYSID

    NUMBER RSV_CONTAINER.SYSID (FK)

    NAME

    VARCHAR

     SYS_DEF.NAME

    SYSTYPEID

    NUMBER

     
    STATUSIDNUMBER 

    RSVTYPEID

    NUMBER

     

    RSVALERTSTATUSID

    NUMBER 

    RSVALERTTS

    DATE

     

    CONTAINERPOOLIDS

    VARCHAR

     

    CONTAINERPOOLNAMES

    VARCHAR

     
    GMONNUMNUMBER 
    VCPUONNUMNUMBER 

    SPAREVM_ALLOCATION

    NUMBER

     

    SPAREVM_UTILIZATION

    NUMBER 

    SPAREVMP1_ALLOCATION

    NUMBER

     

    SPAREVMP1_UTILIZATION

    NUMBER

     

    SPAREVMP2_ALLOCATION

    NUMBER 

    SPAREVMP2_UTILIZATION

    NUMBER 

    LIMITINGRESOURCE_ALLOCATION

    VARCHAR

     

    LIMITINGRESOURCE_UTILIZATION

    VARCHAR 

    COMMITTEDRESERVATIONS

    NUMBER

     

    PENDINGRESERVATIONS

    NUMBER

     
    SPAREVM_BASISVARCHAR 

    PV_RSV_ONBOARDING

    Lists all On-boarding events. For each onboarding reports destination container, date of on-boarding, and total additional capacity provided.

    Column Name

    Data Type

    Key column

    RSVONBOARDINGIDNUMBERX
    NAMEVARCHAR 
    DESCRIPTIONVARCHAR 
    INSERTTSDATE 
    UPDATETSDATE 
    ONBOARDING_DATEDATE 
    OFFBOARDING_DATEDATE 
    STATUSIDNUMBER 
    STATUSVARCHAR 
    NUMNUMBER 
    CPU_TOTAL_MHZNUMBER 
    CPU_NUMNUMBER 
    TOTAL_REAL_MEMNUMBER 
    DISK_SIZENUMBER 
    CONTAINERIDNUMBER 
    CONTAINERNAMEVARCHAR 
    RSVTYPEIDNUMBER 
    PROVISIONTSDATE 
    RSVCONTAINERIDNUMBERRSV_CONTAINER.SYSID
    RSVCONTAINERNAMEVARCHAR 
    CONTAINERPOOLIDNUMBER 
    CONTAINERNAMEVARCHAR 

    PV_RSV_ONBOARDING_SYS

    Associates, for each on-boarding event, all "templates" included into an onboarding

    Column Name

    Data Type

    Key column

    SYSIDNUMBERSYS_DEF.SYSID
    NAMEVARCHAR 
    DESCRIPTIONVARCHAR 
    SYSTYPEIDNUMBER 
    RSVONBOARDINGIDNUMBERRSV_ONBOARDING.RSVONBOARDINGID
    NUMNUMBER 
    CPU_TOTAL_MHZNUMBER 
    CPU_NUMNUMBER 
    TOTAL_REAL_MEMNUMBER 
    DISK_SIZENUMBER 
    OSVARCHAR 

    PV_RSV_RSVITEM

    Column Name

    Data Type

    RSVITEMIDNUMBER

    RSVITEMNAME

    VARCHAR
    TEMPLATEIDNUMBER
    SYSIDNUMBER
    TEMPLATENAMEVARCHAR
    SYSTYPEIDNUMBER
    SYSTYPEVARCHAR
    SERVICEIDNUMBER
    SERVICENAMEVARCHAR
    RSVIDNUMBER
    CONGTAINERIDNUMBER
    CONTAINERNAMEVARCHAR
    CONTAINERTYPEIDNUMBER
    VCPUNUMNUMBER
    CPUMHZNUMBER
    CPUMHZCAPACITYNUMBER
    CPUCORESNUMBER
    CPUENTCCAPACITYNUMBER
    LCPUCAPACITYNUMBER
    MEMORYNUMBER
    MEMCAPACITYNUMBER
    DISKNUMBER
    DISKCAPACITYNUMBER
    OSTYPEVARCHAR
    CONTAINERPOOLIDNUMBER
    CONTAINERPOOLNAMEVARCHAR
    SYSIDREALNUMBER
    SYSNAMEREALVARCHAR
    SYSTYPEIDREALNUMBER

    PV_RSV_RSVTEMPLATE

    Column Name

    Data Type

    STRUCTUREIDNUMBER

    XID

    NUMBER
    NAMEVARCHAR
    SYSTYPEIDNUMBER
    SYSTYPENUMBER
    RSVIDNUMBER
    NUMNUMBER
    CPUMHZNUMBER
    CPUCORESNUMBER
    VCPUNUMNUMBER
    MEMORYNUMBER
    DISKNUMBER
    CPUMHZCAPACITYNUMBER
    MEMCAPACITYNUMBER
    DISKCAPACITYNUMBER
    LCPUCAPACITYNUMBER
    CPUENTCCAPACITYNUMBER
    OSVARCHAR

    PV_RSV_SYS_TEMPLATE

    Column Name

    Data Type

    SYSIDNUMBER

    NAME

    VARCHAR
    SYSTYPEIDNUMBER
    SYSTYPEVARCHAR
    CPUMHZNUMBER
    CPUCORESNUMBER
    VCPUNUMNUMBER
    MEMORYNUMBER
    DISKNUMBER
    CPUMHZCAPACITYNUMBER
    MEMCAPACITYNUMBER
    DSKCPACITYNUMBER
    CPUENTCCAPACITYNUMBER
    LCPUCAPACITYNUMBER
    OSVARCHAR
    USED_INTO_RESERVATIONSVARCHAR

    PV_RSV_SERVICE_TEMPLATE

    Column Name

    Data Type

    SERVICEIDNUMBER

    NAME

    VARCHAR
    TYPEIDNUMBER
    TYPEVARCHAR
    CPUMHZNUMBER
    CPUCORESNUMBER
    VCPUNUMNUMBER
    MEMORYNUMBER
    DISKNUMBER
    CPUMHZCAPACITYNUMBER
    MEMCAPACITYNUMBER
    DSKCPACITYNUMBER
    CPUENTCCAPACITYNUMBER
    LCPUCAPACITYNUMBER
    OSVARCHAR
    USED_INTO_RESERVATIONSVARCHAR

    PV_RSV_COMPONENTS_CONTAINER

    For each reservation, reports all "reservation components" with required resources, involved container (according to reservation status) and its alert status (if any). (join between RSV_SYS_CONTAINER and RSV_APP(SYS)_DATA and RSV_CONTAINER)

    Column NameDescriptionKey column
    RSVID RSV_DEF.RSVID (FK)
    SYSID RSV_SYS.SYSID (FK)
    APPID RSV_APP.APPID (FK)
    INSTANCEID  
    NAMESYS_DEF.NAME 
    RSVNAMERSV_DEF.NAME 
    RSVCONTAINERIDcan be null(FK) RSV_CONTAINER.SYSID
    RSVCONTAINERNAMEcan be null 
    VCPU_NUM  
    CPU_MHZ  
    CPU_ENTITLEMENT  
    CPU_SPECINT  
    MEMORY  
    STORAGE  
    RSVALERTSTATUSIDalert status of containerRSV_ALERT_STATUS.RSVALERTSTATUSID
    RSVALERTTS  

    Indicator-related views

    PV_SYS_INDICATOR

    Column NameDescription
    SYSID 
    SYSMETRICID 
    NAME 
    DESCRIPTION 
    SYSTYPEID 
    SYSTYPE 
    INDICATORobjname
    INDICATORNAMEresource counter name
    SUBINDICATORNAMEsubobjname
    VALTYPEIDSee PV_CAT_VAL_TYPE.
    VALTYPE 
    LASTVALUEThe last value of the indicator. Should be returned by the function.

    Tag-related views

    PV_SYS_TAG

    Describes tags that are placed on TrueSight Capacity Optimization systems.

    Column NameDescription
    SYSIDThe id of the tagged system
    SYSNAMEThe name of the system
    SYSTYPEIDThe type of the system as id
    SYSTYPEThe type of the system
    TAGThe value of the tag
    TAGTYPEIDThe internal identifier of the tag type
    TAGTYPEThe type of the tag
    DESCRIPTIONThe description of the tag (if available)
    INSERTTSThe insert timestamp of the tag
    UPDATETSThe update timestamp of the tag

    PV_BDRV_TAG

    Describes tags that are placed on TrueSight Capacity Optimization business driver

    Column NameDescription
    BDRVIDThe id of the tagged business driver
    BDRVNAMEThe name of the business driver
    BDRVTYPEIDThe type of the business driver as id
    BDRVTYPEThe type of the business driver
    TAGThe value of the tag
    TAGTYPEIDThe internal identifier of the tag type
    TAGTYPEThe type of the tag
    DESCRIPTIONThe description of the tag (if available)
    INSERTTSThe insert timestamp of the tag
    UPDATETSThe update timestamp of the tag

    PV_APP_TAG

    Describes tags that are placed on TrueSight Capacity Optimization domain

    Column NameDescription
    APPIDThe id of the tagged domain
    APPNAMEThe name of the domain
    APPTYPEIDThe type of the domain as id
    APPTYPEThe type of the domain
    TAGThe value of the tag
    TAGTYPEIDThe internal identifier of the tag type
    TAGTYPEThe type of the tag
    DESCRIPTIONThe description of the tag (if available)
    INSERTTSThe insert timestamp of the tag
    UPDATETSThe update timestamp of the tag

    PV_REP_TAG

    Describes tags that are placed on TrueSight Capacity Optimization report

    Column NameDescription
    REPIDThe id of the tagged report
    REPNAMEThe name of the report
    REPTYPEThe type of the report
    TAGThe value of the tag
    TAGTYPEIDThe internal identifier of the tag type
    TAGTYPEThe type of the tag
    DESCRIPTIONThe description of the tag (if available)
    INSERTTSThe insert timestamp of the tag
    UPDATETSThe update timestamp of the tag

    PV_REP_RUN

    Column NameDescription
    REPIDThe id of the tagged report
    REPNAMEThe name of the report
    REPTYPEThe type of the report
    TAGThe value of the tag
    TAGTYPEIDThe internal identifier of the tag type
    TAGTYPEThe type of the tag
    DESCRIPTIONThe description of the tag (if available)
    INSERTTSThe insert timestamp of the tag
    UPDATETSThe update timestamp of the tag

    PV_REPORT

    Column NameDescription
    REPIDNUMBER
    INSERTTSDATE
    NAMEVARCHAR2(250 CHAR)
    DESCRIPTIONVARCHAR2(4000 CHAR)
    REPTEMPLIDNUMBER
    REPTEMPLVARCHAR2(250 CHAR)
    REPTYPEIDNUMBER
    REPTYPEVARCHAR2(50 CHAR)
    ACCOUNTIDNUMBER
    ACCOUNTVARCHAR2(50 CHAR)
    FOLDERIDNUMBER
    FOLDERVARCHAR2(250 CHAR)

    Related topics

    To view example queries developed using these public views, see Query Examples.

    To view Chargeback reports based on these Public Views, see Chargeback reports based on these Public Views.

    APPID    NUMBER
    WKLDID    NUMBER

     

    Column Name

    Data Type

    BDRVMETRICIDNUMBER
    TSDATE
    TZOFFSETNUMBER
    PCLASSIDNUMBER
    DCLASSIDNUMBER
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

     

     

    Column Name

    Data Type

    AUDITACTIONIDNUMBER
    NAMEVARCHAR2(50 CHAR)
    DESCRIPTIONVARCHAR2(250 CHAR)
    AUDITGROUPIDNUMBER
    GROUPNAMEVARCHAR2(50 CHAR)
    HCLASSIDNUMBER
    DURATIONNUMBER
    AVGVALUENUMBER
    MINVALUENUMBER
    MAXVALUENUMBER
    SUMVALUENUMBER
    SUMQUADVALUENUMBER
    CUMSUMVALUENUMBER
    WEIGHTNUMBER
    WAVGVALUENUMBER
    COUNTGOODNUMBER
    COUNTWARNNUMBER
    COUNTPOORNUMBER
    COUNTERRORNUMBER
    COUNTVALUENUMBER

    Public Function Package

    You can extract dynamic thresholds defined for an entity within a custom SQL data mart. To do this, use the PFUNC package. PFUNC is a public function package that stores all functions that retrieve thresholds from a custom SQL data mart.

    The following table lists all the functions available in PFUNC:

    Name

    Description

    Mandatory fields

    pf_threshold_get_by_object(p_structureid, p_metricid, p_appid, p_ts)

    Allow to retrieve threshold values by metric.

    Parameters:
    - <p_structureid>: Could be SYS, WKLD, APP
    - <p_metricid>: Is the identifier of metric that can be retrieved from PV_SYS_METRIC (sysmetricid) or PV_BDRV_METRIC (bdrvmetricid) or PV_APPL_METRIC (appmetricid)
    - <p_appid>: To filter threshold by a specific domain
    - <p_ts>: In case threshold has a configuration metricas limit, return the metric value at that date

    p_structureid, p_metricid

    pf_threshold_get_by_entity(p_structureid, p_id, p_metric, p_appid, p_ts)

    Allow to retrieve threshold values for a certain metric by entity

    Parameters:
    - <p_structureid>: could be SYS, WKLD, APP
    - <p_id>: is the identifier of system from PV_SYSTEM (sysid) or PV_BUSINESS_DRIVER (bdrvid) or PV_APPLICATION (appid)
    - <p_metric>: is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
    - <p_appid>: to filter threshold by a specific domain
    - <p_ts>: in case threshold has as limit a configuration metric, return metric value at that date

    p_structureid, p_id, p_metric

    pf_threshold_get_by_enttype(p_structureid, p_enttypeid, p_metric, p_appid)

    Allow to retrieve threshold values for a certain metric by entity type.

    Parameters:
    - <p_structureid>: Could be SYS, WKLD, APP
    - <p_enttypeid>: Type of entity, can be SYSTYPEID or BDRVTYPEID or APPLTYPEID depending on p_structureid. See also PV_CAT_SYS_TYPE, PV_CAT_APPL_TYPE and PV_CAT_BDRV_TYPE
    - <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
    - <p_appid>: To filter threshold by a specific domain

    p_structureid, p_enttypeid, p_metric

    pf_threshold_get_by_resource(p_metric, p_appid)

    Allow to retrieve threshold values by metric

    Parameters:
    - <p_metric>: Is the name of metric that can be retrieved from PV_SYS_METRIC or PV_BDRV_METRIC or PV_APPL_METRIC (metric)
    - <p_appid>: To filter threshold by a specific domain

    p_metric

    Related topics

    To view example queries developed using these public views, see Query Examples.

    To view Chargeback reports based on these Public Views, see Chargeback reports based on these Public Views.

    1 Comment

    1.