Results for “edwbv_orga_tree1_lvl7_lcv”

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

Overview

The view EDWBV_ORGA_TREE1_LVL7_LCV is a legacy Oracle EBS object belonging to the HRI (Human Resources Intelligence) product, a module now classified as obsolete. This view is a component of the hierarchical organization tree structure used by the HR Intelligence data warehouse/ETL layer, specifically representing level 7 of the ORGA_TREE1 hierarchy. The "_LCV" suffix indicates "Load Current View," reflecting its role as a staging or materialization layer for extraction, transformation, and loading processes.

The object is not implemented in the source database referenced by the ETRM documentation, meaning it exists only as a definition artifact and is not deployed in that environment. Its primary reporting role is to expose organization unit information in a denormalized, hierarchy-flattened form suitable for downstream dimensional modeling and daily/last-load increment processing. The view surfaces PRIMARY_ORG_DP as one of its columns, which is why it appears in searches for that term.

Underlying Base Objects

The ETRM metadata documents no base objects explicitly, but the embedded view SQL in the documentation identifies the following referenced tables and views:

• HR_ALL_ORGANIZATION_UNITS — aliased twice for the business group (BGR) and the organization unit (ORG).
• HRI_PRIMARY_HRCHYS — the primary hierarchy definition table; drives the level and parent/child relationships.
• EDW_ORGA_TREE1_LVL8_LCV — the level 8 view, referenced as the parent (upward FK) in the hierarchy join.
• EDW_LOCAL_INSTANCE — the local instance registry providing INSTANCE_CODE.

The UNION's second branch represents a synthetic "NA_EDW" placeholder row from EDW_LOCAL_INSTANCE, carrying NULL organization attributes. This is a standard pattern for seeding an "unknown/NA" dimension member.

Key Columns

• ORG_TREE1_LVL7_PK — Synthetic primary key formed as '7-' || ORGANIZATION_ID || '-' || INSTANCE_CODE; the NA branch uses '7-NA_EDW' || INSTANCE_CODE.
• ORG_TREE1_LVL8_FK — Foreign key to the level 8 view's primary key, enabling hierarchy navigation.
• INSTANCE — The EDW instance code identifying the source system.
• NAME — Concatenation of organization name and business group name.
• PRIMARY_ORG_DP — Display name for the primary organization, formatted identically to NAME; typically used as a reporting label.
• BUSINESS_GROUP — The business group name from the BGR alias.
• ORGANIZATION_ID — The organization unit identifier.
• LAST_UPDATE_DATE — The GREATEST of the organization's and tree's last-updated values, defaulting to 2000-01-01.
• CREATION_DATE — Organization creation date.

Common Use Cases and Queries

Typical scenarios involve HR organizational hierarchy reporting and loading into downstream EDW dimensions. A common pattern is to filter by instance and business group:

• Resolving the primary organization display for a given level 7 node, using PRIMARY_ORG_DP.
• Bridging level 7 to level 8 for drill-down reporting.
• Incremental loads filtered on LAST_UPDATE_DATE.

Example:

SELECT ORG_TREE1_LVL7_PK,
       ORGANIZATION_ID,
       PRIMARY_ORG_DP,
       BUSINESS_GROUP,
       INSTANCE,
       LAST_UPDATE_DATE
FROM   EDWBV_ORGA_TREE1_LVL7_LCV
WHERE  INSTANCE = :instance_code
AND    LAST_UPDATE_DATE >= :since_date;

Because the view is obsolete and not implemented in the reference database, its use is confined to legacy HRI-enabled environments; modern deployments should rely on supported HR organization hierarchy views.