SOI 2012 990PF All Years

Number of variables	321
Number of records	0

Field Name
Field Type

Description and Values

Basic Info

TaxYr
Character
(4)

Tax Year (Match records to sub-tables using TaxYr and SCPL)
SOI Sample Tax Year (Records are matched to sub-tables using TaxYr and SCPL) (Top of form - Form Tax Year)
Available Years: All

EIN
Character
(9)

Employer Identification Number
Employer Identification Number (Top of form - Box A)
Available Years: All

E010
Character
(4)

Accounting Period
Accounting Period (Top of form - Accounting Period)
Available Years: All

NAME
Character
(60)

Name of Organization
Name of Organization (Top of form - Name of foundation)
Available Years: All

STATE
Character
(2)

State
State (Top of form - State)
Available Years: All

zip5
Character
(5)

Zip code
Zip code (Top of form - Zip Code)
Available Years: All (missing values found 1985-1998)

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
(4)

Metropolitan Statistical Area
Metropolitan Statistical Area (NCCS file) (list)

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

E005
Character
(20)

Return Status Code
Return Status Code (Top of form - Box G)
Available Years: All

A	A - Amended return
C	C - Address Change
F	F - Final return
I	I - Initial return
N	N - Name Change

E050
Character
(20)

Type of Foundation Code
Type of Foundation Code (Top of form - Box H)
Available Years: All

E	E - Private Foundation
T	T - Charitable Trust

E090
Character
(20)

Accounting Method
Accounting Method (Top of form - Box J)
Available Years: 1990 - current

A	Accrual
C	Cash
O	Other

E070
Character
(20)

507(b)1(A) Termination
507(b)1(A) Termination (Top of form - Box E)
Available Years: All

N	No
Y	Yes

E100
Numeric
(20)

Fair Market Value of Assets
Fair Market Value of Assets (Top of form - Box I)
Available Years: All

Part I - Analysis of Revenue and Expenses

R010
Numeric
(20)

Contributions, Gifts, Grants, Etc. Received
Contributions, Gifts, Grants, Etc. Received (Part I - Line 1, Column a)
Available Years: All

R020
Numeric
(20)

Interest
Interest (Part I - Line 3, Column a)
Available Years: All

R030
Numeric
(20)

Dividends
Dividends (Part I - Line 4, Column a)
Available Years: All

R040
Numeric
(20)

Gross Rents
Gross Rents (Part I - Line 5a, Column a)
Available Years: All

R050
Numeric
(20)

Net Gain (Loss) from Sale of Assets
Net Gain (Loss) from Sale of Assets (Part I - Line 6a, Column a)
Available Years: All

R060
Numeric
(20)

Gross Profit (Loss) from Business Activities
Gross Profit (Loss) from Business Activities (Part I - Line 10c, Column a)
Available Years: All

R070
Numeric
(20)

Other Income (Loss)
Other Income (Loss) (Part I - Line 11, Column a)
Available Years: All

R080
Numeric
(20)

Total Income (Loss) Col. A
Total Income (Loss) Col. A (Part I - Line 12, Column a)
Available Years: All

X010
Numeric
(20)

Compensation of Officers-Col. A
Compensation of Officers-Col. A (Part I - Line 13, Column a)
Available Years: All

X020
Numeric
(20)

Other Salaries and Wages-Col. A
Other Salaries and Wages-Col. A (Part I - Line 14, Column a)
Available Years: All

X030
Numeric
(20)

Pension Plans-Col. A
Pension Plans-Col. A (Part I - Line 15, Column a)
Available Years: All

X040
Numeric
(20)

Legal Fees-Col. A
Legal Fees-Col. A (Part I - Line 16a, Column a)
Available Years: All

X050
Numeric
(20)

Accounting Fees-Col. A
Accounting Fees-Col. A (Part I - Line 16b, Column a)
Available Years: All

X060
Numeric
(20)

Other Professional Fees-Col. A
Other Professional Fees-Col. A (Part I - Line 16c, Column a)
Available Years: All

X070
Numeric
(20)

Interest-Col. A
Interest-Col. A (Part I - Line 17, Column a)
Available Years: All

X080
Numeric
(20)

Taxes-Col. A
Taxes-Col. A (Part I - Line 18, Column a)
Available Years: All

X090
Numeric
(20)

Depreciation & Depletion
Depreciation & Depletion (Part I - Line 19, Column a)
Available Years: All

X100
Numeric
(20)

Occupancy-Col. A
Occupancy-Col. A (Part I - Line 20, Column a)
Available Years: All

X110
Numeric
(20)

Travel, Conferences, Meetings-Col. A
Travel, Conferences, Meetings-Col. A (Part I - Line 21, Column a)
Available Years: All

X120
Numeric
(20)

Printing and Publications-Col. A
Printing and Publications-Col. A (Part I - Line 22, Column a)
Available Years: All

X130
Numeric
(20)

Other Expenses-Col. A
Other Expenses-Col. A (Part I - Line 23, Column a)
Available Years: All

X140
Numeric
(20)

Contributions, Gifts, Grants Paid-Col. A
Contributions, Gifts, Grants Paid-Col. A (Part I - Line 25, Column a)
Available Years: All

X150
Numeric
(20)

Total Expenses-Col. A
Total Expenses-Col. A (Part I - Line 26, Column a)
Available Years: All

X160
Numeric
(20)

Excess Revenue Over Expenses
Excess Revenue Over Expenses (Part I - Line 27a, Column a)
Available Years: All

R090
Numeric
(20)

Capital Gain Net Income
Capital Gain Net Income (Part I - Line 7b, Column b)
Available Years: All

R100
Numeric
(20)

Total Income (Loss) Col. B
Total Income (Loss) Col. B (Part I - Line 12, Column b)
Available Years: All

X170
Numeric
(20)

Total Expenses-Col. B
Total Expenses-Col. B (Part I - Line 26, Column b)
Available Years: All

X180
Numeric
(20)

Net Investment Income
Net Investment Income (Part I - Line 27b, Column b)
Available Years: All

X190
Numeric
(20)

Compensation of Officers-Col. D
Compensation of Officers-Col. D (Part I - Line 13, Column d)
Available Years: All

X200
Numeric
(20)

Other Salaries and Wages-Col. D
Other Salaries and Wages-Col. D (Part I - Line 14, Column d)
Available Years: All

X210
Numeric
(20)

Pension Plans-Col. D
Pension Plans-Col. D (Part I - Line 15, Column d)
Available Years: All

X220
Numeric
(20)

Legal Fees-Col. D
Legal Fees-Col. D (Part I - Line 16a, Column d)
Available Years: All

X230
Numeric
(20)

Accounting Fees-Col. D
Accounting Fees-Col. D (Part I - Line 16b, Column d)
Available Years: All

X240
Numeric
(20)

