Last post Aug 02, 2010 06:40 PM by joeastral
Aug 02, 2010 06:40 PM|joeastral|LINK
I do a lot of HR type applications and so I found myself with the challenge of how do I easily do reports off of the org tree structure but then make it so I can dynamically update people. My basic field is EmpID with SupervisorID. The Supervisor ID links
to another EmpID in the table.
Putting the org structure in an easy format for pulling in reports and pulling access is straight forward. I pulled this design from McAfee's Enterprise product for their sites and workstations, etc. This is the DDL for the table that allows us to pull
I hope you find this useful.
sql tree structure
ou chart sql