SOI 2008 990 Comp

Number of variables35
Number of records118,558

Field Name
Field Type
Description and Values
Basic Info
EIN
Character
(9)
Employer Identification Number
Employer identification number (Page 1, Line D)
NAME
Character
(60)
Name of organization
Organization name (Page 1, Line C)
STATE
Character
(2)
State
Two-letter state abbreviation (Page 1, Line C(3))
zip5
Character
(5)
Zip code, 5 digits
First 5 digits of zip code (Page 1, Line C(4))
FIPS
Character
(5)
State + County FIPS code
2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts.
MSA_NECH
Character
(9)
Metropolitan Statistical Area
Metropolitan Statistical Area (NCCS file)
outnccs
Character
(20)
Out of Scope flag
Out-of-scope (IN/OUT) (see OUTREAS doc. for details)
OUTREAS
Character
(20)
Reason why out of scope
Reason why out of scope
No value
44- Not a 501(c)(3)
FF- Foreign organization
GG- Government Entity
II- Coded out of scope by Independent Sector
NN- Coded out of scope by NCCS (e.g. foreign address on Form 990)
SS- Missing geographic information
TT- U.S. Territory or armed forces overseas
Classification
NTEE1
Character
(20)
NTEE major group
NTEE major group (A-Z)
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
NTEECC
Character
(4)
NTEECC primary purpose
NTEECC classification
ntmaj5
Character
(4)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(4)
NTEE major group (10)
10 NTEE major groups
ARArts, culture, and humanities
EDEducation
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
ntmaj12
Character
(4)
NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)
ARArts, culture, and humanities
BHEducation, higher
EDEducation
EHHospitals
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
MAJGRPB
Character
(4)
Major NTEE group
Major NTEE group plus hospitals and higher education
AA-Arts, Culture & Humanities
BB-Education
BHBH-Higher educ.
CC-Environment
DD-Animal Related
EE-Health - General
EHEH-Hospitals
FF-Mental Health
GG-Health - Disease Specific (general)
HH-Health - Disease Specific (research)
II-Crime, Legal Related
JJ-Employment, Job Related
KK-Food, Agriculture, Nutrition
LL-Housing, Shelter
MM-Public Safety, Disaster Preparedness
NN-Recreation and Sports
OO-Youth Development
PP-Human Services, Multipurpose and Other
QQ-International, Foreign Affairs
RR-Civil Rights/Advocacy
SS-Community Improvement
TT-Philanthropy, Voluntarism
UU-Science and Technology
VV-Social Science
WW-Public, Society Benefit
XX-Religion Related
YY-Mutual/Membership Benefit
ZZ-Unknown, Unclassified
Part VII-A and Sched J Part II - Compensation of Officers, Directors, Trustees, Key Employees, etc.
CROW
Character
(4)
Row Identification Number
Row Identification Number
avg_hrs_per_wk
Character
(4)
Average Hours Per Week
Average Hours Per Week (990 - Part VII, Line 1a(B))
7777 - Institutional trustee reported (eg: a bank)
9898 - Part time
9999 - Hours per week unknown
position
Character
(6)
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
Character
(6)
Reportable compensation from organization
Reportable compensation from organization (990 - Part VII, Line 1a(D))
rep_comp_from_rltd_orgs
Character
(6)
Reportable compensation from related organizations
Reportable compensation from related organizations (990 - Part VII, Line 1a(E))
oth_comp
Character
(6)
Other compensation
Other compensation (990 - Part VII, Line 1a(F))
j_base_comp
Character
(6)
Base compensation ($) from filing organization
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
Character
(6)
Bonus and incentive compensation
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
Character
(6)
Other compensation ($) from filing organization
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
Character
(6)
Deferred compensation ($) from filing organization
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
Character
(6)
Nontaxable benefits ($) from filing organization
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
Character
(6)
Total of (B)(i) - (D), from filing org
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
Character
(6)
Comp reported prior 990 - from filing org
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)
Other Classification
NAICS
Character
(9)
N. Am industrial classification
North American Industrial Classification System
LEVEL1
Character
(9)
Public charity or priv. fndn?
Public charity or private foundation?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(9)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(9)
Major NTEE category
Major NTEE category
ARArts, culture and humanities
EDEducation
ENEnvironment/animals
HEHealth
HSHuman Services
INInternational, foreign affairs
MOOther mutual benefit
MRPension and retirement funds
PBPublic, societal benefit
REReligion related
UNUnknown, unclassified
ZASingle organization support
ZBFundraising within NTEE major group
ZCPrivate grantmaking foundations
ZDPublic foundations
ZEGeneral fundraising
ZFOther Supporting Public Benefit
level4
Character
(9)
NTEE-CC Major Group
NTEE-CC Major Group
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
Internal Processing
SCPL
Character
(12)
S.C./Cycle/Page/L.C.
Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)
COMP_CNT
Character
(12)
No. compensated officers, etc
Number of Compensated Officers, Directors, Trustees, Key Employees, etc. reported (total number of rows in 990 Part VII-A compensation table)
Miscellaneous
randnum
Numeric
(12)
Random number between 0 and 1
Random number between 0 and 1 used for creating samples