Generating a custom Org Chart in PeopleSoft July 8, 2014Posted by Duncan in TW.
This week we have a second guest-post from Richard Yip. Richard is a PeopleSoft HCM & Payroll Technical Consultant at Santander Bank here in the UK. He is a long-term PeopleSoft techie and a regular at the UKOUG conferences. I’m delighted to be able to give him a conduit through which to share some of his good work.
Richard’s previous post can be found here.
Custom Organisation Charts in PeopleSoft
In the PS_EMPLOYEES table, there is a custom field called SUPERVISOR_ID. This is used to connect the employee to the supervisor or line manager. This is similar to the REPORTS_TO field in PS_JOB.
I developed this after toying with the GOOGLE API Organisation Chart. Generating the boxes was straight forward enough, so the trick was to understand how to generate the connecting lines.
Richard has kindly shared all the code required to get this working. See Generate a custom Organisation chart from ps_employees for the listings.