06 enhanced micro file without field compression es2emic

Enhanced Micro File (without field compression) (ES2EMIC)

ES2EMIC - Length 1604 - Revised 2/15/2018

Columns​ ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	15	15	Key	Char	EMIC-SESA-ID	State Employment Security Agency identification number of the micro record, subdivided below
1	10	10R	Key	Char	EMIC-ACCT	U-I Account number portion of the SESA ID, using numeric digits, right-justified with leading zeroes
11	15	5R	Key	Num	EMIC-RPT-UNIT	U-I Reporting unit number (RUN) value; '00000' = Single or multi-worksite master; '00001' – '99999' = Worksite sub-units
16	16	1		Char	EMIC-CK-DIGIT	Optional account number check digit (zero or blank if not used); numerics valid
17	25	9		Num	EMIC-EIN	9-digit federal employer identification number (EIN)
26	60	35		Char	EMIC-LEGAL-NAME	Employer legal or corporate name
61	95	35		Char	EMIC-TRADE-NAME	Trade name (or doing-business-as (DBA) name
96	96	1		Char	EMIC-SPECIAL-IND	Special account classification code; blank = Standard account, 'L' = Professional Employee Organization (PEO, aka Employee Leasing company), 'T' = Indian Tribal Council
​​​​Physical Location ​Address Area​​ ​ ​ ​ ​ ​
97	97	1		Char	EMIC-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)
98	98	1		Char	EMIC-PL-ADDR-SOURCE	Code denoting the origin of the following physical location address block
99	133	35		Char	EMIC-PL-ADDRESS	Employer physical location address street address
134	168	35		Char	EMIC-PL-ADDRESS2	Second line of employer physical location address
169	203	35		Char	EMIC-RPT-UNIT-DESCR	Reporting unit description (distinguishes worksites in terms recognized by employer)
204	233	30		Char	EMIC-PL-CITY	Physical location city
234	235	2		Char	EMIC-PL-STATE	Physical location state code
236	244	9		Char	EMIC-PL-ZIP	Physical location full 9-digit zip code
236	240	5R		Char	EMIC-PL-ZIP-5	Standard 5-digit physical location zip code
241	244	4R		Char	EMIC-PL-ZIP-4	Physical location Zip+4 extension
​​​​New Geocoding ​Data Area​​ ​ ​ ​ ​ ​
245	308	64		Char	EMIC-LOCATION-DATA	Version 7 geocoding administrative data fields, before change; breakouts follow
245	245	1R		Char	EMIC-NEW-GEOCODE-SOFTWARE	Latest geocoding software code; 'G' = standard BLS software usage; 'U' = State's own geocoding software utilized
246	246	1R		Char	EMIC-NEW-GEOCODE-SOURCE	Newer geocoding source indicator; 'B' = BLS-developed geocoding; 'S' = State-developed geocoding
247	249	3R		Char	EMIC-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
250	253	4R		Char	EMIC-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
254	261	8R		Num	EMIC-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)
262	270	9R		Num	EMIC-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 S999V999999 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)
271	273	3R		Num	EMIC-NEW-GEOCODE-YR-QTR	3-digit year/quarter in which the current longitude and latitude values were assigned (yyq format)
274	281	8R		Num	EMIC-NEW-PLA-DATE	Date in which the latest physical location address was entered (yyyymmdd format)
​​​​​​Older Geocoding ​Data Area​ ​ ​ ​ ​ ​
282	282	1R		Char	EMIC-OLD-GEOCODE-SOFTWARE	Software code for old geocode fields; 'G' = standard BLS software usage; 'U' = State geocoding software
283	283	1R		Char	EMIC-OLD-GEOCODE-SOURCE	Earlier geocoding source indicator; 'B' = data provided by BLS; 'S' = State geocoding
284	286	3R		Char	EMIC-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
287	290	4R		Char	EMIC-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
291	298	8R		Num	EMIC-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)
299	307	9R		Num	EMIC-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)
308	310	3R		Num	EMIC-OLD-GEOCODE-YR-QTR	3-digit earlier year/quarter in which the "old" longitude/latitude were assigned (yyq format)
​​​​​​Unemployment ​Insurance Address Area​ ​ ​ ​ ​ ​
311	311	1		Char	EMIC-UI-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
312	312	1		Char	EMIC-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
313	347	35		Char	EMIC-UI-ADDRESS	First street address line of the U-I tax address (normal mailing address)
348	382	35		Char	EMIC-UI-ADDRESS2	Second U-I street address line
383	412	30		Char	EMIC-UI-CITY	U-I address city
413	414	2		Char	EMIC-UI-STATE	U-I address state postal abbreviation
415	423	9		Char	EMIC-UI-ZIP	U-I address full 9-digit zip code
415	419	5R		Char	EMIC-UI-ZIP-5	U-I address standard 5-digit zip code
420	423	4R		Char	EMIC-UI-ZIP-4	U-I address Zip+4 extension
​​​​​Remaining ​Administrative Data Fields ​ ​ ​ ​ ​ ​
424	433	10		Num	EMIC-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
434	438	5		Char	EMIC-PHONE-EXT	Phone number extension (blank if missing or unused)
439	440	2		Num	EMIC-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
441	442	2		Num	EMIC-EXTRA-FIELD-LOCK	Additional multi-field batch update lockout indicator; values to be determined later
443	450	8		Num	EMIC-SETUP-DATE	Date on which account was established on the Micro File (or the U-I Tax File; yyyymmdd format)
451	458	8		Num	EMIC-INIT-LIAB-DATE	Date of initial liability or worksite effective date (yyyymmdd format)
459	466	8		Num	EMIC-END-LIAB-DATE	End-of-liability (termination) date (yyyymmdd format)
467	474	8		Num	EMIC-REACT-DATE	Date of reactivation (yyyymmdd format)
475	480	6		Char	EMIC-INFORMED-CONSENT	Group-level informed consent data, eventually used to bypass nondisclosure masking
475	476	2R		Char	EMIC-IC-CODE	Informed consent status code (values not yet listed)
477	478	2R		Char	EMIC-IC-START-YR	First year when participation with informed consent began
479	480	2R		Char	EMIC-IC-END-YR	Year when informed-consent participation was rescinded, if ever
481	484	4		Char	EMIC-ARS-RESP-CD-YR	Group-level annual refiling survey (ARS) response code and refiling year, broken out into the two fields shown below
481	482	2R		Char	EMIC-ARS-RESP-CODE	Refiling response code from Refiling File; blank = never selected for refiling survey
483	484	2R		Char	EMIC-REFILE-YEAR	Most recent refiling year; blank = never selected for refiling survey or no response
485	486	2		Char	EMIC-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)
487	490	4		Char	EMIC-EARS-BATCH-NUM	Batch number used for most recent refiling data entry with EARS system
491	503	13		Char	EMIC-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
491	493	3R		Char	EMIC-OLD-CNTY	FIPS county code from beginning of refiling cycle
494	494	1R		Char	EMIC-OLD-OWN	Most recent pre-refiling ownership code ('1' = Federal government, '2' = State govern­ment, '3' = Local government, '5' = Private industry)
495	497	3R		Char	EMIC-OLD-TOWN	Most recent pre-refiling New England township code; blank in other states
498	503	6R		Char	EMIC-OLD-NAICS	Most recent pre-refiling NAICS code; blank = Never refiled or no NAICS at beginning of refiling cycle
504	505	2R		Char	EMIC-NCA-RC	Non-classified account refiling response code
506	507	2R		Char	EMIC-COLL-MODE-IND	Collection mode indicator (CMI) code used for TRS refiling of eligible single accounts
508	512	5		Num	EMIC-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
513	513	1		Char	EMIC-CES	Indicator showing CES participation; blank = non-CES account, 'C' = CES reporter
514	514	1		Char	EMIC-ORG-TYPE	Private ownership organization type, 'C' = Corporation, 'I' = Individual proprietor, 'O' = Other organization, 'P' = Partnership, blank = Unknown organization
515	548	34		Char	EMIC-STATE-USAGE	Free-form area for auxiliary use by the state; not used in system reports
549	549	1		Char	EMIC-PL-ADDR-TYPE	Physical location address 'type' code, denoting the source of determination of the PLA
550	550	1		Char	EMIC-MWR-Q1-RCPT-SW	Flag to note receipt of future quarter MWR form (masters only), 'Y' = MWR received (usually set by ES2R screen)
551	551	1		Char	EMIC-MWR-Q2-RCPT-SW	Flag to note receipt of current quarter MWR form (masters only), 'Y' = form received (usually set by ES2R screen)
552	552	1		Char	EMIC-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
553	556	4		Char	EMIC-SIC	Standard Industrial Classification (SIC) code stored for the establishment as an admin­istrative data element until the 1987-based field is removed completely
​​​​​Quarterly Data ​Elements ​ ​ ​ ​ ​ ​
557	687	131		Char	EMIC-QTR-DATA(1)	Data for the future quarter, sub-defined below
557	559	3R		Char	EMICQ-YRQ(1)	Future quarter's year/quarter (yyq format, see next)
557	558	2R		Num	EMICQ-YR(1)	Future quarter's year
559	559	1R		Num	EMICQ-QTR(1)	Future quarter's quarter (1, 2, 3, or 4)
560	560	1R		Char	EMICQ-STATUS(1)	Activity status (future quarter), '1' = Active, '2' = Inactive, '9' = Pending activation
561	563	3R		Char	EMICQ-CNTY(1)	FIPS county code (newest quarter (as with all remaining fields listed below))
564	565	2R		Char	EMICQ-OWNER(1)	Ownership code; '10' = Federal government, '20' = State government, '30' = Local government, '50' – '59' = Private ownership
564	564	1R		Char	EMICQ-OWN1(1)	High-order ownership digit (1, 2, 3, or 5)
566	571	6R		Char	EMICQ-NAICS(1)	North American Industry Classification Code
572	572	1R		Char	EMICQ-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
573	576	4R		Char	EMICQ-ZONE(1)	Sub-county area (township or zone)
573	575	3R		Char	EMICQ-TOWN(1)	Township code (New England states and New Jersey)
577	578	2R		Num	EMICQ-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
579	579	1R		Char	EMICQ-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
580	584	5R		Num	EMICQ-PLACE(1)	5-digit place code (once known as a "city" code), denoting individual community names (found in Lookup File)
585	586	2R		Char	EMICQ-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)
587	601	15R		Num (with sign)	EMICQ-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
602	602	1R		Char	EMICQ-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
603	606	4R		Char	EMICQ-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
607	612	6R		Char	EMICQ-NAIC07(1)	Final 2007-based NAICS code after 2012 refiling; or a similar process for each additional revision (2012-2017, etc.)
613	613	1R		Char	EMICQ-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
614	614	1R		Char	EMICQ-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
615	615	1R		Char	EMICQ-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
616	620	5R		Num	EMICQ-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
621	626	6R		Num	EMICQ-M1-EMPL(1)	First month's employment for the quarter, a 6-digit value
627	627	1R		Char	EMICQ-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
628	633	6R		Num	EMICQ-M2-EMPL(1)	Second month's employment, a 6-digit value
634	634	1R		Char	EMICQ-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
635	640	6R		Num	EMICQ-M3-EMPL(1)	Third month's employment, a 6-digit value
641	641	1R		Char	EMICQ-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
642	647	6R		Char	EMICQ-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)
648	658	11R		Num	EMICQ-TOTAL-WAGE(1)	Total wages for the quarter, an 11-digit value
659	659	1R		Char	EMICQ-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)
660	670	11R		Num	EMICQ-TAX-WAGE(1)	11-digit taxable wage field for the quarter (this will be set to zero for non-experience-rated establishments)
671	671	1R		Char	EMICQ-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
672	680	9R		Num	EMICQ-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)
681	681	1R		Char	EMICQ-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
682	687	6R		Char	EMICQ-COMMENT-CODE(1)	Comment codes (up to three 2-byte codes)
682	683	2R		Char	EMICQ-CMNT1(1)	First comment code
684	685	2R		Char	EMICQ-CMNT2(1)	Second comment code
686	687	2R		Char	EMICQ-CMNT3(1)	Third comment code
688	818	131		Char	EMIC-QTR-DATA(2)	Data for the current quarter, with same layout as shown above
819	949	131		Char	EMIC-QTR-DATA(3)	Data for the prior quarter, in the same format
950	1080	131		Char	EMIC-QTR-DATA(4)	Data for second prior quarter
1081	1211	131		Char	EMIC-QTR-DATA(5)	Data for last year's future quarter
1212	1342	131		Char	EMIC-QTR-DATA(6)	Data for last year's current quarter
1343	1473	131		Char	EMIC-QTR-DATA(7)	Data for last year's prior quarter
1474	1604	131		Char	EMIC-QTR-DATA(8)	Data for last year's second prior quarter
Enhanced Micro Output File Data Set Name:                   ES2.V9E.MICRO.COPY Service Center DSN:           YBUssX.A145.V9E.MICRO.COPY, ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          ES2EMIC The Enhanced Micro (EMIC) Output File is essentially the same as the standard Micro File, except that all of the fields that had been compressed, either by packing or conversion to binary format, have been re-expanded.  This causes the expanded version of the file to have over 22% longer records than the production Micro File.  The EMIC File is most useful for States in developing more modern extract programs or for running external queries on micro-level data.  The standard Micro File is difficult to use in a PC transfer due to the compressed fields; these often will not translate correctly, or can cause additional problems in external processing.  The Enhanced Micro File has no compressed fields, so can be readily processed on any platform. ​Job 076E has been developed to convert the Micro File to the Enhanced Micro format.  This job can be run at any time.  The output file can be FTP'ed to the PC/LAN and processed from there.  Due to the expanded size, such FTP's will take a considerable amount of time.  The file can also be written to a tape cartridge, which can be uploaded to another mainframe (if the job is run at SunGard, but the data are needed on a local mainframe, for instance). ​ ​ ​ ​ ​

Related Links

• ​​EQUI Predecessor/Successor Sub-File (ES2EQPS)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home