Document ID: EPA-HQ-OW-2002-0033-0104
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-04-14T04:00Z

Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
SMALL_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Site
ID
Survey
ID
Phase1
A
N
Primary
Sector
Primary
sector
abbreviation
Phase1
B
Y
Rev_
Src
Revenue
Source:
M=
Revenues
come
from
manufacturing
only;
R=
Revenues
come
from
rebuilding
and
maintenance
only;
B=
Revenues
come
from
both
manufacturing
and
rebuilding
and
maintenance;
U=
Unknown;
MU=
Municipality
Phase1
C
N
Firm
Employment
Firm
employment,
1989
Phase1
D
Y
Site
Employment
Site
employment,
1989
Phase1
E
Y
Firm
Revenue
Firm
Revenue,
1996$
Phase1
F
Y
Manufacturing
Threshold
(
Employment)
Small
business
threshold
for
manufacturing
SIC
codes,
employment
Phase1
G
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,2,0)

Rebuilding
/
Maintenance
Threshold
(
Dollars)
Small
business
threshold
for
non­
manufacturing
SIC
codes,
dollars
Phase1
H
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,3,0)

Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Secondary
small
business
threshold
for
nonmanufacturing
SIC
codes,
employment
Phase1
I
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,4,0)

Entity
Size
Entity
Size:
Large
entity;
Small
entity;
Maybe
large
entity
(
exceeds
one
threshold
but
not
the
other);
Unknown
entity
size
Phase1
J
Y
=
IF(
P5=
1,"
Small",
IF(
Q5=
1,"
Maybe",
IF(
R5=
1,"
Large","
Unknown")))

Man
Thresh
(
Emp)
Small
business
threshold
for
manufacturing
SIC
codes,
employment
Phase1
L
Y
Rbldg
Thresh
(
Rev)
Small
business
threshold
for
manufacturing
SIC
codes,
dollars
Phase1
M
Y
=
IF(
D5>
G5,1,0)

Rbldg
Thresh
(
Emp)
Small
business
threshold
for
non­
manufacturing
SIC
codes,
employment
Phase1
N
Y
=
IF(
H5=
0,"
n/
a",
IF(
F5>
H5,1,0))

Rbldg
Thresh
(
both)
Small
business
threshold
for
non­
manufacturing
SIC
codes,
dollars
Phase1
O
Y
=
IF(
I5=
0,"
n/
a",
IF(
D5>
I5,1,0))

small
Is
this
site
owned
by
a
small
entity?
0=
no;
1=
yes
Phase1
P
Y
=
IF(
M5="
n/
a",
N5,
IF(
N5="
n/
a",
M5,
IF(
AND(
M5=
0,
N5=
0),
0,
IF(
AND(
M5=
1,
N5=
1),
1,
IF(
AND(
M5=
0,
N
5=
1),
2,
IF(
AND(
N5=
0,
M5=
1),
2,3))))))
maybe
Is
this
site
maybe
owned
by
a
small
entity?
0=
no;
1=
yes
Phase1
Q
Y
=
IF(
AND(
C5="
M",
L5=
0),
1,
IF(
AND(
C5="
R",
O5=
0),
1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
L5=
0,
O5=
0),
1,
I
F(
AND(
OR(
C5="
B",
C5="
U"),
L5=
0,
O5="
n/
a"),
1,
IF(
AND(
C5="
R",
O5="
n/
a",
L5=
0),
1,
IF(
AND(
C5="
M
",
L5="
n/
a",
O5=
0),
1,0))))))
large
Is
this
site
owned
by
a
large
entity?
0=
no;
1=
yes
Phase1
R
Y
=
IF(
O5=
2,1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
L5=
1,
O5=
0),
1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
L5=
0,
O5=
1
),
1,0)))
Site
ID
Survey
ID
Phase2
A
N
0
Primary
Sector
Primary
sector
code
Phase2
B
Y
Rev_
Src
Revenue
Source:
M=
Revenues
come
from
manufacturing
only;
R=
Revenues
come
from
rebuilding
and
maintenance
only;
B=
Revenues
come
from
both
manufacturing
and
rebuilding
and
maintenance;
U=
Unknown;
MU=
Municipality
Phase2
C
N
Multi­
Site
Is
the
site
owned
by
a
multi­
site
firm?
1=
no;
2=
yes
Phase2
D
N
Firm
Employment
Firm
employment
Phase2
E
Y
Site
Employment
Site
employment
Phase2
F
Y
Firm
Revenue
Firm
revenue
Phase2
G
Y
Site
Revenue
Site
revenue
Phase2
H
Y
Manufacturing
Threshold
(
Employees)
Small
business
threshold
for
manufacturing
SIC
codes
Phase2
I
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,2,0)

