11 appendix expo editing procedures

11 - Appendix E - EXPO Editing Procedures

EXPO EDITING PROCEDURES TABLE OF CONTENTS

• Introduction
• Lookup Table Program Constants (PK Values)
  • PK001
  • PK002
  • PK003
  • PK004
  • PK005
  • PK006
  • PK007
  • PK008
  • PK009
  • PK010
  • PK011
  • PK012
  • PK013
  • PK014
  • PK015
  • PK016
  • PK017
  • PK018
  • PK019
  • PK020
  • PK021
  • PK022
  • PK023
  • PK024
  • PK025
  • PK026
  • PK027
  • PK028
  • PK029
  • PK030
  • PK031
  • PK032
  • PK033
  • PK034
  • PK035
  • PK036
  • PK037
  • PK038
  • PK039
  • PK040
  • PK041
  • PK042
  • PK043
  • PK044
  • PK045
  • PK046
  • PK047
  • PK048
  • PK049
  • PK050
  • PK051
  • PK052
  • PK053
  • PK054
  • PK055
  • PK056
  • PK057
  • PK058
  • PK059
  • PK060
  • PK061
  • PK062​
  • PK063
  • PK064
  • PK065
  • PK066
  • PK067
  • PK068
  • PK069
  • PK070
  • PK071
  • PK072
  • PK073
  • PK074
  • PK075
  • PK076
  • PK077
  • PK078
  • PK079
  • PK080
  • PK081
  • PK082
  • PK083
  • PK084
  • PK085
  • PK086
  • PK087
  • PK088​
• ​Micro and Integrated Edit Processing (Program ES2MI28)
  • Edit Pre-Selection Steps
  • Crucial-Level Micro Edits​​
    • Code 001 - Transaction Code Check
    • Code 002 - U-I Account Number Format
    • Code 003 - Reporting Unit Number (RUN) Format
    • Code 004 - Reference Year Check
    • Code 005 - Reference Quarter Check​
    • Code 006 - State Code Check
    • Code 010 - NAICS Code Check
    • Code 012 - Ownership Code Check
    • Code 013 - County Code Check
    • Code 016 - NAICS/Ownership Conflict Check
    • Code 017 - NAICS-02 and 2007 NAICS Conflict Check
    • Code 021 - Liability Date Format Check
    • Code 022 - End-of-Liability Date Format Check
    • Code 023 - Set-Up Date Format Check
    • Code 024 - Reactivation Date Format Check
    • Code 025 - Status Code Check
    • Code 031 - First Month's Employment Check
    • Code 032 - Second Month's Employment Check
    • Code 033 - Third Month's Employment Check
    • Code 034 - Total Wages Check
    • Code 035 - Taxable Wages Check
    • Code 036 - Contributions Check
    • Code 039 - Type of Coverage Check
    • Code 040 - MEEI Check
    • Code 043 - Predecessor ID Check
    • Code 044 - Successor ID Check
    • Code 045 - Federal Employer Identification Number (EIN) Check
    • Code 046 - ARS Response Code / Year Check
    • Code 047 - Tax Rate Range Check
    • Code 048 - Comment Code Check
    • Code 049 - First Month Employment Indicator Check
    • Code 050 - Second Month Employment Indicator Check
    • Code 051 - Third Month Employment Indicator Check
    • Code 052 - Total Wages Indicator Check
    • Code 053 - Taxable Wages Indicator Check
    • Code 054 - Contribution Indicator Check
    • Code 055 - Transaction Validity Check
    • Code 056 - Federal Type of Coverage Check
    • Code 057 - Federal/Taxable Wages Check
    • Code 058 - Federal/Contributions Check
    • Code 059 - Taxable Wage Check for Non-E/R Accounts
    • Code 060 - Contribution Check for Non-E/R Accounts
    • Code 062 - Taxable > Total Wage Check
    • Code 063 - Contribution > Taxable Wage Check
    • Code 064 - Inconsistent MEEI and RUN Check
    • Code 065 - Inconsistent County and Township Codes Check
    • Code 066 - Predecessor Account Format Check
    • Code 067 - Successor Account Format Check
    • Code 070 - No Usable Address
    • Code 072 - Blank Names Check
    • Code 074 - Old Owner Code Check
    • Code 075 - Old County Code Check
    • Code 076 - Old County/Township Code Check
    • Code 078 - Old NAICS Code Check
    • Code 080 - Indian Tribal Council Ownership Check
    • Code 085 - Potential Predecessor Suspected Base on Wage Records
    • Code 086 - Potential Successor Suspected Base on Wage Records
    • Code 088 - No Physical Address for Large Employer
