Results for “value_num_min”

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

Overview

GMD_TEST_VALUES_B is a base table in the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite, available in release 12.1.1 and 12.2.2. It stores the quality assay test value definitions that drive product development, specification, and quality control processing. Each row represents a permissible or expected value for a given assay test, including numeric tolerance boundaries expressed through VALUE_NUM_MIN and VALUE_NUM_MAX, the two columns most frequently referenced by users searching for range-based test configuration. The table functions as a definition repository: values recorded here are consumed by the quality specification engine when validating batch results, calculating specification conformance, and generating certificates of analysis.

The heuristic Data Vault classification mined from the foreign-key topology identifies this object as a link table. It resolves associations between assay types defined in GMD_TESTS_B and descriptive text references held in QC_TEXT_HDR, with the assay value identifier acting as the principal key. Modelers should treat this as a connected relationship entity rather than an independent hub.

Key Information Stored

The primary key is GMD_TEST_VALUES_B_PK, defined on QCASSY_VAL_ID, a system-generated surrogate identifier. A secondary unique index, GMD_TEST_VALUES_B_U1, covers ORGN_CODE, ASSAY_CODE, and ASSAY_VALUE, making this triple the natural business-key candidate for cross-organization uniqueness.

• QCASSY_VAL_ID — surrogate primary key identifying each test value record.
• QCASSY_TYP_ID — foreign key to GMD_TESTS_B; ties the value to its parent assay test.
• ORGN_CODE — organization code, supporting multi-org partitioning of value definitions.
• ASSAY_CODE / ASSAY_VALUE — the assay identifier and the discrete value or code being defined.
• VALUE_NUM_MIN / VALUE_NUM_MAX — numeric lower and upper tolerance bounds for range-based specifications.
• VALUE_NUM_LABEL — display label presented for the numeric value in specification and result views.
• ASSAY_VALUE_RANGE_ORDER — sequencing attribute controlling the order in which range bands are evaluated.
• VALUE_DESC — descriptive text for the assay value.
• TEXT_CODE — foreign key to QC_TEXT_HDR for long-form descriptive content.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–30 — the standard EBS descriptive flexfield segment block.
• MIGRATION_STATUS — flags records affected by data migration routines.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — audit trail.

Common Use Cases and Queries

Quality analysts and implementation consultants use this table to review and maintain specification tolerance bands. A typical query retrieves all value ranges for a given assay test and organization:

SELECT v.assay_code, v.assay_value, v.value_num_min, v.value_num_max, v.value_num_label FROM gmd_test_values_b v WHERE v.assay_code = :assay_code AND v.orgn_code = :orgn_code ORDER BY v.assay_value_range_order;

Reporting scenarios include identifying assays with overlapping numeric ranges (a configuration integrity check), listing tests that lack any numeric boundaries, and extracting specification limits for certificate-of-analysis templates. Integration developers join this table to GMD_TESTS_B when building inbound interfaces that load laboratory results, and to QC_TEXT_HDR when long descriptions must accompany the numeric limits. Data migration teams monitor MIGRATION_STATUS to confirm that legacy specification values were converted correctly.

Related Objects

• GMD_TESTS_B — parent assay test definition; joined on GMD_TEST_VALUES_B.QCASSY_TYP_ID = GMD_TESTS_B.QCASSY_TYP_ID.
• QC_TEXT_HDR — text header repository; joined on GMD_TEST_VALUES_B.TEXT_CODE = QC_TEXT_HDR.TEXT_CODE.
• GMD_SPEC_VALUES / specification value tables — consumer of these definitions during specification compilation.
• GMD_QC_RESULTS — stores measured laboratory results validated against the ranges defined here.
• GMD_SAMPLE_SPECS — sample specification headers that reference assay value definitions.
• QC_TEXT_TL — translation table supplying language-specific text for TEXT_CODE lookups.