Results for “hazard_classification_code”

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

Overview

GR_ITEM_CLASSNS is a table in the GR schema (Process Manufacturing Regulatory Management) that holds the classification codes assigned to items for regulatory and hazard-management purposes. It functions as a bridge table, mapping an inventory item, identified by ITEM_CODE, to a specific hazard classification, identified by HAZARD_CLASSIFICATION_CODE. This design reflects Regulated/Process Manufacturing's model for associating items with European hazard classification schemes maintained in GR_EUROHAZARDS_B, ensuring that regulatory obligations such as labeling, documentation, and reporting are consistently applied wherever the item appears.

The ETRM documentation identifies this object as VALID in Oracle EBS 12.1.1 and 12.2.2. Applying a heuristic Data Vault classification, GR_ITEM_CLASSNS is best understood as a link table: it connects two business entities (items and hazard classifications) through a composite business key, and carries only non-identifying metadata (audit columns) that would conventionally be modeled as a satellite.

Key Information Stored

The table exposes seven documented columns in the 12.2.2 physical schema, of which the most significant are the following:

• ITEM_CODE — the item identifier participating in the classification. This is the first component of the composite primary key GR_ITEM_CLASSNS_PK and is also a foreign key to GR_EMEA.
• HAZARD_CLASSIFICATION_CODE — the code of the assigned hazard classification. It is the second component of the composite primary key and a foreign key to GR_EUROHAZARDS_B, where the actual classification details (name, description, regulatory attributes) reside.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns that capture who created and last modified each row, providing traceability of classification changes over time.

There is no standalone surrogate ID column; the primary key GR_ITEM_CLASSNS_PK is a composite business key (ITEM_CODE, HAZARD_CLASSIFICATION_CODE), which also functions as the unique index / business-key candidate. This is the only unique index documented on the table.

Common Use Cases and Queries

Because GR_ITEM_CLASSNS records the regulatory classification of items, it is queried primarily in hazard-determination, labeling, MSDS/safety documentation, and EMEA regulatory reporting workflows. Common patterns include:

• Retrieving all hazard classifications for a given item:
  SELECT h.hazard_classification_code, h.description FROM gr.gr_item_classns c, gr.gr_eurohazards_b h WHERE c.hazard_classification_code = h.hazard_classification_code AND c.item_code = :item_code;
• Identifying all items that carry a specific classification:
  SELECT c.item_code FROM gr.gr_item_classns c WHERE c.hazard_classification_code = :hazard_code;
• Audit and change tracking for regulatory review, filtering on LAST_UPDATE_DATE or CREATED_BY.
• Feeding exception reports that flag items lacking a hazard classification (anti-join from GR_EMEA to GR_ITEM_CLASSNS).

Related Objects

The following objects are directly implicated by the documented relationships of GR_ITEM_CLASSNS:

• GR_EUROHAZARDS_B — referenced via GR_ITEM_CLASSNS.HAZARD_CLASSIFICATION_CODE. This base table supplies the classification definitions, descriptions, and regulatory attributes attached to each code.
• GR_EMEA — referenced via GR_ITEM_CLASSNS.ITEM_CODE. This table provides the item-level master information against which classifications are applied.
• GR_ITEM_CLASSNS_PK — the composite primary key index (ITEM_CODE, HAZARD_CLASSIFICATION_CODE), also usable as the unique index for lookups.

Applications and forms in the Process Manufacturing Regulatory Management module that maintain item hazard classifications typically operate on this table, with GR_EUROHAZARDS_B and GR_EMEA as their primary lookup sources. Any program that reports item-level regulatory compliance must traverse GR_ITEM_CLASSNS to resolve which hazard codes apply to an item.