Direct Reports
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Direct Reports
(Created page with "Direct Reports SQL WITH POSITION_TREE AS ( SELECT PD.POSITION_NBR AS ROOT_POSITION , PD.POSITION_NBR , PD.REPORTS_TO , PD.DESCR , PD.BUSINESS_UNIT , PD.DEPTID , PD.LOCATION , ...") |
|||
| Line 1: | Line 1: | ||
Direct Reports SQL | Direct Reports SQL | ||
| - | + | <pre> | |
WITH POSITION_TREE AS ( | WITH POSITION_TREE AS ( | ||
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 | 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 | ||
| Line 15: | Line 15: | ||
PT.ROOT_POSITION = PD.POSITION_NBR | PT.ROOT_POSITION = PD.POSITION_NBR | ||
AND LEVEL <> 0 | AND LEVEL <> 0 | ||
| + | </pre> | ||
