06 micro file es2mic

Micro File (ES2MIC)

ES2MIC - Length 1310 - Revised 1/30/2019

Columns		Len	Key	Type	COBOL Field Name	Description & Notes
1	15	15	Key	Char	MIC-SESA-ID	State Employment Security Agency identification number of the micro record, subdivided below
1	10	10R	Key	Char	MIC-ACCT	U-I Account number portion of the SESA ID, using numeric digits, right-justified with leading zeroes
11	15	5R	Key	Num	MIC-RPT-UNIT	U-I Reporting unit number (RUN) value; '00000' = Single or multi-worksite master; '00001' – '99999' = Worksite sub-units
16	16	1		Char	MIC-CK-DIGIT	Optional account number check digit (zero or blank if not used); numerics valid
17	20	4		Comp	MIC-EIN	9-digit federal employer identification number (EIN)
21	55	35		Char	MIC-LEGAL-NAME	Employer legal or corporate name
56	90	35		Char	MIC-TRADE-NAME	Trade name (or doing-business-as (DBA) name
91	91	1		Char	MIC-SPECIAL-IND	Special account classification code; blank = Standard account, ‘L’ = Professional Employee Organization (PEO, aka Employee Leasing company), ‘T’ = Indian Tribal Council; ‘M’ = Cannabis producer; ‘Y’ = Combination PEO and Cannabis; ‘Z’ = Combination Indian Tribal and Cannabis
Physical Location Address Area​ ​ ​ ​ ​ ​
92	92	1		Char	MIC-NEW-CHNGD-ADDR-IND	New or changed physical address switch; 'Y' = New or modified physical address (may be needed in state processing to adjust sub-county zone or township assignments)
93	93	1		Char	MIC-PL-ADDR-SOURCE	Code denoting the origin of the following physical location address block
94	128	35		Char	MIC-PL-ADDRESS	Employer physical location address street address
129	163	35		Char	MIC-PL-ADDRESS2	Second line of employer physical location address
164	198	35		Char	MIC-RPT-UNIT-DESCR	Reporting unit description (distinguishes worksites in terms recognized by employer)
199	228	30		Char	MIC-PL-CITY	Physical location city
229	230	2		Char	MIC-PL-STATE	Physical location state code
231	239	9		Char	MIC-PL-ZIP	Physical location full 9-digit zip code
231	235	5R		Char	MIC-PL-ZIP-5	Standard 5-digit physical location zip code
236	239	4R		Char	MIC-PL-ZIP-4	Physical location Zip+4 extension
New Geocoding Data Area​ ​ ​ ​ ​ ​
240	282	43		Char	MIC-LOCATION-DATA	Version 7 geocoding administrative data fields, before change; breakouts follow
240	240	1R		Char	MIC-NEW-GEOCODE-SOFTWARE	Latest geocoding software code; 'G' = standard BLS software usage; 'U' = State's own geocoding software utilized
241	241	1R		Char	MIC-NEW-GEOCODE-SOURCE	Newer geocoding source indicator; 'B' = BLS-developed geocoding; 'S' = State-developed geocoding
242	244	3R		Char	MIC-NEW-LOCATION-CODE	More recent geographic location code; Made up of two-byte alpha code for geographic area used, plus numeric digit for degree of certainty; two-byte values are- 'AS' = Address by house range; 'AX' = Address intersection; 'ZB' = Block zip code centroid; 'ZC' = Unclassified Census zip-code centroid; 'ZT' = Census tract zip code centroid
245	248	4R		Char	MIC-NEW-MATCH-CODE	Newer matching code, a data reliability indicator; comprised of letter code and 3-digit number for method of code determination; letter codes are- 'A' = Match to Alias or alternate record from USPS data; 'D' = Small town with PO box or General Delivery address; 'S' = Directly matched to USPS data; 'T' = Zip code Street segment match; 'U' = USPS match, but ZIP+4 dependent on firm name; 'X' = Match on street intersection; 'Y' = Matched to intersection using street name alias; 'Z' = Zip code verified, but no address provided
249	252	4R		Comp	MIC-NEW-LATITUDE	Most recent geographic latitude, measured in millionths of a degree (1/1,000,000° is equivalent to about 4.3 inches; 99V999999 format can convert easily to the display 99.999999 format)
253	256	4R		Comp	MIC-NEW-LONGITUDE	Latest geographic longitude, measured to the nearest millionth of a degree (±0.002 of an arc second, supposedly accurate to ±2 inches (5 cm, east-west); stored in the S999V99999 format for ready conversion to the display +999.999999 format); longitudes in the Western Hemisphere appear as negative values, allowing them to graph properly (so that higher-numbered longitudes run to the left)
257	258	2R		Pack	MIC-NEW-GEOCODE-YR-QTR	3-digit year/quarter in which the current longitude and latitude values were assigned (yyq format)
259	263	5R		Pack	MIC-NEW-PLA-DATE	Date in which the latest physical location address was entered (yyyymmdd format)
Older Geocoding Data Area​ ​ ​ ​ ​ ​
264	264	1R		Char	MIC-OLD-GEOCODE-SOFTWARE	Software code for old geocode fields; 'G' = standard BLS software usage; 'U' = State geocoding software
265	265	1R		Char	MIC-OLD-GEOCODE-SOURCE	Earlier geocoding source indicator; 'B' = data provided by BLS; 'S' = State geocoding
266	268	3R		Char	MIC-OLD-LOCATION-CODE	Older geographic location code; Made up of two-byte alpha code for geographic area used, plus numeric digit for degree of certainty; two-byte values are- 'AS' = Ad­dress by house range; 'AX' = Address intersection; 'ZB' = Block zip code centroid; 'ZC' = Unclassified Census zip-code centroid; 'ZT' = Census tract zip code centroid
269	272	4R		Char	MIC-OLD-MATCH-CODE	Past matching code, a data reliability indicator; comprised of letter code and 3-digit number for method of code determination; letter codes are- 'A' = Match to Alias or alternate record from USPS data; 'D' = Small town with PO box or General Delivery address; 'S' = Directly matched to USPS data; 'T' = Zip code Street segment match; 'U' = USPS match, but ZIP+4 dependent on firm name; 'X' = Match on street intersection; 'Y' = Matched to intersection using street name alias; 'Z' = Zip code verified, but no address provided
273	276	4R		Comp	MIC-OLD-LATITUDE	Previous geographic latitude, in millionths of a degree (each equivalent to about 4.3 inches, north-and-south; 99V999999 format converts to display 99.999999 format)
277	280	4R		Comp	MIC-OLD-LONGITUDE	Older geographic longitude, given to the millionth of a degree (which ought to be accu­rate to within 2 inches or less; the S999V999999 stored format converts to a dis­play format of +999.999999); Western Hemisphere longitudes are listed as nega­tive values, which graph properly (so that higher-valued longitudes are shown to the left)
281	282	2R		Pack	MIC-OLD-GEOCODE-YR-QTR	3-digit earlier year/quarter in which the "old" longitude/latitude were assigned (yyq format)
Unemployment Insurance Address Area​ ​ ​ ​ ​ ​
283	283	1		Char	MIC-ADDR-TYPE	Unemployment Insurance (U-I) address type code (used internally, but not sent on EQUI); '1' = Physical address, '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown or unverified type of address
284	284	1		Char	MIC-MAIL-CODE	Mailing indicator code; blank = Mail every quarter, '1' = Mail once annually, during first calendar quarter only; '2' = Mail annually during second calendar quarter; '3' = Mail annually during third calendar quarter; '4' = Mail annually during fourth calendar quarter; 'Y' = Mail every quarter, 'N' = Never mail to this employer
285	319	35		Char	MIC-UI-ADDRESS	First street address line of the U-I tax address (normal mailing address)
320	354	35		Char	MIC-UI-ADDRESS2	Second U-I street address line
355	384	30		Char	MIC-UI-CITY	U-I address city
385	386	2		Char	MIC-UI-STATE	U-I address state postal abbreviation
387	395	9		Char	MIC-UI-ZIP	U-I address full 9-digit zip code
387	391	5R		Char	MIC-UI-ZIP-5	U-I address standard 5-digit zip code
392	395	4R		Char	MIC-UI-ZIP-4	U-I address Zip+4 extension
396	401	6		Pack	MIC-PHONE-NUM	10-digit group-level phone number identifier, comprised of the 3-digit area code, 3-digit exchange, and 4-digit suffix; these are not sub-defined here because of the packed numerics; a missing phone number will appear as zeroes
402	406	5		Char	MIC-PHONE-EXT	Phone number extension (blank if missing or unused)
407	408	2		Num	MIC-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
409	410	2		Num	MIC-EXTRA-FIELD-LOCK	Additional multi-field batch update lockout indicator; currently this can be used to lock the initial liability date and/or the end-of-liability date; like its predecessor, this field is the sum of the following numeric values:  00 = No date fields locked; 01 = Initial liability date locked; 02 = End-of-liability date locked
411	415	5		Pack	MIC-SETUP-DATE	Date on which account was established on the Micro File (or the U-I Tax File; yyyymmdd format)
416	420	5		Pack	MIC-INIT-LIAB-DATE	Date of initial liability or worksite effective date (yyyymmdd format)
421	425	5		Pack	MIC-END-LIAB-DATE	End-of-liability (termination) date (yyyymmdd format)
426	430	5		Pack	MIC-REACT-DATE	Date of reactivation (yyyymmdd format)
431	436	6		Char	MIC-INFORMED-CONSENT	Group-level informed consent data, eventually used to bypass nondisclosure masking
431	432	2R		Char	MIC-IC-CODE	Informed consent status code (values not yet listed)
433	434	2R		Char	MIC-IC-START-YR	First year when participation with informed consent began
435	436	2R		Char	MIC-IC-END-YR	Year when informed-consent participation was rescinded, if ever
437	440	4		Char	MIC-ARS-RESP-CD-YR	Group-level annual refiling survey (ARS) response code and refiling year, broken out into the two fields shown below
437	438	2R		Char	MIC-ARS-RESP-CODE	Refiling response code from Refiling File; blank = never selected for refiling survey
439	440	2R		Char	MIC-REFILE-YEAR	Most recent refiling year; blank = never selected for refiling survey or no response
441	442	2		Char	MIC-VERIFY-YEAR	Most recent refiling year with a usable response code (i.e., a verification of this establishment's industry classification, namely a response code 41, 42, 46, or 50)
443	446	4		Char	MIC-EARS-BATCH-NUM	Batch number used for most recent refiling data entry with EARS system
447	459	13		Char	MIC-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 the 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
447	449	3R		Char	MIC-OLD-CNTY	FIPS county code from beginning of refiling cycle
450	450	1R		Char	MIC-OLD-OWN	Most recent pre-refiling ownership code ('1' = Federal government, '2' = State govern­ment, '3' = Local government, '5' = Private industry)
451	453	3R		Char	MIC-OLD-TOWN	Most recent pre-refiling New England township code; blank in other states
454	459	6R		Char	MIC-OLD-NAICS	Most recent pre-refiling NAICS code; blank = Never refiled or no NAICS at beginning of refiling cycle
460	461	2R		Char	MIC-NCA-RC	Non-classified account refiling response code
462	463	2R		Char	MIC-COLL-MODE-IND	Collection mode indicator (CMI) code used for TRS refiling of eligible single accounts
464	466	3		Pack	MIC-MAX-RPT-UNIT	5-digit value showing the largest (highest-numbered) RUN encountered so far; only useful in RUN 00000 accounts (masters and singles (possibly collapsed masters)); worksites will show zeroes in this field
467	467	1		Char	MIC-CES	Indicator showing CES participation; blank = non-CES account, 'C' = CES reporter
468	468	1		Char	MIC-ORG-TYPE	Private ownership organization type, 'C' = Corporation, 'I' = Individual proprietor, 'O' = Other organization, 'P' = Partnership, blank = Unknown organization
469	502	34		Char	MIC-STATE-USAGE	Free-form area for auxiliary use by the state; not used in system reports
503	503	1		Char	MIC-PL-ADDR-TYPE	Physical-Address Address Type Code ('B' = BLS-approved bypass; 'C' = County-confirmed PLA; 'G' = Government facility only; 'P' = PLA is approved but not geocoded; 'R' = Residence; 'S' = Sales agent working out of area; '  ' = other)
504	504	1		Char	MIC-MWR-Q1-RCPT-SW	Flag to note receipt of future quarter MWR form (masters only), 'Y' = MWR received (usually set by ES2R screen)
505	505	1		Char	MIC-MWR-Q2-RCPT-SW	Flag to note receipt of current quarter MWR form (masters only), 'Y' = form received (usually set by ES2R screen)
506	506	1		Char	MIC-WAGE-IND	Indicator showing most recent Wage Summary quarter available, '1' = Wage data pre­sent for future quarter, '2' = -current quarter, '3' = prior quarter, '4' 2nd prior quarter, '5' = 3rd prior quarter, '6' = year-ago current quarter, '7' = Year-ago prior quarter; '8' = 2nd prior quarter, year ago
507	510	4		Char	MIC-SIC	Standard Industrial Classification (SIC) code stored for the establishment as an admin­istrative data element until the 1987-based field is removed completely
511	610	100		Char	MIC-QTR-DATA(1)	Data for the future quarter, sub-defined below
511	513	3R		Char	MICQ-YRQ(1)	Future quarter's year/quarter (yyq format, see next)
511	512	2R		Num	MICQ-YR(1)	Future quarter's year
513	513	1R		Num	MICQ-QTR(1)	Future quarter's quarter (1, 2, 3, or 4)
514	514	1R		Char	MICQ-STATUS(1)	Activity status (future quarter), '1' = Active, '2' = Inactive, '9' = Pending activation
515	517	3R		Char	MICQ-CNTY(1)	FIPS county code (newest quarter (as with all remaining fields listed below))
518	519	2R		Char	MICQ-OWNER(1)	Ownership code; '10' = Federal government, '20' = State government, '30' = Local government, '50' – '59' = Private ownership
518	518	1R		Char	MICQ-OWN1(1)	High-order ownership digit (1, 2, 3, or 5)
520	525	6R		Char	MICQ-NAICS(1)	North American Industry Classification Code
526	526	1R		Char	MICQ-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
527	530	4R		Char	MICQ-ZONE(1)	Sub-county area (township or zone)
527	529	3R		Char	MICQ-TOWN(1)	Township code (New England states and New Jersey)
531	532	2R		Num	MICQ-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; 02 = Economic NAICS change; 04 = Economic owner change; 08 = Economic county change; valid range is 00 through 15
533	533	1R		Char	MICQ-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
534	536	3R		Pack	MICQ-PLACE(1)	5-digit place code (once known as a "city" code), denoting individual community names (found in Lookup File)
537	538	2R		Char	MICQ-PLACE-CLASS(1)	Place class code, an identification of the type of municipality or other community/place classification; comprised of two one-byte fields, the first a letter code, the second a numeric digit (which is not present for some letter codes; letter code values include- 'A' = Airports (range of A1 to A5), 'B' = Post  Offices not corresponding to other locational entities; 'C' = Incorporated places (range of C1 to C9); 'D' = American Indian areas (range of D1-D9); 'E' = Alaska Native Areas (range of E1 to E7); 'G' = Nongovernment Facilities; 'H' = Counties and County Equivalents (range of H1 to H6); 'M' = Federal Facilities (range of M1 to M9); 'N' = State, Local Govern­ment Facilities (range of N1 to N9); 'S' = Surface Transportation Facilities; 'T' = Active Minor Civil Divisions (range of T1 to T5); 'U' = Unincorporated, but populated (Community) Places (Except Those Associated with Facilities; range of U1 to U9); 'X' = Obsolete or Incorrect Names or Entities (range of X1 to X6); 'Z' = Inactive or Nonfunctioning Primary County Divisions (range of Z1 to Z8)
539	546	8R		Pack (with sign)	MICQ-CENSUS-BLOCK(1)	15-digit composite Census Block (Census Bureau standard for geocoding) field; the digits comprising this field are: 1-2 = State FIPS; 3-5 = County FIPS; 6-9 = Census tract; 10-11 = Census tract suffix; 12-15 = Census block number; since the com­posite census block is a packed fields, the sub-fields are not listed separately in the field definitions here; they must be broken out in working storage; Note:  This is listed as a signed field; a negative value in the census block indicates that the block number portion of the field (the final four digits) should be blanked out; in some instances, the first of the four digits is still present, but the last three are blank (the significance of these listings is not yet known, but a '0…' entry ( with a leading zero followed by three spaces) can not be represented in the EXPO system
547	547	1R		Char	MICQ-DATA-SOURCE(1)	Data source code used to denote EDI participation or representation of data from a web collection facility; 'C' = CENCO-authorized EDI collected data; 'E' = standard EDI collected data; 'M' = MWR data collected from website; 'Q' = QCR data were collected from website; 'S' = Data collected from State media; 'X' = Formerly an EDI participant, now no longer in the program
548	551	4R		Char	MICQ-AGENT-CODE(1)	Agent code denoting the use of a payroll provider service or similar agency; value does not roll forward with quarter shift process
552	557	6R		Char	MICQ-NAIC12(1)	Final 2012-based NAICS code after 2017 refiling; if involved in the 2017 NAICS revi­sion, this could convert to a different NAICS value under 2017 coding; only valid for 17/1 quarter
558	558	1R		Char	MICQ-EDIT-FLAG(1)	Edit flag notes whether editing is required, or has been performed; 'N' = Edits have not been run, or account has a crucial-level edit exception; 'Y' = Editing is complete
559	559	1R		Char	MICQ-EST-FLAG(1)	Estimation flag denotes the status of estimations for the account; 'N' = Estimations have not been performed; 'Y' = estimation complete; 'F' = Estimates failed
560	560	1R		Char	MICQ-DELQ-FLAG(1)	Delinquency flag indicates the presence or absence of reported data; 'N' = Account is partially or fully reported (for inactive accounts, this field is immaterial); 'Y' = None of the employment fields, nor the total wage field, has reported data
561	563	3R		Pack	MICQ-TAX-RATE(1)	Firm's tax rate, a 5-digit value, given in 100,000ths and redefined as 1000ths of a percent; the two formats are 99V999 (for percentage) and V99999 (for fraction of the whole); sample: 2⅝% appears as 02625, interpreted as 2.625% or 0.02625
564	567	4R		Pack	MICQ-M1-EMPL(1)	First month's employment for the quarter, a 6-digit value
568	568	1R		Char	MICQ-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), 'K' = Special estimate related to natural disaster, '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
569	572	4R		Pack	MICQ-M2-EMPL(1)	Second month's employment, a 6-digit value
573	573	1R		Char	MICQ-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), 'K' = Special estimate related to natural disaster, '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
574	577	4R		Pack	MICQ-M3-EMPL(1)	Third month's employment, a 6-digit value
578	578	1R		Char	MICQ-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), 'K' = Special estimate related to natural disaster, '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
579	584	6R		Char	MICQ-STATE-USAGE(1)	Free-form quarterly state usage field; included in some EXPO reports (for states using numeric values here, they may be summed in the reports that include the field)
585	590	6R		Pack	MICQ-TOTAL-WAGE(1)	Total wages for the quarter, an 11-digit value
591	591	1R		Char	MICQ-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), 'K' = Special estimate related to natural disaster, 'L' = Late reported (replacing an estimate), 'M' = Missing, 'N' = Estima­tion 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)
592	597	6R		Pack	MICQ-TAX-WAGE(1)	11-digit taxable wage field for the quarter (this will be set to zero for non-experience-rated establishments)
598	598	1R		Char	MICQ-TAXW-IND(1)	Taxable wage indicator flag; blank = reported, 'C' = Changed (re-reported), 'E' = esti­mated, 'H' = Hand-estimated (vrs. machine-generated), 'K' = Special estimate related to natural disaster, 'L' = Late reported  (replacing an estimate), 'M' = Mis­sing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'X' = was non-numeric, changed to zeroes
599	603	5R		Pack	MICQ-CONTRIB-DUE(1)	9-digit U-I contributions due (assessed contributions) for the quarter (zero for non-experience-rated establishments (with the possible exception of reimbursables with employee contributions)
604	604	1R		Char	MICQ-CTRB-IND(1)	Contributions due indicator flag; blank = reported, 'C' = Changed (re-reported), 'E' = estimated, 'H' = Hand-estimated (vrs. machine-generated), 'K' = Special estimate related to natural disaster, 'L' = Late reported (replacing an estimate), 'M' = Mis­sing, 'N' = Estimation failed due to long-term delinquency, 'P' = Prorated worksite from master, 'R' = Reported (possibly locked), 'X' = was non-numeric, changed to zeroes
605	610	6R		Char	MICQ-COMMENT-CODE(1)	Comment codes (up to three 2-byte codes)
605	606	2R		Char	MICQ-CMNT1(1)	First comment code
607	608	2R		Char	MICQ-CMNT2(1)	Second comment code
609	610	2R		Char	MICQ-CMNT3(1)	Third comment code
611	710	100		Char	MIC-QTR-DATA(2)	Occurrence 2 (Current Quarter data, in same format as shown above)
711	810	100		Char	MIC-QTR-DATA(3)	Occurrence 3 (Prior Quarter data)
811	910	100		Char	MIC-QTR-DATA(4)	Occurrence 4
911	1010	100		Char	MIC-QTR-DATA(5)	Occurrence 5
1011	1110	100		Char	MIC-QTR-DATA(6)	Occurrence 6
1111	1210	100		Char	MIC-QTR-DATA(7)	Occurrence 7
1211	1310	100		Char	MIC-QTR-DATA(8)	Occurrence 8 – which is invisible on the ES2C screens
Micro File Data Set Name:                   WS.ES202.MICRO Service Center DSN:           YBUssX.A145.MICRO, ('ss' = State FIPS code) Type of File:                         VSAM indexed File Layout:                          ES2MIC CICS ID:                               ES2MIC (standard); EssMIC (Service Center; ss=State) The Micro File is generally considered to be the heart of the EXPO-QCEW system, since virtually all other data sources, reports, etc., are derived from the original Micro File data. One record is present for each establishment in the State, whether single, master, or worksite, regardless of ownership code or type of coverage (except that non-covered accounts, such as non-profit organizations and private household businesses are generally not tracked by most states).  The eight quarters of employment and wage data, combined with the address, phone number, and other administrative data, form the primary basis for the Quarterly Census of Employment and Wages. Updates to this file are numerous and varied.  On-line updates occur frequently in the four ES2C screens, which were designed to display and allow updates to all micro data. The ES2D screen permits updates to micro records included in a specific macro cell.  ES2E allows updates to accounts with micro edit exceptions.  ES2H has worksite proration and data removal features.  ES2P has a means of restoring micro data from the Transaction Files.  ES2R facilitates multi-worksite data entry from MWR forms.  ES2V enables worksite changes or additions using a pattern record.  EARC can transfer refiling code changes to the Micro File as well. On the batch side, IMT processing jobs (001D, 001Q, 001S, and 001X) bring in external information, generally from either the U-I tax file or from other "keypunch" data sources.  Estimation jobs (001D, 001Q, 001S, 002D, 002F, 242D) help to fill in the blanks, by estimating for individual employment or wage fields that are absent from IMT data, or even for fully delinquent accounts.  Micro editing jobs (001D, 001Q, 002D, 002F, 028D, 028S, 242D) generally only adjust flag settings, since they are intended to examine the data as they exist; however, some obvious typographic errors (such as a date of September 31) are automatically overridden as well.  Job 013D applies refiling code change data to the micro records.  Job 026D allows micro data to be restored from Transaction File data in the event of a data failure and subsequent back-up file retrieval for the Micro File. ​When an account becomes inactive on the Micro File, the status is changed to '2', but it is retained on the file to keep its historical information intact.  Once the quarter shift process (in Job 001Q) has brought the account to the point where all quarters are inactive, the record is deleted from the file.  The account is considered to have "rolled off," since there is no longer any historical information that needs to be preserved.  However, the delete action is not sent to BLS via the EQUI, since their own extended history (i.e., the Longitudinal Data Base) requires that the account be on file much longer; a deletion enacted prematurely could bring unfortunate consequences to their data. ​ ​ ​ ​ ​

Related Links

• Micro Edit File (ES2MIED) ​​
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home