Search Results disability_degree

Overview

APPS.PER_ES_TAX_SS_EMP_V is a Spanish localization (ES) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered as part of the Oracle HRMS statutory reporting layer. Its name and structure indicate that it supports Spanish Social Security (Seguridad Social / "SS") tax reporting obligations, exposing person-level and assignment-level attributes required on official filings submitted to the Spanish tax and social security authorities.

The view is session-aware rather than person-parameterized: it filters records using the effective date of the current FND session, resolved through userenv('sessionid'). The view therefore returns the row set applicable "as of" the session's effective date, rather than requiring an explicit date parameter. This design allows a runtime environment to configure an effective date once (through the session) and have all downstream reports and extract programs pick up the correct point-in-time data automatically.

Because it is intended for statutory output, the view performs decoding and derived calculations — most notably translating coded values into human-readable meanings and computing age and disability degree — so that the reporting layer avoids re-implementing that logic.

Underlying Base Objects

The view is defined over the following documented objects:

• PER_ALL_PEOPLE_F (SYNONYM) — supplies person attributes including full name, date of birth, sex, and national identifier.
• PER_ALL_ASSIGNMENTS_F (SYNONYM) — supplies the assignment context: assignment identifier and assignment number.
• FND_SESSIONS (SYNONYM) — supplies the current session record and its effective date, used both for filtering and for driving derived calculations.
• HR_GENERAL (PACKAGE) — provides the DECODE_LOOKUP function used to resolve lookup codes to meanings.
• HR_ES_UTILITY (PACKAGE) — provides GET_DISABILITY_DEGREE, returning the disability degree for a person at a given effective date.

The three tables are joined such that the person's effective-dated record and the assignment's effective-dated record both must encompass the session effective date. The join is on person_id between person and assignment, with the session table driving the temporal filter. This ensures a single consistent "as of" snapshot per session.

Key Columns

• FULL_NAME — the person's full name, taken directly from PER_ALL_PEOPLE_F.
• AGE — derived as FLOOR(MONTHS_BETWEEN(session_effective_date, date_of_birth)/12), i.e. the person's completed years of age as of the session effective date.
• SEX — the raw sex lookup code from PER_ALL_PEOPLE_F.
• SEX_MEANING — the decoded meaning of the SEX code, obtained via HR_GENERAL.DECODE_LOOKUP('SEX', sex). This is the column referenced by the common search term "sex_meaning": reports join or select this column to present a readable value instead of the stored code.
• NATIONAL_IDENTIFIER — the person's national identifier (for Spain, typically the DNI/NIE), used in statutory identification fields.
• ASSIGNMENT_ID and ASSIGNMENT_NUMBER — identifiers of the assignment record returned by the effective-dated join.
• DISABILITY_DEGREE — returned by HR_ES_UTILITY.GET_DISABILITY_DEGREE(person_id, session_effective_date), expressing the recognized degree of disability at the effective date.

Common Use Cases and Queries

The view is typically consumed by Spanish statutory extracts and Social Security reporting programs, and by diagnostic queries that need a decoded, as-of snapshot of person and assignment data with age and disability degree pre-computed.

Because SEX_MEANING is provided directly by the view, queries avoiding the lookup function need only select from the view:

• SELECT full_name, sex, sex_meaning, age FROM apps.per_es_tax_ss_emp_v ORDER BY full_name;
• SELECT assignment_number, national_identifier, sex_meaning, disability_degree FROM apps.per_es_tax_ss_emp_v WHERE disability_degree IS NOT NULL;

Results depend on the effective date configured in the current FND session, so the session context must be established before the view is queried; running it outside an appropriate session scope returns no meaningful rows.