What is the logicof Global name and local name columns population in per_all_people_f table.

I am trying to understand the logic used to populate the Global and local name column in the per_all_people_f table , once i enter the preferred name in the people form both column data becomes same. Can someone help me understand this .

Thank you.

Rajat.