DD Balance Sheet v2005b

Number of variables	102
Number of records	1388480

Field Name
Field Type

Description and Values

Basic Info

EIN
Character
(9)

Employer Identification Number
Employer identification number.

NCCSKEY
Character
(20)

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

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

Part IV: Balance Sheets

p4b_cash
Numeric
(20)

Cash- beg. of year
Cash- beg. of year

p4e_cash
Numeric
(20)

Cash- end of year
Cash- end of year (Part 4, line 45_B)

p4b_save
Numeric
(20)

Savings- beg. of year
Savings- beg. of year

p4e_save
Numeric
(20)

Savings- end of year
Savings- end of year (Part 4, line 46_B)

p4g_arec
Numeric
(20)

Accounts receivable
Accounts receivable

p4d_arec
Numeric
(20)

Allowance for doubtful account
Allowance for doubtful accounts

p4b_arec
Numeric
(20)

Accounts receivable - doubtful
Accounts receivable - doubtful accts- beg. of year

p4e_arec
Numeric
(20)

Accounts receivable- end of ye
Accounts receivable- end of year (Part 4, line 47c_B)

p4b_prec
Numeric
(20)

Pledges receivable - doubtful
Pledges receivable - doubtful accts- beg. of year

p4d_prec
Numeric
(20)

Pledges receivable, allowance
Pledges receivable, allowance for doubtful accts

p4e_prec
Numeric
(20)

Pledges receivable- end of yea
Pledges receivable- end of year (Part 4, line 48c_B)

p4g_prec
Numeric
(20)

Pledges receivable, gross
Pledges receivable, gross

p4b_grec
Numeric
(20)

Grants receivable- beg. of yea
Grants receivable- beg. of year

p4e_grec
Numeric
(20)

Grants receivable- end of year
Grants receivable- end of year (Part 4, line 49_B)

p4b_irec
Numeric
(20)

Receivables from officers, dir
Receivables from officers, directors- beg. of year

p4e_irec
Numeric
(20)

Receivables due from offices,
Receivables due from offices, directors & trustees- end of year (Part 4, line 50_B)

p4b_lrec
Numeric
(20)

Other notes receivable less do
Other notes receivable less doubtful accts- beg. of year

p4d_lrec
Numeric
(20)

Allowance for doubtful account
Allowance for doubtful accounts

p4e_lrec
Numeric
(20)

Other notes & loans receivable
Other notes & loans receivable- end of year (Part 4, line 51c_B)

p4g_lrec
Numeric
(20)

Other notes & loans receivable
Other notes & loans receivable

P4B_INVT
Numeric
(20)

Inventories, beg. of yr.
Inventories for sale or use, beg. of year

P4E_INVT
Numeric
(20)

Inventories, end of yr.
Inventories for sale or use, end of year

p4b_pre
Numeric
(20)

Prepaid expenses & deferred ch
Prepaid expenses & deferred charges- beg. of year

p4e_pre
Numeric
(20)

Prepaid expenses- end of year
Prepaid expenses- end of year (Part 4, line 53_B)

p4b_sec
Numeric
(20)

Investments- securities- beg.
Investments- securities- beg. of year

p4e_sec
Numeric
(20)

Investments- securities- end o
Investments- securities- end of year (Part 4, line 54_B)

p4b_ilnd
Numeric
(20)

Investments- land, blg & eq mi
Investments- land, blg & eq minus accum. dep- beg. of year

p4d_ilnd
Numeric
(20)

Accumulated depreciation for l
Accumulated depreciation for land, blg & equip

p4e_ilnd
Numeric
(20)

Investments-land, buildings &
Investments-land, buildings & equipment minus accum. dep- end of year (Part 4, line 55c_B)

p4g_ilnd
Numeric
(20)

Investments- land, blg & equip
Investments- land, blg & equip: basis

p4b_iOth
Numeric
(20)

Investments- other- beg. of ye
Investments- other- beg. of year

p4e_iOth
Numeric
(20)

Investments-other- end of year
Investments-other- end of year (Part 4, line 56_B)

p4b_land
Numeric
(20)

Land, blg & equip - accum. dep
Land, blg & equip - accum. deprec.- beg. of year

p4d_land
Numeric
(20)

Accumulated depreciation of la
Accumulated depreciation of land, blg & equip

p4e_land
Numeric
(20)

Land, building & equip. minus
Land, building & equip. minus accum. deprec.- end of year (Part 4, line 57c_B)

p4g_land
Numeric
(20)

land, blg, equip: basis
land, blg, equip: basis

p4b_asst
Numeric
(20)

Total assets- beg. of year
Total assets- beg. of year

p4b_oAst
Numeric
(20)