Other Professional Fees-Col. D
Other Professional Fees-Col. D (Part I - Line 16c, Column d)
Available Years: All

X250
Numeric
(20)

Interest-Col. D
Interest-Col. D (Part I - Line 17, Column d)
Available Years: All

X260
Numeric
(20)

Taxes-Col. D
Taxes-Col. D (Part I - Line 18, Column d)
Available Years: All

X270
Numeric
(20)

Occupancy-Col. D
Occupancy-Col. D (Part I - Line 20, Column d)
Available Years: All

X280
Numeric
(20)

Travel, Conferences, Meetings-Col. D
Travel, Conferences, Meetings-Col. D (Part I - Line 21, Column d)
Available Years: All

X290
Numeric
(20)

Printing and Publications-Col. D
Printing and Publications-Col. D (Part I - Line 22, Column d)
Available Years: All

X300
Numeric
(20)

Other Expenses-Col. D
Other Expenses-Col. D (Part I - Line 23, Column d)
Available Years: All

X310
Numeric
(20)

Contributions, Gifts, Grants Paid-Col. D
Contributions, Gifts, Grants Paid-Col. D (Part I - Line 25, Column d)
Available Years: All

X320
Numeric
(20)

Total Expenses-Col. D
Total Expenses-Col. D (Part I - Line 26, Column d)
Available Years: All

Part II - Balance Sheets

A001
Numeric
(20)

Cash-Col. A
Cash-Col. A (Part II - Line 1, Column a)
Available Years: 1999 - current

A002
Numeric
(20)

Savings-Col. A
Savings-Col. A (Part II - Line 2, Column a)
Available Years: 1999 - current

A003
Numeric
(20)

Accounts Receivable-Col. A
Accounts Receivable-Col. A (Part II - Line 3, Column a)
Available Years: 1999 - current

A004
Numeric
(20)

Pledges Receivable-Col. A
Pledges Receivable-Col. A (Part II - Line 4, Column a)
Available Years: 1999 - current

A005
Numeric
(20)

Grants Receivable-Col. A
Grants Receivable-Col. A (Part II - Line 5, Column a)
Available Years: 1999 - current

A006
Numeric
(20)

Receivables Due from Officers-Col. A
Receivables Due from Officers-Col. A (Part II - Line 6, Column a)
Available Years: 1999 - current

A007
Numeric
(20)

Other Notes & Loans Receivable-Col. A
Other Notes & Loans Receivable-Col. A (Part II - Line 7, Column a)
Available Years: 1999 - current

A008
Numeric
(20)

Inventories-Col. A
Inventories-Col. A (Part II - Line 8, Column a)
Available Years: 1999 - current

A009
Numeric
(20)

Prepaid Expenses-Col. A
Prepaid Expenses-Col. A (Part II - Line 9, Column a)
Available Years: 1999 - current

A010
Numeric
(20)

Investments-Government Obligations-Col. A
Investments-Government Obligations-Col. A (Part II - Line 10a, Column a)
Available Years: 1990 - current

A020
Numeric
(20)

Investments-Corporate Stock-Col. A
Investments-Corporate Stock-Col. A (Part II - Line 10b, Column a)
Available Years: 1990 - current

A030
Numeric
(20)

Investments-Corporate Bonds-Col. A
Investments-Corporate Bonds-Col. A (Part II - Lines 10c, Column a)
Available Years: 1990 - current

A031
Numeric
(20)

Investments-Land, Buildings, & Equipment-Col. A
Investments-Land, Buildings, & Equipment-Col. A (Part II - Line 11, Column a)
Available Years: 1999 - current

A032
Numeric
(20)

Investments-Mortgage Loans-Col. A
Investments-Mortgage Loans-Col. A (Part II - Line 12, Column a)
Available Years: 1999 - current

A033
Numeric
(20)

Investments-Other-Col. A
Investments-Other-Col. A (Part II - Line 13, Column a)
Available Years: 1999 - current

A034
Numeric
(20)

Land, Buildings, and Equipment-Col. A
Land, Buildings, and Equipment-Col. A (Part II - Line 14, Column a)
Available Years: 1999 - current

A035
Numeric
(20)

Other Assets-Col. A
Other Assets-Col. A (Part II - Line 15, Column a)
Available Years: 1999 - current

A040
Numeric
(20)

Total Assets-Col. A
Total Assets-Col. A (Part II - Line 16, Column a)
Available Years: All

L010
Numeric
(20)

Total Liabilities-Col. A
Total Liabilities-Col. A (Part II - Line 23, Column a)
Available Years: All

N010
Numeric
(20)

Total Fund Balances/Net Worth-Col. A
Total Fund Balances/Net Worth-Col. A (Part II - Line 30, Column a)
Available Years: All

A050
Numeric
(20)

Cash-Col. B
Cash-Col. B (Part II - Line 1, Column b)
Available Years: All

A060
Numeric
(20)

Savings-Col. B
Savings-Col. B (Part II - Line 2, Column b)
Available Years: All

A070
Numeric
(20)

Accounts Receivable-Col. B
Accounts Receivable-Col. B (Part II - Line 3, Column b)
Available Years: All

A080
Numeric
(20)

Pledges Receivable-Col. B
Pledges Receivable-Col. B (Part II - Line 4, Column b)
Available Years: All

A090
Numeric
(20)

Grants Receivable-Col. B
Grants Receivable-Col. B (Part II - Line 5, Column b)
Available Years: All

A100
Numeric
(20)

Receivables Due from Officers-Col. B
Receivables Due from Officers-Col. B (Part II - Line 6, Column b)
Available Years: All

A110
Numeric
(20)

Other Notes & Loans Receivable-Col. B
Other Notes & Loans Receivable-Col. B (Part II - Line 7, Column b)
Available Years: All

A120
Numeric
(20)

Inventories-Col. B
Inventories-Col. B (Part II - Line 8, Column b)
Available Years: All

A130
Numeric
(20)

Prepaid Expenses-Col. B
Prepaid Expenses-Col. B (Part II - Line 9, Column b)
Available Years: All

A140
Numeric
(20)

Investments-Government Obligations-Col. B
Investments-Government Obligations-Col. B (Part II - Line 10a, Column b)
Available Years: 1990 - current

A150
Numeric
(20)

Investments-Corporate Stock-Col. B
Investments-Corporate Stock-Col. B (Part II - Line 10b, Column b)
Available Years: 1990 - current

A160
Numeric
(20)

Investments-Corporate Bonds-Col. B
Investments-Corporate Bonds-Col. B (Part II - Lines 10c, Column b)
Available Years: 1990 - current

A170
Numeric
(20)

Investments-Land, Buildings, & Equipment-Col. B
Investments-Land, Buildings, & Equipment-Col. B (Part II - Line 11, Column b)
Available Years: All

A180
Numeric
(20)

Investments-Mortgage Loans-Col. B
Investments-Mortgage Loans-Col. B (Part II - Line 12, Column b)
Available Years: All

