Home > Calculation Setup > Plan Definitions > Calculated Dates

Calculated Dates

The Calculated Dates topic allows you to compute various dates that can then be used throughout the benefit calculation. These dates are calculated after the participant data has been loaded, defaulted and validated, but before any benefits are calculated. You could, for example, calculate the date of participation or an early retirement date, and then use it in any expression (except Data Default expressions) to control the benefit calculation.

Calculated Dates are added to the set of calculation dates when:

The Calculated Dates dialog presents a summary of the date calculations including the Order, Data Dictionary Field name, Description and list of calculation types that Use as BCDate. Similar to standard ProAdmin libraries, the right side of the dialog has New, Edit, Copy and Erase buttons to manage the date definitions. There is also a Reorder button to control the order when there are multiple definitions for the same field. ProAdmin will automatically check dependencies and insure that if, for example, DOP is needed to calculate NRD, then DOP is calculated first. If you choose to Suppress all commencement dates after, the multi-choice field allows you to choose from the existing Calculated Dates that are used as commencement dates for calculations. Any commencement dates, calculated or entered manually, will be ignored if they are later than the selected calculated commencement date.

To define a Calculated Date, you need to specify:

If you choose to Calculate date when this Eligibility Definition is met:, the multi-choice field allows you to choose from the Eligibility Definition library entries unhidden in the current Project. The associated Using Service Definition Set: multi-choice field allows you to choose from the Service Definition Set library entries unhidden in the current Project. Click the associated button to edit an existing entry or add a new entry to either of these library.

If you choose to use a Standard calculated date, the available options are: Plan Definition normal retirement date, Social Security normal retirement date, Minimum required distribution date, or April 1 of year following age 70 1/2. The normal retirement date is determined by evaluating the eligibility and service selected for Normal Retirement Date (NRD) within the Plan Definition Plan Attributes. Social Security normal retirement date is the first of the month when an unreduced benefit would be paid (e.g., for someone born 6/17/1991, they reach age 67 in 6/2028, but their first unreduced payment would be 7/1/2028; this is what ProAdmin uses here). Minimum required distribution is the April 1 following attainment of age 70 ½ if attained by 12/31/2019, or the April 1 following the calendar year of attained age 72 if birth year is 1950 or earlier, age 73 if birth year is 1951-1959, or age 75 if birth year is 1960 or later. April 1 of the year following age 70 ½ allows you to more easily program the date after which actuarial increases are due to all active participants regardless of their minimum required distribution dates.

Optionally, you can specify to Use as commencement date for Estimates, Final calculations or All estimated and final calculations. If the calculated commencement date is prior to the decrement date entered, it will be disregarded.

You can have multiple Calculated Dates using the same date field.

You can put a Calculated Date in an Output Definition by defining an Input Pass Thru that retrieves its value from the Data Dictionary field holding its calculated value.