Search Results time_normal_end




Overview
Explore in AI Chat

Overview

APPS.EDW_HR_ASGN_ASSGNMNT_LCV is an Oracle E-Business Suite HRMS reporting view that forms part of the Enterprise Data Warehouse (EDW) layer used to expose Human Resources assignment information for analytical, extract, and integration purposes. The view belongs to the HR assignment coverage area and is generated from a source definition file (hrisvas.odf, version 120.0), consistent with the EDW convention of building denormalized "LCV" (logical coverage view) objects on top of base business views. In Oracle EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and serves as a stable, read-only contract for downstream reporting.

The object provides a single flattened row per assignment, combining identity, dating, status, and scheduling attributes. This design shields external consumers from the underlying normalized HR tables and supports consistent extraction patterns for HR analytics and third-party interfaces.

Underlying Base Objects

The documented metadata records that this view is defined over a single referenced object: EDWBV_HR_ASGN_ASSGNMNT_LCV, itself an EDW business view. No further base tables are enumerated in the ETRM metadata, indicating the lineage is encapsulated within that business view (which ultimately resolves to HR assignment and assignment-extra-information tables such as PER_ALL_ASSIGNMENTS_F and related HR lookup structures). Because the view performs a simple projection with no joins in its own definition, it inherits the semantics, effective dating, and Multi-Org (business group) context of EDWBV_HR_ASGN_ASSGNMNT_LCV.

Key Columns

Common Use Cases and Queries

Typical uses include HR workforce analytics, headcount and scheduling extracts, and data-warehouse loads. A frequent query filters on the scheduling attribute surfaced by the user's search:

  • Identifying assignments whose normal working pattern ends after a threshold: SELECT assignment_id, assignment_number, time_normal_start, time_normal_end FROM apps.edw_hr_asgn_assgnmnt_lcv WHERE time_normal_end > '18:00';
  • Extracting active primary assignments for a business group within a date window using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
  • Building shift or schedule reports joining NORMAL_HOURS, NORMAL_HOURS_FREQUENCY, TIME_NORMAL_START, and TIME_NORMAL_END.
  • Feeding downstream EDW or BI datasets with a consistent assignment snapshot.

Consumers should treat the view as read-only and note that effectivity is governed by the underlying business view, so date-bounded predicates on the effective columns are recommended.