Rebuilding
/
Maintenance
Threshold
(
Dollars)
Small
business
threshold
for
non­
manufacturing
SIC
codes
Phase2
J
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,3,0)

Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Phase2
K
Y
=
VLOOKUP($
B5,'
Sector
Thresh'!$
C$
6:$
F$
25,4,0)

February
14,
2003
1
of
24
small_
final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Small
Entity
Size:
Large
entity;
Small
entity;
Maybe
large
entity
(
exceeds
one
threshold
but
not
the
other);
Unknown
entity
size
Phase2
L
Y
=
IF(
W5=
1,"
Small",
IF(
X5=
1,"
Maybe",
IF(
Y5=
1,"
Large","
Unknown")))

no
emp
Check
for
no
employment
Phase2
N
Y
=
IF(
AND(
ISBLANK(
E5),
ISBLANK(
F5)),
1,0)
use
site
emp
Use
site
employment
because
firm
is
n/
a
Phase2
O
Y
=
IF(
AND(
ISBLANK(
E5),
D5=
1),
1,0)
use
site
rev
Use
site
revenue
because
firm
is
n/
a
Phase2
P
Y
=
IF(
AND(
ISBLANK(
G5),
D5=
1),
1,0)
no
thresh
No
small
business
threshold
because
sector
is
unknown
Phase2
Q
Y
=
IF(
P5=
1,
H5,
IF(
D5=
1,
G5,
H5))

Revenue
Revenue
used
to
compare
to
threshold
Phase2
R
Y
=
IF(
N5=
1,"
no
emp",
IF(
O5=
1,
F5,
IF(
D5=
1,
E5,
F5)))
Employment
Employment
used
to
compare
to
threshold
Phase2
S
Y
=
IF(
R5="
no
emp","
n/
a",
IF(
R5>
I5,1,0))
Man
Thresh
Manufacturing
threshold
used
Phase2
T
Y
=
IF(
J5=
0,"
n/
a",
IF(
Q5>
J5,1,0))
Rbldg
Thresh
Non­
manufacturing
threshold
used
Phase2
U
Y
=
IF(
K5=
0,"
n/
a",
IF(
R5>
K5,1,0))
small
Is
this
site
owned
by
a
small
entity?
0=
no;
1=
yes
Phase2
V
Y
=
IF(
T5="
n/
a",
U5,
IF(
U5="
n/
a",
T5,
IF(
AND(
T5=
0,
U5=
0),
0,
IF(
AND(
T5=
1,
U5=
1),
1,
IF(
AND(
T5=
0,
U5
=
1),
2,
IF(
AND(
U5=
0,
T5=
1),
2,3))))))
maybe
Is
this
site
maybe
owned
by
a
small
entity?
0=
no;
1=
yes
Phase2
W
Y
=
IF(
AND(
C5="
M",
S5=
0),
1,
IF(
AND(
C5="
R",
V5=
0),
1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
S5=
0,
V5=
0),
1,
I
F(
AND(
OR(
C5="
B",
C5="
U"),
S5=
0,
V5="
n/
a"),
1,
IF(
AND(
C5="
R",
V5="
n/
a",
S5=
0),
1,
IF(
AND(
C5="
M
",
S5="
n/
a",
V5=
0),
1,0))))))
large
Is
this
site
owned
by
a
large
entity?
0=
no;
1=
yes
Phase2
X
Y
=
IF(
V5=
2,1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
S5=
1,
V5=
0),
1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
S5=
0,
V5=
1
),
1,0)))
Entity
Size
Entity
Size:
Large
entity;
Small
entity;
Maybe
large
entity
(
exceeds
one
threshold
but
not
the
other);
Unknown
entity
size
Phase2
Y
Y
=
IF(
AND(
C5="
M",
S5=
1),
1,
IF(
AND(
C5="
R",
V5=
1),
1,
IF(
AND(
OR(
C5="
B",
C5="
U"),
S5=
1,
V5=
1),
1,
I
F(
AND(
OR(
C5="
B",
C5="
U"),
S5=
1,
V5="
n/
a"),
1,
IF(
AND(
C5="
R",
V5="
n/
a",
S5=
1),
1,
IF(
AND(
C5="
M
",
S5="
n/
a",
V5=
1),
1,0))))))
Site
ID
Survey
ID
I&
S
A
N
Primary
Sector
Primary
sector
code
I&
S
B
Y
Site
Employment
Site
employment
I&
S
C
Y
Firm
Employment
Firm
employment
I&
S
D
Y
Manufacturing
Threshold
(
Employment)
Small
business
threshold
for
manufacturing
SIC
codes
I&
S
E
Y
=
VLOOKUP(
B16,'
Sector
Thresh'!$
C$
6:$
F$
25,2,0)

Small
Is
the
site
owned
by
a
small
entity?
I&
S
F
Y
=
IF(
D16>
E16,"
Large",
IF(
OR(
ISBLANK(
D16),
D16=
0),"
Unknown","
Small"))
Sector
Sector
code
Sector
Thresh
A
N
Name
Sector
name
Sector
Thresh
B
N
Sect
Abbr
Sector
abbreviation
Sector
Thresh
C
N
Manufacturing
Threshold
(
Employees)
Small
business
threshold
for
manufacturing
SIC
codes
Sector
Thresh
D
N
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Small
business
threshold
for
non­
manufacturing
SIC
codes
Sector
Thresh
E
N
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Secondary
small
business
threshold
for
nonmanufacturing
SIC
codes
Sector
Thresh
F
N
February
14,
2003
2
of
24
small_
final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
3
M
7
M
10
R
12
M
13
M
14
M
15
M
16
M
20
M
24
U
25
B
28
M
31
U
32
M
35
M
38
M
42
M
43
M
46
M
48
M
52
M
55
B
57
M
58
M
59
R
60
U
68
M
69
M
70
M
72
M
73
M
76
M
78
B
83
M
84
M
85
B
86
M
88
U
94
M
96
M
100
M
102
B
105
M
109
U
112
M
114
M
115
M
118
U
119
M
120
M
125
B
129
M
February
14,
2003
3
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
130
M
132
M
135
M
136
M
138
M
141
B
142
M
143
M
147
M
148
M
149
M
154
M
155
M
159
U
162
M
163
M
164
M
165
M
166
M
170
M
172
M
174
M
177
M
178
M
179
M
181
M
183
M
184
M
185
M
187
M
188
M
190
M
191
M
193
M
197
U
199
M
200
M
202
M
208
M
209
M
210
B
212
M
214
M
216
M
219
M
221
M
223
M
226
M
227
M
229
M
230
M
232
M
February
14,
2003
4
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
233
U
235
B
239
M
245
M
247
B
248
B
249
B
252
M
254
M
261
M
262
B
264
M
265
M
266
M
267
M
268
U
273
M
274
B
276
M
279
M
280
U
281
B
282
M
283
U
284
B
285
M
288
M
289
M
293
M
296
M
301
M
302
M
303
M
304
U
305
M
306
U
309
M
313
M
314
B
315
M
319
M
322
M
323
M
325
M
326
M
331
M
333
B
335
M
336
M
338
M
340
M
345
M
February
14,
2003
5
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
351
M
358
M
359
U
361
M
363
B
364
M
365
M
369
U
370
M
376
M
377
M
378
M
380
M
381
M
384
M
386
M
387
B
388
M
390
M
395
M
396
M
398
B
399
M
403
M
404
U
408
M
409
M
410
M
413
U
414
M
416
M
418
M
422
M
424
M
428
M
429
M
440
M
441
B
442
M
446
M
447
M
451
B
452
M
456
M
457
B
458
M
459
M
461
M
462
M
464
M
466
M
468
B
February
14,
2003
6
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
470
M
472
U
473
M
475
M
479
R
480
M
481
M
484
M
486
M
488
M
489
M
490
M
492
B
493
M
496
M
502
M
504
M
509
M
510
M
511
M
514
M
515
M
518
M
520
M
522
B
523
M
524
M
526
M
530
M
531
M
532
B
534
M
536
U
537
M
538
B
539
B
540
U
542
M
545
M
548
M
555
M
561
M
566
M
567
M
570
M
574
M
578
M
579
M
583
M
586
M
590
M
595
B
February
14,
2003
7
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
603
M
605
M
608
M
609
M
611
M
612
M
613
M
614
M
615
M
616
B
617
M
621
M
622
M
623
M
624
M
627
M
629
M
630
B
631
M
632
M
633
M
634
M
635
M
648
M
653
M
655
M
656
B
661
M
662
U
663
M
664
B
665
M
669
M
673
M
675
U
679
U
681
M
683
M
684
M
687
M
688
M
690
M
693
M
695
B
696
M
700
M
704
B
705
M
706
U
707
M
708
M
710
M
February
14,
2003
8
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
711
M
714
M
717
M
718
M
720
M
726
M
730
M
732
M
740
M
741
M
746
M
747
M
749
M
751
B
752
U
753
U
756
M
758
M
760
M
763
U
764
M
767
M
771
M
774
M
775
M
777
M
780
U
785
M
787
M
789
M
790
M
796
U
797
M
799
M
800
M
807
M
808
M
809
M
813
M
814
M
815
M
816
M
821
M
823
M
824
M
829
M
831
M
836
M
837
M
850
M
851
M
853
B
February
14,
2003
9
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Small
Business
Analysis
for
MP&
M
Phase
I
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
1989
Firm
Employment
1989
Site
Employment
1996
Firm
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Entity
Size
Notes
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
854
M
855
M
856
M
857
M
858
B
859
M
860
B
861
U
864
M
867
B
870
M
871
M
873
M
874
B
875
B
880
U
885
M
886
M
February
14,
2003
10
of
24
small_
final.
xls
­
Phase1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Small
Business
Analysis
for
MP&
M
Phase
II
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
1
M
1
2
M
1
5
U
1
6
M
1
8
M
1
9
M
1
21
M
0
22
M
1
26
M
0
27
M
0
29
M
0
33
M
0
36
M
0
37
M
0
41
M
1
44
M
1
45
M
0
47
M
1
49
M
0
50
M
1
51
M
1
53
M
0
61
B
0
62
M
1
64
M
0
65
U
0
67
B
0
71
M
1
74
R
0
75
M
1
79
M
0
81
M
1
87
M
1
89
R
0
90
M
1
91
M
1
92
R
1
95
M
0
97
M
1
99
M
0
101
M
0
103
M
0
106
M
0
108
R
0
110
B
1
111
M
0
113
M
0
116
M
1
121
U
1
122
M
1
126
M
0
127
R
1
February
14,
2003
11
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
February
14,
2003
12
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
128
M
1
131
M
0
137
M
0
140
M
0
146
M
1
150
M
0
151
M
1
153
R
0
156
M
1
157
M
0
161
M
0
173
M
0
176
M
1
182
M
0
186
U
1
189
M
1
192
M
1
195
M
1
196
M
0
201
M
1
203
M
1
204
M
1
207
M
0
211
M
0
215
M
1
222
M
0
224
M
0
225
M
0
228
M
0
231
B
1
234
M
1
237
M
0
240
M
1
241
M
0
242
M
0
243
M
1
246
M
0
250
M
0
253
R
1
255
M
0
257
R
0
259
M
0
263
B
1
269
M
0
270
M
1
271
M
0
286
M
1
290
M
1
291
R
0
295
M
0
298
R
1
299
M
0
300
M
1
307
M
0
308
M
0
February
14,
2003
13
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
February
14,
2003
14
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
310
M
0
312
M
0
316
M
1
324
B
1
327
M
0
328
M
0
329
B
0
330
M
1
332
U
0
334
M
1
337
U
0
342
M
0
349
M
0
350
M
1
355
M
1
357
M
1
371
R
0
372
M
0
374
M
1
383
M
0
392
M
1
393
M
1
400
M
1
401
M
1
402
M
1
406
M
0
407
M
1
411
M
0
412
M
0
417
R
0
419
M
1
420
M
1
421
M
0
423
M
1
425
M
0
430
M
0
433
M
1
434
U
1
435
M
1
438
R
0
439
M
1
443
M
1
445
B
1
448
M
0
449
M
1
450
M
0
453
M
1
455
M
1
460
R
0
463
M
0
471
M
1
476
M
1
477
M
0
482
M
0
487
M
1
February
14,
2003
15
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
February
14,
2003
16
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
494
M
0
495
M
0
497
M
0
498
M
1
501
R
0
503
M
1
505
R
0
506
M
0
507
M
1
513
M
0
516
M
1
517
M
0
519
M
0
525
M
1
527
M
1
528
M
1
533
M
1
543
M
1
547
M
1
549
M
1
550
M
0
552
M
0
556
R
0
560
U
1
563
M
0
564
M
1
575
M
1
577
M
1
580
M
1
584
M
1
587
M
1
591
M
0
594
M
1
598
M
0
599
M
1
600
M
0
606
M
0
607
M
1
610
M
0
619
M
1
625
M
1
626
M
1
628
M
1
636
M
0
637
U
1
639
M
1
640
U
0
641
M
0
643
M
0
645
M
1
649
M
0
650
M
1
651
M
0
658
B
0
660
U
1
February
14,
2003
17
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
February
14,
2003
18
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
666
M
0
667
M
0
668
M
1
670
M
0
671
M
1
674
M
1
678
B
1
680
M
0
682
M
0
685
M
0
694
M
1
699
M
0
701
M
0
702
M
0
703
B
0
709
B
0
712
M
1
713
M
1
715
M
1
716
M
0
719
M
0
721
M
0
722
M
0
723
M
1
724
M
0
725
M
1
727
R
0
728
M
1
729
M
0
733
B
1
734
M
0
735
M
0
737
M
1
738
M
1
745
M
1
748
M
1
755
R
0
757
M
0
759
M
0
762
R
0
765
M
1
766
M
0
768
M
1
772
M
0
773
R
0
778
M
0
779
M
1
781
M
0
782
M
0
784
M
0
786
M
1
788
M
0
791
U
0
792
M
1
793
M
1
February
14,
2003
19
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
February
14,
2003
20
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Site
ID
Primary
Sector
Rev_
Src
Multi­
Site
1996
Firm
Employment
1996
Site
Employment
Firm
Revenue
Site
Revenue
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)
Small
Notes
no
emp
use
site
emp
use
site
rev
Revenue
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
795
M
1
802
M
1
804
R
0
805
M
0
806
M
1
811
M
1
817
B
1
818
M
0
819
M
0
820
M
1
822
M
0
825
M
1
830
M
0
834
M
0
839
M
1
841
B
0
842
M
0
843
R
0
844
R
0
846
M
0
848
M
0
849
M
0
862
M
0
863
B
1
866
M
0
869
U
0
879
B
1
884
M
1
887
B
1
888
R
0
891
B
1
894
M
0
905
U
0
918
R
0
921
R
0
922
M
0
926
R
1
927
M
0
929
U
0
930
M
0
934
M
0
948
U
0
February
14,
2003
21
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
3
4
R
S
T
U
V
W
X
Y
Employment
Man
Thresh
(
Emp)
Rbldg
Thresh
(
Rev)
Rbldg
Thresh
(
Emp)
Rbldg
Thresh
(
both)
small
maybe
large
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
February
14,
2003
22
of
24
small_
final.
xls
­
Phase2
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
A
B
C
D
E
F
Small
Business
Analysis
for
MP&
M
Iron
and
Steel
Surveys
Simple
Mode
Thresholds
Site
ID
Primary
Sector
Site
Employment
Firm
Employment
Manufacturing
Threshold
(
Employment)
Small
940
IS
941
IS
943
IS
944
IS
945
IS
946
IS
947
IS
949
IS
950
IS
951
IS
953
IS
954
IS
955
IS
956
IS
957
IS
958
IS
959
IS
960
IS
961
IS
962
IS
963
IS
964
IS
965
IS
966
IS
February
14,
2003
23
of
24
small_
final.
xls
­
I&
S
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
A
B
C
D
E
F
SOURCE:
SBA_
MPM.
XLS
SBA
Small
Business
Mode
Thresholds
for
MP&
M
Sectors
Sector
Name
Sect
Abbr
Manufacturing
Threshold
(
Employees)
Rebuilding
/
Maintenance
Threshold
(
Dollars)
Secondary
Rebuilding
/
Maintenance
Threshold
(
Employees)

1
Hardware
HW
500
2
Aircraft
AI
1,000
5,000,000
3
Electronic
Equipment
EE
750
4
Stationary
Industrial
Equipment
SI
500
5,000,000
5
Ordnance
OR
1,000
6
Aerospace
AS
1,000
7
Mobile
Industrial
Equipment
MI
500
8
Instrument
IN
500
5,000,000
9
Precious
and
Non­
Precious
Metals
PM
500
5,000,000
10
Ship
and
Boat
SB
1,000
5,000,000
500
11
Household
Equipment
HE
500
5,000,000
12
Railroad
RR
1,000
1,500
13
Motor
Vehicle
MV
500
5,000,000
100
14
Bus
and
Truck
BT
500
5,000,000
15
Office
Machine
OF
1,000
5,000,000
16
Printed
Circuit
Board
PC
500
17
Job
Shop
JS
500
18
Other
Metal
Products
OM
500
5,000,000
19
Iron
and
Steel
IS
1,000
Unknown
UNK
500
February
14,
2003
24
of
24
small_
final.
xls
­
Sector
Thresh