Main Logo
SIMPLIFY PENSION ADMINISTRATION
PENSIONSOFT CHANGE LOG
2017 DB PRECISION UPDATES
Version 2017.17.12.7 - Released 12/22/2017

• MP-2017 Projection Table Added: adds support for the recently published MP-2017 mortality improvement table.

• Person Worksheet and Level Income Option: includes ability to view/edit social security level income option benefit items within a Person Worksheet.

• Service Calculation Output Display: corrects issue with service output display where extra service breaks with a start date that is greater than end date could appear for back-to-back service periods.

• Service Periods: for back-to-back service elapsed time service periods, combines these periods into one period.

• Missing Beneficiary SSN Validation: corrects issue where this validation was incorrectly displayed.

• Weekly Hours Equivalency: changes calculation of weekly hours equivalency to properly credit hours for partial weeks.

• Social Security PIA: includes new option to not allow PIA payment start date to precede the benefit calculation's payment start date.

• Portal Usage Statistics: corrects problem that was causing the participant login count to not appear on the portal usage statistics page.

• Joint-life Annuity Factors and Segment Rates: fixes issue where joint-life annuity factors could be very slightly understated if determined using segment rates.

• Enhanced Tooltips on Main Window: includes enhanced tooltip display on the main window tabs.

• Document Archives: moves document archives to the main window tabs for participants and plan sponsors.

• Import of Date Received: validates format of Date Received on import to avoid possible save errors during the completion of import for a sponsor.

• GETEARLYADJUST Function: includes this new function for determining actuarial equivalent early reduction.

• Person Worksheet Description: description can now be specified for Person Worksheets.

• Person Worksheet Valuation Date: valuation date may now be defined for a Person Worksheet as a variable date (latest snapshot for example) rather than only as a fixed date.

• Updated Architecture: has been updated to use the latest Microsoft architecture and therefore will require a full reinstall.

• Hours Bank Target: allows for the specification of a per-period hours bank target.

• Hours Bank Service Limit: provides ability to limit service resulting from hours bank withdrawals.

• Person Worksheet Reorder: allows for drag and drop on columns list.

• Middle Initial Export: provides ability to export the middle initial when exporting name.

• Benefit Payment Display: includes deferred indicator on the list of benefit payments on the Person Benefit Payment Information screen.

• Function of Service Detail: additional unit-by-unit detail for function of service periods may now be exported.

• Export of Account Number: add ability to export account numbers that are greater than 12 characters in length.

• Person Notes and Change Log: changes to Person Notes are now recorded in the participant transaction log.

• Semi-monthly Amounts: changes the way that semi-monthly amounts are projected such that the projection periods are consistently created on the proper start and end dates.

• Late Retirement Actuarial Increases: includes a new method for developing actuarial increases that interpolates inter-age rates based upon integer-age late increase factors.

• iManage Integration: corrects for problems resulting from using DB Precision with iManage.

• Opening Read-only Files: handles issues with certain network configurations where DB Precision is unable to open some Word documents that are read-only.

• NETWORKINGDAYS Function: adds a new function for calculating the number of working days between two dates.

• New Plan Wizard: includes new alert when export documents already exist in order to prevent accidental overwriting of existing documents.

• New Plan Wizard: fixes issue where the application would fail if service at conversion is to be used but no reported amount is selected.

• Minimum Distribution Excel Extract: properly opens the Excel extract when requested (consistent with all other extracts).

• GETBENLATEST: adds new option to retrieve the original gross annual benefit when using the GETBENLATEST function.

Version 2016.17.11.6 - Released 11/6/2017

• 2018 417(e)(3) Mortality: updated to include 2018 417 mortality rates.

• Benefit Calculations: includes changes to the calculation screen that splits the plan items list into two lists in order to provide users with item selection by category.

• New Plan Sponsor and Change Log: corrects error message that could display when saving a new plan sponsor.

• Error Message Displayed upon Closing in Windows 7: fixes issue in Windows 7 where an error message would be displayed upon application close.

• Import of Reported Amounts Prior to Hire Date: correct issue that could cause the import to get stuck on a Person that had a large number of Reported Amounts that were prior to original hire date.

• Import Speed: includes changes that improve the speed of importing data.

• Average Earnings Units Grouping: corrects problem with last release and item grouping which would occur when the averaging units available were less than the averaging period.

• Portal Worktrack Task Type Selection: adds support for specification of Worktrack task type when a task is created on the portal.

• Change Logs: now includes Grid button on sponsor and plan change logs for easier copy/paste of page items.

• Cancelled Worktrack Task and Duplicate Requests: when checking for the existence of duplicate requests, now properly ignores cancelled tasks.

• Worktrack Request Limits: includes new option when limiting Worktrack requests to include lifetime maximums.

• Person Worksheet Benefit Editing: when changing a payment start date using a Person Worksheet, the corresponding date that appears on the benefit history will now also change.

• Storing Calculation and Export Inputs: corrects issue when saving calculation inputs for a person who had not yet been calculated within a session where the reported amount assumptions would not save, resulting in inputs that could then later not be loaded.

• Adding Reported Amounts: includes a check to make sure that users do not add new Reported Amounts to a sponsor when participants from that sponsor are open (previously this could cause problems when entering new Reported Amount data for those participants).

• Copying/Pasting Export Definitions: fixes problem occuring after copying and then pasting an export definition and saving the document when a person was open. Prior to this release, this could cause the delimited file to then have invalid line breaks.

• COLA Frequency Options: now allows for the specification of non-annual COLA increases for both Annuity and Conversion Factor definitions.

• COLA Type: now allows for the specification of both simple and compound COLA increases for both Annuity and Conversion Factor definitions.

• Late Retirement Printout: displays late retirement benefits as monthly amounts when printing calculation detail to be consistent with other benefits shown.

• Average Earnings Units Grouping: includes efficiency improvements for when the average earnings grouping option is selected.

• Export of Benefit Payment Information: treats both payment forms and the 1099-R codes as numeric values allowing for numeric-to-text conversion of these amounts on export.

• Administrator Portal Logins: properly filters out plan sponsors that do not have the portal enabled for the list of possible sponsors that an administrator can open on the portal.

• Benefit Payment Screen: removes tabbed interface for benefit increases and replaces with list of benefits for easier entry and viewing.

• Export Wizard: allows for specification of Account Definition details within the wizard (previously only the account balance could be selected).

• Data Cleanup Wizard Transactions: these are now assigned a separate entry type (prior to this release, data changes made by the wizard were treated as manual changes).

• Transaction Detail for Benefit Changes: transaction detail now shows the amount for both new benefit payments and new benefit payment history.

• Portal Transactions: includes new screen that allows users to view all transactions made through the portal during some period.

• Snapshots and Unreasonable Earnings Amounts: corrects issue where an unreasonable earnings amount within the average earnings array of a person when running a snapshot would previously stop the snapshot from running.

Version 2016.17.10.3 - Released 10/3/2017

• Sponsor Change Log: records all changes made to a Plan Sponsor in a new log that is then viewable within that sponsor.

• Plan Document Change Log: records all changes made to a Plan Document in a new log that is then viewable within that document.

• Sponsor Portal Security Screen: corrects display issue with the last release where participant email address would not appear correctly for participants with no email.

• Worktrack Requests: includes an additional check when a Worktrack request is made to ensure that the requestor is a participant in the plan.

• Worktrack Request Email: if a sponsor has more than one plan, now includes plan number in the email sent when a Worktrack task is first created.

• Data Request - Historical Dates: includes option to display up to 3 historical dates other than hire/term dates (such as contributory start date) that will then appear on the data request.

• Data Request - Deferred Return of Contributions: a new tab on the data request has been created for participants that are due a return of contributions (such participants had previously been included on the Terminated Vested tab).

• Internet Portal Usage Statistic: corrects an overstatement of the count of the number of users logging in during a period. Prior to this release, the creation of a user was being treated as a log in event resulting in count overstatement.

• Calculation Results: when displaying calculation results where an item cannot be calculated as of the calculation date, a message indicates this prior to displaying results (prior to this release, the result would not appear in the result leading the user to need to draw this conclusion on his/her own).

• Age-based Late Retirement Factor Limit: replaces the static late retirement factor reasonability check with an age-based limit to remove the risk of this limit stopping calculations for much older individuals.

• Export Messages: when there are multiple messages (warnings or information) for an export of the same type, those messages are combined into a single message (prior to this version, only one message would display).

• Portal Worktrack Requests: prohibits participants that have been cashed out or are deceased to make a request through the portal.

• Average Earnings Bi-weekly Pay Units: adds support for a new averaging unit for bi-weekly pay.

• Average Earnings Units Grouping: includes a new option to group non-annual averaging units by year when determining average earnings.

• Service Accruals and Group Codes: makes improvements in calculation of service accrual when Reported Amount group codes are used such that stop dates and transfers are better reflected.

• Portal Beneficiary Editing: supports editing of non-primary beneficiary data.

• Form 8955-SSA: includes new tool to automate the process of determining information submitted on the Form 8955-SSA.

• Portal Benefit Payment Editing: supports editing of benefit payment information from within the portal as well as allows for the display and editing of a benefit payment's deferred indicator.

• Deferred COLA Option: contains ability to specify a deferral period for a COLA for both annuity factors as well as conversion factors.

• Conversion Factor Popup Indicator: corrects issue where the conversion factor popup indicator was incorrectly disabled for some definitions.

• Remote Support: includes our remote support tool directly in the application for easier support access.

• SSN Changes on Import: corrects problem which could cause DB Precision to fail on an import when that import included SSN changes.

• QDRO Participants and Lifecount Reconciliation: includes new footnote that identifies QDRO participants on the lifecount reconciliation.

• GETDETAIL Function and Accounts: corrects issue where transactions classified as "Account Interest" were being treated as normal deposits rather than interest deposits when using the GETDETAIL function.

Version 2016.17.8.15 - Released 08/15/2017

