04 job es2j018d gross errors
Job ES2J018D - Gross Errors (A-B-C List) Report
RUN THIS JOB - As required.
This job executes the following programs (click to link to each program description):
Job Features and Functions
- Reads micro edit file to identify records with major edit exceptions
- Reads PK067 and PK068 values in Edit/Estimation Parameters of Lookup File to determine employment and wage cutoff levels
- Generates gross error report for current or prior quarter parameter specified
- Qualifying error codes: 011, 012, 013, 014, 025, 070, 072, 091, 092, 093, 094, 095, 096, 097, 126, 127, 130, 131, 132, 133
- There is an option to list only uncommented error records
Job 018D generates a report of “A-list” error accounts, those establishments with significant employment and/or wages that contain an error code that could affect the integrity of the EQUI deliverable. This is a subset of the micro edits that helps to limit the scope of edit review, but is not as focused as the Job 008D report. Since this relies on the current Micro Edit File content, some accounts may appear that have already been corrected.
Job 018D is not an edit, but rather prints a current or prior single quarter report of records that were previously edited and flagged with a major error by a micro edit job. Jobs 001Q, 001D, 002D, 028D, and 042D include the micro edit program that flags records with errors and writes these records to the Micro Edit File. Job 018D reads the Micro Edit File, searches for records with major errors, as defined by BLS, and prints these records on a report. Error codes considered to be major are listed below. Also, PK67 and PK68 in the edit/estimation table of the Lookup File are employment and wage cutoff levels for this job. A record must be present in the Micro Edit File with at least one major error code and must also have employment or wages above the PK67 and PK68 cutoff levels to qualify for the report.
The 018D job is driven by records that exist in the Micro Edit File. The PK67 employment level checks are based on any of the three months of the specified quarter, or the third month of the previous quarter. The PK68 wage level checks are based on specified or previous quarter wage levels. These employment and wage cut-off parameters are stored in the State-specific constants table of the Lookup File. The PK 67 employment cut off value has a BLS default of 20. It can be set lower, but not higher. The PK68 wage cut off value has a BLS default of 500,000. It can be set lower, but not higher. If any of the four months of employment, or two quarters of wages equal or exceed the parameter levels, records with gross errors in the Micro Edit File will print on the report. An option exists to exclude records with comment codes for the relevant quarter. Records are listed on the Gross Error Report in the sequence of the Micro Edit File.
Job 018D can be run at any time. It is recommended to be run at least once prior to submittal of the EQUI to identify any serious type errors that may remain unresolved.
Micro exceptions considered by BLS to be gross errors are listed below, by error code:
| Gross Error Code | Gross Error Description |
|---|---|
| 011 | Invalid NAICS code |
| 012 | Invalid Ownership code |
| 013 | Invalid County code |
| 014 | Conflicting ownership and NAICS codes |
| 025 | Invalid Status code |
| 040 | Invalid multi indicator code |
| 064 | MEEI/reporting unit # inconsistent |
| 065 | Inconsistent county/zone or county township combination |
| 070 | No useable address |
| 072 | Both Trade Name and Legal name are blank |
| 091 | Large firm employment change |
| 092 | Large firm ave quarterly wage change |
| 093 | Large firm ave mo empl > (parm), but wages = 0 |
| 094 | Large firm ave mo empl = 0, but wages > (parm) |
| 095 | AME > (parm) and total wages = sum of employment |
| 096 | Unusually large new record |
| 097 | Unusually large discontinued record |
| 126 | Small firm monthly employment change |
| 127 | Average quarterly wage change |
| 130 | Ave mo empl > (parm), but wages = 0 |
| 131 | Ave mo empl = 0, but wages > (parm) |
| 132 | AME > (parm) and total wages = sum of employment |
| 133 | SIC = 9999 and employment > (parm) |
| 139 | Large new record |
| 140 | Large discontinued record |
Related Links
