All Phone Extension list to be maintained within OA/GIAS

Mary Beth submitted the following idea

"Currently I am the keeper of the phone extension list, which changes often. The managers have requested we send out current extension list. I did send one out and within hours there were several changes.
All of this to say, is there away to add the extension list to the OA website available to managers only?

MARY BETH HENSLEY | Customer Care Supervisor"

*******************************************************************************

This change would require OA and GIAS changes.

In GIAS:

Create a new table and maintenance screen to hold phone extension information. The table would need to have the following fields

• Name

• Extenstion

• Department

• Last Updated Date

Whenever a change is made, Mary Beth would be able to make the change in GIAS and have it reflect in OA without having to email out the list over and over again.

In OA:

We would want to create a new screen in OA that is only available for users with ROLE_MANAGER. This screen would show the same information in our phone extension table (but way prettier).

Managers would probably want to be able to search the information by name and department so they can easily find who they are looking for.

Id also want a way to download the extension information. They should be able to download the entire list OR narrow down the list and only download what they want.

It would also be cool if we could create a table to hold "favorites" so managers could select the extensions they use often and favorite them for easy access.

We might want to also explore whether an automated email should go out from GIAS everytime a change is made to the phone extenstion list. The email could go to inhouse and the managers? We would need to see if they would even want that?