Skip to main content

​
Overview

Deletes a payroll record from tab_nomina by year, month, and period.

​
Signature

fun_delete_nomina(
    wano_nom INTEGER,
    wmes_nom INTEGER,
    wper_nom INTEGER
) RETURNS VOID

​
Parameters

​
wano_nom
INTEGER
required
Payroll year (Primary Key)
​
wmes_nom
INTEGER
required
Payroll month (Primary Key)
​
wper_nom
INTEGER
required
Payroll period (Primary Key)

​
Returns

VOID (no return value)

​
Example Usage

-- Delete a payroll record
SELECT fun_delete_nomina(2025, 1, 1);

-- Delete another payroll period
SELECT fun_delete_nomina(2024, 12, 2);

​
Validation Rules

  • The payroll record identified by year, month, and period must exist
  • All three components of the composite key are required
  • This will delete the payroll record but not the related novelties

​
Source

source/func/nomina/fun_delete_nomina.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us