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

• Screen Restrictions: Adds additional restrictions to certain items on screens such as Import Provision, Export Provision, and Person Historical Date to help prevent unintended user actions.

• Person Address Change Date: Changes to this date are now recorded in the Person transaction log.

• Server Explorer: Corrects issue where an Internet Controller could disappear from Server Explorer view until that Interner Controller was restarted.

• Drives Mapped in DB Precision and Excel Documents: Fixes issue where DBP was unable to open Excel documents when mapped through DBP rather than Windows.

• Only import if Current Value is Missing: Expands this import functionality to include participant and beneficiary name and address fields.

• Registration Emails: Adds ability to have these sent and managed by DB Precision.

• Worktrack Task Internet Portal Request Configuration: Includes modifications when users select rounding options for calculation and payment start date restrictions that prevent invalid rounding of dates when such dates are a function of the current date.

• GETSTATUS Function and Related Items: now looks at all valuation snapshots when determining latest status, not just those with a run number equal to 1, and gives precedence to snapshot rows with a higher run number.

• Export Items and Dates: adds option to ensure that DB Precision does not export an item formatted as a date.

• Option to Allow Negative Account Balances: corrects issue when using this option which would zero out balance from a negative value if there are multiple provisions.

• Long Mortality Table Descriptions: now allows for mortality table descriptions that exceed 255 characters in length.

• Export Account Details: Updates the export process to ensure that when exporting Account Definition details, where there are multiple details on different calculation dates, that the details as of the account determination date are the ones that are exported.

• Sponsor Portal Security Setting: Includes new setting allowing for the separate specification of access to updating sponsor portal security on the portal.

• Average Earnings Reported Amount Allocation - Rate of Pay and Working Days (Months, Days) Allocation: Corrects issue where the allocation would be understated when using this allocation method if an amount was for a period less than one month.

• Sponsor Archive Import: Fixes issues on the Sponsor Archive Import screen which were preventing users from specifying an archive description within the file as well as using a calculation date of none (1/1/1800).

• Portal Calculations and Archive Descriptions: Now includes payment start date or calculation date in the archive description.

• 2022 §417(e)(3) Mortality: Updates the §417(e)(3) automatic floating mortality to reflect 2022 rates.

• User Groups: Fixes problem where certain settings (Server Explorer Access and Web Portal Virus scan settings) were not being passed from group-level settings when a user was in a User Group.

• Validation Results Errors Screen: Corrects problem on this screen where when double-clicking a result in filtered display to get details, details for the wrong error could display.

• Sponsor Import: When importing a file and choosing the option to allow critical errors and writing errant rows to a file, fixes issue where a "general error" could occur that then prevented the writing of such rows.

• Portal Open Participant Display: Supports display of the latest snapshot date for status display on the participant open screens (last name and last initial).

• Portal Reported Amount Summary: Adds new option to suppress the display of Reported Amounts in the portal summary and print options.

• Portal Reported Amount Summary: Adds new option to suppress the display of Reported Amounts in the portal summary and print options.

• Benefit Payment Imports: Now displays all details regarding participant-only, both-only, and beneficiary-only changes made on import.

• Sponsor Items Copy/Paste: Allows any Import Definition, Import Provision, or Person Worksheet that does not include a Reported Amount as well as any Task Definition to be copied between different sponsors.

• Plan-level Export: Fixes issue when completing a plan-level export where the application would fail if there was a circular reference in the calculation date, payment start date, lump sum date, or account determination date.

• Actuarial Equivalence Flat Interest Rate Adjustment: Now ensures that a flat interest rate adjustment does not reduce an interest rate below 0.

• Security Report: Corrects issue on the sponsor contact tab of the report where the modified date could appear on the wrong row of the report.

• Adding Person with Tab Open: When adding a Person with no tab open, the application no longer fails.

• Points-based Derived Dates and Age Rounding: Corrects rounding issues associated with this combination of plan specifications.

• New Plan Wizard: Now warns users if they have not opened the payment forms tab before completing the wizard.

