User Calc Operators#
An operator denotes an action that is to be taken on the operands indicated. There are several different categories of operators:Arithmetic Operators#
For arithmetic operations the following operators are available:Rounding Operators#
After an arithmetic operation users may want to round the result using one of the following operators:- RDN Round Nearest
- RDU Round Up
- RDD Round Down
- TRNC Truncate
Conversion Operators#
Fields of one type may be converted to another with the following operators:- DATE Convert to a Date
- CHAR Convert to a Character
- NUM Convert to a Number
- WAGE Convert Wage to the Basis Indicated
Date Operators#
Date Operators available are:- DAY Day Portion of Date
- MTH Month Portion of Date
- YRS Year Portion of Date
- DBT Days Between Dates
- MBT Months Between Dates
- YBT Years Between Dates
Relative Date Operators#
Relative Date Operators give the ability to return the value of a date relative to another date. For example, if a Benefit plan should begin collecting premiums 1 month after hire date, a Relative Date Operator might be used to find the date that is Hire Date + 1 month. The variable defined must be a date.Operators available:
- BD Beginning of Day
- BW Beginning of Week
- EW End of Week
- BM Beginning of Month
- EM End of Month
- BY Beginning of Year
- EY End of Year
Comparison Operators #
Comparison Operators allow the UserCalc to compare two values.The operators available:
- EQ Equal to
- EQNL Equal to If Null
- ELPL Element Pay Line Values Operator
- PCPL Pay Component Pay Line Value Operator
- NE Not Equal to
- GTGreater Than
- GE Greater Than or Equal to
- NG Not Greater Than
- LT Less Than
- LE Less Than or Equal To
- NL Not Less Than
- IN In List
- NN Not in List
- IB In Between
- NB Not in Between
- LIKE Like
