This page (revision-24) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
24 26-Nov-2021 10:22 2 KB RForbes to previous
23 26-Nov-2021 10:22 2 KB RForbes to previous | to last
22 26-Nov-2021 10:22 2 KB JEscott to previous | to last
21 26-Nov-2021 10:22 2 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
UC OPERATORS
UC OPERATORS

Version management

Difference between version and

At line 1 changed 82 lines
[{TableOfContents }]
!!!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|ADD_OPERATOR]
* SUB [Subtract|SUB_OPERATOR]
* MLT [Multiply |MLT_OPERATOR]
* DIV [Divide|DIV_OPERATOR]
* MOD [Modulus|MOD_OPERATOR]
* PRC [Percent|PRC_OPERATOR]
* MAX [Maximum|MAX_OPERATOR]
* MIN [Minimum|MIN_OPERATOR]
----
!Rounding Operators
After an arithmetic operation users may want to round the result using one of the following operators:
* RDN [Round Nearest|RDN_OPERATOR]
* RDU [Round Up|RDU_OPERATOR]
* RDD [Round Down|RDD_OPERATOR]
* TRNC [Truncate|TRNC_OPERATOR]
----
!Conversion Operators
Fields of one type may be converted to another with the following operators:
* DATE [Convert to a Date|DATE_OPERATOR]
* CHAR [Convert to a Character|CHAR_OPERATOR]
* NUM [Convert to a Number|NUM_OPERATOR]
* WAGE [Convert Wage to the Basis Indicated|WAGE_OPERATOR]
----
!Date Operators
Date Operators available are:
* DAY [Day Portion of Date|DAY_OPERATOR]
* MTH [Month Portion of Date|MTH_OPERATOR]
* YRS [Year Portion of Date|YRS_OPERATOR]
* DBT [Days Between Dates|DBT_OPERATOR]
* MBT [Months Between Dates|MBT_OPERATOR]
* YBT [Years Between Dates|YBT_OPERATOR]
----
!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|BD_OPERATOR]
* BW [Beginning of Week|BW_OPERATOR]
* EW [End of Week|EW_OPERATOR]
* BM [Beginning of Month|BM_OPERATOR]
* EM [End of Month|EM_OPERATOR]
* BY [Beginning of Year|BY_OPERATOR]
* EY [End of Year|EY_OPERATOR]
----
!Comparison Operators
Comparison Operators allow the UserCalc to compare two values.
The operators available:
* EQ [Equal to|EQ_OPERATOR]
* EQNL [Equal to If Null|EQNL_OPERATOR]
* ELPL [Element Pay Line Values Operator|ELPL_OPERATOR]
* PCPL [Pay Component Pay Line Value Operator|PCPL_OPERATOR]
* NE [Not Equal to|NE_OPERATOR]
* GT[Greater Than|GT_OPERATOR]
* GE [Greater Than or Equal to|GE_OPERATOR]
* NG [Not Greater Than|NG_OPERATOR]
* LT [Less Than|LT_OPERATOR]
* LE [Less Than or Equal To|LE_OPERATOR]
* NL [Not Less Than|NL_OPERATOR]
* IN [In List|IN_OPERATOR]
* NN [Not in List|NN_OPERATOR]
* IB [In Between|IB_OPERATOR]
* NB [Not in Between|NB_OPERATOR]
* LIKE [Like|LIKE_OPERATOR]
----
![Notes|Edit:Internal.UC+OPERATORS]
[{InsertPage page='Internal.UC+OPERATORS' default='Click to create a new notes page'}]
Operator
An Operator denotes an action that is to be taken on the Operands indicated.
There are several different categories of Operators:
Arithmetic Operators
Add
Subtract
Multiply
Divide
Percent
Modulus
Minimum
Maximum
Rounding Operators
Round to the Nearest
Round Down
Round Up
Truncate
Conversion Operators
Convert to a Date
Convert to a Character
Convert to a Number
Convert Wage to the Basis indicated.
Date Operators
Day portion of Date
Month portion of Date
Year portion of Date
Days between Dates
Months between Dates
Years between Dates.
Relative Date Operators
Beginning of Day
Beginning of Week
End of Week
Beginning of Month
End of Month
Beginning of Year
End of Year.
Comparison Operators
Equal to
Not Equal to
Greater than
Greater than or Equal to
Not Greater than
Less than
Less than or Equal to
Not Less than
In List
Not in List
In Between
Not in Between
Like
This page (revision-24) was last changed on 26-Nov-2021 10:22 by RForbesTop