Search Results gr_ein_asl_risks




Overview
Explore in AI Chat

Overview

The GR_EIN_ASL_RISKS table is a core data entity within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management module (GR). Its primary function is to manage regulatory compliance for chemical substances in the European market. Specifically, it stores the association between EINECS (European Inventory of Existing Chemical Substances) numbers, their defined concentration levels from the Approved Supply List (ASL), and the corresponding standardized Risk Phrases. This table acts as a critical junction, linking substance identification and concentration data to the specific hazard classifications mandated by European chemical regulations, thereby enabling the generation of compliant safety data sheets and product labels.

Key Information Stored

The table's structure is designed to enforce and manage the many-to-many relationship between ASL concentrations and risk phrases. Its composite primary key consists of two columns: SEQUENCE_NUMBER and RISK_PHRASE_CODE. The SEQUENCE_NUMBER serves as a foreign key linking back to a specific concentration record in the GR_EIN_ASL_CONCS table, which itself is tied to an EINECS substance. The RISK_PHRASE_CODE is a foreign key referencing the master list of regulatory risk phrases stored in GR_RISK_PHRASES_B. Each row effectively declares that for a given substance concentration (SEQUENCE_NUMBER), a particular risk phrase (RISK_PHRASE_CODE) is applicable.

Common Use Cases and Queries

This table is central to regulatory reporting and compliance validation processes. A common use case involves generating a comprehensive list of all risk phrases for a specific EINECS-registered substance at its various regulated concentration thresholds. This is essential for creating regional product safety documentation. A typical query would join through the concentration table to retrieve the substance identifier. For example:

  • Reporting All Risks for a Substance: SELECT rp.risk_phrase_code, rp.meaning FROM gr_ein_asl_risks ar, gr_ein_asl_concs ac, gr_risk_phrases_b rp WHERE ar.sequence_number = ac.sequence_number AND ar.risk_phrase_code = rp.risk_phrase_code AND ac.einecs_number = 'XXX-XXX-X';
  • Data Validation: Ensuring that every SEQUENCE_NUMBER in GR_EIN_ASL_CONCS that requires risk phrases has at least one corresponding entry in this table.
  • Impact Analysis: Identifying all affected substance concentrations if a specific RISK_PHRASE_CODE is updated or retired in the master table.

Related Objects

The GR_EIN_ASL_RISKS table is a dependent object within a clear hierarchy, primarily serving as a child to two key parent tables, as defined by its foreign key constraints.

  • GR_EIN_ASL_CONCS: This is the primary parent table. The relationship is defined by GR_EIN_ASL_RISKS.SEQUENCE_NUMBER → GR_EIN_ASL_CONCS. The SEQUENCE_NUMBER identifies the specific Approved Supply List concentration record to which the risk phrases are attached.
  • GR_RISK_PHRASES_B: This is the reference data table for standardized risk phrases. The relationship is defined by GR_EIN_ASL_RISKS.RISK_PHRASE_CODE → GR_RISK_PHRASES_B. This ensures all risk codes used are valid and can obtain their full descriptive text (e.g., R23: Toxic by inhalation).

These relationships ensure data integrity, where a risk association cannot exist without a valid concentration record and a valid master risk phrase.