12 imt development introduction

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

IMT Development Introduction

This appendix provides a complete set of instructions for the development and maintenance of a State-specific extract program that will create an IMT File to load into the EXPO system. The format has remained virtually unchanged since 1997, when Version 5.0 of the EXPO/EARS system was released. However, some of the field definitions have been altered, and they may have been moved to other parts of the Micro File record, transferred to another file (usually the Micro Omni Auxiliary (MOA) File), or removed from the process completely.


This document was designed to assist States in the initial development of their IMT extract process "from scratch." It serves as a guide for setting the initial values of all IMT fields. There are typically two or three programs involved in this process.

  • The first (an initial Micro File build interface) would extract data from the State U-I data to form a six-quarter IMT file.
  • The second program would extract current quarter data (and any administrative changes) from the U-I Tax File, to provide quarterly updates to EXPO micro data through IMT records.
  • The third program, if requiring separate development, would bring in supplemental (late reporter and new account) data periodically throughout the quarter cycle. Some States can use the second program to perform subsequent extracts as well.


Since one of the requirements of the MicMac enhancement of Version 5 entailed updates to the prior quarter, at least one of the IMT data extraction programs will need to access Tax File data for the previous quarter's employment and wage data. This means a current quarter data extraction will also need to attach any prior quarter employment/wage updates in the same file. Otherwise, the only way to perform a batch update of back-quarter data will be to have an added program specifically for older quarter extractions (or running the single extraction program multiple times, once for each quarter). Since the two-quarter extract mandate extends to only a single extract during the quarter, the prior-quarter data need only to be accessed for the initial (usually the Job 001Q) extract.


Hyperlinks are embedded throughout this document. Two types of hyperlinks are in use. For the field ID’s (in titles above a field’s description), the hyperlink connects individual field names to the IMT record layout that appears at the end of this appendix. Hyperlinks appearing within the text of a description are references to other fields; these hyperlinks transfer to that other field’s description, rather than to the record layout table.


The record layout chart is the same as the table found in the Files Section of the EXPO system documentation, but doesn’t need to be opened separately (sometimes a time-consuming operation). These hyperlinks are available so you can see how the field fits into the record layout, the valid values, etc.


Related Links