Search Results text_value7




Overview
Explore in AI Chat

Overview

HR_SUMMARY is a Human Resources (PER) module table in Oracle E-Business Suite, owned by the HR schema and stored in the HR.HR_SUMMARY schema object. According to the ETRM documentation, the table "holds all data for the Generic Summary Process." In practical terms, HR_SUMMARY functions as a flexible, generic staging and consolidation repository used by Oracle HRMS to store summarized or aggregated results that do not warrant a dedicated, purpose-built table. Rather than defining a rigid set of columns for every conceivable summary, the Generic Summary Process writes into this single table using a set of generic value columns (TEXT_VALUE1–7, NUM_VALUE1–3, DATE_VALUE1–3, and FK_VALUE1–3), allowing diverse summary types to share one physical structure.

The table is classified under the ETRM's heuristic Data Vault mining as "satellite-leaning." This suggests a modeling interpretation in which HR_SUMMARY behaves as a satellite structure: it carries descriptive and measured attributes that hang off a business key, with the primary key HR_SUMMARY_PK (ID_VALUE) acting as the surrogate identifier and TYPE distinguishing the category of summary being stored.

Key Information Stored

The documented physical schema for 12.2.2 lists 25 columns. The most significant are:

The unique index HR_SUMMARY_PK on ID_VALUE is the documented business-key candidate; the design is intentionally generic, so TYPE plus the FK_VALUE and VALUE columns combine to give each row its business meaning.

Common Use Cases and Queries

Typical usage involves retrieving summarized HRMF results by type and business group. A common pattern is to filter by TYPE and BUSINESS_GROUP_ID and join the generic FK columns back to their source entities. For example:

  • Reporting all summaries of a given TYPE: SELECT * FROM hr.hr_summary WHERE type = :p_type AND business_group_id = :p_bg;
  • Aggregating numeric measures: SELECT fk_value1, SUM(num_value1) FROM hr.hr_summary WHERE type = :p_type GROUP BY fk_value1;
  • Auditing recent changes: SELECT id_value, type, last_update_date, last_updated_by FROM hr.hr_summary WHERE last_update_date > SYSDATE-7;

Because the table is generic, developers must first determine the meaning of TYPE, the FK columns, and the value columns for the specific summary process before writing queries. The OBJECT_VERSION_NUMBER supports concurrent updates through OAF-based forms and pages.

Related Objects

The documented foreign key establishes a dependency on HR_ALL_ORGANIZATION_UNITS via HR_SUMMARY.BUSINESS_GROUP_ID. The most significant related objects are:

  • HR_ALL_ORGANIZATION_UNITS — joined on BUSINESS_GROUP_ID.
  • HR_SUMMARY_PK — the primary key constraint/index on ID_VALUE.
  • HR_ALL_ORGANIZATION_UNITS (Organization) — provides the business group context and security scope.
  • PER Generic Summary Process — the concurrent/API process that populates and reads HR_SUMMARY.
  • OAF/Forms summary pages — application entities that consume and maintain these rows.

