The following table describes the fields in V_PSL. This is the same for all seven views.
|
Name |
Type |
Content |
|---|---|---|
|
BEGIN_TIME_STAMP_ |
date |
Time stamp of the record, shifted to UTC. |
|
BEGIN_TIME_STAMP |
date |
Time stamp of the record. |
|
SLA_ID |
number |
Foreign Key to T_SLAS. |
|
GLOBAL_RULE_ID |
number |
Foreign Key to T_GLOBAL_RULES. |
|
RULE_ID |
number |
Foreign Key to T_RULES. |
|
PSL_RULE_ID |
number |
Foreign Key to T_RULES. It points to an identical canceled rule actually used to perform the calculation. |
|
FORMULA_ID |
number |
Foreign Key to T_FORMULAS It points to the formula used by the rule that performs the calculations for this PSL entry. |
|
TIME_UNIT |
varchar2(30) |
One of the following strings: HOUR, DAY, WEEK, MONTH, QUARTER or YEAR |
|
IS_PERIOD |
number |
Refers to the sending Metric:
|
|
DOMAIN_CATEGORY_ID |
number |
Foreign Key to T_DOMAIN_CATEGORIES. |
|
SERVICE_DOMAIN_ID |
number |
Foreign Key to T_SERVICE_DOMAINS. |
|
APPLICATION_ID |
number |
Foreign Key to T_APPLICATIONS. |
|
CUSTOMER_ID |
number |
Foreign Key to T_CUSTOMERS. |
|
PROVIDED_CE |
number(15,5) |
The Service Level value. |
|
DEVIATION_CE |
number(15,5) |
Calculated deviation of the Service Level from the Target. |
|
CLUSTER_ID |
number |
ID of Cluster Base Resource Group. |
|
CLUSTER_ITEM_ID |
number |
ID of Cluster Resource. |
|
SERVICE_LEVEL_ |
number(15,5) |
The Target. |
|
FORECAST |
number(15,5) |
Calculated Forecast. |
|
METRIC_TYPE_ID |
number(10) |
Foreign Key to T_SLAS. |
|
COMPLETE_RECORD |
number(1) |
One of the following:
|
The following chart shows the tables and fields used by V_PSL, and the relationships between the tables.

|
Copyright © 2013 CA.
All rights reserved.
|
|