Request: A client recently asked for assistance in balancing their 401(k) deductions.  See article Q10023 for a summary explanation of the request and solution.  The specific portion of that request, which this article details, relates to running SQL scripts to create two views which combine information from EDF and DDS.   The goal is to be able to create a spreadsheet with combines specific information from EDF and DDS in a columniar format.

Solution: Use SQL to create two views which combine information from the EDF table and the parsed results from the DDS reports.  See articles the related articles, attached to the document, for detail on how the DDS report was parsed.  For the purposes of this article accept that the DDS results now exists in a temporary table.

(1) The goal is to allow the user to create a spreadsheet similar to the following.  Note that the following is a simplified example.  There acutal request involved 19 deduction codes and multiple spreadsheets.

(2) Create views for the EDF information and the DDS parsed table.  The sql scripts are attached.

(3) Use Business Objects or Crystal to combine the two views created in step 2.

Note: A simplified SQL statement, used to create a spooled file which was pulled into Excel to create the above spreadsheet, is as follows:

select
edfv.EM_EMPLOYEE_ID,
DEFSAVR_PERCENT,
NDSAVR_PERCENT,
DEFSAVR_YTD,
NDSAVR_YTD,
DEFSAVR_DDS,
NDSAVR_DDS    
from view_401k_edf_info edfv, view_401k_dds_info dds
where NDSAVR_YTD <> 0
  and edfv.em_employee_id = dds.em_employee_id
/