04 job es2j001q quarterly extract

© 2019 - State of Utah - Department of Technology Services
Jump to navigation Jump to search

Job ES2J001Q - Quarterly Extract (Shift Micro File Quarters)

RUN THIS JOB - Quarterly, or as required.

This job executes the following programs (click to link to each program description):


Job Features and Functions

  • Shifts quarters in Micro File
  • Archives oldest quarter on Micro (YBUscX.A145.Micro.Archive; where "sc" = State FIPS code)
  • Posts Micro File codes to old code fields in Refiling File
  • Extracts data from IMT File and updates Micro/MOA Files
  • Performs micro estimates with option for delinquent estimates
  • Performs micro edits
  • Creates initial Micro Edit File for the quarter
  • Sort parameter establishes initial quarter micro edit file order
  • Sort parameters can be subsequently changed in the ES2L State-specific parameter
  • Employment/wage cutoff parameter can exclude small firms from edit report
  • Updates old code field in Refiling File (except response code 46 & 50 records) to match fourth quarter codes in Micro File
  • Deletes the Quarterly Transaction records older than a particular date (up to six months ago)
  • Copies EIN, Tax Rate, Ownership code, Type of Coverage and Special Indicator from the master to its worksites
  • Copies MOA or UI address to physical address field, if address type = 1
  • See Job 001D for more detailed features listing

Job 001Q performs the initial quarterly extract of data from the State Tax File through the Input Micro Transaction (IMT) File, which is created by a State-specific program. Under normal circumstances, this job must be run to begin the quarterly processing of employment and wage data. It is to be run once each quarter.


During the processing of ES2J001Q, the Micro File is shifted forward one quarter, archiving the oldest quarter’s data in the Micro Archive File (at DMA, the archive file name is YBUssX.A145.MICRO.ARCHIVE(+0)‡1). 001Q also sets up space for the new future quarter’s data.


Micro data estimations and edits are performed, older Administrative and Quarterly Transaction Files and Narrative Comment File records are purged, and three supplemental files (the Alpha Locator File, and both the County–and Statewide–Crosswalk Files) are rebuilt from the revised micro data. The initial sequence of the Micro Edit File for the quarter is determined by the parameters supplied to the 001Q job, though it can be modified by changes to the State-specific Constants record of the Lookup File, followed by another job that includes the micro edits (001D, 002D, 028D, or 242D).


If someone wants to shift the quarters without loading an IMT file, the best job is ES2J001R, which is described next. It performs most of the processes of this job, but does not perform IMT estimation or editing processes.


1 Whenever there is a (+0) notation, it means that the file is a “GDG” (or Generation Data Group), which is a file that is saved by generations, and the more recent of these appears as relative generation (+0); earlier generations would be (-1), (-2), etc., as the relative generation number is used.


Related Links

Retrieved from "http://qcewsupportapps.com/index.php?title=04_job_es2j001q_quarterly_extract&oldid=5664"