Results for “policy_start”

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

Overview

HXTFV_HOURS_POLICY is a read-only Oracle EBS view owned by the APPS schema within the HXT (Time and Labor) product family. It provides a denormalized, reporting-oriented representation of hour deduction policies assigned to employees, joining person, assignment, business group, and hour deduction rule data into a single flattened row set. The view is intended for reporting and integration rather than transactional maintenance, and is defined WITH READ ONLY, reinforcing its purpose as a query-only artifact. The "FV" naming convention typically denotes a formatted or flattened view used for extraction, ad hoc reporting, and interface consumption. Because the view applies SYSDATE-based effective date filtering across PER_ALL_PEOPLE_F, PER_ASSIGNMENTS_F, HXT_ADD_ASSIGN_INFO_F, and HXT_HOUR_DEDUCTION_RULES, it always returns only currently effective records as of the time of query execution.

Underlying Base Objects

The view is defined over six principal sources, referenced through synonyms and one view:

• PER_ALL_PEOPLE_F — supplies PERSON_NAME and the person-level effective dating.
• PER_ASSIGNMENTS_F (documented as a VIEW) — supplies ASSIGNMENT_ID, GRADE_ID, JOB_ID, ORGANIZATION_ID, PERSON_ID, POSITION_ID, and BUSINESS_GROUP_ID.
• HXT_ADD_ASSIGN_INFO_F — the assignment-level hour deduction assignment information, joined via AIF.ASSIGNMENT_ID and AIF.HOUR_DEDUCTION_POLICY.
• HXT_HOUR_DEDUCT_POLICIES (HDP) — the policy header, providing policy name, description, start and end dates, and policy ID.
• HXT_HOUR_DEDUCTION_RULES (HDR) — the rule detail, providing deduction type, hours, and time period.
• HR_ALL_ORGANIZATION_UNITS_TL (BGRT) — the translated business group name, joined on business group organization ID and language.

The view also invokes the HR_GENERAL package (specifically DECODE_LOOKUP and GET_BUSINESS_GROUP_ID) and, per documented metadata, HR_SECURITY, which enforces row-level security using the current business group context applied through NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, ASG.BUSINESS_GROUP_ID).

Key Columns

• PERSON_COUNT — the column referenced in the user's search. It is exposed as a literal constant of 1, not an aggregated count. Each row represents one person-assignment-policy-rule combination, so PERSON_COUNT always returns the value 1 and should not be treated as a true count metric; sums across rows yield the row cardinality, not a distinct headcount.
• BUSINESS_GROUP_NAME / BUSINESS_GROUP_ID — the translated business group and its internal identifier.
• PERSON_NAME / PERSON_ID — the employee's full name and person identifier.
• ASSIGNMENT_ID — the specific assignment linking the person to the policy.
• POLICY_NAME / POLICY_DESCRIPTION / POLICY_START / POLICY_END — policy header attributes and effective dates.
• DEDUCTION_TYPE — decoded from the HXT_HOUR_DEDUCTION_TYPE lookup for readability.
• HOURS / TIME_PERIOD — the rule-level deduction quantity and its period.
• GRADE_ID, JOB_ID, ORGANIZATION_ID, POSITION_ID — assignment-based organizational context descriptors.

Common Use Cases and Queries

Typical uses include auditing which employees are subject to which hour deduction policies, validating deductions by business group, and feeding downstream payroll or reporting extracts. A simple query returning person and policy detail:

• SELECT person_name, policy_name, deduction_type, hours, time_period FROM apps.hxtfv_hours_policy WHERE business_group_id = :p_bg_id ORDER BY person_name;

To obtain an accurate headcount rather than the constant P PERSON_COUNT, aggregate distinct persons explicitly:

• SELECT business_group_name, policy_name, COUNT(DISTINCT person_id) headcount FROM apps.hxtfv_hours_policy GROUP BY business_group_name, policy_name;

Because row-level security is enforced through HR_GENERAL/HR_SECURITY, results are automatically scoped to the querying user's business group context unless overridden by the session's business group setting.