Search Results range_low_value

Overview

CSC_PROF_CHECK_RATINGS is a Customer Care (CSC) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the rating and color information associated with customer profile checks. In the CSC schema, a profile check represents a scored verification or assessment applied against a customer, and this table persists the individual rating tiers used by that check. Each row ties a rating grade to a numeric range and to a color code, allowing the application to translate a computed score into a human-readable rating and a visual indicator.

From a modeling perspective, the mined foreign-key structure suggests a link classification under Data Vault heuristics: the table sits between a parent check definition (CSC_PROF_CHECKS_B) and reference classification data (CSC_COLOR_CODES), resolving many-to-many style associations through a dedicated key. This is a suggestion rather than a documented fact, but it accurately reflects the table's role as a junction between check definitions and rating/color reference values.

Key Information Stored

The table contains 20 documented columns. The most significant are:

• CHECK_RATING_ID — the surrogate primary key, enforced by CSC_PROF_CHECK_RATINGS_PK. It uniquely identifies each rating row.
• CHECK_ID — foreign key to CSC_PROF_CHECKS_B, identifying the parent profile check to which the rating belongs.
• CHECK_RATING_GRADE — the ordinal or named grade assigned to the rating tier.
• RATING_CODE — foreign key to CSC_COLOR_CODES, linking the rating to a defined rating code.
• COLOR_CODE — foreign key to CSC_COLOR_CODES, determining the display color associated with the rating.
• RANGE_LOW_VALUE and RANGE_HIGH_VALUE — the numeric bounds that define the score interval mapped to this rating.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org / data-security filtering.
• SEEDED_FLAG — indicates whether the row was delivered as seed data by Oracle.
• ZD_EDITION_NAME — editioning column introduced for EBS 12.2 online patching; it participates in the unique index CSC_PROF_CHECK_RATINGS_U1.
• Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

The unique index CSC_PROF_CHECK_RATINGS_U1 on (CHECK_RATING_ID, ZD_EDITION_NAME) is the documented business-key candidate, with CHECK_RATING_ID serving as the substantive unique identifier and ZD_EDITION_NAME enabling edition-aware uniqueness in 12.2.

Common Use Cases and Queries

Typical usage involves retrieving the rating and color for a given check, or resolving which rating tier a computed score falls into. A representative query joining the rating tiers to their parent check follows:

SELECT r.CHECK_RATING_ID,
       r.CHECK_ID,
       r.CHECK_RATING_GRADE,
       r.RANGE_LOW_VALUE,
       r.RANGE_HIGH_VALUE,
       r.RATING_CODE,
       r.COLOR_CODE
FROM   CSC.CSC_PROF_CHECK_RATINGS r
WHERE  r.CHECK_ID = :check_id
ORDER  BY r.RANGE_LOW_VALUE;

To resolve a score to its rating, the score is compared against the range columns:

SELECT r.CHECK_RATING_GRADE, r.COLOR_CODE
FROM   CSC.CSC_PROF_CHECK_RATINGS r
WHERE  r.CHECK_ID = :check_id
AND    :score BETWEEN r.RANGE_LOW_VALUE AND r.RANGE_HIGH_VALUE;

Reporting use cases include generating rating-distribution reports, validating that rating ranges do not overlap or leave gaps, and auditing seed versus user-defined ratings via SEEDED_FLAG. In 12.2 environments, queries and DML should account for ZD_EDITION_NAME to respect online patching editioning.

Related Objects

• CSC_PROF_CHECKS_B — parent table; joined on CSC_PROF_CHECK_RATINGS.CHECK_ID = CSC_PROF_CHECKS_B.CHECK_ID.
• CSC_COLOR_CODES — reference table; joined on RATING_CODE and again on COLOR_CODE to resolve rating and color definitions.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for data-security filtering.
• CSC_PROF_CHECK_RATINGS_PK / CSC_PROF_CHECK_RATINGS_U1 — the primary key constraint and unique index governing row identity.
• CSC_PROF_CHECKS_TL and related CSC profile-check views and APIs, which expose check definitions that consume these rating tiers.

The table therefore functions as the scoring-to-presentation bridge within the CSC profile-check subsystem, underpinning both transactional scoring and analytic reporting.