PENSIONSOFT CHANGE LOG
PENSIONSOFT RESOURCE LINKS
2020 DB PRECISION UPDATES
Current Beta Version

• Beta 1.01: Formula Functions: adds additional validations to formula functions to make sure that the appropriate type of definition is being referenced when a function is specific to a type of definition.

• Beta 1.01: Renaming Sponsor Items: includes additional coding that ensures that an Assumption Definition, Text Conversion, Reported Amount, and Assumption Definition never matches another item in the sponsor where there is a potential naming conflict.

• Beta 1.01: Late Factor Override: users can now specify a Formula Derived Item to use for actuarial increase when calculating the late factor for a Benefit Payment Set.

• Beta 1.01: CAF and Annuity Factor Interpolation: includes new option to calculate annuity and conversion factors at integer ages and then intepolate for non-integer ages.

• Beta 1.01: COLA Deferral: adds new option to define COLA deferral periods as Formula Derived Items.

• Beta 1.01: Export Provision List: now displays any column header overrides in the list on the Plan Export Provision screen.

• Beta 1.01: Export Counts: users can now export row counts in their export file.

• Beta 1.01: Adding Participant Benefits: ensures that when adding a benefit to a participant, that the benefit history is not carried over from the latest benefit payment stored to the new benefit (previously this was only being done for imported benefits).

• Beta 1.01: ANNUITYFACTOR Function: corrects issue when using the ANNUITYFACTOR function mutiple times within the same calculation that could cause DBP to not recalculate factors if calculating for two ages with the same integer age value but different fractional age values.

• Beta 1.01: Payment Distribution Processing: includes licensing options interface in support of PenChecks distribution integration release.

• Beta 1.01: Multi-core Processing Support and Core Utilization: increases core support from 16 core threads to 32 core threads when running processes in DB Precision that utilize multiple threads.

• Beta 1.01: Withholding Percentages: allows withholding amounts for federal, state, and local to be indicated as being a percentage of the gross benefit payment.

• Beta 1.01: Benefits on Person Worksheet: corrects potential problems which could occur if editing or deleting benefit information using a Person Worksheet for participants with multiple benefit amounts.

• Beta 1.01: Benefits Wizard and Lump Sum/Deferred Benefit Check: if checking for participants with an extra deferred benefit where a lump sum was paid, now does not recommend deletion of the lump sum if the person was rehired after the lump sum was paid.

• Beta 1.01: Registration Code Creation: when managing portal security, users can now select participants for registration code creation.

• Beta 1.01: Service Period Units and Elapsed Time Minimums: includes new option to not apply elapsed time minimums to full periods.

• Beta 1.01: YEARFRAC Function Basis Option: adjusts new basis option released with Version 2019.20.6.8 for matching Excel YEARFRAC function that includes additional adjustments for dates that fall at the end of the month to further match Excel.

• Beta 1.01: GETSAMPLEIND Function: this new function allows users to determine whether a participant is a sample participant within the plan coding.

• Beta 1.01: Worktrack Report: corrects problem where worktrack report was showing latest update date as comment date if a comment was added after the latest step update.

• Beta 1.01: Deposit Types: adds IRA and Employer Plan as new choices for deposit institution types.

• Beta 1.01: Level Income Option and Snapshot: when running a snapshot and using the monthly benefits option, now also displays the final benefit as a monthly amount.

• Beta 1.01: ANNUITYFACTOR Function: includes new optional parameter to override beneficiary age.

• Beta 1.01: Person Worksheet and Reported Amount Display: when opening a Person Worksheet in DBP, now displays Reported Amount cells based upon the number of decimals specified for the display format of that amount.

• Beta 1.01: Reported Amounts and Text Conversions: fixes problem with loading participants on the portal when using a Text Conversion for an amount that is viewable on the portal.

• Beta 1.01: Average Earnings Amounts Grouped by Totals: corrects display of average earnings display when amounts are grouped by year where no more than 5 years of detail would be displayed.