A190
Numeric
(20)

Investments-Other-Col. B
Investments-Other-Col. B (Part II - Line 13, Column b)
Available Years: All

A200
Numeric
(20)

Land, Buildings, and Equipment-Col. B
Land, Buildings, and Equipment-Col. B (Part II - Line 14, Column b)
Available Years: All

A210
Numeric
(20)

Other Assets-Col. B
Other Assets-Col. B (Part II - Line 15, Column b)
Available Years: All

A220
Numeric
(20)

Total Assets-Col. B
Total Assets-Col. B (Part II - Line 16, Column b)
Available Years: All

L020
Numeric
(20)

Total Liabilities-Col. B
Total Liabilities-Col. B (Part II - Line 23, Column b)
Available Years: All

N020
Numeric
(20)

Total Fund Balances/Net Worth-Col. B
Total Fund Balances/Net Worth-Col. B (Part II - Line 30, Column b)
Available Years: All

A230
Numeric
(20)

Cash-Col. C
Cash-Col. C (Part II - Line 1, Column c)
Available Years: All

A240
Numeric
(20)

Savings-Col. C
Savings-Col. C (Part II - Line 2, Column c)
Available Years: All

A250
Numeric
(20)

Accounts Receivable-Col. C
Accounts Receivable-Col. C (Part II - Line 3, Column c)
Available Years: All

A260
Numeric
(20)

Pledges Receivable-Col. C
Pledges Receivable-Col. C (Part II - Line 4, Column c)
Available Years: All

A270
Numeric
(20)

Grants Receivable-Col. C
Grants Receivable-Col. C (Part II - Line 5, Column c)
Available Years: All

A280
Numeric
(20)

Receivables Due from Officers-Col. C
Receivables Due from Officers-Col. C (Part II - Line 6, Column c)
Available Years: All

A290
Numeric
(20)

Other Notes & Loans Receivable-Col. C
Other Notes & Loans Receivable-Col. C (Part II - Line 7, Column c)
Available Years: All

A300
Numeric
(20)

Inventories-Col. C
Inventories-Col. C (Part II - Line 8, Column c)
Available Years: All

A310
Numeric
(20)

Prepaid Expenses-Col. C
Prepaid Expenses-Col. C (Part II - Line 9, Column c)
Available Years: All

A320
Numeric
(20)

Investments-Government Obligations-Col. C
Investments-Government Obligations-Col. C (Part II - Line 10a, Column c)
Available Years: 1990 - current

A330
Numeric
(20)

Investments-Corporate Stock-Col. C
Investments-Corporate Stock-Col. C (Part II - Line 10b, Column c)
Available Years: 1990 - current

A340
Numeric
(20)

Investments-Corporate Bonds-Col. C
Investments-Corporate Bonds-Col. C (Part II - Line 10c, Column c)
Available Years: 1990 - current

A350
Numeric
(20)

Investments-Land, Buildings, & Equipment-Col. C
Investments-Land, Buildings, & Equipment-Col. C (Part II - Line 11, Column c)
Available Years: All

A360
Numeric
(20)

Investments-Mortgage Loans-Col. C
Investments-Mortgage Loans-Col. C (Part II - Line 12, Column c)
Available Years: All

A370
Numeric
(20)

Investments-Other-Col. C
Investments-Other-Col. C (Part II - Line 13, Column c)
Available Years: All

A380
Numeric
(20)

Land, Buildings, and Equipment-Col. C
Land, Buildings, and Equipment-Col. C (Part II - Line 14, Column c)
Available Years: All

A390
Numeric
(20)

Other Assets-Col. C
Other Assets-Col. C (Part II - Line 15, Column c)
Available Years: All

A400
Numeric
(20)

Total Assets-Col. C
Total Assets-Col. C (Part II - Line 16, Column c)
Available Years: All

Part III - Analysis of Changes in Net Assets or Fund Balances

B010
Numeric
(20)

Other Net Worth Increases
Other Net Worth Increases (Part III - Line 3)
Available Years: All

B020
Numeric
(20)

Net Worth Decreases
Net Worth Decreases (Part III - Line 5)
Available Years: All

Part IV - Capital Gains and Losses for Tax on Investment Income

R190
Numeric
(20)

Capital Gain Net Income
Capital Gain Net Income (Part IV - Line 2)
Available Years: 1989 - current

Part V - Qualification Under Section 4940(e)

T010
Numeric
(20)

Average Payout Ratio
Average Payout Ratio (Part V - Line 3)
Available Years: All

T020
Numeric
(20)

Net Investment Assets
Net Investment Assets (Part V - Line 4)
Available Years: All

T030
Numeric
(20)

Multiply Line 4 by Line 3
Multiply Line 4 by Line 3 (Part V - Line 5)
Available Years: All

Part VI - Excise Tax Based on Investment Income

T050
Character
(1)

Section 4940 Code
Section 4940 Code (Part VI - Line 1)
Available Years: All

T053
Numeric
(1)

Section 511 Tax
Section 511 Tax (Part VI - Line 2)
Available Years: 2004 - current

T055
Numeric
(1)

Subtitle A Income Tax
Subtitle A Income Tax (Part VI - Line 4)
Available Years: 2001 - current

T060
Numeric
(1)

Tax on Investment Income
Tax on Investment Income (Part VI - Line 5)
Available Years: All

Part VII-A and VII-B - Statements Regarding Activities

Q010
Character
(1)

Unrelated business gross income over $1000 question
Unrelated business gross income over $1000 question (Part VII-A - Question 4a)
Available Years: All

N	No
Y	Yes

Q015
Character
(1)

Filed 990-T question
Filed 990-T question (Part VII-A - Question 4b)
Available Years: 2002 - current

N	No
Y	Yes

Q020
Character
(1)

Contraction question
Contraction question (Part VII-A - Question 5)
Available Years: All

N	No
Y	Yes

Q030
Character
(1)

Claiming status as private operating foundation question
Claiming status as private operating foundation question (Part VII-A - Question 9)
Available Years: All

N	No
Y	Yes

Q130
Character
(1)

Direct indirect ownership of controlled entity question
Direct indirect ownership of controlled entity question (Part VII-A - Question 11)
Available Years: 2006 - current

N	No
Y	Yes

Q140
Character
(1)

Acquire interest in applicable insurance contract question
Acquire interest in applicable insurance contract question (Part VII-A - Question 12)
Available Years: 2006 - 2010

N	No
Y	Yes

Q150
Character
(1)

Distribution to donor advised fund with advisory privileges
Distribution to donor advised fund with advisory privileges question (Part VII-A - Question 12)
Available Years: 2011

N	No
Y	Yes

Q032A
Character
(1)

Property exchange question
Property exchange question (Part VII-B - Question 1a1)
Available Years: 2002 - current

