Results for “select_block_id”

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

Overview

CSC_PROF_CHECKS_B is the base (non-translated) definition table for profile checks within the CSC – Customer Care module of Oracle E-Business Suite, applicable to both 12.1.1 and 12.2.2. A profile check represents a discrete validation or assessment performed against a customer or account profile, and this table stores the check's identity, activation window, data type, formatting rules, threshold values, and selection logic. Records here are the master definitions that downstream entities — ratings, results, rules, groupings, and plan associations — reference via the CHECK_ID foreign key.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying CSC_PROF_CHECKS_B as a hub. The table centers on a stable business key (CHECK_ID) with relatively few outbound dependencies, while numerous child tables hang off it as satellites and links. This classification is heuristic and offered as a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

The table carries 28 documented columns. The most significant are summarized below.

• CHECK_ID — the surrogate primary key, enforced by CSC_PROF_CHECKS_B_PK. It is the anchor referenced by every dependent table.
• CHECK_NAME_CODE — the human-readable check identifier; the business-key candidate along with CHECK_ID.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective-dating window that controls when a check is active.
• SELECT_TYPE and SELECT_BLOCK_ID — define the scope of data the check evaluates. SELECT_BLOCK_ID points to CSC_PROF_BLOCKS_B.
• DATA_TYPE and FORMAT_MASK — govern the expected input type and presentation format for check responses.
• THRESHOLD_GRADE, THRESHOLD_RATING_CODE, THRESHOLD_COLOR_CODE — threshold values used to grade, rate, or color-code outcomes.
• CHECK_UPPER_LOWER_FLAG — indicates sensitivity to case when evaluating textual responses.
• CHECK_LEVEL and SEEDED_FLAG — denote the check's hierarchical level and whether it was seeded (predefined) by Oracle.
• SECURITY_GROUP_ID — links the record to an FND_SECURITY_GROUPS entry for access control.
• ORIG_SYSTEM_REFERENCE / ORIG_SYSTEM_REFERENCE_ID and APPLICATION_ID — provenance and application ownership metadata.
• ZD_EDITION_NAME — editioning column supporting Online Patching in 12.2.x, appearing in both unique indexes.

Two unique indexes act as business-key candidates: CSC_PROF_CHECKS_B_U1 (CHECK_ID, ZD_EDITION_NAME) and CSC_PROF_CHECKS_B_U2 (CHECK_NAME_CODE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical reporting scenarios involve enumerating active checks, auditing thresholds, and reporting results by check. A common pattern lists active, non-seeded checks:

SELECT c.check_name_code, c.data_type, c.threshold_grade
FROM   csc.csc_prof_checks_b c
WHERE  c.seeded_flag = 'N'
AND    SYSDATE BETWEEN NVL(c.start_date_active, SYSDATE)
                   AND NVL(c.end_date_active, SYSDATE);

Joining to the translation table produces multilingual reporting:

SELECT b.check_id, t.check_name, b.threshold_rating_code
FROM   csc.csc_prof_checks_b  b,
       csc.csc_prof_checks_tl t
WHERE  b.check_id = t.check_id
AND    t.language = USERENV('LANG');

Analysts frequently join to CSC_PROF_CHECK_RESULTS to aggregate outcomes per check, or to CSC_PROF_GROUP_CHECKS to report which checks belong to each group used during assessment.

Related Objects

The following objects are the most significant dependents and references, linked through documented foreign keys.

• CSC_PROF_CHECKS_TL — translated check names/descriptions, joined on CHECK_ID.
• CSC_PROF_BLOCKS_B — source of SELECT_BLOCK_ID, defining the data block a check targets.
• CSC_PROF_CHECK_RULES_B — validation rules keyed to CHECK_ID.
• CSC_PROF_CHECK_RATINGS — rating definitions per check.
• CSC_PROF_CHECK_RESULTS — captured results for each check.
• CSC_PROF_GROUP_CHECKS — associates checks with profile groups.
• CSC_PLAN_HEADERS_B — references checks via PROFILE_CHECK_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for access control.