• Beta 1.01: 415(b) Limit for Optional Benefit: when limiting an option to the unadjusted 415(b) limit, no longer applies the non-life annuity normal for adjustment (specified in the 415(b) section of the Benefit Payment Set Definition).

• Beta 1.01: 415(b) Limit for Optional Benefit: includes ability to now use a separate formula adjustment for determing the 415(b) limit for an individual optional form of payment.

• Beta 1.01: Average Earnings Rounding: corrects issue that could in rare circumstances cause average earnings to be off by a penny when calculating using highest consecutive.

• Beta 1.01: Address Import: no longer overrides the country name US to proper case (Us) when importing or editing in a Person Worksheet for a Person.

• Beta 1.01: Match Report: adds new option to include a Reported Amount such as a group code in listing results.

Version 2019.20.8.11 - Released 08/11/2020

• System Export and Worktrack: when creating an archive document using a system export, users now have the ability to attach the archive to an existing Worktrack task or create a new task.

• File Open Screen: now includes name suffix on all listings shown on the File Open screen where applicable.

• Archive Import: now confirms that all people exist for a sponsor before allowing import of participant archives.

• Call Center Search: now supports multiple search result rows when a person is in more than one sponsor.

• Person Notes Report: when generating a Person Notes report without a sponsor open, now displays company name for each row.

• Person Notes Report: now includes column for note text within this report (up to 500 characters).

• Security Report: changes the way that administrator security information is retrieved to line up with the newer way that is now used by the Internet Portal.

• Last Address Change and Import: now displays prior address change date when importing addresss information.

• Worktrack Emails: includes the ability to show plan number and plan name as variabilized text includes in Worktrack emails.

• Portal Document Upload Notifications: includes new option to specify that sponsor contacts get notified upon sponsor document upload.

• MRD Date Determination: updates the determination of the Minimum Required Distribution Date to reflect changes made with the SECURE Act (April 1 folllowing age 72 if attained age 70.5 after 2019).

• GETMRDDATE Function: adds new function, GETMRDDATE that returns the Minimum Required Distribution Date for a Person.

• GETSOBDATE Function: adds new function, GETSOBDATE, that returns the date that a suspension of benefits notice was issued to a Participant.

• Average Earnings Reported Amount Allocation Method: adds new allocation method, Next-lowest Month (Months, Days).

• Portal Calculation Wording: adds ability to override calculation screen wording on the Portal.

• Portal Calculation User Rates and Values: includes option to hide show any user-defined rate or value.

• New Export Definition Type: adds a new Export Definition type that does not require a person to be vested or eligible for payment when exporting on the portal when used.

• DBP Version Number on Export: includes ability to export DBP version number in Export Definitions.

• Export Bookmarks: improves Export bookmark formatting including table autofit to page and currency formatting for first row of account detail.

• Portal Benefit Summary and Partial Vesting at Early Retirement Date: applies the vesting percentage if applicable at early retirement date when displayed on the portal's benefit summary.

• Portal Benefit Payment Saving: if a user enters an invalid plan number when editing a participant benefit payment, the Internet Controller now corrects the error if there is only one plan for a sponsor, and displays available plan numbers if multiple plans.

• Portal Call Center Interface: adds support for portal's new call center interface.

• Portal Open by Last Name: adds support for partial name matches when searching by last name.

• Database Transfer: adds coding to ensure that no participants are opened prior to allowing a database transfer.

• Login without Internet Connection: improves login time when DB Precision is unable to establish a connection to the license server.

• Read-only Lock: if clearing old users sessions, now unlocks items tagged as read-only on all database servers rather than the only for the one where the user is logged in.

• New User and File Menu: corrects issue which could occur after adding a new user and selecting a group where then application could fail when selecting the file menu.

• Valuation Snapshot and Exports: corrects issue when running an export where the application could fail when running snapshots for very large plans.

• Multi-Core Processing and Average Earnings on Valuation Extract: corrects issue when multiple cores are run for valuation which could cause the earnings array for terminated participants where zero earnings are to be displayed after termination date to not display if the plan was not properly coded for this.

