Returns the normalized value of a benefit formula, i.e., normalized to the value of the Primary benefit or Secondary benefit database field, as specified under the Terminated Vested Data topic of the Census Specifications (German pension mode only).

The #NormToNRB operator (when used in the benefit formula of a Benefit Definition) uses, for each terminated vested participant, the value in the Primary benefit field or Secondary benefit field to normalize the formula provided in the right argument of the operator. The primary benefit will be used when the operator uses a left argument that is omitted or 1; the secondary benefit will be used if the left argument is 2. Specifically, the calculated benefit at each age is multiplied by the ratio of the specified benefit value to the calculated retirement benefit amount as of the participant’s normal retirement date. If “<none>” is specified, no normalizing of the calculated benefits will be done (i.e., #NormToNRB will do nothing). If the relevant benefit is missing on the database for some records, the effect is the same as specifying “<none>” for those records. Please note that for active participants, the #NormToNRB operator will have no impact (i.e., will return its argument). This operator therefore allows the user to model the relative accrual pattern of benefit formulas while maintaining consistency with known retirement benefits for terminated vested participants.

Syntax:

#NormToNRB Formula; or

1 #NormToNRB Formula; or

2 #NormToNRB Formula

Tip:

When setting up a benefit formula containing the #NormToNRB operator, setting a temporary variable equal to the argument of the operator may be helpful when viewing the sample life results.

Example:

Assume the following benefit formula:

#NormToNRB (ACCRUED * ERF)

If the normal retirement age is 65, the Benefit at Normal Retirement Date in the Census Specifications is 45,613.83, and the formula evaluates to 17,656.94 at age 65, then the sample life report for the Benefit Definition would be developed as follows: 

Year	Age	Accrued	ERF	NRB	Accrued * ERF	Formula Benefit
2010	60	15593.58	0.70	45613.83	10915.50	28198.44
2011	61	16033.31	0.76	45613.83	12185.32	31478.79
2012	62	16439.22	0.82	45613.83	13480.16	34823.80
2013	63	16845.12	0.88	45613.83	14823.71	38294.65
2014	64	17251.03	0.94	45613.83	16215.97	41891.32
2015	65	17656.94	1.00	45613.83	17656.94	45613.83

 

1. The NRB column above shows the value specified as the Primary or Secondary benefit in the Census Specifications Terminated Vested Data topic. (Unless it is used in the formula elsewhere, this value would not typically be shown in the sample life report.)

2. The Accrued * ERF column shows the benefit formula prior to any adjustment from the #NormToNRB operator. In most cases, this would not be explicitly shown in the sample life report. For checking purposes, it may be helpful to employ the tip above and use a temporary variable to see this value explicitly:
   T := ACCRUED * ERF &
   #NormToNRB T
   Also note that if there had been no specified Benefit at Normal Retirement Date (either because of a blank database value or <none> specified in the Census Specifications), this would be the end result of the formula.

3. The Formula Benefit column shows the end result of this formula. The prior column has been adjusted by the ratio of 17656.94/45613.83.