Results for “ssp_stoppages”

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

Overview

SSP_STOPPAGES is a transactional table in the Oracle E-Business Suite schema SSP (Social Security/Statutory Payments), which supports statutory absence processing such as maternity, adoption, paternity, and sick pay. The table records periods of non-entitlement to a given element — that is, intervals during which an employee is not entitled to a payment or absence element, or during which withholding from a payment is applied. It is the central repository for stoppage records that determine how statutory absences are treated for payroll and entitlement calculation, particularly in the context of maternity processing and withholding reason codes. ETRM documents the object as VALID in the SSP schema and confirms a 15-column physical layout in release 12.2.2.

Based on the foreign-key structure mined from the ETRM relationship data, the heuristically derived Data Vault classification for this object is link. It is a link because it resolves relationships between an absence/attendance record, a maternity record, and a withholding reason, rather than storing a descriptive business attribute set. This classification should be treated as a modeling suggestion only; the table also carries its own transactional attributes, so in practice it behaves as an intersection table with satellite-like properties.

Key Information Stored

The primary key is SSP_STOPPAGES_PK, defined on STOPPAGE_ID, the surrogate identifier for each stoppage row. The unique index on STOPPAGE_ID is the only documented business-key candidate; no alternate unique business key is defined in the supplied metadata.

• STOPPAGE_ID — surrogate primary key; single-row identifier used by downstream payroll and absence routines.
• ABSENCE_ATTENDANCE_ID — foreign key to PER_ABSENCE_ATTENDANCES, tying the stoppage to the employee's absence record.
• MATERNITY_ID — foreign key to SSP_MATERNITIES, linking the period of non-entitlement to a specific maternity record.
• REASON_ID — foreign key to SSP_WITHHOLDING_REASONS, classifying why entitlement is withheld.
• WITHHOLD_FROM / WITHHOLD_TO — the effective start and end dates of the withholding interval.
• OVERRIDE_STOPPAGE — flag indicating that an automatically derived stoppage has been manually overridden.
• USER_ENTERED and EMPLOYEE_NOTIFIED — audit attributes indicating manual entry and whether the employee was notified.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the ORM layer.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns for change tracking.

Common Use Cases and Queries

Typical reporting scenarios include identifying all stoppages for an employee's absence, reviewing cases where a manual override was applied, and reconciling withholding reasons against payroll output. A representative query joining the parent absence record is:

SELECT s.stoppage_id, s.absence_attendance_id,
       s.withhold_from, s.withhold_to, s.reason_id,
       w.reason_name
FROM   ssp.ssp_stoppages s,
       ssp.ssp_withholding_reasons w
WHERE  s.reason_id = w.reason_id
AND    s.absence_attendance_id = :p_absence_id;

For maternity reporting, join MATERNITY_ID to SSP_MATERNITIES to obtain the maternity reference alongside the stoppage window. Audit-style queries count rows where OVERRIDE_STOPPAGE = 'Y' to monitor manual intervention, while notification tracking filters on EMPLOYEE_NOTIFIED. Because the table is link-centric, date-range reporting on WITHHOLD_FROM and WITHHOLD_TO is the most common aggregation pattern.

Related Objects

• PER_ABSENCE_ATTENDANCES — referenced via ABSENCE_ATTENDANCE_ID; source of the absence event.
• SSP_MATERNITIES — referenced via MATERNITY_ID; parent maternity record.
• SSP_WITHHOLDING_REASONS — referenced via REASON_ID; reason-code lookup.
• SSP_STOPPAGES_PK — the primary key constraint and supporting unique index on STOPPAGE_ID.

The SSP module's absence and payment processes depend on this table to determine periods of non-entitlement, making it a required join point whenever statutory absence entitlement or withholding is reconciled against payroll results.