SOI 2002 990 c3

Number of variables	412
Number of records	16923

Field Name
Field Type Description and Values

Basic Info

EIN
Character
(9) Employer identification number
Employer identification number.

NAME
Character
(70) Name.
Name.

STATE
Character
(2) State
Two-letter state abbreviation.

NTEE1
Character
(2) 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

Other Classification

NAICS
Character
(9) NAICS
NAICS Code

Basic Info

E010
Character
(4) Accounting Period (yymm)
Accounting Period (year and month)

E050
Character
(2) Exemption/subsection number
Organization type - IRS subsection number

zip5
Character
(5) Zip code, 5 digits
First 5 digits of zip code

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

ntmaj5
Character
(20) Major subsector
Major subsector (5)
AR Arts, culture, and humanities
ED Education
HE Health
HU Human services
OT Other

ntmaj10
Character
(20) 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
(20) 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
(20) 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

NTEESOI
Character
(4) NTEE assigned by SOI
NTEE assigned by IRS SOI Division.

Part I: Revenue, Expenses, and Changes in Net Assets or Fund Balances

R010
Numeric
(4) Direct public support, 1a
Direct public support, 1a

R020
Numeric
(4) Indirect public support, 1b
Indirect public support, 1b

R030
Numeric
(4) Government grants, 1c
Government grants, 1c

R040
Numeric
(4) Total contributions, 1d
Total contributions, 1d

R050
Numeric
(4) Program service revenue
Program service revenue, line 2

R060
Numeric
(4) Dues
Membership dues and assessments,line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)

R070
Numeric
(4) Interest, line 4
Interest on savings & temp. cash investments, line 4

R080
Numeric
(4) Dividends
Dividends & interest from securities, line 5

R090
Numeric
(4) Gross rents
Gross rents, line 6a

R100
Numeric
(4) Rental expenses
Rental expenses, line 6b

R110
Numeric
(4) Net rental expenses
Net rental expenses, line 6c

R120
Numeric
(4) Other investment income
Other investment income, line 7

R130
Numeric
(4) Sale of securities, gross
Gross amount from sale of assets, securities, line 8a(A)

R140
Numeric
(4) Basis, sale of securities
Cost or other basis, securities, line 8b(A)

R150
Numeric
(4) Gain (or loss): securities
Gain (or loss) from sale of securities, line 8c(A)

R160
Numeric
(4) Sale of other assets, gross
Gross amount from sale of assets other than securities, line 8a(B)

R170
Numeric
(4) Basis, sale of other assets
Cost or other basis, other assets, line 8b(B)

R180
Numeric
(4) Gain or loss: other asset sale
Gain (or loss), sale of other assets, line 8c(B)

R190
Numeric
(4) Net, sale of non-inv. Assets
Total gain (or loss), sale of assets other than inventory, line 8d

R200
Numeric
(4) Gross, special events
Gross revenue from special events, line 9a

R210
Numeric
(4) Direct expense, special events
Direct expenses for special events, line 9b

R220
Numeric
(4) Special event net
Net from special events, line 9c

R230
Numeric
(4) Sale of inventory, gross
Gross sales of inventory, line 10a

R240
Numeric
(4) Cost of goods sold
Cost of goods sold, line 10b

R250
Numeric
(4) Gross profit, inventory sales
Gross profit from sales of inventory, line 10c

R260
Numeric
(4) Other revenue
Other revenue, line 11

R270
Numeric
(4) Total revenue
Total revenue, line 12

X010
Numeric
(4) Program service expenses
Program services expenses, line 13

X020
Numeric
(4) Management and general expense
Management and general expenses, line 14

X030
Numeric
(4) Fundraising expenses
Fundraising expenses, line 15

X040
Numeric
(4) Payments to affiliates
Payments to affiliates, line 16

X050
Numeric
(4) Total expenses
Total expenses, line 17

N010
Numeric
(4) Net income
Net income: excess or deficit, line 18

N020
Numeric
(4) Net assets, BOY
Net assets or fund balance, beginning of year, line 19

N030
Numeric
(4) Other change, net assets
Other changes in net assets or fund balances

N040
Numeric
(4) Net assets, EOY
Net assets or fund balance, end-of-year, line 21

Part I (EZ Form): Revenue, Expenses, and Changes in Net Assets or Fund Balances

RZ100
Numeric
(4) Investment income (EZ)
Investment income (EZ)

RZ200
Numeric
(4) Gross sale of assets (EZ)
Gross Amt From Sale of Assets (EZ)

RZ300
Numeric
(4) Cost or other basis (EZ)
Cost or Other Basis (EZ)

Part II: Expenses

F010
Numeric
(4) Grants and allocations
Grants and allocations, line 22 B or A

F015
Numeric
(4) Specif assistance, individuals
Specific assistance to individuals - line 23B or A

F020
Numeric
(4) Benefits paid to/for members
Benefits paid to or for members - line 24B or A

F825
Numeric
(4) Comp of officers-total
Compensation of officers - Total, line 25, column A

F025
Numeric
(4) Comp of officers-prog serv
Compensation of officers - Program services - Column B

F225
Numeric
(4) Comp of officers-mgt.& gen.
Compensation of officers - Column C - Management & general,

F425
Numeric
(4) Other expenses-col d, i23d
Compensation of officers - Column D - Fundraising,

F830
Numeric
(4) Oth salaries & wages-total
Other salaries and wages - Column A - Total

F030
Numeric
(4) Oth salaries & wages-prog serv
Other salaries and wages - Program services - Column B

F230
Numeric
(4) Other salaries, mgt.& gen.
Other salaries and wages - Column C - Management & general,

