Extend User Source Properties

Say I have a user source, (from an active directory), list of records of all users with their credentials.
Each user on this table, has built in properties like roles, and schedule.

What if I want to add custom property, like location - designates where user in location hierarchy belong to. or profile image id property, that holds location to pull images from.

I am using this User's Location property in logic thru out the project.

How am I suppose to do that?
Can I copy(sync) the user source records to my created table on database?

or does that mean, I need to manually copy the active directory outside Ignition, and manually update it to table on database?

Find something that uniquely identifies users in the user source and use that as the primary key for your table.
Or use a database user source if it makes things simpler.