This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Texas Municipal Retirement System - TMRS #

The following statements are taken from the Texas Municipal Retirement System's web site:

"Each TMRS participating city has its own retirement plan within the general frame work of the Texas Municipal Retirement System Act. Provisions may vary from city to city, depending upon the options selected by the individual municipality.

TMRS or ‘Texas Municipal Retirement System’ is a qualified retirement plan under Section 401 of the Internal Revenue Code."

TMRS Setup #

To execute the required monthly report the only set up required is a few pay elements and the Interface Format form (IDIF).

The benefit plan may be set up with the standard benefit components documented in Benefits Administration.

---

Pay Elements - IPPE #

Two pay elements must be defined in order to run the UPTMRS2 update:
TMRS GROSS
TMRS CONTRIBUTION

---

Interface Format - IDIF #

If not already defined in the Interface Formats Definition (IDIF) form, load the standard interface file format using the starter_idif_hl$tmrs2.sql script.

Modify the standard TMRS2 file to bank requirements using the IDIF function. Rename the code from HL$TMRS2 to a user-defined code.

Rec	Field	Start	Position	Ending Position	Name	Variable Number	Notes
1	1	1	3	Filler
1	2	4	8	City Number		Enter in Constant
1	3	9	17	SSN	Employee SSN	Identity Government ID
1	4	18	25	Current Month Earnings	Employee Earnings	Element on UPTMRS2
1	5	26	32	Current Month Deduction	Employee Contribution	Element on UPTMRS2
1	6	33	47	Filler
1	7	48	80	Member Name	Member Name	Identity Name

There is no page called 'UPTMRS2_WithUnderscore'. Would you like to create it?