Search Results form_block_name

Overview

The GHR_PA_DATA_FIELDS table is a core data dictionary object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a master repository that defines the metadata for all available data fields on the Request for Personnel Action (RPA) form. Its primary role is to catalog the specific fields, including their identifiers and logical groupings, that can be populated or referenced during the personnel action request and processing lifecycle. This table enables the system to manage field-level processing rules, validations, and integrations by providing a centralized, unique reference for each permissible form element.

Key Information Stored

The table's structure is designed to uniquely identify each form field. The primary key is the system-generated identifier, PA_DATA_FIELD_ID. Two additional unique keys enforce critical business rules. The first (UK1) is on the NAME column, which likely stores a descriptive label for the field. The second (UK2) is a composite key on FORM_BLOCK_NAME and FORM_FIELD_NAME. This combination is essential: FORM_BLOCK_NAME identifies the logical section or block of the RPA form (e.g., Position Data, Employee Data), while FORM_FIELD_NAME specifies the technical name of the individual field within that block. This two-tiered structure allows the system to precisely locate any field within the form's architecture.

Common Use Cases and Queries

A primary use case is retrieving the master list of all fields for a specific form block, often for configuration, reporting, or integration purposes. For example, an administrator may need to audit all fields in the 'Position Data' block. The direct query for this is straightforward: SELECT form_field_name, name FROM hr.ghr_pa_data_fields WHERE form_block_name = '&BLOCK_NAME' ORDER BY form_field_name;. The most pertinent query for a developer or analyst searching by the technical field name, as indicated by the user's search for "form_field_name", would be to identify the full context of a specific field: SELECT pa_data_field_id, form_block_name, name FROM hr.ghr_pa_data_fields WHERE form_field_name = '&FIELD_NAME';. This returns the unique ID, its block, and its descriptive name, which is crucial for troubleshooting or building extensions that interact with RPA data.

Related Objects

As a reference table, GHR_PA_DATA_FIELDS is primarily accessed by other GHR tables that define processing rules tied to specific form fields. The provided metadata shows two key foreign key relationships. The GHR_NOA_FAM_PROC_METHODS table references it, linking Notice of Action (NOA) family processing methods to specific RPA fields. Similarly, the GHR_RESTRICTED_PROC_METHODS table references it, connecting restricted processing methods to fields. This demonstrates that GHR_PA_DATA_FIELDS serves as the authoritative source for field identifiers, ensuring that downstream processing logic in these method tables is consistently mapped to the correct form elements.