Formula

Details

S_CARGAVER

Search items.

S_EPSEMPR

Calculate the EPS calculation base (RV_INSS == “S”), updating the mnemonic NBSEPSEMPR.

For the full salary, consider only 70% of the calculation base.

Search the company's percentage in the EPS Percentage table.

Search the EPS roof. If the roof is lower than the calculation base the roof becomes the calculation base (update the mnemonic NBSEPSEMPR).

Apply this percentage on the calculation base.

Update the mnemonic NEPSEMPR with the result.

S_GRVEPSEM

Add the values found in the EPS calculation base and EPS value to the object, using the calculation identifiers Company EPS Base and Company EPS, respectively.

S_AFPEMPR

Check in the employee file if he must discount pension (RV_JUBILAC == “2”).

If so:

Calculate the AFP calculation base, verifying all the items that fall upon AFP (RV_INSS == “S”) and the absence items not compensated, updating the mnemonic NBSAFPEMPR.

For the full salary, consider only 70% of the calculation base.

Search the AFP roof. If the roof is lower than the calculation base, the roof becomes the calculation base (update the mnemonic NBSAFPEMPR).

Search the percentage of the company and the employee in the Pension Fund.

Apply the company's percentage on the calculation base.

Update the mnemonic NAFPEMPR with the result.

S_GRVAFPEM

Add the values found in the AFP calculation base and AFP value to the object, using the calculation identifiers Company AFP Base and Company AFP, respectively.

S_FSPEMPRE

Employee in license not compensated.

Calculate the FSP calculation base, verifying all the items of absences not compensated, updating the mnemonic NBSFSPEMPR.

For the full salary, consider only 70% of the calculation base.

Search the FSP roof. If the roof is lower than the calculation base, the roof becomes the calculation base (update the mnemonic NBSFSPEMPR).

Search the company's percentage in the Pension Solidarity Fund table, converting the calculation base in minimum salary and verifying in which range is in the table.

Apply this percentage on the calculation base.

Update the mnemonic NFSPEMPR with the result.

S_GRVFSPEM

Add the values found in the FSP calculation base and FSP value to the object, using the calculation identifiers Company FSP Base and Company FSP, respectively.

S_ARPEMPR

Calculate the ARP calculation base, verifying all the items falling upon ARP (RV_RISCOS == “S”), updating the mnemonic NBSARPEMP.

Search the ARP roof. If the roof is lower than the calculation base, the roof becomes the calculation base (update the mnemonic NBSARPEMP).

For Full salary, apply 70% on the value found.

Search the company's ARP level in the table of parameter: minimum, initial or maximum.

Search the percentage according to the ARP fee.

Apply this percentage on the calculation base.

Update the mnemonic NARPEMPR with the result.

S_GRVARPEM

Add the values found in the ARP calculation base and ARP value to the object, using the calculation identifiers Company ARP Base and Company ARP, respectively.

S_BSPARAEM

Calculate the calculation base of the Social Insurance, all the items falling upon the Social Insurance (RV_PARAFIS == S), updating the mnemonic NBSPARAEMPR.

For Full salary, apply 70% on the value found.

Search the percentage of Compensation Cash, SENA and ICBF in the Social Insurance table.

Apply the percentage of Compensation cash and update the mnemonic NCAJAEMPR.

Apply the percentage of SENA and update the mnemonic NSENAEMPR.

Apply the percentage of ICBF and update the mnemonic NICBFEMPR.

S_GRVPARAF

Add the values found of the Calculation Base to Social Insurance, the Compensation Cash value, SENA and ICBF to the object, using the calculation identifiers Company Social Insurance Base, Compensation Cash, SENA – Learning Service and ICBF – Colombian Institute of Family Well-Being, respectively.