Search Results gr_hazard_groups_pk




Overview
Explore in AI Chat

Overview

The GR_HAZARD_GROUPS table is a core reference data object within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It serves as the master repository for defined hazard group classifications, which are critical for regulatory compliance and safety reporting in process manufacturing industries, such as chemicals, pharmaceuticals, and food. The table's primary role is to establish and maintain a standardized, controlled list of hazard group codes and their descriptions, enabling consistent classification of substances and materials across the enterprise. This foundational data is essential for generating safety data sheets (SDS), labeling, and adhering to regional regulatory frameworks like the European CLP (Classification, Labelling and Packaging) regulation.

Key Information Stored

The table's structure is designed for efficient storage and retrieval of hazard group master data. Its primary key is the HAZARD_GROUP_CODE, which is a unique identifier for each hazard classification. The associated description column provides the full textual definition or name of the hazard group. While the provided metadata specifies the primary key column, typical implementations in regulatory management would also include standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditability, and potentially columns for enabling or disabling the code for future transactions.

Common Use Cases and Queries

This table is predominantly used in master data setup, regulatory reporting, and as a validation source for transactional data entry. A common operational use case is populating a list of values (LOV) in forms where users assign hazard groups to specific substances or products. For reporting, it is frequently joined to detail tables to generate comprehensible compliance documents. Key SQL patterns include retrieving the full list of active hazard groups for maintenance or selecting specific hazard data for a material.

  • Basic Lookup: SELECT hazard_group_code, description FROM gr.gr_hazard_groups ORDER BY hazard_group_code;
  • Join for Reporting: Queries often join GR_HAZARD_GROUPS to detail tables like GR_EUROHAZARDS_B to translate codes into descriptions for reports and safety data sheets.

Related Objects

The GR_HAZARD_GROUPS table has a defined parent-child relationship within the GR schema, as documented in the ETRM metadata. It is referenced as a foreign key constraint by the GR_EUROHAZARDS_B table, which stores detailed hazard information for substances. This relationship ensures referential integrity, guaranteeing that any hazard detail record is linked to a valid, pre-defined master hazard group.

  • Primary Key: GR_HAZARD_GROUPS_PK on column HAZARD_GROUP_CODE.
  • Foreign Key (Referencing Table): The table GR_EUROHAZARDS_B contains a foreign key column, HAZARD_GROUP_CODE, which references GR_HAZARD_GROUPS.HAZARD_GROUP_CODE. This links specific European hazard classifications to their broader group category.