• New Plan Wizard: when starting with an empty plan, no longer warns about or removes existing Word documents from the sponsor's default directory.

• Reported Amount Deletion: corrects issue where a database error would occur on document saving after a search/find was completed for a Reported Amount that was then deleted.

• System Import: corrects issue that could cause the application to fail if an invalid path was selected on file import.

• Portal Worktrack Comment: fixes issue which could occur if a Worktrack comment included the character '~' where the sponsor could then not be loaded on the portal.

• Benefit Payment Import: corrects problem when importing a dynamically calculated benefit with no benefit amount which could cause the import to overlay an existing benefit rather than import as a new payment.

• Calculation Display: corrects display issue where top heavy vesting percentage would disappear when toggling between annual and monthly benefits on the main calculation results tab.

• 415(b) Limit in GETBENPAYSET Function: now uses the 415(b) limit based upon the payment date passed through the function rather than the payment start date entered by the user when completing the calculation.

• 401(a)(17) Limit and Short Service Participants: fixes issue which could result in an understatement of average earnings when using the sum of earnings divided by total period for short-service participants.

• Function of Service Detail Display: corrects issue with Function of Service results display where year-by-year detail was not being displayed when configured.

• Interpolated Mortality Rates and Joint Life Annuities: fixes problem when calculating joint-life annuities and using interpolated mortality rates.

• Portal ID and Registration Code Export: corrects problem when exporting portal registration codes or user IDs which could stop the export from processing when multiple cores are used.

• Person Transaction Log: now separately records changes to day versus night phone numbers in the transaction log.

• Patch 1.01: Portal Call Center Interface: allows apostrophes to be included in first, last, and company name when using the call center search.

• Patch 1.02: Portal Benefit Editing: when editing a benefit payment on the portal that includes a cost of living adjustment, now makes the change to the latest benefit row rather than initial benefit row.

• Patch 1.03: Portal Reported Amount Editing: now supports portal modifications of Reported Amounts that are formatted as text.

Version 2019.20.6.8 - Released 06/08/2020

• Person Notes: adds support for Person Notes on the Internet Controller.

• Person Notes Report: includes new report showing details for Person Notes.

• Reported Amount Imports: fixes inability to import more than 1,000 amounts for a Person within the same import.

• Person Import: includes performance improvements for imports with large number of rows per person as well as for participants with large numbers of reported amounts already stored in the database.

• Portal Document Upload Notifications: includes new option to specify that sponsor contacts get notified upon participant document upload.

• Sponsor Contact Portal Edit Access: includes ability to suppress all participant data edit access for an individual contact.

• Assumption Provisions and Increase Rates: includes new option to define increase rates relative to a salary increase assumption.

• Worktrack Task Type: now allows for the specification of which types of users can select from the task type dropdown upon request (all users, participants, or sponsors).

• Late Retirement Final Adjustment: includes new option to adjust final late retirement benefit by a Formula Derived Item.

• GETBENPAYSET Function: adds new formula function, GETBENPAYSET, for getting benefit payment set amounts in a formula.

• CALCDATEBASIC Operand: adds new formula operand, CALCDATEBASIC which equals the calculation date (CALCDATE) but is not subject to any cap (DOT or CALCDATEINPUT).

• YEARFRAC Function Basis Option: includes new basis option for matching Excel YEARFRAC function and adds this option to account interest accumulation period fraction determination choices.

• Function of Service Detail: adds new option to display year-by-year Function of Service detail for functions that reference Reported Amount-based Service Definitions.

• Export Definition Messages: adds support for variable text within export messages.

• System Export: when exporting and changing an Export Definition, no longer retains the previous archive name already specified (if any was previously specified) in order to avoid accidentally creating mutiple archives with the same description.

• Portal Security Screen: replaces Delete All button with participant-level selection checkboxes and a Delete button for better selection of selecting portal information to delete.

• Lifecount Reconciliation Deaths: now separately identifies participant deaths that have a beneficiary receiving or due a benefit.

