Vital Statistics
Duke University Medical Center
Durham, NC
Facilities Facts:
400 buildings, approximately 12 million square feet, all of it managed by ARCHIBUS.
Reasons for Implementing:
Needed to unite space-tracking data from a variety of sources to create a single accurate database.
Benefits Gained:
Increased confidence in the space data; easier indirect cost recovery reporting; enhanced planning and budgeting capabilities.
Business Partner:
Avatech Solutions, Inc.
Web Site:
The #1 Solution in the World for
Total Infrastructure and Facilities Management

Duke University Medical Center: Integrated Healthcare, Integrated Databases

Duke University Medical Center and Health System (DUHS) in Durham, North Carolina is consistently rated among the top hospitals in the country by U.S. News & World Report. The youngest of the nation's leading medical centers, DUHS operates one of the country's largest clinical and biomedical research enterprises, and quickly translates advances in technology and medical knowledge into improved patient care. Meanwhile, the Administrative Development Group (ADG), in Duke's Corporate Information Services, is dedicated to ensuring that space information is readily available to whomever needs it-whether they are space planners, corporate accountants, Duke architects, or Medical School deans.

Cutting through the Data Smog

ADG is one of the groups in Duke's Corporate Information Services department for the Duke University Health System, which consists of three hospitals and other clinical facilities. "In the past, Duke used a variety of homegrown systems to track space information," says Julia Trimmer, a Senior IT Analyst in ADG. But when the group was charged with creating an institutional space system, Trimmer found that space information was tracked in different places, for different purposes, and at different levels of detail throughout the University. The Medical Center Architect's Office had been tracking space in ARCHIBUS for a number of years for planning, construction, and renovation projects. CAD drawings of Medical Center buildings were linked to their space database via ARCHIBUS. View of the sprawling Duke University Medical Center In addition, the Plant Accounting department, which is responsible for tracking space and equipment assets, was using a flat-file database with the usual limitations. And just about every large Medical School department had their own separate "shadow" system to track their own space usage.

A STAR is Born

The ADG team started by creating a Web application that interfaced with existing ARCHIBUS tables in the system, then added some tables for Duke-specific data. This application is referred to as Space Tracking and Reporting system, or STAR. "STAR allows department administrators and space managers to edit their own space information," says Trimmer. "It's designed to let users split the rooms if necessary and tell us which organizations are using the room and for what purpose." Because STAR tables share the ARCHIBUS database, data is completely integrated. After purchasing some additional ARCHIBUS licenses for the Plant Accounting users, all institutional data at Duke is now tracked in one database.

A Multi-Purpose Database

Today, Duke is using this integrated space data in a lot of ways. For example, the Plant Accounting office carefully tracks research space for indirect cost recovery purposes. Allocation of costs-which ensures that "charge-backs" accurately reflect Duke organizations' use of services such as public safety and groundskeeping-has also become easier and more accurate. "The biggest win for us is that everyone is working with the same numbers," says Trimmer. "Before, when we had multiple systems, we had multiple sets of numbers, which could sometimes cause trouble."

ARCHIBUS data is used for other applications as well. The Health System uses the information for Medicare and Medicaid reporting, while the Duke Accounting division uses space data for forecasting, budgeting and year-end closing. The institutional space database feeds building depreciation cost allocation, resource planning efforts, and countless surveys and analyses. The Medical Center's CAD drawings and associated data are used by maintenance, delivery, safety office, police, fire, environmental services, clinical engineering, telecommunications, key shop, visitor services and probably dozens of others.

Achieving Accountability

Comparing research grants to the amount of research space departments occupy is an emerging trend at Duke. "There's a huge interest right now in accounting for the research space that's being used," says Trimmer. "We've created another web application that combines the space data with award and faculty data. This application shows decision-makers the dollars per square foot and other data that various entities are receiving through grants." ADG is considering extending this functionality to other Duke organizations in the near future.

DUHS is also looking into the possibility of adding other ARCHIBUS applications to its system, such as the Building Operations Management application. "The facilities office in one of the Schools wants to add ADA [Americans with Disabilities Act] information for classrooms-such as whether a specific room is wheelchair-accessible-with other maintenance information such as light bulbs, painting, and carpeting," says Trimmer. Adding photograph files to the database to identify these classrooms is another logical extension of this plan, a plan that so far has provided DUHS with a convenient way to share space information across the campus, the Health System, and Duke facilities across North Carolina.