Main Page → Payroll → Documentation → Other → North Dakota Retirement Magnetic Media Reporting

What This Process Does


  • Creates tab-delimited file for uploading the monthly TFFR information to the North Dakota Retirement and Investment Office website.
  • E-Documents will be created of the report with a description of ND Retirement Magnetic Media Reporting.


Requirements


  • To be selected into the report, Deduction Description IDs must begin with ND TFFR, and the Deduction Type must contain RETIREMENT.
  • The report uses the Job Deduction Fiscal file (PAYJDFM).
  • When the reporting month is June, employees with ND TFFR deductions will select regardless of whether they have earnings or contributions for the fiscal month of June.
  • The Deduction Description Gross Amount Tab must contain the multiplier to calculate retirement salary. When the employer makes the payment of all member contributions in lieu of salary increase (Model 2), the formula is as follows: 1.0 - rate that the employer is paying on behalf of the employee, and that result is divided by 1. For example, if rate is full EE rate, 11.75%, then 1.0 - .1175 = .8825. Therefore, 1.0/.8825 = 1.133144 is the multiplier. If the rate is less than the full rate such as if the employer is paying 2.5% of the employee's portion then the formula would be 1.0 - .025 = .975. This multiplier will change if the rate changes. The Deduction Description Gross Amount tab should look like this:

([STANDARD GROSS AMOUNT]*1.133144)

  • Model 2 plan requires 3 deductions, EMPASS (employee portion paid by ER), EMPCON (employer portion), and MEMASS (employee paid amount)
  • Termination date from Personnel Demographics will default as the Last Day worked for terminated employees.
  • When creating the final report for the school year, enter the Last Day worked in the Default Last Day field on the range screen to populate for all employees.
  • Contract hours default from the Contract Hours field, on the Contract tab, in the employee's Job Master (factored by the job's FTE). This field is controlled on the Gross Definition under the Block Flags tab, so contact RDA if this field needs to be added to the Job Master
  • The file will be named T16620RI.001.


North Dakota Retirement Magnetic Media Reporting


  1. HR → Payroll → Other → North Dakota Reports → ND TFFR Report
  2. Enter the Fiscal Year being reported and the Reporting Month.
  3. Default Last Day – normally this is left blank, except at the end of the school year; if populated this will appear as the Last Day for all employees on the report; recommend populating Termination Date in Personnel Demographics for terminated employees; Termination Date will override Default Last Day if entered.
  4. Provide the Report Date, and District Number.
  5. Range as needed, but in most cases not necessary.
  6. Click Select (cog) to run the report.
  7. The Process Exception browse screen displays; make changes or skip employees if necessary.
  8. Click Continue when done.
  9. View and/or Print the report that generates.
  10. If accurate, click Set Flags/Update to create text file; otherwise cancel.
  11. Upon setting flags, the DOS Copy window displays. Note the Filename (TI6620RI-001). This file now resides on your server.
  12. Click the URL/Internet (globe) button; the North Dakota Retirement and Investment Office website should display, so you can Log In to upload the file.
  13. Alternatively, access the Retirement website through your VNC session and upload the report, or move the file from server to work station using CoreFTP.
    FIELDSOpt.Rec.Req.Description
    Fiscal Year——♦Current Fiscal Year
    Reporting Month——♦Current Reporting Month
    Default Last Day♦——Normally left blank on the range screen, except at end of school year; Personnel Demographics Termination Date populates as Last Day for Terminated Employees
    Report Date——♦Date of Report
    District Number——♦Organization's District Number
    Opt. = Optional  Rec. = Recommended  Req. = Required