DD Revenue and Expenses v2005b

Number of variables84
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
p1dirsup
Numeric
(20)
Direct public support
Direct public support
p1indsup
Numeric
(20)
Indirect public support
Indirect public support
p1govgt
Numeric
(20)
Government grants
Government grants
p1noncsh
Numeric
(20)
Noncash contributions
Noncash contributions
p1cash
Numeric
(20)
Cash contributions
Cash contributions
p1tcont
Numeric
(20)
Total contributions
Total contributions, gifts, grants, etc.
p1psrev
Numeric
(20)
Program service revenue
Program service revenue
p1dues
Numeric
(20)
Dues & assessments
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.)
p1int
Numeric
(20)
Interest
Interest
p1oinv
Numeric
(20)
Other investment income
Other investment income
p1div
Numeric
(20)
Dividends
Dividends
p1invst
Numeric
(20)
Total invest. inc. (990 lines
Total invest. inc. (990 lines 4+5+7 OR EZ line 4)
p1rentg
Numeric
(20)
Gross rents
Gross rents
p1rente
Numeric
(20)
Rental expenses
Rental expenses
p1assnet
Numeric
(20)
Total gain, sale of securities
Total gain, sale of securities & "other" assets
p1rentn
Numeric
(20)
Net rental income
Net rental income
p1invntG
Numeric
(20)
Inventory, gross sales
Inventory, gross sales
p1invntC
Numeric
(20)
Inventory, cost of goods sold
Inventory, cost of goods sold
p1invntN
Numeric
(20)
Inventory, gross profit (net)
Inventory, gross profit (net)
p1securg
Numeric
(20)
Gross amount from sale of asse
Gross amount from sale of assets (securities)
p1securC
Numeric
(20)
Cost or other basis (securitie
Cost or other basis (securities)
p1securN
Numeric
(20)
Gain (loss) from sale of secur
Gain (loss) from sale of securities
p1othg
Numeric
(20)
Gross amount from sale of asse
Gross amount from sale of assets (other)
p1othC
Numeric
(20)
Cost or other basis (other)
Cost or other basis (other)
p1othN
Numeric
(20)
Net gain (loss) from sale of "
Net gain (loss) from sale of "other" assets other than inventory
p1spEvC
Character
(20)
Special events - portion of gr
Special events - portion of gross reported in line 1a, contributions, & not reported in line 9
p1spevG
Numeric
(20)
Special event, gross revenue
Special event, gross revenue
p1spEvE
Numeric
(20)
Special events, direct expense
Special events, direct expenses
p1spEvN
Numeric
(20)
Special events, net income
Special events, net income
p1othrev
Numeric
(20)
Other revenue
Other revenue
p1totrev
Numeric
(20)
Total Revenue
Total revenue
p1frexp
Numeric
(20)
Fund-raising expenses
Fund-raising expenses
p1chgas
Numeric
(20)
Other changes in net assets or
Other changes in net assets or fund balances
p1affil
Numeric
(20)
Payments to affiliates
Payments to affiliates
GRREC
Numeric
(20)
Gross receipts, t.rev+6b+8bA&B
Gross receipts (Sum of lines 6b, 8b A, 8b B (Cost or other basis and sales expenses from sale of assets other than inventory or securities),9b,10b, and 12)
p1pExp
Numeric
(20)
Program service expenses
Program service expenses
p1mExp
Numeric
(20)
Management & general expenses
Management & general expenses
p1totexp
Numeric
(20)
Total Expenses
Total expenses
p1netInc
Numeric
(20)
Net income ("excess (or defici
Net income ("excess (or deficit) for the year")
p1nasboy
Numeric
(20)
Net assets or fund balance-beg
Net assets or fund balance-beg. of year
p1naseoy
Numeric
(20)
Net assets or fund balance-end
Net assets or fund balance-end of year
Part II: Statement of Functional Expenses
p2tmemb
Numeric
(20)
Benefits paid to or for member
Benefits paid to or for members- col. A (total)
Part IV: Balance Sheets
p4e_asst
Numeric
(20)
Total assets- end of year
Total assets- end of year
p4e_liab
Numeric
(20)
Total liabilities- end of year
Total liabilities- end of year
Other Classification
LEVEL1
Character
(20)
Public charity or priv. fndn?
Public charity or private foundation?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(20)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(20)
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
(20)
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
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)
Verification Flags
v1tcont1
Character
(20)
Tot. cont. verif. code
Verification of line items 1a,1b,1c sum to line ld
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1tcont2
Character
(20)
Tot. cont. cash verif. code
Verification of line 1,cash and non-cash
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1rentn
Character
(20)
Rent. inc. verif. code
Rental income verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1securN
Character
(20)
Sec. inc. verif. code
Securities income verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1othN
Character
(20)
Sales verif. code
Verification code for sales of assets other than inventory
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
Verification flags
v1spEvN
Character
(20)
Spc. event verif. code
Special Event income verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
Verification Flags
v1invntN
Character
(20)
Invst. inc. verif. code
Investment income verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1totexp
Character
(20)
Tot. exp. verif. code
Verification code for total expenses
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1netInc
Character
(20)
Net. inc. ver. code
Net income verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1naseoy
Character
(20)
Net. ass. ver. code
Net assets verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
v1totrev
Character
(20)
Tot. rev. verif. code
Total revenue verification code
Unknown
1Arithmetic check perfect
2Within $20
3Within 1%
4Within 5%
5Within 10%
6Within 25%
725% or more
8Both values are empty or zero
9One value is empty or zero
b25%+ & error >$1 million
n1 or 2 negative values
Miscellaneous
RandNum
Numeric
(20)
Random number between 0 and 1
Random number between 0 and 1 used for creating samples
ADD_ID
Numeric
(20)
Address ID
Address ID used in original files