Tables

Code

Description

 

S001

Health Promoting Companies (EPS) Master Table

It registers companies which provide health subsidy services, in cases of employee need. Associate the company with the employee using the Employee Register.

 

S002

Occupational Hazard Managing Agencies (ARP) Master Table

It registers companies which provide services referring to occupational hazards and compensate the workers in cases of incapacity or work-related accidents. Associate the company with the employee using the Employee Register.

 

S003

Pension Fund Managing Agencies (AFP) Master Table

It registers companies providing services related to employee retirement. Associate the company with the employee using the Employee Register.

S004

Family Compensation Funds Master Table

It registers companies which collect payments for providing services referring to the Family Compensation Fund Associate the company with the employee using the Employee Register.

S005

Severance Funds Master Table

It registers companies which receive and manage payments referring to Cesantía and perform the payment upon employee dismissal. Associate the company with the employee using the Employee Register.

S006

Voluntary Pension Managing Agencies Master Table

It registers companies which manage the payments referring to voluntary pensions. Associate the company with the employee using the Employee Register.

S007

Colombian Institute for Family Welfare (ICBF) Master Table

It registers the government agency which provides family welfare. Associate the company with the employee using the Employee Register.

S008

National Training Service (SENA) Master Table

It registers the government agency which promotes inclusion of youngsters into the job market and monitors the hiring companies. Associate the agency with the employee using the Employee Register.

S009

Work Centers (ARP) Master Table

It registers the Work Centers, which are used by the Occupational Hazards Agencies to classify employees. Associate the Work Center with the employee using the Employee Register and the codes released by the Centers to the Occupational Hazards Table.

S010

Crafts and Occupations Master Table

The National Training Service (SENA) provides the codes for crafts and occupations so that the companies may issue semestrial reports about their personnel.You must associate the employees with the codes using the Employee Register.

S011

Withholding Table

Table for calculating withheld income tax, i.e., directly withheld form the employee's wages. Register the ranges in UVT (Tax Value Unit), the Marginal Rates and the Effective Tax. It is used in the Payroll Calculation.

S012

Tax Value Unit (UVT)

It stores information which allows adjusting the values of taxes, sanctions and obligations determined by the Tax Statute.

S013

EPS Percentage Table

It stores deduction percentages applicable to the employees and the company in the Payroll Calculation routine. These amounts are destined to the Health Promoting Companies (EPS). Associate the deduction percentages with the employee using the Employee Register.

S014

Occupational Hazards Table (ARP)

It stores the hazard class and their corresponding percentages. Collection is the company's responsibility. Associate the hazard class and its respective deduction with the Employee Register, making it apply to the Payroll Calculation.

S015

Pension Funds Table (AFP)

Information for the Pension and Severance Fund. It stores the deduction percentage applied to employees (associate it with the Employee Register) and to the company, according to type, salary amount and ceiling. It affects the Payroll Calculation routine.

S016

Tax-related Percentage Table

Table containing the following fields: Compensation Fund Percentage; ICBF Percentage and SENA Percentage. It affects the Payroll Calculation routine.

S017

Solidarity Pension Fund Table

It registers rates and conditions. Associate the employee through the Employee Register to run the Payroll Calculation routine. Charges apply only to the employee.

S018

Transportation Allowance Table

It stores the transportation allowance amount to be paid to the employee. Enter the allowance in the Employee Register, which in turn affects the Payroll Calculation.

S019

Legal Minimum Wage Table

It registers the minimum wage value effective in the current year.It affects the Payroll Calculation routine.

S020

Ceiling Table

It stores EPS, AFP, FSP and ARP contribution ceilings.

S021

Company Parameter Table

In the company parameters, create the association with the corresponding agencies (Occupational Hazards, SENA and ICBF).

S022

Types of Contract Table

It registers the types of contract in effect for the company's labor relationships. Associate the contract type with the employee in the Employee Register.

S023

Contract Purpose Table

The Contract Purposes are related to the Types of Contract. They must also be associated to the employee through the Employee Register.

S024

Types of Termination Table

It registers the types of termination pertaining to the company and their variants, such as whether any of them provides for compensation payment.

S025

Compensation Table

It contains the data which, when combined, generate the compensation amount, according to the termination type.

S026

Compensation Tax Withholding Table

It contains the information pertaining to income tax withholding on the compensation amount, paid in the case of termination.

S027

Income & Withholdings Statement Items

This table defines to which group of the Income and Withholdings Statement the item belongs, using the Payroll Item Register.

S028

Departments Table

It records the company's departments.

Associate the departments with the employee in the Employee Register.

S029

Life Insurance Table

It determines the Life Insurance benefit for the employees, whose deduction applies both to the employee and the company. Associated with the Employee Register.

S030

Type of Movement Professional Career

It is the classification of different movements registered among employees and generate transactions in the path employees. Linked to the Employees Register.

S031

Types of Absences

It is the classification of different absences the employee may have in the period.

S032

Schedule

Define schedule type: Commercial, when considered 360 days in the year (each month with 30 days), or Civil, considering the 365 days.

S033

Types of Contract for formulation

Define types of contract for the employee, there are many hiring modalities that fulfill different purposes or objectives. It may be verbal or written: it is convenient to be a written contract to have proof of the agreements. Linked to the Employee Register.

S034

Auxiliary Accumulator

Helps on the calculation in PILHA, mainly as effect for indemnification for pregnancy, vacation, non-salary payments and transportation voucher calculation.

S037

Yes or No

Self-explanatory table.