- CSEA KEIKI HATS
- HANA C.M.S.
- FRS CASE STUDY
KEIKI HATS System
The Child Support Enforcement (CSEA) assists custodial parents, guardians and caretakers with getting the financial and medical support they need to responsibly raise their children. To provide this assistance, the CSEA utilizes KEIKI—an automated system developed in the mid-1990’s to facilitate child support case tracking and case management functions. The KEIKI system is an essential tool utilized by the CSEA to administer the child support program.
The KEIKI system was developed in the 1990’s utilizing technologies such as Adaptable Data Base System (ADABAS) and the NATURAL programming language. The frontend for the application, or GUI (Graphical User Interface), was written in Microsoft Visual Basic 4.0 (VB).
Though the KEIKI system consists of multiple parts, the two main components are the frontend and the mainframe. The frontend is where the user is able to add, update, and delete data. While the mainframe is where the actual application and data reside. The problem the CSEA faced was two-fold, the frontend was outdated and the new solution needed to be able to communicate with a legacy mainframe application.
CSEA wanted to expand and modernize the KEIKI system. The first step in the KEIKI modernization process was to web-enable the frontend. Instead of upgrading to a current version of Visual Basic, CSEA saw this as an opportunity to migrate the frontend to a browser based solution.
This introduced another problem, not only did the new frontend have to be web-based, but the new frontend needed to communicate with the State’s legacy mainframe with minimal modifications to the existing application. The State’s mainframe is where the KEIKI system currently resides.
eWorldES implemented a solution using IBM’s WebSphere Host Access Transformation Services (HATS) to communicate with the legacy mainframe and JavaServer Pages (JSP) to display the web based GUI. Since eWorldES has extensive experience with HATS and JSP, we were able to leverage our knowledge of CSEA’s core technologies (ADABAS / NATURAL) to develop and implement a successful solution. In the end, by combining these technologies, we were able to implement a flexible web based front end for the KEIKI system with minimal modifications to the application itself.
How the Solution Works
HATS acts as a server that allows for communication with KEIKI’s mainframe. No modification to the mainframe application was necessary. The JSP pages are able to call the HATS server, allowing the pages to send and receive data to and from the mainframe application. HATS also allows for the ability to combine multiple mainframe screens into one JSP web page which speeds up the form filling process for users.
By combining HATS and JSP, eWorldES was able to successfully take screens from the mainframe application and convert them into html pages with rich text and controls.
- Now uses the supported technologies HATS and JSP
- No need to modify the original legacy application code
- Application now has a modernized look and feel
- Application interface is web based as opposed to a VB application
- No need to install a physical application thus lessening the footprint on the users machine
- KEIKI’s web interface is the first step towards possibly making the system available to the clients
HANA Client Management System
Client information is one of the most valuable assets. Keeping your client information up-to-date and having instant access to that information is essential to your success. The Client Management System (CMS) has been designed with your success as our goal.
CMS is a cutting-edge, multi-tier client, web-based application for case management that has been developed by hands-on users over a 8-year period. The CMS is also an information management solution that is user friendly, intuitive, powerful, and cost-effective. CMS provides quick access to all of your client's information without ever leaving your desk. With CMS, you can easily print forms, reports, ID-Cards, and much more.
You have the ability to establish views, information and workflows that are important to your office. Different users, departments, and offices can customize the software to meet their specific needs. CMS is built to fit your needs and improve organizational performance. Our solution offers an intuitive interface and its table driven features allow key system parameters to be changed with minimal effort.
Traditionally, organizations have used several different applications to manage their business and practice activities. Our clients are able to eliminate the cost of purchasing separate applications to manage their client cases by employing a single system that can deal with all of their client requirements.
Imagine having an entire client file right at your finger tips—every document, every email and every contact—everything relating to a file instantly available to every user at the same time. No longer will you have to share a hardcopy file amongst your team. Can’t find what you are looking for? Client Management System provides searching within each module. Just type in the keyword(s) you are searching for and view the results.
A name, part of a name, address, phone number, Social Security number, birth date, and specific role are all potential search qualifiers. This expanded search capability reduces time spent trying to identify the correct client, and eliminates duplicate entry of client information.
Focus on the Client
Client Information System lets customer service representatives, agents, and clients enter, edit and review all information in real time via an Internet browser. Client Management captures, stores, and displays information about any individual, household, or business entity that has a relationship with your organization.
With a full picture of the client easily accessible throughout your enterprise, professionals can manage customer service, marketing services, and detect potential fraud with increased accuracy and efficiency.
Client Management System may receive client information from several sources, including online entries, existing systems and batch processes, and may even include third-party vendors. It gives you a comprehensive view of a client, with access to complete client information including alternate names, multiple client addresses, telephone numbers, email addresses, tax identification numbers, demographic information, competitor information and all client relationships. These relationships show how a client is connected to other clients, such as family members or employers, as well as relationships to policies, claims, and billing accounts.
The Client Account process will allow Service Representatives to group clients together using common information. Relationships, types of account, contact, and account members can be used to identify clients in a client account. An example of an account view could be a household view. The account is established, and all clients related to the account are associated by the Client Management System, including all businesses related to that household. This view provides not only a total, comprehensive view of the client or household, but also provides ease of maintenance. You have one place to update common data to the members of the group such as address, phone or e-mail address. The updated information will display when viewing each member’s separate data. You can easily create new client account relationships (between either new or existing clients), add additional members to an existing account or remove a member’s relationship to an account.
Client Management System moves nearly all client-related forms onto the computer. Forms are filled out right on the computer and others may be printed out and filled out by hand. In either case, CMS provides a form repository that contains a consistent, easily-accessed set of your organization's forms.
Forms that are filled out in CMS have a unique ability - They pull common data from a database and eliminate the need for filling out a client's name, address, SSN, county, phone number, etc., from form to form. Filling out common information only needs to be done once, and it will be inherited to other forms from then on.
Client data can be easily accessed by logging onto the system. Don't waste time digging through filing cabinets. With just a few easy clicks of the mouse, you can be quickly looking at any client's information.
Record keeping will be greatly simplified by the automated intake and file creation possible through CMS use. Service Representatives simply create and update client files through CMS as contact occurs, saving time and space.
If you are interested in being able to know what was said, when, and by whom, then you can use CMS which keeps a historical repository of all contact between clients. The ability to view the logs is governed by the user’s program security rights.
Alerts is a feature in Client Management System we create for the explicit purpose of 'forcing someone to be made aware of something'. In CMS, alerts are not intended to be passive, and the intended recipient(s) do not have a choice as to whether or not they see them. By putting important information into the Alert File, we guarantee that Service Representatives will see all alerts.
The Activity Log captures all processes that occur to a given client thereby allowing a Service Representative to look at one screen and immediately understand what system actions have been taken with the client.
Data integrity is an additional benefit. Using the Client Management System as a central storehouse for client information, the Service Representative updates client information only once. CMS stores the new and updated information, which is immediately available to any other application.
Client Management System takes every precaution regarding the electronic transfer of client level data, including firewall protection, encryptions, and access security.The framework provides a secure operating environment for both internal users and external partners through:
- Authorization and organizational structure management
- Implementation of flexible security profiles by use of transactions and worker groups
- Appropriate auditing and administration tools
The system can be configured to allow secure online access to your client forms and records. You have the ability to choose who can be allowed to view data online and what data they are able to see.
If reports are what you are looking for, Client Management System gives you the ability to automate reports to be sent to clients, management, and staff. Extensive statistics on your organization's operations can be used to pinpoint trouble spots are immediately available when needed. Easily-accessed statistics on the services you provide daily, can be used to communicate the need for change with outside entities and plot a course for your organization's future.
The Benefit of Experience
Just as important as the software you buy is the company who will support you. We know your business and provide the technology to get the job done. Every aspect of the implementation of our system is handled directly by personnel who have been implementing sophisticated case management systems for years. Our clients tell us that the service they receive, consistently exceeds their expectations. If your firm is looking for the best way to improve the efficiency of your operation, eWorld Enterprise Solutions can show you how.
- Manages client/case information from start to finish
- Provides case managers with several ways of looking at client, case, and report data
- Reduces client wait time through instant access to client data
- Gives complete picture of case status
- Provides complete, accurate and consistent data
- Offers immediate documentation for informed decision-making or regulatory compliance
- Handles unlimited number of cases and case managers
- Completes all processes in a single system
- Reduces paperwork
- Maintains reliable client data through Data Integrity checks
- Protects sensitive information
- Timely reporting
DOE Financial Report System
The State of Hawaii, Department of Education (DOE) Financial Reporting System (FRS) project got underway on December 8, 2008 to create an Oracle-based financial reporting capability that draws financial information from record databases, such as the Budget and Financial Management System (FMS). The original project was defined in two phases: the first was to create a set of financial reports and the second was to create a star schema architecture for these reports. The DOE would later adopt a SQL-based architecture and integrate new data sources such as CHAPS/eHR and Payroll & Property into the system.
The DOE depends on data in its daily operations and before the creation of the Financial Reporting System (FRS), financial data was stored in various databases across multiple platforms. This made the production of meaningful and timely financial reports a challenge for the DOE.Not only did the DOE need to consolidate its financial data, it also needed to expand the reporting capabilities of the existing system. For a given fiscal year, the DOE needed new reports to be able to:
- Determine FIFO (First In First Out) grants and Non-FIFO grants expiration status, time period and associated balance remaining, how the grant funds were distributed to which organization and programs; how the funds were expended.
- Generate a financial statement for a specific school to help improve the planning and implementation lifecycle.
- Present the cost decomposition (drill-down) of a specific objective code against a given program for an organization within the DOE hierarchy.
- Generate a trial balance anytime within a fiscal year period to assess the financial status of a given program or organization.
eWorld Enterprise Solutions (eWorldES) enhanced the reporting process by creating a web-based interface for FRS. Not only did this new web-based system open the doors to a much larger audience within the DOE, but it also made the retrieving and viewing of reports vastly more efficient. Before FRS, reports would have to be retrieved from their respective department’s mainframe application, such as FMS, where someone would have to manually gather and corroborate the data to generate a report. eWorldES was able to streamline the DOE's financial reporting process through data consolidation. Financial data from various sources was consolidated into a unified database and surfaced using .NET and SQL Server.
How the Solution Works
The DOE’s Financial Reporting System is based on industry standard technologies such as .NET, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
The first step was to consolidate the financial data. The fact that this data resided on disparate systems, utilizing a variety of technologies presented challenges. SSIS was used to retrieve data from the non-SQL Server data sources such as: Mainframe applications, SharePoint lists, and Oracle databases. The majority of the existent SQL Server information was retrieved dynamically, when a user requests a report, because the data is confidential and cannot be stored. The non-confidential data is stored in a Financial Operational Data Store (FODS), which is where the generated reports get their data.
The next challenge was finding an effective way to generate the reports from the newly centralized data. When a user requests a report via the web, a set of SQL Server stored procedures are called to generate an in-depth financial report based on the users criteria. To address all of the DOE’s specific financial reporting needs, there are multiple stored procedures written that perform calculations on the data stored within the FODS.
- Consolidates the DOE’s financial data
- No longer need to manually interact with mainframe applications
- Widely accessible due to web-based form
- Reports allow for ‘drill-down’ capabilities
- Creates meaningful and timely reports