DD Functional Expenses v2005b

Number of variables141
Number of records0

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
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
NTEECC
Character
(4)
NTEECC primary purpose
NTEECC classification
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
44- Not a 501(c)(3)
FF- Foreign organization
GG- Government Entity
II- Coded out of scope by Independent Sector
NN- Coded out of scope by NCCS (e.g. foreign address on Form 990)
SS- Missing geographic information
TT- U.S. Territory or armed forces overseas
Classification
ntmaj5
Character
(20)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(20)
NTEE major group (10)
10 NTEE major groups
ARArts, culture, and humanities
EDEducation
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
ntmaj12
Character
(20)
NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)
ARArts, culture, and humanities
BHEducation, higher
EDEducation
EHHospitals
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
MAJGRPB
Character
(20)
Major NTEE group
Major NTEE group plus hospitals and higher education
AA-Arts, Culture & Humanities
BB-Education
BHBH-Higher educ.
CC-Environment
DD-Animal Related
EE-Health - General
EHEH-Hospitals
FF-Mental Health
GG-Health - Disease Specific (general)
HH-Health - Disease Specific (research)
II-Crime, Legal Related
JJ-Employment, Job Related
KK-Food, Agriculture, Nutrition
LL-Housing, Shelter
MM-Public Safety, Disaster Preparedness
NN-Recreation and Sports
OO-Youth Development
PP-Human Services, Multipurpose and Other
QQ-International, Foreign Affairs
RR-Civil Rights/Advocacy
SS-Community Improvement
TT-Philanthropy, Voluntarism
UU-Science and Technology
VV-Social Science
WW-Public, Society Benefit
XX-Religion Related
YY-Mutual/Membership Benefit
ZZ-Unknown, Unclassified
Part 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)
p2mpensn
Numeric
(20)
Pension plan contributions-col
Pension plan contributions-col. C (mgt. & general)
p2fpensn
Numeric
(20)
Pension plan contributions-col
Pension plan contributions-col. D (fundraising)
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)
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)
p2tembft
Numeric
(20)
Other employee benefits-col. A
Other employee benefits-col. A (total)
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)
p2mlgfee
Numeric
(20)
Legal fees-col. C (mgt. & gene
Legal fees-col. C (mgt. & general)
P2TPROF
Numeric
(20)
Total professional fees
Total professional fees (calculated)
p2tlgfee
Numeric
(20)
Legal fees-col. A (total)
Legal fees-col. A (total)
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)
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)
p2mphone
Numeric
(20)
Telephone-col. C (mgt. & gener
Telephone-col. C (mgt. & general)
p2mpostg
Numeric
(20)
Postage & shipping-col. C (mgt
Postage & shipping-col. C (mgt. & general)
p2fpostg
Numeric
(20)
Postage & shipping-col. D (fun
Postage & shipping-col. D (fundraising)
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)
p2fequip
Numeric
(20)
Equipment rental & exp.-col. D
Equipment rental & exp.-col. D (fundraising)
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)
p2mprint
Numeric
(20)
Printing & publications-col. C
Printing & publications-col. C (mgt. & general)
p2fprint
Numeric
(20)
Printing & publications-col. A
Printing & publications-col. A (fundraising)
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)
p2tint
Numeric
(20)
Interest-col. A (total)
Interest-col. A (total)
p2pint
Numeric
(20)
Interest-col. B (program servi
Interest-col. B (program services)
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)
p2mOtha
Numeric
(20)
Other exp.- 43a, col. C, m&g
Other expenses- row 43a, col. C (mgt. & general)
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)
p2mOthE
Numeric
(20)
Other exp.- 43e, col. C, m&g
Other expenses- row 43e, 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)
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)
p2mOthb
Numeric
(20)
Other exp.- 43b, col. C, m&g
Other expenses- row 43b, 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)
p2fTot
Numeric
(20)
Total functional expenses-col.
Total functional expenses-col. (fundraising)
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)
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?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(9)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(9)
Major NTEE category
Major NTEE category
ARArts, culture and humanities
EDEducation
ENEnvironment/animals
HEHealth
HSHuman Services
INInternational, foreign affairs
MOOther mutual benefit
MRPension and retirement funds
PBPublic, societal benefit
REReligion related
UNUnknown, unclassified
ZASingle organization support
ZBFundraising within NTEE major group
ZCPrivate grantmaking foundations
ZDPublic foundations
ZEGeneral fundraising
ZFOther Supporting Public Benefit
level4
Character
(9)
NTEE-CC Major Group
NTEE-CC Major Group
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
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