• Prior Year Benefit Payments: fixes issues with last release when determining this amount on the snapshot where there were problems with non-level annuities, sponsors with multiple plans, and sponsor with no prior snapshots.

• Sponsor Document Screen: corrects issue on the Sponsor Document screen when there are Document Dates, where certain items on the screen were then not being properly populated.

• Actuarial Equivalence and Pre-retirement Mortality: allows for the specification of separate pre-retirement mortality for Actuarial Equivalence when calculating annuity factors that include a deferral period.

• Existing Plan Wizard: adds functionality for creating standard exports (benefit statements, benefit calculations, and election forms) to the Existing Plan Wizard (previously, this functionality only existed within the New Plan Wizard).

• Plan Notes Filter: fixes issue where the filter for Plan Notes was not being validated on dialog close (which could then cause a problem after saving the Plan Document).

• Portal Registration: adds support for Portal Registration when creating portal user IDs and passwords.

• System Settings: prevents users from assigning two database servers with the same name (could later cause problems transferring data between servers).

• Portal User ID/Password Creation: fixes an issue with the last release which could prevent users from being able to create user IDs and passwords when creating these for the entire plan sponsor.

• Long-period Reported Amount Allocations: corrects for problems that could occur when allocating Reported Amounts that are longer than 1 year to average earnings periods (generally would only occur with rates of pay that are not projected but rather projected to the calculation date).

• Person Calculation Results Detail: adds mortality table information to the conversion and annuity factor calculation results screens.

• Worktrack Task Limit: when processing Worktrack tasks that are limited by frequency, no longer includes cancelled tasks in the count of prior requests.

• Participant Name Suffix Changes on the Portal: now supports changes to name suffix made through the portal.

• Benefit Payment Set Vesting: when evaluating vesting percentage for a Benefit Payment Set, now explicitly measures the percentage at calculation date.

• Mortality Tables: splits the screen for mortality table entry into separate screens to simplify input. Also, now includes the identification of dependencies of Plan Actuarial Equivalence Definitions on each table.

• GETITEMDETAIL Function: corrects issue which could cause this function to incorrectly return zero amounts when determining details for an account.

• Add and Rename Icons: fixes display issue where the add and rename icons on the main toolbar could still appear as enabled after closing all tabs.

• Portal Status Determination: status displayed on the portal is now determined in real-time based upon current information provided (previously, status was determined based upon the last valuation snapshot that was run).

• Portal ODBC Driver: the ODBC driver now only needs to be installed on Portal Controller machines (prior to this release, this driver needed to be installed on any machine that would need to access the portal for password resets, user ID creation, etc.).

• Valuation Snapshot Compare: corrects issue when a snapshot compare was run and an SSN change was detected where the pre and post change SSNs were displayed as the same value.

• Sponsor and Plan Parameters Output: includes new View in Excel option for both plans and sponsors whereby the parameters for each can be output and viewed in Excel.

Version 2016.17.7.1 - Released 07/02/2017

• Reported Amount Sorting and Reported Amount Lookup: when looking up a Reported Amount where there are multiple amounts on the same date (due to a termination date cap on amount effective and stop dates), now looks up based upon the latest of all amounts reported (based upon unadjusted effective date) as of that date. Prior to this version, DBP was using the earliest reported amount.

• Duplicate Portal Benefit Requests: corrects issue where when checking for duplicate Worktrack Requests upon portal request submission, tasks which had no history (other than the actual request itself being made) were incorrectly being ignored.

• Duplicate Portal Benefit Requests: now allows for requests with the same calculation and payment start date if each request is for a different plan.

• Plan Document Rename: now allows document and plan number to be changed by renaming the tree item for that document with the Plan Sponsor.

• Portal Request Limits and Multiple Plans: for Worktrack Requests that have per-period limits, DBP now separately applies limits for each plan (for when a sponsor has multiple plans).

• Deleting History in Worktrack and Completion Date: when a row of history is deleted for a Worktrack Task, the completion date for that task is now removed.

• Snapshot Prior Year Benefit Payments: DBP now measures and stores benefit payments for the prior year on the snapshot to help with gain/loss analysis for the actuarial valuation.

• New 2D Tables Added: adds support for MP-2014, MP-2015, and MP-2016 mortality improvement tables.

• New Plan Wizard Option: includes new option when running the new plan wizard to use stored benefits for terminated vested participants.

• PIA Level Income Benefit Option: now requires that the Annuity Factor Definition selected for benefit equivalence be an immediate annuity.

• Data Cleanup Wizard Processing: corrects issue when running the data cleanup wizard where a database error would occur if nothing had previously been saved within DBP prior to running the wizard.

• Worktrack Display and Report: now properly indicates calculation types along with dates and ages on both the Woktrack detail screen and Worktrack report.

• Portal Security Changes: includes changes that are consistent with portal's new security design.

• Data Request and Reported Amounts Formatted as Text: now properly displays amounts formatted as text on data requested (previously, these amounts displayed as blank on the request).

• Data Validations - Hourly Rates of Pay: corrects issue which was causing problems (both determination and performance) when validating year-by-year hourly rates of pay (as defined on the Custom Errors screen of a Validation Definition).

• Worktrack Emails: when placing a task on or off hold as well as when cancelling a task, corrects problem where the task creation date specified in the email sent was incorrect.

• Rename/Save Problem: corrects issue where after renaming an item within a tab, subsequent changes made to that tab could then not be saved.

• Snapshots and COLAs After Valuation Date: fixes problem where COLA increases after the snapshot date were incorrectly being reflected in the benefit amount stored for the snapshot.

Version 2016.17.6.1 - Released 06/02/2017

• System Settings Maximum Version: includes a dropdown displaying valid version number, and also no longer allows invalid version numbers for this screen item.

• Manage Backups: allows users with View access to sponsor backups to still be able to delete prior backups.

• Lifecount Reconciliation: now properly displays transfers-in and transfers-out on the lifecount reconciliation when filtering results on group code.

• License Administration: removes all references to Marx USB key as licensing is now Internet-based.

• Benefit Payment Set Valuation Extract: allows users to directly include accrued benefit for a Benefit Payment Set (previously needed to create a Formula Derived Item which then referenced the Benefit Payment Set to do this).

• System Settings Screen: corrects problem where changes to both standard extract headers and default naming were not being saved when changed on the System Settings screen.

• Portal Newsfeed Start/Stop Dates: allows for the specification of start and stop dates for newsfeed items.

• Late Retirement Actuarial Increases: corrects issue where DB Precision could become unresponsive when calculating late retirement increases past age 70 1/2.

• Benefit Payment Export: when exporting benefit payment information, users can now specify the index of the payment (where 1 is the most recent, 2 is the second most recent, etc.). Prior to this release, only the most recent benefit payment information could be exported.

• Exports and Macros: when exporting for an Export Definition within a Plan Document, where both a macro has been specified and where results are being saved to the document archive, that macro is now executed separately for each previously (previously, the macro was only executed once which worked for participant-level exports but not plan-level exports).

• Hours Equivalencies and Elapsed Time Minimums: now supports elapsed time minimums for service definitions that use hours equivalencies.

• Hiding Participant Status on the Portal: includes new option to hide participant status on the portal.

• Service and Final Period Rules: a new option has been added to the Service Provision screen which allows users to require that a service sub-period contain an actual termination date in order to be treated as a final or last period.

• Portal Password Requirements: prevents passwords less than 6 characters in length (consistent with the switch to Microsoft ASP Identity).

• New Plan Wizard: now integrates with standardardized Word documents to produce complete Export Definitions AND documents when running the New Plan Wizard.

• Service Eligibility prior to Hire Date: allows for service dates to precede original hire date when eligibility has been coded to explicitly allow for this.

• Beneficiary Selection when Calculating and Exporting: includes new dropdown for beneficiary selection when calculating and exporting for a person (previously always used first of five possible beneficiaries when calculating).

• Reported Amount Projection: changes the way that Reported Amounts are projected to improve calculation performance, particularly for amounts with reporting frequencies that are greater than annual.

• Data Cleanup Wizard: includes new option to identify non-employment historical dates that are prior to original hire date.

• Person Worksheets and Text Amounts: no longer allows Reported Amounts that are formatted as text to be added to a Person Worksheets (because only numeric values can be displayed within a Person Worksheet).

• Adds Grid Button to Person Transaction Log: includes a Grid button to allow transaction results to be copied to another application such as Excel.

• Includes Ability to Export Company Name and Website: these two items can now be included in an export.

• Average Earnings Reported Allocation - Worked Day in Month: when allocating earnings to a monthly Average Earnings Definition based upon whether a participant worked a day in a month, DBP no longer allows more than one Reported Amount to be allocated to any given month.

• GETAVGDETAIL Function: corrects for error which could occur when using this function when there are no earnings amount included in a participant's average.

Version 2016.17.4.24 - Released 04/25/2017

• User Group Standard Rights: fixes problem which was causing DBP to become unresponsive when opening the Standard Rights screen for a User Group.

• Person Worksheet Save: prior to this release, if a column within a Person Worksheet was moved or deleted and then saved, a warning message stating that the worksheet needed to be saved would appear (even though the item had already been saved).

• Valuation Snapshots and Non-accruing Participants: when determining non-accruing participants in a snapshot, DBP no longer recognizes elapsed time minimums when evaluating which participants accrue service. Prior to this release, the first two determination options for non-accruing participants were recognizing elapsed time minimums when evaluating.

• Popup Annuities: popup annuities are now distinguished with their own payment form (10) on both the data request and valuation snapshot.

• Email Storage of Worktrack Requests on Portal: if the email documenting the creation of a Worktrack task is unable to be saved, this is now logged in the portal's transaction log.

• Lifecount Reconciliation: includes details of the footnotes on the main lifecount reconciliation page when extracting those results to Excel.

• Worktrack Task Creation: properly stores the Sponsor Contact's ID when a Worktrack task is created by a Sponsor Contact on the portal and there is more than one contact for a sponsor.