• Person Worksheets and Phone Numbers: Corrects display issue for when phone numbers do not include area code.

Version 2019.21.4.8 - Released 4/8/2021

• Default Import Values: Now allows users to specify default values for Reported Amounts when importing.

• Suspension of Benefits Assumption: Users can now specify for an Assumption Provision that a Suspension of Benefits (SOB) notice is issued on NRD if the issuance date does not already exist for a participant.

• Custom Worktrack Email: Provides additional options for variablized text when creating a custom email for Worktrack.

• Email Archive on Worktrack Request: Adds new options to hide recipients on generated archive as well as to block participant access to that archive.

• Sponsor Payee EIN: Adds the ability to store sponsor EIN for a payee.

• Relative Value Display: No longer displays items as having "same" relative value when the option to not display relative values when within the corridor for a Benefit Payment Set Provision is turned off.

• GETCADOM Function: New function allows for newly created date of marriage.

• Negative Account Balances: Includes option to allow an Account Definition to return a negative value.

• Maximum Account Interest Rate: Includes the ability to specify a maximum interest rate for an Account Provision similar to minimum rate specification.

• Account Provision Interest Determination: Includes new options to determine partial interest amounts based upon whether a year is a leap year (then prorates using a denominator of either 365 or 366).

• Account Provision Interest Handling: Adds new checkbox for accounts that do not credit interest on inter-year interest that is credited.

• Portal Calculation Hidden Items: Now allows both calculation date and payment start date to be hidden (provided that they do not cross reference each other).

• New Export Items: Adds ability to export plan number and sponsor EIN when running an export.

• Beneficiary Date of Marriage: Includes ability to store marriage date for beneficiary information.

• System User Rights: Includes new toggle buttons to set access rights to: all, none, or view.

• Valuation - Other Reports: Adds new report to identify possible death benefit payments due for deceased participants.

• Valuation - Other Reports: Adds benefit description to the end of the PIA level income and disability Excel reports (similar to ending certain period report).

• License Administration: Now, only System Administrators can delete other user's licenses on the License Administration screen.

• SSN Changes on Portal: Changes to SSN can now be made by sponsors and administrators when SSN is displayed.

• Participant Payment Detail: Supports display of benefit payment detail for individual participants on the portal.

• Adding Sponsor Text Conversion Definition to Folder: Corrects issue where users could not add a text conversion definition within a folder.

• Beneficiary Name Import: Fixes issue where import of beneficiary name did not display properly on the import transactions list.

• Date Received Import: Now allows for this date (Reported Amounts field) to be equal to 1/1/1800 (to indicate no date) or blank.

• Person Worksheet Column Selection: Corrects issue on Person Worksheet screen where the application would fail if the Columns list was double-clicked but not item was selected.

• Plan Sponsor Deletion or EIN Change: Worktrack now properly updates upon deletion or EIN changes to a sponsor.

• Benefit Payment Set Minimum Accrued Benefits: Corrects issue which could cause benefits to be understated when a person had a termination date stored, worked past NRD, and the Benefit Payment Set Definition included recurring minimum benefits.

• Relative Value and Married Participants: When determining relative value for a plan that compares relative value for married participants to the married normal form, now requires that the beneficiary be indicated as being the spouse.

• Average Earnings Provision Reported Amount Adjustment: When multiplying a Reported Amount, now multiplies by an adjustment factor (previously, this only worked for non-rates of pay).

• Account Definition Circular References: Adds validations that an Acccount Definition does not cross-reference itself.

• Mortality Projection and Age Setback/Setforward: When using a mortality projection in an Actuarial Equivalence definition along with an age setback/setforward, now only adjusts the base table with the age adjustment.

• Data Cleanup Wizard: Corrects issue when running the data cleanup wizard where clicking on a row would not open the correct person.

• Lifecount Reconciliation: Corrects display issue when lifecount grid contains more than 8 footnotes.

• Valuation - Other Reports: Corrects for display and other processing problems when running Other Reports from the valuation tab.

