Search Results hr_dm_tables




Overview
Explore in AI Chat

Overview

HR_DM_TABLES is a Human Resources (PER product) repository table in the HR schema that serves as the master registry of HRMS tables processed by the Oracle Data Migrator (DM) framework. The Data Migrator is the EBS utility used to generate, load, and reconcile HRMS data during implementations, upgrades, and bulk data conversions. Each row in HR_DM_TABLES describes a single HRMS table that the migrator can act upon, together with the derivation SQL, loader configuration, and generation metadata required to move data into it.

Because the table maintains a controlled inventory of migratable entities rather than transactional HR data, its heuristic Data Vault classification is hub-leaning. In dimensional or Data Vault modeling terms, HR_DM_TABLES behaves as a hub: TABLE_ID is a stable surrogate key, TABLE_NAME is the natural business key, and dependent descriptive attributes (SQL templates, loader settings, generation timestamps) can be modeled as satellite attributes. HR_DM_HIERARCHIES adds a self-referencing link structure for parent/child table dependencies.

Key Information Stored

HR_DM_TABLES contains 34 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical uses include identifying which tables are enabled for migration, tracing loader configuration for a given table, auditing generation history, and extracting table dependency hierarchies.

  • List all migratable tables for an application: SELECT table_id, table_name, loader_name FROM hr.hr_dm_tables WHERE application = :app;
  • Find loaders past a generation date: SELECT table_name, last_generated_date, generator_version FROM hr.hr_dm_tables WHERE last_generated_date > SYSDATE-30;
  • Join to loader parameters: SELECT t.table_name, p.* FROM hr.hr_dm_tables t, hr.hr_dm_loader_params p WHERE t.table_id = p.table_id;
  • Resolve parent/child dependencies: SELECT h.table_id, h.parent_table_id FROM hr.hr_dm_hierarchies h;

Reporting typically surfaces which HRMS tables are migration-enabled, their SQL derivation coverage, and loader/concurrent program assignments.

Related Objects

  • HR_DM_HIERARCHIES — references HR_DM_TABLES via TABLE_ID and PARENT_TABLE_ID, defining parent/child ordering of migratable tables.
  • HR_DM_LOADER_PARAMS — references TABLE_ID; stores per-table loader parameter rows.
  • HR_DM_TABLE_GROUPINGS — references TABLE_ID; groups tables for batch processing.
  • FND_SECURITY_GROUPS — referenced by HR_DM_TABLES.SECURITY_GROUP_ID, controlling security partitioning.
  • FND_CONCURRENT_PROGRAMS — related via LOADER_CONC_PROGRAM for loader execution.