* Core 1989 PC.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
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 - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
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")."
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
CONT "Total public support (Line 1d: sum of direct public support (1a), indirect public support (1b), and government contributions and grants (1c))"
PROGREV "Program service revenue, line 2"
DUES "Membership dues and assessments, line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)"
INVINC "Total investment income (Sum of lines 4, 5, and 7)"
RENTEXP "Rental expenses, line 6b"
SECUR "Gross amount from sale of securities, Column A - line 8a"
SALESEXP "Cost or other basis of securities and sales expenses, Column A - line 8b"
SPEVTG "Gross revenue from special events, line 9a"
FUNDINC "Net income/loss from special events, line 9c"
GOODS "Cost of goods sold, line 10b"
GRPROF "Gross profit/loss from sales of inventory, line 10c"
OTHINC "Other revenue, line 11"
TOTREV "Total revenue, line 12"
GRREC "Gross receipts (Sum of lines 6b, 8b (Columns A and B), 9b, 10b, and 12)"
SOLICIT "Fundraising expenses, line 15"
EXPS "Total expenses, line 17"
FUNDBAL "Net assets or fund balance at end-of-year, line 21"
COMPENS "Compensation of officers, directors, etc. - Total, Column A - line 25 (excludes compensation for 990-EZ filers)"
FUNDFEES "Professional fundraising fees - Total, Column A - line 30"
ASS_BOY "Total assets at beginning-of-year, Column A - line 59"
ASS_EOY "Total assets at end-of-year, Column B - line 59"
LIAB_BOY "Total liabilities at beginning-of-year, Column A - line 66"
LIAB_EOY "Total liabilities at end-of-year, Column B - line 66"
RETEARN "Retained earnings, endowment, accumulated income, or other funds at end-of-year, Column B - line 72"
LEGEXP "Expenses paid for legislative activities (Sch A, Part III), line 1"
GRROOT "Lobbying to influence public opinion (Sch A, Part VI-A), line 36b"
INFLEXP "Lobbying to influence legislative body (Sch A, Part VI-A), line 37b"
EXGRROOT "Excess grass roots expenditures: line 36b less line 42b (Sch A, Part VI-A), line 43b"
EXLOBEXP "Excess lobbying expenditures: line 38b less line 41b (Sch A, Part VI-A), line 44b"
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"
NAICS "North American Industrial Classification System"
NTEE4 "Four-digit NTEE code."
NTEECC4D "NTEE-CC code 4th & 5th characters used for supporting organizations"
ORGCD "Organization code: corporation, trust, association, etc."
VERIFY "Financials have been verified"
ACCPER "Accounting period"
RandNum "Random number between 0 and 1 used for creating samples"
NteeDraft "Draft NTEE-CC code"
.