• Non-Crucial Micro Edits
  • Code 091 - Large Monthly Employment Change​
  • Code 092 - Large AQW Change Check
  • Code 093 - Large Employment without Wages Check
  • Code 094 - Large Wages without Employment Check
  • Code 095 - Large Wages/Employment Sum Check
  • Code 096 - Large New Record Check​
  • Code 097 - Large Discontinued Record Check
  • Code 099 - Large Estimated Establishment
  • Code 101 - (Mailing/Other) Address Type Code Check
  • Code 102 - Physical Location City Check
  • Code 103 - Physical Location State Abbreviation Check
  • Code 104 - Physical Location Zip Code Format Check
  • Code 105 - Telephone Number Format Check
  • Code 106 - U-I Address City Check
  • Code 107 - U-I Address State Abbreviation Check
  • Code 108 - U-I Address Zip Code Format Check
  • Code 109 - Blank Mailing/Other City Check
  • Code 110 - Mailing/Other State Abbreviation Check
  • Code 111 - Mailing/Other Zip Code Format Check
  • Code 112 - Fax Phone Number Format Check
  • Code 114 - Physical Address Format Check
  • Code 116 - Missing Employer Identification Number Check
  • Code 118 - Tax Rate Consistency Check
  • Code 119 - Missing Taxable Wage Check
  • Code 120 - Non-Economic Code Change Check
  • Code 121 - Reverse Code Change Check
  • Code 123 - CCS Edit Checks
  • Code 124 - Active Account Check
  • Code 125 - Liability Check
  • Code 126 - Monthly Employment Change Check
  • Macro Edit Version - Program ES2MA02
  • Code 127 - Average Quarterly Wage Change Check
    • Macro Edit Version
  • Code 128 - Identical Monthly Employment Check
  • Code 129 - Taxable / Total Wage Change Check
  • Code 130 - Small Employment without Wages Check
    • Macro Edit Version
  • Code 131 - Small Wages without Employment Check
    • Macro Edit Version
  • Code 132 - Small Wages/Employment Sum Check
  • Code 133 - NAICS-999999 Check
  • Code 134 - Number of Establishments Change Check - Macro Edit Only
  • Code 135 - New and Discontinued Macro Record Checks - Macro Edit Only
  • Code 139 - New Record Check
  • Code 140 - Discontinued Record Check​
• Multi-Worksite Family Balance Processing (Program ES2MI03)​
  • Multi-Balance Editing Techniques
  • Multi-Balance Warning Messages
    • Code 177 - Inconsistencies from Multi Breakout Check
    • Code 178 - Master without Multiple Worksites
    • Code 179 - Worksites Missing Master Check
    • Code 180 - Single Account / Active Worksites
    • Code 181 - Master / Worksite Owner Code Check
    • Code 182 - Master / Worksite EIN Check
    • Code 183 - Inconsistencies from Multi Collapse Check
    • Code 184 - Large Multi Ceases Breakout Check
• Predecessor/Successor Editing (Program ES2MI15)​​
  • Identifying Potential Successor-to-Predecessor Pairings
  • Identifying Potential Predecessor-to-Successor Pairings​
  • Code 160 - Employment Overlap Check​​
  • Code 161 - Employment Gap Check​​
  • Code 157 - Ownership Code Change Check
  • Code 156 - Township Code Change Check
  • Code 164 - NAICS Code Change Check
  • Processing Wrap-Up​​
• Wage Data Editing (Program ES2WA03)​
  • Preselection Process
  • Code 191 - Wage Record Count Check
  • Code 192 - Wage Record Wages Check
  • Code 193 - First Month Employment / Wage Record Comparison Check
  • Code 194 - Second Month Employment / Wage Record Comparison Check
  • Code 195 - Third Month Employment / Wage Record Comparison Check
  • Code 196 - Month 1 = Month 2 = Month 3 = Wage Record Count Check
  • Code 197 - Total Wages / Wage Record Wages Comparison Check
  • Conclusion
• Edit Scoring Function
• A-B-C List Prioritization Scheme​

Related Links

• EXPO/EARS Documentation Home