Attachment_E_-_Glossary_of_Systems_Applications_and_Tools.pdf

Attachment E

Glossary of Systems, Applications, and Tools

Spectrum

Spectrum is OBA's web-based participant database and benefit administration system.

Spectrum allows users to:

• Manage payments.

• Manage customer data.

• Perform data loads of all plan members.

• View and update customer information.

• Manually add and bulk-load data.

• Create, edit, suspend, resume, terminate, and reinstate payments.

• View ledger information.

• Change payee status.

• Make standard data fixes.

Spectrum integrates with other PBGC applications and services, including (AWA), CCS, CRM, IPS, and infrastructure elements.

Image Processing System (IPS)

System primarily used for imaging all plan and participant related documents. Documents in IPS are available online for review as part of the electronic file.

Customer Relations Management System (CRM)

The Customer Relationship Management system is the central repository for all participant communication. The system tracks the following customer interaction types: phone, email, paper correspondence (IPS), web (MyPBA), Appeals Memos, and OBA Referrals (ARTIS).

LEO

Database Tool used for Building Participant Databases

Actuarial Calculation Toolkit (ACT)

Actuarial Calculation Toolkit (ACT) is used by actuaries to define how a plan must be valued and how benefit statements for that plan should be generated. ACT also allows the actuary to define how a plan benefit estimation calculation is to be conducted, prior to final valuation.

Case Management System (CMS)

The computerized system for tracking events and inquiries that affect the viability of a pension plan. Each event/inquiry which opens a case is tracked to closure. Contains pension plan data and information submitted by plan administrators. At each step in the case, PBGC employees make inputs to the status of the case, milestones, and actions affecting the case.

Oracle Primavera P6

Oracle Primavera P6 is the system used to construct and maintain the case work plan.

Additionally, can be used for time tracking.

Approval Worklist Application (AWA)

Approval Worklist Application used for submitting payment authorizations for approval/rejection of customer transactions.

Pension and Lump Sum System (PLUS)

Pension and Lump Sum System. A disbursement system used only by State Street Corporation (SSC) to handle check writing and tax reporting for annuity and lump sum payments.

Customer Correspondence System (CCS)

Automated Letter Generation System that allows users to communicate quickly and efficiently with PBGC customers via automated, standardized letter templates, which may also be customized as-needed.

Participant Locator

A desktop application tool used to locate customer addresses. The application permits staff to send queries to a commercial database for an individual's addresses. The participant's name, SSN and PBGC case number are required to enter a query. Participant Locator stores PBGC search results in a database, and first checks the existing database for the participant information before sending the search off to the external agent.

PDF to Excel Software

Software tool used to easily convert PDF documents to editable Excel format

SharePoint

SharePoint is a web-based, collaborative platform that integrates with Microsoft Office and used to create websites and primarily used for a document management and storage system.

SharePoint can be used as a secure place to store, organize, share, and access information from almost any device.

Payment Adjustment Calculation System (PACS)

This system is accessible through PBGC's Intranet and calculates:

• Benefit adjustments arising from underpayments and/or overpayments resulting in back payments or recoupment.

• Interest on lump sum payments

COGNOS

Agency Performance Metric Tool used for Performance Reporting

MyPBA Is a software program that allows participants to submit certain forms and update their personal data via the PBGC Web site instead of by mail or phone. Using MyPBA, participants may conduct such transactions as:

• Apply for benefits

• Request a Benefit Estimate

• Submit the Payee Information Form (PIF)

• Designate a beneficiary

• Apply for Electronic Direct Deposit

• Designate or edit Federal Tax Withholding information

Archive Access The Archive system stores all the historical data for a case including as applicable, electronic payment data from a plan's prior paying agent, the electronic source data used to build the participant database, the sampled participant database and the finalized participant database and the finalized plan valuations. The Archive system allows you to select a case and then view or copy any file associated with that case. Users can also access more than one case at a time.

ARES

Participant overpayment recovery tracking tool