1 Reply Latest reply: Jan 10, 2013 2:49 AM by Michel RSS

    What is PSTREESELECT10?

    983332
      In one of the Finger 2 query against PeopleSoft, there is a reference to a table (PSTREESELECT10). What is this table for?
      If this is a department tree table with the nodes defined, are there any descriptive tables to understand the data in this table?

      Edited by: 980329 on Jan 9, 2013 2:04 PM

      Edited by: 980329 on Jan 9, 2013 2:05 PM
        • 1. Re: What is PSTREESELECT10?
          Michel
          Apparently this is a table used by nVision to select information from a tree. Oracle support article 610734.1 mentions this:
          The PSTREESELECT# tables are used to speed tree-based data selection. The table gets rows inserted into it the first time a tree is used by an nVision report.