Add user defined fields to user profiles

Adding a few user defined fields to users profiles would allow customers to directly attach useful information to user profiles. I suggest five 10 character fields. having one field long enough to store an email address would also be very helpful. The customer could then use other files to join with output from DSPUSRPRF to produce reports with more meaningful information. The fields could also be very useful even when displaying a single user profile.

Fields could be used for information like department, phone number, and manager. Having this information available on the DSPUSRPRF screen could make many tasks easier since all information about the user could be readily available on a single screen and without having to track this information separately. Printing reports grouped by department or manager would also make security management much easier.

If easier for design purposes, these fields could even be stored in a separate DB2 table, and potentially even updateable with direct file access. The important thing though would be to be able to enter the information with CRTUSRPRF or CHGUSRPRF, and to have the information available with DSPUSRPRF and RTVUSRPRF.

User defined fields such as department, manager, telephone extension, etc. would be populated while maintaining the user profile. When working with a user profile at a later time, and it is necessary to contact them or their manager, it would be much easier to have the information on the user profile screen instead of having to go to other sources for the information.

When printing security reports for manager review, it would be helpful to have the information available with the profile information. Likewise, selecting employees by department would be much easier. Currently we depend on staff remembering to update our own table, but it is sometimes overlooked. By adding user defined fields to the profile itself the information could be easily entered and maintained while working with the profile, while other solutions require separate processes that could be easily overlooked.