06 micro sequential data file es2mcdt

Micro Sequential Data File (ES2MCDT)

ES2MCDT - Length 572 - Revised 2/14/2018

​Columns​		Len	Key	Type	COBOL Field Name	Description & Notes
1	15	15		Char	MCDT-SESA-ID	SESA ID of micro sequential data record, subdivided below
1	10	10R		Char	MCDT-ACCT	U-I account number
11	15	5R		Num	MCDT-RPT-UNIT	Reporting unit number, 00000 = Single or master account, 00001-99999 = Worksite
16	16	1		Char	MCDT-CK-DIGIT	Check digit for the account
17	21	5		Char	MCDT-YEARQ	Year and quarter for selected data (yyyyq format)
22	24	3		Char	MCDT-COUNTY	FIPS County code
25	26	2		Char	MCDT-OWNER	Ownership code, '10' = Federal, '20' = State, '30' = Local, '50' = Private
27	32	6		Char	MCDT-NAICS	North American Industry Classification System (NAICS) code; or SIC with filler
33	36	4		Char	MCDT-ZONE	Sub-county zone or township (if the latter, last digit is blank)
37	37	1		Char	FILLER	space
38	72	35		Char	MCDT-PRIMARY-NAME	Trade/DBA name
73	107	35		Char	MCDT-SECONDARY-NAME	Legal/corporate name
108	142	35		Char	MCDT-ADDRESS	Physical location street address
143	177	35		Char	MCDT-ADDRESS2	Physical location second street address line
178	205	28		Char	MCDT-CITY	Physical location city
206	207	2		Char	MCDT-STATE	Physical location state postal abbreviation
208	216	9		Char	MCDT-ZIP-CODE	Full 9-digit physical location zip code, broken out below
208	212	5R		Char	MCDT-ZIP-5	Physical location zip code
213	216	4R		Char	MCDT-ZIP-4	Physical location Zip+4 extension
217	251	35		Char	MCDT-RPT-UNIT-DESCR	Worksite reporting unit description
252	286	35		Char	MCDT-CONTACT-NAME	Contact person, department or agency
287	321	35		Char	MCDT-UI-ADDRESS	U-I mailing address street address or P.O. box number
322	356	35		Char	MCDT-UI-ADDRESS2	Second U-I street address line
357	384	28		Char	MCDT-UI-CITY	U-I mailing address city
385	386	2		Char	MCDT-UI-STATE	U-I mailing state code
387	395	9		Char	MCDT-UI-ZIP-CODE	Full 9-digit U-I zip code, broken out into the fields shown below
387	391	5R		Char	MCDT-UI-ZIP-5	U-I mailing address zip code
392	395	4R		Char	MCDT-UI-ZIP-4	U-I mailing address ZIP+4 extension
396	405	10		Char	MCDT-PHONE-NUMBER	Complete 10-digit phone number, broken out into sub-fields below
396	398	3R		Char	MCDT-PHONE-AREA	Phone number area code
399	401	3R		Char	MCDT-PHONE-PREFIX	Phone number exchange or prefix
402	405	4R		Char	MCDT-PHONE-SUFFIX	Phone number suffix
406	406	1		Char	MCDT-STATUS	Activity status code for quarter, '1' = Active, '2' = Inactive, '9' = Pending
407	407	1		Char	MCDT-TYPE-COV	Type of coverage code, '0' = Experience-rated, '1' = Reimbursable, '2' = Experience-rated with employee contributions, '3' = Reimbursable with employee contribs., '8' = Non-subject (non-taxable) employer, '9' = Federal government account
408	408	1		Char	MCDT-MEEI	MEEI code, '1' = Single, '2' = Master, '3' = Worksite, '4' = Refusal, '5' = Composite worksite, '6' = Non-breakout due to low employment
409	414	6		Num	MCDT-EMPL1	First month's employment (selected quarter)
415	420	6		Num	MCDT-EMPL2	Second month's employment
421	426	6		Num	MCDT-EMPL3	Third month's employment
427	437	11		Num	MCDT-TOTAL-WAGE	Total wages
438	448	11		Num	MCDT-TAX-WAGE	Taxable wages
449	457	9		Num	MCDT-CONTRIB	Contributions assessed
458	463	6		Char	MCDT-STATE-USE	Quarterly state usage field
464	469	6		Char	MCDT-COMMENT	Micro comment codes for quarter
470	475	6		Char	MCDT-INDUSTRY	The corresponding SIC or NAICS code to the NAICS or SIC code carried in cols 27-32
476	484	9		Char	MCDT-EIN	Federal Employer Identification Number (EIN) for this employer
485	495	11		Num	MCDT-LONGITUDE	Geographic longitude of the business; format +999.999999; negative means Western Hemisphere; accuracy is supposedly to +/- 3 inches
496	504	9		Num	MCDT-LATITUDE	Geodetic latitude of the business location; 99.999999 format, with a supposed level of accuracy to within 4 inches
505	508	4		Char	MCDT-MATCH-CODE	Geographic data match code; a data reliability indicator; formed by a 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 seg­ment 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
509	511	3		Char	MCDT-LOCATION-CODE	Geographic location code; Made up of a 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
512	516	5		Char	MCDT-PLACE-CODE	Formerly known as the "City" code, this field identifies a community or geography-related entity
517	518	2		Char	MCDT-PLACE-CLASS	Classification code to identify the type of geographic area represented by the above place code (i.e., city, town, airport, etc.)
519	522	4		Char	FILLER	spaces
523	537	15		Char	MCDT-CENSUS-BLOCK	Sub-classification of the census tract to define a minute area within the tract
538	572	35		Char	MCDT-STATE-USAGE	Administrative state usage field
Micro Output Data File Data Set Name:                   WS.ES202.MICRO.DATA1, -2, . . . , -9 Service Center DSN:           YBUssX.A145.MICRO.DATAn, ('ss' = State FIPS code; 'n' = numeric value 1 through 9) Type of File:                         Sequential File Layout:                          ES2MCDT ​This file is an optional output for Job 20D Micro Selection Parameter processing runs.  The files are made available for download to a PC or writing to a tape cartridge, so that the micro data can be forwarded to another platform (PC or State mainframe) for specialized processing external to EXPO.  As listed in the dataset names, it is possible to have up to nine of these files produced by a single Job 20D run, depending on the number of parameter sets processed and the output types selected.  Unlike many temporary files, these are not automatically deleted at the end of the job run, specifically to keep them available for external processing.  The files are only uncatalogued and deleted during the next Job 20D run (unless they are removed automatically by the disk pack definition, which may be set up to expunge all files after they have been on file for a specific number of days).​ ​ ​ ​ ​

Related Links

• Micro Edit Cross-Reference File (ES2MEXR)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home