Results for “fcl_deduction_type”

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

Overview

HXT_HOUR_DEDUCTION_RULES_FMV is a formulation (FMV) view owned by the APPS schema within the Oracle E-Business Suite Time and Labor product (HXT). It presents configured hour deduction rules, the master data that determines how hours are automatically subtracted from an employee's reported or calculated time. Deduction rules are frequently used to model unpaid meal breaks, grace periods, or other fixed and variable deductions applied during time calculation. The view exposes the deduction rule header together with the user-facing meaning of the associated deduction type, resolved from the HR lookup set HXT_HOUR_DEDUCTION_TYPE. Because it is a view rather than a table, it provides a read-only, denormalized projection that joins the base rules table to the lookup translation, sparing report authors and integrators from performing that join themselves.

The "FMV" suffix denotes a formula or fixed view variant typically maintained for internal Time and Labor processing and reporting. The view carries the ROWID of the base table as ROW_ID, which allows downstream consumers to retain a stable identifier for the underlying row. The user search term "hdp_id" corresponds directly to the HDP_ID primary key column exposed by this view, which is the identifier used to reference a specific hour deduction rule.

Underlying Base Objects

The view is defined over the following documented base objects:

• HXT_HOUR_DEDUCTION_RULES (SYNONYM) — the base table holding the hour deduction rule definitions. The synonym resolves to the underlying rules table in the APPS schema.
• HR_LOOKUPS (VIEW) — supplies the translated meaning of the deduction type via a lookup join.
• HR_API (PACKAGE) — referenced as part of the Time and Labor object dependency set supporting the rules infrastructure.

The defining query joins HXT_HOUR_DEDUCTION_RULES to HR_LOOKUPS using an outer join, keyed on the lookup type HXT_HOUR_DEDUCTION_TYPE, the deduction type code, and APPLICATION_ID 808. The outer join ensures that rules with an unmaintained or missing lookup entry still surface with a null MEANING rather than being excluded from the result set. This dependency on HR_LOOKUPS means that changes to the HXT_HOUR_DEDUCTION_TYPE lookup set are immediately reflected in the view output without recompilation.

Key Columns

• HDP_ID — the unique identifier (primary key) of the hour deduction rule. This is the column referenced by the "hdp_id" search term.
• ROW_ID — the ROWID of the base table row, providing a physical locator for the record.
• FCL_DEDUCTION_TYPE — the lookup code identifying the deduction type, joined to HR_LOOKUPS.
• MEANING — the user-facing description of the deduction type, retrieved from the lookup set.
• HOURS — the number of hours to be deducted under the rule.
• TIME_PERIOD — the period context over which the deduction applies.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range during which the rule is active, supporting date-tracked configuration.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit and WHO columns.

Common Use Cases and Queries

Typical uses include auditing configured deduction rules, driving time-calculation analysis, and validating lookup completeness. A simple query retrieving all rules ordered by identifier:

• SELECT HDP_ID, FCL_DEDUCTION_TYPE, MEANING, HOURS, TIME_PERIOD, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM APPS.HXT_HOUR_DEDUCTION_RULES_FMV ORDER BY HDP_ID;
• Locate a specific rule by identifier: SELECT * FROM APPS.HXT_HOUR_DEDUCTION_RULES_FMV WHERE HDP_ID = :p_hdp_id;
• Identify rules whose deduction type lacks a lookup meaning: SELECT HDP_ID, FCL_DEDUCTION_TYPE FROM APPS.HXT_HOUR_DEDUCTION_RULES_FMV WHERE MEANING IS NULL;

Because the view is read-only, inserts and updates must be issued against the base table HXT_HOUR_DEDUCTION_RULES. Report developers should filter on the effective dates to isolate currently active rules.