04 job es2j001d extract edit estimate

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

Job ES2J001D - Extract, Edit, and Estimate (No Quarter Shift)

RUN THIS JOB - As required.

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


Job Features and Functions

  • Extracts data from IMT File and updates Micro and MOA Files
  • New records added to Micro / MOA Files (defaults in non-supplied fields
  • Option to inactivate records (seven delinquent quarters, no estimates)
  • Updates to name, address, phone numbers, Initial and End-liability date; can be blocked with field locks
  • Code changes are non-economic, permitting if first calendar quarter, exceptions:
    • Economic code change indicator
    • Old code(s) = 9’s
    • Inactive to active records
  • Year quarter parameter in ES2N, must be the newest quarter on IMT file
  • Copies EIN, tax rate, ownership, type coverage, and special indicator from master to sub-units
  • Option to block back quarter updates, even if data are on the IMT file
  • Incoming physical addresses clears out geocoding fields
  • Updates Alpha Locator File
  • Performs micro estimates with option for delinquent estimates
  • Estimates are performed on current quarter only
  • Option to process all, single or multiple worksite records
  • Delinquent multi’s only estimated with delinquent estimation
  • Multiple tax wage / contribution allocations either in delinquent or partial estimation option
  • If, after multiple proration-
    • Master changes, re-proration occurs in next run
    • Sub-unit wages change, taxable wages with contribution re-allocated
  • If multi reports after estimated, F11 in ES2R to un-estimate before entry
  • For estimation failures due to long term delinquency, indicator flag set to "N"
  • Performs micro edits
  • Edits are performed on current and immediate prior quarter
  • Option to process all, single, or multi records
  • Option to ignore edit flag and re-edit all active records with data
  • Option allows edit format to be zero (no edit report produced at all)
  • Updates the micro edit file for failed/passed records
  • Sequence of records in micro edit file is set in 001Q, but can be subsequently changed in ES2L State-specific constants table]]
  • Micro edit file sequence determines order of edit report and ES2E
  • Previously edited records don’t reappear on subsequent hard copy edits unless they have a crucial error (error code 001-089), or unless all records are re-edited
  • Optionally copies master’s MOA or tax address to sub-units
  • Copies MOA or UI address to Physical Address field, if address type = 1; preference given to MOA if both MOA and UI addresses exist
  • Sort sequence of Micro Edit file can be changed, if modified in Lookup File prior to running this job

Job 001D performs IMT updates, estimations, and edits in the same manner as Job 001Q, but it does not shift the quarters of the Micro File or purge transaction or narrative comment data. The two Crosswalk Files and the Alpha Locator File are also rebuilt by running this job. Although this job usually extracts late reporter data, it can also extract data for the future quarter prior to running Job 001Q, though future quarter data are not edited by this job. Job 001D can be run multiple times during a quarter’s cycle.


The 001D job is mainly designed to update Micro and MOA data with late-reporter IMT data that were not available earlier. Prior to running this job, a State-specific job must be run to produce the IMT File for loading.


If the IMT data need to be pre-sorted, then Job ES2J084S should be run. If there is a need to correct the IMT data (if the low-valued characters have been set to question mark (“?”) characters), then the ES2J084X job should be run to fix the data appropriately.


Estimates are performed automatically for partially-reported accounts, and optionally for delinquent employers. The edits will be run according to the accounts that are eligible for estimation (or have already been reported); those that remain delinquent in the estimation process will not be included in the edits, since their delinquent values would stand out as though the non-zero employment and wages had suddenly dropped to zero/missing, which would be incorrect estimation data.


Related Links

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