F430
Numeric
(4) Other salaries, fundraising
Other salaries and wages - Column D - Fundraising,

F835
Numeric
(4) Pension contribs, total
Pension plan contributions - Column A - Total

F035
Numeric
(4) Pension contribs, program
Pension plan contributions - Program services - Column B

F235
Numeric
(4) Pension contribs, mgt. & gen.
Pension plan contributions - Column C - Management & general,

F435
Numeric
(4) Pension contribs, fundraising
Pension plan contributions - Column D - Fundraising,

F840
Numeric
(4) Oth employee benefits, total
Other employee benefits - Column A - Total

F040
Numeric
(4) Oth employee benefits-prog ser
Other employee benefits - Program services - Column B

F240
Numeric
(4) Oth employee benefits-mgmt & g
Other employee benefits - Column C - Management & general,

F440
Numeric
(4) Oth employee benefits-fundrais
Other employee benefits - Column D - Fundraising,

F845
Numeric
(4) Payroll taxes-total
Payroll taxes - Column A - Total

F045
Numeric
(4) Payroll taxes-program services
Payroll taxes - Column B - Program services

F245
Numeric
(4) Payroll taxes-mgmt & general
Payroll taxes - Column C - Management & general,

F445
Numeric
(4) Payroll taxes-fundraising ln 2
Payroll taxes - Column D - Fundraising,

F850
Numeric
(4) Professional fundraising fees
Professional fundraising fees - Column A - Total

F855
Numeric
(4) Accounting fees-total
Accounting fees - Column A - Total

F055
Numeric
(4) Accounting fees-prog services
Accounting fees - Column B - Program services -

F255
Numeric
(4) Accounting fees-mgmt & general
Accounting fees - Column C - Management & general,

F455
Numeric
(4) Accounting fees-fundraising
Accounting fees - Column D - Fundraising,

F860
Numeric
(4) Legal fees total line
Legal fees - Column A - Total

F060
Numeric
(4) Legal fees-program services
Legal fees - Column B - Program services -

F260
Numeric
(4) Legal fees-mgmt and general
Legal fees - Column C - Management & general,

F460
Numeric
(4) Legal fees-fundraising
Legal fees - Column D - Fundraising,

F865
Numeric
(4) Supplies-total
Supplies - Column A - Total

F065
Numeric
(4) Supplies-program services
Supplies - Column B - Program services

F265
Numeric
(4) Supplies-mgmt and general
Supplies - Column C - Management & general,

F465
Numeric
(4) Supplies-fundraising
Supplies - Column D - Fundraising,

F870
Numeric
(4) Telephone-total
Telephone - Column A - Total

F070
Numeric
(4) Telephone-program services
Telephone - Column B - Program services -

F270
Numeric
(4) Telephone-mgmt and general
Telephone - Column C - Management & general,

F470
Numeric
(4) Telephone-fundraising
Telephone - Column D - Fundraising,

F875
Numeric
(4) Postage & shipping-total
Postage and shipping - Column A - Total

F075
Numeric
(4) Postage & shipping-prog servic
Postage and shipping - Column B - Program services -

F275
Numeric
(4) Postage & shipping-mgmt & gen
Postage and shipping - Column C - Management & general,

F475
Numeric
(4) Postage & shipping-fundraising
Postage and shipping - Column D

F880
Numeric
(4) Occupancy-total
Occupancy - Column A, total, line 36

F080
Numeric
(4) Occupancy-program services
Occupancy - Column B, program services, line 36

F280
Numeric
(4) Occupancy, mgt. & general
Occupancy - Column C, management & general, line 36

F480
Numeric
(4) Occupancy-fundraising
Occupancy - Column D, fundraising, line 36

F885
Numeric
(4) Equipment rental & exp-total
Equipment rental and expenses - Column A, total, line 37

F085
Numeric
(4) Equipment rental & exp-prog
Equipment rental and expenses - Column B, program services, line 37

F285
Numeric
(4) Equipment rental & exp-mgmt
Equipment rental and expenses - Column C, management & general, line 37

F485
Numeric
(4) Equipment rental & exp-fundr
Equipment rental and expenses - Column D, fundraising, line 37

F890
Numeric
(4) Printing & pub-total
Printing and publications - Column A, total, line 38

F090
Numeric
(4) Printing & pub-prog serv
Printing and publications - Column B, program services, line 38

F290
Numeric
(4) Printing & pub-mgmt & gen
Printing and publications - Column C, management & general, line 38

F490
Numeric
(4) Printing & pub-fundraising
Printing and publications - Column D, fundraising, line 38

F895
Numeric
(4) Travel - total
Travel - Column A, total, line 39

F095
Numeric
(4) Travel - program services
Travel - Column B, program services, line 39

F295
Numeric
(4) Travel - mgmt and general
Travel - Column C, management & general, line 39

F495
Numeric
(4) Travel - fundraising
Travel - Column D, fundraising, line 39

F900
Numeric
(4) Conf,convntns&meetings-total
Conferences, conventions, and meetings - Column A, line 40

F100
Numeric
(4) Conf,convntns&meetings-prog sv
Conferences, conventions, and meetings - Column B, line 40

F300
Numeric
(4) Conf,convntns&meetings-mg &g
Conferences, conventions, and meetings - Column C, management & general, line 40

F500
Numeric
(4) Conf,convntns&meetings-fundrsn
Conferences, conventions, and meetings - Column D, fundraising, line 40

F905
Numeric
(4) Interest - total
Interest - Column A, total, line 41

F105
Numeric
(4) Interest - progam
Interest - Column B, program services, line 41

