GENERATE FUND DEDUCTIONS MAG MEDIA

Use this screen to print a report showing the deduction amounts for each employee's payments to his deferred compensation balances. You can run this report for a time period that spans several pay periods, if desired. In this case, it will sum all the deductions within the timeframe selected (for all pay periods selected). You can also generate a magnetic media file for submission to your third-party financial institution (or mutual fund provider) showing the deduction amount for each employee.

You must complete all of the Plan Controls and Employee Setup screens for any plan codes for which you want to print this report and create the magnetic media file.

Sort

Use the options in this group box to specify the sort of this report.

Employee Name

Select this radio button to specify the employee's name (the Displayed Name from the Basic Employee Info screen in Costpoint Employee) as the sort criterion for this report.

Employee ID

Select this radio button to specify the employee's ID as the sort criterion for this report.

Select

Plan Info

Plan

Enter, or use Lookup to select, the deferred compensation plan code for which you want to run this report. Employee deductions assigned to the selected deferred compensation plan are selected for processing.

From Date

Enter the starting date to use for running this report. This will normally be the starting check date related to one or more pay periods that you select.

To Date

Enter the ending date for running this report. This will normally be the ending check date related to one or more pay periods that you select.

Create File

Use this group box to determine whether you want to show contribution or loan repayment totals. This group box will not be available until you enter a plan in the Plan Info group box.

Contribution

Select this checkbox to show contribution totals.

Loan Repayment

Select this checkbox to show loan repayment totals.

Test File

Select this checkbox to generate a magnetic media test file. This checkbox is enabled only if the Plan code's assigned Financial Institution is "CIGNA2" in the Plan Setup screen. If the Financial Institution is "CIGNA2" for the Plan code, the Contribution and Loan Repayment checkboxes will be selected and disabled.

Report Status

When you first enter this screen, the status is "Report Not Printed." You must first print the report before you can create the file. If you change parameters in this screen after printing the report, you will need to reprint the report using the new parameters before you can create the file.

File Name

Enter the file name to use for generating the magnetic media file. You can enter the entire path to specify creation in a certain directory. Otherwise, the file is created in your Windows directory.

Create mag media file

Select this button on the toolbar to begin creating the magnetic media file. This button is available only after you have printed the report.

Process/Print

Select this button on the toolbar to print the report and then immediately start creating the magnetic media file. This option may be appropriate if you have already printed the report.

Table Information

This screen uses the following tables:

Basic Employee Info - EMPL

Deferred Compensation Plan Setup - H_CODA_SETUP

Deduction Code Assignment - H_CODA_DED_CD

Maintain Employee Earnings - EMPL_EARNINGS

Employee Deferred Compensation Loan - H_CODA_EMPL_LOAN

Employee Deductions - EMPL_EARN_DED

Employee Contributions - EMPL_EARN_CNTRB

Report Columns