Search Results gmd_qc_test_values_b




Overview
Explore in AI Chat

Overview

GMD_QC_TEST_VALUES_B is a base table in the GMD schema (Process Manufacturing Product Development) that stores the individual value definitions associated with quality control tests in Oracle Process Manufacturing. In ETRM 12.1.1 and 12.2.2, it holds the discrete, permissible, or expected test values that qualify a parent QC test — for example the numeric bounds, textual codes, expression references, and free-text ranges that describe what result a given quality test may return. The table functions as the detail-level counterpart to the QC test header: a single TEST_ID drives one or more TEST_VALUE_ID records that articulate the accepted value set, tolerance band, or enumeration for that test.

The documented physical schema exposes 44 columns, two unique indexes, and is classified as VALID in the GMD schema on the ETRM 12.2.2 reference. Its mined Data Vault classification is standalone, meaning no foreign-key relationships were detected; from a dimensional modeling perspective, this suggests the table is best treated as a self-contained satellite/detail entity keyed by its own surrogate, rather than as a hub or link participating in an explicit relational web.

Key Information Stored

TEST_VALUE_ID is the surrogate primary key, enforced by GMD_QC_TEST_VALUES_B_PK, and uniquely identifies each value row. The business-key candidate is captured by the composite unique index GMD_QC_TEST_VALUES_B_U1 on (TEST_ID, TEST_VALUE_ID), which ties each value back to its owning QC test. The most operationally significant data columns are:

  • TEST_ID — the parent QC test to which the value belongs; the principal join key to the test definition.
  • TEST_VALUE_ID — surrogate identifier of the value row.
  • MIN_NUM / MAX_NUM — numeric lower and upper bounds defining an acceptable or expected numeric range.
  • VALUE_CHAR — the character/text representation of the value, used when the test result is alphanumeric.
  • TEXT_RANGE_SEQ — sequence used to order text-range entries within a test.
  • EXPRESSION_REF_TEST_ID — reference to a test used within an expression-based value definition.
  • TEXT_CODE — coded text value associated with the row.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard Oracle EBS descriptive flexfield (DFF) segment columns for user-defined extensions.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO (audit) columns tracking record creation and modification.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all value definitions for a test, finding tests with numeric tolerances, and validating completeness of value sets ahead of QC data entry. A representative query joining values to their parent test is:

  • SELECT v.TEST_ID, v.TEST_VALUE_ID, v.MIN_NUM, v.MAX_NUM, v.VALUE_CHAR FROM GMD.GMD_QC_TEST_VALUES_B v WHERE v.TEST_ID = :p_test_id ORDER BY v.TEXT_RANGE_SEQ;
  • Enumerating numeric-bound tests: WHERE MIN_NUM IS NOT NULL OR MAX_NUM IS NOT NULL.
  • DFF extraction: selecting ATTRIBUTE_CATEGORY and populated ATTRIBUTE1–ATTRIBUTE30 for interface or migration reporting.
  • Audit queries filtering on LAST_UPDATE_DATE for change tracking since a given date.

Related Objects

  • GMD_QC_TESTS_B — parent test definition, joined on TEST_ID.
  • GMD_QC_TEST_RESULTS — captured QC results validated against these value definitions.
  • GMD_QC_SPECIFICATIONS — specifications that reference tests whose values are defined here.
  • GMD_QC_TEST_VALUES_TL — translation table for descriptive text of test values where present.
  • GMD_QC_TEST_VALUES_B (self-reference) — EXPRESSION_REF_TEST_ID may point back to a related test/test value, supporting expression-based definitions.
  • OPM QC public APIs / concurrent programs (e.g., QC test value maintenance and migration interfaces) that read and write these rows.