Search Results contribution_class




Overview
Explore in AI Chat

Overview

PAY_IE_PRSI_DETAILS_F is a Payroll (PAY) module table owned by the HR schema that stores Pay-Related Social Insurance (PRSI) details for an assignment within the Irish legislative payroll context. PRSI is the Irish social insurance contribution regime administered by the Department of Social Protection, and this table captures the employment-specific attributes that drive contribution classification, insurable week counting, and exemption handling for a given employee assignment.

The table is Date Tracked, meaning that multiple rows may exist for the same logical PRSI record across different effective date ranges. Each row is bounded by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, and the DateTrack infrastructure (via the standard HR DateTrack framework) manages row versioning as users make date-effective corrections in the Oracle Forms-based PRSI Details window. The _F suffix denotes the "frozen"/date-tracked variant, which is the form the application queries at runtime.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault modelling scheme, indicating that no foreign-key relationships were mined from the physical structure. From a modelling suggestion perspective, this object is best treated as a satellite-like record keyed by a surrogate identifier plus a date range, rather than as a hub or link, because it holds descriptive and state attributes about PRSI treatment rather than representing a distinct business entity or an association between entities.

Key Information Stored

The primary key is Pay_IE_Prsi_Details_F_PK, comprising PRSI_DETAILS_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. PRSI_DETAILS_ID is the surrogate identifier; the two effective date columns complete the DateTrack key and together form the business-key candidate exposed by that unique index.

  • PRSI_DETAILS_ID — surrogate primary key for the PRSI record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — DateTrack effective range.
  • ASSIGNMENT_ID — the assignment to which these PRSI details apply; the principal business reference.
  • CONTRIBUTION_CLASS — the PRSI contribution class assigned to the assignment (e.g., the A, S, D or other class codes that drive contribution rates).
  • OVERRIDDEN_SUBCLASS — a user-specified subclass override where the derived subclass is not appropriate.
  • SOC_BEN_FLAG and SOC_BEN_START_DATE — indicate Social Benefit entitlement and the date from which it applies.
  • OVERRIDDEN_INS_WEEKS / NON_STANDARD_INS_WEEKS — the overridden and non-standard insurable weeks totals used in contribution calculations.
  • EXEMPTION_START_DATE / EXEMPTION_END_DATE — the range over which a PRSI exemption applies.
  • CERT_ISSUED_BY — the party or authority that issued the supporting certificate.
  • DIRECTOR_FLAG and COMMUNITY_FLAG — status flags identifying proprietary directors and community employment participants.
  • OBJECT_VERSION_NUMBER — optimistic locking version for concurrent update control.

Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are also present.

Common Use Cases and Queries

The principal use case is driving Irish PRSI contribution calculation during payroll runs. The payroll engine resolves the effective PRSI row for an assignment at the processing date and derives the contribution class, insurable weeks, and any exemption before computing deductions. A second use is statutory reporting, including the preparation of PRSI-related returns and the reconciliation of contribution classes and insurable weeks per employee.

Effectivity-aware queries are essential. A typical pattern retrieves the current row for an assignment:

  • SELECT * FROM pay_ie_prsi_details_f WHERE assignment_id = :p_assignment_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
  • Historical reporting replaces SYSDATE with the as-at date of interest.
  • Exemption auditing selects rows where exemption_start_date or exemption_end_date is not null within a payroll period.
  • Class distribution reporting groups by contribution_class and overridden_subclass across a pay period.

Related Objects

Because the mined classification is standalone, no enforced foreign keys are documented. The most significant related objects are therefore functional dependents and references:

Any extension or interface should perform DateTrack-aware reads and must not assume a single row per assignment.