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