Search Results ghr_restricted_proc_methods




Overview
Explore in AI Chat

Overview

The GHR_RESTRICTED_PROC_METHODS table is a core data 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 an intersection or mapping table, establishing a critical relationship between specific personnel action (PA) data fields and restricted forms. Its primary role is to enforce business rules by defining which data fields are applicable or required when processing a particular restricted form within the federal personnel action workflow. This table is essential for ensuring data integrity and compliance with federal HR processing regulations by controlling the availability and validation of data elements based on the form in use.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two columns. The PA_DATA_FIELD_ID column stores a foreign key reference to a specific personnel action data field defined in the GHR_PA_DATA_FIELDS table. The RESTRICTED_FORM column identifies the specific form (e.g., a Standard Form number like SF-52) to which the data field's restriction applies. Each row in this table represents a single rule, mapping one data field to one form. The table does not store the data values themselves but the metadata governing which fields are relevant for a given form's processing method.

Common Use Cases and Queries

A primary use case is the dynamic construction of data entry screens or validation routines within the GHR module. When a user initiates a personnel action on a specific form, the application queries this table to determine the set of data fields that must be presented or validated. For reporting and administrative purposes, common queries involve listing all restricted forms associated with a particular data field or vice versa. A sample SQL pattern to retrieve all data fields restricted to a specific form would be:

  • SELECT pdf.DATA_FIELD_NAME, rp.RESTRICTED_FORM
  • FROM GHR_RESTRICTED_PROC_METHODS rp,
  • GHR_PA_DATA_FIELDS pdf
  • WHERE rp.PA_DATA_FIELD_ID = pdf.PA_DATA_FIELD_ID
  • AND rp.RESTRICTED_FORM = 'SF-52';

Related Objects

The GHR_RESTRICTED_PROC_METHODS table has a direct and documented dependency on the GHR_PA_DATA_FIELDS table, which is the master source for personnel action field definitions. The relationship is enforced by a foreign key constraint where GHR_RESTRICTED_PROC_METHODS.PA_DATA_FIELD_ID references GHR_PA_DATA_FIELDS. This table is likely referenced by various GHR application forms, packages, and business logic components that govern the personnel action processing lifecycle. Understanding this intersection is key for troubleshooting data entry issues, customizing form behavior, or developing integrations that must adhere to the module's field-level security and validation rules.