• Opening a Sponsor: corrects issue where either an error would display or DBP would become unresponsive when opening a sponsor where no sponsor was selected on the Open screen, and where there was only one plan sponsor loaded on the user's network.

• Worktrack Creation Validation: prevents payment start date from ever preceding calculation date when both are specified (prior to this release, payment start date could precede calculation date when making a request if one was specified as a date and the other as an age).

• Participant Validation and Orphaned Database Records: includes coding to protect against application failure for when a participant's information is validated or saved, where there are orphaned Reported Amounts for that participant.

• Sponsor-only Worktrack Tasks: allows documents to be added and viewed for sponsor-level Worktrack tasks.

• Actuarial Valuation Data Display: corrects issue in which calculated plan items would not display properly on the Actuarial Valuation Data Detail screen for a Person (Reported Amount values would display instead).

• Earnings and Valuation Extract: now properly handles earnings in valuation extract when pay is reported on a calendar year basis but snapshot date is not calendar year.

• Partial Years Earnings Treated as Full Year: no longer excludes partial years when measuring earnings for partial periods that are to be treated as full years where the earnings period would otherwise have been rounded to zero.

• Compatible with Upcoming Portal Security Design Change: this version of DB Precision is compatible with an upcoming upgrade to the portal's security model.

• Service Hours Equivalencies and Date Determination: properly allocates hours equivalencies amounts over the entire year rather than all at the start of the year to correct for issues with date determination for dates that reference a Service Definition that uses hours equivalencies.

• Portal Controller Log: correct for display issues when a log message includes more than 255 characters.

• SQL Server 2016 Support: includes database support for SQL Server 2016.

Version 2016.17.3.7 - Released 03/07/2017

• Export Definitions: includes new option when exporting to always treat the export date like a termination date for people when exporting.

• Average Earnings: corrects display problem when an average earnings definition uses monthly units and includes partial periods.

• Worktrack Requests: includes new option to store emails sent out when the request is made as an archive document.

• Data Transfer: limits access for users to this functionality to be the same as the access for restoring data.

• Person/Plan Notes: fixes issue where only one note was appearing if a person or plan had more than one note to be displayed (on open or calculation of that item).

• Average Earnings Periods: includes coding to prevent an average earnings period from ever dropping below zero.

• Beneficiary Name Import: properly separates middle name and name suffix when these are included in first or last names (similar to the current functionality for participant name).

• Portal Controller Log: includes additional detail for document-related transactions.

• Data Request: includes beneficiary name suffix on the data request.

• Data Cleanup Wizard: no longer displays a possible missing TV benefit warning when looking for missing TV benefits (where the box "Check Terminated Vested Participants for missing benefits and calculate amounts" is checked) and where the benefit for a person is dynamically calculated.

• Microsoft Word Documents on the Portal: corrects error displayed on the portal when a Word document (xlsx or xlsm) was viewed online.

Version 2016.17.2.9 - Released 02/09/2017

• SSN Changes: when changing a Person's Social Security Number, the archives associated with that Person are now properly updated (prior to this version, such documents were orphaned and no longer associated with the Person).

• Portal Listener: corrects issue that could cause the portal to be unable to properly display the selection of multiple plan documents when calculating benefits.

• Internet-based License Support: adds new optional Internet-based licensing option which removes the need for installation of the hardware license key (Marx key).

• Beneficiary Import: cleans up name and address information for beneficiaries prior to applying to the database such that the import of information that is all in caps for example will now be imported in proper case.

• Opening Participant by SSN in Portal: prevents the opening of a Person by SSN within the portal when there is no historical dates or benefit information for the opened sponsor.

• Document Upload with Worktrack Request: emails are now sent to specified users when a document is uploaded as part of a Worktrack request.

• Opening an Unsaved Worksheet: when opening a Person Worksheet within a Sponsor that has not yet been saved, DBP now issues a warning/error.

• Portal Security: for Sponsors with multiple plans, DBP now allows users to choose plan number when generating user IDs/passwords within the Sponsor.

• Portal Security: if the web portal .csv is open when generating user IDs/passwords, DBP allows users to close the .csv file so that changes made on this screen are properly recorded.

• Social Security Calculation: when an employee has either no employment dates or earnings reported, and PIA is calculated, the calculation is no longer stopped as this was causing problems for plans with a PIA level income option.

• Valuation Earnings Projection: includes option to project/not project earnings for the valuation snapshot (had previously not allowed projected earnings amounts).

• Account Definition Export: fixes problem which could cause the account balance to not export properly (would export an older balance).

SIMPLIFY PENSION ADMINISTRATION
PENSIONSOFT CHANGE LOG
2018 DB PRECISION UPDATES
Version 2017.18.12.18 - Released 12/18/2018

• Derived Dates and Hours Equivalencies: fixes issue when calculating a Derived Date that references a Service Definition that is based upon hours equivalency where prior DBP versions fully allocated a full-year's accrual on start date in the calculation date year which could then lead the resulting date to occur on the first day of that year rather than later that year.

• System Settings Database Names: now allows for server names that extend beyond the width of the system setting entry fields.

• Worktrack Report: adds a new column, date last updated, to the Worktrack Report.

• Worktrack Task Display: includes Sponsor name in the list of Worktrack tasks.

• Service Accrual: when the option, "Exclude periods prior to the earliest accrual date for the following" is checked and the referenced service definition never starts accruing for a person, service under that definition now also never begins accruing.

• Derived Dates: corrects issue when there are multiple provisions where the resulting date could be overstated.

• Invalid Average Earnings Amount: with previous versions of DB Precision, if an average earnings amount was invalid, it could then invalidate other amounts and sometimes result in blank values on the export. This have been fixed.

• Internet Controller Stability: corrects issue that could cause the Internet Controller to become unstable.

• Internet Controller and Invalid Status Determination: fixes issue for plans where status determination cannot be made (plan where no credited service definition is specified for example), where the Internet Controller was previously unable to publish benefit calculations or participant data.

• PIA Level Income Report: now includes additional columns showing initial and post-PIA benefits.

• Average Earnings Units Annual Grouping: adds annual grouping support for monthly periods.

• Average Beneficiary Date of Birth: now reflects the youngest beneficiary for purposes of applying joint and survivor option limitations.

• New Gender Formula Functions: adds two new functions, GETSEX and GETCASEX to allow for gender of both participant and beneficiary to be referenced in plan coding.

• Actuarial Equivalence Separate Pre-payment Interest: allows for the specification of a separate pre-payment interest rate.

• MP-2018 Mortality Projection: support for this mortality projection table has been added.

• Floating Mortality Table Year: includes new option to export the mortality table year for an annuity or conversion factor definition.

• Sponsor Contracts: users may now add Contracts and Contract Amounts similar to what was done for company amounts.

• New Reported Amount Types: add two new Reported Amount types that allow users to indicate that a Reported Amount is either a company code or a contract code.

• Additional Identifer Values: users can now create numeric to text conversions to be used for Reported Amount additional identifiers within a plan sponsor.

• Reported Amount Additional Identifier Lookup: new lookup buttons have been added to Reported Amount primary and secondary additional identifier screens to simplify identifier entry.

• Machine Name: now records machine name and displays on main screen and licensing screen.

• .NET Version: determines .NET version and notifies user if it is lower than the minimum required.

• Derived Dates Service Requirements: when calculating Derived Dates with service requirements, now confirms that the service requirement is met before returning a date (with hours equivalencies and rounding, previously the date returned could be stated as being prior to the date the service requirement was actually met).

• Formula Derived Item Detail Display: for display of Formula Derived Items on the portal, now treats the date 1/1/1800 as 0 for zero display.

• Portal News Feed: resolve issue where portal news feed stop date might not appear properly in DB Precision (and will instead display as current date).

• Worktrack Task Filter: fixes issue where when using a Worktrack Task Request filter, no Worktrack tasks could be completed through the portal.

• COLA Imports: when importing a COLA on import, if a benefit row for a Person already existed with the COLA date but with a different benefit amount, a primary key violation would occur on import save. This has been fixed.

• Duplicate Worktrack Requests: adds additional checks when testing for duplicate requests that compare date entries and age entries (for calculation and payment start dates) against each other rather than only testing for duplicate inputs.

• Joint and Last Survivor: includes this as new choice for option in Annuity Factor Definition, Conversion Factor Definition, and New Plan Wizard screens.

• Individual Segment Rate Projection: fixes issue for Actuarial Equivalence Definitions that use individual segment rates (1, 2, or 3), where projected values of corresponding annuity or conversion factors could not be calculated.

• Account Provisions Using Daily Interest Rounding: for plans that use daily interest rounding (rare), now always accumulates opening period balances based upon days rather than nearest months for some accumulations.

• Worktrack Report: includes new screen that allows for filtering of tasks to be included in the report.

• Benefit Payment Report: contains a new report which displays lump sum and annuity payments during some specified period.

• Data Cleanup Wizard: no longer incorrectly displays error for participants receiving the joint and last survivor payment form where the initial payment is different from the benefit payable while only the participant is alive.

• Office 2019: includes support for Office 2019.

• Averaging Periods and Compensation Limit: adds option to determine averaging periods based upon unlimited earnings and then avergaing limited years.

Version 2017.18.10.2 - Released 10/02/2018

• SQL Server Names: corrects issue with the find button which causes pressing this button to not result in the correct database name selection.

• Locking/Unlocking Valuation Snapshots: when the lock/unlock button is pressed, the button text now properly toggles between lock and unlock.

• Import and SOB Notice Date: corrects issue when importing SOB date where the date would not be saved when importing for a new person.

• Import of Sponsor Company Amounts: fixes problem where the application could fail when importing company amounts (on the Sponsor Company Amount screen).

• Portal Change Logs: corrects problem when viewing the portal change logs which could cause a data truncation error to appear.