Where additional summary detail is required, the generic TEXT_VALUE, NUM_VALUE, and DATE_VALUE columns can be interpreted against the corresponding source HRMS entities referenced by FK_VALUE1–3.

  • Table: HR_SUMMARY 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_SUMMARY,  object_name:HR_SUMMARY,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY holds all data for the Generic Summary Process. ,  implementation_dba_data: HR.HR_SUMMARY , 

  • Table: HR_SUMMARY 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_SUMMARY,  object_name:HR_SUMMARY,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY holds all data for the Generic Summary Process. ,  implementation_dba_data: HR.HR_SUMMARY , 

  • View: HR_SUMMARY_TEMPLATE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_TEMPLATE,  object_name:HR_SUMMARY_TEMPLATE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_TEMPLATE stores all the details of each template used by the GSP. ,  implementation_dba_data: APPS.HR_SUMMARY_TEMPLATE , 

  • View: HR_SUMMARY_VALID_RESTRICTION 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_VALID_RESTRICTION,  object_name:HR_SUMMARY_VALID_RESTRICTION,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_VALID_RESTRICTION stores the restrictions that apply to a single item type within a template. ,  implementation_dba_data: APPS.HR_SUMMARY_VALID_RESTRICTION , 

  • View: HR_SUMMARY_ITEM_TYPE_USAGE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_ITEM_TYPE_USAGE,  object_name:HR_SUMMARY_ITEM_TYPE_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_ITEM_TYPE_USAGE identifies the items that will be used by a template every time the GSP process is run. ,  implementation_dba_data: APPS.HR_SUMMARY_ITEM_TYPE_USAGE , 

  • View: HR_SUMMARY_RESTRICTION_VALUE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_RESTRICTION_VALUE,  object_name:HR_SUMMARY_RESTRICTION_VALUE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_RESTRICTION_VALUE holds records for each restriction used by item type in a given template. ,  implementation_dba_data: APPS.HR_SUMMARY_RESTRICTION_VALUE , 

  • View: HR_SUMMARY_ITEM_TYPE_USAGE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_ITEM_TYPE_USAGE,  object_name:HR_SUMMARY_ITEM_TYPE_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_ITEM_TYPE_USAGE identifies the items that will be used by a template every time the GSP process is run. ,  implementation_dba_data: APPS.HR_SUMMARY_ITEM_TYPE_USAGE , 

  • View: HR_SUMMARY_RESTRICTION_VALUE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_RESTRICTION_VALUE,  object_name:HR_SUMMARY_RESTRICTION_VALUE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_RESTRICTION_VALUE holds records for each restriction used by item type in a given template. ,  implementation_dba_data: APPS.HR_SUMMARY_RESTRICTION_VALUE , 

  • View: HR_SUMMARY_TEMPLATE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_TEMPLATE,  object_name:HR_SUMMARY_TEMPLATE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_TEMPLATE stores all the details of each template used by the GSP. ,  implementation_dba_data: APPS.HR_SUMMARY_TEMPLATE , 

  • View: HR_SUMMARY_KEY_TYPE_USAGE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_KEY_TYPE_USAGE,  object_name:HR_SUMMARY_KEY_TYPE_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_KEY_TYPE_USAGE stores records which identify the particular key types which should be included within the SQL statement generated for an Item Type when processed within a particular Template. ,  implementation_dba_data: APPS.HR_SUMMARY_KEY_TYPE_USAGE , 

  • View: HR_SUMMARY_VALID_KEY_TYPE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_VALID_KEY_TYPE,  object_name:HR_SUMMARY_VALID_KEY_TYPE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_VALID_KEY_TYPE stores a record of those key types which may be used by a particular item type ,  implementation_dba_data: APPS.HR_SUMMARY_VALID_KEY_TYPE , 

  • View: HR_SUMMARY_VALID_RESTRICTION 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_VALID_RESTRICTION,  object_name:HR_SUMMARY_VALID_RESTRICTION,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_VALID_RESTRICTION stores the restrictions that apply to a single item type within a template. ,  implementation_dba_data: APPS.HR_SUMMARY_VALID_RESTRICTION , 

  • View: HR_SUMMARY_VALID_KEY_TYPE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_VALID_KEY_TYPE,  object_name:HR_SUMMARY_VALID_KEY_TYPE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_VALID_KEY_TYPE stores a record of those key types which may be used by a particular item type ,  implementation_dba_data: APPS.HR_SUMMARY_VALID_KEY_TYPE , 

  • View: HR_SUMMARY_KEY_TYPE_USAGE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_KEY_TYPE_USAGE,  object_name:HR_SUMMARY_KEY_TYPE_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_KEY_TYPE_USAGE stores records which identify the particular key types which should be included within the SQL statement generated for an Item Type when processed within a particular Template. ,  implementation_dba_data: APPS.HR_SUMMARY_KEY_TYPE_USAGE , 

  • View: HR_SUMMARY_RESTRICTION_USAGE 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_RESTRICTION_USAGE,  object_name:HR_SUMMARY_RESTRICTION_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_RESTRICTION_USAGE holds records which identify the particular restrictions which should be included within the SQL statement generated for an item type when processed within a particular template. ,  implementation_dba_data: APPS.HR_SUMMARY_RESTRICTION_USAGE , 

  • View: HR_SUMMARY_RESTRICTION_USAGE 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PER.HR_SUMMARY_RESTRICTION_USAGE,  object_name:HR_SUMMARY_RESTRICTION_USAGE,  status:VALID,  product: PER - Human Resources ,  description: HR_SUMMARY_RESTRICTION_USAGE holds records which identify the particular restrictions which should be included within the SQL statement generated for an item type when processed within a particular template. ,  implementation_dba_data: APPS.HR_SUMMARY_RESTRICTION_USAGE ,