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:

• ADD Add
• SUB Subtract
• MLT Multiply
• DIV Divide
• MOD Modulus
• PRC Percent
• MAX Maximum
• MIN Minimum

---

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

---

Notes #

Click to create a new notes page