N	No
Y	Yes

Q032B
Character
(1)

Borrow lend money question
Borrow lend money question (Part VII-B - Question 1a2)
Available Years: 2002 - current

N	No
Y	Yes

Q032C
Character
(1)

Furnished goods question
Furnished goods question (Part VII-B - Question 1a3)
Available Years: 2002 - current

N	No
Y	Yes

Q032D
Character
(1)

Paid compensation question
Paid compensation question (Part VII-B - Question 1a4)
Available Years: 2002 - current

N	No
Y	Yes

Q032E
Character
(1)

Transfer question
Transfer question (Part VII-B - Question 1a5)
Available Years: 2002 - current

N	No
Y	Yes

Q032F
Character
(1)

Agree to make pay question
Agree to make pay question (Part VII-B - Question 1a6)
Available Years: 2002 - current

N	No
Y	Yes

Q034
Character
(1)

Acts fail to qualify under section 53.4941(d)-3 question
Acts fail to qualify under section 53.4941(d)-3 question (Part VII-B - Question 1b)
Available Years: 2002 - current

N	No
Y	Yes

Q035
Character
(1)

Rely on notice regarding disaster assistance question
Rely on notice regarding disaster assistance question (Part VII-B - Question 1b checkbox)
Available Years: 2002 - current

N	No
Y	Yes

Q036
Character
(1)

Engage in acts in prior year question
Engage in acts in prior year question (Part VII-B - Question 1c)
Available Years: 2002 - current

N	No
Y	Yes

Q040
Character
(1)

Undistributed income question
Undistributed income question (Part VII-B - Question 2a)
Available Years: 1989 - current

N	No
Y	Yes

Q045
Character
(1)

Not applying section 4942(a)(2) provisions question
Not applying section 4942(a)(2) provisions question (Part VII-B - Question 2b)
Available Years: 2002 - current

N	No
Y	Yes

Q048
Character
(1)

Direct indirect interest in business enterprise question
Direct indirect interest in business enterprise question (Part VII-B - Question 3a)
Available Years: 2002 - current

N	No
Y	Yes

Q050
Character
(1)

Excess business holdings question
Excess business holdings question (Part VII-B - Question 3b)
Available Years: 1989 - current

N	No
Y	Yes

Q052
Character
(1)

Jeopardizing investments question
Jeopardizing investments question (Part VII-B - Question 4a)
Available Years: 2002 - current

N	No
Y	Yes

Q054
Character
(1)

Prior year jeopardizing investments question
Prior year jeopardizing investments question (Part VII-B - Question 4b)
Available Years: 2002 - current

N	No
Y	Yes

Q056A
Character
(1)

Propaganda question
Propaganda question (Part VII-B - Question 5a1)
Available Years: 2002 - current

N	No
Y	Yes

Q056B
Character
(1)

Influence public election question
Influence public election question (Part VII-B - Question 5a2)
Available Years: 2002 - current

N	No
Y	Yes

Q056C
Character
(1)

Grant individual question
Grant individual question (Part VII-B - Question 5a3)
Available Years: 2002 - current

N	No
Y	Yes

Q056D
Character
(1)

Non-charity grant question
Non-charity grant question (Part VII-B - Question 5a4)
Available Years: 2002 - current

N	No
Y	Yes

Q056E
Character
(1)

Non-religious purposes question
Non-religious purposes question (Part VII-B - Question 5a5)
Available Years: 2002 - current

N	No
Y	Yes

Q057
Character
(1)

Transactions fail to qualify under section 53.4945 question
Transactions fail to qualify under section 53.4945 question (Part VII-B - Question 5b)
Available Years: 2002 - current

N	No
Y	Yes

Q058
Character
(1)

Rely on notice regarding disaster assistance question
Rely on notice regarding disaster assistance question (Part VII-B - Question 5b checkbox)
Available Years: 2002 - current

N	No
Y	Yes

Q059
Character
(1)

Expenditure responsibility question
Expenditure responsibility question (Part VII-B - Question 5c)
Available Years: 2002 - current

N	No
Y	Yes

Q060
Character
(1)

Receive funds to pay premiums on personal benefit contract
Receive funds to pay premiums on personal benefit contract question (Part VII-B - Question 6a)
Available Years: 2000 - current

N	No
Y	Yes

Q070
Character
(1)

Pay premiums on personal benefit contract question
Pay premiums on personal benefit contract question (Part VII-B - Question 6b)
Available Years: 2000 - current

N	No
Y	Yes

Part VIII - Officers, Directors, Trustees, Foundation Managers, etc.

C100
Character
(3)

Number of Uncompensated Officers, Directors, etc.
Number of Uncompensated Officers, Directors, etc. (Part VIII - n/a)
Available Years: 1993 - current

H010
Character
(2)

Average Hours Per Week-Emp1
Average Hours Per Week-Emp1 (Part VIII - Line 2, Column b, Row 1)
Available Years: 1993 - current

H020
Numeric
(2)

Compensation-Emp1
Compensation-Emp1 (Part VIII - Line 2, Column c, Row 1)
Available Years: 1993 - current

H030
Numeric
(2)

Contributions to Employee Benefit Plans-Emp1
Contributions to Employee Benefit Plans-Emp1 (Part VIII - Line 2, Column d, Row 1)
Available Years: 1993 - current

H040
Numeric
(2)

Expense Account/Other Allowances-Emp1
Expense Account/Other Allowances-Emp1 (Part VIII - Line 2, Column e, Row 1)
Available Years: 1993 - current

H110
Character
(2)

Average Hours Per Week-Emp2
Average Hours Per Week-Emp2 (Part VIII - Line 2, Column b, Row 2)
Available Years: 1993 - current

H120
Numeric
(2)

Compensation-Emp2
Compensation-Emp2 (Part VIII - Line 2, Column c, Row 2)
Available Years: 1993 - current

H130
Numeric
(2)

Contributions to Employee Benefit Plans-Emp2
Contributions to Employee Benefit Plans-Emp2 (Part VIII - Line 2, Column d, Row 2)
Available Years: 1993 - current

H140
Numeric
(2)

Expense Account/Other Allowances-Emp2
Expense Account/Other Allowances-Emp2 (Part VIII - Line 2, Column e, Row 2)
Available Years: 1993 - current

H210
Character
(2)

Average Hours Per Week-Emp3
Average Hours Per Week-Emp3 (Part VIII - Line 2, Column b, Row 3)
Available Years: 1993 - current

H220
Numeric
(2)

Compensation-Emp3
Compensation-Emp3 (Part VIII - Line 2, Column c, Row 3)
Available Years: 1993 - current

H230
Numeric
(2)

Contributions to Employee Benefit Plans-Emp3
Contributions to Employee Benefit Plans-Emp3 (Part VIII - Line 2, Column d, Row 3)
Available Years: 1993 - current

H240
Numeric
(2)

