06 ​​second almis extract file es2alm2

Second ALMIS Extract File (ES2ALM2)

ES2ALM2 - Length 142 - Revised 8/2/2002

​Columns​ ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	2	2		Char	ALM2-STATE-FIPS	Not used by EXPO
3	4	2		Char	ALM2-AREA-TYPE	Type code for geographic area definition; unknown values
5	10	6		Char	ALM2-CNTY	Combination of two county codes
5	7	3R		Char	ALM2-AREA-CNTY	County FIPS code #1
8	10	3R		Char	ALM2-AREA-CNTY2	Second County FIPS code; unknown usage
11	14	4		Char	ALM2-YRQ	Unknown usage
11	14	4R		Char	ALM2-YEAR	Year for ALMIS data
15	16	2		Char	ALM2-PERIOD-TYPE	Type of time period used for data; unknown usage
17	18	2		Char	ALM2-QTR	Set of two quarter codes, broken out below
17	17	1R		Char	ALM2-QTR1	First of two quarters; unknown usage
18	18	1R		Char	ALM2-QTR2	Second quarter code
19	20	2		Char	ALM2-INDCDTY	Industry code type; unknown usage
21	26	6		Char	ALM2-NAICS	Current NAICS code under review; may be subdivided into SIC and filler, below
21	24	4R		Char	ALM2-SIC	SIC portion of NAICS code just listed
21	21	1R		Char	ALM2-SIC1	First digit of industry code (SIC or NAICS)
22	22	1R		Char	ALM2-SIC2	Second digit of industry code
23	23	1R		Char	ALM2-SIC3	Third digit of industry code
24	24	1R		Char	ALM2-SIC4	Fourth digit of industry code
25	25	1R		Char	ALM2-IND5	Fifth digit of NAICS code
26	26	1R		Char	ALM2-IND6	Sixth digit of NAICS code
27	28	2		Char	ALM2-OWNER	Full ownership code definition ('10', '20', '30', '50' – '59'); sub-divided below
27	27	1R		Char	ALM2-OWN	Single-byte ownership identifier
28	28	1R		Char	ALM2-OWN2	Second digit of ownership code; generally set to zero
29	36	8		Num	ALM2-FIRMS	Individual U-I account numbers used to make up this macro-level data; this field is able to handle up to 100,000,000 firms
37	44	8		Num	ALM2-ESTAB	Number of establishments (singles and worksites) comprising the macro data; to 100M
45	53	9		Num	ALM2-EMPLOY	Summed employment (AME?); can handle up to a billion employees
54	62	9		Num	ALM2-MONTH1	Summed first-month employment for the quarter (same 1,000,000,000 limit)
63	71	9		Num	ALM2-MONTH2	Summed second-month employment
72	80	9		Num	ALM2-MONTH3	Summed third-month employment
81	89	9		Num	ALM2-TOPEMP	Highest employment found for the quarter
90	98	9		Num	ALM2-TOPAVGEMP	Largest average-monthly-employment (AME) value found
99	112	14		Num	ALM2-TOTAL-WAGE	Summed total wages for the quarter; allows up to $100 trillion to be shown
113	118	6		Num	ALM2-AVG-WEEK-WAGE	Average weekly wage value computed from above data, limited to $1,000,000/week
119	132	14		Num	ALM2-TAX-WAGE	Summed taxable wages for the quarter wit $100 trillion limit
133	141	9		Num	ALM2-CONTRIB	Summed contributions due for the quarter, handling up to $1 billion in U-I taxes
142	142	1		Char	ALM2-SUPPRESS	Non-disclosure suppression code
Second ALMIS Extract File Data Set Name:                   WS.JOB47D.DATA2n   (where 'n' is a value from 1 to 9, based on the parameter set processed) Service Center DSN:           YBUssX.A145.JOB47D.DATA2n  ('ss' = State FIPS code, 'n' is a value from 1 to 9, based on the parameter set processed) Type of File:                         Sequential File Layout:                          ES2ALMS ​This is second of three ALMIS extract output file formats.  While the first format is designed more as a readable file, this one is more detailed and uses no unnecessary filler spaces as field separators.  The third file is a revision of this file.  All three of these are produced by Job 247D.  They are used by different branches of ALMIS personnel.  Since the ALMIS system is outside the scope of EXPO general processing, these files are produced here merely as an interface mechanism.  There is no direct linkage between EXPO and ALMIS; in addition, no quid-pro-quo organization is provided, since this is a unidirectional data transfer. ​ ​ ​ ​ ​

Related Links

• ​​Third ALMIS Extract File (ES2ALM3)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home