Search Results pay_fr_contribution_usages




Overview
Explore in AI Chat

Overview

PAY_FR_CONTRIBUTION_USAGES is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds the definition of statutory payroll contributions within the French legislation, acting as a configuration repository that maps payroll elements to the contribution treatment required by French statutory reporting. The table is classified as VALID in the ETRM data model and contains 20 documented columns.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table retains a surrogate primary key, multiple business-key unique constraints, and descriptive attributes (rate, contribution, and process properties) that change over time, which is characteristic of satellite behaviour attached to a core business entity. This classification is a heuristic recommendation rather than a prescriptive implementation rule.

Key Information Stored

The table's structure supports both identity and descriptive purposes:

Common Use Cases and Queries

Typical usage centres on French statutory payroll reporting, effective-dated rate lookups, and auditing of contribution definitions. A common query pattern resolves the currently active contribution for a given element and process:

  • Filtering by SYSDATE BETWEEN DATE_FROM AND DATE_TO to obtain the effective definition on a pay period date.
  • Joining on ELEMENT_NAME and PROCESS_TYPE to reconcile payroll element setup against statutory contribution codes.
  • Using GROUP_CODE or RATE_CATEGORY to segment contributions by population or scheme.
  • Retrieving RETRO_CONTRIBUTION_CODE when processing retroactive payroll adjustments.
  • Reporting on CONTRIBUTION_TYPE and CONTRIBUTION_USAGE_TYPE to summarise the statutory contribution footprint for a business group.

A representative pattern selects CONTRIBUTION_CODE, RATE_TYPE, and RATE_CATEGORY from PAY_FR_CONTRIBUTION_USAGES where ELEMENT_NAME and PROCESS_TYPE match the payroll element, BUSINESS_GROUP_ID matches the operating unit's business group, and the current date falls within the effective range. Because the table is effective-dated, queries should always constrain the date window to avoid returning multiple historical rows.

Related Objects

The principal relationships documented for this table are:

  • HR_ALL_ORGANIZATION_UNITS — referenced through PAY_FR_CONTRIBUTION_USAGES.BUSINESS_GROUP_ID, providing the owning business group for each contribution definition.
  • PAY_FR_CONTRIBUTION_USAGES_UK1, PAY_FR_CONTRIBUTION_USAGES_UK2, and PAY_FR_CONTRIBUTION_USAG_PK — the unique indexes enforcing identity and business-key uniqueness.
  • Payroll element and rate definition entities referenced via ELEMENT_NAME and CODE_RATE_ID — these link the usage row to the element and rate structures that drive calculation.

Because the table functions as a French-legislation configuration repository, dependent payroll processes, statutory reports, and rate-maintenance screens read from it rather than write to it during normal payroll runs.