Results for “hrfv_ada_disabilities”

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

Overview

HRFV_ADA_DISABILITIES is an APPS-owned, VALID business view within the Oracle E-Business Suite PER (Human Resources) product module. As stated in the ETRM metadata, it is a "business view template from which the flexfield view is generated." In practice, this means the view is not a static reporting object but a template driven by a specific descriptive flexfield (DFF) context. The view exposes person-level records associated with the Americans with Disabilities Act (ADA) disability tracking flexfield, letting HR users and downstream reports query structured disability information stored in the generic person-analysis (extra information) framework.

The view provides a denormalized, readable projection of person analysis records, joining the person, business group, and analysis criteria definitions. Because the underlying data is stored in the generic PER_PERSON_ANALYSES model, HRFV_ADA_DISABILITIES abstracts the DFF mechanics and presents business-friendly column names such as PERSON_NAME, TYPE, START_DATE, and END_DATE.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following base objects:

• PER_PERSON_ANALYSES (SYNONYM) — the core fact table holding person analysis (extra information) rows, including dates, comments, and the analysis criteria reference.
• PER_ANALYSIS_CRITERIA (SYNONYM) — defines the available analysis criteria (the "types") for the flexfield.
• PER_PEOPLE_X (VIEW) — supplies person attributes such as FULL_NAME and EMPLOYEE_NUMBER.
• HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — supplies the translated business group name.
• HR_BIS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (PACKAGES) — supporting HR packages, notably HR_BIS.GET_SEC_PROFILE_BG_ID for business group security filtering.

The defining SQL joins PER_PERSON_ANALYSES to PER_ANALYSIS_CRITERIA on ANALYSIS_CRITERIA_ID and ID_FLEX_NUM, to PER_PEOPLE_X on PERSON_ID, and to HR_ALL_ORGANIZATION_UNITS_TL on BUSINESS_GROUP_ID = ORGANIZATION_ID. A fixed ID_FLEX_NUM of 50129 identifies the ADA disability flexfield. The view is created WITH READ ONLY and filters business groups by the user's security profile via NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ...).

Key Columns

• ANALYSIS_CRITERIA_ID — the identifier of the specific analysis criteria (disability type record) attached to the person. This is the column referenced in the originating search.
• TYPE — the SEGMENT1 value from PER_ANALYSIS_CRITERIA, giving the human-readable criteria/type label.
• PERSON_NAME / EMPLOYEE_NUMBER — employee identity attributes sourced from PER_PEOPLE_X.
• BUSINESS_GROUP_NAME — translated organization name for the business group.
• START_DATE / END_DATE — DATE_FROM and DATE_TO of the analysis record, defining the effective period.
• COMMENTS — free-text notes on the record.
• ID_FLEX_NUM / BUSINESS_GROUP_ID / PERSON_ID / PERSON_ANALYSIS_ID — key and context identifiers used for joins, security, and record uniqueness.

Common Use Cases and Queries

This view supports ADA disability reporting, compliance extracts, and HR self-service or OBIEE/BIP reporting on employee accommodations. A typical query filters by business group or person:

• Listing disability types for an employee: SELECT person_name, type, start_date, end_date, comments FROM hrfv_ada_disabilities WHERE employee_number = :emp_num;
• Aggregating by criteria: SELECT type, COUNT(*) FROM hrfv_ada_disabilities GROUP BY type;
• Resolving the criteria identifier: SELECT person_name, analysis_criteria_id, type FROM hrfv_ada_disabilities WHERE analysis_criteria_id = :id;

Because the view enforces business group security, results are automatically restricted to the querying user's accessible business groups. Analysts seeking the meaning of a stored analysis_criteria_id should join or compare against PER_ANALYSIS_CRITERIA to retrieve the descriptive TYPE label.