Section 1 - EXPO/EARS Divisions
Revision as of 16:51, 11 July 2019 by MattSteadman (talk | contribs) (Text replacement - "[[start" to "[[EXPO_Documentation")
Contents
- 1 02 - EXPO System Overview
- 2 03 - EXPO Development Team Profiles
- 3 04 - Batch Job Processing
- 4 05 - CICS Screens
- 5 06 - File Record Layouts
- 6 07 - Appendix A - DMA Processing
- 7 08 - Appendix B - Miscellaneous System Tables
- 8 09 - Appendix C - VSAM Files & CICS Table Definitions
- 9 10 - Appendix D - Estimation Methods
- 10 11 - Appendix E - EXPO Editing Procedures
- 11 12 - Appendix F - IMT Development
- 12 12 - Appendix F - IMT Development
- 13 13 - Appendix G - IMAT File Development
- 14 14 - Appendix H - Parameter Descriptions
- 15 15 - Appendix I - Program Descriptions
- 16 16 - Appendix J - Glossary & Common Terms
02 - EXPO System Overview
- Exportable QCEW System (EXPO) General Overview
- User Procedures for EXPO Processing
- User Procedures for EARS Refiling
- EXPO Major System Files
- Exportable Annual Refiling System (EARS) Major Files
- Batch Jobs
- CICS On-Line Transactions
- QCEW Processing Timeline
- EARS Timeline
- Due Dates
03 - EXPO Development Team Profiles
04 - Batch Job Processing
- Introduction
- Micro Jobs
- Job ES2J001D - Extract, Edit, and Estimate (No Quarter Shift)
- Job ES2J001Q - Quarterly Extract (Shift Micro File Quarters)
- Job ES2J001R - Shift Micro File Quarters (No IMT, Edit, Estimate)
- Job ES2J001S - Extract and Estimate (No Edits - IMT Process Only)
- Job ES2J001X - Extract IMT Data Only (No Estimation, Edit, Etc.)
- Job ES2J002D - Micro Edit and Estimation (No New Data Extracted)
- Job ES2J002F - Micro Edit and Estimation for Future Quarter
- Job ES2J002S - Micro Estimation without Edits and Estimation Report
- Job ES2J003D - Multi Balance Report / Micro Edit Update
- Job ES2J003S - Multi Balance Report (Any Quarter) - No Micro Edit
- Job ES2J004D - Delinquent Multi Employer Report
- Job ES2J005D - Transaction File Purging of Old Data
- Job ES2J007C - Firm Listing and Summary Report - Data Sharing (CIPSEA-Compliant)
- Job ES2J007D - Firm Listing and Summary Report - No Data Sharing
- Job ES2J008D - Scored Error Report (Focused Edit Scoring)
- Job ES2J008S - Faster Scored Error Report (No Re-Editing)
- Job ES2J009D - Employment Change Report
- Job ES2J010D - General Purpose Mailing Labels
- Job ES2J011D - EQUI Deliverable Production
- Job ES2J011S - EQUI - Special Correction using Prior Backup
- Job ES2J012B - Print Blank MWR Forms
- Job ES2J012D - Print Multiple Worksite Report (MWR) Forms
- Job ES2J012E - Create File to Print MWR Forms Off-Site
- Job ES2J012F - Print Federal Single/Multi Worksite Forms
- Job ES2J012P - Create File for MWR Print Contractor
- Job ES2J012W - Print MWR-Web Solicitation Forms
- Job ES2J012X - Create Files for MWR-Web Solicitation Forms Offsite
- Job ES2J013D - Transfer EARS Changes to Micro File
- Job ES2J014D - Multi Master / Worksites Report
- Job ES2J015D - Predecessor/Successor Edits Report
- Job ES2J015S - Old (Obsolete) Predecessor/Successor Edit Report (Pre-Version 8.1)
- Job ES2J016D - Audit Trail Report
- Job ES2J017D - Code Change Report - Micro vs. Refiling File
- Job ES2J018D - Gross Errors (A-B-C List) Report
- Job ES2J019C - Size of Firm Report - for Data Sharing (CIPSEA-Compliant)
- Job ES2J019D - Size of Firm Report - No Data Sharing
- Job ES2J020C - Customized Micro Report - for Data Sharing (CIPSEA-Compliant)
- Job ES2J020D - Customized Micro Report - No Data Sharing
- Job ES2J021C - Single-Quarter EQUI File - for Data Sharing (CIPSEA-Compliant)
- Job ES2J021D - Single-Quarter EQUI File (724-Byte Format) - No Data Sharing
- Job ES2J021F - EQUI Subset Output for BLS Using 'SUBS' Group
- Job ES2J021O - Single-Quarter EQUI (1060-Byte Format) for OES Use
- Job ES2J021S - Single-Quarter EQUI (1166-Byte Format) without Data Sharing
- Job ES2J022D - Micro Narrative and Comment Codes Report
- Job ES2J023D - Micro File Status Report
- Job ES2J024D - Micro File Update from Old MWR File (350-Byte Format)
- Job ES2J024E - Micro File Update from EDI CENCO File
- Job ES2J024P - Micro File Update from MWR Print Contractor File
- Job ES2J025D - 13-Month Firm List
- Job ES2J026D - Restore Micro Data from Transaction File
- Job ES2J028D - Perform Micro Edits
- Job ES2J028S - Run Micro Edits on Back Quarters
- Job ES2J029D - Produce Micro Flash Report
- Job ES2J030D - Micro and Micro-Edit General Status Report
- Job ES2J031D - EQUI Preparatory Scored Edit (All EQUI Quarters)
- Job ES2J032D - Adjust NAICS Codes on Masters
- Job ES2J034C - Create Two Files for MLS Use - for Data Sharing (CIPSEA-Compliant)
- Job ES2J034D - Create Two Files for MLS Use - Not for Data Sharing
- Job ES2J035D - Load Geo-Code Data to Micro File
- Job ES2J035S - Compare Micro PLAs to IGT PLAs
- Job ES2J036D - Produce "Place Code" Report
- Job ES2J037D - Process MWR-Web Confirmed Registry File
- Job ES2J038D - Create MWR-Web Historical Data File
- Job ES2J039D - Update Micro File with MWR-Web Collected Data
- Job ES2J040D - Micro Selection Report - Not for Data Sharing
- Job ES2J042D - Special EQUI Production
- Job ES2J043D - Extract IMAT (Input Micro Auxiliary) Data Only
- Job ES2J044D - Large Imputation Spreadsheets
- Job ES2J047D - Produce MWR-Web Master File
- Utility & Wage-Data Batch Jobs
- Job ES2J050D - Build the Alpha Locator File
- Job ES2J051D - Build the Crosswalk Files
- Job ES2J052Q - Update File Counts for the ES2L Files Screen
- Job ES2J060D - Add/Replace a Quarter on the Wage Summary File
- Job ES2J060S - Add/Replace Quarter on Wage Summary File using Wage File
- Job ES2J061D - Perform Wage Summary Edits
- Job ES2J062D - Add a Quarter Pair to the Potential Pred/Succ File
- Job ES2J062S - Add a Quarter Pair to Potential P/S File using Wage File
- Job ES2J063D - Produce Report of Scored Potential Pred/Succ's
- Job ES2J084C - Create an IMT File from Micro and MOA Data
- Miscellaneous Utility Batch Jobs
- Miscellaneous Utility Batch Job Descriptions
- Macro Batch Jobs
- Job ES2J241D - Macro Quarters Rebuild / Crosswalks Rebuild
- Job ES2J242D - Run Integrated Edits and Rebuild Crosswalks
- Job ES2J243D - Purge/Archive Macro File Quarters
- Job ES2J244C - NAICS-Based Publication Report - for Data Sharing (CIPSEA-Compliant)
- Job ES2J244D - NAICS-Based Publication Report - No Data Sharing
- Job ES2J244R - State Data File Generation for Aggregation Tool (IADAT)
- Job ES2J245A - Annual Summary Reports - No Data Sharing
- Job ES2J245C - Annual Summary Reports - for Data Sharing (CIPSEA-Compliant)
- Job ES2J246C - Customized Macro Rollup Reports - for Data Sharing (CIPSEA-Compliant)
- Job ES2J246D - Customized Macro Rollup Reports - No Data Sharing
- Job ES2J246F - Macro Rollup for CES/QCEW Analysis
- Job ES2J247C - Produce ALMIS Version of Macro File - for Data Sharing (CIPSEA-Compliant)
- Job ES2J247D - Produce ALMIS Version of Macro File - No Data Sharing
- Job ES2J248D - NAICS-Based Full-Scale Publication Parameters Setup
- Job ES2J249D - Create Special Macro Deliverable File
- EARS Refiling Batch Jobs
- Job EARJ100A - Refiling File Build
- Job EARJ101D - Batch Update to Refiling File (From IRT)
- Job EARJ102D - Conduct Refiling File Edits
- Job EARJ105D - Single and Multi Refiling Forms for CARS
- Job EARJ106D - Prepare Survey Management Report (On Demand)
- Job EARJ106M - Prepare Survey Management Report/File Deliverable (Monthly)
- Job EARJ107D - Refiling Establishment List Report
- Job EARJ108D - Load TRS Response File to the Refiling File
- Job EARJ109D - Create Code Change Supplement (CCS) File
- Job EARJ110D - Produce Summary of Differences (SoD) Report
- Job EARJ111A - Create TRS Eligibility File and Report
- Job EARJ112D - Perform CCS Edits
- Job EARJ113D - Distribution of Refiling Report (by EIN, etc.)
- Job EARJ114D - Load CARS Data (for CARS States Only)
- Job EARJ115D - Non-Response Firm Listing
- Job EARJ116D - Refiling Audit Trail Report
- Job EARJ117D - Print NCA Refiling Forms from Micro File
- Job EARJ117E - Create Cartridge for Offsite NCA Form Printing
- Job EARJ118D - Produce CCS Master List
- Job EARJ119D - Unclassified Management Report and File
- Job EARJ120A - Process CARS Change-of-Address File
- Job EARJ121D - Update Micro Data from ARS-Web Collected Data
- Job EARJ122D - Insert Physical Address for CARS Accounts from Input File
- Job EARJ123D - Remove Physical Address for CARS Refiling Non-Response
- Job EARJ124D - Non-Respondent Firm List File
05 - CICS Screens
- CICS Screens Introduction
- EXPO CICS Screens
- ES2A - Labor Market Information (LMI) Menu
- ES2B - EXPO QCEW System Menu
- ES2C - Micro File Inquiry / Maintenance
- ES2D - Macro File Inquiry and Integrated Edit Review
- ES2E - Micro Edit Reconciliation
- ES2F - Selective Firm List Display
- ES2G - Predecessor/Successor Wage Record Search
- ES2H - On-line Master/Worksite Inquiry
- ES2I - Micro File Lock Facility
- ES2J - Common ABEND Routine
- ES2K - Common Ending Routine
- ES2L - Lookup File Inquiry and Maintenance
- ES2M - EXPO Internal Security Maintenance
- ES2N - Batch Job Parameter Entry
- ES2P - Transaction Files Review
- ES2R - Multi Worksite Report Entry Screen
- ES2S - Alpha Locator Inquiry
- ES2U - Publication Parameter File Maintenance
- ES2V - Establishing or Modifying Multiple Worksites
- ES2X - On-line Multi Change of Ownership for Selected Worksites
- ES2Y - Narrative Comments Entry
- ES2Z - Account Groups File Maintenance
- EARS CICS Transactions
- EARB - EARS Menu
- EARC - Refiling File Inquiry and Maintenance
- EARF - Refiling File Establishment List
- EARI - Refiling File Lock Utility
- EARL - Lookup File Inquiry and Maintenance
- EARN - Batch Job Parameter Entry Screen
- EARP - Refiling Transaction Data Review
- EARR - Mass Update of Refiling Data in Batches
06 - File Record Layouts
EARS Files
- Attempted Response Code File (EARARC)
- ARS-Web Input File (EARAWEB)
- CARS Load/Response File (EARCARL)
- Code Change Supplement File (EARCCS)
- Input Refiling Transaction (IRT) File (EARIRT)
- EARS Job Parameters File (Lookup File Subset) (EARJPRM)
- Refiling Master File (EARREF)
- Refiling Report Selection Parameters File (EARRESP (ES2RUP redef.))
- Refiling Data Output File (EARRFDT)
- Refiling Summary Management Report File (EARRSMR)
- Refiling Transactions File (EARRTRN)
- Summary of Differences File (EARSDIF)
- Selection for Mailing File (EARSELM)
- Survey Log File (Records in Lookup File) (EARSLOG/ES2LKUP)
- TRS Eligible File (EARTRS)
- TRS Load File (EARTRSL)
EXPO Files
- ALMIS Extract File (ES2ALMS)
- Second ALMIS Extract File (ES2ALM2)
- Third ALMIS Extract File (ES2ALM3)
- Alpha Locator File (ES2ALPH)
- Abbreviated Quarterly U-I Address File (ES2AQUI)
- Administrative Transaction File (ES2ATRN)
- Edit Processing Bookmark File (stored in Lookup) (ES2BKMK)
- Census Wage Deliverable New/Old Files (ES2CENN / ES2CENO)
- Enhanced Macro File (without field compression) (ES2EMAC)
- Enhanced Micro File (without field compression) (ES2EMIC)
- EQUI Predecessor/Successor Sub-File (ES2EQPS)
- Enhanced Quarterly U-I Address File (ES2EQUI)
- Version 8 Quarterly U-I Address File (ES2EQUI8)
- Employee Transfer Transaction File (ES2ETT)
- Account Groups File (ES2GRP)
- Input Geocoding Transaction File (ES2IGT)
- Input Micro Auxiliary Transaction File (ES2IMAT)
- Input Micro Transaction File (ES2IMT)
- Job Parameters File (ES2JPRM (ES2LKUP))
- Lookup File (ES2LKUP)
- Labels Temporary File (ES2LTMP)
- Macro File (ES2MAC)
- Macro Edit File (ES2MAED)
- Micro Sequential Data File (ES2MCDT)
- Micro Edit Cross-Reference File (ES2MEXR)
- Micro Archive File (ES2MIAR)
- Micro File (ES2MIC)
- Micro Edit File (ES2MIED)
- Micro-to-Macro Data Collection File (ES2MIMA)
- Micro-Selection Parameters File (ES2MISP (ES2RUP))
- Micro Worksite Summary File (ES2MIWS)
- First Mass Layoff Statistics (MLS) Output File (ES2MLS1)
- Second Mass Layoff Statistics (MLS) Output File (ES2MLS2)
- 15-Month Output Data (Job 025D) File) (ES2MO15)
- Micro Omni (or Omnifarious) Auxiliary File (ES2MOA)
- Micro Super-Selection Parameter File (ES2MSSP (ES2RUP))
- Micro-Omni-Aux Transaction File (ES2MTRN)
- MWR Web-Collected Data File (ES2MWCD)
- MWR Web-Collection Historical Data File (ES2MWHD)
- Multi Worksite Report (MWR) Data File (ES2MWR)
- Multi Worksite Report (MWR) Tape File (ES2MWRT)
- MWR Extended Tape File (ES2MWRX)
- Narrative Comment File (ES2NARC)
- Non-Classified Accounts Survey Summary Management File (ES2NCA)
- Predecessor / Successor Actual File (ES2PSA)
- Predecessor / Successor Notes File (ES2PSN)
- Predecessor / Successor Potential File (ES2PSP)
- Publication Parameter Header File (ES2PUB)
- Publication Selected Output File (ES2PUBF)
- Quarterly Publication Output File (ES2PUBQ)
- Quarterly Transaction File (ES2QTRN)
- Macro Rollup File (ES2RLUP)
- Roll-up Data Collection File (ES2ROLL)
- Roll-up Parameters File (ES2RUP)
- Internal Security File (ES2SECR)
- Size-of-Firm Selection Output File (ES2SIZE)
- Statewide Macro File (ES2SMAC)
- Standard U-I Extract Non-quarterly (ES2SUEN)
- Standard U-I Extract Quarterly Data File (ES2SUEQ)
- Summary Output File (from Job 007D) (ES2SUMM)
- Standard U-I Extract / Predecessor/Successor File (ES2SUPS)
- Wage Summary File (ES2WAGE)
- Wage File Creator File (ES2WFC)
- Wage File Creator – Matched Pairs File (ES2WFCM)
- Wage Data Temporary File (ES2WTMP)
- Statewide Macro-to-Micro Crosswalk File (ES2XWK2)
- County-based Macro-to-Micro Crosswalk File (ES2XWLK)
07 - Appendix A - DMA Processing
- DMA Service Center Logon
- Logging on to EXPO at DMA with Attachmate
- Changing Session Characteristics
- Sign-On Methods
- How to Get Reconnected
- Submitting a Job through C-List
- TSO Job Monitoring with IOF
- Printing Reports
- Snap a Report
- Using FileAid to View a File
- How to FTP a File Using Reflection Software
- Miscellaneous DMA Information
- Files Requiring FTP
- Contact Information
08 - Appendix B - Miscellaneous System Tables
- Miscellaneous System Tables Introduction
- Data Definitions
- Estimation Report Codes
- QCEW Micro-Edit Exception Codes
- Predecessor/Successor Errors
- Standard BLS QCEW Comment Codes
- Miscellaneous QCEW Codes
- EARS-Specific Field Values
- NAICS Definitions
- Definitions for Micro/Multi Balance Edit PK Values
- QMSA Definition and Maintenance
- Disclosure Masking Techniques
09 - Appendix C - VSAM Files & CICS Table Definitions
- Sample VSAM File Definitions
- Refiling File (EARREFDF)
- Refiling File (EARRTRDF)
- Alpha Locator File (ES2ALPDF)
- Administrative Transaction File (ES2ATRDF)
- Account Groups File (ES2GRPDF)
- Batch Job Parms File, EARS Lookup File, Micro File Quarter Locks File, Lookup Table File (ES2LKUDF)
- Macro File (ES2MACDF)
- Macro Edit File (ES2MAEDF)
- Micro Edit Cross Reference File (ES2MEXDF)
- Micro File (ES2MICDF)
- Micro Edit File (ES2MIEDF)
- Micro Omnifarious Auxiliary File (ES2MOADF)
- MOA Transaction File (ES2MTRDF)
- Narrative Comments File (ES2NARDF)
- Predecessor Successor Actual File (ES2PSADF)
- Predecessor Successor Notes File (ES2PSNDF)
- Predecessor Successor Potential File (ES2PSPDF)
- Publications Details File (ES2PUB)
- Quarterly Transaction File (ES2QTRDF)
- Macro Rollup Parm File, Refiling Report Selection Parm File, and Micro Selection Parm File (ES2RUPDF)
- Internal Security File (ES2SECDF)
- Statewide Macro File (ES2SMADF)
- Wage Summary File (ES2WAGDF)
- Statewide Macro-to-Micro Crosswalk File (ES2XW2DF)
- County-Based Macro-to-Micro Crosswalk File (ES2XWLDF)
- Sample File Control Table (FCT) Definitions
- Sample Program Control Table (PCT)
- Sample Processing Program Table (PPT)
- How to Compute VSAM File Space Requirements
- Sample State Computations
10 - Appendix D - Estimation Methods
- Introduction
- Initial Record Selection Process
- Quarter-Specific Estimation Selections
- Estimation Processing
- Subscripts and Field Names
- Total Wage Estimation
- Taxable Wage Estimation
- Contributions Estimation
- Employment Estimation
- Indicator Settings from Estimates
- Conclusion of the Estimation Process
11 - Appendix E - EXPO Editing Procedures
- 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
- Code 128 - Identical Monthly Employment Check
- Code 129 - Taxable / Total Wage Change Check
- Code 130 - Small Employment without Wages Check
- Code 131 - Small Wages without Employment Check
- 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
12 - Appendix F - IMT Development
- IMT Development Introduction
- The Input Micro Transaction (IMT) File
- SESA ID
- Check Digit
- Federal Employer Identification Number (EIN)
- Legal Name
- Trade Name
- Data Source Code (EDI Indicator)
- Special Indicator
- Agent Code
- New/Changed Physical Address Indicator
- Physical Location Address (PLA) Block Fields
- Unemployment-Insurance Address (UIA) Block Fields
- Mailing/Other Address (MOA) Block Fields
- Phone Number
- Facsimile (Fax) Machine Phone Number
- Field Lock Indicator
- Set-up Date
- Initial Liability Date
- End-of-Liability Date
- Reactivation Date
- Predecessor and Successor SESA ID’s
- ARS Response Code and Year
- ARS Verify Year
- Refiling Batch Number
- Refiling Old Codes
- Non-Classified Accounts (NCA) Response Code
- Maximum Report Unit Number (RUN)
- Current Employment Statistics (CES) Indicator
- Organization Type Code
- Administrative State Usage
- Future Quarter MWR Received Switch
- Current Quarter MWR Received Switch
- Wage Summary Quarter Indicator
- Quarterly Data Fields
- Quarterly Data Areas Defined
- Year/Quarter Field
- Status Code
- County FIPS Code
- Ownership Code
- NSTA Code
- SIC Code
- Type of Coverage (ToC) Code
- Sub-County Zone or Township Code
- NAICS Code
- Economic Code Change Indicator (ECCI)
- Auxiliary Code
- Multiple-Establishment Employer Indicator (MEEI) Code
- Editing Flag
- Estimation Flag
- Delinquency Flag
- Tax Rate
- First Month’s Employment
- First Month’s Employment Indicator
- Second Month’s Employment
- Second Month’s Employment Indicator
- Third Month’s Employment
- Third Month’s Employment Indicator
- Quarterly State Usage Field
- Total Wages
- Total Wage Indicator
- Taxable Wages
- Taxable Wage Indicator
- Contributions “Due”
- Contribution Indicator
- Comment Codes (up to three)
- IMT Record Layout
12 - Appendix F - IMT Development
- IMT Development Introduction
- The Input Micro Transaction (IMT) File
- SESA ID
- Check Digit
- Federal Employer Identification Number (EIN)
- Legal Name
- Trade Name
- Data Source Code (EDI Indicator)
- Special Indicator
- Agent Code
- New/Changed Physical Address Indicator
- Physical Location Address (PLA) Block Fields
- Unemployment-Insurance Address (UIA) Block Fields
- Mailing/Other Address (MOA) Block Fields
- Phone Number
- Facsimile (Fax) Machine Phone Number
- Field Lock Indicator
- Set-up Date
- Initial Liability Date
- End-of-Liability Date
- Reactivation Date
- Predecessor and Successor SESA ID’s
- ARS Response Code and Year
- ARS Verify Year
- Refiling Batch Number
- Refiling Old Codes
- Non-Classified Accounts (NCA) Response Code
- Maximum Report Unit Number (RUN)
- Current Employment Statistics (CES) Indicator
- Organization Type Code
- Administrative State Usage
- Future Quarter MWR Received Switch
- Current Quarter MWR Received Switch
- Wage Summary Quarter Indicator
- Quarterly Data Fields
- Quarterly Data Areas Defined
- Year/Quarter Field
- Status Code
- County FIPS Code
- Ownership Code
- NSTA Code
- SIC Code
- Type of Coverage (ToC) Code
- Sub-County Zone or Township Code
- NAICS Code
- Economic Code Change Indicator (ECCI)
- Auxiliary Code
- Multiple-Establishment Employer Indicator (MEEI) Code
- Editing Flag
- Estimation Flag
- Delinquency Flag
- Tax Rate
- First Month’s Employment
- First Month’s Employment Indicator
- Second Month’s Employment
- Second Month’s Employment Indicator
- Third Month’s Employment
- Third Month’s Employment Indicator
- Quarterly State Usage Field
- Total Wages
- Total Wage Indicator
- Taxable Wages
- Taxable Wage Indicator
- Contributions “Due”
- Contribution Indicator
- Comment Codes (up to three)
- IMT Record Layout
13 - Appendix G - IMAT File Development
- IMAT File Development Guide Introduction
- The Input Micro Auxiliary Transaction (IMAT) File
- SESA ID
- IMAT Address Block (for MOA (“A”) Record Type)
- Contact Information (for Contact (“C”) Record Type
- Email and Fax Phone (for Email (“E”) Record Type)
- Website Address (for Website (“W”) Record Type)
- IMAT Record Layout
14 - Appendix H - Parameter Descriptions
- Introduction
- Jobs 001D, 001S, 001X - IMT Updates, Estimation, Editing - First Screen
- Jobs 001Q, 001R - Quarter Shift, IMT Updates, Estimation, Editing, etc. - First Screen
- Jobs 002D, 002F, 002S - Estimation and Editing
- Job 003D - Multi-Balance Editing
- Job 003S - Back-Quarter Multi-Balance Editing
- Job 004D - Multi-Family Delinquency Report
- Job 005D - Purge Older Transaction File Records
- Jobs 007D, 007C - Firm List and Summary Report Production
- Job 008D - Focused Edit Scoring ("FESTER") Reporting
- Job 008S - Streamlined Focused Edit Scoring ("FESTER") Report
- Job 009D - Quarterly Employment/Wage Shift Report
- Job 010D - Mailing Label Printing
- Jobs 011D and 011S - Produce EQUI Deliverable
- Jobs 012D, 012B, 012E - Produce Multiple Worksite Report (MWR) Forms, Blank Forms, Print Data Files
- Job 012F - Produce Federal Multiple Worksite Report (MWR) Forms
- Jobs 012W, 012X - Produce Multiple Worksite Report (MWR) Forms for Web-Based Response Solicitation
- Job 013D - Transfer Refiling File Changes to Micro File
- Job 014D - Produce General Multi-Family Report
- Jobs 015D and 015S - Perform Predecessor/Successor Edits
- Job 016D - Produce an Audit Trail Report
- Job 017D - EARS and Micro Quarterly Code Comparison
- Job 018D - Produce "Gross" Errors Report
- Jobs 019D, 019C - Produce a Size-of-Firm Report
- Jobs 020D, 020C - Produce Micro Selection Reports / Files
- Jobs 021D, 021C, 021O, 021S - Produce Single-Quarter EQUI File (for CES)
- Job 021F - Produce Federal EQUI File (Single-Quarter or Subset)
- Job 022D - Produce Micro Comments Report
- Job 023D - Produce Micro File Status Report
- Jobs 024D, 024E - MWR/EDIC-MWR Tape Update to Micro File
- Job 025D - Produce 13-Month Firm List Report (or 15-Month File)
- Jobs 026D, 026U - Micro File Restore from Transaction File Data
- Job 028D - Perform Micro Edits (Current and Prior Quarter)
- Job 028S - Perform Micro Edits for Back Quarters
- Job 029D - Produce the BLS "Flash" Report
- Job 030D - Produce Micro Edit Status Report
- Job 031D - Produce EQUI Edit Scoring Report
- Job 032D - Assign Prevalent NAICS Code to Master
- Job 034D - Produce the MLS Files and Report
- Job 035D - Process IGT Data into Micro File
- Job 036D - Produce Place-Code Data Aggregation Report
- Job 037D - Collect Micro Data for Eligible MWR Web Candidates
- Job 039D - Send Micro Data to BLS for MWR Web Families
- Job 040D - Produce Micro Super-Selection Reports or Files
- Job 042D - Produce an EQUI Change Report
- Job 047D - Produce an MWR Web Master File
- Job 060D - Add / Replace a Wage Summary File Quarter
- Job 061D - Perform Wage Summary Edits
- Job 062D - Add ETT Data to the Employment Transfer File
- Job 063D - Predecessor / Successor Linkage Scoring
- Job 084C - Load the IMT and IMAT Data from the Micro and MOA Files
- Job EARJ101D - Process Input Refiling Transaction (IRT) File
- Job 102D - Perform Refiling Batch Edits
- Job 107D - Produce Refiling Selection Reports
- Job 108D - Load TRS Batch Data into Refiling File
- Job 116D - Produce Refiling Audit Trail Report
- Jobs 117D, 117E - NCA Refiling Forms Mailing
- Job 118D - Produce the Code-Change Summary Master List
- Job 120A - Apply USPS COA Updates for CARS Accounts
- Job 121D - Load the ARS-Web Data File
- Job 124D - Load the Non-Response File
- Job 241D - Rebuild Macro and Crosswalk Files
- Job 242D - Rebuild Macro and Perform Integrated Edits
- Job 243D - Macro Archival and Purging Processes
- Jobs 244D, 244C - Produce Macro-Based Publication Report / File
- Jobs 245A, 245C - Produce a Macro Annual Summary Report
- Jobs 246D, 246C - Produce Macro Roll-Up Reports / Files
- Job 246F - Collect Eight-Quarter CES/CEW Comparison Data
- Jobs 247D, 247C - Produce ALMIS Data Output
- Job 248D - Populate a Publication Parameters Set
- Job 249D - Produce Specialized Macro "Deliverable"
15 - Appendix I - Program Descriptions
- Introduction
- EARBP01
- EARCP01
- EARFP01
- EARIP01
- EARLP01
- EARNP01
- EARNP03
- EARPP01
- EARPP02
- EARRF00
- EARRF01
- EARRF02
- EARRF03
- EARRF04
- EARRF05
- EARRF06
- EARRF07
- EARRF08
- EARRF10 - SoD Production Program
- EARRF11
- EARRF12
- EARRF13
- EARRF14
- EARRF15
- EARRF16
- EARRF17
- EARRF18
- EARRF19
- EARRF20
- EARRF21
- EARRF22
- EARRF23
- EARRF24
- EARRP01
- EARRP02
- EARUT02
- EARUT03
- EARUT05
- EARUT07
- EARUT08
- EARUT09
- EARUT10
- EARUT12
- EARUT14
- EARUT15
- EARUT16
- EARUT17
- EARUT18
- EARUT19
- EARUT20
- EARUT24
- ES2AP01
- ES2BP01
- ES2CP01
- ES2CP02
- ES2CP03
- ES2CP04
- ES2DP01
- ES2EP01
- ES2FP01
- ES2GP01
- ES2GP02
- ES2HP01
- ES2IBLD
- ES2IP01
- ES2JP01
- ES2KP01
- ES2LP01
- ES2MA01
- ES2MA02
- ES2MA03
- ES2MA04
- ES2MA05
- ES2MA06
- ES2MA09
- ES2MA10
- ES2MA11
- ES2MI01 - IMT Interface Program
- ES2MI02 - Micro Estimation Program
- ES2MI03 - Multi-Worksite Family Balance Processing Program
- ES2MI04
- ES2MI05
- ES2MI07
- ES2MI08
- ES2MI09
- ES2MI10
- ES2MI11
- ES2MI12
- ES2MI12P
- ES2MI13
- ES2MI14
- ES2MI15 - Predecessor/Successor Editing Program
- ES2MI15S
- ES2MI16
- ES2MI17
- ES2MI18
- ES2MI19
- ES2MI20
- ES2MI21
- ES2MI22
- ES2MI23
- ES2MI24
- ES2MI25
- ES2MI26
- ES2MI28 - Micro and Intregrated Edit Processing Program
- ES2MI29
- ES2MI30
- ES2MI31
- ES2MI32
- ES2MI34
- ES2MI35
- ES2MI36 - Place Code Aggregation Sector Reports Program
- ES2MI37
- ES2MI38
- ES2MI39
- ES2MI40
- ES2MI41
- ES2MI42
- ES2MI43
- ES2MI44
- ES2MI47
- ES2MI48
- ES2MI49
- ES2MP01
- ES2MP02 - User Security Access Verification Program
- ES2NP01
- ES2NP02
- ES2NP03
- ES2NP04
- ES2NP05
- ES2PP01
- ES2RP01
- ES2SIMT
- ES2SP01
- ES2UP01
- ES2UT01 - Worksite Summarization Program
- ES2UT02 - Estimation Report Printing Program
- ES2UT03
- ES2UT04 - Crosswalk Data Collection Program
- ES2UT05
- ES2UT06
- ES2UT07
- ES2UT08 - Alpha Locator File Creation Program
- ES2UT09
- ES2UT10
- ES2UT12
- ES2UT13
- ES2UT14
- ES2UT15
- ES2UT16
- ES2UT17
- ES2UT17S
- ES2UT18
- ES2UT19 - Parameter Reformatting Program
- ES2UT20
- ES2UT22 - Quarter-Shifting Program
- ES2UT23
- ES2UT24
- ES2UT25 - CCS File Production Program
- ES2UT26
- ES2UT27
- ES2UT28
- ES2UT29
- ES2UT30
- ES2UT31
- ES2UT32
- ES2UT33
- ES2UT34
- ES2UT36
- ES2UT37
- ES2UT38
- ES2UT39
- ES2UT40
- ES2UT41
- ES2UT41A
- ES2UT42
- ES2UT43
- ES2UT44
- ES2UT45
- ES2UT46
- ES2UT47
- ES2UT48
- ES2UT49
- ES2UT50
- ES2UT51
- ES2UT51A
- ES2UT52
- ES2UT53
- ES2UT55
- ES2UT56
- ES2UT57
- ES2UT58
- ES2UT59
- ES2UT60
- ES2UT61
- ES2UT62
- ES2UT63
- ES2UT64
- ES2UT65
- ES2UT66
- ES2UT67
- ES2UT68
- ES2UT69
- ES2VP01
- ES2VP02
- ES2WA02 - Wage Summary Update/Merge Program
- ES2WA03 - Wage Data Editing Program
- ES2WA04
- ES2WA05
- ES2WA07
- ES2WA08
- ES2WA09
- ES2WA10
- ES2WA11
- ES2XP01
- ES2YP01
- ES2ZP01
16 - Appendix J - Glossary & Common Terms
- AAMC
- ACES
- Advanced Release
- Agent
- ALMIS
- AME
- AQW
- ARCS
- ARS
- ASCII
- AWW
- BEA
- Benchmark
- Birth
- BLS
- BLS-Washington
- BLS-790
- Bureau of the Census
- Business Cycle
- CARS
- CBSA
- CCS
- CENCO
- Census
- Census Block
- Census Tract
- Centroid
- CES
- Current Employment Statistics (CES) Survey
- CICS
- CIPSEA
- CMI
- C-O-N
- Core
- Covered Employment
- CPI
- CPS
- CSA
- CSV
- COOP
- DASLT
- DBA
- DBES
- DDDP
- Deaths
- Deliverable
- Disaggregate
- Disclose or Disclosure
- DLFS
- DMA
- DOL
- DSP
- EARS
- EBCDIC
- ECC
- ECCI
- Economic Indicator
- EDI
- EIN
- Embargoed Data
- Employment Interchange Measure
- ENZRU
- EOL
- EQUI
- ES-202
- Establishment
- Estimate
- Estimating Cell
- ETA
- ETT
- EUS
- EUSWeb
- EXPO
- EXPO-202
- Extrapolate
- Federal Reserve Board (Fed)
- Federal/State Cooperative Programs
- FEIN
- FESTER
- FIPS
- Firms
- FTP
- FUTA
- FY
- GBF
- GDG
- GDP
- GDPS
- GEO
- GIS
- IBLD
- IDCF
- IGT
- IID
- IMAT
- Imputation
- IMT
- Industry
- IOF
- IP
- iQ
- IRT
- ISIC
- JCL
- JOLTS
- Labor Dispute
- LABSTAT
- LAUS
- LDB
- LED
- LEHD
- LMA
- LMI
- LMI Cooperative Agreement
- LTIP
- Macro Data
- Master Record
- Mean
- MED
- MEEI
- MEXR
- Micro Data
- Micropolitan Statistical Area
- MLS
- MOA
- Moving Average
- MSA
- MSSP
- Multi-Establishment
- MWR
- MWRweb
- NAFTA
- NAICS
- NCA
- NCOA
- NECC
- N-O
- Nonresponsive
- NSTA
- Numbered Memoranda
- NVM
- NVS
- OES
- OEUS
- OFO
- OMB
- O-N-C
- OOB
- OP
- Optimum Allocation
- OTSP
- Parent Organization or Company
- Parm
- PCT
- PEO
- PLA
- PPI
- PPT
- Pre-Release Economic Data
- Program Offices
- Project Offices
- PS
- PSA
- PSN
- PSP
- QCEW
- QCR
- QMSA
- QUEST
- RACF
- Reference Date
- Regional Office
- Reporting Unit
- Respondent
- RFEW
- RO
- RUD
- RUN
- Sample
- Sample Survey
- SDF
- Seasonal Adjustment
- Series Break
- SESA ID
- SIC
- SMD
- SMR
- SMS
- SoD
- SSMR
- Statistical Activities
- Statistical Purposes
- Status Determination Form
- STIP
- Strike
- Successor
- SUE
- Survey Design
- SWA
- TC,TOCS
- TDE
- Time Series
- TQW
- Trend
- TRS
- TSO
- UCFE
- UDB
- UI
- UIA
- UIAN
- Universe
- VSAM
- VTOC
- Wage Records
- WIC
- WIN-202
- YRQ
Related Links