06 ​​input micro auxiliary transaction file es2imat

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

Input Micro Auxiliary Transaction File (ES2IMAT)

ES2IMAT - Length 327 - Revised 9/10/2004

​Columns​

LenKeyTypeCOBOL Field NameDescription & Notes
11515KeyCharIMAT-SESA-IDState Employment Security Agency Identification Number (U-I account + RUN)
11010RKeyCharIMAT-ACCTU-I Account number, right-justified with leading zeroes
11155RKeyNumIMAT-RPT-UNITU-I Reporting unit number (RUN) value; '00000' = Single or multi-worksite master; '00001' – '99999' = Worksite sub-units
16127112 CharIMAT-ADDRESSMailing / other address block (to be stored in "A" type record of MOA File), broken out as detailed below
16161R CharIMAT-ADDR-TYPEM/O address type code ('1' = Physical, '2' = Mailing, '3' = Corporate, '9' = Unknown
175135R CharIMAT-ADDRESS1M/O street address - first line
528635R CharIMAT-ADDRESS2M/O street address - second line
8711630R CharIMAT-CITYMOA city
1171182R CharIMAT-STATEMOA state postal abbreviation
119127

9R

 CharIMAT-ZIPFull 9-digit MOA zip code
1191235R CharIMAT-ZIP-5Standard 5-digit MOA zip code
1241274R CharIMAT-ZIP-4MOA Zip+4 expansion
12819770 CharIMAT-CONTACTInformation regarding contact person (stored in the "C" type record of the MOA File); sub-divided below
12816235R CharIMAT-CONTACT-NAMEName of contact person
16319735R CharIMAT-CONTACT-TITLEJob title of contact person
19826770 CharIMAT-EMAILCombined e-mail and fax phone number information, used in "E" type record of the MOA File; broken out into the detail shown below
19825760R CharIMAT-EMAIL-ADDRESSE-mail address used to contact the employer; can store lower-case characters
25826710R CharIMAT-FAX-PHONEPhone number of employer's facsimile machine that can be used for contact form or inquiry transmission
2582603R CharIMAT-FAX-AREAArea code portion of fax phone number
2612633R CharIMAT-FAX-EXCHANGEExchange portion of fax phone number
2642674R CharIMAT-FAX-SUFFIXSuffix portion of fax phone number
26832760 CharIMAT-WEBSITE-ADDRESSEmployer's website address for identifying QCEW-related news items; stored in the "W" type record in the MOA File (also referred to as "IMAT-WEBSITE")

​​​​​Input Micro Auxiliary Transaction File​

Data Set Name:                   WS.ES202.IMAT.FILE

Service Center DSN:           YBUssX.A145.IMAT.FILE, ('ss' = State FIPS code)

Type of File:                         Sequential

File Layout:                          ES2IMAT

The Input Micro Auxiliary Transaction (or IMAT) File is produced by State-specific data extraction programs.  It parallels the actions of IMT updates, but applies changes to the Micro Omni Auxiliary (MOA) File, rather than to the Micro File.  Although the MOA File carries several different record types, a single IMAT record can update most of them simultaneously. In the same manner as IMT updates, any data that are to remain unchanged on the MOA File should appear as low-values (binary zeroes) in the IMAT fields.  If one or more of the sections listed above are set to all spaces, it signals that that record is to be removed from the MOA File (such as the deletion of the mailing/other address or the contact information, etc.  As such, this file can cause a great deal of trouble if the contents are not checked before the first IMAT run.  The State development of an IMAT File should be coordinated with the Utah staff to ensure that there will not be a large-scale problem in data removal.

​IMAT updates are performed by Job 043D.  The file will generally not be needed for further retention after this job has run. ​ ​ ​ ​ ​


Related Links