Health Care by Age Group
For the employee health care deduction calculation in the payroll, by age group, the S009 table is considered to determine the group values, so that the deduction is proportional to the employee and his dependants' ages, as per the Employee and Dependent Register.
Field |
Description |
Details |
Code |
Code |
Enter the code of Health/Dental Care Plan to be associated with the employee. As it is concerning age group, the codes must be repeated to define groups. |
Desc |
Description |
Description of Health/Dental Care Plan. |
Ageto |
Age To |
Employee age group to define plan value and deduction percentage. |
Holvl |
Holder Vl. |
Enter the plan value for the holder (employee). |
Depvl |
Depen. Vl. |
Register the plan value for each dependent associated with the employee. |
HMvl |
Hous. Member Vl. |
Define the plan value for the employee's household members. |
Holperc |
Hold. Deduct. % |
Enter the deduction percentage according to the holder (employee) value. This percentage defines the employee deduction and the value paid by the company. |
Depperc |
Depen. Deduct. % |
Enter the deduction percentage for each dependent associated with the employee according to the dependent value. This percentage defines the employee deduction and the value paid by the company. |
HMperc |
Hous. Mem. Deduct. % |
Enter the deduction percentage for household members associated with the employee according to the household member value. This percentage defines the employee deduction and the value paid by the company. |
Provcd |
Provider Code |
Enter the code of Health/Dental Care Plan Provider - according to the registers from tables S016 and S017. |
Example:
Health Care by Age Group Table:
Seq. |
001 |
002 |
003 |
004 |
005 |
006 |
007 |
008 |
Code |
01 |
01 |
01 |
01 |
02 |
02 |
02 |
02 |
Description |
Basic Plan |
Basic Plan |
Basic Plan |
Basic Plan |
Master Plan |
Master Plan |
Master Plan |
Master Plan |
Age To |
6 |
20 |
50 |
999 |
6 |
20 |
50 |
999 |
Holder Vl. |
60,00 |
100,00 |
130,00 |
180,00 |
100,00 |
115,00 |
148,00 |
210,00 |
Depen. Vl. |
70,00 |
110,00 |
140,00 |
190,00 |
115,00 |
125,00 |
168,00 |
230,00 |
Hous. Member Vl. |
80,00 |
120,00 |
150,00 |
200,00 |
125,00 |
135,00 |
178,00 |
245,00 |
Hold. Deduct. % |
7,000 |
7,000 |
7,000 |
7,000 |
12,000 |
12,000 |
12,000 |
12,000 |
Depen. Deduct. % |
12,000 |
12,000 |
12,000 |
12,000 |
18,000 |
18,000 |
18,000 |
18,000 |
Hous. Mem. Deduct. % |
20,000 |
20,000 |
20,000 |
20,000 |
40,000 |
40,000 |
40,000 |
40,000 |