This is a tree with 7 levels, of which the detail value is account. We utilize this tree for organizing where our accounts fall in our Trial Balances. Primarily this tree is used for running our nightly trialbalances, but we also specifically call on this tree in many queries, nvision reports, and especially in databases. It's important to log any changes to this tree since it could affect reports or databases that call on that account or tree node specifically.
Changelog - Place new records at top10/17/2017- Becky split the PENSION_DEFERRED_IN tree node to add DEF_IN_SVC_CON_ARR with range 25002000-25099999. See ticket#11172734
09/09/2017- Becky added a new treenode, CAP_INTERGOV_PROG with the range 43363000-43364999, this range was previously part of EXTERNAL_IN_KIND. See ticket# 10639565
07/30/2017- Becky added a new level 7 node ISSUANCE_OF_REF_DEBT 45250100-45250199, see ticket#10101079
4/3/2017- Modified Payment node locations per ticket#8447896. This included some renaming of existing nodes (i.e. changing _OKC to _GOV). (Note: This has modified some since the original ticket, probably because of it being such a rush job.)
3/22/2017- Set-up new Transfer and Payment nodes per ticket#8268671. This required the modification/deletion of some existing nodes. This will definitely affect the IntrafundWP and will require an update to the how the nightly process classifies accounts as PC,P1,PO&P2 types.
11/07/2016POL-FIRE_ON-BEHALF is now 4330000-43304999 & 43306000-43309999
Added node
TAX_INCENTIVES for 43305000-43305999
03/04/2016Added tree node PENS_INT_RECEIVABLE as a sibling to INT_DIV_ROY_RECEIV
Added range 13200000-13209999 to account for pension receivable accounts
11/10/2015: Stephen and Becky did some changes.
MISC_LONG-TERM_DEBT renamed to NONCAPLTDNCNONCAPLTD added as a sibling of LT_EST_CLAIMS_PAYThe treenode NC_NONCAP_LTD was added to non-current_notes.
The range for LT_EST_CLAIMS_PAY was changed to 25700000-25791000
The range for NC_NONCAP_LTD was changed to 25791001-25799999