Data Cleaning and Conversion

Lead: Anantha Kadur

UCDHS Contact: Drew Pokorney

  • Eliminating unnecessary data records
  • Identifying and correcting inaccurate or missing data
  • Merging duplicated data
  • Reformatting and standardizing data so that it can be converted
  • Gathering information that does not exist in any legacy system but is required in UCPath.
  • Identify (potential) duplicate records
  • Standardize address information based on the US Postal service zip code database.