Charlotte These seem to be the facts Oracle has a (nearly?) complete set of job descriptions and department codes, but no level information Your Excel spreadsheet contains an outdated or incomplete set of codes for company, department, level and position, but crucially not the full job description that would match what is in Oracle (or does it?) You simply do not have enough information to proceed with an automated derivation of job codes that could be made consistent with what is already in Excel (and what I suspect is being used downstream in reporting). The only possible join is on Department code, if indeed that is consistent, and that does not have enough granularity to match existing position codes with Job Designations. You could set aside the excel version and just produce new codes from the Oracle extract, treating the Level information as missing. Then try and match the new version with the excel table, using it to update Level information for those jobs where the new job code matches the existing excel position code. I'm guessing there will be mismatches which will cause havoc with downstream processing, which might be alleviated by keeping everyone informed. If the spreadsheet did contain job descriptions (as in Oracle) you could make some further progress and be more consistent with existing codes. You could use existing position codes where they matched job descriptions in Oracle, and code of the type I have suggested to create new ones as required. You could fill in Level information where it exists, and leave the rest blank. The rest would have to wait for a downstream project. It may not be too big a job to manually match Oracle job designations to the existing codes. A company of 700 is unlikely to have 700 unique job designations, so if you sort both tables by department code and job or position and put them side by side many matches will be obvious. It may even be quicker at this point to create new position codes for jobs that are missing form excel. If you can do this you will have a lookup table that can convert Oracle job designation and Department to company, department code, (partially to level), and position code; which may be all you could hope for in the short term. Richard
... View more