06 15 month output data job 025d file es2mo15

15-Month Output Data (Job 025D) File) (ES2MO15)

ES2MO15 - Length 181 - Revised 3/11/2005

​Columns ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	3	3		Char	MO15-CNTY	Base county FIPS code (for 2nd of five consecutive quarters)
4	4	1		Char	FILLER	space
5	10	6		Char	MO15-NAICS	Base NAICS code
11	11	1		Char	FILLER	space
12	13	2		Char	MO15-OWNER	Base 2-digit ownership code
14	14	1		Char	FILLER	space
15	45	31		Char	MO15-ACCT-NAME	Employer SESA ID and name, broken out in the format shown below
15	24	10R		Char	MO15-ACCT	U-I account number
25	29	5R		Num	MO15-RPT-UNIT	U-I reporting unit number
30	30	1R		Char	FILLER	space
31	45	15R		Char	MO15-FIRM-NAME	Employer legal name
15	45	31R		Char	MO15-FIRM-SUB-TOTAL	Redefinition of the Acct/Name block to list various sub-total counts; broken out below
15	37	23R		Char	MO15-ST-NAME	Sub-total field name
38	44	7R		Num	MO15-ST-COUNT	Count associated with this sub-total
45	45	1R		Char	MO15-ST-END	Trailing character following the count
46	46	1		Char	FILLER	space
47	73	27		Char	MO15-QTR1-DATA	Employment fields for the first of five quarters of data; breakout appears below
47	47	1R		Char	FILLER	space
48	55	8R		Num	MO15-MON1-EMPL	First month's employment in first quarter
56	56	1R		Char	FILLER	space
57	64	8R		Num	MO15-MON2-EMPL	Second month's employment in first quarter
65	65	1R		Char	FILLER	space
66	73	8R		Num	MO15-MON3-EMPL	Third month's employment in first quarter
74	100	27		Char	MO15-QTR2-DATA	Second quarter's employment data (broken out below)
74	74	1R		Char	FILLER	space
75	82	8R		Num	MO15-MON4-EMPL	First month's employment in second quarter
83	83	1R		Char	FILLER	space
84	91	8R		Num	MO15-MON5-EMPL	Second month's employment in second quarter
92	92	1R		Char	FILLER	space
93	100	8R		Num	MO15-MON6-EMPL	Third month's employment in second quarter
101	127	27		Char	MO15-QTR3-DATA	Third quarter's employment data (broken out below)
101	101	1R		Char	FILLER	space
102	109	8R		Num	MO15-MON7-EMPL	First month's employment in third quarter
110	110	1R		Char	FILLER	space
111	118	8R		Num	MO15-MON8-EMPL	Second month's employment in third quarter
119	119	1R		Char	FILLER	space
120	127	8R		Num	MO15-MON9-EMPL	Third month's employment in third quarter
128	154	27		Char	MO15-QTR4-DATA	Fourth quarter's employment data (broken out below)
128	128	1R		Char	FILLER	space
129	136	8R		Num	MO15-MON10-EMPL	First month's employment in fourth quarter
137	137	1R		Char	FILLER	space
138	145	8R		Num	MO15-MON11-EMPL	Second month's employment in fourth quarter
146	146	1R		Char	FILLER	space
147	154	8R		Num	MO15-MON12-EMPL	Third month's employment in fourth quarter
155	181	27		Char	MO15-QTR5-DATA	Fifth Quarter's employment data, broken out as shown below
155	155	1R		Char	FILLER	space
156	163	8R		Num	MO15-MON13-EMPL	First month's employment in fifth quarter
164	164	1R		Char	FILLER	space
165	172	8R		Num	MO15-MON14-EMPL	Second month's employment in fifth quarter
173	173	1R		Char	FILLER	space
174	181	8R		Num	MO15-MON15-EMPL	Third month's employment in fifth quarter
15-Month Output File Data Set Name:                   ES2.JOB25D.DATA Service Center DSN:           YBUssX.A145.JOB25D.DATA  ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          ES2MO15 ​This file is an optional output from the 25D (13-month firm list) job.  In this case, the data cover 15 months of employment rather than 13.  Since this volume of data would not be printable in a single detail line, the disk type output is the only option for a full five-quarter output.  Single-space filler characters are inserted to separate each of the fields, so they can be interpreted as space-delimited fields by PC applications such as an Excel spreadsheet.  Certain features that are available in the 13-month report are absent from the 15-month file output, such as inter-quarter code changes, status changes and MEEI changes.  The file is intended for longitudinal tracking of employment for establishments in external research-and-analysis applications.​ ​ ​ ​ ​ ​

Related Links

• Micro Omni (or Omnifarious) Auxiliary File (ES2MOA)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home