Database Table Reference → PES_ObjectMap
PES_ObjectMap is a primary ID generator for all objects stored in PES_Object.
| Name | Type | Length |
| obj_UID | int | 4 |
| clt_UID | int | 4 |
SELECT* FROM PES_ObjectMap SELECT m.obj_UID, ct.clt_Name,ISNULL(o.obj_Name,ISNULL(w.obj_Name, r.obj_Name))as'Name' FROM PES_ObjectMap m INNERJOIN PES_ClassType ct ON m.clt_UID = ct.clt_UID LEFTJOIN PES_Object o ON m.obj_UID = o.obj_UID LEFTJOIN PES_AgileWI w ON m.obj_UID = w.obj_UID LEFTJOIN PES_Resource r ON m.obj_UID = r.obj_UID obj_UID clt_UID ----------- ----------- -7 1 -6 1 -5 1 -3 1 -2 1 -1 1 1 1 272 4 274 4 279 4 282 4 345 4 346 4 347 4 348 4 349 4 419 4 922 1 923 16 924 16 925 1 926 1 927 1 928 16 929 16 (25 row(s) affected) obj_UID clt_Name Name ----------- ------------------ ---------------- -7 Investment Enterprise Templates -6 Investment Root Task -5 Investment Enterprise Resource Pool -3 Investment Administrative Role Assignments -2 Investment Unassigned Objects -1 Investment System Root Object 1 Investment Agile Projects 272 Resource Alvarado, Juan 274 Resource Goubert, Pete 279 Resource Administrator, Administrator 282 Resource Sin, Josh 345 Resource Scrum Master, Shane 346 Resource Product Owner, Pete 347 Resource Executive, Edward 348 Resource Team Member, Tom 349 Resource Team Member, Tara 419 Resource Coolman, Pete 922 Investment project 1 923 Agile Work Item Sample Story 924 Agile Work Item ttttt 925 Investment Release 1 926 Investment Team 1 927 Investment Sprint 1 928 Agile Work Item story1 929 Agile Work Item task1 (25 row(s) affected)