Previous Topic: Additional Calculated Data InterfaceNext Topic: V_SO_<tablename>


V_SLALOM_OUTPUTS

This view exposes all SLALOM OUTPUT records written by business logic.

The following table describes the fields in V_SLALOM_OUTPUTS.

Name

Type

Content

RECORD_KEY

varchar2(50)

Unique identifier of the record.

RECORD_TIME_STAMP

date

Time stamp of the record (UTC time).

TABLE_NAME

varchar2(30)

Name of the logical table that the record belongs to.

RULE_ID

number

Foreign Key to T_RULES.

CLUSTER_ITEM_ID

number

Foreign Key to T_RESOURCES.
If the Metric that created the record is clustered, this field contains the ID of the Cluster Resource.

IS_PERIOD

number(1)

Refers to the sending Metric:

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

COMPLETE_PERIOD

number(1)

Refers to the sending Metric:

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

CREATE_DATE

date

Creation date of the record.

MODIFY_DATE

date

Modification date of the record.

RESOURCE_ID

number

Foreign Key to T_RESOURCES.

RESOURCE_NAME

varchar2(100)

Name of the Resource.

VAL_1

varchar2(512)

Value of field #1 of the record.

VAL_2

varchar2(50)

Value of field #2 of the record.

VAL_X

varchar2(50)

Value of field #x of the record.