Search Results hxt_timecards_f




Overview
Explore in AI Chat

Overview

HXT_TIMECARDS_F is the core transactional table in the Oracle E-Business Suite Time and Labor (HXT) module. It stores the detailed hours an employee works within a given payroll period, acting as the timecard repository that feeds payroll processing, costing, and labor distribution. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the HXT schema and is maintained through the OTL (Oracle Time and Labor) timecard entry, approval, and retrieval processes. Each row represents an effective-dated timecard record tied to a specific person and time period.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as standalone. This heuristic suggests HXT_TIMECARDS_F functions primarily as a hub-like or self-contained entity rather than a dependent link or pure satellite, anchored by its business key of person and time period. The classification is a mined suggestion, not an enforced constraint.

Key Information Stored

The table contains 49 columns. The most significant are:

The business-key candidate HXT_TIMECARDS_UK (FOR_PERSON_ID, TIME_PERIOD_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) uniquely identifies a person's timecard for a period, distinguishing it from the surrogate ID in HXT_TIMECARDS_PK.

Common Use Cases and Queries

Typical reporting scenarios include retrieving an employee's hours for a period, auditing approvals, and reconciling timecards to payroll.

  • Retrieve timecards for a person and period: 
    SELECT id, for_person_id, time_period_id, status
FROM hxt.hxt_timecards_f
WHERE for_person_id = :person_id
AND time_period_id = :period_id
AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
  • Identify pending approvals: 
    SELECT id, for_person_id, approved_timestamp
FROM hxt.hxt_timecards_f
WHERE status = 'SUBMITTED'
AND approv_person_id IS NULL;
  • Join to time periods for payroll reconciliation: 
    SELECT t.id, p.period_name
FROM hxt.hxt_timecards_f t, per.per_time_periods p
WHERE t.time_period_id = p.time_period_id;

These queries support payroll auditing, labor cost analysis, and compliance reporting.

Related Objects

The most significant related objects, based on documented foreign keys and dependencies, include:

Together these objects form the Time and Labor data model that connects employee time capture to payroll and costing.