.
VALUE LABELS AFCD
"1" "Central organization (no group exemption)"
"9" "Subordinate in a group ruling."
"8" "Central - parent (group ruling) and is a church or 501 (c)(1)"
"7" "Intermediate- group exempt intermediate organization of a national, regional or geog. group"
"0" "Unknown"
"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)"
.
VALUE LABELS DEDUCTCD
"2" "Contributions are not deductible"
"4" "Contributions are deductible by treaty (foreign organizations)"
"0" "Description unknown at this time"
"1" "Contributions are deductible"
.
VALUE LABELS FNDNCD
"12" "Hospital or medical research organization"
"11" "School"
"10" "Church"
"09" "Suspense"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"21" "Supporting Organization 509(a)(3) Type I"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"22" "Supporting Organization 509(a)(3) Type II"
"00" "All organizations except 501(c)(3)"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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"
.
VALUE LABELS FRCD
"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)"
"04" "Required to file 990BL - Black Lung Trust"
"03" "Required to file 990 - Group Return"
"00" "Not required to file (all other)"
"14" "Not required to file - State Instrumentality or Political Subdivision"
"13" "Not required to file - Religious Organization"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS LEVEL3
"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"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
.
VALUE LABELS LEVEL4
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"" "Unknown"
"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"
"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"
.
VALUE LABELS MAJGRPB
"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"
"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"
.
VALUE LABELS NTEE1
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"" "Unknown"
"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"
"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"
.
VALUE LABELS nteeFinal1
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"" "Unknown"
"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"
"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"
.
VALUE LABELS NTEESRC
"FC" "Foundation Center reclassification"
"DS" "David Stevenson's rulings (confidence=A)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"ZD" "David Stevenson's reclass. of unclassified"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"ZT" "Temp's review of unclassified, Feb. 97"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"MD" "Classifcation of Maryland State Attorney General's file"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"T" "Temps review in Fall 1996 (confidence=B)"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"IV" "Independent verifiers (1996) (confidence=A)"
"KCS" "Classification done for Kansas City newspaper layout"
"" "Unknown source (confidence= ?)"
"SM" "Classification done by ShoShauna Mccoy"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"$src" "Dig.data auto-coded 3/2005"
"3YR" "Classification review completed during the data development of the three-year financial project"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"$src" "Auto-generated codes (confidence=C)"
"SMP" "Classification review from sampling (confidence=B)"
"ZZ" "NCCS expert verified records"
"RTF" "Classification of I.R.S. Return Transaction Files"
"DD200511" "Digitized data auto-codes"
"CORE02" "Core 2002 codes (04/02/04)"
"ALM" "Almanac 2000 edits (confidence=A)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"Core2004co" "2006 NTEE rules"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"DD200304-B" "Dig.data verified 4/2003"
"bahrz1" "NCCS - No information found in web search"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
.
VALUE LABELS ORGCD
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"T" "T- U.S. Territory or armed forces overseas"
"F" "F- Foreign organization"
"" "No value"
"4" "4- Not a 501(c)(3)"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS SOURCE
"I" "IRS Return Transaction Files"
"A" "Unified Database of Arts Organizations"
"C" "American Churches List"
"G" "Knight Foundation Grant Applicant Files"
"P" "Phone CD"
"D" "Dun & Bradstreet Data Source"
"U" "United Way"
"SAG" "NTEE Classification based on agreement of 2 or 3 of codes from NCCS, FC or SOI."
"SOK" "NTEE Classification based on information from directory, web search or phone call."
"SQU" "NTEE Classification based on current IRS information or on previous classifications-chosen without c"
.
VALUE LABELS SUBSECCD
"24" "24-Trust described in Section 4049 of ERISA"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"25" "25- Title Holding Company for Pensions, etc"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"90" "90- 4947(a)(2) Split Interest Trust"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"80" "80- Farmers' Cooperatives"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"70" "70- Child Care Organization - 501(k)"
"92" "92- 4947(a)(1) Private Foundations"
"11" "11- Teachers retirement fund associations."
"71" "71- Charitable Risk Pool"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"81" "81- Qualified State-Sponsored Tuition Program"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"19" "19- Post or organization of war veterans."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"22" "22- Multiemployer Pension Plan"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"23" "23- Veterans association formed prior to 1880"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"02" "02- Title holding corporation for a tax-exempt organization."
"82" "82- 527 Political Organizations"
.
VALUE LABELS VERIFY
"T" "Current financial fields have been multiplied by 1000 because return reported in thousands."
"L" "Financial fields were multiplied by 1000 because return reported in the thousands but inspection rev"
"" "No code"
"M" "Financial fields have been verified by staff."
"S" "Financial fields have been verified by SOI edited return."
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
CONT f15.0
DUES f15.0
SECUR f15.0
SALESEXP f15.0
INVINC f15.0
SOLICIT f15.0
GOODS f15.0
GRPROF f15.0
SALES f15.0
GRINC f15.0
GRREC f15.0
EXPS f15.0
FUNDBAL f15.0
COMPENS f15.0
FUNDFEES f15.0
ASS_BOY f15.0
ASS_EOY f15.0
LIAB_BOY f15.0
LIAB_EOY f15.0
RETEARN f15.0
INITFEES f15.0
GRRECPUB f15.0
GRRECMEM f15.0
GRRECOTH f15.0
POLPURP f15.0
LEGEXP f15.0
GRROOT f15.0
INFLEXP f15.0
EXGRROOT f15.0
EXLOBEXP f15.0
VERIFY a1
OLDNTEE a4
NTEE2 a4
RASCD a1
RINCCD a1
REXPCD a1
NAME a70
CONTACT a35
ADDRESS a34
CITY a22
STATE a2
ZIP a10
GEN a4
SUBSECCD a2
AFCD a1
CLASSCD a4
RULEDATE a6
DEDUCTCD a1
FNDNCD a2
ORGCD a1
DISTRICT a2
ARED a6
FRCD a3
ACCPER a2
SEC_NAME a35
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
SOURCE a5
ENDDATE a4
VFB a1
VBS f15.0
VINCEXP f15.0
VINCTYPE a1
VOK f15.0
FIPS a5
MANUAL a3
NTEE a4
NTEECC a3
NTEECC4D a1
LEVEL1 a2
LEVEL2 a1
LEVEL3 a2
LEVEL4 a1
OUTNCCS a3
OUTREAS a1
STYEAR a4
ntee1 a1
ntee4 a4
RandNum f15.0
zipnew a5
ZIP5 a5
MSA_NECH a4
PMSA a4
MAJGRPB a2
NTEESRC a1
ntmaj10 a2
ntmaj5 a2
fipsold a5
ntmaj12 a2
nteeConf a1
TOTREV f15.0
PROGREV f15.0
RENTEXP f15.0
OTHINC f15.0
SPEVTG f15.0
FUNDINC f15.0
v_errorCd a1
FisYr a4
NteeDraft a4
taxper a6
stateOld1 a2
zip5Old1 a5
cityOld1 a22
BOND_EOY f15.0
MRTG_EOY f15.0
LEVEL1old20090616 a2
LEVEL2old20090616 a2
LEVEL3old20090616 a2
LEVEL4old20090616 a2
OUTNCCSold20090616 a3
OUTREASold20090616 a1
nteeFinal a5
nteeFinal1 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.