Search Results datetracked_event_id

Overview

The PAY_DATETRACKED_EVENTS table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). It functions as a central registry for defining which specific data changes, or "events," should be systematically monitored and recorded on DateTrack-enabled tables across the Human Resources Management System (HRMS). DateTrack is Oracle's fundamental mechanism for maintaining historical, current, and future-dated information for key HR entities like assignments, jobs, and salaries. This table enables the Payroll engine to identify and react to relevant changes in HR data, ensuring accurate and auditable payroll calculations by linking specific column updates in HR tables to defined payroll event groups.

Key Information Stored

The table stores metadata that maps HR data changes to payroll processing events. Its structure, as indicated by its primary and unique keys, is designed to prevent duplicate tracking definitions. The critical columns include DATETRACKED_EVENT_ID (the primary key surrogate identifier), EVENT_GROUP_ID (a foreign key to PAY_EVENT_GROUPS, linking to a logical set of payroll events), and DATED_TABLE_ID (a foreign key to PAY_DATED_TABLES, identifying the specific HR DateTrack table being monitored, such as PER_ALL_ASSIGNMENTS_F). The COLUMN_NAME specifies the exact column within that dated table where a change constitutes a tracked event (e.g., SALARY_AMOUNT in PER_ALL_PAY_PROPOSALS_F). Finally, UPDATE_TYPE defines the nature of the change that triggers the event, typically indicating an update (U), correction (C), or date delete (D).

Common Use Cases and Queries

The primary use case is configuring and auditing the payroll event framework. System administrators or functional implementers query this table to verify which HR data changes will initiate downstream payroll processes. Common queries involve listing all tracked events for a specific HR table or for a particular payroll event group to understand process dependencies. For example, a query to see all columns tracked for salary change events would join PAY_DATETRACKED_EVENTS to PAY_EVENT_GROUPS and PAY_DATED_TABLES. Reporting use cases focus on impact analysis; before modifying a critical HR table's structure or data loading procedures, consultants would reference this table to assess potential effects on payroll event generation and subsequent calculations.

Related Objects

PAY_DATETRACKED_EVENTS sits at the intersection of several key payroll data model objects. It has direct foreign key relationships with PAY_EVENT_GROUPS (which categorizes events) and PAY_DATED_TABLES (which catalogs DateTrack-enabled tables). The events defined here are consumed by the payroll engine's event-driven architecture, influencing processes managed by packages like PAY_EVENT_PROCEDURES. Furthermore, the table is referenced by other configuration and logging tables, such as those storing generated event instances (e.g., PAY_PAYROLL_EVENTS) for a specific employee assignment when a tracked column is updated. Understanding its relationships is essential for tracing the flow from an HR data change to a payroll calculation adjustment.