1 / 17

Employee Compensation and Benefits Statement

Employee Compensation and Benefits Statement. presented by Brad Smith Library and Information Services Institutional Systems. Dickinson College. Please turn off all cell phones/pagers If you must leave the session early, please do so as discreetly as possible

fia
Download Presentation

Employee Compensation and Benefits Statement

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Employee Compensation and Benefits Statement presented by Brad Smith Library and Information Services Institutional Systems

  2. Dickinson College Please turn off all cell phones/pagers If you must leave the session early, please do so as discreetly as possible Please avoid side conversations during the session. Please feel free to ask questions at any time during the session. Thank you for your cooperation! Benefit Statement General Announcements

  3. Dickinson College Benefit Statement When Your Retirement Plans don’t fit into your Child’s Future

  4. Dickinson College Benefit Statement Benefits…. Sweet Benefits…..

  5. Dickinson College Benefit Statement Timing is Everything!

  6. Dickinson College Went Live with Banner HR January 1, 2006. No prior consolidated Compensation and Benefit Statement. No easy way for employees to see the ‘true’ value of their employment benefits. (Not happy with Banner Delivered options.) HR Committee formed at the behest of VP of HR to discuss the creation of a ‘Comprehensive’ Benefits Statement. (June 2007) Content Format Presentation Options Security Benefit Statement Background

  7. Dickinson College Benefit Statement Concerns and Issues • Data Security was the Number 1 Issue. • Decided against on-line access for the first cut. • USPS Chosen for initial delivery. • Bypass Staff Associates, Assistants, and Office Mail. • Ease of Use for HR Staff and Distribution. • Flexibility in Statement Production (Individually or in a Group) • Simple, one-page (double-sided), glossy document. • Graphs • Tables • Easy to Understand and Pleasing to the Eye.

  8. Dickinson College Benefit Statement Functionally speaking… • Salary Valuation • Retirement Contributions • Health and Wellness Contributions • Education Benefits • Leave Time Valuation • Paid Holidays, Closings, and Other Time Off • Other Benefits (Monetary and Non-Monetary) • Other Campus Services

  9. Dickinson College In house development (by Application Support Analyst) Rollout January 2008 Data extracted from PROD instance of INB Real time results. (to prepare for eventual on-line access) Access controlled by Human Resource Services. Benefit Statement Technically speaking…

  10. Dickinson College Benefit Statement Data Sources • SPRIDEN • SPRADDR • FTVORGN • PEBEMPL • PDRDEDN • PTRBDPL • PTRBDCA • PERLEAV • NBRJOBS

  11. Dickinson College Benefit Statement SQL Basics • Simplified Structure • Sub-Queries • Linked by PIDM • Analytical Functions • Dickinson ‘Rules’ Built-in where Possible • Age-banded Life Insurance • Leave Time for Administrators

  12. Dickinson College Benefit Statement Putting the Pieces Together • Decided to use COGNOS to Format the Statement Presentation. • Conditional Variables to format Table Rows • Master-Detail Relationship for Graphs • Flexible Parameters • Many calculations built into COGNOS rather than SQL • Raw data extracted in SQL, manipulation done in COGNOS

  13. Dickinson College Benefit Statement A Picture is Worth a Thousand Words

  14. Dickinson College Benefit Statement

  15. Dickinson College Benefit Statement

  16. Dickinson College Benefit Statement Dynamic Boxes. (Grow or Shrink depending on the content) Administrator Leave Time in Days rather than Hours.

  17. Dickinson College Benefit Statement And now….. Here’s Katie!

More Related