For many years, customers have had a need to associate multiple people with a particular department in PeopleSoft in various roles. They need to have a Manager, a Financial Analyst, a Human Resources specialist, etc. The usual answer in the past was to either customize the DEPT_TBL to provide for additional fields and add them to the page for collection. An alternative was to create a separate record and create a page for collection/maintenance of the information that was added to the DEPT_TBL component.
There is a way to accomplish this task with no customization to the database – you use the Profile Management area of the application. You can create Non-Person profiles for each type of association you need to be able to create/maintain associated with a department.
An example for creating a Non-Person Profile for a Financial Analyst is shown here (above). The steps are the same for each type of Non-Person Profile you would want to create.