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). |
| #NoAttrib | Returns the full value of a component, with no attribution or other adjustments for UC or PUC. |
| #NormToNRB | Returns the normalized value of a benefit formula (German pension mode only). |