It gives your sims different buffs (like 'sensory overload' and 'enjoying routine') and it takes these Sims longer to form friendships.
It's best to just read the descriptions for a full explanation of all the things that were changed, but it's mostly things that will make the careers feel more realistic and seamless during gameplay (like increasing the chance of emergencies in the Doctor career, or adding more co-workers to both careers).