Search Results pay_monetary_units_pk




Overview
Explore in AI Chat

Overview

The PAY_MONETARY_UNITS table is a foundational reference table within the Oracle E-Business Suite (EBS) Payroll module (PAY). It serves as a master repository for defining the valid denominations or units of currency, such as coins and banknotes, that are recognized by the system. Its primary role is to support payroll calculations and reporting, particularly in scenarios involving cash handling, coin analysis, and the breakdown of net pay into specific monetary units for payment distribution. By maintaining a centralized list of currency denominations, it ensures data integrity and consistency across all payroll-related processes that require granular currency information.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the table's description and relationships indicate its core structure. The central column is MONETARY_UNIT_ID, which serves as the unique identifier (Primary Key: PAY_MONETARY_UNITS_PK) for each currency denomination record. Typical columns expected in such a reference table, based on standard Oracle HRMS design patterns, would include the currency value (e.g., 0.01, 0.05, 1, 5, 10, 20), a descriptive name for the unit, and an association to a specific currency from the FND_CURRENCIES table. The table likely also contains standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing and a column to indicate the active status of the monetary unit.

Common Use Cases and Queries

This table is primarily utilized in payroll processes that involve the physical disbursement of cash or detailed analysis of pay components. A core use case is configuring and running coin analysis, where an employee's net pay is algorithmically broken down into an optimal mix of available currency denominations for cash payment. Reporting on cash payment requirements for a specific payroll run would also rely on this data. Sample queries often involve joining to the PAY_COIN_ANAL_ELEMENTS table to retrieve the denominations used for a particular analysis setup or to list all active monetary units for a given currency.

  • Sample Query: SELECT monetary_unit_id, unit_value, name FROM pay_monetary_units WHERE currency_code = 'USD' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY unit_value;
  • Reporting Use Case: Generating a report detailing the quantity of each banknote and coin required to fulfill the cash payments for a payroll, aggregated across all employees paid via that method.

Related Objects

The PAY_MONETARY_UNITS table has a direct, documented relationship with the PAY_COIN_ANAL_ELEMENTS table, as per the provided foreign key metadata. This relationship is fundamental to the coin analysis functionality.

  • PAY_COIN_ANAL_ELEMENTS: This table references PAY_MONETARY_UNITS via the foreign key column MONETARY_UNIT_ID. It stores the configuration of which specific monetary units (coins and notes) are available for use within a defined coin analysis element, linking the analysis setup to the master list of valid denominations.

While not explicitly listed in the brief metadata, this table is conceptually related to core HRMS tables such as FND_CURRENCIES (for valid currency codes) and PAY_PAYROLL_ACTIONS within the broader payroll calculation flow.