Search Results normal_start_time

Overview

HXC_RESOURCE_INFORMATION_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the HXC – Time and Labor Engine product. It exposes a consolidated, denormalized record of a resource (typically an employee or contingent worker) together with the contextual attributes needed by Time and Labor and related self-service flows. Rather than presenting raw HR tables, the view projects person identifiers, display names, employee numbers, national identifiers, hire dates, job titles, organization names, supervisor details, descriptive flexfield segments (PER_INFORMATION1 through PER_INFORMATION30), office and location attributes, and availability information into a single row per person.

Its principal role is to serve as a stable read-only interface for Time and Labor pages, approval workflows, and custom reports that need resource details without joining multiple PER and HR tables directly. Because the definition resolves surrogate keys into user-facing values such as full names and meanings, it is well suited for reporting and integration layers where readability and stable column aliases matter.

Underlying Base Objects

The view is defined over a broad set of HRMS and payroll objects. Documented referenced base objects include PER_PEOPLE_F, PER_ASSIGNMENTS_F, PER_POSITIONS, PER_PERIODS_OF_SERVICE, PER_TIME_PERIODS, PER_GRADES, PER_JOBS, PER_PAY_BASES, PER_COLLECTIVE_AGREEMENTS, PER_CAGR_GRADES_DEF, and the PER_ASSIGNMENT_STATUS_TYPES_V view. Payroll and costing context is supplied through PAY_PAYROLLS, PAY_PEOPLE_GROUPS, PAY_COST_ALLOCATIONS_F, and PAY_COST_ALLOCATION_KEYFLEX.

Organization and location data are drawn from HR_ORGANIZATION_UNITS and HR_LOCATIONS, while HR_LOOKUPS supplies meaning values such as the availability schedule. Date-effective resolution for the person and assignment entities is handled through HR_GENERAL, and security filtering is applied via HR_SECURITY and HR_API so that rows respect the caller's security profile. Name formatting is performed through HR_PERSON_NAME, and flexfield context is resolved through HR_SOFT_CODING_KEYFLEX. The view therefore behaves as a date-effective, security-aware projection across the HRMS person model.

Key Columns

• RESOURCE_ID – The PERSON_ID of the resource, the primary join key to Time and Labor tables.
• RESOURCE_DISPLAY_NAME / RESOURCE_NUMBER – Full name and employee number for display and lookup.
• NATIONAL_IDENTIFIER – Government or national identifier from the person record.
• HIRE_DATE – Derived from PERIODS_OF_SERVICE.DATE_START, populated only when the person is a current employee.
• JOB_TITLE / ORGANIZATION_NAME – Job and organization context for the assignment.
• SUPERVISOR_NAME / SUPERVISOR_NUMBER – Supervisor identification for approval routing.
• PER_INFORMATION_CATEGORY and PER_INFORMATION1–30 – Descriptive flexfield category and segment values.
• OFFICE_NUMBER, INTERNAL_LOCATION, MAILSTOP – Location and internal addressing attributes.
• AVAILABILITY_SCHEDULE – Meaning resolved from HR_LOOKUPS describing availability.
• FULLTIME_AVAILABILTY – FTE capacity of the resource.
• ATTRIBUTE_CATEGORY / ATTRIBUTE1 – Additional descriptive attributes carried from the person record.

Note that the search term normal_start_time is not a column of this view; start-time information is held by Time and Labor schedule and shift entities rather than by HXC_RESOURCE_INFORMATION_V.

Common Use Cases and Queries

Typical uses include resolving resource identity in Time and Labor reports, populating LOVs on custom concurrent programs, and enriching timecard extracts with job, organization, and supervisor context.

SELECT resource_id,
       resource_display_name,
       resource_number,
       hire_date,
       job_title,
       organization_name,
       supervisor_name,
       fulltime_availabilty
  FROM apps.hxc_resource_information_v
 WHERE resource_number = :employee_number;

For a department listing with availability, filter on organization and order by name:

SELECT resource_display_name,
       organization_name,
       job_title,
       availability_schedule,
       fulltime_availabilty
  FROM apps.hxc_resource_information_v
 WHERE organization_name = :organization_name
 ORDER BY resource_display_name;

Because the view applies HR security, results returned in a custom report or SQL session are restricted by the security profile of the connected user, which should be accounted for when validating row counts or building integrations.