1	Producing the EPRI DATABASE with the DATA HARMONY SUITE
2	ABOUT EPRI Headquartered in Palo Alto, California Founded in 1973 as a private, public-interest, not-for-profit organization The Electric Power Research Institute (EPRI) addresses society's most urgent and important needs related to electricity and the environment. EPRI's integrity is anchored on its ability to provide a clear and credible voice through the development of independently verifiable scientific and technical research. EPRI's researchers are independent scientists and engineers with total freedom to assure solid science is brought to bear on challenging and often controversial issues.
3	"Now known simply as EPRI" Now known simply as EPRI, the company provides a wide range of innovative products and services to more than 1000 energy-related organizations in 40 countries. EPRI employs a multidisciplinary team of scientists and engineers. EPRI is committed to its mission to lead public-interest research on key issues facing the power industry on behalf of all electricity stakeholders and society. Environmental research is regularly submitted to outside scientific committees and to peer-reviewed journals to assure it meets every criterion of best scientific practice. “Electrify the world!” (a service mark of the Electric Power Research Institute, Inc.)
4	"Air Quality" Air Quality: Supporting the development of effective and protective policies, standards, implementation plans, and compliance strategies Distributed Resources: Providing grid, system, or customer benefits, such as standby generation, peak shaving, combined heat and power, prime power, premium power, or renewable power Electric and Magnetic Fields and Radio Frequency: Informing regulatory decision-making and public opinion and ensuring the health and safety of both occupationally exposed workers and the public Electric Transportation: Increasing market penetration of electric vehicles to enhance economic development and contribute to a cleaner environment Environmental Benefits of Nuclear Power: Working to ensure that the potential contribution of nuclear energy is fully recognized as an element in resolving the global climate change issue
5	"Future Coal Generation Options" Future Coal Generation Options: Accelerating research into coal generation technology with the vision of developing a new fleet of highly efficient, low-emission, moderate-cost, and flexible coal-fueled power plants Global Climate Change: Facilitating science-based policymaking and effective technical and business decision-making Integrated Environmental Controls for Fossil Power Plants: Helping power producers optimize pollution control and plant performance to provide for a cleaner environment while serving the public need for electricity Land and Groundwater Issues: Protecting natural and human environments, and retuning previously contaminated sites to productive use Occupational Health: Minimizing workplace injuries unique to the electricity sector and increasing the effectiveness of health- and safety-related investments Renewable Energy Resources: Developing market-based and technical solutions for the integration of renewable energy sources into the electricity grid, and gauging the performance of emerging renewable power generation technologies Water, Watershed, and Ecosystem Issues: Integrating management of water resources, energy facilities, and natural ecosystems
6	OUR ROLE (EPRI Project Staff at Access Innovations , Inc.) DATABASE SUPPORT Step 1: Transfer of Publications from EPRI Text from publications and sometimes entire publications are sent by EPRI via email attachments. A product identification number has been assigned to each publication that we receive. Each item has a completion deadline. We receive and process mostly Product Descriptions, Report Summaries and Software Descriptions. Other Publications include: Brochures, Fact Sheets, Newsletters, Technical Reports, Project Opportunities, Events, Report Summaries, Product Descriptions, Software Descriptions
7
8	"Step 2" Step 2: Data Entry A content management system or software tool known as XIS from the Access Innovations, Inc. Data Harmony product line is used to fit required text into related fields. Content from document attachments is keyed in or copied and pasted into text-related fields. Text is also abstracted, edited, and formatted. The product identification number on each item transferred to us is important. It is entered into the XIS NATS field and the Report No. field. This number is deliberately entered into two fields. In the NATS field for exportation and in the Report No. field for future retrieval. All product ID numbers are imported from EPRI into a so-called NATS table in our database. When an editor enters the product ID number into the XIS NATS field, it is automatically matched to its corresponding number in our NATS table. A record will not export to EPRI’s database without the product ID number in the NATS field. If a record is missing its NATS number, it can be accessed by it corresponding report number.
9	"Step 3" Step 3: Indexing After applicable text is entered into respective XIS data fields, keywords and other indexing terms are added to describe the document content. The system we use for applying indexing terms is a machine aided indexer (M.A.I) software tool also from the Access Innovations, Inc. Data Harmony product line. M.A.I. increases indexing efficiency and consistency. Based on the document’s content, it presents a list of approved terms to the editor for selection. It helps save the time of looking up terms manually, thereby speeding up record processing. Step 4: Spell Check and Quality Control (QC) To complete the data entry process, each document is spell checked and ‘QC’d’ for accuracy.
10	SYSTEM FOR DATA ENTRY XIS Software Application
11
12
13
14
15	XIS Software Application Expanding XIS Fields
16	SYSTEM FOR APPLYING INDEXING TERMS M.A.I Software Application
17
18	M.A.I Software Application If the MAI list of suggested terms does not produce the expected results, an F2 search in the MAI function can be initiated to obtain desired keywords.
19	F2 Searches for Keywords and Other Indexing Terms
20	OTHER REQUIRED PROCESSES INVOLVED IN XIS DATA ENTRY HTML Tagging and Coding HTML tagging and coding allow the following to display properly on EPRI’s website: Subscripts and superscripts ( especially useful for chemical and mathematical notation) Special characters (bullets, Greek characters, accents, dashes) ‘Clickable’ links for e-mail addresses and URLs
21	Examples of HTML Tagging and Coding
22
23
24	Editorial Shortcuts Copy and paste text: from Microsoft Word and Adobe Reader attachments
25	"F2 function key" F2 function key: generates a drop-down ‘pick list’ box in certain fields
26	"F4 function key" F4 function key: copies text from a given field in a previous record into the identical field of a working record F5 function key: spell checks entire record Asterisk (*): for truncated searches of indexing terms MAI function on Publication Title and/or Subtitle: to zero in on the most significant terms quickly as in this example:
27	ELECTRONIC TRANSFER CYCLE EPRI IMPORT/ACCESS EXPORT Import: An import is required prior to every export. Before completed publications can be transferred from our database to EPRI’s, every document record must have a product identification number in the NATS field. A document will not export to EPRI’s database without a number in this specific field. A scheduled import from EPRI updates product ID numbers and other vital document information in the NATS table in our database. Records with missing product ID number are matched at this time.
28	"Export" Export: A scheduled weekly export transfers completed and updated publications to EPRI’s database. Quite often, EPRI will request an additional export. EPRI staff extract the files we export to their database and place the new publication records online for availability to their members, clients, and prospective members.
29	Continuing Advances in XIS Software Expansion of the rule base for M.A.I.: Create, edit and review rules in the M.A.I. Knowledge Base to increase indexing efficiency and consistency Expansion of Thesaurus to enhance indexing capabilities: Note frequency of potentially useful indexing terms appearing in documents but not yet included in Thesaurus Master Expansion of Spelling Dictionary: Editors add terms to the Dictionary to increase its accuracy *Note: These functions are performed occasionally through periodic updates.
30	COMPLETED DOCUMENT As It Appears On EPRIweb
31
32
33