Benefit Formula Operators
Click the name of an operator to learn more:
#MAXBEN | Returns the U.S. Internal Revenue Code Section 415(b) maximum benefit deferred to Age. |
#CANMAX | Returns the Canadian ITA maximum pension deferred to Age, based on service according to left argument. |
#EQCY | Returns 1 if the calendar year is equal to Year (4 digits), otherwise 0. |
#GECY | Returns 1 if the calendar year is greater than or equal to Year (4 digits), otherwise 0. |
#GTCY | Returns 1 if the calendar year is greater than Year (4 digits), otherwise 0. |
#LECY | Returns 1 if the calendar year is less than or equal to Year (4 digits), otherwise 0. |
#LTCY | Returns 1 if the calendar year is less than Year (4 digits), otherwise 0. |
#NECY | Returns 1 if the calendar year is not equal to Year (4 digits), otherwise 0. |
#ENTRYYEAR | Returns the year of plan entry for new entrants during a forecast. |
#VALYEAR | Returns the valuation year (year beginning on the valuation date) of the liability measurement. |
#DECAGE | Returns decrement age, i.e., age on the anniversary of the valuation date in the year of decrement, unrounded (OPEB mode only) |
#DECPTS | Returns points (decrement age + service at decrement), unrounded (OPEB mode only) |
#DECSVC | Returns service at decrement, i.e., service as of the anniversary of the valuation date in the year of decrement, unrounded (OPEB mode only) |
#DECYEAR | Returns the calendar year of the anniversary of the valuation date in the year of decrement, e.g., 2010 (OPEB mode only) |
#PMTAGE | Returns payment age (after decrement), i.e., age on the anniversary of the valuation date in the year of payment, unrounded (OPEB mode only) |
#PMTYEAR | Returns the calendar year of the anniversary of the valuation date in the year of payment (after decrement), e.g., 2020 (OPEB mode only) |
#ReserveEE | Returns the total reserve for employee insurance contracts defined in the Plan Definition (universal mode only). |
#ReserveER | Returns the total reserve for employer insurance contracts defined in the Plan Definition (universal mode only). |
#ReserveEEPS | Returns the total reserve for participation (profit sharing) portions of employee insurance contracts defined in the Plan Definition (universal mode only). |
#ReserveERPS | Returns the total reserve for participation (profit sharing) portions of employer insurance contracts defined in the Plan Definition (universal mode only). |
#NormToNRB | Returns the normalized value of a benefit formula (German pension mode only). |