Search Results cs_counter_der_filters_pk

Overview

The CS_COUNTER_DER_FILTERS table is a core data object within the Oracle E-Business Suite Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It is designed to store filter conditions that govern group operations on counters. In the context of service management, counters are used to track measurable usage or consumption of a serviceable item. This table enables the definition of precise criteria to select specific counters or counter readings when performing bulk or derived operations, such as generating aggregated readings or applying formulas across a defined set of counter data. Its role is essential for automating and managing complex service counter logic within the application.

Key Information Stored

The table's primary purpose is to define filter conditions. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its critical structure. The primary key, COUNTER_DER_FILTER_ID, uniquely identifies each filter condition record. The COUNTER_ID column is a foreign key to the CS_COUNTERS table, linking the filter to a specific counter. The COUNTER_PROPERTY_ID column is a foreign key to the CS_COUNTER_PROPERTIES table, indicating that filters are often based on specific properties or attributes of a counter. Additional columns, not explicitly listed, would logically store the filter's operator (e.g., equals, greater than) and the filter value or threshold against which the counter property is evaluated.

Common Use Cases and Queries

A primary use case is the configuration of rules for deriving new counter readings from a group of existing counters. For instance, a filter could be set to select only counters where the COUNTER_PROPERTY 'Status' equals 'Active' for a group read or reset operation. Administrators may query this table to audit or troubleshoot counter derivation rules. A typical reporting query would join CS_COUNTER_DER_FILTERS to CS_COUNTERS and CS_COUNTER_PROPERTIES to list all active filter conditions:

• SELECT cnt.counter_name, cp.property_code, cdf.filter_operator, cdf.filter_value FROM cs_counter_der_filters cdf, cs_counters cnt, cs_counter_properties cp WHERE cdf.counter_id = cnt.counter_id AND cdf.counter_property_id = cp.counter_property_id;

Data maintenance scripts might target this table when migrating or archiving counter data associated with decommissioned service items.

Related Objects

The table is centrally connected to other core Service tables via documented foreign key relationships:

• CS_COUNTERS: The primary parent table. The CS_COUNTER_DER_FILTERS.COUNTER_ID column references CS_COUNTERS, establishing the counter to which the filter condition applies.
• CS_COUNTER_PROPERTIES: A key reference table. The CS_COUNTER_DER_FILTERS.COUNTER_PROPERTY_ID column references CS_COUNTER_PROPERTIES, defining which counter attribute (e.g., reading type, unit of measure) is used in the filter condition.
• CS_COUNTER_DER_FILTERS_PK: The primary key constraint on the COUNTER_DER_FILTER_ID column, ensuring the uniqueness of each filter record.

This table likely feeds or is referenced by various service counter processing engines and APIs within the CS module, particularly those handling counter group derivations.