DD Revenue and Expenses v2005b

Number of variables	84
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

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?

O	Other Nonprofits
PC	Public Charity
PF	Private Foundation
U	Unknown

LEVEL2
Character
(20)

Reporting public charity group
Reporting public charity groups.

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

level3
Character
(20)

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

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

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
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1tcont2
Character
(20)

Tot. cont. cash verif. code
Verification of line 1,cash and non-cash

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1rentn
Character
(20)

Rent. inc. verif. code
Rental income verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1securN
Character
(20)

Sec. inc. verif. code
Securities income verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1othN
Character
(20)

Sales verif. code
Verification code for sales of assets other than inventory

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

Verification flags

v1spEvN
Character
(20)

Spc. event verif. code
Special Event income verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

Verification Flags

v1invntN
Character
(20)

Invst. inc. verif. code
Investment income verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1totexp
Character
(20)

Tot. exp. verif. code
Verification code for total expenses

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1netInc
Character
(20)

Net. inc. ver. code
Net income verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1naseoy
Character
(20)

Net. ass. ver. code
Net assets verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 or 2 negative values

v1totrev
Character
(20)

Tot. rev. verif. code
Total revenue verification code

	Unknown
1	Arithmetic check perfect
2	Within $20
3	Within 1%
4	Within 5%
5	Within 10%
6	Within 25%
7	25% or more
8	Both values are empty or zero
9	One value is empty or zero
b	25%+ & error >$1 million
n	1 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