Search Results per_disabilities_f




Overview
Explore in AI Chat

Overview

The PER_DISABILITIES_F table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for releases 12.1.1 and 12.2.2. As indicated by its name and the provided metadata, its primary function is to hold disability information for a person. The '_F' suffix denotes that it is an effective-dated table, meaning it tracks changes to a person's disability records over time using the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns. This temporal design is fundamental to maintaining a historical record of when a disability was first recorded, any subsequent updates, and when it may have become inactive. The table is owned by the HR schema and is integral to managing legally sensitive and compliance-related employee data.

Key Information Stored

The table's structure is designed to capture comprehensive disability details. The primary key is a composite of DISABILITY_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, ensuring uniqueness of each historical record for a specific disability. Key columns, as inferred from the metadata and standard HR table design, include DISABILITY_ID (the unique identifier for the disability record), PERSON_ID (linking to the PER_ALL_PEOPLE_F table), and the effective date columns for tracking history. The metadata explicitly confirms the presence of an ORGANIZATION_ID column, linked via foreign key to HR_ALL_ORGANIZATION_UNITS, which associates the disability record with a specific organization. Furthermore, the existence of a foreign key relationship from PER_WORK_INCIDENTS on the INCIDENT_ID column indicates this table can store disabilities that are formally linked to a specific work-related incident.

Common Use Cases and Queries

This table is central to compliance reporting, benefits administration, and workplace accommodation processes. Common operational and reporting scenarios include generating lists of employees with active disabilities for legal audits, determining eligibility for specific benefits programs, and analyzing workplace incident outcomes. A typical query to retrieve current disability records for a person would join PER_DISABILITIES_F to PER_ALL_PEOPLE_F and filter on EFFECTIVE_END_DATE being greater than or equal to SYSDATE. For reporting on disabilities related to workplace incidents, a join to PER_WORK_INCIDENTS via the INCIDENT_ID would be essential. Developers often interact with this table indirectly via standard HRMS APIs (e.g., PER_DISABILITY_API) to ensure proper validation and maintenance of the data.

Related Objects

  • PER_WORK_INCIDENTS: Directly related via the foreign key on INCIDENT_ID, linking a disability to a specific occupational incident.
  • HR_ALL_ORGANIZATION_UNITS: Linked via the ORGANIZATION_ID foreign key, providing the organizational context for the disability record.
  • PER_ALL_PEOPLE_F: The foundational person table, linked via PERSON_ID (implied by the table's purpose), to retrieve employee or person details.
  • PER_DISABILITY_CATEGORIES (Typical): While not listed in the provided metadata, this lookup table is commonly referenced to classify the type of disability.
  • HRMS APIs: Standard Oracle HRMS APIs, such as those in the PER_DISABILITY package, provide the sanctioned method for creating, updating, and deleting records in this table.