UQAR System Products

Economic Sciences Corporation's Utility Query, Analysis and Reporting System (UQAR) is a complete information system containing electric and gas utility financial and operating statistics for comprehensive utility analysis. Through user interface screens, users can access, manipulate, analyze, report, and graph financial and operating statistics for electric and gas utilities. UQAR's underlying OLAP software provides time-series database capabilities and permits analysts to perform rigorous studies quickly and efficiently, without programmer assistance. UQAR users are supported by ESC consulting personnel with extensive utility industry experience.

The Utility Query, Analysis and Reporting System is continually being maintained and upgraded. ESC strives to make this system the most comprehensive, accessible, and usable utility data system available while providing users with the lowest cost utility data source on the market.

eUQAR - The New Flagship Internet Gateway

eUQAR makes the entire UQAR system available through the internet with standard browsers. With simple browser dialogue screens users can view or download a vast array of time-series data reports and special analytic reports. Taking advantage of UQAR's powerful OLAP features, there is virtually no limit to the complexity of analytic studies that can be developed using eUQAR through the internet. While bringing extraordinary analytic power to users, eUQAR also relieves users of the large investments in time and dollars associated with installing and maintaining software and large utility databases on their own workstations.

eUQAR/390 - The New Energy Information System for Large Enterprises

eUQAR/390 is intended for enterprises with a substantial number of personnel requiring access to, and analysis of, energy information. eUQAR/390 is designed for installation and use of the entire UQAR System on client IBM System 390 computers operating under VM/ESA. The eUQAR/390 user interface utilizes exactly the same browser dialogue screens as eUQAR. The browsers simply link to the user's in-house servers instead of ESC's. eUQAR/390 can also be easily tailored and expanded to include enterprise databases and other databases to create a seamlessly integrated and powerful enterprise reporting and analysis system.

PC UQAR

PC UQAR operates on a personal computer in the Windows environment. The user can view and print reports, graph data, or transfer the data to other software applications for specialized reporting or analysis. With the PC UQAR user interface, there is no need to learn database software commands or utility account identifiers, so the user can immediately make effective use of the database.

DATABASE MODULES

FERC Form 1, Annual Report of Major Electric Utilities

The Federal Energy Regulatory Commission (FERC) Form 1 gathers financial and operating data used for formal financial and performance audits and for investigation of electric rates and rate levels. Collected data include all line items from: * balance sheet * income statement * cash flows * plant in service * depreciation, depletion and amortization * taxes * salaries * operating revenue, sales, and number of customers * electric operation and maintenance expenses * environmental facilities and expenses, and much more. Survey respondents are electric utilities and licensees with sales or transmission in each of the last three years that exceed one or more of the following: (1) 1 million MWh total annual sales; (2) 100 MWh annual sales for resale; (3) 500 MWh annual gross interchange out; or (4) 500 MWh of wheeling for others (deliveries plus losses).
Years Covered: 1982-1998

FERC Form 1, Annual Generating Plant Statistics

The FERC Form 1 contains steam generating plant statistics for all respondent large plants owned or operated by respondents. ESC enters this data into the UQAR System for cost of production, capacity and generation analyses and to analyze utility generation mix and age. Data for each plant include: * year of construction * capacity * generation * capital costs * operation & maintenance and * fuel consumption by fuel type.
Years Covered: 1987-1998

FERC Form 2 LDC, Annual Report of Major Natural Gas Utilities

The FERC Form 2 LDC module, unique in the market, is expanded to include annual local distribution company (LDC) filings with individual state agencies in addition to the major interstate gas transmission companies that respond to FERC. This all-inclusive database also covers major intrastate transmission and combination utility data as filed with state regulatory agencies. FERC Form 2 data are used by the Federal Energy Regulatory Commission for gas pipeline review and rate-setting, by the Energy Information Administration, state regulatory commissions, and the Economic Regulatory Administration. Collected data include all line items from: * balance sheet * income statement * cash flows * plant in service * depreciation, depletion and amortization * salaries * operating revenue, sales, number of customers * gas operation and maintenance expenses * gas account and * gas purchases.
Years Covered: 1984-1998

EIA Form 861, Annual Electric Utility Report

Form EIA-861 is a mandatory collection of data filed annually by each electric utility in the United States, its territories, and Puerto Rico. The survey collects data on: * generation and system peak * wholesale purchases * net wheeling and exchange * sales, revenue and customers by class and * demand-side management programs and impacts. Respondents include each electric utility that provides generation, transmission, distribution, or sale of electric energy primarily for use by the public.
Years Covered: 1990-1997

EIA Form 412, Annual Report of Public Electric Utilities

Form EIA-412 provides financial and operating data from publicly owned electric utilities whose annual sales to ultimate consumers, or sales for resale, are 120,000 megawatts or greater for each of the two previous years. These data are published and used in EIA studies of the electric power industry. Data collected include * balance sheets * income statements * expense data * electric sales and purchases * generating plant and * transmission data.
Years Covered: 1986-1997

Rural Utility Services Form 7

RUS Form 7 is filed by all electric utilities who hold RUS loans outstanding and whose primary operations are in the distribution of electricity within their territory. All line items are maintained from: * balance sheet * expenses and costs * plant in service * depreciation and amortization * statement of operations * demand and energy, and other schedules. Available through dial-up service.
Years Covered: 1985-1996

Rural Utility Services Form 12

RUS Form 12 is filed by all electric utilities who hold RUS loans outstanding and whose primary operations include the generation, transmission and/or distribution of electricity for sale within their territory or outside. All line items are maintained from: * balance sheet * expenses and costs * plant in service * depreciation and amortization * statement of operations * demand and energy, and other schedules. Available through dial-up service.
Years Covered: 1985-1996

EIA Form 826, Monthly Electric Utility Sales and Revenue Report

Form EIA-826 contains data on electricity sales to and associated revenue from ultimate consumers by class of service (Residential, Commercial, Industrial, Other, and Total). These data are used to study rates and price trends on a monthly basis. Respondents are a selected sample representing different types of utilities (private, public, and coop) spread evenly across the United States. Available through dial-up service.
Years Covered: 1985 - two mos. prior to current month

UPDATES

ESC is continuously updating, revising and expanding the UQAR System. All subscribers will be provided with the most current, accurate data possible and with new versions as they are released. Subscribers will be notified of any changes made to the System.

OTHER SERVICES

Economic Sciences Corporation provides customized information services using the UQAR System and our available resources. These services are designed to meet specific reporting and analytic needs. Selected data can be retrieved from the database, analyzed, and reported in accordance with specific client requirements. These services can be performed for a specific project or on a periodic basis. Pricing depends on project specifications.