W 2_GOVERNMENT_REPORTING_PROCEDURES
Back to current versionRestore this version
The following steps outline the procedure to produce the W2 Forms and the Government file:
  1. RPREGT
    • RPREGT
      • For annual reporting , run RPREGT to produce YTD Register
      • For quarterly reporting, run RPREGT to produce QTD Register
  2. IDFD/IDFDV/RDFD
    • IDFD
      • Specifies the W2 Form and File Definition for Annual and Quarterly reporting
      • Contains the default values to enter on IDFDV
      • The information on this screen is provided at release time using a script. The script only needs to be executed in order to load in the most current information for the year.
    • IDFDV
      • Mandatory set up of Annual W2 Form and File Definition with user information
      • Optional set up of Quarterly Form and File Definition with user information
    • RDFD
      • Used to report the Form and File Definition from IDFD and IDFDV
  3. RPYEU
    • RPYEU
      • Produces US Year End Summary Report for the reporting Year or the reporting Quarter
      • Must be used to balance to the YTD Register or QTD Register report (RPREGT)
      • Exception messages from this Summary Report must be checked and any exceptions corrected
      • Generates the Federal Government file in federal format
      • Generates State File in the federal file format for states that accept the federal file format
      • Generates State File for states with specific State File format requirement
      • RPYEU must be run one state at a time to generate state specific file
      • Each state may have its own requirement, it must be verified if that state specific format is supported by RPYEU prior to running RPYEU for a specific state file
      • Generates an XML file to feed into Oracle version RPW2 in order to print W2 Forms
      • Generates GVT Run and stores information in IPGR, IPGH for Windward RPW2W
      • In utility trace mode, RPYEU generates a .txt file for SQL Select statement and csv trace file
      • Provides an option to generate data dump file in .csv format for Federal, State, Local, School data for debugging or balancing
  4. IPGR/IPGH
    • IPGR
      • Screen inquiry by GVT Run Number after RPYEU
    • IPGH
      • Screen inquiry by GVT Header for an employee after RPYEU
  5. UPGRUNDO
    • UPGRUNDO
      • Used to undo GVT Run number by employee
      • Used to undo erroneous GVT Run due to set up issues or to remove archived GVT info
  6. RPW2 (Oracle)/RPW2W (Windward)
    • RPW2 (Oracle)
      • Produces W2 forms (supporting either a 2-on-a-page or 4-on-a-page format)
      • Reads XML file generated from RPYEU to print W2 forms
      • Prints W2 on pre-printed W2 forms or prints different copies (Copy A, 1, B, C, 2, D ) of the W2 forms along with an option to print 'Employee Instructions' on the back
      • Generates grand total and exception messages with RPW2 Execution ID as Execution Run Logs
      • It is mandatory to use the Execution ID of the RPW2 and run RMEX to obtain a grand total report
    • RPW2W (Windward)
      • Produces W2 forms (supporting a 4-on-a-page format only)
      • Reads IPGR/IPGH information generated from RPYEU to print W2 Forms
      • Generates grand total and exception messages with RPW2W Execution ID as Execution Run Logs
  7. RMEX
    • RMEX
      • Produces a grand total report from the RPW2 run to balance to RPYEU
      • It is mandatory to enter the Execution ID of the RPW2W run to obtain a grand total report
      • The RMEX grand total report is used to balance to RPYEU only, and is not used for government reporting

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation