Results for “cs_csz_srch_criteria”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_CSZ_SRCH_CRITERIA is a Service (CS) module table in the Oracle E-Business Suite database, owned by the CS schema. It stores the individual search criteria that make up a Saved Search definition, supporting the Configurator/Service search infrastructure used to retrieve service-related records. Each row represents one criterion — an attribute, operator context, and data type — that participates in a saved search. The table is designated VALID and is present in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table carries its own surrogate primary key and descriptive attributes, while also holding a foreign key to a parent grouping table, which is characteristic of a satellite attached to a parent hub or grouping entity rather than a standalone hub.

Key Information Stored

The table contains 13 documented columns. The most significant include:

• CRITERIA_ID — the surrogate primary key, defined by the unique index CS_CSZ_SRCH_CRITERIA_PK and the unique constraint CS_CSZ_SRCH_CRITERIA_U1. It uniquely identifies each saved-search criterion row.
• CRITERIA_GROUP_ID — foreign key to CS_CSZ_SRCH_CRIT_GROUPS, associating the criterion with its parent criteria group within a saved search.
• ATTR_ID — identifier of the attribute the criterion filters on.
• ATTR_GROUP_ID — identifier of the attribute group to which the filtered attribute belongs.
• ATTR_TYPE — classification of the attribute (for example, field versus grouped attribute).
• DATA_TYPE — the data type of the criterion value, driving search operator behavior.
• DISPLAY_VALUE_FLAG — controls whether the criterion's value is presented in the saved search display.
• OBJECT_VERSION_NUMBER — the standard EBS optimistic locking column used by the framework for concurrent update control.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified the row and when.

The surrogate key (CRITERIA_ID) is distinct from business-key candidates; the only documented unique index is CS_CSZ_SRCH_CRITERIA_U1, also on CRITERIA_ID, so no separate natural-key column is documented.

Common Use Cases and Queries

Typical use cases include auditing saved searches, reporting on configured search criteria, and troubleshooting why a saved search returns unexpected results. A common diagnostic query joins criteria to their parent groups:

• Router criteria: SELECT c.criteria_id, c.attr_id, c.attr_type, c.data_type, c.display_value_flag FROM cs_csz_srch_criteria c WHERE c.criteria_group_id = :group_id;
• Value lookup through the child table: SELECT v.* FROM cs_csz_srch_crit_values v WHERE v.criteria_id = :criteria_id;
• Audit reporting on creation/update metadata using CREATED_BY and LAST_UPDATED_BY.

Reporting use cases include documenting the criteria definitions behind each saved search and validating that criteria and their values remain referentially consistent across upgrades.

Related Objects

• CS_CSZ_SRCH_CRIT_GROUPS — parent table; joined via CS_CSZ_SRCH_CRITERIA.CRITERIA_GROUP_ID = CS_CSZ_SRCH_CRIT_GROUPS.CRITERIA_GROUP_ID.
• CS_CSZ_SRCH_CRIT_VALUES — child table holding the criteria values; joined via CS_CSZ_SRCH_CRIT_VALUES.CRITERIA_ID = CS_CSZ_SRCH_CRITERIA.CRITERIA_ID.
• CS_CSZ_SRCH_CRITERIA_PK — primary key constraint.
• CS_CSZ_SRCH_CRITERIA_U1 — unique index backing the primary key on CRITERIA_ID.