Difference between revisions of "06 input micro transaction file es2imt"
m (1 revision imported) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
Line 9: | Line 9: | ||
* [[06_job_parameters_file_es2jprm_es2lkup|Job Parameters File (ES2JPRM (ES2LKUP))]] | * [[06_job_parameters_file_es2jprm_es2lkup|Job Parameters File (ES2JPRM (ES2LKUP))]] | ||
* [[06_file_record_layouts|File Record Layouts Table of Contents]] | * [[06_file_record_layouts|File Record Layouts Table of Contents]] | ||
− | * [[ | + | * [[EXPO_Documentation|EXPO/EARS Documentation Home]] |
Latest revision as of 16:44, 11 July 2019
Input Micro Transaction File (ES2IMT)
ES2IMT - Length 1364 - Revised 1/30/2019
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 15 | 15 | Key | Char | IMT-SESA-ID | State Employment Security Agency Identification Number (U-I account + RUN) |
1 | 10 | 10R | Key | Char | IMT-ACCT | U-I Account number, right-justified with leading zeroes |
11 | 15 | 5R | Key | Char | IMT-RPT-UNIT | U-I Reporting unit number (RUN) value; '00000' = Single or multi-worksite master; '00001' – '99999' = Worksite sub-units |
16 | 16 | 1 | Char | IMT-CK-DIGIT | Optional account number check digit (zero or low-values if not used); numerics valid; Note: For all IMT fields other than key elements, low-values denotes no change for existing accounts, or allows program to set default values on new accounts | |
17 | 25 | 9 | Char | IMT-EIN | Federal employer identification number (EIN) | |
26 | 60 | 35 | Char | IMT-LEGAL-NAME | Employer legal or corporate name | |
61 | 95 | 35 | Char | IMT-TRADE-NAME | Trade name (or doing-business-as (DBA) name | |
96 | 96 | 1 | Char | IMT-DATA-SOURCE | Source code for origination of account data; blank = Non-EDI account, 'C' = EDI employer with limited edits for EXPO; 'E' = EDI employer with data fully editable; 'M' = MWR web-collected data; 'Q' = QCR data collected from the web; 'S' = State media data; 'X' = Former EDI participant no longer participating; applied to the newest quarter represented in the IMT record when transferred to the Micro File | |
97 | 97 | 1 | Char | IMT-SPECIAL-IND | Special account classification code; blank = Standard account, ‘L’ = Professional Employee Organization (PEO, aka Employee Leasing company), ‘T’ = Indian Tribal Council; ‘M’ = Cannabis supplier; ‘Y’ = Combination PEO and Cannabis; ‘Z’ = Combination Indian Tribal and Cannabis | |
98 | 101 | 4 | Char | IMT-AGENT-CODE | State-defined 4-digit agent code (used for payroll service or similar agency); applied to the newest IMT quarterly data | |
102 | 248 | 147 | Char | IMT-PHYS-LOC-ADDRESS | Physical location address block; fields broken out below. | |
102 | 102 | 1R | Char | IMT-NEW-CHNGD-ADDR-IND | New or changed physical address switch; 'Y' = New or modified physical address | |
103 | 137 | 35R | Char | IMT-PL-ADDRESS | Employer physical location address street address | |
138 | 172 | 35R | Char | IMT-PL-ADDRESS2 | Second line of employer physical location address | |
173 | 207 | 35R | Char | IMT-RPT-UNIT-DESCR | Reporting unit description (distinguishes worksites in terms recognized by employer) | |
208 | 237 | 30R | Char | IMT-PL-CITY | Physical location city | |
238 | 239 | 2R | Char | IMT-PL-STATE | Physical location state code | |
240 | 248 | 9R | Char | IMT-PL-ZIP | Physical location full 9-digit zip code | |
240 | 244 | 5R | Char | IMT-PL-ZIP-5 | Standard 5-digit physical location zip code | |
245 | 248 | 4R | Char | IMT-PL-ZIP-4 | Physical location Zip+4 extension | |
249 | 396 | 148 | Char | IMT-UI-TAX-ADDRESS | Unemployment Insurance address contents, broken out as shown below | |
249 | 249 | 1R | Char | IMT-UI-ADDR-TYPE | U-I address type code (used internally, but not sent on EQUI); '1' = Physical address, '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown/unverified addr | |
250 | 250 | 1R | Char | IMT-MAIL-CODE | Mailing indicator code; blank = Mail every quarter, 'F' = Mail first quarter only (translated to '1' in Micro File), 'M' = Mail every quarter (translated to 'Y' in Micro File), 'N' = Do not mail; '1' = Mail first calendar quarter only; '2' = Mail second calendar quarter only; '3' = Mail third calendar quarter only; '4' = Mail fourth calendar quarter only | |
251 | 285 | 35R | Char | IMT-ATTN-NAME | Attention or contact name field for 'ATTN:', 'C/O', etc. | |
286 | 320 | 35R | Char | IMT-UI-ADDRESS | First street address line of the U-I tax address (normal mailing address) | |
321 | 355 | 35R | Char | IMT-UI-ADDRESS2 | Second U-I street address line | |
356 | 385 | 30R | Char | IMT-UI-CITY | U-I address city | |
386 | 387 | 2R | Char | IMT-UI-STATE | U-I address state postal abbreviation | |
388 | 396 | 9R | Char | IMT-UI-ZIP | U-I address full 9-digit zip code | |
388 | 392 | 5R | Char | IMT-UI-ZIP-5 | U-I address standard 5-digit zip code | |
393 | 396 | 4R | Char | IMT-UI-ZIP-4 | U-I address Zip+4 extension | |
397 | 508 | 112 | Char | IMT-MAILING-OTHER-ADDRESS | Group-level mailing/other address area, detailed below | |
397 | 431 | 35R | Char | IMT-MO-ADDRESS | First line of mailing/other street address | |
432 | 466 | 35R | Char | IMT-MO-ADDRESS2 | Second line of mailing/other street address | |
467 | 496 | 30R | Char | IMT-MO-CITY | Mailing/other address city | |
497 | 498 | 2R | Char | IMT-MO-STATE | Mailing/other address state postal abbreviation | |
499 | 507 | 9R | Char | IMT-MO-ZIP | Mailing/other address full 9-digit zip code | |
409 | 503 | 5R | Char | IMT-MO-ZIP-5 | 5-digit standard mailing/other address zip code | |
504 | 507 | 4R | Char | IMT-MO-ZIP-4 | Mailing/other address Zip+4 extension | |
508 | 508 | 1R | Char | IMT-MO-ADDR-TYPE | Mailing/other address type code ('1' = Physical address, '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown or unverified type of address) | |
509 | 518 | 10 | Char | IMT-PHONE-NUM | Group-level phone number identifier, sub-defined below | |
509 | 511 | 3R | Char | IMT-AREA | Phone number area code (blank if phone number or area code is unknown) | |
512 | 518 | 7R | Char | IMT-PHONE | Phone number (blank if unknown) | |
519 | 523 | 5 | Char | IMT-PHONE-EXT | Phone number extension (blank if missing or unused) | |
524 | 533 | 10 | Char | IMT-FAX-PHONE-NUM | Group-level facsimile machine phone number; sub-defined below | |
524 | 526 | 3R | Char | IMT-FAX-AREA | Area code for facsimile machine phone number | |
527 | 533 | 7R | Char | IMT-FAX-PHONE | Facsimile machine phone number | |
534 | 535 | 2 | Num | IMT-FIELD-LOCK | Multi-field batch update lockout indicator; value is the sum of the following individual field lock values: 00 = No fields locked to update; 01 = Physical address locked; 02 = Mailing address locked; 04 = Legal name locked; 08 = Trade name locked; 16 = Phone number locked; 32 = Attention name locked | |
536 | 543 | 8 | Char | IMT-SETUP-DATE | Date on which account was established on the Micro File (or the U-I Tax File; yyyymmdd format) | |
544 | 551 | 8 | Char | IMT-INIT-LIAB-DATE | Date of initial liability or worksite effective date (yyyymmdd format) | |
552 | 559 | 8 | Char | IMT-END-LIAB-DATE | End-of-liability (termination) date (yyyymmdd format) | |
560 | 567 | 8 | Char | IMT-REACT-DATE | Date of reactivation (yyyymmdd format) | |
568 | 582 | 15 | Char | IMT-PRED-SESA-ID | Grouped predecessor U-I account number and RUN | |
568 | 577 | 10R | Char | IMT-PRED-ACCT | Primary predecessor U-I account number; blank = No predecessor | |
578 | 582 | 5R | Char | IMT-PRED-RPT-UNIT | Primary predecessor U-I reporting unit number (RUN) | |
583 | 597 | 15 | Char | IMT-SUCC-SESA-ID | Grouped successor U-I account number and RUN | |
583 | 592 | 10R | Char | IMT-SUCC-ACCT | Primary successor U-I account number; blank = No successor | |
593 | 597 | 5R | Char | IMT-SUCC-RPT-UNIT | Primary successor U-I reporting unit number (RUN) | |
598 | 603 | 6 | Char | IMT-ARS-RESP-CD-YR | Group-level annual refiling survey (ARS) response code and refiling year | |
598 | 599 | 2R | Char | IMT-ARS-RESP-CODE | Refiling response code from Refiling File; blank = never selected for refiling survey | |
600 | 603 | 4R | Char | IMT-REFILE-YEAR | Most recent refiling year; blank = never selected for refiling survey or no response | |
604 | 607 | 4 | Char | IMT-VERIFY-YEAR | Most recent refiling year with a usable response code (41, 42, 46, or 50) | |
608 | 608 | 1 | Char | FILLER | space | |
609 | 612 | 4 | Char | IMT-EARS-BATCH-NUM | Batch number used for most recent refiling data entry with EARS system | |
613 | 635 | 23 | Char | IMT-OLD-CODES | Group-level identifier for pre-refiling code values (county, NAICS, etc.), shown below; these are compared to first calendar quarter codes to create code change supplement (CCS) records, from which Summary of Difference (SoD) records are produced; these are used to explain some first-quarter macro edit exceptions | |
613 | 615 | 3R | Char | IMT-OLD-CNTY | FIPS county code from beginning of refiling cycle | |
616 | 616 | 1R | Char | IMT-OLD-OWN | Most recent pre-refiling ownership code ('1' = Federal government, '2' = State government, '3' = Local government, '5' = Private industry) | |
617 | 620 | 4R | Char | FILLER | spaces | |
621 | 623 | 3R | Char | IMT-OLD-TOWN | Most recent pre-refiling New England township code; blank in other states | |
624 | 629 | 6R | Char | FILLER | spaces | |
630 | 635 | 6R | Char | IMT-OLD-NAICS | Most recent pre-refiling NAICS code | |
636 | 637 | 2 | Char | IMT-NCA-RC | Response code for non-classified establishment; may not be developed in most states' extract process | |
638 | 641 | 4 | Char | FILLER | spaces | |
642 | 646 | 5 | Char | IMT-MAX-RPT-UNIT | Largest RUN encountered so far (rarely used in IMT updates; interpreted on Micro) | |
647 | 647 | 1 | Char | IMT-CES | Indicator showing CES participation; blank = non-CES account, 'C' = CES reporter | |
648 | 648 | 1 | Char | IMT-ORG-TYPE | Private ownership organization type code; 'C' = Corporation, 'I' = Individual proprietorship, 'O' = Other organization, 'P' = Partnership, blank = Unknown / non-private | |
649 | 683 | 35 | Char | IMT-STATE-USAGE | Free-form administrative state usage area for auxiliary use by the state, not by EXPO | |
684 | 684 | 1 | Char | IMT-MWR-Q1-RCPT-SW | Flag denoting receipt of MWR form for future quarter (masters only); 'Y' = Future quarter MWR has been received (data not necessarily entered yet) | |
685 | 685 | 1 | Char | IMT-MWR-Q2-RCPT-SW | Flag denoting current quarter MWR form receipt for masters; 'Y' = MWR received | |
686 | 686 | 1 | Char | IMT-WAGE-IND | Indicator showing most recent quarter on Wage Summary File (not used in IMT data) | |
687 | 799 | 113 | Char | IMT-QTR-DATA(1) | Data for most recent quarter on the IMT record, sub-defined below | |
687 | 691 | 5R | Char | IMTQ-YRQ(1) | Most recent year/quarter (yyyyq format); Note: If year/quarter doesn't match IMT processing year/quarter parm (Job 01D, etc.), record will be skipped; if numeric year/ quarter found in first IMT record that has mismatch, it will ABEND the IMT process | |
687 | 690 | 4R | Char | IMTQ-YEAR(1) | Most recent IMT data's year | |
691 | 691 | 1R | Char | IMTQ-QTR(1) | Most recent IMT data's quarter (1, 2, 3, or 4) | |
692 | 692 | 1R | Char | IMTQ-STATUS(1) | Activity status code (newest quarter); '1' = Active, '2' = Inactive, '9' = Pending | |
693 | 695 | 3R | Char | IMTQ-CNTY(1) | FIPS county code (newest quarter (as with all remaining fields listed below)) | |
696 | 697 | 2R | Char | IMTQ-OWNER(1) | Ownership code; '10' = Federal government, '20' = State government, '30' = Local government, '50' – '59' = Private ownership | |
696 | 696 | 1R | Char | IMTQ-OWN1(1) | High-order ownership digit (1, 2, 3, or 5) | |
698 | 703 | 6R | Char | IMTQ-NSTA(1) | (Obsolete) North American Industry Classification System (NAICS) code with an SIC Treatment of Auxiliary Establishments; not processed, except that when the NSTA is specified, while the NAICS is left blank, it will be interpreted as a NAICS code | |
704 | 707 | 4R | Char | IMTQ-SIC(1) | Standard Industrial Classification (SIC) code | |
708 | 708 | 1R | Char | IMTQ-TYPE-COV(1) | Type of coverage; '0' = Experience-rated, '1' = Reimbursable, '2' = Experience-rated with employee contribution, '3' = Reimbursable with employee contribution, '8' = Non-covered (non-subject), '9' = Federal employer | |
709 | 712 | 4R | Char | IMTQ-ZONE(1) | Sub-county area (township or zone) | |
709 | 711 | 3R | Char | IMTQ-TOWN(1) | Township code (New England states and New Jersey) | |
713 | 718 | 6R | Char | IMTQ-NAICS(1) | NAICS code | |
719 | 719 | 1R | Char | IMTQ-AUX(1) | Obsolete; had identified the auxiliary code: no longer used | |
720 | 721 | 2R | Num | IMTQ-ECCI(1) | Economic code change indicator, showing economically-based code changes, summed from the following values: 00 = No economic code changes; 01 = Economic township change; 04 = Economic ownership change; 08 = Economic county change; 32 = Economic NAICS change; possible values range from 00 through 63; since '02' and '16' have been removed, however (formerly for SIC and NSTA economic code changes, respectively), not all of these values are possible for processing ('02', '06', '10', '14', '16'-'31', '34', '38', '42', '46', '48'-'63' represent invalid combinations) | |
722 | 722 | 1R | Char | FILLER | space | |
723 | 723 | 1R | Char | IMTQ-MEEI(1) | Multiple Establishment Employer Identifier (MEEI) code; '1' = Single account, '2' = Multi master account, '3' = Worksite, '4' = Known multi refusing breakout report (or presolicitation worksite in pending status), '5' = Composite (multiple location) worksite, '6' = Multi master treated as a single (not broken out) due to few people | |
724 | 724 | 1R | Char | IMTQ-EDIT-FLAG(1) | Edit flag (not used in IMT processing) | |
725 | 725 | 1R | Char | IMTQ-EST-FLAG(1) | Estimation flag (not used in IMT processing) | |
726 | 726 | 1R | Char | IMTQ-DELQ-FLAG(1) | Delinquency flag (not used in IMT processing) | |
727 | 727 | 1R | Char | FILLER | space | |
728 | 732 | 5R | Num | IMTQ-TAX-RATE(1) | Firm's tax rate, given in 100,000ths (converted in processing to 1000ths of a percent); e.g., 2 5/8% would appear as 02625 (2.625%) | |
733 | 738 | 6R | Num | IMTQ-M1-EMPL(1) | First month's employment for the quarter | |
739 | 739 | 1R | Char | IMTQ-M1-IND(1) | Month 1 employment indicator flag; blank = reported, 'A' = Matched to CES value, 'C' = Changed (re-reported), 'D' = reported on missing data notice, 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'S' = Summed worksite data to master, 'W' = applied wage record count, 'X' = was non-numeric | |
740 | 745 | 6R | Num | IMTQ-M2-EMPL(1) | Second month's employment | |
746 | 746 | 1R | Char | IMTQ-M2-IND(1) | Month 2 employment indicator flag; blank = reported, 'A' = Matched to CES value, 'C' = Changed (re-reported), 'D' = reported on missing data notice, 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'S' = Summed worksite data to master, 'W' = applied wage record count, 'X' = was non-numeric | |
747 | 752 | 6R | Num | IMTQ-M3-EMPL(1) | Third month's employment | |
753 | 753 | 1R | Char | IMTQ-M3-IND(1) | Month 3 employment indicator flag; blank = reported, 'A' = Matched to CES value, 'C' = Changed (re-reported), 'D' = reported on missing data notice, 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'S' = Summed worksite data to master, 'W' = applied wage record count, 'X' = was non-numeric | |
754 | 759 | 6R | Char | IMTQ-STATE-USAGE(1) | Free-form quarterly state usage field; included in some EXPO reports | |
760 | 770 | 11R | Num | IMTQ-TOTAL-WAGE(1) | Total wages for the quarter | |
771 | 771 | 1R | Char | IMTQ-TOTW-IND(1) | Total wage indicator flag; blank = reported, 'C' = Changed (re-reported), 'D' = reported on missing data notice, 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'S' = Summed worksite data to master, 'W' = applied wage record wages, 'X' = was non-numeric, changed to zeroes (inestimable) | |
772 | 782 | 11R | Num | IMTQ-TAX-WAGE(1) | Taxable wages for the quarter (zero for non-experience-rated establishments) | |
783 | 783 | 1R | Char | IMTQ-TAXW-IND(1) | Taxable wage indicator flag; blank = reported, 'C' = Changed (re-reported), 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'X' = was non-numeric, changed to zeroes | |
784 | 792 | 9R | Num | IMTQ-CONTRIB-DUE(1) | U-I Contributions due for the quarter (zero for non-experience-rated establishments (with the possible exception of reimbursables with employee contributions) | |
793 | 793 | 1R | Char | IMTQ-CTRB-IND(1) | Contributions due indicator flag; blank = reported, 'C' = Changed (re-reported), 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'X' = was non-numeric, changed to zeroes | |
794 | 799 | 6R | Char | IMTQ-COMMENT-CODE(1) | Comment codes (up to three 2-byte codes) | |
794 | 795 | 2R | Char | IMTQ-CMNT1(1) | First comment code | |
796 | 797 | 2R | Char | IMTQ-CMNT2(1) | Second comment code | |
798 | 799 | 2R | Char | IMTQ-CMNT3(1) | Third comment code | |
800 | 912 | 113 | Char | IMT-QTR-DATA(2) | Occurrence 2 of IMT data (for data immediately prior to the most recent quarter, just described; format is the same for this occurrence and all others to follow | |
913 | 1025 | 113 | Char | IMT-QTR-DATA(3) | Third occurrence (two quarters before the most recent IMT quarter) | |
1026 | 1138 | 113 | Char | IMT-QTR-DATA(4) | Fourth occurrence of IMT quarterly data | |
1139 | 1251 | 113 | Char | IMT-QTR-DATA(5) | Fifth occurrence of IMT quarterly data | |
1252 | 1364 | 113 | Char | IMT-QTR-DATA(6) | Sixth occurrence of IMT quarterly data | |
Input Micro Transaction File Data Set Name: WS.ES202.MICRO.TRANS.FILE Service Center DSN: YBUssX.A145.MICRO.TRANS.FILE, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2IMT The Input Micro Transaction (or IMT) File is produced by State-specific data extraction programs. It is the keystone for the standard micro data interface method. The format of this file closely follows that of the Micro File. However, this is a six-quarter file, with added fields for Mailing/Other Address (MOA) File updates. The Micro File has seven quarters of employment and wage data, but doesn't include the mailing/other address block. All fields in the IMT File are defined as alpha-numeric (PIC X), even though many of these correspond to numeric fields in the Micro record. This definition is used so that fields which are not intended as updates can be set to low-values (binary zeroes), which signify that no changes to the existing Micro File values are to take place. Values of spaces are interpreted as a blanking-out of the particular field, which may not be the desired effect. The ES2MI01 interface program matches IMT elements to their counterparts in the Micro File, validates codes, and updates fields that are changed. At the same time, any information found in the mailing/other address block is passed on to the Mailing/Other Address File. Once processed, the IMT File can be deleted, as it is no longer needed by the system. However, this deletion generally is not performed by EXPO JCL's, as some States may have some additional use for the file after it has been processed into the Micro File data. Due to disk space limitations at SunGard, the IMT File may still need to be deleted a week after its use, to prevent the IMT disk from becoming over-full. An IMT File may be developed to initially build the Micro File, to add a new quarter to the Micro File, or to serve as a source for late-reported or modified data. Most other changes to the Micro File will be made on-line. |
Related Links