• Auto-login and Database Availability: if the database is unreachable on application startup and is set to automatically log in and there is no other user interaction, DBP will keep trying to connect to the database every 20 seconds until the database is once again reachable.

• Documents Deleted within the Portal: document description for deleted documents is now included in the log.

• Match Report: corrects an issue when running the Match Report and checking a file with a single row where that row was not getting evaluated.

• Benefit Payment Set Optional Benefits: the check box "Reduce optional benefit amounts by employee-paid annuity" is now saving when checked.

• Application Stability: corrects issue with current release that could cause the application to fail when renaming or deleting a plan item.

• Application Stability: after running a calculation or export for a person, making changes to a sponsor, and then saving, the application would then fail on closing that person. This version corrects that issue.

• Average Beneficiary Date of Birth: includes new option to use average beneficiary date of birth when calculating for a person.

• Sponsor EIN: when this is changed, both archives and portal settings are now updated with the new EIN.

• Validation Definition Filter Formula References: prior to this release, changes made to items referenced in a Validation Definition Filter Formula were not being properly updated on document save.

• Benefit Payment Set Vector Range Error: fixes vector range error which could appear when determining service for a non-vesting service definition that included a five-consecutive year break rule.

• Worktrack Filtering: modifies Worktrack filtering options to display only those tasks that a user can work on (similar to the portal).

• SQL 2017 Support: includes full support for SQL 2017 including the ability to now reference ODBC Native Client 17.

• Database Defragmentation: corrects issue which could cause an error when defragmenting the database.

• Valuation Data on Person Worksheet: fixes problem which was preventing saving of valuation data from within a Person Worksheet.

• Export to Archives: when exporting to archives within a Person, this version corrects an issue when viewing other archives for that person that could occur before closing the person's tab (item selection was off by one archive).

Version 2017.18.9.4 - Released 09/04/2018

• New Operand - PROCESSNAME: adds new Formula Operand that allows users to reference the Export Definition name within a formula (ex. IF(PROCESSNAME = "exportEstimate", 1, 0).

• Changing Import Item Columns: corrects issue which could cause the application to stop responding after saving an Import Provision where column number changes were made that then shifted other columns within that Import Provision.

• First Ever Login: when a user logs in for the first time to DBP, the user is asked whether they would like to view the DBP user guide. However, there is then no opportunity to view this guide as there are no yes or no buttons on the screen. This has been fixed.

• New Average Earnings Unit: a new semi-monthly averaging unit has been added.

• Importing Historical Dates: when an import results in a change to the date classification of a Historical Date, the old and new values now properly show in the import results change listing (previously, these fields were blank).

• Account Transactions: adds new option to create multiple formula transactions on a transaction date when a specified Reported Amount has more than one additional identifier.

• Other Reports Option and Multiple Plans: fixes issue where application would fail when running Other Reports (ribbon Valuation tab) for a plan with multiple plan documents where the plan number was not selected.

• Certain-only Benefits and Period Validations: when a certain period is specified that is inconsistent with the effective and stop dates provided, this will now result in a new validation warning.

• Portal Zero-value Handling: corrects issue that could cause problems opening a plan when the option "Display as N/A if zero" was selected.

• Minimum Distribution Benefit Type: changes all current "Minimum Distribution" benefit payment references to the more general term "In-Service Distribution".

• Uniform Distribution of Deaths (UDD): includes new option when valuing annuity and conversion factors to value using Uniform Distribution of Deaths (UDD). Previously, Woolhouse's approximation, (n-1)/2n, was the only option for measuring values of non-annual payments.

• Match Report: corrects issue where dual-status participants from the prior snapshot would incorrectly show up as dropoffs on the Match Report.

• Match Report: now allows for the selection of run number when comparing imported files to prior snapshots using the Match Report.

• Plan Changes Across Multiple Time Zones: corrects issue which could cause the Internet Controller to not refresh plan and sponsor changes when multiple users made changes across different time zones.

• Benefit Payment Set Lump Sum Options: adds new option to indicate a limit for lump sums within the Benefit Payment Set options.

• CALCULATE Function and Formula Derived Items: users can now pass up to 10 values to a Formula Derived Item using the CALCULATE function and then reference those values using the new operands VALUEPASSED_1, VALUEPASSED_2, etc.

• Points-based Derived Dates: when a Derived Date Provision references an elapsed time definition, the date returned is now limited to never precede hire date (note that this was already being done for definitions that referenced Reported Amount Service).

• Sponsor Reported Amount Deletion: no longer allows deletion of Sponsor Reported Amounts when participants in that sponsor are open in order to eliminate the risk of display problems within those tabs.

• Portal Comment Hiding: supports new portal settings that allow for comments to be hidden on the portal.

• Formula Parser: checks for missing function name when evaluating formulas (prior version allowed a formula such as 1+(2,3) where no function name was specified).

• Service Breaks: adds new options for determining hours-based breaks (prior versions required that break be equal to 5 consecutive years, and only counted years in which under 500 hours was worked).

• Service Breaks: corrects issue when rehire date is rounded after break where 2 breaks-in-service would appear on the calculation display (one with an end date equal to the rounded date and the other with the unrounded date).

• Valuation Snapshot Results Inputs: when viewing snapshot result inputs and pressing OK, the system no longer displays an error message (screen could then only be closed by pressing Cancel).

• Account Definitions and Bi-weekly Transactions: now properly allows for the specification of bi-weekly Account Definition transaction start dates.

• Folder Drag-Drop: corrects issue when dragging one folder on to another within a Plan Document or Person tab which could cause the application to fail.

• Mortality Table Export: when exporting mortality table name for an annuity or conversion factor, the exported value now includes the year (similar to the calculations results screen).

• Joint and Last Survivor: when running a snapshot for a person receiving a joint and last survivor annuity when the beneficiary has died, DB Precision now properly reduces the benefit and changes the payment form to a life annuity.

• Sponsor Deletion and Sponsor Company Amounts: fixes problem when deleting a Sponsor when there are Sponsor Company Amounts.

• Annuity and Conversion Factor Interest Projections: includes new option to export the date from which interest rates are projected.

• Person Worksheets on the Portal: fixes issue where last row of a Person Worksheet might not be viewable on the portal.

• Export 415(b) Limit Indicator/Amount: the ability to export these two items has been added.

• Dual Status QDRO Participants: includes new coding that allows QDRO participants to be evaluated as dual status.

• New Validation for Deceased Participants: when a participant has deceased while receiving a benefit that includes a survivor component and where the beneficiary is still alive, DB Precision now includes a new validation that confirms that the beneficiary has an SSN specified (for a corresponding second Person created in DBP).

• 100% Vesting at NRD: now also requires that a person be a participant before this rule is applied.

• SQL Server Names: now detect SQL Server names on settings screens for easier database name selection.

• Default Folder Name in Status Bar: when changing the default folder path for a sponsor, now updates the status bar with the new path.

• Person Worksheet: when editing participant historical dates within a Person Worksheet, now properly updates the data when Termination Date is selected as an option and the underlying type is something other than "Terminated - No Reason Given".

• Application Stability: corrects issue with current release that could in rare circumstances cause the application to fail after running calculations for plans that include Validation Definitions.

• Person Validation Definition Description: descriptions for Validation Definitions now properly save.

• Memory Leak: closes memory leak which could occur if the Internet Controller is force shut down by the Internet Controller Manager thread due to lack of response from the Internet Controller thread after 4 minutes.

Version 2017.18.7.10 - Released 07/10/2018

• Item Explorer Loading: now begins when a tab is first opened rather than on first click of an item.

• Worktrack Tasks on the Portal: display Worktrack tasks on the portal's Worktrack list that were created over a year earlier but not yet been completed (previously, any task created over a year earlier was excluded from the portal's display).

• Sponsor Archive Folders: allows for the creation of archive folders on a plan sponsor level and then displays those archives grouped by those folders on the Internet Portal.

• Person Find: adds option to search by first name as well as last when trying to find a Person on the Open screen.

• Changing Servers: adds new button to the caption bar that allows for easy switching between servers after login.

• System Settings - Network Settings: corrects issue where driver letter / UNC path substitutions could not be saved on the System Settings screen.

• New Data Reports: adds two new standard reports. One for determining annuitants with ending certain periods, and another for determining participants receiving level income annuities that are about to change.

• Actuarial Equivalence Mortality Projection Blending: includes new option that allows for blending of male and female rates for two-dimensional mortality projection tables.

• Worktrack Expiration: includes ability to store this new type of date for Worktrack tasks.

• Task Details on Portal Request: task details may now be optionally hidden from the task request screen on the portal.

• Benefit Payment Override: no longer carries over this indicator when a new benefit payment is created for a Person.

• Conversion Factors and Popup Annuities: now allows for popup annuities to be determined for certain-period annuities.

• Internet Controller and Thread Restart: eliminates all Word and Excel processes on controller thread restart to reduce the risk of application instability.

• Formula Derived Item Circular Reference: fixes issue where calculator could incorrectly report a circular reference in a Formula Derived Item after encountering a separate issue in the formula.

• Formula Derived Item Portal Display: properly displays amounts that are dates using a date format.

• Plan Sheet Copying: fixes problem when copying one sheet to another smaller sheet where the cells that did not previously exist on the target sheet would not be stored on plan document save.

• Network Administrators: no longer requires that an email address or mobile contact be included when saving a Network Administrator.

• Reported Amount Import: corrects system error when importing text that contains an apostrophe to either a Reported Amount formatted as text or to the comment field of a Reported Amount.

• Reported Amount Import: fixes display problem on Import Results screen where a Reported Amount was reported as a change for Reported Amounts that have changed from text to numeric or numeric to text where there was a previously stored value that is no longer applicable.

• Import Speed: includes changes designed to improve import speed.

• Sponsor Companies: adds ability to store multi-employer companies within a plan sponsor.

• Sponsor Company Amounts: users can now store amounts for a sponsor on a company level (previously amounts could only be stored for people).

