This tree provides the structure of projects.
To view tree information, go to MaineStreet > Enterprise Applications > Financials, then go to Main Menu > Tree Manager > Tree Viewer. Enter "UMS_PROJECT" for the 'Tree Name' and click 'Search'. Then click "-" to expand the tree.
Eight fields in UM_GLQ_REPRTING table are based on this UMS_PROJECT tree.
The level of the tree corresponds to the field. For example, for the PROJECT_ID=8100037, UM_PROJ_CATEGORY is based on the level 3 of the tree. Since some PROJECT_IDs do not have all tree nodes, some fields are blank in UM_GLQ_REPRTING table.
Attachments:
image2019-10-29_12-1-13.png (image/png)
image2019-10-29_11-52-53.png (image/png)
image2019-10-29_11-48-55.png (image/png)
image2019-10-29_10-56-48.png (image/png)
image2019-10-29_9-32-8.png (image/png)
image2019-10-29_9-33-35.png (image/png)
image2019-10-29_10-28-38.png (image/png)
image2019-10-29_10-31-23.png (image/png)
image2019-10-29_10-41-56.png (image/png)
image2019-10-29_12-33-26.png (image/png)
image2019-10-29_12-36-32.png (image/png)
image2019-10-29_12-39-43.png (image/png)
