An age old question at universities is “How much does it cost to teach a class?” During these hard times of the economy, the answer to this question is becoming more important and should be taken into consideration when making the class schedule. I initiated a project to create a report to answer this question and took the lead. As simple as the question may seem, the rules revolving around classes, faculty, salaries, and how benefits are paid presented a challenge.
Challenges
- Need to combine data from the three different PeopleSoft modules (Human Resources, Student Administration, and Finance) which does not necessarily relate fields as they are independent systems.
- Work with both functional and technical staff from the different modules which entails different lingo, ideas and definitions of terms.
Tools: Microsft SQL Server Reporting Services, Cognos Decision Stream
Languages: SQL, VB script
No comments:
Post a Comment