Employee Data and Ceridian

Okay, so I work in HR at a company that uses Ceridian HPL to house our employee data. We are trying to make the new hire and change process more efficient.

What we would like to do is create an interface that enables the managers and people submitting employee changes from making mistakes. In other words, if they select change A, then that narrows some field. As an example, if they select a pay increase, then there options for the effective date of the change are now limited to dates that are Sunday (technically it would be every other Sunday).

So, I’m looking for some ideas (maybe this should go in IMHO?).

I think I could make something in Sharepoint, or possibly use excel (granted excel would be very advanced, I think).