Class (profile) mis-match in character_stat

It appears that there is a problem with character_stats related to classes. It looks like the values for the Medic and Engineer are swapped (I haven't checked any of the other classes).

I play almost exclusively Engineer (over 80%), which the players site correctly identifies, however when I look at the API data, it seems to claim that I play the Medic that much, and rarely play Engineer.

Medic stats:
http://census.daybreakgames.com/get/ps2:v2/ch...^inject_atrofile^hiderofile_id)&c:lang=en
score: 18131052
play time: 4065083
deaths: 15273

Engineer stats:
http://census.daybreakgames.com/get/ps2:v2/ch...^inject_atrofile^hiderofile_id)&c:lang=en
score: 831399
play time: 216615
deaths: 1424

 

This is very confusing, but the profile_id in the characters_stat joins to profile.profile_type_id, not to profile.profile_id. I would rename characters_stat.profile_id but that ship has sailed...

combat medic: (profile_type_id 4)
http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=characters_stat^list:1^inject_at:stats^hide:character_id^termsrofile_id=4(profile^onrofile_id^torofile_type_id^inject_atrofile^hiderofile_id)&c:lang=en

• stat_name: <span style="color: green">"play_time",
• value_forever: <span style="color: green">"308265",

engineer: (profile_type_id 5)
http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=characters_stat^list:1^inject_at:stats^hide:character_id^termsrofile_id=5(profile^onrofile_id^torofile_type_id^inject_atrofile^hiderofile_id)&c:lang=en

• stat_name: <span style="color: green">"play_time",
• value_forever: <span style="color: green">"4065083",

 

Oh, that is confusing (but good to know). Also explains why some of the results were referencing profile IDs that didn't exist