* BMF 02/2013.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
CITY "City"
zip5 "First 5 digits of zip code"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
MSA_NECH "Metropolitan Statistical Area (NCCS file) (list)"
PMSA "Primary Metropolitan Statistical Area"
TAXPER "Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412")."
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
Filer "Filed 990 return (Form 990, Form 990-EZ, Form 990-PF, or Form 990-N) within 24 months of BMF file? (Y/N)"
ZFILER "Filed 990 return with zero income and assets within 24 months of BMF file? (Y/N) - Beginning 2008, over 95% of 'zero filers' (ZFiler=Y) filed Form 990-N (e-Postcard) for tax years ending on or after December 31, 2007."
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
INCOME "Gross receipts from most recently filed Form 990"
ASSETS "Total assets (end of year) from most recent Form 990"
cFiler "Filed 990 return within 24 months of BMF file date? (Y/N)"
czFiler "Filed 990 return with zero income and assets within 24 months of BMF file? (Y/N) - Beginning 2008, over 95% of 'zero filers' (cZFiler=Y) filed Form 990-N (e-Postcard) for tax years ending on or after December 31, 2007."
cTaxPer "Ending date for tax period of NCCS financial data in yyyymm format."
cTotRev "Total Revenue from most recent Form 990 (Part I, line 12 on Form 990; Part I, line 9 on Form 990-EZ; or Part I, line 12(a) on Form 990-PF)"
cAssets "Total Assets (Book Value at end of year) from most recent Form 990 (Part IV, line 59(B) on Form 990; Part II, line 25(B) on Form 990-EZ; or Part II, line 16(b) on Form 990-PF)"
cFinSrc "Source of financial data added by NCCS (primarily the most recent Form 990 filing as of BMF date from NCCS Core files)"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
FRCD "Filing requirements code. The 1st 2 characters indicate the requirements for 990/990-EZ forms. The 3rd character = 1 if a 990-PF is required or 0 if not."
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NAICS "NAICS Code"
ACCPER "Accounting period"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS cFiler
"N" "No"
"Y" "Yes"
.
VALUE LABELS czFiler
"N" "No"
"Y" "Yes"
.
VALUE LABELS Filer
"Y" "Yes"
"N" "No"
.
VALUE LABELS FNDNCD
"22" "Supporting Organization 509(a)(3) Type II"
"03" "Private operating foundation (other)"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"00" "All organizations except 501(c)(3)"
"18" "Organization organized and operated to test for public safety"
"17" "Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16"
"16" "Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose"
"15" "Organization with a substantial portion of support from a governmental unit or the general public"
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"12" "Hospital or medical research organization"
"11" "School"
"10" "Church"
"09" "Suspense"
"21" "Supporting Organization 509(a)(3) Type I"
"04" "Private non-operating foundation"
.
VALUE LABELS FRCD
"011" "990PF Required (all other)"
"020" "990 - Required to file Form 990-N (Income less than $25,000 per year)"
"021" "990PF Required - 990 Required to file Form 990-N (Income less than $25,000 per year)"
"030" "990 - Group return"
"031" "990PF Required - Group return"
"040" "990 - Required to file Form 990-BL, Black Lung Trusts"
"041" "990PF Required - 990 Required to file Form 990-BL, Black Lung Trusts"
"060" "990 - Not required to file (church)"
"061" "990PF Required - Not required to file (church)"
"070" "990 - Government 501(c)(1)"
"071" "990PF Required - Government 501(c)(1)"
"130" "990 - Not required to file (religious organization)"
"131" "990PF Required - Not required to file (religious organization)"
"000" "990 - Not required to file (all other)"
"140" "990 - Not required to file (instrumentalities of states or political subdivisions)"
"001" "990PF Required - 990 not required to file (all other)"
"141" "990PF Required - Not required to file (instrumentalities of states or political subdivisions)"
"010" "990 (all other) or 990EZ return"
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"U" "Unknown"
"O" "Other Nonprofits"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ED" "Education"
"ZB" "Fundraising within NTEE major group"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"L" "Housing, Shelter"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
.
VALUE LABELS MAJGRPB
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
"BH" "BH-Higher educ."
"Q" "Q-International, Foreign Affairs"
"C" "C-Environment"
"R" "R-Civil Rights/Advocacy"
"D" "D-Animal Related"
"S" "S-Community Improvement"
"E" "E-Health - General"
"T" "T-Philanthropy, Voluntarism"
"EH" "EH-Hospitals"
"U" "U-Science and Technology"
"F" "F-Mental Health"
"V" "V-Social Science"
"G" "G-Health - Disease Specific (general)"
"W" "W-Public, Society Benefit"
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
.
VALUE LABELS NTEE1
"J" "Employment, Job Related"
"Z" "Unknown"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"L" "Housing, Shelter"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
.
VALUE LABELS nteeFinal1
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"L" "Housing, Shelter"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
.
VALUE LABELS NTEESRC
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"3YR" "Classification review completed during the data development of the three-year financial project"
"SMP" "Classification review from sampling (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"ALM" "Almanac 2000 edits (confidence=A)"
"$src" "Dig.data auto-coded 3/2005"
"$src" "Auto-generated codes (confidence=C)"
"DD200511" "Digitized data auto-codes"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"" "Unknown source (confidence= ?)"
"Core2004co" "2006 NTEE rules"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"CORE02" "Core 2002 codes (04/02/04)"
"DS" "David Stevenson's rulings (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"bahrz1" "NCCS - No information found in web search"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"ZZ" "NCCS expert verified records"
"RTF" "Classification of I.R.S. Return Transaction Files"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"DD200304-B" "Dig.data verified 4/2003"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
.
VALUE LABELS ntmaj10
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
VALUE LABELS ntmaj12
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"4" "4- Not a 501(c)(3)"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"S" "S- Missing geographic information"
"T" "T- U.S. Territory or armed forces overseas"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"" "No value"
.
VALUE LABELS SUBSECCD
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"19" "19- Post or organization of war veterans."
"70" "70- Child Care Organization - 501(k)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"22" "22- Multiemployer Pension Plan"
"71" "71- Charitable Risk Pool"
"11" "11- Teachers retirement fund associations."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"23" "23- Veterans association formed prior to 1880"
"81" "81- Qualified State-Sponsored Tuition Program"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"24" "24-Trust described in Section 4049 of ERISA"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"02" "02- Title holding corporation for a tax-exempt organization."
"25" "25- Title Holding Company for Pensions, etc"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"82" "82- 527 Political Organizations"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"90" "90- 4947(a)(2) Split Interest Trust"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"80" "80- Farmers' Cooperatives"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"92" "92- 4947(a)(1) Private Foundations"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
.
VALUE LABELS ZFILER
"Y" "Yes"
"N" "No"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
FIPS a5
NTEECC a4
FILER a1
ZFILER a1
NAME a70
ADDRESS a70
CITY a22
STATE a2
ZIP5 a5
GEN a4
SUBSECCD a2
RULEDATE a6
FNDNCD a2
TAXPER a6
FRCD a3
ACCPER a2
ASSETS f15.0
INCOME f15.0
SEC_NAME a100
NTEE1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
nteeFinal a5
nteeFinal1 a1
RandNum f15.0
nteeConf a1
MSA_NECH a4
PMSA a4
cFiler a1
czFiler a1
cTaxPer a6
cAssets f15.0
cTotRev f15.0
cFinSrc a15
EPOST a1
FISYR_IMAGE a4
IRS990n a1
NAICS a6
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.