Results for “range_min”

32 results




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

Overview

GR_PROPERTIES_B is a base table owned by the GR schema within Oracle E-Business Suite, belonging to the Process Manufacturing Regulatory Management (GR) product family. It stores the definition of property codes and their associated indicators that describe the label attributes used in regulatory and label management processes. In practical terms, a single label can carry several property codes, and this table holds the master definition of each of those properties. The table forms part of the core metadata layer that governs how label content is structured, validated, and rendered across the Process Manufacturing regulatory environment.

From a Data Vault modeling perspective, the heuristic classification of GR_PROPERTIES_B is hub-leaning. This suggests the table behaves as a hub-like entity: it anchors a stable business concept (the property) identified by a single surrogate key, and it is referenced by multiple dependent tables rather than itself depending on many parents. Any downstream modeling exercise could treat PROPERTY_ID as the hub key and place descriptive or translated attributes in companion satellite or link structures.

Key Information Stored

The table comprises 11 documented columns. The central identifier is PROPERTY_ID, a surrogate primary key enforced through the unique index GR_PROPERTIES_B_PK. Because this is the only documented unique index, PROPERTY_ID is the sole business-key candidate available in the metadata; no separate natural business key is exposed.

The remaining columns capture the behavioral and structural characteristics of each property:

  • PROPERTY_ID — Primary key (GR_PROPERTIES_PK). Unique surrogate identifier for each property record.
  • PROPERTY_TYPE_INDICATOR — Indicator describing the type or classification of the property, distinguishing how the property behaves on a label.
  • LENGTH — Defines the permitted length for the property value, supporting validation and formatting rules.
  • PRECISION — Specifies numeric precision where the property is of a numeric nature.
  • RANGE_MIN — Lower bound of an allowed value range for the property.
  • RANGE_MAX — Upper bound of an allowed value range for the property.
  • CREATED_BY, CREATION_DATE — Standard EBS audit columns recording who created the record and when.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE — Audit columns capturing the most recent modification and its author.
  • LAST_UPDATE_LOGIN — Login audit identifier associated with the last update, used for tracking sessions.

The combination of PROPERTY_TYPE_INDICATOR, LENGTH, PRECISION, RANGE_MIN, and RANGE_MAX effectively defines the validation contract for each property, while the audit columns provide the standard Oracle EBS change-tracking envelope.

Common Use Cases and Queries

Typical usage centers on retrieving property definitions to drive label attribute configuration and validation. A common reporting pattern joins the base table to its translation and value tables to present a fully described property. For example, retrieving all defined properties with their type and range constraints:

  • SELECT PROPERTY_ID, PROPERTY_TYPE_INDICATOR, LENGTH, PRECISION, RANGE_MIN, RANGE_MAX FROM GR.PROPERTIES_B;
  • Joining to translated descriptions via GR_PROPERTIES_TL.PROPERTY_ID = GR_PROPERTIES_B.PROPERTY_ID to resolve language-specific names.
  • Joining to GR_LABEL_PROPERTIES.PROPERTY_ID to determine which labels use a given property.
  • Joining to GR_PROPERTY_VALUES_TL.PROPERTY_ID to enumerate permitted or translated values for a property.
  • Auditing recent changes using LAST_UPDATED_BY and LAST_UPDATE_DATE filters.

Analysts commonly query this table to audit the completeness of label property definitions, to identify properties without translation rows, or to validate that range and precision settings conform to regulatory requirements before label publication.

Related Objects

GR_PROPERTIES_B is referenced by several dependent objects through the PROPERTY_ID column, confirming its hub-like role:

  • GR_LABEL_PROPERTIES — references GR_PROPERTIES_B via GR_LABEL_PROPERTIES.PROPERTY_ID. Associates properties with specific labels.
  • GR_PROPERTIES_TL — references GR_PROPERTIES_B via GR_PROPERTIES_TL.PROPERTY_ID. Holds translated property descriptions.
  • GR_PROPERTY_VALUES_TL — references GR_PROPERTIES_B via GR_PROPERTY_VALUES_TL.PROPERTY_ID. Stores translated permitted values tied to each property.

Together these three tables form the immediate dependency circle around GR_PROPERTIES_B, supplying labels, translations, and values that complete the property definition within Process Manufacturing Regulatory Management.