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 ICMAInterface 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. |
