V_BREACH_ROOT

This view exposes all Breach Root Cause records written by business logic or manually by users.

The following table describes the fields in V_BREACH_ROOT_CAUSE.

Name	Type	Content
RECORD_KEY	varchar2(50)	Unique identifier of the record.
RECORD_TIME_STAMP	date	Time stamp of the record (UTC time).
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.
DESCRIPTION	varchar2(512)	Description written by the logic/user.