DD Functional Expenses v2005b

Number of variables	141
Number of records	1388480

Field Name
Field Type

Description and Values

Basic Info

NCCSKEY
Character
(20)

Unique key: ein + return date
Unique key: ein + return date

EIN
Character
(9)

Employer Identification Number
Employer identification number.

FisYr
Character
(4)

Fiscal year
Fiscal year (ending year)

NAME
Character
(60)

Name of organization
Organization 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

zip5
Character
(5)

Zip code, 5 digits
First 5 digits of zip code

FIPS
Character
(5)

State + County FIPS code
2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts.

MSA_NECH
Character
(9)

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

PMSA
Character
(4)

Primary MSA
Primary Metropolitan Statistical Area - the component areas that comprise a CMSA (76 PMSAs as of 1995). (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

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

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

p1totexp
Numeric
(20)

Total Expenses
Total expenses

NUMBER
Numeric
(20)

Sort order
Sort by state and number to order record

Part II: Statement of Functional Expenses

p2tgrant
Numeric
(20)

Grants & allocations - col. A
Grants & allocations - col. A (total)

p2pgrant
Numeric
(20)

Grants and allocations- col. B
Grants and allocations- col. B (program services)

p2tasist
Numeric
(20)

Specific assistance to individ
Specific assistance to individuals- col. A (total)

p2pasist
Numeric
(20)

Specific assistance to individ
Specific assistance to individuals- col. B (program services)

p2tmemb
Numeric
(20)

Benefits paid to or for member
Benefits paid to or for members- col. A (total)

p2pmemb
Numeric
(20)

Benefits paid- col. B (program
Benefits paid- col. B (program services)

p2tcomp
Numeric
(20)

Compensation of officers-col.
Compensation of officers-col. A (total)

p2pcomp
Numeric
(20)

Compensation of officers-col.
Compensation of officers-col. B (program services)

p2mcomp
Numeric
(20)

Compensations of officers-col.
Compensations of officers-col. C (mgt. & general)

p2fcomp
Numeric
(20)

Compensation of officers-col.
Compensation of officers-col. D (fundraising)

p2fwages
Numeric
(20)

Other salaries & wages-col. D
Other salaries & wages-col. D (fundraising)

p2twages
Numeric
(20)

Other salaries & wages-col. A
Other salaries & wages-col. A (total)

p2pwages
Numeric
(20)

Other salaries & wages-col. B
Other salaries & wages-col. B (program services)

p2mwages
Numeric
(20)

Other salaries & wages-col. C
Other salaries & wages-col. C (mgt. & general)

p2fpensn
Numeric
(20)

Pension plan contributions-col
Pension plan contributions-col. D (fundraising)

p2mpensn
Numeric
(20)

Pension plan contributions-col
Pension plan contributions-col. C (mgt. & general)

p2tpensn
Numeric
(20)

Pension plan contributions-col
Pension plan contributions-col. A (total)

p2ppensn
Numeric
(20)

Pension plan contributions-col
Pension plan contributions-col. B (program services)

p2membft
Numeric
(20)

Other employee benefits-col. C
Other employee benefits-col. C (mgt. & general)

p2fembft
Numeric
(20)

Other employee benefits-col. D
Other employee benefits-col. D (fundraising)

p2tembft
Numeric
(20)

Other employee benefits-col. A
Other employee benefits-col. A (total)

P2TEMP
Numeric
(20)

Total employment expenses
Total employment expenses (calculated)

p2pembft
Numeric
(20)

Other employee benefits-col. B
Other employee benefits-col. B (program services)

p2fpytax
Numeric
(20)

Payroll taxes-col. D (fundrais
Payroll taxes-col. D (fundraising)

p2ppytax
Numeric
(20)

Payroll taxes-col. B (program
Payroll taxes-col. B (program services)

p2mpytax
Numeric
(20)

Payroll taxes-col. C (mgt. & g
Payroll taxes-col. C (mgt. & general)

p2tpytax
Numeric
(20)

Payroll taxes-col. A (total)
Payroll taxes-col. A (total)

p2mfrfee
Numeric
(20)

Professional fundraising fees-
Professional fundraising fees-col. C (mgt. & general)

p2ffrfee
Numeric
(20)

Professional fundraisng fees-c
Professional fundraisng fees-col.D

p2tfrfee
Numeric
(20)

Professional fundraising fees-
Professional fundraising fees-total (col.A)

p2pfrfee
Numeric
(20)

Professional fundraising fees-
Professional fundraising fees-col. B (program services)

p2macfee
Numeric
(20)

Accounting fees-col. C (mgt. &
Accounting fees-col. C (mgt. & general)

p2facfee
Numeric
(20)

Accounting fees-col. D (fundra
Accounting fees-col. D (fundraising)

P2TOCCEQ
Numeric
(20)

Total occupancy & equip. costs
Total occupancy & equipment costs

p2tacfee
Numeric
(20)

Accounting fees-col. A (total)
Accounting fees-col. A (total)

p2pacfee
Numeric
(20)

Accounting fees-col. B (progra
Accounting fees-col. B (program services)

p2flgfee
Numeric
(20)

Legal fees-col. C (fundraising
Legal fees-col. C (fundraising)

P2TPROF
Numeric
(20)

Total professional fees
Total professional fees (calculated)

p2tlgfee
Numeric
(20)

Legal fees-col. A (total)
Legal fees-col. A (total)

p2mlgfee
Numeric
(20)

Legal fees-col. C (mgt. & gene
Legal fees-col. C (mgt. & general)

p2plgfee
Numeric
(20)

Legal fees-col. B (program ser
Legal fees-col. B (program services)

p2fsup
Numeric
(20)

Supplies-col. D (fundraising)
Supplies-col. D (fundraising)

p2psup
Numeric
(20)

Supplies-col. B (program servi
Supplies-col. B (program services)

p2msup
Numeric
(20)

Supplies-col. C (mgt. & genera
Supplies-col. C (mgt. & general)

p2tsup
Numeric
(20)

Supplies-col. A (total)
Supplies-col. A (total)

p2mphone
Numeric
(20)

Telephone-col. C (mgt. & gener
Telephone-col. C (mgt. & general)

p2fphone
Numeric
(20)

Telephone-col. D (fundraising)
Telephone-col. D (fundraising)

p2tphone
Numeric
(20)

Telephone-col. A (total)
Telephone-col. A (total)

p2pphone
Numeric
(20)

Telephone-col. B (program serv
Telephone-col. B (program services)

p2fpostg
Numeric
(20)

Postage & shipping-col. D (fun
Postage & shipping-col. D (fundraising)

p2mpostg
Numeric
(20)

Postage & shipping-col. C (mgt
Postage & shipping-col. C (mgt. & general)

p2tpostg
Numeric
(20)

Postage & shipping-col. A (tot
Postage & shipping-col. A (total)

p2ppostg
Numeric
(20)

Postage & shipping-col. B (pro
Postage & shipping-col. B (program services)

p2moccup
Numeric
(20)

Occupancy-col. C (mgt. & gener
Occupancy-col. C (mgt. & general)

p2foccup
Numeric
(20)

Occupancy-col. D (fundraising)
Occupancy-col. D (fundraising)

p2toccup
Numeric
(20)

Occupancy-col. A (total)
Occupancy-col. A (total)

p2poccup
Numeric
(20)

Occupancy-col. B (program serv
Occupancy-col. B (program services)

p2mequip
Numeric
(20)

Equipment rental & exp.-col. C
Equipment rental & exp.-col. C (mgt. & general)

p2tequip
Numeric
(20)

Equipment rental & exp.-col. A
Equipment rental & exp.-col. A (total)

p2pequip
Numeric
(20)

Equipment rental & exp.-col. B
Equipment rental & exp.-col. B (program services)

p2fequip
Numeric
(20)

Equipment rental & exp.-col. D
Equipment rental & exp.-col. D (fundraising)

p2fprint
Numeric
(20)

Printing & publications-col. A
Printing & publications-col. A (fundraising)

p2mprint
Numeric
(20)

Printing & publications-col. C
Printing & publications-col. C (mgt. & general)

p2tprint
Numeric
(20)

Printing & publications-col. A
Printing & publications-col. A (total)

p2pprint
Numeric
(20)

Printing & publications-col. B
Printing & publications-col. B (program services)

p2ftravl
Numeric
(20)

Travel-col. D (fundraising)
Travel-col. D (fundraising)

p2ttravl
Numeric
(20)

Travel-col. A (total)
Travel-col. A (total)

p2ptravl
Numeric
(20)

Travel-col. B (program service
Travel-col. B (program services)

p2mtravl
Numeric
(20)

Travel-col. C (mgt. & general)
Travel-col. C (mgt. & general)

p2mmtgs
Numeric
(20)

Conferences, conventions & mee
Conferences, conventions & meetings-col. C (mgt. & general)

p2fmtgs
Numeric
(20)

Conferences, conventions & mee
Conferences, conventions & meetings-col. D (fundraising)

p2tmtgs
Numeric
(20)

Conferences, conventions & mee
Conferences, conventions & meetings-col. A (total)

p2pmtgs
Numeric
(20)

Conferences, conventions & mee
Conferences, conventions & meetings-col. B (program services)

p2mint
Numeric
(20)

Interest-col. C (mgt. & genera
Interest-col. C (mgt. & general)

p2fint
Numeric
(20)

Interest-col. D (fundraising)
Interest-col. D (fundraising)

p2pint
Numeric
(20)

Interest-col. B (program servi
Interest-col. B (program services)

p2tint
Numeric
(20)

Interest-col. A (total)
Interest-col. A (total)

p2mdeprc
Numeric
(20)

Depreciation, depletion, etc.-
Depreciation, depletion, etc.-col. C (mgt. & general)

p2fdeprc
Numeric
(20)

Depreciation, depletion, etc.-
Depreciation, depletion, etc.-col. D (fundraising)

p2tdeprc
Numeric
(20)

Depreciation, depletion, etc.-
Depreciation, depletion, etc.-col. A (total)

p2pdeprc
Numeric
(20)

Depreciation, depletion, etc.-
Depreciation, depletion, etc.-col. B (program services)

p2mOthc
Numeric
(20)

Other exp.- 43c, col. C, m&g
Other expenses- row 43c, col. C (mgt. & general)

p2mOthd
Numeric
(20)

Other exp.- 43d, col. C, m&g
Other expenses- row 43d, col. C (mgt. & general)

p2fOthE
Numeric
(20)

Other exp.- 43e, col. D,fundr.
Other expenses- row 43e, col. D (fundraising)

p2fOthd
Numeric
(20)

Other exp.- 43d, col. D,fundr.
Other expenses- row 43d, col. D (fundraising)

p2mOthE
Numeric
(20)

Other exp.- 43e, col. C, m&g
Other expenses- row 43e, col. C (mgt. & general)

p2fOthc
Numeric
(20)

Other exp.- 43c, col. D,fundr.
Other expenses- row 43c, col. D (fundraising)

p2fOthb
Numeric
(20)

Other exp.- 43b, col. D,fundr.
Other expenses- row 43b, col. D (fundraising)

p2fOtha
Numeric
(20)

Other exp.- 43a, col. D,fundr.
Other expenses- row 43a, col. D (fundraising)

p2mOtha
Numeric
(20)

Other exp.- 43a, col. C, m&g
Other expenses- row 43a, col. C (mgt. & general)

p2tOthe
Numeric
(20)

Other exp.- 43e, col. A ,tot.
Other expenses- row 43e, col. A (total)

p2tOthd
Numeric
(20)

Other exp.- 43d, col. A ,tot.
Other expenses- row 43d, col. A (total)

p2tOthc
Numeric
(20)

Other exp.- 43c, col. A ,tot.
Other expenses- row 43c, col. A (total)

p2tOthb
Numeric
(20)

Other exp.- 43b, col. A ,tot.
Other expenses- row 43b, col. A (total)

p2totha
Numeric
(20)

Other exp.- 43a, col. A ,tot.
Other expenses- row 43a, col. A (total)

p2pOthE
Numeric
(20)

Other exp.- 43e, col. B ,prog.
Other expenses- row 43e, col. B (program services)

p2pOthd
Numeric
(20)

Other exp.- 43d, col. B ,prog.
Other expenses- row 43d, col. B (program services)

p2pOthc
Numeric
(20)

Other exp.- 43c, col. B ,prog.
Other expenses- row 43c, col. B (program services)

p2pOthb
Numeric
(20)

Other exp.- 43b, col. B ,prog.
Other expenses- row 43b, col. B (program services)

p2potha
Numeric
(20)

Other exp.- 43a, col. B ,prog.
Other expenses- row 43a, col. B (program services)

p2mOthb
Numeric
(20)

Other exp.- 43b, col. C, m&g
Other expenses- row 43b, col. C (mgt. & general)

p2tTot
Numeric
(20)

Total functional expenses-col.
Total functional expenses-col. A (total)

p2pTot
Numeric
(20)

Total functional expenses-col.
Total functional expenses-col. B (program services)

p2fTot
Numeric
(20)

Total functional expenses-col.
Total functional expenses-col. (fundraising)

p2mTot
Numeric
(20)

Total functional expenses-col.
Total functional expenses-col. C (mgt. & general)

p2jt_tot
Numeric
(20)

Joint costs, total
Joint costs, total

p2jt_rpt
Character
(9)

Reporting of joint costs
Reporting of joint costs

p2jt_fr
Numeric
(9)

Joint costs allocated to fundr
Joint costs allocated to fundraising

p2jt_mgt
Numeric
(9)

Joint costs allocated to manag
Joint costs allocated to management & general

p2jt_prg
Numeric
(9)

Joint costs alloc to program s
Joint costs allocated to programs services

Other Classification

LEVEL1
Character
(9)

Public charity or priv. fndn?
Public charity or private foundation?

O	Other Nonprofits
PC	Public Charity
PF	Private Foundation
U	Unknown

LEVEL2
Character
(9)

Reporting public charity group
Reporting public charity groups.

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

level3
Character
(9)

Major NTEE category
Major NTEE category

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

level4
Character
(9)

NTEE-CC Major Group
NTEE-CC Major Group

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

Miscellaneous

Latest
Character
(1)

Most recent return
Is record the most recent one received from organization? (y)

Internal Processing

FIN_ID
Character
(1)

Unique org. ID
Unique organization ID

LAST_MOD
Character
(20)

Date last modif. 2
Date last modified (var 2)

GRREC_SM
Character
(2)

Gross receipts < $25k flag
Gross receipts < $25k flag (Y/N)

Internal Processing

SET_
Character
(20)

Source data set
Source data set

NCCSKEY2
Character
(14)

Unique key: ein + fiscal year
Unique key: ein + fiscal year

formtype
Character
(20)

990 or ez? (9/z)
990 or ez? (9/z)

Miscellaneous

RandNum
Numeric
(20)

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