• Actuarial Equivalence Provision: includes new 120% FMT variable interest rate option.

• RPTAMTLOOKUP and Stop Date: corrects issue when looking up stop date for the latest amount could return a date equal to the day after the true final stop date.

• System Email Settings: fixes problem when incorrect settings were entered, and the Test button was then pressed while also now allows for empty password to be entered (for when validation on the SMTP email server is not required).

• Internet Controller and Latest Status for Multiple Plans: when determining latest eligible status to determine latest status, the controller now only looks at statuses for which the user has portal access.

• Creating New Reported Amounts on Import: uses a new method for importing new reported amounts to improve import speed.

• Remote Support Tool: includes updated remote support tool with latest enhancements to Splashtop SOS.

• Updated Standard Forms Package: includes updated standard forms package with updates to the special tax notice.

• Relative Value Override: corrects problem where relative value would not reflect the corridor (to indicate if amount was considered the same value) when an override was used for a payment option.

• Database Defragmentation: includes new tool that allows system and database administrators to defragment the database to improve database performance.

• Account Transaction Filter Formula: adds ability to apply a filter formula to account transaction (can be used to improve calculation performance by eliminating unnecessary calculations).

• Person Worksheet Save: fixes problem with Person Worksheet where saving multiple lines for one Person could result in an error.

• Status Determination: corrects problem where a person due a deferred beneficiary annuity who was also cashed out of his/her retirement annuity was incorrectly being determined to be lump sum cashout rather than as a deferred beneficiary.

• Server Explorer View: now correctly only displays servers that are currently logged in and stops flickering when a server goes offline or when there is a status change.

• Breaks-in-service: when the option to exclude service prior to five consecutive years of less than 500 hours is chosen, DB Precision now correctly excludes service when there are more than one of such periods. In addition, it now properly reflects hours amounts for determining such periods when something other than a Formula Derived Item is chosen for Hours.

• Lifecount Reconciliation: fixes problem where DBP could fail when running a lifecount reconciliation for plans with participants that have beneficiary SSN specified that match other beneficiary SSN within the plan (used to check for 5500 exclusions).

• Inconsistent Optional Benefits within Benefit Payment Set: prior to this release, if the options available within a Benefit Payment Set Definition were not consistent and an Export Definition referred to that definition, this could prevent users from being able to open the Plan Document without PensionSoft assistance.

• Sponsor Import: corrects issue where the application could stop responding on import if the option to only import existing actives was chosen and the first person in the import was not in the sponsor's group of people.

• Internet Controller Logoff/Login: fixes issue where when logging off and logging back in to an Internet Controller session without closing DBP, the Internet Controller would first disconnect and then reconnect to the portal database after the second login.

Version 2017.18.4.17 - Released 04/18/2018

• Worktrack Task Emails: when emails are to be sent on task step completion or authorization, DBP no longer sends emails to the user updating the task if emails for all other portal users have been turned off for that step.

• Average Earnings Final Partial Period: includes new option to include the final partial year in the averaging if it will result in a higher average.

• Monthly Annuity Factor Option: adds new option to determine annuity factors as monthly amounts.

• Duplicate Worktrack Requests: for tasks that allow for duplicate requests, includes new option to delete all prior duplicate tasks for a person before creation of the new task.

• Snapshot Inputs: store all snapshot input entries rather than only the results and allow them to be viewable on the snapshot results screen.

• GETDETAIL Function: includes new optional parameter allowing for the specification of a determination date for purposes of determining the detail amount.

• Writing Errors to File on Import: corrects issue where the error file written when writing rows with errors to a separate file could be created with an invalid format.

• Item Explorer: makes additional corrections to Item Explorer to improve application stability for large plans.

• Application Stability: corrects some problems with application stability on the main screen.

• Resizable Dialog Boxes: adds the ability to resize certain dialog boxes.

• Moving Folders: corrects issue where moving folders could cause a folder and its items to all appear in the root folder.

• Archive Renaming: permits archive renaming that includes special characters when making changes within the main document tree.

• Sponsor Archive Changes: changes made to documents within the sponsor for export-generated and imported archives now flow through all participant archives (this had changed when archive documents were moved to the main document tree).

• Worktrack Description: ensures that Worktrack Task Definition descriptions are unique to avoid potential problems on task creation.

• Sample Participant Indicator: allows for participants to be designated as "Sample" such that they can be used for demonistration but not show up in things such as valuation extract files, life count reconciliation, data request, or standard client reports.

• Beneficiary Information: adds additional fields to beneficiary information that is stored including beneficiary allocation fraction, a comment field, benefit priority type (primary, secondary, etc), and a pre-35 spousal waiver indicator.

• Internet Controller: corrects issue for sponsors with multiple plans that could cause the Internet Controller to stop responding upon saving a participant through the portal.

• Participant Summary Details: fixes problem where Formula Derived Items that are included as participant summary details could fail to display as of the correct date (latest snapshot date versus login date).

• Formula Derived Item Tooltip: now includes portal information in tooltip if applicable.

Version 2017.18.3.21 - Released 03/21/2018

• Copying Worktrack Task Definition: corrects issue when copying a Worktrack Task Definition where the application would fail on copy.

• Adding and Deleting a Document: fixes problem where database error would occur on save if adding and then immediately deleting document from either a sponsor or participant.

• Portal Summary on Main Page: no longer requires that a snapshot be run for a participant in order to display all possible summary items (main portal page).

• PIA Level Income and Beneficiary: corrects issue where PIA level income option might not appear if spousal information was not provided.

• View Archive Documents: adds ability to view archive documents from the main tab.

• Archive Tooltip: adds detail to the main archive tooltip to help identify which documents are accessible within the portal.

• New Service Eligibility Option: includes new option to assume that all accrual conditions are met when an eligibility override start date is used.

• Match Report: replaces the dropoff report with a match report that non only displays dropoffs for files being imported but also displays new participants and matched participants.

• Date Import: adds new date import option to only use year value (and assume that month and day both equal 1).

• Beneficiary Name Import: corrects display issue where beneficiary name changes only due to difference in capitalization would incorrectly appear as name changes on the import results screen.

• GETBENLATEST: adds ability to get the stop date of a benefit payment when using this function.

• Historical Date Import: prevents users from importing a termination date that then replaces the only hire date for a person when there is also no benefit payment stored for that person (designed to protect against orphaning a person).

• New Address Validation: includes new a validation warning for when a participant is indicated as being unlocatable but has an address stored.

• Person Validations: adds ability to hide validations error-by-error so that they do not show up when running future validations.

• Range Validations: corrects issue when running validations which could result in range validation errors when there should have been no error reported.

• Status Determination and Return of Contributions: if there is a contribution start date or CSD, VSD, or DOP Override date that is after return of contributions payment date, DBP now disregards the payment for purposes of status determination.

• Import Conversion Screen: corrects issues with Import Item Conversion Screen where blank amounts could be entered and where decimal values were being rounded to the nearest integer.

• Item Explorer: corrects problem where Item Explorer would cause the application to stop responding on very large plans (over 500,000 participants).

• Item Explorer: includes changes that will improve application stability and the speed that Item Explorer loads.

• Social Security Level Income Options: allows for the specification of an actuarial equivalence measurement date that is other than payment start date (previously, actuarial equivalence was always measured on payment start date regardless of the underlying annuity factor settings).

• Citrix XenApp Compatibility: allows for the hummingbird icon to be hidden when running under Citrix XenApp to avoid remnant application from being created (the hummingbird icon) that then could cause problems on re-login.

• Daylight Savings Time: corrects for possible time stamp distortion issues on the Internet Portal log resulting from differences in daylight savings time.

• Internet Controller and Read-only Files: enables Internet Portal Controller to properly export to Word when a file is set to read-only.

• Valuation Snapshot and Monthly Benefits Display: corrects issues when creating a valuation extract and data requests where PIA Level Income, Joint Life with Popup, and Joint and Last Survivor payment options were displaying as annual amounts when monthly display was chosen.

• Beneficiary Address Export: when exporting beneficiary address, if beneficiary address is indicated as being the same as participant address, now properly exports participant address rather than blank.

• Item Explorer and QDRO Participants: separately groups QDRO participants within Item Explorer for easier identification.

• Late Retirement and Segment Rates: makes adjustment to late retirement to allow segment rates to be used when using the floating PPA basis. Note that the option "PPA Segment Rates" must be chosen for the option "Rates Level by Age".

• Archive Images: allows users to select the file path/name first where the file type is then selected based upon the file that is chosen.

• Average Earnings Amount Allocation: adds a new way to allocate reported amounts such that they are allocated based upon working days in a month.

• Service Determination: adds a new way to calculate elapsed time credited service where service is determine for a partial month based upon working days in that month.

• Import Files with Duplicate Rows: when duplicate SSN rows within a file should not be imported, and rows with critical errors are to be ignored, the import is now allowed to continue and all duplicate rows are indicated as having critical errors (rather than stopping the import on the first duplicate row).

• Person Transaction Log: includes changes to this screen including a Person Notes filter option as well as a check/uncheck all filters button.

Version 2017.18.2.5 - Released 02/05/2018

• Suspension of Benefits Date and Unable to Locate Information: these items may now be both imported and exported for individuals.

• Sponsor Import Wizard: includes the ability to add blank columns when using the Import Wizard and also allows for users to select multiple employment and termination dates within this wizard.

• Sponsor Import and Reported Amounts: includes changes to enhance the speed of saving large numbers of reported amounts on import.

• Sponsor Import and Possible SSN Changes: hides this warning for new participants if no possible SSN changes were detected on import.

• Joint and Last Survivor Payment Form: includes the ability to store a new payment form for benefit payments, Joint and Last Survivor, where the benefit drops on either the participant or beneficiary death.

• Benefit Payment Screen: includes enhanced display and selection for beneficiary information on the benefit payment screen.

• Sponsor Validations: uses simplified validation messages and removes redundant type descriptions from the error description.

