Creating Deduction Assignments for Loan Schedules

After you define a loan schedule, the system creates a deduction assignment for each loan schedule. This is performed by a component interface. The process creates a link to the Element Assignment By Payee page using the following supporting elements.

Note: Make sure that each loan deduction you are using has a component reference name HC_GPMX_LOAN_GBL defined for it. You can define a component reference name for a loan deduction in Set Up HCM, Product Related, Global Payroll & Absence Mgmt, System Settings, Configuration by Element.

Field

Variable

Loan Number

PR VR NUM PRESTAMO

Total Amount

PR VR MONTO TOTAL

Date

PR VR FECHA

Payment Amount

PR VR PAGO

Infonavit % (only for INFONAVIT loans)

PR VR PCT INFONAV

Times Minimum Wage

PR VR NUM SAL MIN

All of these variables are used by the process to keep track of each loan balance separately. These variables are also used to calculate the deduction for each loan.

This topic outlines what you need to define in the deduction assignment for each loan type. You define deduction assignments on the Positive Input page in the core application.

See Understanding Positive Input.

Company Loans

The loan number, total amount, loan date, and payment amount must be defined on the Positive Input page.

Faltante de Caja

The loan number, loan date, and total amount must be defined on the Positive Input page. The legal ceiling is calculated to determine the monthly payment. The legal ceiling is based on the monthly salary wage zone.

INFONAVIT Loans

The loan number, loan date, total amount, and either percentage, payment amount, or number of minimum wages must be defined on the Positive Input page.

There are three different types of INFONAVIT loans:

  • By Percentage.

  • By Amount.

  • By x Minimum Wages.

To calculate By Percentage loans:

  1. Determine the initial SDI for the employee (bimonthly).

  2. Calculate the payment based on the number of minimum wage zone salaries and the loan percentage.

  3. Return the minimum between the payment and balance amount.

To calculate By Amount loans, find the minimum between the loan payment and the balance amount.

To calculate By x Minimum Wages loans, find the minimum between the Minimum Wage x Minimum Wage number and the balance amount.

FONACOT Loans

The loan number, loan date, total amount, and payment must be defined on the Positive Input page.

You'll prorate the payment between the monthly days in the period and multiply this factor by the worked days.