DBDevNet, LLC

1
Schwab Retirement Technologies?
Partnering for Success with DBDevNet, LLC July
2003
2
Focused on Your Success
Technology
Technology
3
DBDevNet, LLC
Database Consulting Software Development
Network Consulting

• Schwab Retirement Technologies
• Consulting Partner

4
Introduction to DBDevNet, LLC

• DBDevNet, LLC was founded near Raleigh, NC by
  Dawn and Jeff Brown in 1994
• The Browns have provided consulting services to
  clients that utilize the Schwab RT Recordkeeping
  system for more than twelve years
• DBDevNet provides a full range of services for
  users of the Schwab RT software

5
DBDevNet, LLC Services

• Consulting
• Training
• Custom Software Development
• Documentation

6
Consulting Services

• Provide consulting services in the following
  areas
• Reconciliation of plan and participant accounts
• Departmental operations and procedures
• Conversion of plans from predecessor systems
• Recordkeeping of plans

7
Microsoft SQL Server Consulting Services

• Provide assistance in the following areas
• Preparation/clean-up of data prior to conversion
  from Pervasive to SQL
• Migration of data to SQL version of Schwab RT
  Recordkeeping

8
DBDevNet, LLC Training

• Offer the following types of training
• Operation of the Schwab RT Recordkeeping software
• Utilization of the TBOL report writer
• Development of reports using Crystal Reports

9
Custom Software Development

• Develop the following custom software
• TBOL programs
• Crystal Reports
• Trade Data Interchange (TDI) software
• Custom add-on applications

10
Custom Documentation

• Create the following types of documentation
• Customized Schwab RT Recordkeeping module
  documentation
• Customized daily operation procedures
• Customized programming documentation

11
DBDevNet Software Products

• Automated End of Day process
• Average Daily Balance Extract
• Data Dictionary File (DDF) Utilities for Schwab
  RT
• Loan Distribution (LDT) Extract Utility
• Investment Program (IPM) Fund Balances Extract
• Toolbox for Schwb RT

12
Automated End of Day

• Allows users the ability to export End of
• Day data from all Schwab RT directories
• Extracted data written to ASCII text file
• May be utilized to balance Schwab RT
  Recordkeeping system to fund vendor or trust
  systems on a daily basis

13
Average Daily Balance Extract

• Calculates and extracts average daily asset
  balances
• for participants
• Can populate a Microsoft Access database or
  produce
• an ASCII text file
• Produces two types of reports
• Plan Detail Report
• Plan Summary Report
• May utilize extracted balances for calculations
  of asset-based fees, or to provide more detailed
  information for revenue-sharing calculations

14
DDF Utilities for Schwab RT

• Provides a group of modules that enable Schwab RT
  users to perform many reporting and audit
  functions
• Enhances productivity by allowing the user the
  ability to
• process reports and utility functions across
  paths, plans
• and participants
• Offers numerous built-in reports for meeting plan
  sponsor and participant reporting requirements
• Extracts SRT RK data in both MS Access and ASCII
  text formats to provide flexibility for producing
  plan sponsor and participant reports

15
DDF Utilities for Schwab RT

• The following reports may be produced
• Participant Statements
• Participant Status and Balance Report
• Participant Age and Balance Report
• Confirmation Letters
• PIN Notification Letters
• Global Asset Holdings
• Fund Breakdown Analysis

16
DDF Utilities for Schwab RT

• Additional reports are as follows
• Plan Accounting by Division
• Cash Balance Report
• Negative Unit Holdings Report
• Pending Batches Aging Report
• Headcount Report

17
DDF Utilities for Schwab RT

• The following utility tools are available
• Find a Participant
• Participant Audit
• Execute Your Crystal Report
• Participant Data Extract

18
LDT Extract Utility

• Extracts loan and distribution data residing in
  the LDT file on Schwab RT
• Can populate a Microsoft Access database or
  produce an ASCII text file
• Provides data in a format that can be utilized
  for purposes such as cash reconciliation

19
Program Fund Balances Extract

• Extracts Investment Program Fund (IPM) balances
  for participants
• Produces an ASCII text file
• Can be executed in an unattended mode
• Provides the ability to show detailed balance
  information
• for each asset comprising an IPM

20
Toolbox for Schwab RT

• Provides a group of modules that allow the
  ability to perform data analysis and auditing
• Tools may be utilized for daily operations or to
  prepare for data conversions

21
Toolbox for Schwab RT

• The software provides for the auditing of the
  following Schwab RT files
• Plan Index
• Participant Balance Records
• Assets
• Tax Maps
• Vesting Schedules
• Report Headers
• VRU

22
Toolbox for Schwab RT

• Additional elements that may be analyzed and/or
  modified are as follows
• Primary Status Codes
• Tax and Description Codes
• Plan Synoptic Data
• TDI Link Data
• Asset Data

23
Toolbox for Schwab RT

• The following utilities are also provided
• VRU PIN Export
• VRU PIN Import