Expense Account/Other Allowances-Emp3
Expense Account/Other Allowances-Emp3 (Part VIII - Line 2, Column e, Row 3)
Available Years: 1993 - current

H310
Character
(2)

Average Hours Per Week-Emp4
Average Hours Per Week-Emp4 (Part VIII - Line 2, Column b, Row 4)
Available Years: 1993 - current

H320
Numeric
(2)

Compensation-Emp4
Compensation-Emp4 (Part VIII - Line 2, Column c, Row 4)
Available Years: 1993 - current

H330
Numeric
(2)

Contributions to Employee Benefit Plans-Emp4
Contributions to Employee Benefit Plans-Emp4 (Part VIII - Line 2, Column d, Row 4)
Available Years: 1993 - current

H340
Numeric
(2)

Expense Account/Other Allowances-Emp4
Expense Account/Other Allowances-Emp4 (Part VIII - Line 2, Column e, Row 4)
Available Years: 1993 - current

H410
Character
(2)

Average Hours Per Week-Emp5
Average Hours Per Week-Emp5 (Part VIII - Line 2, Column b, Row 5)
Available Years: 1993 - current

H420
Numeric
(2)

Compensation-Emp5
Compensation-Emp5 (Part VIII - Line 2, Column c, Row 5)
Available Years: 1993 - current

H430
Numeric
(2)

Contributions to Employee Benefit Plans-Emp5
Contributions to Employee Benefit Plans-Emp5 (Part VIII - Line 2, Column d, Row 5)
Available Years: 1993 - current

H440
Numeric
(2)

Expense Account/Other Allowances-Emp5
Expense Account/Other Allowances-Emp5 (Part VIII - Line 2, Column e, Row 5)
Available Years: 1993 - current

H500
Character
(3)

Total Number of Other Employees Paid >$50,000
Total Number of Other Employees Paid >$50,000 (Part VIII - Line 2)
Available Years: 1993 - current

Part X - Minimum Investment Return

M010
Numeric
(3)

Line 3 Minus Line 4
Line 3 Minus Line 4 (Part X - Line 5)
Available Years: All

M020
Numeric
(3)

5% of Line 5
5% of Line 5 (Part X - Line 6)
Available Years: All

Part XI - Distributable Amount

M030
Numeric
(3)

Tax on Investment Income
Tax on Investment Income (Part XI - Line 2a)
Available Years: All

M040
Numeric
(3)

Income Tax Under Subtitle A
Income Tax Under Subtitle A (Part XI - Line 2b)
Available Years: All

M050
Numeric
(3)

Recoveries
Recoveries (Part XI - Line 4)
Available Years: All

M070
Numeric
(3)

Deductions from Distributable Amount
Deductions from Distributable Amount (Part XI - Line 6)
Available Years: All

M080
Numeric
(3)

Distributable Amount as Adjusted
Distributable Amount as Adjusted (Part XI - Line 7)
Available Years: All

Part XII - Qualifying Distributions

D010
Numeric
(3)

Expenses, Contributions, Gifts, Etc.
Expenses, Contributions, Gifts, Etc. (Part XII - Line 1a)
Available Years: All

D020
Numeric
(3)

Program Related Investments
Program Related Investments (Part XII - Line 1b)
Available Years: All

D030
Numeric
(3)

Amount Paid To Acquire Assets
Amount Paid To Acquire Assets (Part XII - Line 2)
Available Years: All

D040
Numeric
(3)

Suitability Test
Suitability Test (Part XII - Line 3a)
Available Years: All

D050
Numeric
(3)

Cash Distribution Test
Cash Distribution Test (Part XII - Line 3b)
Available Years: All

D060
Numeric
(3)

Total Qualifying Distributions
Total Qualifying Distributions (Part XII - Line 4)
Available Years: All

Part XIII - Undistributed Income

U010
Numeric
(3)

Prior Excess Distributions Carryover
Prior Excess Distributions Carryover (Part XIII - Line 3f, Column a)
Available Years: All

U020
Numeric
(3)

Distributions Out of Corpus
Distributions Out of Corpus (Part XIII - Line 4c, Column a)
Available Years: All

U030
Numeric
(3)

Remaining Amount Distributed
Remaining Amount Distributed (Part XIII - Line 4e, Column a)
Available Years: All

U040
Numeric
(3)

Excess Distributions Carryover Applied
Excess Distributions Carryover Applied (Part XIII - Line 5, Column a)
Available Years: All

U050
Numeric
(3)

Total Net Corpus
Total Net Corpus (Part XIII - Line 6a, Column a)
Available Years: All

U060
Numeric
(3)

Amounts Treated As Distributions
Amounts Treated As Distributions (Part XIII - Line 7a, Column a)
Available Years: All

U070
Numeric
(3)

Excess Distributions Carryover From 1st Prior Year
Excess Distributions Carryover From 1st Prior Year (Part XIII - Line 8, Column a)
Available Years: All

U080
Numeric
(3)

Excess Distributions Carryover to Next Year
Excess Distributions Carryover to Next Year (Part XIII - Line 9, Column a)
Available Years: All

U085
Numeric
(3)

Undistributed Income - Prior Years
Undistributed Income - Prior Years (Part XIII - Line 2b, Column b)
Available Years: 2002 - current

U090
Numeric
(3)

Applied to Undistributed Income - Prior years
Applied to Undistributed Income - Prior years (Part XIII - Line 4b, Column b)
Available Years: 1990 - current

U094
Numeric
(3)

Prior Years Undistributed Income - Notice issued
Prior Years Undistributed Income - Notice issued (Part XIII - Line 6c, Column b)
Available Years: 2002 - current

U096
Numeric
(3)

Undistributed Income - Taxable Amount
Undistributed Income - Taxable Amount (Part XIII - Line 6d, Column b)
Available Years: 2002 - current

U100
Numeric
(3)

Undistributed Income - Previous Year
Undistributed Income - Previous Year (Part XIII - Line 2a, Column c)
Available Years: 1991 - current

U110
Numeric
(3)

Applied to Undistributed Income - Previous Year
Applied to Undistributed Income - Previous Year (Part XIII - Line 4a, Column c)
Available Years: 1990 - current

U120
Numeric
(3)

Undistributed Income for Prior Years
Undistributed Income for Prior Years (Part XIII - Line 6e, Column c)
Available Years: 1991 - current

U130
Numeric
(3)

Distributable Amount
Distributable Amount (Part XIII - Line 1, Column d)
Available Years: All

U140
Numeric
(3)

Qualifying Distributions Applied
Qualifying Distributions Applied (Part XIII - Line 4d, Column d)
Available Years: All

U150
Numeric
(3)

Undistributed Income
Undistributed Income (Part XIII - Line 6f, Column d)
Available Years: All

Part XIV and Part XVII Data Indicators

Q100
Character
(3)

