The following steps outline the procedure to produce the W2 Forms and the Government file:

RPREGT - Produce pay totals Register#

  • For annual reporting, run RPREGT to produce the YTD Register
  • For quarterly reporting, run RPREGT to produce the QTD Register

IDFD - Define Legislative Forms #

  • This form defines the W2 Form and File Definition for Annual and Quarterly reporting
  • This form contains the default values to enter on IDFDV
  • The information on this form is provided by High Line with the Year End software. The script only needs to be executed in order to load in the most current information for the year.

IDFDV - Define Legislative Form Variables#

  • Users MUST set up Annual W2 Form and File Definition with user information
  • Users CAN set up Quarterly Form and File Definition with user information

RDFD - Form Definition Report#

  • To report the Form and File Definition from IDFD and IDFDV

RPYEU - Produce Year End Summary#

  • Produces US Year End Summary Report for the reporting Year or the reporting Quarter
  • Users must use this report to balance to the YTD Register or QTD Register report (RPREGT)
  • Users must check exception messages from this Summary Report and correct any exceptions
  • Generates the Federal Government file in federal format
  • Generates the State File in the federal file format for States that accept the federal file format
  • Generates the State File for States with specific State File format requirements
  • Users must run RPYEU one State at a time to generate State specific file
  • Each State may have its own requirements. Users must verify if that State specific format is supported by RPYEU prior to running RPYEU for a specific State file
  • Generates an XML file for RPW2 (Oracle version only) to print the W2 Forms
  • Generates the GVT Run and stores information in IPGR, IPGH for RPW2W4C/RPW2W4TB (Windward versions) to print the W2 forms
  • In utility trace mode, RPYEU generates a .txt file for the SQL Select statement and the .csv trace file
  • Provides an option to generate data dump file in a .csv format for Federal, State, Local, School data for balancing and debugging purposes

IPGR - View Government Report Runs#

  • View data by GVT Run Number after RPYEU is run

IPGH - Manage Government Report Details#

  • View data by GVT Header after RPYEU is run for an employee

UPGRUNDO - Undo Government Reporting Run#

  • Allows users to undo a GVT Run number by employee
  • To undo an erroneous GVT Run due to set up issues or to remove archived GVT info

RPW2W4C - Produce W2 Forms #

  • Produce W2 forms (supports 4-on-a-page formats only)
  • Reads GVT file information generated from RPYEU to print the W2 Forms
  • Generates grand totals and exception messages with the RPW2W4C Execution ID as Execution Run Logs

RPW2W4TB - Produce W2 Forms #

  • Produces W2 forms (supports 4-on-a-page, top-to-bottom format only)
  • Reads XML file generated from RPYEU to print the W2 Forms
  • Generates grand totals and exception messages with the RPW2W4TB Execution ID as Execution Run Logs
  • This is the RPW2W4SM function, now re-named RPW2W4TB

REW2 - List of Execution Messages #

  • Produces W2 forms for employees in Self Service
  • Allows the employee to print current year, plus any previous year made available
  • Organizations can control the years that W2 forms are available for employees to print, by defining the EE_W2_GVT_RUN Preference on the IMST form
  • Required if SS_REW2 preference has a value of 'NO' and consent for printing electronically has been given

BEW2 - List of Execution Messages #

  • Produces W2 forms for employees in Self Service via logi panel
  • Allows the employee to print current year only
  • Organizations can control the years that W2 forms are available for employees to print, by defining the EE_W2_GVT_RUN Preference on the IMST form
  • Required if SS_REW2 preference has a value of 'NO' and consent for printing electronically has been given

RMEX - List of Execution Messages #

  • Produces a Grand Total report from the W2 Print Program run to balance to the RPYEU report
  • Users MUST enter the Execution ID of the W2 Print Program run to obtain a grand total report
  • This report is used to balance to RPYEU only. It is not used for government reporting