This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 1 KB JMyers to previous
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB JMyers to previous | to last
3 26-Nov-2021 10:22 3 KB JMyers to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 3 KB JMyers to last

Page References

Incoming links Outgoing links
TMRS
TMRS

Version management

Difference between version and

At line 7 changed 2 lines
TMRS or ‘Texas Municipal Retirement System’ is a qualified retirement plan under Section 401 of the Internal Revenue Code."\\ \\
TMRS or ‘Texas Municipal Retirement System’ is a qualified retirement plan under Section 401 of the Internal Revenue Code."\\
At line 11 changed one line
The benefit plan may be set up with the standard benefit components documented in the Benefits Administration section.\\
The benefit plan may be set up with the standard benefit components documented in [Benefits Administration|BENEFIT COMPONENTS].\\
----
At line 13 changed 15 lines
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 form (IDIF), 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
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 |
At line 29 changed 32 lines
These are the report parameters for the monthly-required report.
‘Create TMRS Interface File’ Highlights
‘Create TMRS Interface File’ may be found through the menu bar:
The form may also be accessed through the command window with ‘UPTMRS2’.
‘Create TMRS Interface File’ Usage and Examples
Report Parameters Entity Mandatory, LOV available
Limits the process to the entity specified.
Payroll Mandatory, LOV available
Only one payroll may be selected per execution of this function.
Pay Run Number Optional, LOV available TMRS Gross Element Mandatory, LOV available TMRS Contribution Element Mandatory, LOV available Reporting Period Mandatory, Text YYYYMM
The ‘Reporting Period’ date will be used to determine which 'month' the report falls into.
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, LOV available
If the file already exists should the current information overwrite it or append to it?
Exception Level Mandatory, LOV available
A ‘trace’ report of exception messages may be produced to assist in the testing phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this is a voluminous report and will cause very slow performance.
[{InsertPage page='UPTMRS2' section=1}]
[{InsertPage page='UPTMRS2' section=2}]
[{InsertPage page='UPTMRS2' section=3}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyersTop