11 list prioritization scheme
A-B-C List Prioritization Scheme
The following is the prioritization list, under the Gross Errors classification of edit exceptions. It shows the relative importance of conditions in all of the editing sub-systems and how they interrelate. The columns are: Rank, EXPO “G” code (‘GCd’), BLS classification (‘BLS’), and edit condition description. The rank is a sequential number for relative severity of the condition.
Note: When both macro and micro records have the same error code, the micro takes precedence over the macro in this severity table; macros are not listed separately in the list below.
The EXPO “G” code combines the “A”, “B”, or “C” letter (with some exceptions where the BLS codes could cause sorting conflicts), and the original 3-digit error code number. Some edits are not performed in EXPO. Those that can appear in the EXPO edits with a “G” code are in bold characters. The BLS classification is composed of three parts: the A, B, or C group letter, the edit class code, and the edit sub-class code. Edit classes and sub-classes include:
A.1.1 = B.1.2 = C.1.2 - Pre-Edits;
A.1.2 = B.1.3 - Key Field Edits;
A.1.3 = B.1.4 = C.1.4 - Dates and Status Code Edits;
A.1.4 = B.1.5 = C.1.6 = Remaining Invalid Error Edits;
A.1.5 = B.1.6 = Significant Employment and Wage Micro and Summed Level Edits
A.1.6 = B.1.7 = C.1.8 = Warning and Other Summed Level Edits
A.2.8 = Multi-Establishment Edits
B.2.7 = Predecessor / Successor Edits
C.2.9 = Identical Monthly Employment Edit
C.3.10 = Missing EIN
C.4.9 = Wage Record Edits
Note: The A-B-C prioritization structure is reviewed periodically. It will likely be modified in future versions, as the value and significance of each edit is re-evaluated. The current use of dual-level coding, depending upon the size of the employer, may be discontinued eventually. If so, all error codes that could be considered an “A”-level error for a large establishment will become an “A” classification for all establishments. If applied, it could significantly skew both A-list reports and edit scoring.
Rnk. GCd BLS Description of Edit Condition
1. A002 A.1.1 Invalid U-I account number on larger account
2. A003 A.1.1 Invalid reporting unit number on larger account
3. A004 A.1.1 Invalid year in EQUI record on larger account
4. A005 A.1.1 Invalid quarter in EQUI record on larger account
5. A006 A.1.1 Invalid state code in EQUI record on larger account
6. A010 A.1.2 Invalid NAICS code on larger account
7. A012 A.1.2 Invalid ownership code on larger account
8. A013 A.1.2 Invalid county code on larger account
9. A016 A.1.2 NAICS and ownership codes inconsistent
10. A017 A.1.2 NAICS02 – 2007 NAICS conflict on larger account
11. A025 A.1.3 Invalid status code on larger account
12. A039 A.1.4 Invalid type of coverage
13. A040 A.1.4 Invalid MEEI code on larger account
14. A045 A.1.4 Invalid EIN Format
15. A056 A.1.4 Inconsistent ownership / type of coverage
16. A057 A.1.4 Taxable wages found on federal record
17. A058 A.1.4 Contributions found on federal record
18. A059 A.1.4 Taxable wages > 0 for non-experience-rated record
19. A060 A.1.4 Contributions > 0 for non-experience-rated record
20. A062 A.1.4 Taxable wages > total wages
21. A063 A.1.4 Contributions > taxable wages
22. A064 A.1.4 MEEI / reporting unit number inconsistent on larger account
23. A065 A.1.4 Inconsistent county/township combination on larger account
24. A070 A.1.4 No useable address on larger account
25. A072 A.1.4 Both trade name and legal name are blank on larger account
26. A085 A.1.4 Potential predecessor found based on wage record data
27. A086 A.1.4 Potential successor found based on wage record data
28. A091 A.1.5 Employment change greatly exceeds parameters on larger account
29. A092 A.1.5 AQW change is significantly > $parm and exceeds twice the quartile AQW range on larger account
30. A093 A.1.5 Average employment is significantly > parm, but total wages = $0 on larger account
31. A094 A.1.5 Average employment = 0, but total wages are significantly > parm on larger account
32. A095 A.1.5 Total wages = sum of employment +/- parm if AME is large on larger account
33. A096 A.1.5 Large new record on larger account
34. A097 A.1.5 Large discontinued record on larger account
35. A099 A.1.5 Large establishment with estimated employment
36. A116 A.1.6 EIN missing for more than parm months
37. A126 A.1.6 Employment change exceeds test parameters on larger account
38. A127 A.1.6 AQW change > $parm and exceeds twice the quartile AQW range on larger account
39. A130 A.1.6 Average employment > parm, but total wages = $0 on larger account
40. A131 A.1.6 Average employment = 0, but total wages > parm on larger account
41. A132 A.1.6 Total wages = sum of employment +/- parm on larger account
42. A133 A.1.6 NAICS = 999999, employment > parm on larger account
43. A134 A.1.6 [Macro only] Number of establishments out of range on larger cell
44. A135 A.1.6 [Macro only] New or discontinued larger macro cell
45. A139 A.1.6 New larger account
46. A140 A.1.6 Discontinued larger account
47. B160 A.1.6 Both predecessor and successor reported
48. B161 A.1.6 Neither predecessor nor successor reported
49. A171 A.2.8 First month employment out-of-balance in larger multi-family
50. A172 A.2.8 Second month employment out-of-balance in larger multi-family
51. A173 A.2.8 Third month employment out-of-balance in larger multi-family
52. A174 A.2.8 Total wages out of balance in larger multi family
53. A175 A.2.8 Taxable wages out of balance in larger multi family
54. A176 A.2.8 Contributions out of balance in larger multi family
55. A178 A.2.8 Larger master without multiple worksites
56. A179 A.2.8 Larger family of worksites missing master
57. A180 A.2.8 Larger single account with active worksites
58. A181 A.2.8 Worksite ownership code differs from master in larger multi-family
59. A182 A.2.8 Worksite EIN differs from master in larger multi-family
60. A183 A.2.8 Inconsistencies from multi-collapse of larger multi-family
61. A184 A.2.8 Larger multi-family ceases MWR breakout
62. B002 B.1.2 Invalid U-I account number
63. B003 B.1.2 Invalid reporting unit number
64. B004 B.1.2 Invalid year in EQUI record
65. B005 B.1.2 Invalid quarter in EQUI record
66. B006 B.1.2 Invalid state code in EQUI record
67. B010 B.1.5 Invalid NAICS code
68. B012 B.1.3 Invalid ownership code
69. B013 B.1.3 Invalid county code
70. B016 B.1.3 NAICS and ownership codes inconsistent
71. B017 B.1.3 NAICS-02 conflicts with 2007 NAICS code
72. B025 B.1.4 Invalid status code
73. B039 B.1.5 Invalid type of coverage
74. B040 B.1.5 Invalid MEEI code
75. B043 B.1.5 Invalid predecessor SESA ID
76. B044 B.1.5 Invalid successor SESA ID
77. B045 B.1.5 Invalid federal EI number
78. B046 B.1.5 Invalid ARS response code / year
79. B056 B.1.5 Inconsistent ownership / type of coverage
80. B057 B.1.5 Taxable wages found on federal record
81. B058 B.1.5 Contributions found on federal record
82. B059 B.1.5 Taxable wages > 0 for non-experience-rated record
83. B060 B.1.5 Contributions > 0 for non-experience-rated record
84. B062 B.1.5 Taxable wages > total wages
85. B063 B.1.5 Contributions > taxable wages
86. B064 B.1.5 MEEI / reporting unit number inconsistent
87. B065 B.1.5 Inconsistent county/township combination
88. B066 B.1.5 Invalid format in predecessor account
89. B067 B.1.5 Invalid format in successor account
90. B070 B.1.5 No useable address
91. B072 B.1.5 Both trade name and legal name are blank
92. B074 B.1.5 Old ownership code does not match fourth quarter code
93. B075 B.1.5 Old county code does not match fourth quarter code
94. B076 B.1.5 Old county/township codes do not match fourth quarter codes
95. B078 B.1.5 Old NAICS code does not match fourth quarter code
96. A085 A.1.4 Potential predecessor found based on wage record data
97. A086 A.1.4 Potential successor found based on wage record data
98. B088 B.1.5 No physical address present for large employer
99. B091 B.1.6 Employment change greatly exceeds test parameters
100. B092 B.1.6 AQW change is significantly > $parm and exceeds twice the quartile AQW range
101. B093 B.1.6 Average employment is significantly > parm, but total wages = $0
102. B094 B.1.6 Average employment = 0, but total wages are significantly > parm
103. B095 B.1.6 Total wages = sum of employment +/- parm if AME is large
104. B096 B.1.6 Large new record
105. B097 B.1.6 Large discontinued record
106. B099 B.1.6 Large establishment with estimated employment present
107. B116 B.1.7 EIN missing for more than parm months
108. B120 B.1.7 Possible mid-year non-economic code change
109. B121 B.1.7 Code change back to a recent code
110. B123 B.1.7 Expected code change not made
111. B126 B.1.7 Employment change exceeds test parameters
112. B127 B.1.7 AQW change > $parm and exceeds twice the quartile AQW range
113. B130 B.1.7 Average employment > parm, but total wages = $0
114. B131 B.1.7 Average employment = 0, but total wages > parm
115. B132 B.1.7 Total wages = sum of employment +/- parm
116. B133 B.1.7 NAICS = 999999, employment > parm
117. B134 B.1.7 [Macro only] Number of establishments out of range
118. B135 B.1.7 [Macro only] New or discontinued macro cell
119. B139 B.1.7 New account
120. B140 B.1.7 Discontinued account
121. B156 B.2.7 Predecessor/successor county code change conflict
122. B157 B.2.7 Predecessor/successor ownership code change conflict
123. B159 B.2.7 Predecessor/successor township code change conflict
124. B164 B.2.7 Predecessor/successor NAICS code change conflict
125. B171 B.2.9 First month employment out-of-balance in multi-family
126. B172 B.2.9 Second month employment out-of-balance in multi-family
127. B173 B.2.9 Third month employment out-of-balance in multi-family
128. B174 B.2.9 Total wages out of balance in multi family
129. B175 B.2.9 Taxable wages out of balance in multi family
130. B176 B.2.9 Contributions out of balance in multi family
131. B178 B.2.9 Master without multiple worksites
132. B179 B.2.9 Family of worksites missing master
133. B180 B.2.9 Single account with active worksites
134. B181 B.2.9 Worksite ownership code differs from master
135. B182 B.2.9 Worksite EIN differs from master
136. B183 B.2.9 Inconsistencies from multi-collapse of multi-family
137. B184 B.2.9 Multi-family ceases MWR breakout
138. C001 C.1.2 Invalid EQUI transaction code
139. C021 C.1.4 Invalid initial liability date format
140. C022 C.1.4 Invalid EOL date format
141. C023 C.1.4 Invalid setup date format
142. C024 C.1.4 Reactivation date format invalid of earlier than liability date
143. C031 C.1.6 Invalid first month employment
144. C032 C.1.6 Invalid second month employment
145. C033 C.1.6 Invalid third month employment
146. C034 C.1.6 Invalid total wages
147. C035 C.1.6 Invalid taxable wages
148. C036 C.1.6 Invalid contributions
149. C047 C.1.6 Tax rate beyond minimum/maximum range
150. C048 C.1.6 Invalid comment code
151. C049 C.1.6 Invalid first month employment indicator
152. C050 C.1.6 Invalid second month employment indicator
153. C051 C.1.6 Invalid third month employment indicator
154. C052 C.1.6 Invalid total wages indicator
155. C053 C.1.6 Invalid taxable wages indicator
156. C054 C.1.6 Invalid contributions indicator
157. C055 C.1.6 EQUI transaction not executable
158. C101 C.1.8 Unusable address type code (M-O address)
159. C102 C.1.8 Blank physical location city with other P/L address fields present
160. C103 C.1.8 Unusable physical location state abbreviation
161. C104 C.1.8 Unusable physical location zip code format
162. C105 C.1.8 Unusable telephone number format
163. C106 C.1.8 Blank U-I city field with other U-I address fields present
164. C107 C.1.8 Unusable U-I state abbreviation
165. C108 C.1.8 Unusable U-I zip code format
166. C109 C.1.8 Blank MOA city with other M/O address fields present
167. C110 C.1.8 Unusable mailing/other state abbreviation
168. C111 C.1.8 Unusable mailing/other zip code format
169. C112 C.1.8 Questionable fax phone number format
170. C114 C.1.8 Physical address error - P.O. box, blank street address, or out-of-state location in physical location address block
171. C118 C.1.8 Computed tax rate > tol% from reported, and compute tax > tol from reported
172. C119 C.1.8 First quarter taxable wages missing for an experience-rated account
173. C124 C.1.8 Inactive record with reported employment or wage data present
174. C125 C.1.8 Data reported prior to the initial liability date
175. C129 C.1.8 Taxable/total wage ratio exceeds prior year ratio by parm%
176. D128 C.2.9 Identical monthly employment > parm
177. D191 C.4.9 Questionable wage record count
178. D192 C.4.9 Questionable wage record wages
179. D193 C.4.9 First month employment > wage record count
180. D194 C.4.9 Second month employment > wage record count
181. D195 C.4.9 Third month employment > wage record count
182. D196 C.4.9 All months employment equal wage record count
183. D197 C.4.9 Total wages vary greatly from wages on wage records
Related Links
