Results for “quota_fte”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_DISABILITIES_F is a core Human Resources (PER) table in the Oracle E-Business Suite, residing in the HR schema. It stores disability information recorded against an individual person, supporting legislative and organizational requirements such as disability registration, quota tracking, and reasonable-accommodation documentation. The table is date-tracked: every disability record is bounded by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, enabling historical reconstruction of a person's disability status over time. This date-effective design is consistent with the broader PER datetrack model used across person, assignment, and work-incident entities.

In heuristic Data Vault terms, the mined foreign-key structure classifies PER_DISABILITIES_F as a link object. It connects a person to a work incident (PER_WORK_INCIDENTS) and to an organization unit (HR_ALL_ORGANIZATION_UNITS), functioning as an associative record rather than a pure hub of business keys or a satellite holding descriptive attributes. This classification is a modeling suggestion only; the table's physical implementation remains a standard EBS datetracked table within the HR schema.

Key Information Stored

The documented physical schema contains 87 columns. The most significant are:

• DISABILITY_ID — surrogate identifier for the disability record; combined with effectiveness dates it forms the primary key PER_DISABILITIES_F_PK (DISABILITY_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE).
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — datetrack boundaries defining the validity window of each row.
• PERSON_ID — the person to whom the disability record belongs (business-key candidate linking to PER_ALL_PEOPLE_F).
• INCIDENT_ID — foreign key to PER_WORK_INCIDENTS, associating the disability with a recorded workplace incident.
• ORGANIZATION_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the responsible organization unit.
• ASSIGNMENT_ID — the assignment context in which the disability is recorded.
• REGISTRATION_ID / REGISTRATION_DATE / REGISTRATION_EXP_DATE — official registration details and their expiry.
• ASSESSMENT_DUE_DATE — scheduled date for disability assessment.
• CATEGORY, DESCRIPTION, DEGREE — classification and severity of the disability.
• QUOTA_FTE — full-time-equivalent quota implications.
• WORK_RESTRICTION / PRE_REGISTRATION_JOB — accommodation and pre-registration employment context.
• ATTRIBUTE1–30 and DIS_INFORMATION1–30 — flexfield descriptor and information columns for extensible configuration.
• OBJECT_VERSION_NUMBER, STATUS — concurrency control and record lifecycle state.

The unique index PER_DISABILITIES_F_PK acts as the business-key candidate, enforcing uniqueness over the surrogate key plus both datetrack dates.

Common Use Cases and Queries

Typical uses include disability register reporting, quota compliance monitoring, and tracking the outcome of workplace incidents. A common date-effective query retrieves the current disability records for a person:

• SELECT disability_id, person_id, category, degree, registration_date FROM per_disabilities_f WHERE person_id = :p_person_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
• Joining to PER_WORK_INCIDENTS to trace which incidents produced disability records: ... FROM per_disabilities_f d, per_work_incidents i WHERE d.incident_id = i.incident_id;
• Aggregating QUOTA_FTE by organization for workforce planning, grouping by ORGANIZATION_ID and joining HR_ALL_ORGANIZATION_UNITS.

Reports should always filter on effectiveness dates to avoid returning historical or future-dated versions of a record.

Related Objects

• PER_WORK_INCIDENTS — referenced via PER_DISABILITIES_F.INCIDENT_ID; source of incident context for the disability.
• HR_ALL_ORGANIZATION_UNITS — referenced via PER_DISABILITIES_F.ORGANIZATION_ID; supplies organization unit details.
• PER_ALL_PEOPLE_F — parent person entity associated through PERSON_ID.
• PER_ALL_ASSIGNMENTS_F — related through ASSIGNMENT_ID for employment context.
• PER_DISABILITIES_F_PK index — enforcing uniqueness on the primary key columns.

These relationships make PER_DISABILITIES_F a focal point for joining person, incident, assignment, and organization data in HR disability reporting and compliance extracts.