Results for “gr_ein_numbers_b”

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

Overview

GR_EIN_NUMBERS_B is a core reference table within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. The table stores one row for each European Index Number (EIN), a regulatory identifier assigned to hazardous chemical substances under European Union legislation. EINs are used to classify and cross-reference substances for regulatory reporting, safety data sheet (SDS) generation, and compliance with directives such as those governing dangerous substances and preparations. Each record anchors a substance's identity to its EIN, its EEC (European Economic Community) number, its primary CAS registry number, and its chemical formula, making GR_EIN_NUMBERS_B a master reference hub for regulatory substance identification.

Under the heuristic Data Vault classification derived from its foreign key topology, the table is modelled as hub-leaning. It holds a stable, unique business identifier (the European Index Number) with descriptive attributes, and it is referenced by downstream association tables rather than referencing them itself. This structure is consistent with a reference or master-data hub that supports one-to-many relationships with dependent regulatory records.

Key Information Stored

The documented schema contains nine columns. The most significant are:

• EUROPEAN_INDEX_NUMBER — The European Index Number, a unique regulatory identifier for the substance. This column serves as both the primary key and the single business-key candidate, defined by the unique index GR_EIN_NUMBERS_B_PK.
• EEC_NUMBER — The European Economic Community number, a legacy regulatory classification identifier associated with the substance.
• PRIMARY_CAS_NUMBER — The primary Chemical Abstracts Service registry number, the globally recognized numeric identifier for the chemical substance.
• CHEMICAL_FORMULA — The molecular formula describing the substance's chemical composition.
• CREATED_BY, CREATION_DATE — Standard Oracle audit columns capturing the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the last modification user, timestamp, and login context.

In this table the surrogate primary key and the business key are effectively the same attribute: EUROPEAN_INDEX_NUMBER. There is no separately generated numeric surrogate column documented. The foreign key relationship is inverted — GR_EIN_NUMBERS_B is the parent referenced by GR_EIN_ASL_CONCS rather than the child of another table.

Common Use Cases and Queries

The primary use case is regulatory substance look-up and compliance reporting. Regulatory managers query the table to resolve an EIN to its CAS number or EEC number when preparing SDS documentation or hazardous substance inventories. A typical query retrieves full substance detail by business key:

• SELECT european_index_number, eec_number, primary_cas_number, chemical_formula FROM gr.gr_ein_numbers_b WHERE european_index_number = :ein;
• Reporting across the table to enumerate all registered EINs: SELECT european_index_number, primary_cas_number FROM gr.gr_ein_numbers_b ORDER BY european_index_number;
• Audit and change-tracking queries filtering on LAST_UPDATE_DATE to identify recently maintained reference data.
• Cross-referencing substances between the EIN and CAS identifiers to reconcile regulatory and chemical inventory systems.

Because the table functions as a reference hub, joins to dependent association tables are common in reporting extracts and interface programs.

Related Objects

The documented foreign key relationships identify the following dependent object:

• GR_EIN_ASL_CONCS — References GR_EIN_NUMBERS_B through the column EUROPEAN_INDEX_NUMBER. This association table links European Index Numbers to substance concentration or listing data, joining on GR_EIN_ASL_CONCS.EUROPEAN_INDEX_NUMBER = GR_EIN_NUMBERS_B.EUROPEAN_INDEX_NUMBER.

In practice, GR_EIN_NUMBERS_B is referenced alongside other GR regulatory tables that consume substance identifiers, supporting SDS authoring, substance volume tracking, and hazardous classification workflows. Analysts should treat GR_EIN_NUMBERS_B as the authoritative source for EIN-to-CAS/EEC mapping within the Process Manufacturing Regulatory Management module.