* SOI 2012 990 Comp.

VARIABLE LABELS
EIN "Employer identification number (Page 1, Line D)"
FisYr "Fiscal year (ending year)"
NAME "Organization name (Page 1, Line C)"
STATE "Two-letter state abbreviation (Page 1, Line C(3))"
zip5 "First 5 digits of zip code (Page 1, Line C(4))"
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)"
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.)"
NAICS "North American Industrial Classification System"
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
CROW "Row Identification Number"
avg_hrs_per_wk "Average Hours Per Week (990 - Part VII, Line 1a(B))"
position "Position (check all that apply): Code values indicate column(s) checked. Because employees may hold multiple positions, this field may contain a single digit or some combination of digits (e.g. '34' = Officer and Key employee) (990 - Part VII, Line 1a(C)).
1 - Individual trustee or director
2 - Institutional trustee
3 - Officer
4 - Key employee
5 - Highly-compensated employee
6 - Former"
rep_comp_from_org "Reportable compensation from organization (990 - Part VII, Line 1a(D))"
rep_comp_from_rltd_orgs "Reportable compensation from related organizations (990 - Part VII, Line 1a(E))"
oth_comp "Other compensation (990 - Part VII, Line 1a(F))"
j_base_comp "W-2 / 1099-MISC breakdown: Base compensation ($) from filing organization (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col B(i))"
J_bonus_incntv_comp "W-2 / 1099-MISC breakdown: Bonus and incentive compensation (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col B(ii))"
j_oth_rptble_comp "W-2 / 1099-MISC breakdown: Other compensation ($) from filing organization (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col B(iii))"
j_def_comp "Deferred compensation ($) from filing organization (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col C)"
j_nontxbl_bnfts "Nontaxable benefits ($) from filing organization (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col D)"
j_total_comp "Total of (B)(i) - (D), from filing org (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col E)"
j_comp_rptd_prior "Comp reported prior 990 - from filing org (zero-filled for employees listed in Form 990 Part VII that are not required to be reported on Schedule J) (990 - Sch J, Part II, Line (i) Col F)"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
SCPL "Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)"
COMP_CNT "Number of Compensated Officers, Directors, Trustees, Key Employees, etc. reported (total number of rows in 990 Part VII-A compensation table)"
randnum "Random number between 0 and 1 used for creating samples"
.

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

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.