Search Results rotation_plan_name




Overview
Explore in AI Chat

Overview

HXT_ADD_ASSIGN_INFO_D is a denormalized reporting view owned by the APPS schema within the Oracle Time and Labor (HXT) module. It presents configuration data from the Additional Assignment Information entity, joining the effective-dated base table HXT_ADD_ASSIGN_INFO_F to human-readable reference names for rotation plans, earning policies, shift differential policies, and hour deduction policies. Its principal design objective is to resolve internal foreign keys into descriptive NAME and MEANING values, eliminating the need for downstream queries to repeatedly join the various HXT policy tables.

The view is particularly relevant to users searching for rotation_plan_name, since that attribute is exposed directly as a column populated from HXT_ROTATION_PLANS.NAME. Rotation plans govern recurring shift cycles in Time and Labor, so this view serves as a convenient single source for reporting assignment-level rotation assignments without manual joins.

Underlying Base Objects

The documented base objects referenced by the view are: FND_USER (synonym), HR_API (package), HR_GENERAL (package), HR_LOOKUPS (view), HR_SECURITY (package), HXT_ADD_ASSIGN_INFO_F (synonym), HXT_EARNING_POLICIES (synonym), HXT_HOUR_DEDUCT_POLICIES (synonym), HXT_ROTATION_PLANS (synonym), HXT_SHIFT_DIFF_POLICIES (synonym), and PER_ASSIGNMENTS_F (view).

The view text confirms these relationships. HXT_ADD_ASSIGN_INFO_F supplies the driving rows, keyed on ASSIGNMENT_ID and effective dates. PER_ASSIGNMENTS_F is outer-joined on ASSIGNMENT_ID with overlapping effective date ranges, providing the ASSIGNMENT_NUMBER. HR_LOOKUPS is outer-joined on LOOKUP_TYPE = 'YES_NO', APPLICATION_ID = 800, and ENABLED_FLAG = 'Y' to translate the AUTOGEN_HOURS_YN code into a MEANING. The policy tables (HXT_ROTATION_PLANS, HXT_EARNING_POLICIES, HXT_SHIFT_DIFF_POLICIES, HXT_HOUR_DEDUCT_POLICIES) are joined on their respective ID columns; shift differential and hour deduction are outer-joined (denoted by the (+)), while rotation and earning policies are inner-joined. FND_USER is outer-joined on USER_ID to resolve the LAST_UPDATED_BY value into a USER_NAME.

Key Columns

  • ID – Primary identifier from HXT_ADD_ASSIGN_INFO_F.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE – Date-effective range for the assignment information record.
  • ASSIGNMENT_NUMBER – Assignment identifier drawn from PER_ASSIGNMENTS_F.
  • AUTOGEN_HOURS_YN – Decoded YES/NO meaning for automatic hour generation.
  • ROTATION_PLAN_NAME – Descriptive name of the assigned rotation plan from HXT_ROTATION_PLANS.NAME.
  • EARNING_POLICY_NAME – Earning policy name from HXT_EARNING_POLICIES.NAME.
  • SHIFT_DIFFERENTIAL_POLICY_NAME – Shift differential policy name; nullable due to outer join.
  • HOUR_DEDUCTION_POLICY_NAME – Hour deduction policy name; nullable due to outer join.
  • LAST_UPDATE_DATE – Audit timestamp of the last modification.
  • LAST_UPDATED_BY – FND_USER.USER_NAME of the last editor; nullable due to outer join.

Common Use Cases and Queries

Typical reporting scenarios include auditing rotation plan assignments across a population of employees, verifying which earning or deduction policies apply to a given assignment, and tracing configuration changes for compliance purposes. A common query filters directly on the rotation plan name:

  • SELECT assignment_number, rotation_plan_name, earning_policy_name FROM hxt_add_assign_info_d WHERE rotation_plan_name = :p_rotation;
  • SELECT assignment_number, autogen_hours_yn, shift_differential_policy_name FROM hxt_add_assign_info_d WHERE effective_start_date >= :p_start;
  • SELECT id, last_update_date, last_updated_by FROM hxt_add_assign_info_d WHERE last_update_date >= TRUNC(SYSDATE) - 30;

Because HR_SECURITY and HR_API are referenced, effective access respects the security profile applied to PER_ASSIGNMENTS_F. Querying the view under the APPS schema or via a reporting responsibility with appropriate grants is recommended. Combined with the _F base table for detail-level analysis, HXT_ADD_ASSIGN_INFO_D simplifies Time and Labor reporting by presenting descriptive policy and rotation identifiers in a single, ready-to-use structure.