Part XIV (Operating Foundation Question) filled out?
Part XIV (Operating Foundation Question) filled out? (Part XIV - n/a)
Available Years: All

N	No
Y	Yes

Q200
Character
(3)

Info Re: Transfers/Transactions 1a-c "Yes"?
Info Re: Transfers/Transactions 1a-c "Yes"? (Part XVII - Question 1)
Available Years: 1990 - current

N	No
Y	Yes

Q300
Character
(3)

Info Re: Transfers/Transactions 2a "Yes"?
Info Re: Transfers/Transactions 2a "Yes"? (Part XVII - Question 2a)
Available Years: 1990 - current

N	No
Y	Yes

Part XVI-A - Analysis of Income-Producing Activities

I001
Character
(6)

Program Service (a) Business Code-Col. A
Program Service (a) Business Code-Col. A (Part XVI-A - Line 1a, Column a)
Available Years: 1999 - current

I002
Numeric
(6)

Program Service (a) Amount-Col. B
Program Service (a) Amount-Col. B (Part XVI-A - Line 1a, Column b)
Available Years: 1999 - current

I003
Character
(2)

Program Service (a) Exclusion Code-Col. C
Program Service (a) Exclusion Code-Col. C (Part XVI-A - Line 1a, Column c)
Available Years: 1999 - current

I004
Numeric
(2)

Program Service (a) Amount-Col. D
Program Service (a) Amount-Col. D (Part XVI-A - Line 1a, Column d)
Available Years: 1999 - current

I005
Numeric
(2)

Program Service (a) Amount-Col. E
Program Service (a) Amount-Col. E (Part XVI-A - Line 1a, Column e)
Available Years: 1999 - current

I011
Character
(6)

Program Service (b) Business Code-Col. A
Program Service (b) Business Code-Col. A (Part XVI-A - Line 1b, Column a)
Available Years: 1999 - current

I012
Numeric
(6)

Program Service (b) Amount-Col. B
Program Service (b) Amount-Col. B (Part XVI-A - Line 1b, Column b)
Available Years: 1999 - current

I013
Character
(2)

Program Service (b) Exclusion Code-Col. C
Program Service (b) Exclusion Code-Col. C (Part XVI-A - Line 1b, Column c)
Available Years: 1999 - current

I014
Numeric
(2)

Program Service (b) Amount-Col. D
Program Service (b) Amount-Col. D (Part XVI-A - Line 1b, Column d)
Available Years: 1999 - current

I015
Numeric
(2)

Program Service (b) Amount-Col. E
Program Service (b) Amount-Col. E (Part XVI-A - Line 1b, Column e)
Available Years: 1999 - current

I021
Character
(6)

Program Service (c) Business Code-Col. A
Program Service (c) Business Code-Col. A (Part XVI-A - Line 1c, Column a)
Available Years: 1999 - current

I022
Numeric
(6)

Program Service (c) Amount-Col. B
Program Service (c) Amount-Col. B (Part XVI-A - Line 1c, Column b)
Available Years: 1999 - current

I023
Character
(2)

Program Service (c) Exclusion Code-Col. C
Program Service (c) Exclusion Code-Col. C (Part XVI-A - Line 1c, Column c)
Available Years: 1999 - current

I024
Numeric
(2)

Program Service (c) Amount-Col. D
Program Service (c) Amount-Col. D (Part XVI-A - Line 1c, Column d)
Available Years: 1999 - current

I025
Numeric
(2)

Program Service (c) Amount-Col. E
Program Service (c) Amount-Col. E (Part XVI-A - Line 1c, Column e)
Available Years: 1999 - current

I031
Character
(6)

Program Service (d) Business Code-Col. A
Program Service (d) Business Code-Col. A (Part XVI-A - Line 1d, Column a)
Available Years: 1999 - current

I032
Numeric
(6)

Program Service (d) Amount-Col. B
Program Service (d) Amount-Col. B (Part XVI-A - Line 1d, Column b)
Available Years: 1999 - current

I033
Character
(2)

Program Service (d) Exclusion Code-Col. C
Program Service (d) Exclusion Code-Col. C (Part XVI-A - Line 1d, Column c)
Available Years: 1999 - current

I034
Numeric
(2)

Program Service (d) Amount-Col. D
Program Service (d) Amount-Col. D (Part XVI-A - Line 1d, Column d)
Available Years: 1999 - current

I035
Numeric
(2)

Program Service (d) Amount-Col. E
Program Service (d) Amount-Col. E (Part XVI-A - Line 1d, Column e)
Available Years: 1999 - current

I041
Character
(6)

Program Service (e) Business Code-Col. A
Program Service (e) Business Code-Col. A (Part XVI-A - Line 1e, Column a)
Available Years: 1999 - current

I042
Numeric
(6)

Program Service (e) Amount-Col. B
Program Service (e) Amount-Col. B (Part XVI-A - Line 1e, Column b)
Available Years: 1999 - current

I043
Character
(2)

Program Service (e) Exclusion Code-Col. C
Program Service (e) Exclusion Code-Col. C (Part XVI-A - Line 1e, Column c)
Available Years: 1999 - current

I044
Numeric
(2)

Program Service (e) Amount-Col. D
Program Service (e) Amount-Col. D (Part XVI-A - Line 1e, Column d)
Available Years: 1999 - current

I045
Numeric
(2)

Program Service (e) Amount-Col. E
Program Service (e) Amount-Col. E (Part XVI-A - Line 1e, Column e)
Available Years: 1999 - current

I051
Character
(6)

Program Service (f) Business Code-Col. A
Program Service (f) Business Code-Col. A (Part XVI-A - Line 1f, Column a)
Available Years: 1999 - current

I052
Numeric
(6)

Program Service (f) Amount-Col. B
Program Service (f) Amount-Col. B (Part XVI-A - Line 1f, Column b)
Available Years: 1999 - current

I053
Character
(2)

Program Service (f) Exclusion Code-Col. C
Program Service (f) Exclusion Code-Col. C (Part XVI-A - Line 1f, Column c)
Available Years: 1999 - current

I054
Numeric
(2)

Program Service (f) Amount-Col. D
Program Service (f) Amount-Col. D (Part XVI-A - Line 1f, Column d)
Available Years: 1999 - current

I055
Numeric
(2)

Program Service (f) Amount-Col. E
Program Service (f) Amount-Col. E (Part XVI-A - Line 1f, Column e)
Available Years: 1999 - current

I061
Character
(6)

Program Service (g) Business Code-Col. A
Program Service (g) Business Code-Col. A (Part XVI-A - Line 1g, Column a)
Available Years: 1999 - current

I062
Numeric
(6)

Program Service (g) Amount-Col. B
Program Service (g) Amount-Col. B (Part XVI-A - Line 1g, Column b)
Available Years: 1999 - current

I063
Character
(2)

