Skip to main content
 
 
 
IN THIS SECTION
3 posts
Hegedus
Last seen: 02/04/2024 - 19:23
Joined: 10/24/2018 - 20:10
Assignee Location ID vs. Assignee ID

I am trying to match up assignees to location.

For example from the assignee.tsv file for "boeing"

08cemk21ku7pg7zmtrbv6ks1n    2            The Boeing Company

All well and good.

But I find no "08cemk21ku7pg7zmtrbv6ks1n" in the location_assignee file

Also the assignee field has values that are prefaced with "org_"

org_uRgOYD3Oar5qRXpkfYwP

The Excel file of the grid mapping implies that I should be able to match assignee_id in location_assignee with id in assignee.

Not working for me.  What am I missing?

Andy

 

PVTeam
Role: moderator
Last seen: 04/24/2024 - 12:31
Joined: 10/17/2017 - 10:47
Re: Assignee Location vs. Assignee ID and Multiple Assignees

Hi,

Not all assignees have a location: If an assignee doesn’t have a location, then it won’t be present in the location_assignee table. Additionally, the assignee disambiguation algorithm is new for the latest data update which is where the issue pointed out above with “The Boeing Company” surfaces. We are still in the process of tweaking the algorithm to address some of these output issues for the next data update.

Thank you,

PVTeam