Correct Worker Name Capitalization

Whether it is imported from an outside system or manually entered, sometimes worker names are not in a Proper Case (First letter capital, the rest lowercase). This can be cleaned up automatically using a custom report and a Studio Integration.

The custom report should filter for workers whose names are All Capital Letters or all Lowercase letters. Then the Studio will import this, correct the case and update Workday.

Alternately, if the incorrect case is coming from a third party source, like a Recruiting system other than Workday, the code to find and correct capitalization can be integrated into the Hire Integration.

One Caveat: This solution does not correctly capitalize some last names like McDonald, or Van Buren. IT is possible to build a list of common complex names to ignore, but this may need to be updated periodically.