• Worktrack Task List: Now correctly hides Worktrack tasks for users that do not have participant view access for a given plan sponsor.

• System User Copy/Paste: No longer copies recently opened items when pasting from another user.

• Write Access to Sponsors and Plans: Corrects issue where, when opening a sponsor or plan in two sessions (same User ID), the item could become unlocked where a second user could then gain duplicate write-access.

• Internet Controller and Microsoft Processes: When the Internet Controller is launched or restarted, it now only kills current Microsoft Word and Microsoft Excel processes that belong to the Internet Controller's Windows user on that server (to allow the controller to run on a server being used by other Windows users).

• Multi-core Processing: Includes additional code to clear out all participant vector remnants from core factories prior to processing multi-core tasks.

• Sponsor-level Archive Saving: No longer changes the description of corresponding participant documents when the the sponsor description has not been changed.

• Patch 1.01: Corrects problem with current version which could cause the Internet Controller to be unable to open certain participants with an active Worktrack task.

Version 2019.21.2.4 - Released 2/4/2021

• Worktrack Email: Includes new options to suppress automatically sending email to Worktrack Task requestor as well as option to not include requestor information block.

• Sponsor Payee Information: adds support for depository/payee information that can be defined on a sponsor-level.

• GETNOLOCATE Function: Adds new function to indicate whether a person can/cannot be located based upon the corresponding indicator in the database.

• GETCADOD Function: Adds new function to get beneficiary date of death.

• Account Provisions and Lump Sums: Option to treat lump sum distributions as account transactions has been added.

• Account Provisions and User-defined Interest Rates: Provides new option to credit interest at intervals based upon dates that user-defined rates are specified.

• Export Bookmark Totals Option: Now displays totals for any Formula Derived Item columns.

• Export Bookmark Zero Rows: Includes new option to not display rows that have all zeros for values.

• Certain and Joint and Last Survivor: when running a snapshot, now adjusts payment form when the beneficiary has deceased (similar to what is done for other contingent-dependent payment forms).

• IRS Section 436 and Small Benefit Cashout: no longer restricts small benefit cashout payment (under $5,000) when IRS Section 436 applies and the plan is less than 80% funded (AFTAP).

• Ending Certain Period Report: Now adds benefit payment description (user-specified item) to the Excel version of this report.

• Data Cleanup Wizard: Adds new option in the data cleanup wizard that consolidates multiple Person names into a single name.

• Capitalization Functions: Enhances internal capitalization functions to not override name/address capitalization when such capitalization has already been been specified.

• Hire Date Import: When unknown hire dates are allowed and an import replaces that unknown hire date, now includes estimated indicator in that new date if specified in the import.

• Status Override Reported Amount: Corrects display issue where converted status values would not display in the Person Reported Amount dialog box or snapshot file.

• Optional Benefit Separate Formulas: Now applies partial vesting percentages to beneficiary, both, and relative value results when a separate benefit formula is used (previously, this was only done for the initial benefit).

• ANNUITYFACTOR Function: Corrects issue where beneficiary age would not get recognized when a participant had no beneficiary.

• Function of Service Calculation Detail: Fixes calculation detail display when there are multiple Function of Service Definition results.

• Function of Service Calculations: Now reflects estimated dates of hire if they are prior to non-estimated when calculating.

• Interpolated Mortality Rates Distribution Method: When using the Interpolated Mortality Rates distribution method, now allows for separate pre-payment mortality to be used.

• Derived Dates with Points Requirement and Unrounded Dates: When using a Derived Date with a points requirement and no date rounding where the underlying Service Definition is elapsed time, no longer automatically rounds resulting date to next-highest coinciding month.

• Export Definition Bookmarks: Fixes problem where only one bookmark could be saved per definition.

• Internet Controller: Corrects problem that could cause an account to not be calculated on the Home page summary.

• Plan Export: DB Precision no longer stops reponding when running a group-level export where there are no export rows in the selected Export Definition.