Home > Expression Operators > Benefit Formula Operators

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).