Search Results hr_pattern_bits




Overview
Explore in AI Chat

Overview

HR_PATTERN_BITS is an Oracle Human Resources (PER) foundation table that stores the atomic building blocks used to construct scheduling and availability patterns. Each row defines a discrete period of time — for example a block of working hours, a rest interval, or an absence segment — that is later assembled into a larger pattern through the HR_PATTERN_CONSTRUCTIONS intersection entity. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the pattern framework that supports shift definitions, work schedules, and related HR scheduling constructs.

From a modeling perspective, the mined Data Vault classification is hub-leaning. HR_PATTERN_BITS behaves like a hub: it holds the durable, business-keyed identity of each pattern bit (via PATTERN_BIT_CODE), independent of how that bit is later reused across patterns. Its descriptive attributes can be viewed as satellite-style payload, while HR_PATTERN_CONSTRUCTIONS acts as the link that associates bits with pattern definitions.

Key Information Stored

The table exposes eleven documented columns. The most significant are:

Common Use Cases and Queries

Typical uses include validating pattern bit definitions, auditing who created or changed bits, and reporting on the duration composition of scheduling patterns. A catalog query retrieves the human-readable definition of each bit:

  • SELECT pattern_bit_id, pattern_bit_code, bit_meaning, time_unit_multiplier, base_time_unit FROM hr.hr_pattern_bits ORDER BY pattern_bit_code;
  • Joining to the construction table to see which bits compose a pattern: SELECT b.pattern_bit_code, b.bit_meaning FROM hr.hr_pattern_bits b, hr.hr_pattern_constructions c WHERE b.pattern_bit_id = c.pattern_bit_id;
  • Audit/reporting filter: SELECT * FROM hr.hr_pattern_bits WHERE last_update_date >= :from_date;

Because patterns drive scheduling and absence logic, reporting should restrict queries by the relevant pattern or business group to avoid full-table scans on large implementations.

Related Objects

The principal dependent object is the intersection entity that consumes bits:

  • HR_PATTERN_CONSTRUCTIONS — references HR_PATTERN_BITS through HR_PATTERN_CONSTRUCTIONS.PATTERN_BIT_ID, defining which bits make up each pattern.
  • HR_PATTERN_BITS_PK / HR_PATTERN_BITS_UK1 — the indexes enforcing surrogate and business-key uniqueness.

Additional PER scheduling and pattern-definition tables participate indirectly through the pattern construction layer, but HR_PATTERN_CONSTRUCTIONS remains the primary documented relationship with this table.