Employee Benefit Statements
ProceduresDocument CollectionData CollectionTutorial for Doing-it-YourselfSamples & ExamplesAn Employee Website + more
Click here for the Index
Employee Communications
A variety of Targeted Examples, ranging from an online Employee Budget Worksheet, to Retirement Communications, online Enrollment & much more.
Click here for the Index
The Human Resources Collaborative Suite
Why it's neededTools we usedYour ToolsOverview and IntroductionMovies and more
Click here for the Index
Step #1
NOTES:
Very few of us have a solid understanding of SQL.  It is unrealistic to expect Users to sit down with an SQL text editor and write the following without error:
SELECT "census"."ee_id" AS census_ee_id, "census"."dob" AS dob, "v_cens_comp"."mnth_wage" AS mnth_wage, "b_yr"."bp_1r" AS bp_1r, "b_yr"."bp_2r" AS bp_2r, (least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) AS r1, +((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) AS r2, (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15) AS r3, round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)) AS pia, "b_yr"."cum_cpi" AS cum_cpi, "b_yr"."ful_txt" AS ful_txt, "b_yr"."red_fact_65" AS red_fact_65, round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."cum_cpi"*"b_yr"."red_fact_65") AS ret_at_65_mo, (round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65"))*12 AS ann_ss, round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65")/"v_cens_comp"."mnth_wage" AS ss_rep_pct, to_char((round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65"))*12, '$fm99G999') AS ann_ss_t, to_char(100*round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65")/"v_cens_comp"."mnth_wage", 'fm999%') AS ss_rep_pct_t, round(((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."cum_cpi"*"b_yr"."red_fact_65")*(1+("b_yr"."del_ret_cr_pct"*5))) AS ret_at_70_mo FROM "rrdonnelley"."census" LEFT JOIN "rrdonnelley"."v_cens_comp" ON "census"."ee_id" = "v_cens_comp"."census_ee_id" LEFT JOIN "rrdonnelley"."b_yr" ON "v_cens_comp"."yob" = "b_yr"."y" ORDER BY dob ASC
Which is why we developed a Visual Query GUI that auto generated the code above. This does NOT mean that knowing SQL is not helpful.  It does mean that simple queries can be created by a Novice with a nominal amount of training.
Select New .....Query from the horizontal menu.  This will take you to Step 1 of the Query Editor.  
Give your new Query a Name and description, then click 'Next'.
The process of retrieving or the command to retrieve data from a database is called a query.  Ask a question .. get an answer, but ... you must ask the correct question.
 New Query
The GUI is designed specifically to allow HR to 'ask questions' (query) without any knowledge of SQL.  This means your HR Team will be able to redo queries and as you do, you will learn more and more about SQL.
Most of us learn best when we roll up our sleeves and try, regardless of the task, so give it a go.
In addition, there is a an immense amount of material on the web.
Some background reading
Have a Question?
Your email
 Watch the 2 movies in the links above:  Simple, 1 Table Query & Edit Query
Employee Benefit Statements An onlineEmployee Budget Worksheet Collaborate.Easily,productively
Please wait...