* BMF 09/2007 Other.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
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 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"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
ASCD "Asset code"
INCOME "Gross receipts from most recently filed Form 990"
INCCD "Income range code"
F990REV "Total revenue from most recent 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."
AFCD "Affiliation code"
ARED "Advance Ruling Expiration Date"
CONTACT "Contact person (from IRS files)"
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
DISTRICT "IRS District Office"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
NAICS "NAICS Code"
ORGCD "Organization code: corporation, trust, association, etc."
ACCPER "Accounting period"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS AFCD
"7" "Intermediate- group exempt intermediate organization of a national, regional or geog. group"
"6" "Central - parent (group ruling) and is not a church or 501(c)(1)"
"3" "Independent org. or independent auxiliary unaffil. w. national, regional or geogr. grouping"
"2" "Intermediate organization (no group exemption)"
"1" "Central organization (no group exemption)"
"9" "Subordinate in a group ruling."
"0" "Unknown"
"8" "Central - parent (group ruling) and is a church or 501 (c)(1)"
.
VALUE LABELS ASCD
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
.
VALUE LABELS cFiler
"N" "No"
"Y" "Yes"
.
VALUE LABELS cZFiler
"N" "No"
"Y" "Yes"
.
VALUE LABELS DEDUCTCD
"0" "Description unknown at this time"
"1" "Contributions are deductible"
"2" "Contributions are not deductible"
"4" "Contributions are deductible by treaty (foreign organizations)"
.
VALUE LABELS Filer
"N" "No"
"Y" "Yes"
.
VALUE LABELS FNDNCD
"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"
"21" "Supporting Organization 509(a)(3) Type I"
"11" "School"
"22" "Supporting Organization 509(a)(3) Type II"
"10" "Church"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"09" "Suspense"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"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"
.
VALUE LABELS FRCD
"00" "Not required to file (all other)"
"14" "Not required to file - State Instrumentality or Political Subdivision"
"13" "Not required to file - Religious Organization"
"04" "Required to file 990BL - Black Lung Trust"
"06" "Not required to file - Church"
"02" "Required to file 990N (gross receipts less than $25,000)"
"01" "Required to file 990 (all other) or 990EZ"
"07" "Required to file 990 - Government 501 ( c) (1)"
"03" "Required to file 990 - Group Return"
.
VALUE LABELS INCCD
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"PC" "Public Charity"
"O" "Other Nonprofits"
"PF" "Private Foundation"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"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"
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"" "Unknown"
"L" "Housing, Shelter"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
"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"
.
VALUE LABELS NTEE1
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"" "Unknown"
"L" "Housing, Shelter"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
.
VALUE LABELS nteeFinal1
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"" "Unknown"
"L" "Housing, Shelter"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
.
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
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
.
VALUE LABELS ntmaj5
"HE" "Health"
"HU" "Human services"
"OT" "Other"
"AR" "Arts, culture, and humanities"
"ED" "Education"
.
VALUE LABELS ORGCD
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"6" "Non-exempt charitable trust"
"1" "Corporation"
"0" "Unknown"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
"4" "4- Not a 501(c)(3)"
"" "No value"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"22" "22- Multiemployer Pension Plan"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"23" "23- Veterans association formed prior to 1880"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"24" "24-Trust described in Section 4049 of ERISA"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"25" "25- Title Holding Company for Pensions, etc"
"11" "11- Teachers retirement fund associations."
"02" "02- Title holding corporation for a tax-exempt organization."
"90" "90- 4947(a)(2) Split Interest Trust"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"80" "80- Farmers' Cooperatives"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"19" "19- Post or organization of war veterans."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"92" "92- 4947(a)(1) Private Foundations"
"70" "70- Child Care Organization - 501(k)"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"71" "71- Charitable Risk Pool"
"81" "81- Qualified State-Sponsored Tuition Program"
"82" "82- 527 Political Organizations"
.
VALUE LABELS ZFiler
"N" "No"
"Y" "Yes"
.

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 a5
NteeCC4d a2
NTEEconf a1
FILER a1
zFiler a1
NAME a70
CONTACT a35
ADDRESS a35
CITY a22
STATE a2
ZIP5 a5
ZIP a10
GEN a4
SUBSECCD a2
AFCD a1
CLASSCD a4
RULEDATE a6
DEDUCTCD a1
FNDNCD a2
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
ORGCD a1
DISTRICT a2
ARED a6
TAXPER a6
ASCD a1
INCCD a1
FRCD a3
ACCPER a2
ASSETS f15.0
INCOME f15.0
NEGINCOM a1
F990REV f15.0
NEGF990R a1
NTEEIRS a4
SEC_NAME a35
NteeOldB a5
NTEE1 a1
MajGrpB a2
NtMaj10 a2
NtMaj5 a2
NtMaj12 a2
OutNCCS a3
OutReas a1
Level1 a2
Level2 a1
Level3 a2
Level4 a1
Ntee2007a a5
Confidence2007a a1
RandNum f15.0
cAssets f15.0
cTotRev f15.0
cTaxPer a6
cFinSrc a10
cFiler a1
czFiler a1
nteeFinal a5
nteeFinal1 a1
MSA_NECH a4
PMSA a4
NAICS a11
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.