total compensation. we wanted to highlight and communicate the value of our benefit package since it...
TRANSCRIPT
Total Compensation
We wanted to highlight and communicate the value of our benefit package since it is a strategic advantage in recruiting and retaining our community members.
So we got to work…
Our HR folks like to produce warm and fuzzy feel good material, and
Value of Total Compensation Statements
• Raise awareness of the total
monetary value of Benefits.
• Communicate how much the College values our community members -- we are making an investment in their health and future.
• Highlight the selling and retention point of a really strong asset for the College.
Why put it on the Web?
We chose an online delivery model because:
• We want our employees to think of Employee Self-Service as the place to go to access paystubs and earnings information, healthcare and flexible benefits, retirement information, and now, their Total Compensation Statement.
• Web access allows the statement to be continuously updated
(in our case, data is refreshed daily).
• Eliminates costs of paper and postage.
But……you have to reach your Audience ! Although we want folks to use Employee Self-Service, we realize this is not always practical. Therefore:
• We won’t completely abandon paper but will continue to encourage employees to use self-service.
– The paper version will highlight the web link
• We used Oracle Reports to create a paper version which will be available for administrators to run by department or individual
– by department when annual raise letters are sent– by individual as needed
Creating the Total Compensation Statement
• Created in Application Express
• Used a table build that runs daily– Lots of functions used– Most data from nbrjobs,pdrdedn,phrdedn
• Worked with Web Developers to create a new theme (i.e. look)
Administrator’s View
• We wanted a way for HR Benefit Administrators to view individual statements
• Application Express made this fairly easy
How secure is it?
• We needed to make sure no one could access another person’s statement
• We want folks to access their Total Compensation Statements via Employee Self-Service
• My colleague came up with a plan
WTAILOR: Add column in Web Tailor Session ID table (TWGBWSES) to capture SESSID
NAME Null? Type
------------------------------- --------- -----
TWGBWSES_PIDM NOT NULL NUMBER(8,0)
TWGBWSES_WEBID VARCHAR2(6)
TWGBWSES_LAST_ACCESS DATE
TWGBWSES_LOGIN_ATTEMPTS NUMBER(2,0)
TWGBWSES_LOGIN_REQ_IND VARCHAR2(1)
TWGBWSES_SESSIONID NUMBER
TWGBWSES_PREV_WEBID VARCHAR2(6)
TWGBWSES_SWAT_SESSID VARCHAR2(50)
WTAILOR: Modify Package body TWBKWBIS**This package provides the WWW Banner security and menu processes
Create a global variable to capture the sessid cookie
swat_cookie varchar2(4000) default 'no_cookie';
In the function f_validuser:
swat_cookie := twbkbssf.f_encode (webid || pidm);
Every update of twgbwses: set twgbwses_swat_sessid = swat_cookie set twgbwses_swat_sessid = NULL where applicable.
What happens now is that once a user logs into and navigates throughself-service the sessid will be updated in twgbwses.
Setting up Application Express Applications to Authenticate with Self-Service
PACKAGE BODY PKS_APEX_MYSWAT_AUTHENTICATION IS
pidm number(8);
swat_sessid varchar2(50);
procedure apex_totalcomp is
BEGIN
IF NOT twbkwbis.f_validuser (pidm) THEN
RETURN;
END IF;
begin
select twgbwses_swat_sessid
into swat_sessid
from twgbwses
where twgbwses_pidm = pidm;
exception
when no_data_found then
swat_sessid := null;
end;
htp.p('<SCRIPT LANGUAGE="JavaScript">window.location=
"https://apex.xxxxxxxx/f?p=TOTALCOMP:7:::NO::MYSWAT_SESSID:'||swat_sessid||
'"</script>');
END;
Now log into WebTailor and define as you normally would (roles, Menus, etc).
Authorization Scheme that verifies self-service session ID
Getting the PIDM for use in the application
Capturing the IP address
Ensuring that the IP is within the Swarthmore subnet
Summary• Swarthmore HR wanted an online and printable
Total Compensation Statement• We decided to use Application Express for the
online statement and Oracle Reports for the printable statement
• We worked with our Web team to give the online statement a Swarthmore Look
• We found a way to make the online statement secure and to keep it within the campus network
Go Live Date?
• We are planning to go live with both the paper copy & Employee Self-Service link in January 2008.