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

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

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

• Beta 1.01: 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.

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

• Beta 1.02: 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.

• Beta 1.02: 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.

• Beta 1.02: 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.

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

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

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

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

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

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

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

• Beta 1.04: 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.

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

• Beta 1.05: 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.

• Beta 1.05: 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.

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

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

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

• Beta 1.07: 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.

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

• Beta 1.07: 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.

• Beta 1.07: Average Earnings Reported Amount Allocation Method: adds new allocation method, Next-lowest month (months, days).

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

• Beta 1.07: Multicore 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 th plan was not properly coded for this.

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

• Beta 1.07: 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.

• Beta 1.07: 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.

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

• Beta 1.07: Portal Calculation Wording: adds ability to override calculation screen wording.

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

• Beta 1.07: 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).

• Beta 1.07: 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.

• Beta 1.07: Archive Import: now confirms that the person exists for a sponsor before allowing import of an archive for a person.

• Beta 1.07: Portal Benefit Payment Saves: 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.

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.