• Portal Controller Shutdown Setting: adds new setting that causes the Internet Controller to shut down if hung on a task rather than trying to resolve the stoppage itself (applicable for controllers that are launched using AlwaysUp or some other auto restart process).

• Status Determination: when determining status for a participant in a frozen plan who was paid a lump sum and then rehired, now properly determines that participant status to be a lump sum cashout when the option to exclude service prior to the payment of a lump sum is selected for credited service (was previously treating a participant in this situation as active).

• Address Import and Proper Case: when cleaning up address information items on import, now properly recognizes numbers after numeric characters as not needing conversion to lower case.

• Text Conversion Definition Import: no longer requires that text conversion values and file values have the same letter case to be determined to be equal on import.

• SPONSORAMTLOOKUP: supports other return types beyond the value of the sponsor amount.

• Contributions Remaining in Plan: adds additional coding to ensure that this value is never less than zero for calculating non-taxable basis.

• CALCDATE and Formula Derived Items: if CALCDATEINPUT is prior to a termination date within Historical Dates, CALCDATE is now capped at the greater of termination date and CALCDATEINPUT (previously was always capped at CALCDATEINPUT rather than greater of the two).

• Average Compensation and Service Definition Formula Freeze: includes additional coding to ensure that average earnings cannot go beyond a formula-based Service Definition stop date (defined for the underlying Service Definition that is referenced).

• DC Balance Override: now allows transactions that occur within the same year as a DC balance override and also corrects an issue where the override row was not displaying.

• Copying a Participant: fixes problem when copying a participant from one tab to another where benefit information and/or historical date information would not copy over.

• Person SSN Changes or Deletion: corrects issue which could cause portal information to not update upon person SSN change or deletion.

• Portal Controller Stability: corrects stability problem with the Internet Controller which could occur if the Word document of an underlying benefit calculation included an invalid merge field.

• Corrupted Benefit Formula and the Internet Portal Controller: when a plan becomes corrupted on file save (rare and usually results from database connection failure during save) the corresponding message allowing users to fix the error is no longer displayed on the portal server (was locking up the Internet Controller).

• Patch 1.01: GETBENPAYSET Function: corrects issue with new GETBENPAYSET function which could cause problems when exporting while using this function for a late retirement calculation when an adjustment was also applied.

• Patch 1.02: Valuation Snapshot Error: fixes invalid error message regarding over 20 snapshots being run that could occur which would then prevent a new snapshot from being run.

• Patch 1.03: Internet Controller and Assumptions: includes additional coding to ensure that the default assumption is always used for producing the participant benefit summary on the portal.

• Patch 1.04: Person Notes Duration: corrects issue which could cause the duration time for a new note saved on the portal to be incorrect.

• Patch 1.05: System Import: fixes issue with last release that could cause the application to fail or not save row changes for basic information where there were permitted skipped rows in the file (due to critical error or excluded new participants).

Version 2019.20.4.3 - Released 04/03/2020

• Call Center Interface: adds new checkbox to open the Person Note screen for a Person when opening that Person.

• Person Notes: includes additional variables within Person Notes designed to be used for call center tracking.

• Possible Duplicate People: adds detail to display additional results.

• Benefits on Person Worksheet: includes new option to display benefits on Person Worksheets as monthly amounts within the portal.

• 415(b) Service Overrides: adds ability to specify Formula Derived Items that then serve as service overrides for 415(b) limit determination.

• Non-taxable Contributions and Lump Sums: now correctly displays the non-taxable portion of lump sum payment amounts in the optional benefit display when a portion of the lump sum amount is non-taxable (previously showed a non-taxable amount of $0 for lump sum options).

• Grandfathered 401(a)(17) Limits: adds ability to specify that an Average Earnings Provision should use the pre-OBRA '93 compensation limits (for governmental plans that did not change to Post-OBRA 93 amounts).

• Account Provision: adds additional new methods for determining interest accumulation periods and now applies this determination methodology to partial period reductions when using the fractional interest rule.

• Annuity Purchases: includes new date for benefit payments to identify annuity purchases and displays them separately on the lifecount reconciliation.