F305
Numeric
(4) Interest - mgmt and general
Interest - Column C, management & general, line 41

F505
Numeric
(4) Interest - fundraising
Interest - Column D, fundraising, line 41

F910
Numeric
(4) Depreciation, depletion - tota
Depreciation, depletion - Column A, total, line 42

F110
Numeric
(4) Depreciation,depletion-prog se
Depreciation, depletion - Column B, program services, line 42

F310
Numeric
(4) Depreciation,depletion-mgmt &g
Depreciation, depletion - Column C, management & general, line 42

Other Classification

LEVEL1
Character
(4) Public charity or priv. fndn?
Public charity or private foundation?
O Other Nonprofits
PC Public Charity
PF Private Foundation
U Unknown

LEVEL2
Character
(4) Reporting public charity group
Reporting public charity groups.
M Mutual Benefit Public Charity
O Operating Public Charity
S Supporting Public Charity

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

Part II: Expenses

F510
Numeric
(4) Depreciation, depletion-fundrs
Depreciation, depletion - Column D, fundraising, line 42

F920
Numeric
(4) Oth expenses, total
Other expenses - Column A, total, line 43a-e

F120
Numeric
(4) Oth expenses, program
Other expenses - Column B, program services, line 43a-e

F320
Numeric
(4) Oth expenses, mgt & gen
Other expenses - Column C, management & general, line 43a-e

F520
Numeric
(4) Oth expenses -fundraising
Other expenses - Column D, fundraising, line 43a-e

F930
Numeric
(4) Total functional exp-total
Total functional expenses - Column A, total, line 44

F130
Numeric
(4) Total functional exp-prog serv
Total functional expenses - Column B, program services, line 44

F330
Numeric
(4) Total functional exp-mgmt & ge
Total functional expenses - Column C, management & general, line 44

F530
Numeric
(4) Total functional exp-fundrsng
Total functional expenses - Column D, fundraising, line 44

F050
Numeric
(4) Prof. Fundraising fees, prog.
Professional fundraising fees - Column B, program, line 30

F250
Numeric
(4) Prof. Fundraising fees, mgt.
Professional fundraising fees - Column C, management & general, line 30

F450
Numeric
(4) Prof. Fundraising fees, fundr.
Professional fundraising fees - Column D, fundraising, line 30

Part I (EZ Form): Revenue, Expenses, and Changes in Net Assets or Fund Balances

XZ100
Numeric
(4) Grants paid (EZ)
Grants and Similar Amounts Paid (EZ)

XZ200
Numeric
(4) Salaries and benefits (EZ)
Salaries, Compensation and Employee Benefits (EZ)

XZ300
Numeric
(4) Professional fees (EZ)
Professional fees and other payments (EZ)

