http://springboardsolutions.com/wiki/index.php?action=history&feed=atom&title=Direct_Reports 2026-10-17T03:26:45Z Revision history for this page on the wiki MediaWiki 1.25.2 http://springboardsolutions.com/wiki/index.php?title=Direct_Reports&diff=229&oldid=prev 2016-03-25T08:51:08Z

<p>1 revision imported</p> <table class='diff diff-contentalign-left'> <tr style='vertical-align: top;'> <td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 08:51, 25 March 2016</td> </tr><tr><td colspan='2' style='text-align: center;'><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

WikiSysop http://springboardsolutions.com/wiki/index.php?title=Direct_Reports&diff=227&oldid=prev 2015-11-28T18:44:19Z

<p></p> <p><b>New page</b></p><div>[[Microsoft SQL Server]] SQL query to find Direct and Indirect Reports of a manager in [[PeopleSoft HRMS]] (that determines the management hierarchy by Position Management):<br /> &lt;pre&gt;<br /> WITH POSITION_TREE AS ( <br /> SELECT PD.POSITION_NBR AS ROOT_POSITION , PD.POSITION_NBR , PD.REPORTS_TO , PD.DESCR , PD.BUSINESS_UNIT , PD.DEPTID , PD.LOCATION , PD.COMPANY , PD.JOBCODE , PD.POSN_STATUS , 0 AS LEVEL <br /> FROM PS_POSN_EFF_VW PD <br /> UNION ALL <br /> SELECT POSITION_TREE.ROOT_POSITION AS ROOT_POSITION , PD2.POSITION_NBR , PD2.REPORTS_TO , PD2.DESCR , PD2.BUSINESS_UNIT , PD2.DEPTID , PD2.LOCATION , PD2.COMPANY , PD2.JOBCODE , PD2.POSN_STATUS , LEVEL+1 AS LEVEL <br /> FROM PS_POSN_EFF_VW PD2 <br /> JOIN POSITION_TREE ON PD2.REPORTS_TO = POSITION_TREE.POSITION_NBR <br /> WHERE PD2.REPORTS_TO NOT IN (PD2.POSITION_NBR, ' ')<br /> ) <br /> SELECT PD.POSITION_NBR , PT.POSITION_NBR , PT.DESCR , PT.BUSINESS_UNIT , PT.DEPTID , PT.LOCATION , PT.COMPANY , PT.JOBCODE , PT.POSN_STATUS , PT.REPORTS_TO , LEVEL <br /> FROM PS_POSN_EFF_VW PD , POSITION_TREE PT <br /> WHERE <br /> PT.ROOT_POSITION = PD.POSITION_NBR <br /> AND LEVEL &lt;&gt; 0<br /> &lt;/pre&gt;<br /> <br /> This is an example of an ANSI SQL recursive query. Recursive queries have the general format:<br /> <br /> &lt;pre&gt;<br /> WITH view_table AS ( <br /> SELECT ... <br /> UNION ALL <br /> SELECT ...<br /> JOIN view_table ON connect_criteria<br /> )<br /> SELECT ...<br /> FROM view_table<br /> WHERE<br /> start_node_criteria<br /> &lt;/pre&gt;<br /> <br /> [[Microsoft SQL Server]]</div>

WikiSysop