Reviewed Dev initial design on the SODI to link to prefix table, suggested pentaho objects that he can use, Instructed to create additional Pentaho transformation that would handle the transmission of data to cache and staging table in Pentaho