Program Service (g) Exclusion Code-Col. C
Program Service (g) Exclusion Code-Col. C (Part XVI-A - Line 1g, Column c)
Available Years: 1999 - current

I064
Numeric
(2)

Program Service (g) Amount-Col. D
Program Service (g) Amount-Col. D (Part XVI-A - Line 1g, Column d)
Available Years: 1999 - current

I065
Numeric
(2)

Program Service (g) Amount-Col. E
Program Service (g) Amount-Col. E (Part XVI-A - Line 1g, Column e)
Available Years: 1999 - current

I071
Character
(6)

Membership Business Code-Col. A
Membership Business Code-Col. A (Part XVI-A - Line 2, Column a)
Available Years: 1999 - current

I072
Numeric
(6)

Membership Amount-Col. B
Membership Amount-Col. B (Part XVI-A - Line 2, Column b)
Available Years: 1999 - current

I073
Character
(2)

Membership Exclusion Code-Col. C
Membership Exclusion Code-Col. C (Part XVI-A - Line 2, Column c)
Available Years: 1999 - current

I074
Numeric
(2)

Membership Amount-Col. D
Membership Amount-Col. D (Part XVI-A - Line 2, Column d)
Available Years: 1999 - current

I075
Numeric
(2)

Membership Amount-Col. E
Membership Amount-Col. E (Part XVI-A - Line 2, Column e)
Available Years: 1999 - current

I081
Character
(6)

Interest-Business Code-Col. A
Interest-Business Code-Col. A (Part XVI-A - Line 3, Column a)
Available Years: 1990 - current

I082
Numeric
(6)

Interest-Amount-Col. B
Interest-Amount-Col. B (Part XVI-A - Line 3, Column b)
Available Years: 1990 - current

I083
Character
(2)

Interest-Exclusion Code-Col. C
Interest-Exclusion Code-Col. C (Part XVI-A - Line 3, Column c)
Available Years: 1990 - current

I084
Numeric
(2)

Interest-Amount-Col. D
Interest-Amount-Col. D (Part XVI-A - Line 3, Column d)
Available Years: 1990 - current

I085
Numeric
(2)

Interest-Related or Exempt Income-Col. E
Interest-Related or Exempt Income-Col. E (Part XVI-A - Line 3, Column e)
Available Years: 1990 - current

I091
Character
(6)

Dividends-Business Code-Col. A
Dividends-Business Code-Col. A (Part XVI-A - Line 4, Column a)
Available Years: 1990 - current

I092
Numeric
(6)

Dividends-Amount-Col. B
Dividends-Amount-Col. B (Part XVI-A - Line 4, Column b)
Available Years: 1990 - current

I093
Character
(2)

Dividends-Exclusion Code-Col. C
Dividends-Exclusion Code-Col. C (Part XVI-A - Line 4, Column c)
Available Years: 1990 - current

I094
Numeric
(2)

Dividends-Amount-Col. D
Dividends-Amount-Col. D (Part XVI-A - Line 4, Column d)
Available Years: 1990 - current

I095
Numeric
(2)

Dividends-Related or Exempt Income-Col. E
Dividends-Related or Exempt Income-Col. E (Part XVI-A - Line 4, Column e)
Available Years: 1990 - current

I101
Character
(6)

Rental Income (RE-DF)-Business Code-Col. A
Rental Income (RE-DF)-Business Code-Col. A (Part XVI-A - Line 5a, Column a)
Available Years: 1990 - current

I102
Numeric
(6)

Rental Income (RE-DF)-Amount-Col. B
Rental Income (RE-DF)-Amount-Col. B (Part XVI-A - Line 5a, Column b)
Available Years: 1990 - current

I103
Character
(2)

Rental Income (RE-DF)-Exclusion Code-Col. C
Rental Income (RE-DF)-Exclusion Code-Col. C (Part XVI-A - Line 5a, Column c)
Available Years: 1990 - current

I104
Numeric
(2)

Rental Income (RE-DF)-Amount-Col. D
Rental Income (RE-DF)-Amount-Col. D (Part XVI-A - Line 5a, Column d)
Available Years: 1990 - current

I105
Numeric
(2)

Rental Income (RE-DF)-Related or Exempt Income-Col. E
Rental Income (RE-DF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5a, Column e)
Available Years: 1990 - current

I111
Character
(6)

Rental Income (RE-NDF)-Business Code-Col. A
Rental Income (RE-NDF)-Business Code-Col. A (Part XVI-A - Line 5b, Column a)
Available Years: 1990 - current

I112
Numeric
(6)

Rental Income (RE-NDF)-Amount-Col. B
Rental Income (RE-NDF)-Amount-Col. B (Part XVI-A - Line 5b, Column b)
Available Years: 1990 - current

I113
Character
(2)

Rental Income (RE-NDF)-Exclusion Code-Col. C
Rental Income (RE-NDF)-Exclusion Code-Col. C (Part XVI-A - Line 5b, Column c)
Available Years: 1990 - current

I114
Numeric
(2)

Rental Income (RE-NDF)-Amount-Col. D
Rental Income (RE-NDF)-Amount-Col. D (Part XVI-A - Line 5b, Column d)
Available Years: 1990 - current

I115
Numeric
(2)

Rental Income (RE-NDF)-Related or Exempt Income-Col. E
Rental Income (RE-NDF)-Related or Exempt Income-Col. E (Part XVI-A - Line 5b, Column e)
Available Years: 1990 - current

I121
Character
(6)

Rental Income (PP)-Business Code-Col. A
Rental Income (PP)-Business Code-Col. A (Part XVI-A - Line 6, Column a)
Available Years: 1990 - current

I122
Numeric
(6)

Rental Income (PP)-Amount-Col. B
Rental Income (PP)-Amount-Col. B (Part XVI-A - Line 6, Column b)
Available Years: 1990 - current

I123
Character
(2)

Rental Income (PP)-Exclusion Code-Col. C
Rental Income (PP)-Exclusion Code-Col. C (Part XVI-A - Line 6, Column c)
Available Years: 1990 - current

I124
Numeric
(2)

Rental Income (PP)-Amount-Col. D
Rental Income (PP)-Amount-Col. D (Part XVI-A - Line 6, Column d)
Available Years: 1990 - current

I125
Numeric
(2)

Rental Income (PP)-Related or Exempt Income-Col. E
Rental Income (PP)-Related or Exempt Income-Col. E (Part XVI-A - Line 6, Column e)
Available Years: 1990 - current

I131
Character
(6)

Other Investments-Business Code-Col. A
Other Investments-Business Code-Col. A (Part XVI-A - Line 7, Column a)
Available Years: 1999 - current

I132
Numeric
(6)

Other Investments-Amount-Col. B
Other Investments-Amount-Col. B (Part XVI-A - Line 7, Column b)
Available Years: 1999 - current

I133
Character
(2)

