CareerDupNames

Description

User complains of duplicate names showing up in career stats.

Possible Reasons

Manager is not using email address and created another player with the same name instead of assigning the player already created. This typically happens in two cases, the manager removed the original player from their player list and later re-adds them OR a new manager is assigned and is required to re-create new players to PII data doesn't get shared. Need to look into solving the second issue.

Manual Fix

update manager access to the player:
update softball_manager_player set player_user_id = MASTER where player_user_id = TEMP

Update the player to be assigned to the master user:
update softball_player set user_id = MASTER where user_id = TEMP

---