Printer friendly version

Enterprise Project completes personnel data conversion

The Enterprise Project team recently reached a major milestone in preparation for the project's Release 2, which will include human resources, payroll, time and labor entry and advanced benefits functions.

In December, the team finished converting the Lab's personnel data from the legacy Employee Information System (EIS) to the Enterprise Project's new Oracle system. According to Doris Bryant, a member of the Release 2 technical team (IM-EP), "The amount of data that we needed to convert was staggering. Around 1.4 million personnel records existed for almost 200,000 people, a population that includes everyone who has worked for, contracted with, or officially visited the Laboratory during its entire history." These records are integral to Release 2's success, since they encompass information required for the Lab's badging system, as well as its equal employment opportunity reporting, training programs, time-and-effort entry, payroll and so on.

"Although my particular role was to lead the conversion strategy and to develop the conversion code used to migrate the data from the legacy system into the new Oracle system, it was only through the efforts of the whole team - Laboratory employees plus people who work for Oracle, IBM and other organizations - that we accomplished the conversion on schedule," said Bryant.

Bryant applauded the Human Resources (HR) Division for cooperating closely with the project team. "We began by reviewing what the HR staff needed, what data already existed, where that information was and how we needed to prepare the legacy databases for a trouble-free conversion," said Bryant. "After the conversion, we cooperated with HR again, this time to validate our converted data."

What's next? "For the next few months, the legacy EIS database and the new Oracle database will work in parallel," Bryant said. "As employees enter information each day into the old EIS program, we will migrate that data nightly into the Oracle program. This ensures that the two systems remain 'in sync' and prepares us for two major events: retiring the EIS system and adopting the Oracle software as the system of record for personnel data."

For more information and updates, go to the Enterprise Project's Web site at http://ep.lanl.gov/ online, or contact the Enterprise Project Office at 5-9067.

-- Brooke Kent

Other Headlines