Previous Topic: Service Level InterfaceNext Topic: V_PSL_EXTENDED


V_PSL

The following table describes the fields in V_PSL. This is the same for all seven views.

Name

Type

Content

BEGIN_TIME_STAMP_
UTC

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:

  • 0 - An operational calculation.
  • 1 - Business calculation according to tracking period defined in the contract.

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.
0 if metric is not clustered.
Foreign Key to T_RESOURCES.

CLUSTER_ITEM_ID

number

ID of Cluster Resource.
0 if metric is not clustered.
Foreign Key to T_RESOURCES.

SERVICE_LEVEL_
TARGET_CE

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:

  • 0 - An ongoing calculation in the middle of the period.
  • 1 - Calculation of a period that was completed.

The following chart shows the tables and fields used by V_PSL, and the relationships between the tables.