Does anyone know what database table houses Functional Teams in Agile PLM?
Looking to capture the Functional Team reported on the cover page for most entities in Agile PLM v9.3.3 but couldn’t seem to find Functional Teams captured anywhere within the database schema – would anyone know where this is?
Thanks very much in advance!
The information for functional teams is in USER_GROUP – it is just another class (id=2000017166) under the User_Groups base class. The FUNC_TEAM attribute was added back in 22.214.171.124.
The USER_GROUP table was added way back in 126.96.36.199, so it should be there, and Averify should call it out as missing if it is not there.