• System Export: includes ability to export additional item detail for non-taxable basis.

• Export Item Paste Format: now copies all text conversion values during paste format operation.

• Ineligible Status Display on Portal: allows users to display ineligible participants as ineligible rather than active on portal listings.

• Database Transfer: have enhanced the transfer screen to not allow transfers of categories of database items that do not exist for the sponsor on the source server.

• Registration Code Export: added error handling to manage when Internet access is lost during the export of portal Registration Codes within a system export.

• Portal Request Email: now includes item detail choice if selected on a Worktrack request through the portal.

• Valuation Data Request: when creating the data request for participants that have contributions due and where balance amounts are dynamically calculated, now shows the "as of date" equal to the data request date.

• Create Valuation Snapshot Screen: when adding a new Snapshot, now pre-fills inputs from the last Snapshot run for that Plan number.

• Portal Benefit Summary and Formula Derived Items: now sets small benefit cashout date used in calculations of benefit summary and formula derived items on the home page to be equal to ACD rather than current date.

• Weekly and Bi-weekly Projections: corrects issue where the first weekly or bi-weekly projected period had an extra day (15-day initial projected period for bi-weekly projection for example).

• Late Retirement Accumulation Method: no longer forces users to set calculation date to be less than or equal to NRD to get the accumulation to grow from NRD.

• Benefit Formula Paste: removes copying of portal items during paste operation for Formula Derived Items to avoid possible subsequent plan save problems.

• Average Earnings Reported Amount Copy/Paste: fixes issue where not all details would be copied when copying and pasting an Avergae Earnings Reported Amount.

• Function of Service Detail: when exporting service detail amounts, service that is displayed now reflects service caps that are defined using year limits on rates.

• System Exports: corrects problem with last release that could cause selections of Derived Dates or Formula Derived Items as dates on the Export Screen to become invalid if a corresponding plan item was deleted.

• Night Phone Number Import: fixes issue where nighttime phone number could not be imported.

• Patch 1.01: corrects issue where the 415(b) compensation limit was by default using participation service rather than vesting service for the reduction of less than 10 years of service.

• Patch 1.02: fixes problem when vesting service requires a projection of a Reported Amount where a person who is terminated vested could be incorrectly identified as non-vested on the portal.

• Patch 1.03: corrects issue with current release that would cause the Excel view of the lifecount reconciliation grid to not display properly.

• Patch 1.04: for short service employees and average earnings, corrects and issue which could cause an understated of average earnings when subject to 401(a)(17).

• Patch 1.04: for short service employees and average earnings, reflects retroactive limitation rules for older calculations such as pre-EGTRA.

Version 2019.20.2.6 - Released 02/06/2020

• Multiple Core Processing and Optimization: changes the way that exports and snapshots are processed for improved processing speed.

• Reported Amount Deletion: includes new tool that simplifies the deletion of Reported Amounts.

• PPA Funding Status: adds ability to automatically restrict lump sum payments based upon the funded status of the plan (as indicated on the Plan Document Dates screen).

• Reported Amount Definition Portal Access: now provides two separate settings for Participants and Sponsor Contacts, allowing System Users to specify separate access for each user type.

• Import Item Additional Identifier Default Values: allows users to specify default values for Reported Amount additional identifiers.

• Reported Amount Item Imports for Amounts with Additional Identifiers: adds new option to always add new Reported Amounts to a Person by automatically increasing one of the additional identifiers rather than replace a matching Reported Amount if an exact match is found.

• Worktrack Request Restriction: adds ability to restrict which participants can initiate a Worktrack Request based upon status code (previously, users could only restrict based upon location code Reported Amounts).

• Comments when Completing/Authorizing Tasks: includes comments that are added during task completion/authorization in the email that is sent.

• Partial Lump Sum Distributions: includes new optional benefit payment form indicator that can be used to indicate which options should reflect a split between partial lump sum and annuity.

• Employee-paid Benefit: includes new option to not treat an employee-paid benefit as a minimum for accrued benefit calculation.

• GETCAFRACTION Function: includes new function that returns the benefit fraction for the specified conversion factor.

