Results for “time_normal_start”

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

Overview

The EDW_HR_PSTN_POSITION_LCV view is a Human Resources Intelligence (HRI) reporting object owned by the APPS schema. Its name follows the HRI warehouse naming convention: the EDW prefix identifies it as part of the Enterprise Data Warehouse staging and loading layer, HR denotes the Human Resources subject area, PSTN indicates the Position dimension, and the LCV suffix denotes a "Load Column View." Such load column views are the standardized extraction interface used by HRI's ETL processes to populate the position dimension tables that underpin HR analytics and workforce reporting. In the context of Oracle EBS 12.1.1 and 12.2.2, this view is a read-only, VALID database object exposing position definition attributes — including working hours and their frequency — to downstream reports, extracts, and integration programs. The explicit reference to the working_hour_freq column reflects its relevance for users searching that term, since it is one of the few EBS reporting surfaces where position-level working-hour frequency is directly readable without joining to the underlying HR tables.

Underlying Base Objects

The documented view text shows a single dependent object: EDWBV_HR_PSTN_POSITION_LCV. ETRM metadata records no other referenced base objects, and the view is a thin projection rather than a join. The BV in the dependency name indicates a "Bulk View" — an intermediate HRI layer that reads from the EBS HR position base tables (HR_ALL_POSITIONS_F and its related _TL and _B siblings) and applies any warehouse-specific filtering or instance stamping. The outer LCV view therefore exists to present a stable, ordered column list to the loader. This layering means the view is not a substitute for transactional HR querying; it is a controlled interface whose shape is governed by the HRI data model rather than by EBS form requirements. Because the dependency is a view and not a base table, the load column view remains insulated from physical table reorganization in EBS 12.2.2's online patching (adop) editioning model.

Key Columns

• POSITION_PK, POSITION_ID, POSITION_DEFINITION_ID — surrogate and EBS primary keys identifying the position and its definition version.
• INSTANCE, ALL_FK — HRI warehouse instance discriminator and the "all" foreign key used in the multi-instance data model.
• NAME, POSITION_DP, BUSINESS_GROUP, BUSINESS_GROUP_ID — position name and the business group (organization) it belongs to.
• ORGANIZATION_ID, JOB_ID — owning organization and associated job for the position.
• POSITION_FROM_DATE, POSITION_TO_DATE — effective dating of the position definition row.
• PROBATION_PERIOD, REPLACEMENT_REQUIRED — position requirement flags.
• TIME_NORMAL_START, TIME_NORMAL_FINISH — default working time boundaries for the position.
• WORKING_HOURS, WORKING_HOUR_FREQ — the number of working hours and the frequency unit (for example, per day, week, or month) used to interpret that number.
• LAST_UPDATE_DATE, CREATION_DATE — audit columns used by incremental ETL.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — descriptive flexfield segments; the view text supplies literal NULL placeholders for them.

Common Use Cases and Queries

Typical consumers load the HRI position dimension or publish position extracts to downstream HR analytics. To locate positions with a defined working-hour frequency:

• SELECT position_id, name, working_hours, working_hour_freq FROM apps.edw_hr_pstn_position_lcv WHERE working_hour_freq IS NOT NULL;
• Incremental extraction using the audit columns: SELECT * FROM apps.edw_hr_pstn_position_lcv WHERE last_update_date >= :p_since;
• Business-group scoped reporting: SELECT business_group, position_id, working_hours, working_hour_freq FROM apps.edw_hr_pstn_position_lcv WHERE business_group_id = :p_bg_id;
• Effective-dated validation: filter on position_from_date and position_to_date to return only current positions.

Queries should be issued with the APPS schema or through a synonym with appropriate grants, as direct access is restricted to the HRI reporting role.