Hi,

Could you please be more specific about your aim?
Do you want to load/store the Badge points in other (custom) table?

As for updating the Badge (ID) - this is done in code of UpdateActivityPointsToUser method, as can be seen in the DevGuide article with Badges examples or in the API examples project:

\CMSAPIExamples\Code\Administration\Badges\Default.aspx.cs
method BadgeInfoProvider.UpdateActivityPointsToUser

There are finally two methods called:

// Update user counts
UserInfoProvider.UpdateUserCounts(pointsType, userID, points);

// Update badge
UpdateUserBadge(ui.UserID);

The first of the methods has its part in the stored procedure
Proc_CMS_User_UpdateUserCounts, so you may find the necessary information there...

Hope it will help.

Regards,
Zdenek