Other Benefits Tables

After configuring a benefit in the Benefits Settings module, the user must also complete the table which contains all benefit values.
All figures included in this table depend on how the Base Amount has been setup. For example, if the base is an hourly rate, then the table values must be hours. If the base is a daily wage, then the values must be expressed in days.

However, the system also offers the user the option to set table values as a percentage of the Base Amount. Every table is made up like a regular spreadsheet: Horizontal rows refer to different levels of employee seniority, and column headers display a particular employee categorization. This allows the flexibility of taking into consideration things like length of service in the company or the category of employee job title when making the benefit calculation.

Configuring a new Benefits Table:

Go to Maintenance. Select Benefits Tables, and click on Other Benefits Tables.
Review and/or complete the following fields:
- Pay Period: The system stores the table used in every pay period in order to keep historical information. When a new pay period starts, the table is automatically created with all values stored from the previous pay period.
- Company Code: It is the two to four-character code used to identify the particular ACS site or office.
- Benefits Code: It is the code which has been previously set to identify the particular employee benefit.
- Category Type: Selecting a Category Type is necessary. This is the parameter which defines the table columns. It allows to select one category from the system with the purpose of filtering employees and calculate a corresponding amount of benefit depending on that criteria. If the benefit amount depends on employee seniority only, or it is the same for ALL employees, it is recommended to select SYSCAT (System Category).
- LOS Level on: LOS stands for Length of Service, and it reflects employee seniority.This parameter defines the table rows. Use may select from Days, Weeks, Months or Years. The field "caclulated to the" provides user with the option of setting a particular time or date for LOS calculation (see Reference 1). If benefit will be paid on a yearly bases, it is recommended to select "Current Year End Date". In case the benefit is paid in every pay peiod, the user should select "Current Pay Period End Date".
- LOS Search Criteria: When employee seniority is calculated, this parameter defines if benefit calculation must be paid depending on full or partial years of service. User must select one of the following options:
- - Based on Last Anniversary Date
  - Based on Next Anniversary Date
- Table Operation: It sets the relationship between the payment base and the table values. User must select one of three options:
- - Percentage. This operation converts the table values in percentages which are applied to Base Amount.
  - Multiplication. This operation simply multiplies every table vaule by Base Amount. Therefore, if the base is an hourly rate, the table values must be in hours. If the base is a daily wage, then table values must be in days, and if the base is a monthly salary, then table values must be in months.
  - Division. This operation converts all table values in a divisor for Base Amount. This option is rarely used.
- Prorated Calc: Clicking on this checkbox will allow user to configure certain settings to obtain prorated benefit amounts. Two factors are involved in this calculation:
- - Total Calc - User must set the criteria for obtaining 100% of the benefit .
  - Prorated Calc - User must set the criteria for obtaining part of the benefit.
  - Both of the aforementioned parameters provide drop down menus so the user can select one of the following options:
    - Custom Days. It is a given number of days.
    - All Days. It is the total calendar days in the specified period of time.
    - Working Days. It is the total days covered by employee contract during the specified period of time.
    - Worked Days. It is the total employee worked days during the specified period of time, paid leaves and rest days included. Only absences are excluded.
    - Attendance Days. It is the total employee worked days during the specified period of time. All incidences and rest days are excluded.
    - Custom Months. Its is a given number of months.
    - Worked Months (PH). It is a customized calculation to fit the Philippines benefits pay guidelines.
- Benefits Table: It is a chart where all benefit values are shown. As it was stated before, every row represents a different seniority level, meanwhile every column header will show the selected Category Type.
- - Column "Level #". Each level of seniority is represented by a consecutive number.
  - Column "LOS Upper Level". User must set the top seniority level for that particular level.
  - All other columns are created based on the selected Category Type, and user must set the benefit for each one of them. If any value is set to 0 (zero), this will mean all employees who fall under that category are not eligible for that benefit.
  - Add Five Records. Every new table will show 10 levels (rows). If user only needs to complete three levels and then saves the table, then the other seven rows will disappear and the table will only show the three rows which were completed. This button gives the user the option to create five additional rows in the table if necessary.
  - Delete Five Records. If user clicks on this button, then the five records (rows) on the bottom of the table will disappear.

Reference 1
Current Period Start Date	It is the first day of company current pay period.
Last Period Start Date	It is the final day of company current pay period.
Current Date	It refers to today's date. When the process is is run, the system will consider the server current date at that time.
Current Month Start Date	It is the first day of current pay period month.
Last Month Start Date	It is the first day of the previous month from the current pay period.
Current Year Start Date	It is the first day of the current pay period year.
Last Year Start Date	It is the first day of last year from current pay period year.
No Start Date	It means that Start Date will not be considered. Therefore, if an End Date is set, that will mean that any date lower or equal as End Date will apply.
Current Period End Date	It is the final day of the company current pay period.
Last Period End Date	It is the final day of the previous closed pay period in the company.
Current Month End Date	It is the final day of the current pay period month.
Last Month End Date	It is the final day of previous month from current pay period.
Current Year End Date	It is the final day of the current pay period year.
Last Year End Date	It is the final day in the previous year from current pay period.
No End Date	It means that End Date will not be considered. Therefore, if a Start Date is set, it will mean that any date equal or greater than start date will apply.