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. |