Imported UW Data

We import several types of UW information into our database from other sources. This page describes the common framework adopted to manage this import process.

Specific sources handled through this system are:

• UWDir Extract (not yet) — data provided through UWdir.
• PeopleSoftDataImport (not yet) — data held in the PeopleSoft SA system.

Once the raw data have been obtained, processing is required in order to put the data in a useful form for importing into the database. This is done in a uniform manner according to the following steps:

• Check raw data
• Create temporary directory
• Pre-process raw data into form suitable for version control
• Update version control with pre-processed raw data
• Process version controlled raw data into database-ready form
• Update version control with processed data
• Run database input process on processed data

-- IsaacMorland - 02 Jan 2008