Wiki: Deferred Compensation

DEFERRED COMPENSATION#

The following statements are taken from the ICMA Retirement Corporation's web site: "The International City/County Management Association created the ICMA Retirement Corporation (RC) as a separate, not-for-profit organization in 1972."

ICMA Setup #

To execute the required report the only set up required is a pay element and the Interface Format form (IDIF). The benefit plan may be set up with the standard benefit components documented in the Benefits Administration manual (see the Pension Sample Plan).

Pay Element - IPPE #

One pay element must be created in order to execute the report: ICMA Element Pay element that contains the deduction pay components that qualify for ICMA

Interface Format - IDIF #

If not already defined in the Interface Formats Definition form (IDIF), load the standard interface file format using the starter_idif_hl$icma.sql script.
Modify the standard ICMA file to bank requirements using the IDIF function. Rename the code from HL$ICMA to a user-defined code.

Rec	Field	Start Position	Ending Position	Name	Variable Number	Notes
1	1	1	55	Company Name		Enter in Constant
2	1	1	11	Filler
2	2	12	15	Plan ID		Enter in Constant
3	1	1	4	Filler
3	2	5	14	Company PIN		Enter in Constant
4	1	1	4	Filler
4	2	5	15	Total Contribution	Total Contribution	ICMA Element from UPICMA
4	3	16	30	Filler
4	4	31	41	Calculated Amount	Total Contribution	ICMA Element from UPICMA
5	1	1	9	Filler
5	2	10	15	Pay Issue Date	Pay Issue Date	Pay Header Issue Date
6	1	1	55	Employee Name	Employee Name	Identity Name
6	2	56	64	Employee SSN	Employee SSN	Identity Government ID
6	3	65	72	Filler
6	4	73	83	Employee Contribution	Employee Contribution	ICMA Element on UPICMA

Create ICMA Interface File #

These are the report parameters for the monthly-required report.

Report Parameters & Filters#

Report Parameters
Entity	Mandatory, LOV available Limits the process to the entity specified.
Payroll	Mandatory, LOV available Multiple payrolls may be selected per execution of this function.
ICMA Element	Mandatory, LOV available Pay element that contains the deduction pay components that qualify for ICMA
From Pay Issue Date	Optional, Date, LOV available The ‘Pay Issue' date range will be used to determine which pay components within the element to report on.
To Pay Issue Date	Optional, Date, LOV available The ‘Pay Issue' date range will be used to determine which pay components within the element to report on.
Payroll Date	Mandatory, Date, LOV available The ‘Payroll Date' is the date printed in the file.
Interface Code	Mandatory, LOV available Only those reports of the format “TMRS Contributions” will display. Choose from the report formats created. The format “HL$TMRS2” has been provided as a sample, but should be copied, and the copy edited, by the client before running this report. The report definition selected will determine the format of the output file (if any), as well as the columnar content of the report.
Interface Directory	Mandatory, text Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used.
File Name	Mandatory, text Enter the name of the file that will be created in the interface directory specified.
Write or Append	Mandatory, Write or Append lexicon available If the file already exists should the current information overwrite it or append to it?
Output Header and Trailer File Records	Mandatory, Yes or No lexicon available If the file is to contain a header and trailer record then indicate <Yes>.
Exception	Mandatory, Exception Level lexicon available This field defines the exception level (report messages) required.

Report Filters
Pay Run Number	Optional, LOV available This field limits the process to the pay run specified.