Other Investments-Exclusion Code-Col. C
Other Investments-Exclusion Code-Col. C (Part XVI-A - Line 7, Column c)
Available Years: 1999 - current

I134
Numeric
(2)

Other Investments-Amount-Col. D
Other Investments-Amount-Col. D (Part XVI-A - Line 7, Column d)
Available Years: 1999 - current

I135
Numeric
(2)

Other Investments-Amount-Col. E
Other Investments-Amount-Col. E (Part XVI-A - Line 7, Column e)
Available Years: 1999 - current

I141
Character
(6)

Net Gain(Loss)-Sales of Assets-Business Code-Col. A
Net Gain(Loss)-Sales of Assets-Business Code-Col. A (Part XVI-A - Line 8, Column a)
Available Years: 1990 - current

I142
Numeric
(6)

Net Gain(Loss)-Sales of Assets-Amount-Col. B
Net Gain(Loss)-Sales of Assets-Amount-Col. B (Part XVI-A - Line 8, Column b)
Available Years: 1990 - current

I143
Character
(2)

Net Gain(Loss)-Sales of Assets-Exclusion Code-Col. C
Net Gain(Loss)-Sales of Assets-Exclusion Code-Col. C (Part XVI-A - Line 8, Column c)
Available Years: 1990 - current

I144
Numeric
(2)

Net Gain(Loss)-Sales of Assets-Amount-Col. D
Net Gain(Loss)-Sales of Assets-Amount-Col. D (Part XVI-A - Line 8, Column d)
Available Years: 1990 - current

I145
Numeric
(2)

Net Gain(Loss)-Sales of Assets-Related or Exempt Inc-Col. E
Net Gain(Loss)-Sales of Assets-Related or Exempt Income-Col. E (Part XVI-A - Line 8, Column e)
Available Years: 1990 - current

I151
Character
(6)

Special Events-Business Code-Col. A
Special Events-Business Code-Col. A (Part XVI-A - Line 9, Column a)
Available Years: 1999 - current

I152
Numeric
(6)

Special Events-Amount-Col. B
Special Events-Amount-Col. B (Part XVI-A - Line 9, Column b)
Available Years: 1999 - current

I153
Character
(2)

Special Events-Exclusion Code-Col. C
Special Events-Exclusion Code-Col. C (Part XVI-A - Line 9, Column c)
Available Years: 1999 - current

I154
Numeric
(2)

Special Events-Amount-Col. D
Special Events-Amount-Col. D (Part XVI-A - Line 9, Column d)
Available Years: 1999 - current

I155
Numeric
(2)

Special Events-Amount-Col. E
Special Events-Amount-Col. E (Part XVI-A - Line 9, Column e)
Available Years: 1999 - current

I161
Character
(6)

Gross Profit (Loss)-Sales of Inventory-Business Code-Col. A
Gross Profit (Loss)-Sales of Inventory-Business Code-Col. A (Part XVI-A - Line 10, Column a)
Available Years: 1990 - current

I162
Numeric
(6)

Gross Profit (Loss)-Sales of Inventory-Amount-Col. B
Gross Profit (Loss)-Sales of Inventory-Amount-Col. B (Part XVI-A - Line 10, Column b)
Available Years: 1990 - current

I163
Character
(2)

Gross Profit (Loss)-Sales of Inventory-Exclusion Code-Col. C
Gross Profit (Loss)-Sales of Inventory-Exclusion Code-Col. C (Part XVI-A - Line 10, Column c)
Available Years: 1990 - current

I164
Numeric
(2)

Gross Profit (Loss)-Sales of Inventory-Amount-Col. D
Gross Profit (Loss)-Sales of Inventory-Amount-Col. D (Part XVI-A - Line 10, Column d)
Available Years: 1990 - current

I165
Numeric
(2)

Gross Profit(Loss)-Sales of Invntry-Rel or Exempt Inc-Col. E
Gross Profit (Loss)-Sales of Inventory-Related or Exempt Income-Col. E (Part XVI-A - Line 10, Column e)
Available Years: 1990 - current

I171
Character
(6)

Sum--Other Revenue-Business Code-Col. A
Sum--Other Revenue-Business Code-Col. A (Part XVI-A - Line 11e, Column a)
Available Years: 1990 - current

I172
Numeric
(6)

Sum--Other Revenue-Amount-Col. B
Sum--Other Revenue-Amount-Col. B (Part XVI-A - Line 11e, Column b)
Available Years: 1990 - current

I182
Numeric
(6)

Subtotal-Amount-Col. B
Subtotal-Amount-Col. B (Part XVI-A - Line 12, Column b)
Available Years: 1990 - current

I173
Character
(2)

Sum--Other Revenue-Exclusion Code-Col. C
Sum--Other Revenue-Exclusion Code-Col. C (Part XVI-A - Line 11e, Column c)
Available Years: 1990 - current

I174
Numeric
(2)

Sum--Other Revenue-Amount-Col. D
Sum--Other Revenue-Amount-Col. D (Part XVI-A - Line 11e, Column d)
Available Years: 1990 - current

I184
Numeric
(2)

Subtotal-Amount-Col. D
Subtotal-Amount-Col. D (Part XVI-A - Line 12, Column d)
Available Years: 1990 - current

I175
Numeric
(2)

Sum-lines Other Revenue-Related or Exempt Income-Col. E
Sum-lines Other Revenue-Related or Exempt Income-Col. E (Part XVI-A - Line 11e, Column e)
Available Years: 1990 - current

I185
Numeric
(2)

Subtotal-Related or Exempt Income-Col. E
Subtotal-Related or Exempt Income-Col. E (Part XVI-A - Line 12, Column e)
Available Years: 1990 - current

IRS Internal Processing

WEIGHT
Numeric
(2)

Weight (values range between: 1.00 and 999.99)
Weight (Population estimate multiplier, values range between: 1.00 and 999.99) (Assigned by IRS)
Available Years: All

COMP_CNT
Character
(2)

Count of related records in Compensation Data File
Count of related records in Compensation Data File (Part VIII)
Available Years: 1993 - current

SCPL
Character
(12)

SCPL (Match records to sub-tables using TaxYr and SCPL)
Service Center/Cycle/Page/Line Count (Records are matched to sub-tables using TaxYr and SCPL) (Assigned by IRS)
Available Years: All

COND
Character
(12)

Condition Code
Condition Code (Assigned by IRS)
Available Years: All

I	Imputed values
L	Short-year return
S	Substitute return

Classification

NTEE1
Character
(12)

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

NTEEconf
Character
(1)

NTEE confidence rating
NTEE classification confidence rating (A/B/C)

MAJGRPB
Character
(1)

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

Other Classification

NAICS
Character
(9)

North American Industrial Clas
North American Industrial Classification System

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

Miscellaneous

randnum
Numeric
(9)

Random number between 0 and 1
Random number between 0 and 1 used for creating samples