SOI 2012 990 Comp

Number of variables37
Number of records0

Field Name
Field Type
Description and Values
Basic Info
EIN
Character
(9)
Employer Identification Number
Employer identification number (Page 1, Line D)
FisYr
Character
(4)
Fiscal year
Fiscal year (ending year)
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 codes
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
SUBSECCD
Character
(20)
Subsection code
IRS subsection code (03=501(c)(3), etc.)
0101- Corporations originated under Act of Congress, including Federal Credit Unions
0202- Title holding corporation for a tax-exempt organization.
0303- Religious, educational, charitable, scientific, and literary organizations...
0404- Civic leagues, social welfare organizations, and local associations of employees
0505- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps...
0606- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions...
0707- Social and recreational clubs which provide pleasure, recreation, and social activities.
0808- Fraternal beneficiary societies and associations, with lodges providing for payment of life...
0909- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary...
1010- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable...
1111- Teachers retirement fund associations.
1212- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop...
1313- Cemetery companies, providing burial and incidental activities for members.
1414- State-chartered credit unions, mutual reserve funds, offering loans to members...
1515- Mutual insurance cos. ar associations, providing insurance to members substantially at cost...
1616- Cooperative organizations to finance crop operations, in conjunction with activities ...
1717- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp...
1818- Employee funded pension trusts, providing benefits under a pension plan funded by employees...
1919- Post or organization of war veterans.
2020- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans.
2121- Black lung trusts, satisfying claims for compensation under Black Lung Acts.
2222- Multiemployer Pension Plan
2323- Veterans association formed prior to 1880
2424-Trust described in Section 4049 of ERISA
2525- Title Holding Company for Pensions, etc
2626- State-Sponsored High Risk Health Insurance Organizations
2727- State-Sponsored Workers Compensation Reinsurance
4040- Apostolic and religious orgs. - 501(d)
5050- Cooperative Hospital Service Organization - 501(e)
6060- Cooperative Service Org. of Operating Educ. Org.- 501(f)
7070- Child Care Organization - 501(k)
7171- Charitable Risk Pool
8080- Farmers' Cooperatives
8181- Qualified State-Sponsored Tuition Program
8282- 527 Political Organizations
9090- 4947(a)(2) Split Interest Trust
9191- 4947(a)(1) Public Charity (Files 990/990-EZ)
9292- 4947(a)(1) Private Foundations
9393- 1381(a)(2) Taxable Farmers Cooperative
COCO- Unspecified 501(c) Organization Other Than 501(c)(3)
NAICS
Character
(9)
North American Industrial Clas
North American Industrial Classification System
NTEE1
Character
(9)
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
LEVEL1
Character
(6)
Public charity or priv. fndn?
Public charity or private foundation?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(6)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(6)
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
(6)
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