Macnaics Table Format
Field Name |
Data Type |
Format |
Description |
county_cd |
inte |
999 |
County Code |
data-changed |
logi |
yes/no |
Data Changed Flag |
mac_com_1 |
inte |
99 |
Comment Code 1 |
mac_com_2 |
inte |
99 |
Comment Code 2 |
mac_com_3 |
inte |
99 |
Comment Code 3 |
mac_conf |
logi |
yes/no |
Confidential Flag |
mac_contrib |
deci-2 |
>>>,>>>,>>9 |
Contributions |
mac_edited |
logi |
yes/no |
Edit Flag |
mac_firms |
inte |
99999999 |
Firms |
mac_largest_emp |
inte |
99999999 |
Largest Employment |
mac_largest_ui |
deci-2 |
9999999999 |
Largest UI Acct Number |
mac_m1 |
inte |
999999999 |
Month 1 Employment |
mac_m2 |
inte |
999999999 |
Month 2 Employment |
mac_m3 |
inte |
999999999 |
Month 3 Employment |
mac_narr |
char |
X(35) |
Narrative Field |
mac_narr_ind |
logi |
yes/no |
Narrative Flag |
mac_nonzero |
inte |
99999999 |
Number Nonzero Accounts |
mac_tax_wgs |
deci-2 |
>,>>>,>>>,>>>,> |
Taxable Wages |
mac_tot_wg |
deci-2 |
->>,>>>,>>>,>>> |
Total Wages |
mac_unique_est |
inte |
999999 |
Number of Unique Firms |
mac_units |
inte |
99999999 |
Number of Units |
naics-cd |
char |
X(6) |
NAICS Code |
own_cd |
inte |
9 |
Ownership Code |
qtr |
inte |
9 |
Quarter |
sic-cd-chr |
char |
9999 |
SIC Code |
standard-ind |
inte |
9 |
Standard Indicator |
yr |
inte |
9999 |
Year |