This tree provides the structure of programs.
To view tree information, go to MaineStreet > Enterprise Applications > Financials, then go to Main Menu > Tree Manager > Tree Viewer. Enter "UMS_PROGRAM" for the 'Tree Name' and choose the most recent tree. This tree is updated annually on July 1st.
Click the "-" and expand the tree.
Here is the relationship between the fields in UM_GLQ_REPRTING table and tree nodes.
The level of the tree corresponds to the field. For example, for the PROGRAM_CODE=10006, UM_PROG_CAT1 is based on the level 3 of the tree. Some program codes do not have all the level, such as PROGRAM_CODE=80073. The UM_PROG_CAT_3, & 3_D, UM_PROG_CAT_4 & 4_D, UM_PROG_RESTR_1 & 1_D, UM_PROG_RESTR_2 & 2_D, and UM_PROG_RESTR_3 & 3_D fields for the PROGRAM_CODE=80073 are all blank in UM_GLQ_REPRTING table since there are no tree nodes below level 4.
Please see Replacing DEPT_CRx with "in tree" logic for using a tree in Query Manager.
Attachments:
image2019-10-29_10-41-56.png (image/png)
image2019-10-29_10-31-23.png (image/png)
image2019-10-29_10-28-38.png (image/png)
image2019-10-29_9-33-35.png (image/png)
image2019-10-29_9-32-8.png (image/png)
image2019-10-29_10-56-48.png (image/png)
image2019-10-29_11-48-55.png (image/png)
image2019-10-29_11-52-53.png (image/png)
image2019-10-29_12-1-13.png (image/png)
