Results for “hr_pattern_bits_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR.HR_PATTERN_BITS is a foundational configuration table in the Oracle E-Business Suite HR (Human Resources) module, owned by the HR schema and delivered under FND Design Data PER.HR_PATTERN_BITS. Its purpose is to simplify the construction of complex repeating patterns such as work patterns and resource schedules. Rather than expressing durations directly, the table allows an administrator to define arbitrary named time periods — for example, a period based on 8 hours labelled "Standard shift" — that can subsequently be referenced when building pattern constructions. The application stores a base real-time unit (hours, days, or weeks) together with a multiplier, and derives the duration of each pattern bit by multiplying the two. Because the multiplier accepts any positive number, including fractions, pattern bits can be defined at very fine levels of granularity.

The object carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. Under the heuristic Data Vault classification mined from its foreign-key structure, HR_PATTERN_BITS is hub-leaning: it behaves as a stable, uniquely keyed registry of business concepts (the pattern bits themselves) that other tables reference, rather than as a transactional link or a descriptive satellite.

Key Information Stored

The table is physically stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 20, and contains eleven documented columns.

• PATTERN_BIT_ID — System-generated numeric primary key, enforced by the HR_PATTERN_BITS_PK unique index. This is the surrogate identifier used by foreign keys.
• PATTERN_BIT_CODE — A VARCHAR2(30) unique name that identifies the pattern bit to users and integrations. It is the documented business key, enforced by the HR_PATTERN_BITS_UK1 unique index (the object referenced by the search term "hr_pattern_bits_uk1"). Note that the ETRM metadata also lists an alternate unique key name, HR_PAB_UK01, over the same column.
• BIT_MEANING — A VARCHAR2(2000) explanation of the pattern bit and its intended purpose, providing the descriptive context needed by administrators.
• TIME_UNIT_MULTIPLIER — The numeric figure by which the base time unit is multiplied to calculate the duration of the pattern bit.
• BASE_TIME_UNIT — A VARCHAR2(30) value naming the real time unit (hours, days, or weeks) from which the pattern bit duration is derived.
• OBJECT_VERSION_NUMBER — A system-maintained version counter that increments by one on each update, supporting optimistic locking.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the audit trail.

Common Use Cases and Queries

Typical usage involves validating configuration before building or migrating work patterns, and reporting on the pattern bits available to the scheduling engine. A lookup by business key is the most common access path:

• Retrieve a pattern bit by its unique code: SELECT pattern_bit_id, bit_meaning, time_unit_multiplier, base_time_unit FROM hr.hr_pattern_bits WHERE pattern_bit_code = :code;
• List all defined durations: SELECT pattern_bit_code, time_unit_multiplier, base_time_unit FROM hr.hr_pattern_bits ORDER BY pattern_bit_code;
• Audit recent configuration changes: filter on last_update_date and last_updated_by.
• Join to HR_PATTERN_CONSTRUCTIONS to identify which patterns consume a given pattern bit.

Related Objects

• HR_PATTERN_CONSTRUCTIONS — References HR_PATTERN_BITS through the column PATTERN_BIT_ID, defining where and how each pattern bit is used in pattern construction.
• Other work-pattern and scheduling objects in the HR and PER product families that resolve pattern durations through HR_PATTERN_BITS_PK or HR_PATTERN_BITS_UK1.
• Standard HR configuration APIs and concurrent programs that validate pattern bit codes against HR_PATTERN_BITS_UK1.