Search Results per_time_period_types

Overview

The PER_TIME_PERIOD_TYPES table is a core reference table within the Oracle E-Business Suite Human Resources (PER) module. It serves as a master repository for defining the valid period types that can be used across the system, primarily for structuring payroll calendars and HR budget calendars. This table provides a standardized list of periodicity codes, such as 'Weekly', 'Monthly', or 'Bi-Weekly', which are essential for configuring the frequency of payroll runs, budget accruals, and other time-based processes. Its role is foundational, ensuring consistency in how time periods are referenced and utilized throughout the HR and payroll applications.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the structure of such reference tables in Oracle HRMS typically includes a key code column and descriptive fields. Based on standard implementation patterns, the primary column is almost certainly PERIOD_TYPE, which acts as the unique identifier (Primary Key) for each period type. This column stores short, meaningful codes. Supporting columns would typically include a user-friendly NAME or DESCRIPTION for the period type (e.g., 'Calendar Month'), and potentially control attributes like a system flag or number of days. The data is predominantly seeded by Oracle during installation, with organizations potentially able to add custom period types to meet specific business requirements.

Common Use Cases and Queries

A primary use case is the setup and validation of payroll definitions. When an administrator creates a payroll, they must select a period type that defines its frequency. The system validates this selection against PER_TIME_PERIOD_TYPES. Similarly, when defining element entry rules or budget commitment elements, the period type determines reset or accrual frequencies. Common reporting and query scenarios include listing all available period types for a setup task or identifying which payrolls use a specific period type. A fundamental query to retrieve all valid period types would be: SELECT period_type, name FROM hr.per_time_period_types ORDER BY period_type;. For troubleshooting, one might join this table to payroll definitions to analyze frequency configurations across the enterprise.

Related Objects

As documented in the foreign key relationships, PER_TIME_PERIOD_TYPES is referenced by several key transactional and setup tables. The PERIOD_TYPE column is joined to the following objects:

• PAY_ALL_PAYROLLS_F: Links to define the core frequency (PERIOD_TYPE) of a payroll.
• PAY_CALENDARS: References the period type (ACTUAL_PERIOD_TYPE) used for a specific payroll calendar.
• PER_TIME_PERIOD_SETS: Associates a set of generated time periods with a base period type.
• PAY_ELE_PAYROLL_FREQ_RULES: Specifies the reset frequency (RESET_PERIOD_TYPE) for payroll element rules.
• PER_COBRA_COV_ENROLLMENTS: Indicates the period type used for COBRA coverage billing.
• PQH_BDGT_CMMTMNT_ELMNTS: Defines the default frequency (DFLT_ELMNT_FREQUENCY) for budget commitment elements.

These relationships underscore the table's central role in enforcing temporal consistency across payroll processing, benefits administration, and budgeting.