11 code 192 wage record wages check

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

Wage Record Wages Check - Code 192

This is the first of two edits on the Wage Record Wages (WRW), which are the summed total wages from the individual employee wage records forwarded by the State-specific ES2WA01 program to the Wage Summary update program (ES2WA02). Unlike other edits throughout the MicMac design, wage data edits are assembled in a hodgepodge order. The 191 code deals with WRC, while this code is for WRW. Codes 193 through 196 again deal with the WRC value, and 197 returns to the WRW. As with other Wage Summary File edits, there are preliminary conditions checked before the edit can be run. First, the wage record wages field must be a numeric, non-zero value. Next, the employer must be a single or master, experience-rated firm. Third, the Wage Record Wages Availability Switch must be set to “Y”, indicating that the WRW field is supposed to be present. Finally, the micro record’s AME must meet or surpass the level required by the PK049 cutoff value.


If all of the preconditions are met, this edit checks for total wages significantly exceeding the wage record wages. If accurate data are represented in both files, it should not be possible for the Micro File total wages to surpass the Wage Summary File wages. The former represents data for all employees working during the 12th day of any month in the quarter, whereas the latter represents wages for all of the quarter. So there is a chance that the two would be equal, or that the micro data would be lower. It is not possible, however, for the micro wages to be higher (since part of the picture shouldn’t be larger than the whole picture).


The edit equation is fairly simple, namely:


091 code 192.png


Of course, if the wage record wages (WRW) are higher than the total wages (TotW), the difference will be negative, which will never be greater than the allowed tolerance. So, the edit only comes into play when the total wages are significantly larger than the WRW. The description of the condition is “Questionable Wage Record Wages.” BLS classification: C.4.9.


Related Links