Time clock systems by TimeIPS
Call Now! 316-264-1600
Information
Sales
Support
Knowledge Base Search:  
Main Menu
· Home

· Table of Contents
· Article Index

· Downloads
· New Features
· FAQ
· News
· Web Links

  
TimeIPS Knowledge Base

Table of Contents: Article IndexPrintable Version

Applies to versions: 2.0, 2.1, 2.2, 2.3, 2.4, 2.5



Advanced Modifications and Accruals using Expressions



Accruals and Modifications can be configured to calculate with an expressions for special situations.

Accruals

The accrual expression should return the amount of the accrual in seconds.

The following variables are available to the expression when calculating the accrual amount:

  • usersID - The ID of the user benefit accruals are being calculated for
  • benefitTypeID - The ID of the benefit type being calculated
  • begTimestamp - The timestamp of the beginning of the accrual range
  • endTimestamp - The timestamp of the end of the accrual range

Example:

An accrual policy grants 50 hours a year on Jan 1st each year.  And, for employees who where hired between Jan and June, an additional 8 hours is granted on Jul 1st.

  • This is a special rule because the amount accrued on Jul 1st is different than on Jan 1st and depends on the hire date of the employee.
  • To accommodate this, accruals would be set to run twice a year
  • The accrual amount would be set to Expression
  • The expression would be
    =if(date("m",[begTimestamp])=1,50*3600, /* this gives 50 hours if it is the Jan accrual */
    if(substr(employeeInfo([usersID], 'startDate'),6,2)<7,8*3600,0)) /* this looks at the month of the start date and, if it's less than 7 (Jan->Jun) then give 8 hours, otherwise none */

 

Modifications

The following variables are available to the expression when calculating the modification amount:

  • usersID - The ID of the user benefit accruals are being calculated for
  • benefitTypeID - The ID of the benefit type being calculated
  • begTimestamp - The timestamp of the beginning of the accrual range
  • endTimestamp - The timestamp of the end of the accrual range


See Also:
Accruals (2.0, 2.1, 2.2, 2.3, 2.4, 2.5)

©2004-2017 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.