Search Results gr_exposure_auths_b_pk

Overview

The GR_EXPOSURE_AUTHS_B table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It functions as the master repository for defining and storing Exposure Authority Codes. In the context of regulatory compliance, particularly for chemical or substance management, an Exposure Authority Code is a critical classification that dictates the permissible exposure limits, handling guidelines, and regulatory requirements for personnel interacting with specific materials. This table serves as the foundational reference table, ensuring that exposure control data is consistently applied across the product lifecycle, from formulation to reporting.

Key Information Stored

As a base table (indicated by the '_B' suffix), GR_EXPOSURE_AUTHS_B holds the primary transactional and key data. The central column is EXPOSURE_AUTHORITY_CODE, which serves as the unique identifier (Primary Key) for each exposure authority record. While the provided metadata does not list additional columns, typical '_B' tables in EBS often include standard columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing. The descriptive, translatable name for each code is stored in the related translation table, GR_EXPOSURE_AUTHS_TL, which is linked via the primary key.

Common Use Cases and Queries

This table is primarily used in regulatory setup and enforcement. Common scenarios include configuring the list of valid exposure authorities during system implementation and associating these codes with specific items or substances. A frequent reporting need is to list all defined authorities, often joined with their descriptions. A typical query would be:

• SELECT b.EXPOSURE_AUTHORITY_CODE, tl.DESCRIPTION FROM GR.GR_EXPOSURE_AUTHS_B b, GR.GR_EXPOSURE_AUTHS_TL tl WHERE b.EXPOSURE_AUTHORITY_CODE = tl.EXPOSURE_AUTHORITY_CODE AND tl.LANGUAGE = USERENV('LANG');

Another critical use case is validating data integrity when assigning exposure codes to items, ensuring that any code used in the GR_ITEM_EXPOSURE table exists in this master table.

Related Objects

The GR_EXPOSURE_AUTHS_B table is central to a small but important data model within the GR module. Its relationships are documented as follows:

• Primary Key: GR_EXPOSURE_AUTHS_B_PK on the column EXPOSURE_AUTHORITY_CODE.
• Foreign Key References (Child Tables):
  • GR_EXPOSURE_AUTHS_TL: This translation table holds the language-specific descriptions for each exposure authority code. It joins to GR_EXPOSURE_AUTHS_B via the column GR_EXPOSURE_AUTHS_TL.EXPOSURE_AUTHORITY_CODE.
  • GR_ITEM_EXPOSURE: This transactional table assigns specific exposure authorities to regulated items or substances. It references the master code via the column GR_ITEM_EXPOSURE.EXPOSURE_AUTHORITY_CODE.

These relationships enforce referential integrity, making GR_EXPOSURE_AUTHS_B the single source of truth for valid exposure authority codes in the system.