Promiso, our workload measurement program, stores details about how resources are utilized in your organization. This makes it a rich source of data for other applications: data, for example, to update the general ledger, determine costing, complete decision-making models. These other applications often provide an interface to import external data. We have created two companion products to extract the data you require and export it: Management Information Systems (MIS) Statistical Export Utility and Case Costing Export Utility.
MISSEU exports data from the perspective of the profession providing the services. It capitalizes on Promiso's ability to capture workload and relate it to elements such as client type, contact type, cost centre, and age group. You create MISSEU reports row by row, specifying the fields you need in each. You might start with the report span and continue with rows of statistical account numbers and the corresponding workload or caseload. Copy features facilitate repetitive work from row to row and one profession to another. Once a report has been created it can be saved and run as required (e.g., every month). Each time it is run, it iterates through the database and writes to an export file in ANSI Standard Delimited Format (SDF). This file can then be imported by the receiving applications.
CCEU exports workload data from the perspective of the recipient of the services. It takes advantage of Promiso's ability to track workload by client and the profession providing the service. This is the extract to run if you need to know time spent providing services to individual clients. The data is typically required by case costing programs, hence the name. When setting up this report you export workload per client or per client plus encounter number. Here's the difference. Client extracts retrieve data for each client over the date span you specify at run-time. If you choose to extract per encounter number then data will be retrieved per client broken down by the encounter number assigned at the time of service delivery. In either case, you can select to have the output as totals for the date span or as totals for individual days within the date span.
If you are looking for a simple way to produce files to feed applications that require MIS statistical or case costing data, you will appreciate the benefits of MISSEU and CCEU immediately: • No specialized skills required, no need to involve information systems people (and to wait until they're available) • No need to learn the database schema or understand table relationships • Build your reports using an assortment of fields, setting their length and other properties (e.g., justification, number of decimal places) to get the information you seek in the required format • No need to redesign reports should we make changes to the Promiso database: we take care of updating MISSEU and CCEU fields accordingly