• Sponsor Validations: reduces the number of allowable errors for corridor and missing items for each reported amount to 10 in order improve performance.

• Sponsor Validations: when a validation definition is used for running participant validations, only validates selected items to improve performance.

• Participant Archive Documents: corrects issue with last release which would cause a problem viewing an archive document immediately after creating it using an export within a participant tab.

• Late Retirement and Segment Rates: when accumulating using the method "Mortality, but interest only during the accumulation period", where segment rates are referenced, now uses the first segment rate (rather than the 30-year treasury rate).

• Person Change Log: corrects issue where transactions displayed for a Person that existed in multiple sponsors was including transactions for all sponsors (only transactons for the opened sponsor now display).

• 2019 417(e)(3) Mortality: updated to include 2019 417 mortality rates.

• Annuity and Conversion Factor Display: now displays the mortality year when floating 417(3) mortality is chosen.

• 415(b) Display: corrects display issue on 415(b) limit screen which could cause the lump sum amount and factor shown to incorrectly appear for plans with a small benefit cashout (note that this issue did not impact any previously calculated values).

• Portal Participant Summary Formula Derived Item Display: includes support for new portal feature allowing Formula Derived Items to be displayed on the portal.

• Space-Delimited Imports: fixes issue where spaces included in participant SSN were causing the import row to be skipped when importing a space-delimited file.

• User Rights Exceptions: corrects issue with last release where the application would fail when displaying a tooltip for a User Rights Exception for a User where the User was part of a User Group.

• Sponsor Transaction Log Detail: fixes issue where benefit detail was not appearing for added benefit payments.

• Person Worksheet Date Filter: when an invalid date filter is entered on Person Worksheet item, DB Precision now properly forces the date to be a valid date or returns an error.

• Sponsor Portal Security Screen File: corrects a display issue for participant status on this file for participants that should no longer have portal access.

• Exporting Middle Initial: fixes export problem when exporting middle initial for participants with no middle name.

• Portal Name Changes: when a name change is made through the portal, an algorithm has been added to the portal controller that determines whether the change requires that a new name be added due to marriage (rather than changing/correcting the existing name).

• Skipped New Participants on Import: when only existing participants are to be included when importing, all otherwise new participants are now included in the skipped rows display.

• Provides Option to Allow for Duplicate Worktrack Requests: a new option has been added that allows for duplicate portal Worktrack Requests (same calc date, ACD, and plan).

• Next-highest Coinciding Month Age Rounding: makes an adjustment to age rounding for annuity factors and CAF factors when age is rounded to the next-highest coinciding month such that when day values are equal for birth date and payment date, the calculation does not ever include an extra month.

• GETEARLYADJUST Function: adds support for a new method for determining early reduction when using this function - calculating early reductions factors at integer ages and then interpolating.

• Cashout Date on Lifecount Reconciliation: when a person is cashed out after receiving a return of employee contributions, now properly shows the cashout date on the lifecount reconciliation.

• Calculation Results Reported Amount Screen: adds grid button to this screen for easier checking.

• Average Earnings Grouping: adds support for weekly earnings when grouping earnings amounts by year.

• Grouped Average Earnings and Career Lookback: fixes problem where the application would fail with grouped earnings amounts and career lookback.

• Allowable Average Earnings Lookback Period: increases the number of lookback units from 260 to 520 (to allow for 10 year lookbacks and weekly average earnings).

• Weekly Average Earnings Periods: similar to bi-weekly periods, ensures that all weekly averaging earnings units begin on a Sunday and end on a Saturday.

• Averaging Period End Date Adjustments and Averaging Units: corrects issue where new averaging periods would not be created after final termination date when averaging period end date adjustments were to be made.

• Benefit Payment Calculation Override: adds new option for participant benefit payments where calculated accrued benefits can be overriden with the stored benefit payment amount (without needing to separately code for this using GETBENLATEST).

• Text to Numeric Conversion on Import: includes the ability to convert Reported Amount primary and secondary additional identifiers from text to numeric on import (previously could only convert the amount itself).

• Multiple Import Record Layout Row Identifier: this may now include semi-colons to allow for multiple file values for a single layout type.

SIMPLIFY PENSION ADMINISTRATION
PENSIONSOFT CHANGE LOG
2019 DB PRECISION UPDATES
Current Beta Version

• Renaming Items in a Previously Corrupted Plan: corrects issue which would cause the application to fail if renaming a plan item after opening a previously corrupted plan.

• Database Connection Properties: provides new option on the user's options screen for users that connect to DB Precision using Windows Active Directory allowing them to update their own database connection properties (previously, this would need to be done using Regedit).

• New Mortality Distribution Method - Interpolated Mortality Rates: includes a new method for defining mortality distribution method when determining annuity and conversion factors that uses interpolated mortality probabilities.

• Deleting Items After Deleting a Benefit Payment Set Definition: corrects problem where the application would fail after a user deleted a Benefit Payment Set Definition and then also deleted another plan item.

• Summing Accrued Benefits at each Termination Date: fixes credited service display problem when using this option as well as problem when deleting a termination date for a person but then calculating without closing and reopening that person.

• Display of Historical Override Dates on Portal: for administrator logins, now displays override dates regardless of whether these are hidden for participants and sponsor contacts.

• Sponsor Archive Tooltip: corrects problem where the sponsor archive summary would not show as a tooltip when a user would mouse over Archive Documents in a Sponsor view.

• Saving a Person: fixes problem when saving a Person after having both added a new archive and then changing the SSN of that Person and then saving which would cause the application to stop responding.

• Sponsor Contact Hold and Cancel Rights: now properly restricts access when a Sponsor Contact does not have on/off hold or cancel rights for Worktrack tasks on the portal.

• Standard Report Status Determination: when determining status for ending disability, overdue terminated vested, and certain period annuity reports, now uses dynamically determined status rather than valuation snapshot status.

• Ending Certain Period Annuity Report: includes two additional columns for this report (payment type and certain period).

• Portal Access Denial by Status: adds ability to deny access to the portal based upon valuation status.

• Lifecount Reconciliation and QDRO: now identifies QDRO participants that are deferred versus not deferred.

• Option Form Non-taxable Basis: enables users to export the underlying basis (balance) used in the determination of the non-taxable benefit.

• Number and Text Conversions: allows users to tie numeric to text conversions directly to employer, contract, or additional identifier mappings for certain functions such as import, export, and portal display.

• Import Item Application: adds new option for certain import items such as participant date of birth or date of death that will only apply a change to a person's record if it does not already exist for that person.

• Plan Sheet Lookup: corrects issue when using VLOOKUP function on a plan sheet with a very large third parameter which could cause the application to fail when calculating.

• Saving Request Email to Archive: when an automatic email is saved to a participants archives on Worktrack request, now updates the documents section of the portal to include this email.

• Renaming Items Contained in Formulas: corrects an issue where in rare instances, a formula could become corrupted on item rename.

• Saving Bank Information on Portal: fixes information where bank information would not be saved on the portal if Bank Name was blank.

• Internet Controller and Worktrack: utilizes horizontal rather than vertical build of Worktrack vector to improve portal speed for Sponsor Contacts and Administrators.

• Plan Export Wizard: when choosing Benefit Payment items in the wizard, now properly identifies those that should be formatted as currency.

• 415(b) Limit and Small Benefit Cashout: fixes issue where inclusion of the small benefit cashout in a plan could result in an understated 415(b) lump sum limit.

• Portal Controller Log: now includes the number of seconds each task takes to process.

• Worktrack Duplicate Requests: fixes issue where the portal controller could allow duplicate Worktrack requests, even when such requests were prohibited.

• Certain Period Annuities with 0% Interest: corrects problem when calculating annuities with certain periods along with 0% interest rates.

• Leading/Trailing Spaces in Worktrack Task Step Names: makes additional changes made with last release to correct for updates to tasks that are made within DBP where a step would not display as completed if it contained a leading or trailing space in its name.

• Open Portal for Participant: new ribbon button has been added allowing for a DBP user to open the portal for a selected participant and sponsor (without needing to separately log in).

• Plan Exports with Macros: when doing a plan-level export that includes a macro defined in DBP and where the user wants to generate a merged document, DBP now loops through each record to produce a document that separately reflects the macro for each record (previously this needed to be done using Word merge events).

• Updating Documents on Portal and Worktrack: if a user updates an archive document on the portal and a participant is opened, the document in any associated Worktrack task is now also updated on the portal.

• Worktrack History Detail Grid: adds grid button to history tab of Worktrack Detail screen for easier information extract.

• Call Center Interface: includes new call center interface, providing for fast participant searches.

Version 2019.19.7.18 - Released 07/18/2019

• Sponsor Text Conversion Definitions: adds new type of component for a Sponsor where users can define a mapping for numeric to text conversion.

• Text Conversion Screens: all screens include Delete All button to remove all conversions.

• Imports and Replacing All Benefits: adds a new check box to Import screen for when a sponsor that has multiple plans where the option to replace all existing benefits is selected. Users can now choose to then only delete existing benefits if plan number of an existing benefit matches the plan number of the benefit that is being imported.

• Import of Reported Amounts: includes additional detail on the import results screen to indicate what has changed for a Reported Amount upon import.

• File Import: adds better handling for files with large numbers of blank rows.

• Reported Amount Renaming and Assumptions: with prior versions of DBP, when a user would rename a Reported Amount within a Sponsor and save, the assumptions for that amount on reopen for the Reported Amount would appear as blank/unspecified. This has now been resolved.

• Person Worksheets: includes new options to hide portal columns on the portal display of Person Worksheets as well as allows for display of values converted to text.

• New Choices for 415(b) Limit: includes new choices when determining the 415(b) limit which allow for the specification of a maximum year when looking up the dollar limit as well as an option to determine the dollar limitation based upon payment start date rather than calculation date.

