06 equi predecessor successor sub file es2eqps

EQUI Predecessor/Successor Sub-File (ES2EQPS)

ES2EQPS - Length 1190 - Revised 9/8/2006

Columns ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	1	1	Key	Char	EQUI-PS-TRANS-CODE	Transaction Type Code; 'P = Predecessor/successor EQUI transaction
2	3	2	Key	Char	EQUI-PS-STATE-FIPS	State FIPS Code
4	18	15	Key	Char	EQUI-PS-SESA-ID	Combined U-I account number and reporting unit number; break-out follows
4	13	10R	Key	Char	EQUI-PS-UI-ACCT	U-I account number
14	18	5R	Key	Char	EQUI-PS-RUN	Reporting unit number
19	19	1	Key	Char	EQUI-PS-FORMAT-TYPE	Switch to distinguish between predecessor and successor relationships; 'P' = SESA ID to follow is a predecessor to the account shown above; 'S' = following SESA ID is a successor to the current establishment
20	20	1	Key	Char	EQUI-PS-ACTION-CODE	Switch to distinguish between new, changed or removed predecessor/successor relationships; blank = new predecessor or successor assignment; 'D' = former predecessor or successor relationship is deleted (has been removed); 'R' = retain a predecessor or successor relationship, but some of the attributes of this relation­ship are changed
21	35	15	Key	Char	EQUI-PS-P-S-SESA-ID	SESA ID of the predecessor or successor to the SESA ID appearing below the FIPS code; broken out below
21	30	10R	Key	Char	EQUI-PS-P-S-UI-ACCT	U-I account number portion of the SESA ID
31	35	5R	Key	Char	EQUI-PS-P-S-RUN	Predecessor or successor reporting unit number
36	37	2		Char	EQUI-PS-SOURCE-CODE	Origination source for the predecessor/successor information; valid values include – 'AR' = ARS (Annual Refiling Survey) 'BL' = BLS Weighted Match 'ED' = EDI Center 'ER' = Employer 'EX' = Extract 'FS' = Other Federal/State Program 'HS' = Historical 'MD' = Media 'MW' = Multiple Worksite Report (MWR) 'OT' = Other data source 'RL' = Record linking 'SD' = SUTA Dumping 'UI' = Unemployment Insurance (U-I) department 'WR' = Wage record data
38	45	8		Char	EQUI-PS-TRANSFER-DATE	Date on which the transfer (i.e., change of ownership) took place between the prede­cessor and the successor; yyyymmdd format; may be blank if actual date unknown
46	53	8		Char	EQUI-PS-POSTED-DATE	Date on which the predecessor/successor information was relayed to the Predecessor Successor Actual (PSA) File; yyyymmdd format
54	198	145		Char	EQUI-PS-NARR-COMMENT	Extended narrative comment (from the Predecessor/Successor Narrative (PSN) File) used to describe the specific nature of the predecessor/successor relationship
199	1190	992		Char	FILLER	spaces (this massive filler area is needed to align the P/S EQUI record with the other, standard EQUI's, which contain substantially more data
​​​​​This is a subset of the EQUI File; see the EQUI documentation on the next pages for information on the structure, file name, formation and disposition, etc. ​ ​ ​ ​

​​​​​​ == 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 partici­pant, '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 re­gardless 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' = Indivi­dual 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' = Reim­bursable, '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 loca­tions, 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 Con­sent program, whereby employers may permit their data to be released in publica­tions, 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 re­lated 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 establish­ments; 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 employ­ment = 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 excep­tions; 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 tax­able 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 em­ployment 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 inconsisten­cies; 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 quar­ters 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., repre­senting 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 (show­ing 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

• ​​Enhanced Quarterly U-I Address File (ES2EQUI)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home