This is a work instruction document for IWK's integrated management system. It describes the step-by-step procedure for downloading and processing e-billing data from the BRAINS system. The document is intended for staff who generate monthly e-billing reports.
This document is a work instruction for IWK's integrated management system. It provides a step-by-step procedure for downloading and processing e-billing data from the BRAINS system. The intended audience is staff responsible for generating monthly e-billing reports.
The first section covers generating the monthly e-bill report after month-end processing in BRAINS. It details how to use the IWKEBILLDLD screen to extract data by provider and status. The process involves running a query that takes approximately 12 hours, then importing the resulting text file into MS Access.
The document specifies a series of MS Access queries to be run in sequence. These queries produce summary tables for total registered e-bill accounts, non-active accounts, and accounts with outstanding balances over 12 months. The data is split by class and service level, with amounts shown in RM.
A separate procedure covers processing Pukal accounts under the Government class. This involves linking data from the GovtProp table to identify accounts not registered with e-billing. The queries filter accounts by rate code and service level to produce a final table.
The document also describes processing e-billing vendor reports received after live bill runs. Reports in .csv format are appended to an MS Access file using specific queries. The queries update columns for email status, pfile numbers, and cost codes, and create summary tables for bill status verification.
The final section covers the e-bill dashboard and includes appendices showing the BRAINS IWKEBILLDLD screen, the e-bill folder structure, and examples of vendor reports. The document provides reference tables and query lists for the complete data processing workflow.