BEGIN_TIME_STAMP_
UTC

date

Time stamp of the record, shifted to UTC.

BEGIN_TIME_STAMP

date

Time stamp of the record.

END_TIME_STAMP_UTC

date

End time stamp of the record, shifted to UTC.

END_TIME_STAMP

date

End 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 cancelled 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

INTERVAL_LENGTH

number

Number of TIME_UNITs in the calculated period.

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.

EXCEPTION

number(1)

One of the following:

• 0 - The calculated period did not include any Exceptions.
• 1 - The calculated period included an Exception.

For 1 there can be multiple Exceptions.

CORRECTION

number(1)

One of the following:

• 0 - The calculated period did not include any Corrections.
• 1 - The calculated period included a Correction.

For 1 there can be multiple Corrections.

PROVIDED

number(15,5)

Service Level value, calculated without Corrections or Exceptions.

PROVIDED_C

number(15,5)

Service Level value, calculated with Corrections and without Exceptions.

PROVIDED_E

number(15,5)

Service Level value, calculated without Corrections and with Exceptions.

PROVIDED_CE

number(15,5)

Service Level value, calculated with Corrections and Exceptions.

DEVIATION

number(15,5)

Calculated deviation of the Service Level from the Target, calculated without Corrections or Exceptions.

DEVIATION_C

number(15,5)

Calculated deviation of the Service Level from the Target, calculated with Corrections and without Exceptions.

DEVIATION_E

number(15,5)

Calculated deviation of the Service Level from the Target, calculated without Corrections and with Exceptions.

DEVIATION_CE

number(15,5)

Calculated deviation of the Service Level from the Target, calculated with Corrections and Exceptions.

TIME_UNIT_ORDER

number

One of the following:

• 3 - HOUR
• 4 - DAY
• 5 - WEEK
• 6 - MONTH
• 7 - QUARTER
• 8 - YEAR

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.

GLOBAL_COMPOUND_
TIMESLOT_ID

number

Foreign Key to T_GLOBAL_COMPOUND_TIMESLOTS.

PSL_CREATE_DATE

date

Creation date of the record.

PSL_MODIFY_DATE

date

Modification date of the record.

SERVICE_LEVEL_
TARGET

number(15,5)

The Target, in the calculation without Corrections or Exceptions.

SERVICE_LEVEL_
TARGET_C

number(15,5)

The Target, in the calculation with Corrections and without Exceptions.

SERVICE_LEVEL_
TARGET_E

number(15,5)

The Target, in the calculation without Corrections and with Exceptions.

SERVICE_LEVEL_
TARGET_CE

number(15,5)

The Target, in the calculation with Corrections and Exceptions.

FORECAST

number(15,5)

Calculated Forecast.

METRIC_TYPE_ID

number(10)

Foreign Key to T_METRIC_TYPES.

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.