SOI 2008 990 Comp

Number of variables	35
Number of records	0

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
4	4- Not a 501(c)(3)
F	F- Foreign organization
G	G- Government Entity
I	I- Coded out of scope by Independent Sector
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

Classification

NTEE1
Character
(20)

NTEE major group
NTEE major group (A-Z)

	Unknown
A	Arts, Culture, and Humanities
B	Education
C	Environmental Quality, Protection, and Beautification
D	Animal-Related
E	Health
F	Mental Health, Crisis Intervention
G	Diseases, Disorders, Medical Disciplines
H	Medical Research
I	Crime, Legal Related
J	Employment, Job Related
K	Food, Agriculture, and Nutrition
L	Housing, Shelter
M	Public Safety
N	Recreation, Sports, Leisure, Athletics
O	Youth Development
P	Human Services - Multipurpose and Other
Q	International, Foreign Affairs, and National Security
R	Civil Rights, Social Action, Advocacy
S	Community Improvement, Capacity Building
T	Philanthropy, Voluntarism, and Grantmaking Foundations
U	Science and Technology Research Institutes, Services
V	Social Science Research Institutes, Services
W	Public, Society Benefit - Multipurpose and Other
X	Religion Related, Spiritual Development
Y	Mutual/Membership Benefit Organizations, Other
Z	Unknown

NTEECC
Character
(4)

NTEECC primary purpose
NTEECC classification

ntmaj5
Character
(4)

Major subsector
Major subsector (5)

AR	Arts, culture, and humanities
ED	Education
HE	Health
HU	Human services
OT	Other

ntmaj10
Character
(4)

NTEE major group (10)
10 NTEE major groups

AR	Arts, culture, and humanities
ED	Education
EN	Environment
HE	Health
HU	Human services
IN	International
MU	Mutual benefit
PU	Public and societal benefit
RE	Religion
UN	Unknown

ntmaj12
Character
(4)

NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)

AR	Arts, culture, and humanities
BH	Education, higher
ED	Education
EH	Hospitals
EN	Environment
HE	Health
HU	Human services
IN	International
MU	Mutual benefit
PU	Public and societal benefit
RE	Religion
UN	Unknown

MAJGRPB
Character
(4)

Major NTEE group
Major NTEE group plus hospitals and higher education

A	A-Arts, Culture & Humanities
B	B-Education
BH	BH-Higher educ.
C	C-Environment
D	D-Animal Related
E	E-Health - General
EH	EH-Hospitals
F	F-Mental Health
G	G-Health - Disease Specific (general)
H	H-Health - Disease Specific (research)
I	I-Crime, Legal Related
J	J-Employment, Job Related
K	K-Food, Agriculture, Nutrition
L	L-Housing, Shelter
M	M-Public Safety, Disaster Preparedness
N	N-Recreation and Sports
O	O-Youth Development
P	P-Human Services, Multipurpose and Other
Q	Q-International, Foreign Affairs
R	R-Civil Rights/Advocacy
S	S-Community Improvement
T	T-Philanthropy, Voluntarism
U	U-Science and Technology
V	V-Social Science
W	W-Public, Society Benefit
X	X-Religion Related
Y	Y-Mutual/Membership Benefit
Z	Z-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))

77	77 - Institutional trustee reported (eg: a bank)
98	98 - Part time
99	99 - 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?

O	Other Nonprofits
PC	Public Charity
PF	Private Foundation
U	Unknown

LEVEL2
Character
(9)

Reporting public charity group
Reporting public charity groups.

M	Mutual Benefit Public Charity
O	Operating Public Charity
S	Supporting Public Charity

level3
Character
(9)

Major NTEE category
Major NTEE category

AR	Arts, culture and humanities
ED	Education
EN	Environment/animals
HE	Health
HS	Human Services
IN	International, foreign affairs
MO	Other mutual benefit
MR	Pension and retirement funds
PB	Public, societal benefit
RE	Religion related
UN	Unknown, unclassified
ZA	Single organization support
ZB	Fundraising within NTEE major group
ZC	Private grantmaking foundations
ZD	Public foundations
ZE	General fundraising
ZF	Other Supporting Public Benefit

level4
Character
(9)

NTEE-CC Major Group
NTEE-CC Major Group

	Unknown
A	Arts, Culture, and Humanities
B	Education
C	Environmental Quality, Protection, and Beautification
D	Animal-Related
E	Health
F	Mental Health, Crisis Intervention
G	Diseases, Disorders, Medical Disciplines
H	Medical Research
I	Crime, Legal Related
J	Employment, Job Related
K	Food, Agriculture, and Nutrition
L	Housing, Shelter
M	Public Safety
N	Recreation, Sports, Leisure, Athletics
O	Youth Development
P	Human Services - Multipurpose and Other
Q	International, Foreign Affairs, and National Security
R	Civil Rights, Social Action, Advocacy
S	Community Improvement, Capacity Building
T	Philanthropy, Voluntarism, and Grantmaking Foundations
U	Science and Technology Research Institutes, Services
V	Social Science Research Institutes, Services
W	Public, Society Benefit - Multipurpose and Other
X	Religion Related, Spiritual Development
Y	Mutual/Membership Benefit Organizations, Other
Z	Unknown

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