I am trying to understand the database behind UGM and GSM for a couple projects I am working on. I am currently looking at the PDEV database and trying to run a report on the table that holds information pertaining to the Users and the Business Unit they are apart of. But I can not find the tables.
Also, is there a way I can just search a ID number against the entire database to find where and which tables this number is located?
Can I get some help, please and thank you!!
You can get a type from your ID number - it is first 4 numbers of your ID.
Then you can query ORClassMetaInfo to find the table name based on type.
select tablename from ORClassMetaInfo where type = 2107;
You can read more about it in the Additional Details section (page A-5) of the Extensibility guide.