• New Elapsed Time Service Method: adds new method for calculating elapsed time service, No Borrowing (365.25)

• Account Provision: adds new option to apply partial period fraction to the interest rate rather than the period when assuming transactions occur some fraction from the end of the year.

• Account Provision: adds new method for determining interest accumulation periods that uses differences in days rather than a service-style calculation of differences in months and days.

• Exports and Archive Creation: includes new settings for specifying document type and portal access for running exports.

• Export Provision Screen: items may now be reordered using drag-and-drop.

• Person Notes: users can now indicate which Person Notes should be viewable the portal by participants and/or Sponsor Contacts.

• Valuation Snapshots: now allows users to select which snapshot to replace when a snapshot with the same effective already exists (previously always replaced run 1).

• Valuation Extract Filename: now includes both month and day of the valuation date in the default extract file name when running a snapshot (previously only included year).

• Custom User-Defined Variables: expands the number of user-defined variables (USERVALUE1 for example) from 3 to 10.

• 2021 417(e) Floating Mortality Table Support: includes support for 2021 417(e) mortality for when the floating 417(e) basis is chosen and where the measurement date is on or after the 2021 year.

• Portal Summary: includes support for "as of" dates in portal's benefit summary display.

• Sponsor Opened Read-only: fixes display issue where a sponsor opened read-only would display as if it had been opened with write access after a user opened the Sponsor Basic Information screen (even if it was still read-only).

• Alternate Status Determination: corrects issue when using service accrual based termination dates where a participant could incorrectly be treated as 100% vested after normal retirement date.

• Emails Sent through Portal: corrects problem which could cause the Internet Controller to be unable to send emails on task on/off hold or when adding comments to a task.

• Server Data Transfer: fixes issue where Sponsor Task Definition information was not being transferred when transmitting data between servers (Data - Transfer on the main ribbon).

• GETCA SSN, Sex, Type, DOB Functions: improved to return beneficiary information available when a parameter of 0 is passed to the function, even when no default beneficiary is selected.

• Elapsed Time Service - Work (months, days): corrects issue which could cause service to be understated when using this method along with allowing service to accrue through the end of the day.

• 401(a)(17) Limit and Short Service Participants: when using the method to sum all earnings and divide by the earnings period, now includes additional coding to ensure that the compensation limit is applied using 12-month lookback periods working back from termination date.

• Account Calculation Display: corrects account calculation display problem where interest transactions could be displayed prior to hire date.

• Account Interest Rate Rounding and Display: no longer forces user-defined interest rates to be rounded to 4 decimals (similar to handling for user-defined fixed rates) and displays interest rates based upon the number of decimals provided in the plan.

• 1.401(a)(9)-6 CAF Limits: when measuring limits for certain periods and beneficiary fractions under 1.401(a)(9)-6, now limits based upon the age measurement date specified (on the advanced screen) rather than always based upon payment start date (ACD).

• Annuity Factors and Interpolated Mortality Rates: now supports non-integer payment ages for deferred annuity factors.

• Patch 1.01: Portal Settings Screen: corrects issue where user-defined values for items 4-10 on the portal settings screen were not being saved.

• Patch 1.01: System Export: fixes rare instances where a problem with running an export could cause duplicate rows to be created on a subsequent export.

• Patch 1.02: Valuation Snapshot: when changing month or day for Effective Date on the screen to add new valuation snapshots, now correctly also adjusts the file name for those changes.

• Patch 1.03: Export Provision Items: corrects issue that could occur after reordering export items that could prevent saving of the plan document.

• Patch 1.04: 401(a)(17) Limit and Short Service Participants: fixes issue with current release which could result in an understatement of average earnings when using the sum of earnings divided by total period for short-service participants.

• Patch 1.05: Server Explorer and Controller Log: when viewing server explorer and the Interent Controller Log at the same time, corrects issue which could cause the number of items displayed in the log to multiply.

• Patch 1.06: Temporary Annuity Factors: fixes issue with this release that could cause a problem when calculating temporary annuity factors.