• Late Retirement Options: includes new option for late retirement to not actuarially increase benefits prior to termination date but only if termination date (actual or estimated) is prior to minimum distribution date (4/1 following calendar year of age 70.5).

• GETCASSN Function: adds new function to get beneficiary SSN in a formula.

• RPTAMTLOOKUP Function: includes new option to lookup a Reported Amount's secondary identifier.

• Formula Derived Item Portal Display: includes new option to convert numeric values to text for purposes of display on the Internet Portal.

• New Average Earnings Reported Amount Combination: adds new Reported Amount combination type that allocates the latest amount as of each period's end date (previously could only do this as of period start date).

• Export Bookmarks: adds custom column support to late retirement table bookmarks.

• Window Customization: includes new color-selection box for application window customization.

• Hiding the Login Screen: includes new option that can be set on both a User and User Group level to prevent users from being able to hide the login screen on application startup.

• Opening Items Already Opened: when opening an item that is already opened in another tab, now selects that tab rather than opening in a new tab.

• Excel and Word Integration: reflects modification made with last release such that Word and Excel open in a normal window state rather than maximized when opened.

• Main Ribbon View Panel: changes view of all check boxes to switches.

• Ending Disability Payment Report: includes new standard report that shows upcoming end dates for disability payments.

• Sample Participant Handling: properly excludes sample participants from validation tasks such as the match report, data cleanup wizard, and group-level validations.

• Portal Database Changes Log: users can now view this log for all sponsors as well as filter on update type.

• Administrator Portal Participant Listings: participants of all status codes now appear when an Administrator searches for participants on the portal (rather than being limited based upon Sponsor Contact settings).

• Sponsor Contact Portal Participant Listings: these are now displayed based upon separate settings (previously, only participants in groups of participants that were provided user IDs would be displayed).

• Portal Benefit Summary: automatically supresses main summary information for retired, beneficiary, cashouts, and deceased participants.

• Participant Internet Benefit Summary: now uses the default assumption specified for the plan if any to develop amounts shown on the participant benefit summary.

• Worktrack Requests and Employee Contributions: no longer prevents worktrack requests for non-vested participants if they have an employee contribution balance.

• List Control Sorting: now correctly sorts negative numbers when sorting numeric values.

• Import Wizard: fixes an issue with the Import Wizard when selecting "[Empty Column]" items and then multiple Reported Amounts after that column which could cause additional unwanted empty columns between Reported Amount items.

• Import File Preview: fixes issue where application would fail if no import was selected when trying to preview the import file.

• Import Results: corrects issue where some import results for beneficiaries were not displaying on the import results screen.

• Benefits Import: when importing benefits for a person where some information is carried over from an existing benefit row to a new benefit, no longer adds the COLA history from the prior benefit row.

• Leading/Trailing Spaces in Worktrack Task Step Names: fixes an issue where a step would not display as completed if it contained a leading or trailing space in its name.

• Worktrack Request Emails and Address: when the mailing address either provided with the portal request or stored for a person is non-US, now includes the country name in automatically generated request email correspondence.

• Adding Sponsor Archive Documents to Folders: corrects problem where, when adding a document to a sponsor folder, it would appear in the root archive folder upon reopen of the sponsor.

• GETBENLIMIT Function: when getting a limit for a year that was prior to benefit payment start date, now returns the value for that year rather than not allowing the returned limit to be less than the benefit limit on payment start date.

• GETCALCINPUT Function: fixes problem with function GETCALCINPUT where the parameter code being evaluated was off by 1 (to get salary scale override for example, a user needed to specify an input parameter of 2 rather than 1).

• Service Provision Unrounded Remainder Option: fixes an issue where service could be understated when choosing this option.

• Average Earnings and Working Days Allocation: corrects issue when allocating rates of pay to monthly average earnings periods based upon working days in a month which could result in an overstatement of allocated earnings when there is a mid-month pay rate change.

• Account Provisions and Fractional Interest: makes additional adjustments to the prior release to better handle first year deposits.

• Plan Sheet Save: corrects issue with last release where changes to Plan Sheets could not be saved.

• Pasting to a Plan Sheet: fixes problem when pasting to blank cells of a Plan Sheet.

• Export Bookmark: corrects problem with new Export Bookmark feature where a table delimiter was sometimes not being added when dates for rows were displayed as year value rather than full date.

• Data Request and Comments Containing Quotes: with previous versions of DBP, a quotation found in a comment field for a person would stop display of all subsequent participants on any created data request.

• Portal Security Screen: fixes problem where fill button was not disabled when refreshing the screen for changing plan number or pressing the fill button.

• Sponsor Portal Security: no longer disables plan dropdown box if there are no participants listed on sponsor portal security screen (was preventing ability to create IDs in some situations).

• Scheduled Database Backups: fixes problem when DB Precision is configured to manage database backups where an error message will be displayed if the application server does not have the same mapping to the backup location as the database server.

• Patch 1.01: GETHISTDATE Function: fixes problem with initial release which could cause application stability problems when using the GETHISTDATE function along with a negative third parameter value.

• Patch 1.01: Create New Item: corrects issue where users would need to use the keyboard rather than double-click to select a new item to create.

Version 2019.19.5.22 - Released 05/22/2019

• Updated Interface: main interface has been updated to Office 2016 styling including new ribbon toolbars and replacement of the file menu with backstage view.

• SNFACCRUED Operand: includes a new operand that can be referenced on the optional payment form screen to get the single normal form of payment.

• MODE Formula Function: adds new Formula Function that returns most common item in a list of items.

• Breaks-in-Service: simplifies the break-in-service screen and adds support for hours-based break-in-service formula rules (previously, break-in-service formulas could only be evaluated based upon breaks from Historical Dates).

• Export Definition Bookmark Sections: includes new functionality where users can now include standard DB Precision calculation detail displayed as tables for items such as service and account calculation detail by adding and then referencing Word document bookmarks.

• Status Overrides: users can now create a Reported Amount that can be used to override valuation status codes (active, terminated vested, etc.) determined by DBP.

• New Status Determination Rule: Receiving QDRO/Deferred Retirement Annuity: if a person is receiving a QDRO and also has a deferred retirement annuity, participant will now be treated as dual status.

• Multiple Assumption Definitions and Snapshots: when running a snapshot where there are multiple Assumption Definitions for a sponsor, DBP now properly picks the default assumption for the plan (if specified). Prior versions of DBP required the user to choose the assumption even when a default was specified.

• Lifecount Reconciliation and Participant Death: now looks at default beneficiary rather than the beneficiary in the first tab when determining whether there is a beneficiary upon death.

• Data Request: fixes problem when generating a data request where, in rare instances, an invalid joint-and-survivor percentage could appear for dual-status participants.

• Using Tab Key on Calculate and Export Screens: corrects issue when using the tab key on either the calculate or export screens which could cause the incorrect items to enable or disable.

• Export Definition with No Default Assumption Definition: when an Export Definition has no default assumption specified or calculation history stored, now automatically selects the plan default or first assumption definition for the plan when running a plan-level export.

• Excel and Word Integration: brings both Word and Excel to the top when opening external Office documents.

• Zip Code Import: removes dash from zip code on import if it is the right-most character in that column.

• New Person Wizard: prepopulates more fields such as address and beneficiary information when manually creating a new person from another person using the New Person Wizard.

• Portal Emails and Group Code Restrictions: when a participant is in a group that a Sponsor Contact has no access to, emails on task start and end are no longer sent to that contact.

• Email on Worktrack Task Start/End: now will only send portal emails on task start/end if specified for an individual task (previously sending was solely dependent upon settings specified for sponsor contacts and administrators).

• Worktrack Tasks: corrects issue where optional steps that required all prior steps to be completed could be completed out-of-order and before other prior steps had been completed.

• Worktrack Report: now disregards comment dates when developing each task's last update date for this report.

• Pasting Blank Cells to Person Worksheet: corrects problems from pasting blank cells to cells in a Person Worksheet which could result in validation errors.

• Portal/Sponsor Transaction Logs: adds an additional column for item name on the sponsor transaction log participant detail and portal transaction log exported items to simplify filtering and sorting (had previously been combined in the action column).

• Optional Form Rename: when a Benefit Payment Set Definition has multiple provisions, now allows users to rename options to be the same name as options in a different provision or definition.

• GETSVCSTARTLATEST: fixes issue where DBP would return a provision start date if it fell after latest employment date and the periods were based upon Reported Amounts.

• Non-annual units and Consecutive Period Averaging: when averaging non-annual units, corrects issue where the 401(a)(17) limit was being prorated for people with less than one year of earnings.

• Account Provisions and Fractional Interest: corrects calculation problems for this option.

• Account Provision Screen: screen has been modified to provide more clarity on screen items.

• Certain Period Entry: corrects problem on Annuity Factor and Conversion Factor Definition screens which previously prevented entry of a non-zero value for the certain period if fixed certain period was not selected.

• Maximum Certain Period and Beneficiary Fraction under 401(a)(9): when an option includes both a certain period and contingent benefit fraction, now properly determines maximum allowable benefit fraction using ages as of the end of the certain period.

• Plan Export Item Copy/Paste: corrects problem on Export Provision screen where when previously copying/pasting, conversion values would not be retained on document save.

• Export Item Screen: corrects issue on the Item Export Screen where the application would fail when changing format type for a Benefit Payment Set optional benefit where the new Benefit Payment Set did not have the same optional form of payment.

• Person Transaction Log Screen: adds functionality to archive filter checkbox.

• Person Transaction Log: corrects problem where invalid transactions could be added to a participant's transaction log when participant changes are made through the portal.

• Find Screen and Portal Controller Log Screen: fixes an issue where the screen would not display after a user pressed escape on either of these screens (required restart of DBP to display again).

• Plan Document Loading: improves loading times for plan documents.

• Beneficiary and Export Beneficiary Selection: improves the way that beneficiaries are selected when running calculations and exports.