XZ400
Numeric
(4) Occupancy, utilities, maint (E
Occupancy, Rent, Utilitites, Maintenance (EZ)

XZ500
Numeric
(4) Printing, pub, post (EZ)
Printing, Publications, Postage, Shipping (EZ)

XZ600
Numeric
(4) Total other exp (EZ)
Total Other Expenses (EZ)

Part IV: Balance Sheet

A040
Numeric
(4) Cash, non interest bearing-EOY
Cash, non-interest-bearing - Column B, end-of-year, line 45

A050
Numeric
(4) Savings, EOY
Savings & temporary cash investments - Column B, end-of-year, line 46

A060
Numeric
(4) Accounts receivable-EOY
Accounts receivable - Column B, end-of-year, line 47c

A070
Numeric
(4) Pledges receivable, EOY
Pledges receivable - Column B, end-of-year, line 48c

A080
Numeric
(4) Grants receivable, EOY
Grants receivable - Column B, end-of-year, line 49

A090
Numeric
(4) Receivables -officrs/dirs, EOY
Receivables due from officers, directors, Column B, end-of-year, line 50

A001
Numeric
(4) Cash-Col A
Cash-Col A

A002
Numeric
(4) Savings-Col A
Savings-Col A

A003
Numeric
(4) Accounts Receivable-Col A
Accounts Receivable-Col A

A100
Numeric
(4) Capital gain net income, i7b
Other notes & loans receivable - Column B, end-of-year, line 51c

A004
Numeric
(4) Pledges Receivable-Col A
Pledges Receivable-Col A

A005
Numeric
(4) Grants Receivable-Col A
Grants Receivable-Col A

A006
Numeric
(4) Receivables Due From Officers, Directors & Truste
Receivables Due From Officers, Directors & Trustees-Col A

A007
Numeric
(4) Other Notes & Loans Receivable-Col A
Other Notes & Loans Receivable-Col A

A010
Numeric
(4) Inventories, BOY
Inventories for sale or use - Column A, beginning-of-year, line 52

A011
Numeric
(4) Prepaid Expenses-Col A
Prepaid Expenses-Col A

A021
Numeric
(4) Investments-Land, Buildings & Equipment-Col A
Investments-Land, Buildings & Equipment-Col A

A022
Numeric
(4) Investments-Other-Col A
Investments-Other-Col A

A023
Numeric
(4) Land, Building & Equip.-Col A
Land, Building & Equip.-Col A

A110
Numeric
(4) Inventories, EOY
Inventories for sale or use - Column B, end-of-year, line 52

A024
Numeric
(4) Other Assets-Col A
Other Assets-Col A

A120
Numeric
(4) Prepaid expenses, EOY
Prepaid expenses & deferred charges, end-of-year, line 53

A020
Numeric
(4) Investments-securities, BOY
Investments (securities) - Column A, beginning-of-year, line 54

A130
Numeric
(4) Investments-securities, EOY
Investments (securities) - Column B, end-of-year, line 54

A140
Numeric
(4) Investments, land, bldngs, EOY
Investments (land, buildings, equipment), end-of-year, line 55c

A150
Numeric
(4) Investments-other, EOY
Investments (other) - Column B, end-of-year, line 56

A160
Numeric
(4) Land, buildings, &equip-EOY
Land, buildings, & equipment - Column B, end-of-year, line 57c

A170
Numeric
(4) Other assets, EOY
Other assets - Column B, end-of-year, line 58

A030
Numeric
(4) Total assets, BOY
Total assets - Column A, beginning-of-year, line 59

A180
Numeric
(4) Total assets, EOY
Total assets - Column B, end-of-year, line 59

L001
Numeric
(4) Accounts Payable-Col A
Accounts Payable-Col A

L020
Numeric
(4) Accounts payable, EOY
Accounts payable & accrued expenses, end-of-year, line 60

L002
Numeric
(4) Grants Payable-Col A
Grants Payable-Col A

L030
Numeric
(4) Grants payable, EOY
Grants payable - Column B, end-of-year, line 61

L003
Numeric
(4) Deferred Revenue -Col A
Deferred Revenue -Col A

L040
Numeric
(4) Deferred revenue, EOY
Deferred revenue (support & revenue designated for future use) - Column B, end-of-year, line 62

L004
Numeric
(4) Loans From Officers, Directors & Trustees-Col A
Loans From Officers, Directors & Trustees-Col A

L050
Numeric
(4) Loans fr. Officers, dirs., EOY
Loans from officers, directors, �- Column B, end-of-year, line 63

L005
Numeric
(4) Tax-exempt bond liabilities-Col A
Tax-exempt bond liabilities-Col A

L070
Numeric
(4) Mortgages & notes payable, EOY
Mortgages and other notes payable - Column B, end-of-year, line 64b

L006
Numeric
(4) Mortgages & Other Notes Payable-Col A
Mortgages & Other Notes Payable-Col A

L080
Numeric
(4) Other liabilities, EOY
Other liabilities - Column B, end-of-year, line 65

L007
Numeric
(4) Other Liabilities-Col A
Other Liabilities-Col A

L010
Numeric
(4) Total liabilities, BOY
Total liabilities - Column A, beginning-of-year, line 66

L090
Numeric
(4) Total liabilities, EOY
Total liabilities - Column B, end-of-year, line 66

B010
Numeric
(4) Total net assets-BOY
Total fund balances or net assets - Column A, beginning of year, line 73

B020
Numeric
(4) Total net assets-EOY
Total fund balances or net assets - Column B, end-of-year, line 73

B015
Numeric
(4) Total Fund Balances-Col A
Total Fund Balances-Col A

B030
Numeric
(4) Total liab & net assets
Total liabilities & fund balances/net assets - Column B, end-of-year, line 74

Part IV: Balance Sheets

L060
Numeric
(4) Tax-exempt bond liabilities
Tax-exempt bond liabilities

Part IV-A: Reconciliation of Revenue per Audited Financial Statements ...

W010
Numeric
(4) Tot. Rev., gains per audited f
Part IV-A-a, Total revenue, gains, other supp

W020
Numeric
(4) Net unrealized gains on invest
Part IV-A-b-1, Net unrealized gains or investments

W030
Numeric
(4) Rev fr donated svc & uses of f
Part IV-A-b-2, Donates services, use facilities

W040
Numeric
(4) Recoveries of prior year grant
Part IV-A-b-3, Recoveries of prior year grants

W050
Numeric
(4) Other revenue
Part IV-A-b-4, Other amounts not on line 12

W060
Numeric
(4) Sum of revenue
Part IV-A-b, Total revenue not on line 12

W070
Numeric
(4) Difference in revenue
Part IV-A-c, Line a minus line b

W080
Numeric
(4) Investment exp not incl. On F9
Part IV-A-d-1, Investment expenses

W090
Numeric
(4) Oth. Exp on F990 line 12 n. In
Part IV-A-d-2, Other amounts included on line 12

W100
Numeric
(4) Tot. Rev. Exp. Not incl in (a)
Part IV-A-d, Revenue on line 12 but not line

W110
Numeric
(4) Recncld revenue stated on F990
Part IV-A-e, Total revenue per line 12

Part IV-B: Reconciliation of Expenses per Audited Financial Statements ...

W210
Numeric
(4) Tot. Exp. & losses per audited
Part IV-B-a, Total expenses per statements

W220
Numeric
(4) Exp. From donated svcs & use
Part IV-B-b-1, Donates services

W230
Numeric
(4) Prior yr adjstmts reprtd on F9
Part IV-B-b-2, Prior-year adjustments

W240
Numeric
(4) Losses reported on F990 line 2
Part IV-B-b-3, Losses reported on line 20

W250
Numeric
(4) Other exp on F990 li17 but not
Part IV-B-b-4, Other amts not included on line

W260
Numeric
(4) Tot. Exp. Not incl in (a)
Part IV-B-b, Total expenses not on line 17

W270
Numeric
(4) Difference in exp.
Part IV-B-c, Line a minus line b

W280
Numeric
(4) Investmt exp not incl on F990
Part IV-B-d-1, Investment expenses

W290
Numeric
(4) Other exp no incl on F990
Part IV-B-d-2, Other amounts included on line 17

W300
Numeric
(4) Tot. Exp. Not incl on F990
Part IV-B-d, Expenses on line 17 but not line

W310
Numeric
(4) Reconcld exp. As stated on F99
Part IV-B-e, Total expenses per line 17

Part V: Officers, Directors, Trustees, Key Employees

C100
Numeric
(4) Number of uncompensated office
Number of uncompensated officers, etc.

Part VI: Other Information

Q070
Character
(4) Deductible dues?
Deductible dues question
N No
Y Yes

Q080
Character
(4) Lobby expenditures?
Lobby expenditures question
N No
Y Yes

Q090
Numeric
(4) Dues (line 85c)
Dues (Line 85c)

Q100
Numeric
(4) Section 162(e) lobbying exp.
Section 162(e) lobbying expenditures (Line 85d)

Q110
Numeric
(4) Nondeductible dues
Nondeductible dues (Line 85e)

Q120
Numeric
(4) Taxable lobbying exp.
Taxable lobbying expenditures (Line 85f)

Q130
Character
(4) Section 6033(e) tax?
Section 6033(e) tax question
N No
Y Yes

Q140
Character
(4) Nondeductible lobbying exp.?
Nondeductible lobbying exepense question
N No
Y Yes

Q150
Numeric
(4) Initiation fees
Initiation fees

Q160
Numeric
(4) Gross rec from facilities
Gross receipts from public use of facilities

Q020
Character
(1) Part VI question 78(b)
Part VI Question 78(b)

Q030
Character
(1) Part VI question79
Part VI Question 79

Q040
Character
(1) Part VI question 80
Part VI Question 80

Q050
Numeric
(1) Political expenditures
Political expenditures, line 81a

Q060
Character
(1) Was form 1120-pol filed?
Was Form 1120-POL filed? line 81b
N No
Y Yes

Q170
Numeric
(1) Tax paid under section 4911
Tax paid under section 4911, line 89a

Q180
Numeric
(1) Tax paid under section 4912
Tax paid under section 4912, line 89a

Q190
Numeric
(1) Tax paid under section 4955
Tax paid under section 4955, line 89a

Q200
Character
(1) Section 4958 excess benefit?
Section 4958 excess benefit? Line 89b
N No
Y Yes

Q210
Numeric
(1) Tax paid under 4912...
Tax paid under section 4912, 4955, & 4958; line 89c

Q220
Numeric
(1) Amt of tax reimbursed by...
Amount of 4912, 4955, or 4958 tax reimbursed by organization

Q230
Numeric
(1) Num. Of employees
Number of employees in pay period that included March 12, line 90b

Part VII: Income Detail

I001
Numeric
(1) Prog serv rev(a)-business code
Program service revenue (a) - Column A, line 93a

I002
Numeric
(1) Prog serv rev(a)-amount, ln 93
Program service revenue (a) - Column B, line 93a

I003
Numeric
(1) Prog serve rev(a)-exclusion cd
Program service revenue (a) - Column C, line 93a

I004
Numeric
(1) Prog serv rev(a)-amount ln 93a
Program service revenue (a) - Column D, line 93a

I005
Numeric
(1) Prog serv rev(a)-related/exmpt
Program service revenue (a) - Column E, line 93a

I011
Numeric
(1) Prog serv rev(b)-business ln 9
Program service revenue (b) - Column A, line 93b

I012
Numeric
(1) Prog serv rev(b)-amount ln 93b
Program service revenue (b) - Column B, line 93b

I013
Numeric
(1) Prog serv rev(b)-exclusion ln
Program service revenue (b) - Column C, line 93b

I014
Numeric
(1) Prog serv rev(b)-amount, ln 93
Program service revenue (b) - Column D, line 93b

I015
Numeric
(1) Prog serv rev(b)-related/exmpt
Program service revenue (b) - Column E, line 93b

I021
Numeric
(1) Prog serv rev(c)-business code
Program service revenue (c) - Column A, line 93c

I022
Numeric
(1) Prog serv rev(c)-amount ln 93c
Program service revenue (c) - Column B, line 93c

I023
Numeric
(1) Prog serv rev(c)-exclusion ln
Program service revenue (c) - Column C, line 93c

I024
Numeric
(1) Prog serv rev(c)-amount ln 93c
Program service revenue (c) - Column D, line 93c

I025
Numeric
(1) Prog serv rev(c)-related ln 93
Program service revenue (c) - Column E, line 93c

I031
Numeric
(1) Prog serv rev(d)-business code
Program service revenue (d) - Column A, line 93d

I032
Numeric
(1) Prog serv rev(d)-amount ln 93d
Program service revenue (d) - Column B, line 93d

I033
Numeric
(1) Prog serv rev(d)-exclusion ln
Program service revenue (d) - Column C, line 93d

I034
Numeric
(1) Prog serv rev(d)-amount ln 93d
Program service revenue (d) - Column D, line 93d

I035
Numeric
(1) Prog serv rev(d)-related/exmpt
Program service revenue (d) - Column E, line 93d

I041
Numeric
(1) Prog serv rev(e)-business code
Program service revenue (e) - Column A, line 93e

I042
Numeric
(1) Prog serv rev(e)-amount ln 93e
Program service revenue (e) - Column B, line 93e

I043
Numeric
(1) Prog serv rev(e)-exclusion ln
Program service revenue (e) - Column C, line 93e

I044
Numeric
(1) Prog serv rev(e)-amount ln 93e
Program service revenue (e) - Column D, line 93e

I045
Numeric
(1) Prog serv rev(e)-related/exmpt
Program service revenue (e) - Column E, line 93e

I051
Numeric
(1) Mcr/prog serv rev(f)-bus. Code
Medicare/Medicaid (1997- forms) or program service revenue (f) - Column A (pre-1997), line 93f

I052
Numeric
(1) Mcr/prog serv rev(f)-amt, 93f
Medicare/Medicaid (1997- forms), Program service revenue (f) - Column B (pre-1997), line 93f

I053
Numeric
(1) Mcr/ prog serv rev(f)-excl. Cd
Medicare/Medicaid (1997- forms) Program service revenue (f) - Column C (pre-1997), line 93f

I054
Numeric
(1) Mcr/prog serv rev(f)-amt 93f
Medicare/Medicaid (1997- forms) Program service revenue (f) - Column D (pre-1997), line 93f

I055
Numeric
(1) Mcr/prog serv rev(f)-rel./expt
Medicare/Medicaid (1997- forms); Program service revenue (f) - Column E (pre-1997), line 93f

I061
Numeric
(1) Fees from govt. Agencies(g)
Fees from govt. agencies (g) - Column A, line 93g

I062
Numeric
(1) Fees from govt. Agencies (g)
Fees from govt. agencies (g) - Column B, line 93g

I063
Numeric
(1) Fees from govt. Agencies (g)
Fees from govt. agencies (g) - Column C, line 93g

I064
Numeric
(1) Fees from govt. Agencies (g)
Fees from govt. agencies (g) - Column D, line 93g

I065
Numeric
(1) Fees from govt. Agencies (g)
Fees from govt. agencies (g) - Column E, line 93g

I071
Numeric
(1) Mem dues&assessmnts-business
Membership dues & assessments - Column A, line 94

I072
Numeric
(1) Mem dues&assessmnts-amount
Membership dues & assessments - Column B, line 94

I073
Numeric
(1) Mem dues&assessmnts-exclusion
Membership dues & assessments - Column C, line 94

I074
Numeric
(1) Mem dues&assessmnts-amount
Membership dues & assessments - Column D, line 94

I075
Numeric
(1) Mem dues&assessments-reltd-exm
Membership dues & assessments - Column E, line 94

I081
Numeric
(1) Int on sav&temp cash inv-bus c
Interest on savings & temp cash investments - Column A, line 95

I082
Numeric
(1) Int on sav&temp cash inv-amoun
Interest on savings & temp cash investments - Column B, line 95

I083
Numeric
(1) Int on sav&temp cash inv-ex cd
Interest on savings & temp cash investments - Column C, line 95

I084
Numeric
(1) Int on sav&temp cash inv-amoun
Interest on savings & temp cash investments - Column D, line 95

I085
Numeric
(1) Int on sav&temp cash inv-rltd-
Interest on savings & temp cash investments - Column E, line 95

I091
Numeric
(1) Div & int from securities-bus
Dividends & interest from securities - Column A, line 96

I092
Numeric
(1) Div & int from securities-amou
Dividends & interest from securities - Column B, line 96

I093
Numeric
(1) Div & int from securities-ex c
Dividends & interest from securities - Column C, line 96

I094
Numeric
(1) Div & int from securities-amou
Dividends & interest from securities - Column D, line 96

I095
Numeric
(1) Div &int from securities-rltd-
Dividends & interest from securities - Column E, line 96

I101
Numeric
(1) Nrent inc-rl est,debt-fin-bs c
Net rental income from real estate: debt - Column A, line 97a

I102
Numeric
(1) Nrent inc-rl est,debt-fin-amnt
Net rental income from real estate: debt - Column B, line 97a

I103
Numeric
(1) Nrent inc-rl est,debt-fin-ex c
Net rental income from real estate: debt - Column C, line 97a

I104
Numeric
(1) Nrent inc-rl est,debt-fin-amnt
Net rental income from real estate: debt - Column D, line 97a

I105
Numeric
(1) Nrent inc-rl est,debt-fin-re/e
Net rental income from real estate: debt - Column E, line 97a

I111
Numeric
(1) Nrent inc-rl est,nt dt-fin-b c
Net rental income from real estate: not debt - Column A, line 97b

I112
Numeric
(1) Nrent inc-rl est,nt dt-fin-amn
Net rental income from real estate: not debt - Column B, line 97b

I113
Numeric
(1) Nrent inc-rl est,nt dt-fin-ex
Net rental income from real estate: not debt - Column C, line 97b

I114
Numeric
(1) Nrent inc-rl est,nt dt-fin-amn
Net rental income from real estate: not debt - Column D, line 97b

I115
Numeric
(1) Nrent inc-rl est,nt dt-fin-re
Net rental income from real estate: not debt - Column E, line 97b

I121
Numeric
(1) Net rent inc persnl prop-bus c
Net rental income personal prop: debt fi - Column A, line 98

I122
Numeric
(1) Net rent inc persnl prop-amoun
Net rental income personal prop: debt fi - Column B, line 98

I123
Numeric
(1) Net rent inc persnl prop-ex co
Net rental income personal prop: debt fi - Column C, line 98

I124
Numeric
(1) Net rent inc persnl prop-amoun
Net rental income personal prop: debt fi - Column D, line 98

I125
Numeric
(1) Net rent inc persnl prop-rele
Net rental income personal prop: debt fi - Column E, line 98

I131
Numeric
(1) Other investment income-bus cd
Other investment income - Column A, line 99

I132
Numeric
(1) Other investment income-amount
Other investment income - Column B, line 99

I133
Numeric
(1) Other investment income-excl c
Other investment income - Column C, line 99

I134
Numeric
(1) Other investment income-amount
Other investment income - Column D, line 99

I135
Numeric
(1) Other investment income-rel/ex
Other investment income - Column E, line 99

I141
Numeric
(1) Gain (loss) from soa-bus code
Gain (loss) from sale of assets other than inventory - Column A, line 100

I142
Numeric
(1) Gain (loss) from soa-amount
Gain (loss) from sale of assets other than inventory - Column B, line 100

I143
Numeric
(1) Gain (loss) from soa-exclsn cd
Gain (loss) from sale of assets other than inventory - Column C, line 100

I144
Numeric
(1) Gain (loss) from soa-amount
Gain (loss) from sale of assets other than inventory - Column D, line 100

I145
Numeric
(1) Gain (loss) from soa-reltd/exm
Gain (loss) from sale of assets other than inventory - Column E, line 100

I151
Numeric
(1) Net from spec.evt,bus cd
Net income from special events - Column A, line 101

I152
Numeric
(1) Net from spec.evt, amount
Net income from special events - Column B, line 101

I153
Numeric
(1) Net from spec.evt, exclsn c
Net income from special events - Column C, line 101

I154
Numeric
(1) Net from spec.evt, amount
Net income from special events - Column D, line 101

I155
Numeric
(1) Net from spec.evt, reltdex
Net income from special events - Column E, line 101

I161
Numeric
(1) Profit(loss)invent sales-bus c
Gross profit (loss) from inventory sales - Column A, line 102

I162
Numeric
(1) Profit(loss)invent sales-amnt
Gross profit (loss) from inventory sales - Column B, line 102

I163
Numeric
(1) Profit(loss)invent sales-exl c
Gross profit (loss) from inventory sales - Column C, line 102

I164
Numeric
(1) Profit(loss)invent sales-amnt
Gross profit (loss) from inventory sales - Column D, line 102

I165
Numeric
(1) Profit(loss)invent sales-rl/ex
Gross profit (loss) from inventory sales - Column E, line 102

I171
Numeric
(1) Total other revenue-bus code
Total other revenue - Column A, line 103

I172
Numeric
(1) Total other revenue-amnt ln 10
Total other revenue - Column B, line 103

I173
Numeric
(1) Total other revenue-exlsn cd
Total other revenue - Column C, line 103

I174
Numeric
(1) Total other revenue-amnt ln 10
Total other revenue - Column D, line 103

I175
Numeric
(1) Total other revenue-rel/exmt
Total other revenue - Column E, line 103

I182
Numeric
(1) Subtotal-amount ln 104/b
Subtotal - Column B, line 104

I184
Numeric
(1) Subtotal-amount ln 104/d
Subtotal - Column D, line 104

I185
Numeric
(1) Subtotal-reltd/exmpt functn
Subtotal - Column E, line 104

Part IX: Taxable Subsidiaries

T000
Numeric
(1) Number of taxable subsidiaries
Number of taxable subsidiaries

T010
Character
(9) Subsidiary EIN (a),part IX
Subsidiary EIN (a)

T020
Numeric
(9) % of ownership interest (a), p
Percentage of ownership interest (a)

T030
Numeric
(9) Total income (a),part IX
Total income (a)

T040
Numeric
(9) End of year assets (a), part I
End of year assets (a)

T110
Character
(9) Subsidiary EIN (b), part IX
Subsidiary EIN (b)

T120
Numeric
(9) % of ownership interest (b), p
Percentage of ownership interest (b)

T130
Numeric
(9) Total income (b),part IX
Total income (b)

T140
Numeric
(9) End of year assets (b),part IX
End of year assets (b)

T210
Character
(9) Subsidiary EIN (c), part IX
Subsidiary EIN ( c)

T220
Numeric
(9) % of ownership interest (c), p
Percentage of ownership interest ( c)

T230
Numeric
(9) Total income (c),part IX
Total income ( c)

T240
Numeric
(9) End of year assets (c), part
End of year assets ( c)

T310
Character
(9) Subsidiary EIN (d), part IX
Subsidiary EIN (d)

T320
Numeric
(9) % of ownership interest (d), p
Percentage of ownership interest (d)

T330
Numeric
(9) Total income (d), part IX
Total income (d)

T340
Numeric
(9) End of year assets (d), part I
End of year assets (d)

Schedule A, Part I: Compensation of Five Highest Paid Employees ...

S001
Numeric
(9) Compensation,part a, i(c)
Compensation (a)

S002
Numeric
(9) Cont to employee benefit plans
Contributions to employee benefit plans (a)

S003
Numeric
(9) Exp acct & other allowances, a
Expense account and other allowances (a)

S011
Numeric
(9) Compensation, a, part I(c)
Compensation (b)

S012
Numeric
(9) Cont to employee benefit plans
Contributions to employee benefit plans (b)

S013
Numeric
(9) Exp acct & other allowances, a
Expense account and other allowances (b)

S021
Numeric
(9) Compensation, form 990 a, part
Compensation ( c)

S022
Numeric
(9) Cont to employee benefit plans
Contributions to employee benefit plans ( c)

S023
Numeric
(9) Exp acct & other allowances, a
Expense account and other allowances ( c)

S031
Numeric
(9) Compensation, form 990 a, part
Compensation (d)

S032
Numeric
(9) Cont to employee benefit plans
Contributions to employee benefit plans (d)

S033
Numeric
(9) Exp acct & other allowances, a
Expense account and other allowances (d)

S041
Numeric
(9) Compensation, form 990 a, part
Compensation (e)

S042
Numeric
(9) Cont to employee benefit plans
Contributions to employee benefit plans (e)

S043
Numeric
(9) Exp acct & other allowances, a
Expense account and other allowances (e)

S050
Numeric
(9) # of oth employees pd >$30,000
Number of other employees paid > $30,000

Schedule A, Part III: Statement About Activities

S070
Numeric
(9) Exp pd for leg activities a, p
Expenses paid for legislative activities

Schedule A, Part IV: Status

S100
Character
(3) Schedule a, part IV status
Schedule A, Part IV reason for non-private foundation status

Schedule A, Part IV-A: Support Schedule

S200
Numeric
(3) Gifts, grants, & cont rec part
Gifts, grants, and contributions received - Column A

S205
Numeric
(3) Gifts, grants, & cont rec part
Gifts, grants, and contributions received - Column E

S210
Numeric
(3) Membership fees received part
Membership fees received - Column A

S215
Numeric
(3) Membership fees received part
Membership fees received - Column E

S220
Numeric
(3) Gross receipts part IV ln 17a
Gross receipts - Column A

S225
Numeric
(3) Gross receipts part IV ln 17e
Gross receipts - Column E

S230
Numeric
(3) Gross income part IV ln 18a
Gross income - Column A

S235
Numeric
(3) Gross income part IV ln 18e
Gross income - Column E

S240
Numeric
(3) N income-unrelated bus act par
Net income from unrelated business activities - Column A

S245
Numeric
(3) N income-unrelated bus act par
Net income from unrelated business activities - Column E

S250
Numeric
(3) Tax revenues part IV ln 20a
Tax revenues - Column A

S255
Numeric
(3) Tax revenues part IV ln 20e
Tax revenues - Column E

S260
Numeric
(3) Val serv furnishd by govt part
Value of services furnished by government - Column A

S265
Numeric
(3) Val serv furnishd by govt part
Value of services furnished by government - Column E

S270
Numeric
(3) Other income part IV ln 22a
Other income - Column A

S275
Numeric
(3) Other income part IV ln 22e
Other income - Column E

S280
Numeric
(3) Total part IV ln 23a
Total - Column A

S285
Numeric
(3) Total part IV ln 23e
Total - Column E

S290
Numeric
(3) Tot(ln23)minus grss rects
Total (line 23) minus gross receipts - Column A

S295
Numeric
(3) Tot(ln23)minus grss rects
Total (line 23) minus gross receipts - Column E

S300
Numeric
(3) 1% of line 24 part IV line 25
1% of line 24

Schedule A, Part VI-A: Lobbying Expenditures by Electing Public Charities

S510
Numeric
(3) Tot. Grassroots lbbyg exp.-all
Lobbying to influence public opinion

S520
Numeric
(3) Tot. Direct lbbyg exp.- all
Lobbying to influence legislative body

S530
Numeric
(3) Tot. Lbbyg exp. (gr & dir)-all
Total lobbying

S540
Numeric
(3) Other exempt purp. Exp.-all
Other exempt purpose expenditures

S550
Numeric
(3) Tot. Exempt purp exp. (lbbyg)
Total exempt purpose expenditures

S560
Numeric
(3) Max. Nontax. Lobbying amt �all
Lobbying nontaxable amount

S570
Numeric
(3) Grassrts nontax. Amt 25% ln 41
Grassroots nontaxable amount

S580
Numeric
(3) Subtract li42 from ln 36
Line 36 less line 42

S590
Numeric
(3) Li38-li41 (0 if ln 41>ln 38)-a
Line 38 less line 41

Internal Processing

EZ_IND
Character
(3) 990-EZ filing
Form 990-EZ Indicator (Y=EZ)
N No
Y Yes

DLN
Character
(25) Document Locator Number
Document locator number used by the IRS

SCPL
Character
(12) S.C./Cycle/Page/L.C.
S.C./Cycle/Page/L.C.

COND
Character
(12) Condition Code
Condition code
A Amended return
F Final return
G Group return
S Separate return

SAMP_CD
Character
(12) Sample Code
Sample code
11 501(c)(3) Private Foundation: Assets under $125,000
12 501(c)(3) Private Foundation: Assets $125,000 under $400,000
13 501(c)(3) Private Foundation: Assets $400,000 under $1,000,000
14 501(c)(3) Private Foundation: Assets $1,000,000 under $2,500,000
15 501(c)(3) Private Foundation: Assets $2,500,000 under $10,000,000
16 501(c)(3) Private Foundation: Assets $10,000,000 under $25,000,000
17 501(c)(3) Private Foundation: Assets $25,000,000 or more
21 Charitable Trust: Assets under $100,000
22 Charitable Trust: Assets $100,000 under $1,000,000
23 Charitable Trust: Assets $1,000,000 or more
31 501(c)(3) Public Charity: Assets under $500,000
32 501(c)(3) Public Charity: Assets $500,000 under $1,000,000
33 501(c)(3) Public Charity: Assets $1,000,000 under $2,500,000
34 501(c)(3) Public Charity: Assets $2,500,000 under $5,000,000
35 501(c)(3) Public Charity: Assets $5,000,000 under $10,000,000
36 501(c)(3) Public Charity: Assets $10,000,000 under $30,000,000
37 501(c)(3) Public Charity: Assets $30,000,000 or more
41 501(c)(4)-(9): Assets under $125,000
42 501(c)(4)-(9): Assets $125,000 under $400,000
43 501(c)(4)-(9): Assets $400,000 under $1,000,000
44 501(c)(4)-(9): Assets $1,000,000 under $2,500,000
45 501(c)(4)-(9): Assets $2,500,000 under $10,000,000
46 501(c)(4)-(9): Assets $10,000,000 or more

SAM_CNT
Numeric
(12) Sample Count
Sample count

PSR_CNT
Numeric
(12) Service Revenue Table Count
Service revenue table count

COMP_CNT
Numeric
(12) Compensation Table Count
Compensation table count

POP_CNT
Numeric
(12) Population Count
Population count

WEIGHT
Numeric
(12) Weight
Weight

Miscellaneous

RandNum
Character
(12) Random number between 0 and 1
Random number between 0 and 1 used for creating samples