Search Results pay_time_definitions

Overview

The PAY_TIME_DEFINITIONS table is a core data structure within the Oracle E-Business Suite Payroll module (PAY). It serves as the master repository for defining distinct periods of time, which are fundamental to payroll processing. These time definitions are abstract representations of payroll periods, such as weekly, bi-weekly, or monthly cycles, and are used to govern the calculation and consolidation of earnings, deductions, and other payroll elements. The table's role is to establish the temporal framework against which payroll runs are executed, ensuring that all calculations are aligned to the correct and consistent time intervals as defined by an organization's payroll policies and legislative requirements.

Key Information Stored

The table stores metadata that uniquely identifies and describes each time period definition. Its primary key is TIME_DEFINITION_ID, a system-generated unique identifier. A composite unique key (PAY_TIME_DEFINITIONS_UK1) enforces business rule integrity across the DEFINITION_NAME, BUSINESS_GROUP_ID, and LEGISLATION_CODE columns. This structure allows for the creation of definition names that can be reused across different business groups or legislative contexts. Key descriptive columns include DEFINITION_NAME, which holds the user-recognizable name of the time period (e.g., "Weekly US Payroll"). The BUSINESS_GROUP_ID and LEGISLATION_CODE columns provide the necessary multi-organization and legal context, segregating data according to the operating unit and country-specific payroll laws.

Common Use Cases and Queries

This table is primarily referenced for setup validation, reporting, and integration. A common use case is verifying the time definitions configured for a specific business group or legislation to ensure payroll calendar creation is based on valid periods. For reporting, it is often joined to payroll transaction tables to provide context on the period for which payments were calculated. A typical query pattern involves selecting active definitions for a given context:

• SELECT definition_name, time_definition_id FROM pay_time_definitions WHERE business_group_id = &bg_id ORDER BY definition_name;

Another critical use case is during the design of custom payroll reports or interfaces, where the TIME_DEFINITION_ID from this table is used to correctly filter or segment payroll data by its originating pay period.

Related Objects

As indicated by the provided foreign key metadata, PAY_TIME_DEFINITIONS has a direct relationship with the PAY_EVENT_GROUPS table. The PAY_EVENT_GROUPS.TIME_DEFINITION_ID column references PAY_TIME_DEFINITIONS, linking groups of payroll events (like batch calculations) to a specific time definition. Furthermore, this table is foundational to the PAY_PAYROLLS and PAY_PAYROLL_ACTIONS tables, which store payroll instances and execution details tied to a period. It is also referenced by key APIs and views within the Payroll module, such as those supporting the payroll calendar form and the Payroll Process driver, which uses the time definition to control the sequencing of payroll calculations.