• Patch 1.01: Application Start: corrects issue when opening DB Precision after previously closing it from multiple monitors where the application had been closed from the right-most monitor. With the original release, the application would then open as minimized.

• Patch 1.01: Mortality Table Paste: fixes issue with this release when copying to a mortality table where the pasted cells would not populate with the copied values.

• Patch 1.02: Portal Registration Codes: fixes issue where a primary key violation could occur during the process of generating portal registration codes for a sponsor's participants.

• Patch 1.03: Plan Sheet Save: corrects issue with this release where changes to Plan Sheets would not be properly saved.

Version 2017.19.3.25 - Released 03/25/2019

• 415(b) and Employee Contributions: now properly only limits the employer portion of the benefit when appying 415(b). Previously was applying to the whole benefit which could then result in an understatement of benefit amounts.

• Reported Amount Additional Identifiers: will now only import additional identifiers for Reported Amounts if the indicator for that amount is specified within the sponsor.

• 2019 Pension Portal: includes security compatibility with 2019 Pension Portal.

• Multiple Derived Date Provisions: corrects issue resulting from when a Derived Date Definition has multiple provisions where the returned date was being invalidated if it fell outside a provision's date range.

• Beneficiary Entries on the Portal and Average Beneficiary DOB: when using average beneficiary DOB on the portal (for plans that allow this), the youngest beneficiary is now identified for purposes of disallowing options under 401(a)(9). Previously, this was only being done for calculations completed in DBP.

• GETCADOB and Portal Calculations: now properly returns beneficiary date of birth for calculations done on the portal. Previously, this was returning missing DOB.

• User-specified Values: includes new formula operands (USERVALUE1, USERVALUE2, and USERVALUE3) that represent user entries completed by the user at the time a calculation is completed. Note that only the next-generation portal will support this new functionality.

• Maximum Certain Period and Beneficiary Fraction: provides new option that develops survivor benefits, conversion factors, and annuity factors using the maximum certain and/or beneficiary fractions allowed under IRS 1.401(a)(9)-6

• 415 Limit and Optional Payment Forms: a new choice to apply the 415(b) limit separately to an option without CAF adjustment has been added.

• Unknown Hire Date: Plan Sponsors can now be configured to allow for unknown hire dates (common for multiemployer plans).

• Portal Usage Statistics Screen: fixes issue where the count shown for the item "Participants Logging in During Period" could be understated.

• Person Worksheets and Orphan Records: corrects problem which could occur when saving a Person Worksheet where an orphaned record could be created if all employment dates and benefit information were deleted for a person.

• Multiple Server Access: for prior versions, the Transfer Data button (between servers) was enabled/disabled based upon restore rights. Now it is based upon multiple server access.

• PIA Earnings Amounts: permits Formula Derived Items to be used as PIA Earnings Amounts (previously could only reference Reported Amounts).

• Copying Data Between Servers: fixes problem where the application would fail when copying to a server where the sponsor already existed.

• Changing Servers: under the prior version, users would be unable to add participants or save items after switching servers within the same application session. In addition, an error message would be displayed when opening the Manage License screen after changing servers. These issues have been resolved.

• Projection of Reported Amounts with Multiple Identifiers: when projecting Reported Amounts that include the usage of additional identifiers, now consolidates final amounts that have the same effective date for purposes of projection.

• Sample Participant Names: sample participants can now have numeric characters in their names ("Sample #1" for example).

• Average Earnings and Option to Include Final Period if Increases Average: corrects issue in prior versions of DBP which previously could understate the average when using this method.

• Database Transfer Sponsor Transaction: when a data transfer is made between servers, that transfer is now recorded in the sponsor's Person Transaction Log.

• Formula Detail Screen: fixes stability problem that could occur when double-clicking on a Formula Derived Item in the calculation results screen if any plan definition in the plan did not have any provision.

• Status Code Determination: for plans that are frozen where a participant received a lump sum of his/her retirement benefit and is then rehired, no longer classifies the participant as a cashout if the person's vesting percentage has grown since rehire date.

• Reported Amount Import Item Conversion: corrects issues with the "Fill" button when setting up conversions for Reported Amount import items.

• Grouped Average Earnings Periods and 401(a)(17): fixes problem when using grouped average earnings along with the 401(a)(17) limit for participants with less than one year of service where the application could fail on calculation.

• Saving Data for Participants on Portal: corrects problem with last release that resulted in crossover participants receiving an invalid error message that the data could not be saved when it was in fact saved.

• Formula Autocomplete and Tooltips: includes enhancements to formula tooltips and automcomplete such as scroll button support for newer operating systems, wider selection box, and other display improvements.

• Sponsor Employer/Company Name: fixes issue which would prevent updates to any sponsor employer/company whose name included an apostrophe.

• 2020 417(e) Mortality: adds support for the recently published 2020 417(e) mortality table.

Version 2017.19.2.8 - Released 02/11/2019

• PIA Level Income Option: includes new options for rounding PIA payment age when Social Security payment date is selected.

• Item Renaming, Deleting, and Find/Replace: corrects issue which could cause the application to fail when performing an item deletion, rename, or find/replace within a plan document that has a plan design problem.

• Drive Mapping Overrides and Exports: fixes an issue when using drive-mapping overrides (see System Settings) where the Word document for an export could sometimes not be opened.

• Export of Employee Contribution Benefit Detail: adds new exportable items that allow for details of employee-contribution derived benefits to be included in exports.

• Social Security Earnings: includes a new reported amount type, Social Security Earnings, that may be stored with effective dates that are prior to hire date. This then allows for the proper determination of Social Security Primary Insurance Amount (when full Social Security Wage history is known).

• Beneficiary Relationship: when beneficiary relationship is changed to none on the portal, all corresponding information for that beneficiary is now removed (same as when this change is made within DBP).

• Sponsor Changes Impacting Plans: corrects problem when renaming either a Reported Amount, Assumption Definition, or Employer Amount where those changes (including those automatically made to the plan) were not being recorded in the change log.

• Beneficiary Relationship and Missing Beneficiary DOB: now treats a beneficiary as existing when calculating for a person when that beneficiary has a specified relationship but no date of birth specified.

• Microsoft Office 2016 Update: fixes issue impacting certain machines that were updated in January 2019 by a Microsoft Office update that could then cause DBP to fail on startup or during an export to Excel or Word.

• Annuity and Conversion Factor DOB Rounding: now includes next-highest as well as next-highest coinciding as options for date of birth rounding when determining annuity and conversion factors (previously only next-highest coinciding was a choice and the Conversion Factor Definition screen improperly described this as next-highest).

• New Beneficiary Formula Functions: adds three new formula functions, GETCADOB, GETCATYPE, and GETCACOUNT.

• Calculation Date and Payment Start Date on the Portal: new option was added that allows users to turn off the feature for a Plan Document where DBP will automatically back up the calculation date by a day when it is equal to payment start date.

• Data Cleanup Wizard: when updating terminated vested participants, now looks at Benefit Determination Method to evaluate whether the payment form is Modified Cash Refund (MCR) versus life annuity (DBP previously assumed all Benefit Payment Sets with Contribution Accounts were MCR).

• Person Reported Amount Screen: fixes problem with display which could occur after a validation message was shown on Person reported amounts screen.

• Plan Document Law Type: includes new dropdown that allows users to indicate what country's pension laws the plan is subject to.

• Crossover Data Blocking: includes new sponsor option that prevents external changes to shared data for crossover participants.

• Person Archives: changes are now included in the transaction log.

• Archive Renaming: corrects issue when renaming an archive where the tab title would take on the name of the archive until save.

• GETCALCINPUT Formula Function: adds new function that can be used to retrieve calculation input values.

• Beneficiary Death and Valuation Snapshot: when a participant receiving an annuity payment has a beneficiary that is deceased, now requires that all beneficiaries be deceased before overriding the payment form to life annuity when running a snapshot.

• Snapshot Comparison: corrects display issue when running a snapshot comparison where Formula Derived Items that are dates appeared incorrectly formatted.

• Corrupted Plan Recovery: if a plan is corrupted (due to lost database connection during document save for example), DBP now allows users to open the corrupted plan and fix the problem (previously required PensionSoft assistance).

• Duplicate Worktrack Tasks: corrects issue where two worktrack tasks with different task names but the same calculation dates and payment start dates would incorrectly be identified as duplicate requests.

• Compensation Limit and Dropout Periods: fixes issue when determining the compensation limit for non-annual, consecutive periods that included periods with $0 earnings where the compensation limit could then have been understated.

SIMPLIFY PENSION ADMINISTRATION
PENSIONSOFT CHANGE LOG
PLANNED ENHANCEMENTS
Planned DB Precision Enhancements

• Benefit Calculation Results: add ability to view a participant's benefit calculation results (from the calculation screen) in Word and/or Excel.

• PenChecks Integration: allow check writing using PenChecks payment services from within DBP.

• Unusual Portal Activity Detection: enable algorithm to detect unusual portal user activity (to protect against a user with stolen login credentials).

• QDRO Indicator and Amounts: create a way to store QDRO information that does not rely on reported amounts.

• Export Results Storage: add the ability to store results for plan level exports and also compare the results from two exports.

• Restricted Lump Sums under PPA: automate 60%/80% funding percentages impact on benefits and lump sums.

Possible DB Precision Issues

• None outstanding

Web Portal Enhancements

• Internal Help System: add detailed help popup window that varies content based upon web portal settings that vary by plan sponsor. Also allow for users guides that can then be linked for sponsors.

• Compensation and Benefit limits: add an option that makes this increase assumption a function of the salary increase rate provided by the user on the web.

• Worktrack and Benefit Elections: allow for the display of benefit options and allow users to indicate which benefit option is to be paid within a task.

• Worktrack and Benefit Calculations: allow users to populate Worktrack benefit options by running benefits on the web.

Web Portal Fixes

• None outstanding

©2019 PensionSoft Corporation, LLC | 860.540.3690 | web@pensionsoft.com