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

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

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