06 enhanced quarterly address file es2equi
Enhanced Quarterly U-I Address File (ES2EQUI)
ES2EQUI - Length 1190 - Revised 2/13/2018
Columns | | Len | Key | Type | COBOL Field Name | Description & Notes |
== Standard Data Record == | ||||||
1 | 1 | 1 | Key | Char | EQUI-TRANS-CODE | Transaction Type Code; 'F' = Standard fully-formatted record (added, modified, inactivated, etc., establishment), 'D' = Deleted record |
2 | 3 | 2 | Key | Char | EQUI-STATE-FIPS | FIPS State Code |
4 | 8 | 5 | Key | Char | EQUI-YRQ | Year and quarter for the data to follow; subdivided below |
4 | 7 | 4R | Key | Char | EQUI-YEAR | Year of data to come (expanded from the 2-digit year field found in the micro record) |
8 | 8 | 1R | Key | Char | EQUI-QTR | Quarter identification number within the data year; '1' = First calendar quarter (January to March), '2' = Second calendar quarter (April to June), '3' = Third calendar quarter (July to September), '4' = Fourth calendar quarter (October to December) |
9 | 23 | 15 | Key | Char | EQUI-SESA-ID | State Employment Security Agency Identification number for the employer (U-I account plus reporting unit number); sub-defined below |
9 | 18 | 10R | Key | Char | EQUI-UI-ACCT | U-I account number portion of SESA ID |
19 | 23 | 5R | Key | Char | EQUI-RUN | Reporting unit number |
24 | 32 | 9 | Num | EQUI-EIN | Federal Employer Identification Number (EIN) – blank when zero | |
33 | 47 | 15 | Char | FILLER | spaces (formerly the Predecessor SESA ID, now placed on separate P/S records) | |
48 | 62 | 15 | Char | FILLER | spaces (formerly the Successor SESA ID, now placed on separate P/S records) | |
63 | 97 | 35 | Char | EQUI-LEGAL-NAME | Employer's legal/corporate name | |
98 | 132 | 35 | Char | EQUI-TRADE-NAME | Employer's trade name (or doing-business-as (DBA) name) | |
133 | 243 | 111 | Char | EQUI-UI-TAX-ADDRESS | U-I tax department's mailing address for the employer; individual fields that compose this group level are listed below | |
133 | 167 | 35R | Char | EQUI-UI-ADDR1 | First line of U-I tax street address | |
168 | 202 | 35R | Char | EQUI-UI-ADDR2 | Second line of U-I tax street address | |
203 | 232 | 30R | Char | EQUI-UI-CITY | U-I address city | |
233 | 234 | 2R | Char | EQUI-UI-STATE | U-I address state postal abbreviation | |
235 | 243 | 9R | Char | EQUI-UI-ZIP-CODE | Full 9-digit zip code for U-I tax address (subdivided below) | |
235 | 239 | 5R | Char | EQUI-UI-ZIP | Standard 5-digit zip code for U-I tax address (or first five characters of Canadian zip code (ANANA format (alternating alphabetic and numeric characters))) | |
240 | 243 | 4R | Char | EQUI-UI-ZIPX | U-I tax address Zip+4 extension; or last digit of Canadian zip code with three spaces | |
244 | 354 | 111 | Char | EQUI-PHYS-LOC-ADDRESS | Block definition of physical location address; sub-defined below | |
244 | 278 | 35R | Char | EQUI-PL-ADDR1 | First physical location street address line | |
279 | 313 | 35R | Char | EQUI-PL-ADDR2 | Second line of physical location street address | |
314 | 343 | 30R | Char | EQUI-PL-CITY | Physical location address city | |
344 | 345 | 2R | Char | EQUI-PL-STATE | Physical location address state postal abbreviation | |
346 | 354 | 9R | Char | EQUI-PL-ZIP-CODE | Physical location address 9-digit zip code; subdivided below | |
346 | 350 | 5R | Char | EQUI-PL-ZIP | Physical location 5-digit zip code | |
351 | 354 | 4R | Char | EQUI-PL-ZIPX | Physical location Zip+4 extension | |
355 | 466 | 112 | Char | EQUI-MAILING-OTHER-ADDRESS | Group definition of the mailing/other address block; subdivided below | |
355 | 389 | 35R | Char | EQUI-MO-ADDR1 | First mailing/other street address line | |
390 | 424 | 35R | Char | EQUI-MO-ADDR2 | Second mailing/other street address line | |
425 | 454 | 30R | Char | EQUI-MO-CITY | Mailing/other address city | |
455 | 456 | 2R | Char | EQUI-MO-STATE | Mailing/other address state postal abbreviation | |
457 | 465 | 9R | Char | EQUI-MO-ZIP-CODE | Mailing/other address 9-digit zip code, split into sub-fields below | |
457 | 461 | 5R | Char | EQUI-MO-ZIP | Mailing/other address 5-digit zip code | |
462 | 465 | 4R | Char | EQUI-MO-ZIPX | Mailing/other address Zip+4 extension | |
466 | 466 | 1R | Char | EQUI-MO-ADDR-TYPE | Address type code for the mailing/other address; '1' = Physical location address; '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown or unverified type of address | |
467 | 501 | 35 | Char | EQUI-RPT-UNIT-DESCR | Reporting unit description (intended for worksite identification, but can be used for any account) | |
502 | 511 | 10 | Num | EQUI-PHONE-NUM | Employer's phone number; sub-fields are listed below; blank when zero | |
502 | 504 | 3R | Char | EQUI-PHONE-AREA | Area code portion of the phone number | |
505 | 507 | 3R | Char | EQUI-PHONE-PFX | Exchange code for phone number (or 'prefix') | |
508 | 511 | 4R | Char | EQUI-PHONE-SFX | Suffix of phone number | |
512 | 519 | 8 | Num | EQUI-SETUP-DATE | Set-up date for the establishment (date when record was added to the U-I tax file (or to the Micro File); yyyymmdd format; blank when zero; sub-fields (EQUI-SETUP-YEAR, EQUI-SETUP-MON, EQUI-SETUP-DAY) are "Char" data type | |
520 | 527 | 8 | Num | EQUI-INIT-LIAB-DATE | Date of initial liability for U-I taxation for the establishment; yyyymmdd format; blank when zero; sub-fields (EQUI-LIAB-YEAR, EQUI-LIAB-MON, EQUI-LIAB-MON) are "Char" data type | |
528 | 535 | 8 | Num | EQUI-END-OF-LIAB-DATE | Most recent end-of-liability, which may be circumvented by a reactivation date (mentioned next); yyyymmdd format; blank when zero; sub-fields (EQUI-EOL-YEAR, EQUI-EOL-MON, EQUI-EOL-DAY) are "Char" data type | |
536 | 543 | 8 | Num | EQUI-REACT-DATE | Most recent reactivation date, resulting in an active status code unless an even later end-of-liability date is present; yyyymmdd format; blank when zero; sub-fields (EQUI-REACT-YEAR, EQUI-REACT-MON, EQUI-REACT-DAY) are "Char" data type | |
544 | 544 | 1 | Char | EQUI-STATUS | Activity status code for the designated quarter; '1' = Active, '2' = Inactive, '9' = Pending future activation | |
545 | 545 | 1 | Char | EQUI-CES-IND | Indicator showing whether the establishment participates in the Current Employment Statistics (CES) system; space = Account has not been identified as a CES participant, 'C' = Account reports data under the CES system | |
546 | 547 | 2 | Char | EQUI-REFILE-RESP-CODE | Refiling response code for the most recent cycle for which the account was selected | |
548 | 551 | 4 | Char | EQUI-REFILE-YEAR | Year of most recent Annual Refiling Survey (ARS) activity (associated with the response code above); expanded from the 2-digit year stored in the micro record | |
552 | 574 | 23 | Char | EQUI-OLD-CODES | Changed codes showing the values as they existed at the beginning of the most recent refiling year; split into subordinate fields below; some new fields have been inserted in this section to replace obsolete old-code fields as well | |
552 | 554 | 3R | Char | EQUI-OLD-CNTY | Most recent changed pre-refiled county FIPS code | |
555 | 555 | 1R | Char | EQUI-OLD-OWN | Most recent pre-refiling ownership code | |
556 | 559 | 4R | Char | EQUI-ARS-VERIFY-YEAR | Latest refiling year for verification of codes (RC 41, 42, 46, 50) | |
560 | 562 | 3R | Char | EQUI-OLD-TOWN | Most recent New England township code, as it existed at the beginning of a refiling cycle | |
563 | 567 | 5R | Num | EQUI-MAX-RUN | Highest reporting unit number used for the multi-family during at least the last five years; used only for main account (with reporting unit number of 00000); a 'Char' type equivalent (EQUI-MAX-RUN-X) is also provided | |
568 | 568 | 1R | Char | EQUI-MWR-MAIL-IND | Mailing code from the micro record, denoting whether the employer receives mailings, and, if so, whether they would go out each quarter or only once per year during a designated quarter; 'N' = No mailings sent; 'Y' = Mailings go out each quarter; '1' = Mailings sent first calendar quarter only; '2' = Only 2nd quarter mailings go out; '3' = Mailings sent annually during 3rd quarter; '4' = Only 4th quarter mailings sent | |
569 | 574 | 6R | Char | EQUI-OLD-NAICS | Pre-refiling NAICS code from the most recent refiling cycle, if a change has occurred | |
575 | 575 | 1 | Char | EQUI-DATA-SOURCE | Code for origination source of data, for the designated quarter; space = Data from employer, 'E' = EDI data; 'C' = CENCO data (highly regarded data integrity) | |
576 | 576 | 1 | Char | EQUI-SPECIAL-IND | Specialized classification code; space = Standard account, 'L' = Employee leasing company, 'T' = Indian tribal council | |
577 | 580 | 4 | Char | EQUI-AGENT-CODE | Agent code for specified quarter, generally used for a payroll service or other external agent who has employment and wage information for the establishment | |
581 | 1190 | 610 | Char | EQUI-QUARTER-DATA | Data elements specifically dealing with the particular quarter; fields appear below; not all of these elements will necessarily be considered quarterly in nature, however | |
581 | 584 | 4R | Char | EQUI-SIC | Standard Industrial Classification (SIC) code "for the quarter" (since this is now an administrative (rather than a quarterly) data item, the value will be the same regardless of the quarter); most accounts created since 2002 will show an SIC code of '9999', since it does not need to be coded along with the NAICS | |
585 | 590 | 6R | Char | EQUI-NAICS12 | The NAICS-2012 field represents the final 2012-based NAICS code used for the establishment following the 2017 refiling cycle | |
591 | 596 | 6R | Char | EQUI-NAICS | NAICS (North American Industry Classification System) code for the quarter | |
597 | 597 | 1R | Char | EQUI-OWN | Single-digit ownership code for the quarter; '1' = Federal government, '2' = State gov't, '3' = Local government, '5' = Private ownership | |
598 | 598 | 1R | Char | EQUI-ORG-TYPE | Private industry organization type code "for the quarter"; this is an administrative (rather than quarterly) field, so it will have the same value regardless of the quarter; space = Unknown or unspecified organization type, 'C' = Corporation, 'I' = Individual proprietorship, 'O' = Other organization type; 'P' = Partnership | |
599 | 601 | 3R | Char | EQUI-CNTY | FIPS county code for the quarter | |
602 | 604 | 3R | Char | EQUI-TOWN | FIPS sub-county township code for the quarter; applies only to New England and NJ | |
605 | 605 | 1R | Char | FILLER | spaces (formerly used for the auxiliary code) | |
606 | 611 | 6R | Num | EQUI-MON1-EMPL | First month's employment for the quarter | |
612 | 612 | 1R | Char | EQUI-MON1-IND | Indicator field for first month's employment; space = Reported, 'A' = Assigned from CES data, 'C' = Changed (re-reported), 'D' = Missing data notice data (reported), 'E' = Estimated, 'H' = Hand-estimated (vrs. machine-generated estimates, 'K' = Special estimate related to natural disaster, 'L' = Late reported (overrides earlier estimates), 'M' = Missing, 'N' = Non-estimable due to long-term delinquency, 'P' = Prorated from master to worksite, 'R' = Reported, 'S' = Summed worksites to master, 'W' = Assigned from Wage Summary File data, 'X' = Non-numeric input datum converted to zeroes and inestimable as is | |
613 | 618 | 6R | Num | EQUI-MON2-EMPL | Second month's employment for the quarter | |
619 | 619 | 1R | Char | EQUI-MON2-IND | Indicator field for second month's employment; space = Reported, 'A' = Assigned via CES data, 'C' = Changed (re-reported), 'D' = Missing data notice data (reported), 'E' = Estimated, 'H' = Hand-estimated (vrs. machine-generated estimates, 'K' = Special estimate related to natural disaster, 'L' = Late reported (overrides earlier estimates), 'M' = Missing, 'N' = Non-estimable due to long-term delinquency, 'P' = Prorated from master to worksite, 'R' = Reported, 'S' = Summed worksites to master, 'W' = Assigned from Wage Summary File data, 'X' = Non-numeric input datum converted to zeroes and inestimable as is | |
620 | 625 | 6R | Num | EQUI-MON3-EMPL | Third month's employment for the quarter | |
626 | 626 | 1R | Char | EQUI-MON3-IND | Indicator field for third month's employment; space = Reported, 'A' = Assigned from CES data, 'C' = Changed (re-reported), 'D' = Missing data notice data (reported), 'E' = Estimated, 'H' = Hand-estimated (vrs. machine-generated estimates, 'K' = Special estimate related to natural disaster; 'L' = Late reported (overrides earlier estimates), 'M' = Missing, 'N' = Non-estimable due to long-term delinquency, 'P' = Prorated from master to worksite, 'R' = Reported, 'S' = Summed worksites to master, 'W' = Assigned from Wage Summary File data, 'X' = Non-numeric input datum converted to zeroes and inestimable as is | |
627 | 637 | 11R | Num | EQUI-TOTAL-WAGE | Total wages for the quarter | |
638 | 638 | 1R | Char | EQUI-TOTW-IND | Indicator field for total wages; space = Reported, 'C' = Changed (re-reported), 'D' = Datum obtained from missing data notice (reported), 'E' = Estimated, 'H' = Hand-estimated (vrs. machine-generated estimates, 'K' = Special estimate related to natural disaster, 'L' = Late reported (overrides earlier estimates), 'M' = Missing, 'N' = Non-estimable due to long-term delinquency, 'P' = Prorated from master to worksite, 'R' = Reported, 'S' = Summed worksites to master, 'W' = Assigned from Wage Summary File data, 'X' = Non-numeric input datum converted to zeroes and inestimable as is | |
639 | 649 | 11R | Num | EQUI-TAX-WAGE | Taxable wages for the quarter | |
650 | 658 | 9R | Num | EQUI-CONTRIB | Contributions due (or assessed) for the quarter | |
659 | 659 | 1R | Char | EQUI-TYPE-COV | Type-of-coverage code for the quarter; '0' = Experience-rated, taxable, '1' = Reimbursable, '2' = Experience-rated with employee contributions, '3' = Reimbursable with employee contributions, '8' = Non-covered (non-subject), '9' = Federal acct. | |
660 | 660 | 1R | Char | EQUI-MEEI | Multiple Establishment Employer Indicator (MEEI) code for the quarter; '1' = Single, '2' = Multi-worksite master, '3' = Worksite sub-unit, '4' = Known multi refusing to provide worksite detail (treated as single), '5' = Composite worksite (multiple locations, such as county-wide), '6' = Multi master treated as single, since fewer than 10 persons are employed in all secondary worksites combined | |
661 | 661 | 1R | Char | EQUI-PLA-TYPE-CODE | Currently undefined type code field related to the physical location address; not yet present in Micro data; replaces the reporting change indicator, which was abandoned during Version 9 development | |
662 | 667 | 6R | Char | EQUI-COMMENT | Group-level comment codes; individual comment code fields are defined below | |
662 | 663 | 2R | Char | EQUI-CMNT1 | First 2-digit comment code for the quarter | |
664 | 665 | 2R | Char | EQUI-CMNT2 | Second comment code for the quarter | |
666 | 667 | 2R | Char | EQUI-CMNT3 | Third comment code for the quarter | |
668 | 724 | 57R | Char | EQUI-NARR-CMNT | Narrative comment to supplement the numeric codes above | |
725 | 726 | 2R | Char | EQUI-COLLECT-IND | Collection mode indicator (CMI) used in TRS refiling of single employers | |
727 | 728 | 2R | Char | EQUI-ECON-CD-CHG-IND | Economic code change indicator numeric sum; a value of '00' denotes no economic code changes exist; a non-zero value is derived from the sum of- 01 = Economic township change; 02 = Economic NAICS change; 04 = Economic owner change; 08 = Economic county change; valid range is 00 through 15 | |
729 | 729 | 1R | Char | EQUI-UI-ADDR-TYPE-CODE | Unemployment-insurance address type code ('1' = Physical location address; '2' = Mailing address; '3' = Corporate headquarters; '9' = Unknown address type | |
730 | 737 | 8R | Num | EQUI-PLA-BIG-DATE | Physical Location Address change date (yyyymmdd format, blank if zero) | |
738 | 738 | 1R | Char | EQUI-GEO-SOFTWARE | Indicator for the type of geocoding software used to obtain the geocoding information on an employer; 'G' = Standard BLS geocoding software in use | |
739 | 739 | 1R | Char | EQUI-GEOCODE-SRC | Geocoding information source indicator code; 'B' = BLS geocoding source | |
740 | 743 | 4R | Char | EQUI-MATCH-CODE | Code denoting the reliability of the geocoding data; values found in Lookup File | |
744 | 746 | 3R | Char | EQUI-LOCATION | Geographic location code; values found in Lookup File | |
747 | 755 | 9R | Num | EQUI-LATITUDE | Geographic latitude of the location to within +/- 2.2 inches north/south measurement (99.999999 format used; blank if unknown); blank when zero | |
756 | 766 | 11R | Num | EQUI-LONGITUDE | Geographic longitude (sign yet to be established) for the establishment's physical location, with supposed precision to +/- 2 inches east/west measurement (format is +999.999999; blank if unknown); blank when zero | |
767 | 771 | 5R | Num | EQUI-NEW-LONG-LAT-YEARQ | Year/quarter in which the geocoding information was last updated (yyyyq format; expanded from the 2-digit year value found in the micro record); blank when zero | |
772 | 776 | 5R | Num | EQUI-PLACE-CODE | Municipality geographic code number (values found in Lookup File 'PL' records); blank when zero | |
777 | 778 | 2R | Char | EQUI-PLACE-CLASS CODE | Index to place code, further clarifying the metropolitan, urban, rural, airport, etc., nature of the place code; defined in Lookup File | |
779 | 793 | 15R | Num | EQUI-CENSUS-ID | Census Bureau's geographic block identifier, broken out as 2-digit State FIPS, 3-digit county FIPS, 4-digit Census Tract, 2-digit tract extension, and 4-digit block number; blank when zero | |
794 | 797 | 4R | Char | FILLER | spaces | |
798 | 798 | 1R | Char | EQUI-ADDR-CONT-SOURCE | Indicator denoting the source of information regarding the physical location address and/or contact name and contact title; values not yet specified | |
799 | 800 | 2R | Char | EQUI-INFORM-CONSENT-CD | Classification code denoting the employer's participation status in the Informed Consent program, whereby employers may permit their data to be released in publications, even if their individual data may be determined from the aggregates; values have not yet been released | |
801 | 804 | 4R | Char | EQUI-IC-START-YEAR | Year when the company started to participate in the informed consent process; this is determined from the Micro 2-digit year, with the century assigned as '20' | |
801 | 802 | 2R | Char | EQUI-IC-START-CENT | Century portion of informed consent starting year | |
803 | 804 | 2R | Char | EQUI-IC-START-YR | Two-digit informed consent start year | |
805 | 808 | 4R | Char | EQUI-IC-END-YEAR | Last year of participation by the employer in informed consent process; century part assigned '20' if 2-digit year (from micro data) is present | |
805 | 806 | 2R | Char | EQUI-IC-END-CENT | Century portion of informed consent ending year | |
807 | 808 | 2R | Char | EQUI-IC-END-YR | Two-digit informed consent ending year | |
809 | 812 | 4R | Char | EQUI-FUTURE-ARS-YEAR | 4-digit year of future application code changes; broken out below | |
809 | 810 | 2R | Char | EQUI-FUTURE-ARS-CENT | Century portion of future year field for upcoming code change data; interpreted from Future-ARS-Year, below; Future code changes are drawn from the Refiling File | |
811 | 812 | 2R | Char | EQUI-FUTURE-ARS-YEAR | Year of future application code changes | |
813 | 814 | 2R | Char | EQUI-FUTURE-ARS-RC | Response code associated with future-application code changes | |
815 | 820 | 6R | Char | EQUI-FUTURE-NAICS | NAICS code as it will exist once the code changes are put into effect | |
821 | 823 | 3R | Char | EQUI-FUTURE-CNTY | County code that will exist when the future code changes are enacted | |
824 | 826 | 3R | Char | EQUI-FUTURE-TOWN | Township code (for New England states and New Jersey) that will be among the future code changes | |
827 | 828 | 2R | Char | EQUI-FUTURE-CMI-CODE | Collection Mode Indicator tied to the future code changes | |
829 | 834 | 6R | Num | EQUI-WAGE-RECORD-CT | Number of wage records found for this employer for the quarter, stored in the Wage Summary File; EQUI-WAGE-RECORD-CTX provides a character-based equivalent | |
835 | 845 | 11R | Num | EQUI-WAGE-RECORD-WAGES | Summed wages from wage record data, stored in Wage Summary File; a character-based equivalent for the field is provided | |
846 | 850 | 5R | Char | EQUI-PHONE-EXT | Extension number for a particular contact person at the organization; from the field in the Micro File phone number set; placed here until the EQUI format is restructured following the demise of the 724-byte format in other BLS systems | |
851 | 885 | 35R | Char | EQUI-CONTACT-NAME | Formerly known as the attention name in micro data; drawn from the contact record of the MOA File, if present | |
886 | 920 | 35R | Char | EQUI-CONTACT-TITLE | Job title of the contact person of this establishment; from the MOA contact record | |
921 | 980 | 60R | Char | EQUI-E-MAIL-ADDR | E-mail address for the contact person; if entered on-line, will appear in all upper-case characters, even though lower-case may be expected for messages; drawn from MOA e-mail/fax number record, if present | |
981 | 990 | 10R | Char | EQUI-FAX-PHONE | Facsimile machine phone number, in standard area-exchange-suffix format; data are taken from MOA e-mail/fax number record, if present | |
991 | 1050 | 60R | Char | EQUI-WEBSITE-ADDR | Company website address; from MOA website address record, if present | |
1051 | 1051 | 1R | Char | EQUI-FUTURE-USE | Planned new field of uncertain definition | |
1052 | 1061 | 10R | Char | EQUI-LARGEST-WAGE-REC-RCP-SUCC | U-I account number of employer with the highest number of employees that could potentially represent a successor relationship | |
1062 | 1067 | 6R | Char | EQUI-LARGEST-WAGE-REC-CNT-SUCC | Number of wage records associated with the potential successor listed above | |
1068 | 1077 | 10R | Char | EQUI-LARGEST-WAGE-REC-RCP-PRED | U-I account number of employer with the highest potentially-transferred wage record count related to the current employer | |
1078 | 1083 | 6R | Char | EQUI-LARGEST-WAGE-REC-CNT-PRED | Number of wage records connected to the potential predecessor U-I listed above | |
1084 | 1089 | 6R | Char | EQUI-HIRES | BLS Definition not yet confirmed – potential new hires based upon wage record data – the number of employees that appear for this employer now, but were not associated with any employer in last quarter's wage record data | |
1090 | 1095 | 6R | Char | EQUI-SEPARATIONS | BLS Definition not yet confirmed – potential number of unhired layoffs, based on wage record data – those employees who were associated with this employer last quarter, but are not connected with any employer in the current quarter | |
1096 | 1101 | 6R | Char | EQUI-NEW-ENTRANTS | BLS Definition not yet confirmed – Apparently similar to, but not quite the same as, the EQUI-HIRES field | |
1102 | 1107 | 6R | Char | EQUI-EXITS | BLS Definition not yet confirmed – Apparently similar to, but not quite the same as, the EQUI-SEPARATIONS field | |
1108 | 1113 | 6R | Char | EQUI-CONTINUOUS-EMPS | BLS Definition not yet confirmed – Number of wage records noting an employee who has been working for this employer over both quarters | |
= = = Fact of Discrepancy Fields = = = | ||||||
1114 | 1119 | 6R | Num | EQUI-FOD-DATE-YYYYMM | Year and month during which the fact of discrepancy is handled or encountered (4-digit year is followed by 2-digit month number) | |
1120 | 1121 | 2R | Char | EQUI-FOD-CTRL-ACT-CODE | Fact-of-discrepancy control action code; definition and values have not yet been related by BLS | |
1122 | 1127 | 6R | Char | EQUI-FOD-NAICS | Conflicting NAICS code shown from another source, disputing the value listed in the Micro File (blank if no disparity exists for the NAICS?) | |
1128 | 1130 | 3R | Char | EQUI-FOD-CNTY | Conflicting county FIPS code drawn from another data source, contrasted with the value shown in Micro File data (blank if no disparity exists for the county?) | |
1131 | 1187 | 57R | Char | EQUI-FOD-EXPLANATION | Narrative area provided to explain the situation related to the code disparity (fact of discrepancy); for Missouri and Rhode Island, this holds their original account number so that the BLS will have knowledge of the connection | |
1188 | 1190 | 3R | Char | FILLER | spaces | |
EQUI Header Record Layout | ||||||
1 | 1 | 1 | Key | Char | EQUIH-TRANS-CODE | Transaction type code; 'H' = Signifies the header record of an EQUI transmittal |
2 | 3 | 2 | Key | Char | EQUIH-STATE-FIPS | FIPS State code |
4 | 8 | 5 | Key | Char | EQUIH-YEARQ | Most recent year and quarter to be represented in the EQUI records; broken out below |
4 | 7 | 4R | Key | Char | EQUIH-YEAR | Year of most recent EQUI data (4-digit, numeric) |
8 | 8 | 1R | Key | Char | EQUIH-QTR | Most recent quarter of data in EQUI records ('1', '2', '3', or '4') |
9 | 23 | 15 | Key | Char | EQUIH-SESA-ID | Normally the place for a SESA ID, this field is set to zeroes to match the key length of other record types |
24 | 31 | 8 | Num | EQUIH-CREATE-DATE | Creation date of the EQUI file (or more precisely for this record, yyyymmdd format) | |
32 | 39 | 8 | Num | EQUIH-CREATE-TIME | Creation time-of-day for the EQUI file's header record (hhmmssff format, where 'hh' is hour (00-23), 'mm' is minute (00-59), 'ss' is second (00-59), and 'ff' is the fraction (in hundredths) of a second (00-99) | |
40 | 42 | 3 | Num | EQUIH-RECORD-LENGTH | Length of each EQUI record; set to 190 (a high-order truncation of the standard 1190-byte record) or, in old-style runs, 724 (an option in 021D job run) | |
43 | 47 | 5 | Num | EQUIH-BLOCK-SIZE | Length of each block of EQUI records on the tape, cartridge, or disk file; for the 1190-byte record, this is set to 27370; for the 724-byte record it is set to 27512 | |
48 | 433 | 386 | Char | EQUIH-EDIT-PARMS | Grouped editing parameters and tolerances, sub-defined below | |
48 | 53 | 6R | Num | EQUIH-MAX-TAX-RATE | Maximum tax rate for the State (1000ths of a percent); BLS default is 15000 (15%) | |
54 | 59 | 6R | Num | EQUIH-MIN-TAX-RATE | Minimum tax rate for State (1000ths of a percent); BLS default is 0% | |
60 | 65 | 6R | Num | EQUIH-EMPLOYEE-TAX-RATE | State employee contribution rate (for any applicable state, 1000ths of a percent; 0% | |
66 | 71 | 6R | Num | EQUIH-PRED-SUCC-AME | Minimum average monthly employment needed to conduct edits on predecessor and successor account numbers; BLS default is 0 | |
72 | 73 | 2R | Num | EQUIH-EMPL-DIFF-SPL-AME | Division point in employment change edit to separate smaller and larger establishments; BLS default is 20 | |
74 | 75 | 2R | Num | EQUIH-LOW-EMPL-MAX-DIFF | Smaller establishment allowed monthly employment change; BLS default is 10 | |
76 | 77 | 2R | Num | EQUIH-HIGH-EMPL-MAX-DIFF | Larger establishment allowed monthly employment change; BLS default is 30 | |
78 | 79 | 2R | Num | EQUIH-HIGH-RPTG-PCT-CHG | Allowed monthly employment change percentage for establishments with over five months of reported data during the past year; BLS default is 10(%) | |
80 | 81 | 2R | Num | EQUIH-LOW-RPTG-PCT-CHG | Allowed monthly employment change percentage when fewer than six months in the past year have reported data; BLS default is 30(%) | |
82 | 83 | 2R | Num | EQUIH-EMPL-CHECK-MULTER | Multiplying factor for employment change parameters to split moderate from severe employment change errors; BLS default is 10 | |
84 | 85 | 2R | Num | EQUIH-NO-WAGE-MAX-EMPL | Maximum allowed employment for zero total wages; BLS default is 10 | |
86 | 91 | 6R | Num | EQUIH-WAGE-CHG-CUTOFF | Allowed quarterly fluctuation of average quarterly wages (AQW); default is 10000 | |
92 | 93 | 2R | Num | EQUIH-WAGE-CHECK-MULTER | Multiplier for AQW change tolerance to distinguish moderate and severe AQW change exceptions; BLS default is 3 | |
94 | 95 | 2R | Num | EQUIH-NO-WAGE-MAX-EMP-XER | Multiplier for employment-without-wages edit to find severe conditions; default 10 | |
96 | 101 | 6R | Num | EQUIH-NO-EMPL-MAX-WAGE | Maximum allowed total wages for a no-employment account; BLS default is 10000 | |
102 | 103 | 2R | Num | EQUIH-NO-EMP-MAX-WAGE-XER | Multiplier for wages-without-employment edit to split standard from severe exceptions; BLS default is 3 | |
104 | 105 | 2R | Num | EQUIH-EMPL-EQ-WAGE-TOL | Maximum deviation between total wages and summed employment to flag the employment = wages exception; BLS default is 5 | |
106 | 111 | 6R | Num | EQUIH-EMPL-EQ-WAGE-AME | Minimum AME required to check for employment=wages exception; default is 25 | |
112 | 113 | 2R | Num | EQUIH-EMPL-EQ-WAGE-MULTER | Multiplier for employment=wages edit to distinguish severe versus ordinary exceptions; BLS default is 10 | |
114 | 119 | 6R | Num | EQUIH-ZIP-CODE-AME | Minimum AME required to flag an edit exception for zip code fields; BLS default 99 | |
120 | 125 | 6R | Num | EQUIH-PHONE-AME | Minimum AME required to flag an edit exception for unusable phone number; BLS default is 99 | |
126 | 131 | 6R | Num | EQUIH-PHYS-ADDR-AME | Minimum AME required to flag an edit for unusable physical address; default is 0 | |
132 | 137 | 6R | Num | EQUIH-EIN-AME | Minimum AME needed to flag an invalid EIN; BLS default is 0 | |
138 | 139 | 2R | Num | EQUIH-EIN-MONTHS | Number of months allowed to pass before a missing (i.e., zero-valued) EIN account is flagged for review; BLS default is 24 | |
140 | 145 | 6R | Num | EQUIH-MAX-TAX-RATE-DEV | Maximum allowed deviation in tax rate percentage (computed versus reported, in 1000ths of a percent); BLS default is 330 ( 0.330%) | |
146 | 151 | 6R | Num | EQUIH-MAX-CONTRIB-DEV | Maximum allowed deviation in contributions (computed versus reported, in cents); BLS default is 250 (or $2.50) | |
152 | 152 | 1R | Char | EQUIH-CALIF-RATE-EDIT-BYP | Special switch for California to allow tax rate edit to be bypassed; '0' = No bypass (perform the edit), '1' = Bypass the tax rate edit (i.e., this is California) | |
153 | 158 | 6R | Num | EQUIH-MAX-TOTW-NO-TAXW | Maximum total wages allowed to exist with zero taxable wages for an experience-rated employer during the first calendar quarter; BLS default is 25000 ($25,000) | |
159 | 159 | 1R | Char | EQUIH-CALIF-NO-TAXW-BYP | Special edit bypass switch for California to ignore the edit for total wages without taxable wages; '0' = Conduct the no-taxable-wage edit normally, '1' = Bypass the edit | |
160 | 161 | 2R | Num | EQUIH-NECC-EMPL | Maximum AME permitted to ignore a mid-year non-economic code change (NECC); BLS default is 25 | |
162 | 163 | 2R | Num | EQUIH-LOGIC-SIC-CHG-AME | Obsolete - Maximum AME permitted to ignore an illogical SIC change (i.e., suspected digit transposition); BLS default is 50 | |
164 | 165 | 2R | Num | EQUIH-ACTIVE-AME | Maximum AME for which active account edit can be ignored; BLS default is 99 25 | |
166 | 171 | 6R | Num | EQUIH-ACTIVE-WAGE | Maximum total wages that can ignore active account edit; BLS default is 10000 | |
172 | 173 | 2R | Num | EQUIH-LIABLE-AME | Maximum AME for liable account edit to be ignored; BLS default is 25 | |
174 | 179 | 6R | Num | EQUIH-LIABLE-WAGE | Maximum total wages that can ignore liable account edit; BLS default is 10000 | |
180 | 185 | 6R | Num | EQUIH-MAX-IDENT-EMPL | Maximum employment level to skip the identical employment edit; BLS default is 50 | |
186 | 187 | 2R | Num | EQUIH-TAXW-TOTW-CHG-PCT | Allowed annual change in taxable-total wage ratio, in percentage; BLS default is 20 | |
188 | 193 | 6R | Num | EQUIH-TAXW-TOTW-CHG-AME | AME cutoff for checking taxable/total wage ratio annual change; BLS default is 99 | |
194 | 195 | 2R | Num | EQUIH-UNCLASS-MAX-AME | AME cutoff for flagging unclassified (SIC 9999) accounts; BLS default is 25 | |
196 | 201 | 6R | Num | EQUIH-MACRO-DISCON-AME | AME cutoff for flagging discontinued employers at macro level; BLS default is 50 | |
202 | 207 | 6R | Num | EQUIH-MACRO-NEW-AME | Macro-level AME cutoff for flagging new employers; BLS default is 50 | |
208 | 209 | 2R | Num | EQUIH-NEW-DISCON-SINGLE | Micro-level AME cutoff to flag new/discontinued single accounts; BLS default is 25 | |
210 | 211 | 2R | Num | EQUIH-NEW-DISCON-MULTI | Micro-level AME cutoff to flag a new or discontinued multi account (a master or a worksite); BLS default is 50 | |
212 | 213 | 2R | Num | EQUIH-PRED-SUCC-EMPL-CHG | Predecessor-to-successor maximum employment change; BLS default is 25 | |
214 | 215 | 2R | Num | EQUIH-MAX-RU-CT-BRK-CON | Maximum change in reporting unit count in breakout/consolidation; default is 10 | |
216 | 217 | 2R | Num | EQUIH-MAX-RU-CT-PCT-CHG | Maximum allowed percentage change in breakout/consolidation; default is 10 | |
218 | 219 | 2R | Num | EQUIH-MAX-EMPL-DIFF-B-C | Maximum allowed employment change in breakout/consolidation; default is 50 | |
220 | 221 | 2R | Num | EQUIH-EMPL-PCT-DIFF-B-C | Maximum employment percentage change in breakout/consolidation; default is 10 | |
222 | 223 | 2R | Num | EQUIH-RU-CT-CHG-NON-999 | Maximum reporting unit count change for a non-nines (unclassified NAICS or county) breakout or consolidation; BLS default is 20 | |
224 | 229 | 6R | Num | EQUIH-EMPL-BAL-SPLIT1 | First AME split level for multi-unit balance checking, distinguishing small and mid-sized families; BLS default is 50 | |
230 | 231 | 2R | Num | EQUIH-LOW-EMPL-BAL-TOL | Small family employment balance edit tolerance; BLS default is 5 | |
232 | 233 | 2R | Num | EQUIH-MED-EMPL-BAL-PCT | Mid-sized family employment balance percentage tolerance; BLS default is 10 | |
234 | 239 | 6R | Num | EQUIH-EMPL-BAL-SPLIT2 | Second AME split level to separate medium-sized and large-sized multi-families in employment balancing; BLS default is 1000 | |
240 | 245 | 6R | Num | EQUIH-HIGH-EMPL-BAL-TOL | Large-family employment balance tolerance; BLS default is 100 | |
246 | 251 | 6R | Num | EQUIH-WAGE-BAL-SPLIT1 | First split level for family total wage balancing; separates small and medium sized families; BLS default is 25000 | |
252 | 257 | 6R | Num | EQUIH-LOW-WAGE-BAL-TOL | Small-wage family total wage balance tolerance; BLS default is 250 | |
258 | 259 | 2R | Num | EQUIH-MED-WAGE-BAL-MIL | Medium-wage family total wage balance mill (1/10%) tolerance; BLS default is 10 | |
260 | 265 | 6R | Num | EQUIH-WAGE-BAL-SPLIT2 | Second split level for total wage balancing, dividing medium- and large-wage families; BLS default is 100000 | |
266 | 271 | 6R | Num | EQUIH-HIGH-WAGE-BAL-TOL | Large-wage families' total wage balance tolerance; BLS default is 1000 | |
272 | 277 | 6R | Num | EQUIH-CCS-DIV-CHG-AME | AME cutoff for flagging a major division change in CCS edits; BLS default is 100 | |
278 | 283 | 6R | Num | EQUIH-CCS-IN-DIV-AME | AME cutoff for flagging an SIC change within the same major division under the CCS edits; BLS default is 250 | |
284 | 289 | 6R | Num | EQUIH-WAGE-REC-EDIT-AME | AME cutoff for performing wage record edits (if wage record data are used in the State); BLS default is 50 | |
290 | 291 | 2R | Num | EQUIH-EMPL-GT-WRC-PCT | Percentage by which the monthly micro employment may exceed the wage record count; BLS default is 10 | |
292 | 293 | 2R | Num | EQUIH-WRC-GT-EMPL-PCT | Percentage by which the wage record count may exceed the highest micro monthly employment value; BLS default is 20 | |
294 | 299 | 6R | Num | EQUIH-WAGE-REC-WAGE-AME | AME cutoff for editing wage record wages/micro total wage checks; default is 100 | |
300 | 301 | 2R | Num | EQUIH-WAGE-GT-WRW-PCT | Percentage by which total wages may exceed wage record wages; BLS default is 20 | |
302 | 307 | 6R | Num | EQUIH-MIN-AME-CUTOFF | Minimum employment required to print an edit exception (introduced with the total wage cutoff (described next) to reduce edit report volume; BLS default is 0 | |
308 | 313 | 6R | Num | EQUIH-MIN-TOTW-CUTOFF | Minimum total wage value required to print micro edit exception; if either employment or wage minimum is met, edit report detail line will be generated; default is 0 | |
314 | 319 | 6R | Num | EQUIH-EIN-ERROR-AME | Employment cutoff for editing the EIN format; BLS default is 5 | |
320 | 325 | 6R | Num | EQUIH-SUPL-EDIT-AME | Minimum employment needed to conduct supplemental AQW edit; BLS default is 25 | |
326 | 331 | 6R | Num | EQUIH-SUPL-EDIT-WAGE-DIFF | Minimum AQW quarterly change required to perform supplemental AQW edit (when normal edit passes); BLS default is 3000 | |
332 | 337 | 6R | Num | EQUIH-LARGE-NEW-EMPL | Employment threshold for very large new employer edit; BLS default is 500 | |
338 | 343 | 6R | Num | EQUIH-LARGE-DISC-EMPL | Minimum employment to run very large discontinued employer edit; default is 500 | |
344 | 349 | 6R | Num | EQUIH-NEW-EMPL | Threshold employment for flagging new large-employment account; default is 100 | |
350 | 355 | 6R | Num | EQUIH-DISC-EMPL | Final employment level required to flag a terminating employer as a large discontinued account; BLS default is 100 | |
356 | 361 | 6R | Num | EQUIH-PRED-SUCC-EMPL | Employment level needed to perform checks for predecessor/successor inconsistencies; BLS default is 100 | |
362 | 367 | 6R | Num | EQUIH-MULTI-BREAK-EMPL | Multi family breakout editing cutoff employment; BLS default is 100 | |
368 | 373 | 6R | Num | EQUIH-MULTI-COLLAPSE-EMPL | Employment limit for multi-family consolidation checks; BLS default is 100 | |
374 | 379 | 6R | Num | EQUIH-LARGE-MULTI-COLLAPS | Employment minimum for flagging huge multi family collapse; BLS default is 1000, but EXPO uses a 500 default | |
380 | 385 | 6R | Num | EQUIH-MULTI-COLLAPSE | Large family collapse employment limit; BLS default is 500 | |
386 | 391 | 6R | Num | EQUIH-MULTI-UNIT-COLLAPSE | Reporting unit count cutoff for huge family collapse edit; BLS default is 50 (Note: EXPO uses a 2-digit parameter instead of the 6-digit value shown here.) | |
392 | 397 | 6R | Num | EQUIH-COMMENT-ERROR-AME | Minimum employment to flag invalid comment codes; BLS default is 10 | |
398 | 403 | 6R | Num | EQUIH-GROSS-ERROR-AME | Employment level needed to flag an account as possessing a gross error | |
404 | 409 | 6R | Num | EQUIH-GROSS-ERROR-TOTW | Total wage level needed to flag an account as possessing a gross error | |
410 | 415 | 6R | Num | EQUIH-NO-ADDR-AME | Minimum employment needed to flag accounts with no usable address present | |
416 | 421 | 6R | Num | EQUIH-NO-NAME-AME | Minimum employment required to flag accounts with neither legal nor trade name | |
422 | 427 | 6R | Num | EQUIH-FUTURE-USE5 | For future use | |
428 | 433 | 6R | Num | EQUIH-FUTURE-USE6 | For future use | |
434 | 1190 | 757 | Char | FILLER | spaces | |
EQUI Trailer Record Layout | ||||||
1 | 1 | 1 | Key | Char | EQUIT-TRANS-CODE | Transaction type code; 'T' = Trailer record of an EQUI transmittal |
2 | 3 | 2 | Key | Char | EQUIT-STATE-FIPS | FIPS State code |
4 | 8 | 5 | Key | Char | EQUIT-YRQ | Year/quarter of most recent data found on the EQUI file; yyyyq format |
9 | 23 | 15 | Key | Char | EQUIT-SESA-ID | Space for a SESA ID in standard EQUI records; used here as a record key alignment; value is zeroes |
24 | 96 | 73 | Char | EQUIT-RECORD-COUNTS | Group-level identifier for record counts shown in the detail listed below | |
24 | 31 | 8R | Num | EQUIT-RC-DELETES | Total number of records deleted from the Micro File (excludes accounts that have "rolled off" due to six consecutive inactive quarters; these are not considered "deleted" records in the National BLS system; with a limit of 100 million deleted establishments, there is little doubt that adequate space has been reserved for this field | |
32 | 44 | 13R | Char | EQUIT-RC-QTRLY-DATA(1) | First occurrence of quarterly record counts, representing the most recent quarter of EQUI data; the individual fields appear below | |
32 | 36 | 5R | Num | EQUIT-RC-YEARQ(1) | Most recent year/quarter for EQUI data (should match EQUIT-YRQ); yyyyq format | |
37 | 44 | 8R | Num | EQUIT-RC-RECS(1) | Number of EQUI records present for the most recent quarter | |
45 | 57 | 13R | Char | EQUIT-RC-QTRLY-DATA(2) | Second occurrence of quarterly record count data, with the same format as above | |
58 | 70 | 13R | Char | EQUIT-RC-QTRLY-DATA(3) | Third occurrence of quarterly record count data, with the same format as above | |
71 | 83 | 13R | Char | EQUIT-RC-QTRLY-DATA(4) | Fourth occurrence of quarterly record count data, with the same format as above | |
84 | 96 | 13R | Char | EQUIT-RC-QTRLY-DATA(5) | Fifth occurrence of quarterly record count data, with the same format as above | |
97 | 171 | 75 | Char | EQUIT-ALL-QTR-TOTALS | Group-level definition of the all-quarter record counts detailed below | |
97 | 104 | 8R | Num | EQUIT-AQT-ESTABS | Number of establishments represented in all quarters of EQUI records combined | |
105 | 113 | 9R | Num | EQUIT-AQT-M1-EMPL | Summed first month employment from all EQUI records in the file (up to a billion) | |
114 | 122 | 9R | Num | EQUIT-AQT-M2-EMPL | Summed second month employment from all EQUI records in the file | |
123 | 131 | 9R | Num | EQUIT-AQT-M3-EMPL | Summed third month employment from all EQUI records in the file | |
132 | 145 | 14R | Num | EQUIT-AQT-TOTAL-WAGE | Summed total wages from all EQUI records in the file; up to $100 trillion limit | |
146 | 159 | 14R | Num | EQUIT-AQT-TAX-WAGE | Summed taxable wages from all EQUI records in the file, same limit as total wages | |
160 | 171 | 12R | Num | EQUIT-AQT-CONTRIB-DUE | Summed contributions for all EQUI records, with a National-debt-sized limit | |
172 | 246 | 75 | Char | EQUIT-ALL-OWNER-TOTALS(1) | Group-level definition for newest quarter's sum of all ownerships' data, defined below | |
172 | 179 | 8R | Num | EQUIT-AOT-ESTABS(1) | Number of establishments shown in EQUI records for the most recent quarter | |
180 | 188 | 9R | Num | EQUIT-AOT-M1-EMPL(1) | Summed first-month employment in all newest-quarter EQUI records, all ownerships | |
189 | 197 | 9R | Num | EQUIT-AOT-M2-EMPL(1) | Summed second-month employment data for all newest-quarter EQUI records | |
198 | 206 | 9R | Num | EQUIT-AOT-M3-EMPL(1) | Summed third-month employment data for all newest-quarter EQUI records | |
207 | 220 | 14R | Num | EQUIT-AOT-TOTAL-WAGE(1) | Newest quarter's summed total wage data over all EQUI records for the quarter | |
221 | 234 | 14R | Num | EQUIT-AOT-TAX-WAGE(1) | Summed taxable wages for all EQUI records representing newest-quarter data | |
235 | 246 | 12R | Num | EQUIT-AOT-CONTRIB-DUE(1) | Summed contributions from all newest-quarter EQUI records | |
247 | 321 | 75 | Char | EQUIT-ALL-OWNER-TOTALS(2) | Group-level definition for the next-to-newest quarter's summed data over all ownership codes; sub-fields are in the same format as those described above | |
322 | 396 | 75 | Char | EQUIT-ALL-OWNER-TOTALS(3) | Group-level definition for all-ownership totals for records representing data two quarters before the newest EQUI quarter, in the same format as listed above | |
397 | 471 | 75 | Char | EQUIT-ALL-OWNER-TOTALS(4) | Group-level definition for summed all-ownership data from EQUI records for three quarters before the newest EQUI quarter, using the same format as in subscript 1; when the newest year/quarter is the second or third calendar quarter (i.e., representing the months of April through September), totals in occurrence 4 should all be zero | |
472 | 546 | 75 | Char | EQUIT-ALL-OWNER-TOTALS(5) | Group-level definition for all-ownership summed data for year-ago EQUI records, with the same format as in subscript #1; these fields should be zeroes under normal processing, unless the newest EQUI quarter is the first calendar quarter of the year | |
547 | 1190 | 644 | Char | FILLER | spaces | |
Enhanced Quarterly U-I Address File
Data Set Name: EQUI.DATA.STYYQ Service Center DSN: YBUssX.A145.EQUI.DATA.STYYQ, ('ss' = State FIPS code) ST = State Postal Abbreviation, YYQ = principal year/quarter for EQUI data) Type of File: Sequential File Layout: ES2EQUI
The Enhanced Quarterly U-I (EQUI) File is the only deliverable file required by BLS under the MicMac system. There are two flavors of the file. The first is the full-scale deliverable that contains a record for each active account on the Micro File, except for non-covered accounts. It also contains update data for all "unlocked" earlier quarters of micro data. The second type of file contains only updates to the current and earlier quarters. The term "unlocked" refers to quarters that can be updated on the BLS Micro File. The current and immediate prior quarter are always updateable under MicMac. Quarters before the immediate prior quarter can also be updated if they are in the same calendar year as the prior quarter. Therefore, if current quarter is 2018/2, none of the quarters earlier than the prior quarter (2018/1) could be updated, since they are in an earlier year.
The EQUI data record contains most of the fields found in the micro record, along with data from the MOA and Narrative Comment Files. There is also a header record (showing tape transmission data, edit parameters, and other general data. A trailer record is included as well, showing various types of record count tallies that can be used by BLS to verify that all of the data came through on the tape. This tape file is generated by Jobs ES2J011D and -11S. The same format of file is produced by Jobs 21D and 21F (though only the first 724 bytes are initially accepted for Job 21D runs), but this file usually gives either a single quarter's information only, or a multi-quarter subset file, selecting records prescribed by BLS for special needs. Job 21D is intended more for CES applications that require an EQUI input file. Job 21F is used strictly for special BLS deliverables. |
Related Links