Search Results per_time_period_sets




Overview
Explore in AI Chat

Overview

The PER_TIME_PERIOD_SETS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module. It functions as the master definition table for time period sets, which are structured calendars used to organize and define specific recurring timeframes. These calendars are foundational for scheduling and processing time-sensitive HR and payroll operations. The table's role is to establish the unique combination of a calendar name and its effective start date, providing the temporal framework upon which detailed period types and payroll calendars are built.

Key Information Stored

The table stores the essential metadata that defines a time period calendar. Its primary key is a composite of two columns: PERIOD_SET_NAME and START_DATE. The PERIOD_SET_NAME identifies the calendar, such as 'Standard Bi-Weekly' or 'Monthly Accounting'. The START_DATE marks the effective commencement date for that particular calendar definition. Another critical column is PERIOD_TYPE, which is a foreign key linking to the PER_TIME_PERIOD_TYPES table. This column defines the frequency (e.g., Week, Month, Bi-Week) that governs the calendar's structure. Additional descriptive columns, though not explicitly listed in the provided metadata, typically include attributes for further identification and control.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of payroll calendars and for reporting on period-based data. A common administrative query retrieves all defined calendars and their effective dates to verify setup. For example: SELECT period_set_name, start_date, period_type FROM per_time_period_sets ORDER BY period_set_name, start_date;. In reporting scenarios, it is frequently joined to detailed period tables to filter or categorize transactions, such as payroll runs or accrual calculations, within a specific calendar timeframe. System processes rely on this table to validate that payroll processing aligns with the correct, active calendar definition.

Related Objects

The PER_TIME_PERIOD_SETS table maintains key relationships with other HR and Payroll structures, as documented in the provided metadata.

  • Primary Key: PER_TIME_PERIOD_SETS_PK (START_DATE, PERIOD_SET_NAME). This unique constraint is the anchor for relationships from other tables.
  • Foreign Key (Referenced by): The PAY_CALENDARS table references PER_TIME_PERIOD_SETS via the PERIOD_SET_NAME column. This links the calendar definition to its specific implementation details for payroll processing.
  • Foreign Key (References): The PER_TIME_PERIOD_SETS table references the PER_TIME_PERIOD_TYPES table via the PERIOD_TYPE column. This ensures the calendar's frequency is a valid, predefined type.