Other assets- beg. of year
Other assets- beg. of year

p4e_asst
Numeric
(20)

Total assets- end of year
Total assets- end of year (Part 4, line 59_B)

p4e_oAst
Numeric
(20)

Other assets- end of year
Other assets- end of year (Part 4, line 58_B)

p4b_apay
Numeric
(20)

Accounts payable & accrued exp
Accounts payable & accrued expenses- beg. of year

p4e_apay
Numeric
(20)

Accounts payable- end of year
Accounts payable- end of year (Part 4, line 60_B)

p4b_gpay
Numeric
(20)

Grants payable- beg. of year
Grants payable- beg. of year

p4e_gpay
Numeric
(20)

Grants payable- end of year
Grants payable- end of year (Part 4, line 61_B)

p4b_defr
Numeric
(20)

Deferred revenue- beg. of year
Deferred revenue- beg. of year

p4e_defr
Numeric
(20)

Revenue designated for future
Revenue designated for future periods- end of year (Part 4, line 62_B)

p4b_lpay
Numeric
(20)

Loans from officers, directors
Loans from officers, directors,- beg. of year

p4e_lpay
Numeric
(20)

Loans from officers, directors
Loans from officers, directors & trustees- end of year (Part 4, line 63_B)

p4b_bond
Numeric
(20)

Tax-exempt bond liabilities- b
Tax-exempt bond liabilities- beg. of year

p4e_bond
Numeric
(20)

Tax-exempt bond liabilities- e
Tax-exempt bond liabilities- end of year (Part 4, line 64a_B)

p4b_mort
Numeric
(20)

Mortgages & other notes payabl
Mortgages & other notes payable- beg. of year

p4e_mort
Numeric
(20)

Mortgages & other notes payabl
Mortgages & other notes payable- end of year (Part 4, line 64b_B)

p4b_oLia
Numeric
(20)

Other liabilities- beg. of yea
Other liabilities- beg. of year

p4e_oLia
Numeric
(20)

Other liabilities- end of year
Other liabilities- end of year (Part 4, line 65_B)

p4b_liab
Numeric
(20)

Total liabilities- beg. of yea
Total liabilities- beg. of year

p4e_liab
Numeric
(20)

Total liabilities- end of year
Total liabilities- end of year (Part 4, line 66_B)

p4b_unre
Numeric
(20)

Unrestricted net assets or fun
Unrestricted net assets or fund balances- beg.of year

p4e_unre
Numeric
(20)

Unrestricted net assets or fun
Unrestricted net assets or fund balances- end of year (Part 4, line 67_B)

p4b_temp
Numeric
(20)

Temporarily restricted net ass
Temporarily restricted net asset- beg. of year

p4e_temp
Numeric
(20)

Temporarily restricted net ass
Temporarily restricted net assets- end of year (Part 4, line 68_B)

p4b_perm
Numeric
(20)

Permanently restricted net ass
Permanently restricted net assets- beg. of year

p4e_perm
Numeric
(20)

Permanently restricted net ass
Permanently restricted net assets- end of year (Part 4, line 69_B)

p4b_cap
Numeric
(20)

Capital stock, trust prncipl,
Capital stock, trust prncipl, or curnt fnds-beg. of year

p4e_cap
Numeric
(20)

Capital stock, trust prncipl,
Capital stock, trust prncipl, or curnt fnds-end of year (Part 4, line 70_B)

p4b_surp
Numeric
(20)

Paid-in or capital splus, or l
Paid-in or capital splus, or ld, blg & e fd- beg. of year

p4e_surp
Numeric
(20)

Paid-in or capital splus, or l
Paid-in or capital splus, or ld, blg & e fd- end of year (Part 4, line 71_B)

p4b_retn
Numeric
(20)

Retained earns, endowmts, accu
Retained earns, endowmts, accum. Income- beg. of year

p4e_retn
Numeric
(20)

Retained earns, endowmts, accu
Retained earns, endowmts, accum. Income- end of year (Part 4, line 72_B)

p4b_net
Numeric
(20)

Total fund balances or net wor
Total fund balances or net worth- beg. of year

p4e_net
Numeric
(20)

Total fund balances or net wor
Total fund balances or net worth- end of year (Part 4, line 73_B)

p4b_lint
Numeric
(20)

Total liabilities & net assets
Total liabilities & net assets/fund balances- beg. of year

p4e_lint
Numeric
(20)

Total liabilities & net assets
Total liabilities & net assets/fund balances- end of year (Part 4, line 74_B)

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

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

formtype
Character
(20)

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

NCCSKEY2
Character
(14)

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

Miscellaneous

RandNum
Numeric
(14)

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